大型项目Oracle sql，function，procedures，package,cursor,job

CREATE OR REPLACE PACKAGE BODY pdf_util_package IS /** 功能：记录式数据转换入关联数组接口客户资料 参数：p_assoc_array 关联数组 p_client_info_record 对象记录，可为null，对应的属性定义经转换后形如：client_info__polno。 说明：转换时依次将对象属性压入p_assoc_array中，即使其值为null,但如p_assoc_array参数与p_pol_info_record有重复， 覆盖之。 **/ PROCEDURE transform_record_to_arr(p_assoc_array IN OUT NOCOPY pdf_package.assoc_array, p_client_info_record IN client_info%ROWTYPE) IS BEGIN p_assoc_array('client_info__clientno') := sys.anydata.convertvarchar2(p_client_info_record.clientno); p_assoc_array('client_info__client_name') := sys.anydata.convertvarchar2(p_client_info_record.client_name); p_assoc_array('client_info__birth_date') := sys.anydata.convertdate(p_client_info_record.birth_date); p_assoc_array('client_info__sex') := sys.anydata.convertvarchar2(p_client_info_record.sex); p_assoc_array('client_info__id_type') := sys.anydata.convertvarchar2(p_client_info_record.id_type); p_assoc_array('client_info__idno') := sys.anydata.convertvarchar2(p_client_info_record.idno); p_assoc_array('client_info__work_unit') := sys.anydata.convertvarchar2(p_client_info_record.work_unit); p_assoc_array('client_info__prof_code') := sys.anydata.convertvarchar2(p_client_info_record.prof_code); p_assoc_array('client_info__mari_sts') := sys.anydata.convertvarchar2(p_client_info_record.mari_sts); --p_assoc_array('client_info__home_addr') := sys.anydata.convertvarchar2(p_client_info_record.home_addr); p_assoc_array('client_info__home_postcode') := sys.anydata.convertvarchar2(p_client_info_record.home_postcode); --p_assoc_array('client_info__conta_addr') := sys.anydata.convertvarchar2(p_client_info_record.conta_addr); p_assoc_array('client_info__conta_postcode') := sys.anydata.convertvarchar2(p_client_info_record.conta_postcode); --p_assoc_array('client_info__conta_tel') := sys.anydata.convertvarchar2(p_client_info_record.conta_tel); p_assoc_array('client_info__death_date') := sys.anydata.convertdate(p_client_info_record.death_date); --p_assoc_array('client_info__birth_place') := sys.anydata.convertvarchar2(p_client_info_record.birth_place); p_assoc_array('client_info__client_attr') := sys.anydata.convertvarchar2(p_client_info_record.client_attr); --p_assoc_array('client_info__lcd') := sys.anydata.convertdate(p_client_info_record.lcd); --p_assoc_array('client_info__lcu') := sys.anydata.convertvarchar2(p_client_info_record.lcu); p_assoc_array('client_info__region_code') := sys.anydata.convertvarchar2(p_client_info_record.region_code); --p_assoc_array('client_info__prof_desc') := sys.anydata.convertvarchar2(p_client_info_record.prof_desc); --p_assoc_array('client_info__education') := sys.anydata.convertvarchar2(p_client_info_record.education); --p_assoc_array('client_info__cell_phone') := sys.anydata.convertvarchar2(p_client_info_record.cell_phone); --p_assoc_array('client_info__e_mail') := sys.anydata.convertvarchar2(p_client_info_record.e_mail); -- p_assoc_array('client_info__country') := sys.anydata.convertvarchar2(p_client_info_record.country); --p_assoc_array('client_info__register_place') := sys.anydata.convertvarchar2(p_client_info_record.register_place); --p_assoc_array('client_info__home_tel') := sys.anydata.convertvarchar2(p_client_info_record.home_tel); --p_assoc_array('client_info__position') := sys.anydata.convertvarchar2(p_client_info_record.position); p_assoc_array('client_info__party_no') := sys.anydata.convertvarchar2(p_client_info_record.party_no); p_assoc_array('client_info__is_vip') := sys.anydata.convertvarchar2(p_client_info_record.is_vip); p_assoc_array('client_info__phoneticize_lastname') := sys.anydata.convertvarchar2(p_client_info_record.phoneticize_lastname); p_assoc_array('client_info__phoneticize_firstname') := sys.anydata.convertvarchar2(p_client_info_record.phoneticize_firstname); p_assoc_array('client_info__privacy_level') := sys.anydata.convertvarchar2(p_client_info_record.privacy_level); --p_assoc_array('client_info__fcd') := sys.anydata.convertdate(p_client_info_record.fcd); --p_assoc_array('client_info__fcu') := sys.anydata.convertvarchar2(p_client_info_record.fcu); p_assoc_array('client_info__idno_validity_date') := sys.anydata.convertdate(p_client_info_record.idno_validity_date); END; -- webapp-generator-insert-location -- /** 功能：记录式数据转换入关联数组接口保单交费资料 参数：p_assoc_array 关联数组 p_prem_info_record 对象记录，可为null，对应的属性定义经转换后形如：prem_info__polno。 说明：转换时依次将对象属性压入p_assoc_array中，即使其值为null,但如p_assoc_array参数与p_pol_info_record有重复， 覆盖之。 **/ PROCEDURE transform_record_to_arr(p_assoc_array IN OUT NOCOPY pdf_package.assoc_array, p_prem_info_record IN prem_info%ROWTYPE) IS BEGIN p_assoc_array('prem_info__deptno') := sys.anydata.convertvarchar2(p_prem_info_record.deptno); p_assoc_array('prem_info__polno') := sys.anydata.convertvarchar2(p_prem_info_record.polno); p_assoc_array('prem_info__brno') := sys.anydata.convertnumber(p_prem_info_record.brno); p_assoc_array('prem_info__plan_code') := sys.anydata.convertvarchar2(p_prem_info_record.plan_code); p_assoc_array('prem_info__period') := sys.anydata.convertnumber(p_prem_info_record.period); p_assoc_array('prem_info__prem_term') := sys.anydata.convertnumber(p_prem_info_record.prem_term); p_assoc_array('prem_info__std_modal_prem') := sys.anydata.convertnumber(p_prem_info_record.std_modal_prem); p_assoc_array('prem_info__substd_prem') := sys.anydata.convertnumber(p_prem_info_record.substd_prem); p_assoc_array('prem_info__prof_prem') := sys.anydata.convertnumber(p_prem_info_record.prof_prem); p_assoc_array('prem_info__tot_modal_prem') := sys.anydata.convertnumber(p_prem_info_record.tot_modal_prem); p_assoc_array('prem_info__prem_times') := sys.anydata.convertnumber(p_prem_info_record.prem_times); p_assoc_array('prem_info__pol_yr') := sys.anydata.convertnumber(p_prem_info_record.pol_yr); p_assoc_array('prem_info__app_type') := sys.anydata.convertvarchar2(p_prem_info_record.app_type); p_assoc_array('prem_info__prem_type') := sys.anydata.convertvarchar2(p_prem_info_record.prem_type); p_assoc_array('prem_info__pay_mode') := sys.anydata.convertvarchar2(p_prem_info_record.pay_mode); p_assoc_array('prem_info__col_mode') := sys.anydata.convertvarchar2(p_prem_info_record.col_mode); p_assoc_array('prem_info__agentno') := sys.anydata.convertvarchar2(p_prem_info_record.agentno); p_assoc_array('prem_info__colno') := sys.anydata.convertvarchar2(p_prem_info_record.colno); p_assoc_array('prem_info__amt_type') := sys.anydata.convertvarchar2(p_prem_info_record.amt_type); p_assoc_array('prem_info__pay_to_date') := sys.anydata.convertdate(p_prem_info_record.pay_to_date); p_assoc_array('prem_info__payment_date') := sys.anydata.convertdate(p_prem_info_record.payment_date); p_assoc_array('prem_info__comm_date') := sys.anydata.convertdate(p_prem_info_record.comm_date); p_assoc_array('prem_info__comm_rate') := sys.anydata.convertnumber(p_prem_info_record.comm_rate); p_assoc_array('prem_info__j_date') := sys.anydata.convertdate(p_prem_info_record.j_date); p_assoc_array('prem_info__jno') := sys.anydata.convertvarchar2(p_prem_info_record.jno); p_assoc_array('prem_info__rcptno') := sys.anydata.convertvarchar2(p_prem_info_record.rcptno); p_assoc_array('prem_info__proc_tag') := sys.anydata.convertvarchar2(p_prem_info_record.proc_tag); p_assoc_array('prem_info__region_code') := sys.anydata.convertvarchar2(p_prem_i