184:
185: begin
186: hr_utility.trace('In get_asg_xml');
187:
188: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
189:
190: open c_get_params;
191: fetch c_get_params into
192: l_aa_id,
935:
936: begin
937:
938: l_single_xml :=
939: '
941: pay_ca_t4_mag.convert_2_xml(p_employee_name, 'snm','T','','Y')||
942: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
943: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
936: begin
937:
938: l_single_xml :=
939: '
940: '
942: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
943: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
944: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
938: l_single_xml :=
939: '
940: '
941: pay_ca_t4_mag.convert_2_xml(p_employee_name, 'snm','T','','Y')||
942: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
943: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
944: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
945: pay_ca_t4_mag.convert_2_xml(p_employee_init, 'init','T','','Y')||
946: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
940: '
941: pay_ca_t4_mag.convert_2_xml(p_employee_name, 'snm','T','','Y')||
942: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
943: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
944: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
945: pay_ca_t4_mag.convert_2_xml(p_employee_init, 'init','T','','Y')||
946: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
947: pay_ca_t4_mag.convert_2_xml(p_employee_addr, 'empe_addr','T','','Y')||
948: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
942: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
943: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
944: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
945: pay_ca_t4_mag.convert_2_xml(p_employee_init, 'init','T','','Y')||
946: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
947: pay_ca_t4_mag.convert_2_xml(p_employee_addr, 'empe_addr','T','','Y')||
948: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
949: pay_ca_t4_mag.convert_2_xml(p_employer_name, 'empr_nm','T','','Y')||
950: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
944: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
945: pay_ca_t4_mag.convert_2_xml(p_employee_init, 'init','T','','Y')||
946: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
947: pay_ca_t4_mag.convert_2_xml(p_employee_addr, 'empe_addr','T','','Y')||
948: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
949: pay_ca_t4_mag.convert_2_xml(p_employer_name, 'empr_nm','T','','Y')||
950: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
951: pay_ca_t4_mag.convert_2_xml(p_employer_addr, 'empr_addr','T','','Y')||
952: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
946: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
947: pay_ca_t4_mag.convert_2_xml(p_employee_addr, 'empe_addr','T','','Y')||
948: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
949: pay_ca_t4_mag.convert_2_xml(p_employer_name, 'empr_nm','T','','Y')||
950: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
951: pay_ca_t4_mag.convert_2_xml(p_employer_addr, 'empr_addr','T','','Y')||
952: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
953: pay_ca_t4_mag.convert_2_xml(p_gre_name, 'gre','T','','Y')||
954: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
948: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
949: pay_ca_t4_mag.convert_2_xml(p_employer_name, 'empr_nm','T','','Y')||
950: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
951: pay_ca_t4_mag.convert_2_xml(p_employer_addr, 'empr_addr','T','','Y')||
952: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
953: pay_ca_t4_mag.convert_2_xml(p_gre_name, 'gre','T','','Y')||
954: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
955: pay_ca_t4_mag.convert_2_xml(p_employer_bn, 'bn','T','','Y')||
956: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
950: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
951: pay_ca_t4_mag.convert_2_xml(p_employer_addr, 'empr_addr','T','','Y')||
952: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
953: pay_ca_t4_mag.convert_2_xml(p_gre_name, 'gre','T','','Y')||
954: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
955: pay_ca_t4_mag.convert_2_xml(p_employer_bn, 'bn','T','','Y')||
956: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
957: pay_ca_t4_mag.convert_2_xml(p_sin, 'sin','T','','Y')||
958: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
952: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
953: pay_ca_t4_mag.convert_2_xml(p_gre_name, 'gre','T','','Y')||
954: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
955: pay_ca_t4_mag.convert_2_xml(p_employer_bn, 'bn','T','','Y')||
956: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
957: pay_ca_t4_mag.convert_2_xml(p_sin, 'sin','T','','Y')||
958: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
959: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_exempt, 'cpp_qpp_xmpt_cd','T','','Y')||
960: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
954: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
955: pay_ca_t4_mag.convert_2_xml(p_employer_bn, 'bn','T','','Y')||
956: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
957: pay_ca_t4_mag.convert_2_xml(p_sin, 'sin','T','','Y')||
958: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
959: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_exempt, 'cpp_qpp_xmpt_cd','T','','Y')||
960: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
961: pay_ca_t4_mag.convert_2_xml(p_ppip_exempt, 'ppip_xmpt_cd','T','','Y')||
962: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
956: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
957: pay_ca_t4_mag.convert_2_xml(p_sin, 'sin','T','','Y')||
958: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
959: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_exempt, 'cpp_qpp_xmpt_cd','T','','Y')||
960: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
961: pay_ca_t4_mag.convert_2_xml(p_ppip_exempt, 'ppip_xmpt_cd','T','','Y')||
962: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
963: pay_ca_t4_mag.convert_2_xml(p_ei_exempt, 'ei_xmpt_cd','T','','Y')||
964: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
958: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
959: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_exempt, 'cpp_qpp_xmpt_cd','T','','Y')||
960: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
961: pay_ca_t4_mag.convert_2_xml(p_ppip_exempt, 'ppip_xmpt_cd','T','','Y')||
962: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
963: pay_ca_t4_mag.convert_2_xml(p_ei_exempt, 'ei_xmpt_cd','T','','Y')||
964: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
965: pay_ca_t4_mag.convert_2_xml(p_year, 'tx_yr','T','','Y')||
966: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
960: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
961: pay_ca_t4_mag.convert_2_xml(p_ppip_exempt, 'ppip_xmpt_cd','T','','Y')||
962: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
963: pay_ca_t4_mag.convert_2_xml(p_ei_exempt, 'ei_xmpt_cd','T','','Y')||
964: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
965: pay_ca_t4_mag.convert_2_xml(p_year, 'tx_yr','T','','Y')||
966: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
967: pay_ca_t4_mag.convert_2_xml(p_employment_prov, 'empt_prov_cd','T','','Y')||
968: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
962: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
963: pay_ca_t4_mag.convert_2_xml(p_ei_exempt, 'ei_xmpt_cd','T','','Y')||
964: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
965: pay_ca_t4_mag.convert_2_xml(p_year, 'tx_yr','T','','Y')||
966: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
967: pay_ca_t4_mag.convert_2_xml(p_employment_prov, 'empt_prov_cd','T','','Y')||
968: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
969: pay_ca_t4_mag.convert_2_xml(p_employment_code, 'empt_cd','T','','Y')||
970: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
964: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
965: pay_ca_t4_mag.convert_2_xml(p_year, 'tx_yr','T','','Y')||
966: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
967: pay_ca_t4_mag.convert_2_xml(p_employment_prov, 'empt_prov_cd','T','','Y')||
968: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
969: pay_ca_t4_mag.convert_2_xml(p_employment_code, 'empt_cd','T','','Y')||
970: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
971: pay_ca_t4_mag.convert_2_xml(p_employment_income, 'empt_incamt','T','','Y')||
972: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
966: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
967: pay_ca_t4_mag.convert_2_xml(p_employment_prov, 'empt_prov_cd','T','','Y')||
968: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
969: pay_ca_t4_mag.convert_2_xml(p_employment_code, 'empt_cd','T','','Y')||
970: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
971: pay_ca_t4_mag.convert_2_xml(p_employment_income, 'empt_incamt','T','','Y')||
972: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
973: pay_ca_t4_mag.convert_2_xml(p_registration_number, 'rpp_dpsp_rgst_nbr','T','','Y')||
974: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
968: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
969: pay_ca_t4_mag.convert_2_xml(p_employment_code, 'empt_cd','T','','Y')||
970: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
971: pay_ca_t4_mag.convert_2_xml(p_employment_income, 'empt_incamt','T','','Y')||
972: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
973: pay_ca_t4_mag.convert_2_xml(p_registration_number, 'rpp_dpsp_rgst_nbr','T','','Y')||
974: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
975: pay_ca_t4_mag.convert_2_xml(p_cpp_contributions, 'cpp_cntrb_amt','T','','Y')||
976: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
970: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
971: pay_ca_t4_mag.convert_2_xml(p_employment_income, 'empt_incamt','T','','Y')||
972: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
973: pay_ca_t4_mag.convert_2_xml(p_registration_number, 'rpp_dpsp_rgst_nbr','T','','Y')||
974: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
975: pay_ca_t4_mag.convert_2_xml(p_cpp_contributions, 'cpp_cntrb_amt','T','','Y')||
976: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
977: pay_ca_t4_mag.convert_2_xml(p_qpp_contributions, 'qpp_cntrb_amt','T','','Y')||
978: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
972: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
973: pay_ca_t4_mag.convert_2_xml(p_registration_number, 'rpp_dpsp_rgst_nbr','T','','Y')||
974: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
975: pay_ca_t4_mag.convert_2_xml(p_cpp_contributions, 'cpp_cntrb_amt','T','','Y')||
976: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
977: pay_ca_t4_mag.convert_2_xml(p_qpp_contributions, 'qpp_cntrb_amt','T','','Y')||
978: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
979: pay_ca_t4_mag.convert_2_xml(p_ei_contributions, 'empe_eip_amt','T','','Y')||
980: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
974: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
975: pay_ca_t4_mag.convert_2_xml(p_cpp_contributions, 'cpp_cntrb_amt','T','','Y')||
976: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
977: pay_ca_t4_mag.convert_2_xml(p_qpp_contributions, 'qpp_cntrb_amt','T','','Y')||
978: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
979: pay_ca_t4_mag.convert_2_xml(p_ei_contributions, 'empe_eip_amt','T','','Y')||
980: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
981: pay_ca_t4_mag.convert_2_xml(p_rpp_contributions, 'rpp_cntrb_amt','T','','Y')||
982: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
976: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
977: pay_ca_t4_mag.convert_2_xml(p_qpp_contributions, 'qpp_cntrb_amt','T','','Y')||
978: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
979: pay_ca_t4_mag.convert_2_xml(p_ei_contributions, 'empe_eip_amt','T','','Y')||
980: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
981: pay_ca_t4_mag.convert_2_xml(p_rpp_contributions, 'rpp_cntrb_amt','T','','Y')||
982: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
983: pay_ca_t4_mag.convert_2_xml(p_pension_adjustment, 'padj_amt','T','','Y')||
984: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
978: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
979: pay_ca_t4_mag.convert_2_xml(p_ei_contributions, 'empe_eip_amt','T','','Y')||
980: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
981: pay_ca_t4_mag.convert_2_xml(p_rpp_contributions, 'rpp_cntrb_amt','T','','Y')||
982: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
983: pay_ca_t4_mag.convert_2_xml(p_pension_adjustment, 'padj_amt','T','','Y')||
984: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
985: pay_ca_t4_mag.convert_2_xml(p_tax_deducted, 'itx_ddct_amt','T','','Y')||
986: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
980: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
981: pay_ca_t4_mag.convert_2_xml(p_rpp_contributions, 'rpp_cntrb_amt','T','','Y')||
982: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
983: pay_ca_t4_mag.convert_2_xml(p_pension_adjustment, 'padj_amt','T','','Y')||
984: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
985: pay_ca_t4_mag.convert_2_xml(p_tax_deducted, 'itx_ddct_amt','T','','Y')||
986: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
987: pay_ca_t4_mag.convert_2_xml(p_ei_earnings, 'ei_insu_ern_amt','T','','Y')||
988: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
982: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
983: pay_ca_t4_mag.convert_2_xml(p_pension_adjustment, 'padj_amt','T','','Y')||
984: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
985: pay_ca_t4_mag.convert_2_xml(p_tax_deducted, 'itx_ddct_amt','T','','Y')||
986: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
987: pay_ca_t4_mag.convert_2_xml(p_ei_earnings, 'ei_insu_ern_amt','T','','Y')||
988: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
989: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_earnings, 'cpp_qpp_ern_amt','T','','Y')||
990: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
984: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
985: pay_ca_t4_mag.convert_2_xml(p_tax_deducted, 'itx_ddct_amt','T','','Y')||
986: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
987: pay_ca_t4_mag.convert_2_xml(p_ei_earnings, 'ei_insu_ern_amt','T','','Y')||
988: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
989: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_earnings, 'cpp_qpp_ern_amt','T','','Y')||
990: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
991: pay_ca_t4_mag.convert_2_xml(p_union_dues, 'unn_dues_amt','T','','Y')||
992: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
986: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
987: pay_ca_t4_mag.convert_2_xml(p_ei_earnings, 'ei_insu_ern_amt','T','','Y')||
988: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
989: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_earnings, 'cpp_qpp_ern_amt','T','','Y')||
990: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
991: pay_ca_t4_mag.convert_2_xml(p_union_dues, 'unn_dues_amt','T','','Y')||
992: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
993: pay_ca_t4_mag.convert_2_xml(p_charitable_donations, 'chrty_dons_amt','T','','Y')||
994: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
988: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
989: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_earnings, 'cpp_qpp_ern_amt','T','','Y')||
990: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
991: pay_ca_t4_mag.convert_2_xml(p_union_dues, 'unn_dues_amt','T','','Y')||
992: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
993: pay_ca_t4_mag.convert_2_xml(p_charitable_donations, 'chrty_dons_amt','T','','Y')||
994: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
995: pay_ca_t4_mag.convert_2_xml(p_ppip_contributions, 'ppip_cntrb_amt','T','','Y')||
996: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
990: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
991: pay_ca_t4_mag.convert_2_xml(p_union_dues, 'unn_dues_amt','T','','Y')||
992: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
993: pay_ca_t4_mag.convert_2_xml(p_charitable_donations, 'chrty_dons_amt','T','','Y')||
994: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
995: pay_ca_t4_mag.convert_2_xml(p_ppip_contributions, 'ppip_cntrb_amt','T','','Y')||
996: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
997: pay_ca_t4_mag.convert_2_xml(p_ppip_earnings, 'ppip_insu_ern_amt','T','','Y')||
998: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
992: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
993: pay_ca_t4_mag.convert_2_xml(p_charitable_donations, 'chrty_dons_amt','T','','Y')||
994: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
995: pay_ca_t4_mag.convert_2_xml(p_ppip_contributions, 'ppip_cntrb_amt','T','','Y')||
996: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
997: pay_ca_t4_mag.convert_2_xml(p_ppip_earnings, 'ppip_insu_ern_amt','T','','Y')||
998: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
999: pay_ca_t4_mag.convert_2_xml(p_other_code1, 'oth_code1','T','','Y')||
1000: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
994: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
995: pay_ca_t4_mag.convert_2_xml(p_ppip_contributions, 'ppip_cntrb_amt','T','','Y')||
996: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
997: pay_ca_t4_mag.convert_2_xml(p_ppip_earnings, 'ppip_insu_ern_amt','T','','Y')||
998: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
999: pay_ca_t4_mag.convert_2_xml(p_other_code1, 'oth_code1','T','','Y')||
1000: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1001: pay_ca_t4_mag.convert_2_xml(p_other_amount1, 'oth_amnt1','T','','Y')||
1002: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
996: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
997: pay_ca_t4_mag.convert_2_xml(p_ppip_earnings, 'ppip_insu_ern_amt','T','','Y')||
998: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
999: pay_ca_t4_mag.convert_2_xml(p_other_code1, 'oth_code1','T','','Y')||
1000: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1001: pay_ca_t4_mag.convert_2_xml(p_other_amount1, 'oth_amnt1','T','','Y')||
1002: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1003: pay_ca_t4_mag.convert_2_xml(p_other_code2, 'oth_code2','T','','Y')||
1004: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
998: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
999: pay_ca_t4_mag.convert_2_xml(p_other_code1, 'oth_code1','T','','Y')||
1000: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1001: pay_ca_t4_mag.convert_2_xml(p_other_amount1, 'oth_amnt1','T','','Y')||
1002: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1003: pay_ca_t4_mag.convert_2_xml(p_other_code2, 'oth_code2','T','','Y')||
1004: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1005: pay_ca_t4_mag.convert_2_xml(p_other_amount2, 'oth_amnt2','T','','Y')||
1006: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1000: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1001: pay_ca_t4_mag.convert_2_xml(p_other_amount1, 'oth_amnt1','T','','Y')||
1002: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1003: pay_ca_t4_mag.convert_2_xml(p_other_code2, 'oth_code2','T','','Y')||
1004: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1005: pay_ca_t4_mag.convert_2_xml(p_other_amount2, 'oth_amnt2','T','','Y')||
1006: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1007: pay_ca_t4_mag.convert_2_xml(p_other_code3, 'oth_code3','T','','Y')||
1008: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1002: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1003: pay_ca_t4_mag.convert_2_xml(p_other_code2, 'oth_code2','T','','Y')||
1004: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1005: pay_ca_t4_mag.convert_2_xml(p_other_amount2, 'oth_amnt2','T','','Y')||
1006: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1007: pay_ca_t4_mag.convert_2_xml(p_other_code3, 'oth_code3','T','','Y')||
1008: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1009: pay_ca_t4_mag.convert_2_xml(p_other_amount3, 'oth_amnt3','T','','Y')||
1010: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1004: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1005: pay_ca_t4_mag.convert_2_xml(p_other_amount2, 'oth_amnt2','T','','Y')||
1006: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1007: pay_ca_t4_mag.convert_2_xml(p_other_code3, 'oth_code3','T','','Y')||
1008: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1009: pay_ca_t4_mag.convert_2_xml(p_other_amount3, 'oth_amnt3','T','','Y')||
1010: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1011: pay_ca_t4_mag.convert_2_xml(p_other_code4, 'oth_code4','T','','Y')||
1012: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1006: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1007: pay_ca_t4_mag.convert_2_xml(p_other_code3, 'oth_code3','T','','Y')||
1008: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1009: pay_ca_t4_mag.convert_2_xml(p_other_amount3, 'oth_amnt3','T','','Y')||
1010: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1011: pay_ca_t4_mag.convert_2_xml(p_other_code4, 'oth_code4','T','','Y')||
1012: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1013: pay_ca_t4_mag.convert_2_xml(p_other_amount4, 'oth_amnt4','T','','Y')||
1014: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1008: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1009: pay_ca_t4_mag.convert_2_xml(p_other_amount3, 'oth_amnt3','T','','Y')||
1010: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1011: pay_ca_t4_mag.convert_2_xml(p_other_code4, 'oth_code4','T','','Y')||
1012: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1013: pay_ca_t4_mag.convert_2_xml(p_other_amount4, 'oth_amnt4','T','','Y')||
1014: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1015: pay_ca_t4_mag.convert_2_xml(p_other_code5, 'oth_code5','T','','Y')||
1016: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1010: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1011: pay_ca_t4_mag.convert_2_xml(p_other_code4, 'oth_code4','T','','Y')||
1012: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1013: pay_ca_t4_mag.convert_2_xml(p_other_amount4, 'oth_amnt4','T','','Y')||
1014: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1015: pay_ca_t4_mag.convert_2_xml(p_other_code5, 'oth_code5','T','','Y')||
1016: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1017: pay_ca_t4_mag.convert_2_xml(p_other_amount5, 'oth_amnt5','T','','Y')||
1018: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1012: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1013: pay_ca_t4_mag.convert_2_xml(p_other_amount4, 'oth_amnt4','T','','Y')||
1014: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1015: pay_ca_t4_mag.convert_2_xml(p_other_code5, 'oth_code5','T','','Y')||
1016: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1017: pay_ca_t4_mag.convert_2_xml(p_other_amount5, 'oth_amnt5','T','','Y')||
1018: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1019: pay_ca_t4_mag.convert_2_xml(p_other_code6, 'oth_code6','T','','Y')||
1020: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1014: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1015: pay_ca_t4_mag.convert_2_xml(p_other_code5, 'oth_code5','T','','Y')||
1016: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1017: pay_ca_t4_mag.convert_2_xml(p_other_amount5, 'oth_amnt5','T','','Y')||
1018: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1019: pay_ca_t4_mag.convert_2_xml(p_other_code6, 'oth_code6','T','','Y')||
1020: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1021: pay_ca_t4_mag.convert_2_xml(p_other_amount6, 'oth_amnt6','T','','Y')||
1022: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1016: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1017: pay_ca_t4_mag.convert_2_xml(p_other_amount5, 'oth_amnt5','T','','Y')||
1018: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1019: pay_ca_t4_mag.convert_2_xml(p_other_code6, 'oth_code6','T','','Y')||
1020: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1021: pay_ca_t4_mag.convert_2_xml(p_other_amount6, 'oth_amnt6','T','','Y')||
1022: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1023: pay_ca_t4_mag.convert_2_xml('RC-07-1122', 'cra_code','T','','Y')||
1024: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1018: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1019: pay_ca_t4_mag.convert_2_xml(p_other_code6, 'oth_code6','T','','Y')||
1020: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1021: pay_ca_t4_mag.convert_2_xml(p_other_amount6, 'oth_amnt6','T','','Y')||
1022: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1023: pay_ca_t4_mag.convert_2_xml('RC-07-1122', 'cra_code','T','','Y')||
1024: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1025: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1026: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1020: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1021: pay_ca_t4_mag.convert_2_xml(p_other_amount6, 'oth_amnt6','T','','Y')||
1022: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1023: pay_ca_t4_mag.convert_2_xml('RC-07-1122', 'cra_code','T','','Y')||
1024: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1025: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1026: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1027:
1028: hr_utility.trace('XML string :' ||l_single_xml);
1021: pay_ca_t4_mag.convert_2_xml(p_other_amount6, 'oth_amnt6','T','','Y')||
1022: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1023: pay_ca_t4_mag.convert_2_xml('RC-07-1122', 'cra_code','T','','Y')||
1024: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1025: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1026: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1027:
1028: hr_utility.trace('XML string :' ||l_single_xml);
1029:
1022: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1023: pay_ca_t4_mag.convert_2_xml('RC-07-1122', 'cra_code','T','','Y')||
1024: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1025: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1026: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1027:
1028: hr_utility.trace('XML string :' ||l_single_xml);
1029:
1030: return l_single_xml;
1044: begin
1045:
1046: l_header_xml_string :=
1047: '
1048: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1049:
1050: /* ''||
1051: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1052: '
1047: '
1048: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1049:
1050: /* ''||
1051: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1052: '
1053: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1054: */
1055: pay_core_files.write_to_magtape_lob(l_header_xml_string);
1049:
1050: /* ''||
1051: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1052: '
1053: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1054: */
1055: pay_core_files.write_to_magtape_lob(l_header_xml_string);
1056:
1057: end get_header_xml;
1064: begin
1065:
1066: l_trailer_xml_string :=
1067: ''||
1068: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1069:
1070: pay_core_files.write_to_magtape_lob(l_trailer_xml_string);
1071:
1072: end get_trailer_xml;