Notes

CREATE OR REPLACE PACKAGE AMAN_API.prepare_data
IS
TYPE p_prepare_data_type IS RECORD
(
p_cust_nationality NUMBER,
p_account_no NUMBER,
p_cust_no NUMBER,
p_cust_age NUMBER,
p_cover_type NUMBER,
p_cover_tot_amount NUMBER,
p_geo_tot_amount NUMBER,
p_discount_tot_amount NUMBER,
p_loading_tot_amount NUMBER,
p_tot_add_prem NUMBER,
p_veh_net_prem NUMBER,
p_vehicle_make NUMBER,
p_vehicle_model NUMBER,
p_type_of_body NUMBER,
p_address_city_desc VARCHAR2 (256),
p_rneibhood_code NUMBER,
p_wneibhood_code NUMBER,
p_full_address VARCHAR2 (1000),
p_iban_no VARCHAR2 (256),
p_bank_id NUMBER,
p_occupation NUMBER,
p_veh_registration_no VARCHAR2 (256),
p_r_city_code NUMBER,
p_r_district_code NUMBER,
p_education_no NUMBER,
p_marital_status NUMBER,
p_medical_status NUMBER,
p_reg_place NUMBER,
p_drvr_full_address VARCHAR2 (256),
p_driver_age NUMBER,
p_is_pol_holder NUMBER,
p_drvr_nationality NUMBER,
p_w_city_code NUMBER,
p_postal_city_code NUMBER,
p_drvr_r_city NUMBER,
p_drvr_r_district NUMBER,
p_drvr_off_city NUMBER,
p_drvr_off_district NUMBER,
p_drvr_r_neibhood NUMBER,
p_license_isue_pace NUMBER,
p_color NUMBER,
p_class_of_use NUMBER,
p_drvr_education_no NUMBER,
p_drvr_marital_status NUMBER,
p_drvr_medical_status NUMBER,
p_drvr_relation NUMBER,
p_drvr_occupation NUMBER,
p_najm_server NUMBER,
p_broker_Comm_Amt NUMBER, -- BALQIS
p_vat_comm_pcnt NUMBER,
p_vat_comm_amt NUMBER
);

p_err_msg VARCHAR2 (1000);
p_all_err_msg VARCHAR2 (4000);
p_tokens api_message_tokens;

p_prepare_data_rec p_prepare_data_type;
p_calc_level VARCHAR2 (256);

--p_calc_level will be filled in the code that will be calling the preparing package in it to determine calculations level such as(veh,drvr,..)

PROCEDURE prepare_motor_main_data;

PROCEDURE prepare_client_data;

PROCEDURE prepare_motor_veh_data;

PROCEDURE prepare_motor_driver_data;

PROCEDURE prepare_motor_veh_det_data;

PROCEDURE iban_processing (p_iban_no IN OUT VARCHAR2,
p_bank_no OUT NUMBER);

PROCEDURE motor_calculations;

FUNCTION mapping_data (p_service NUMBER,
p_map_data NUMBER,
p_num_val NUMBER,
p_char_val VARCHAR2,
p_val_desc VARCHAR2,
p_veh_make NUMBER DEFAULT NULL)
RETURN NUMBER;

PROCEDURE prepare_najm_request;

FUNCTION chk_category_setup (p_najm_aman_office NUMBER,
p_client_no NUMBER)
RETURN NUMBER;

FUNCTION get_service_map_data (p_elm_najm NUMBER, --1 elm 2 najm
p_data_map NUMBER, --1 elm vehicle color 2 elm vehicle make 3 elm vehicle body type 4 najm city 5 najm vehicle make 6 najm cause of accident 7 najm model 8 najm damage parts
p_service_desc VARCHAR2,
p_make_code number DEFAULT NULL)
RETURN NUMBER;

FUNCTION get_service_map_data_code (p_elm_najm NUMBER, --1 elm 2 najm
p_data_map NUMBER, --1 elm vehicle color 2 elm vehicle make 3 elm vehicle body type 4 najm city 5 najm vehicle make 6 najm cause of accident 7 najm model 8 najm damage parts
p_service_code NUMBER,
p_make_code NUMBER DEFAULT NULL)
RETURN NUMBER;
END;
/