DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on FND_GLOBAL

Line 188: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);

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,

Line 939: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||

935:
936: begin
937:
938: l_single_xml :=
939: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
940: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
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')||

Line 940: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||

936: begin
937:
938: l_single_xml :=
939: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
940: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
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)||

Line 942: fnd_global.local_chr(13)||fnd_global.local_chr(10)||

938: l_single_xml :=
939: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
940: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
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)||

Line 944: fnd_global.local_chr(13)||fnd_global.local_chr(10)||

940: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
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)||

Line 946: 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)||

Line 948: 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)||

Line 950: 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)||

Line 952: 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)||

Line 954: 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)||

Line 956: 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)||

Line 958: 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)||

Line 960: 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)||

Line 962: 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)||

Line 964: 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)||

Line 966: 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)||

Line 968: 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)||

Line 970: 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)||

Line 972: 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)||

Line 974: 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)||

Line 976: 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)||

Line 978: 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)||

Line 980: 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)||

Line 982: 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)||

Line 984: 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)||

Line 986: 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)||

Line 988: 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)||

Line 990: 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)||

Line 992: 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)||

Line 994: 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)||

Line 996: 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)||

Line 998: 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)||

Line 1000: 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)||

Line 1002: 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)||

Line 1004: 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)||

Line 1006: 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)||

Line 1008: 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)||

Line 1010: 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)||

Line 1012: 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)||

Line 1014: 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)||

Line 1016: 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)||

Line 1018: 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)||

Line 1020: 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)||

Line 1022: 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);

Line 1024: 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);

Line 1025: ''||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);
1029:

Line 1026: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);

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;

Line 1048: fnd_global.local_chr(13)||fnd_global.local_chr(10);

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: ''||

Line 1051: fnd_global.local_chr(13)||fnd_global.local_chr(10)||

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);

Line 1053: 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);
1056:
1057: end get_header_xml;

Line 1068: fnd_global.local_chr(13)||fnd_global.local_chr(10);

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;