310:
311: begin
312: hr_utility.trace('In get_asg_xml');
313:
314: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
315:
316: open c_get_params;
317: fetch c_get_params into
318: l_aa_id,
434: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
435: hr_utility.trace('p_province '||p_province);
436: hr_utility.trace('p_output_location '||p_output_location);
437:
438: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
439: l_iana_charset := get_IANA_charset;
440:
441: l_xml_version := ''|| EOL;
442:
1331:
1332: begin
1333:
1334: l_single_xml :=
1335: '
1337: pay_ca_t4_mag.convert_2_xml(p_employee_name, 'snm','T','','Y')||
1338: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1339: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
1332: begin
1333:
1334: l_single_xml :=
1335: '
1336: '
1338: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1339: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
1340: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1334: l_single_xml :=
1335: '
1336: '
1337: pay_ca_t4_mag.convert_2_xml(p_employee_name, 'snm','T','','Y')||
1338: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1339: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
1340: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1341: pay_ca_t4_mag.convert_2_xml(p_employee_init, 'init','T','','Y')||
1342: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1336: '
1337: pay_ca_t4_mag.convert_2_xml(p_employee_name, 'snm','T','','Y')||
1338: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1339: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
1340: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1341: pay_ca_t4_mag.convert_2_xml(p_employee_init, 'init','T','','Y')||
1342: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1343: pay_ca_t4_mag.convert_2_xml(p_employee_addr, 'empe_addr','T','','Y')||
1344: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1338: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1339: pay_ca_t4_mag.convert_2_xml(p_employee_last_name, 'gvn_nm','T','','Y')||
1340: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1341: pay_ca_t4_mag.convert_2_xml(p_employee_init, 'init','T','','Y')||
1342: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1343: pay_ca_t4_mag.convert_2_xml(p_employee_addr, 'empe_addr','T','','Y')||
1344: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1345: pay_ca_t4_mag.convert_2_xml(p_employer_name, 'empr_nm','T','','Y')||
1346: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1340: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1341: pay_ca_t4_mag.convert_2_xml(p_employee_init, 'init','T','','Y')||
1342: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1343: pay_ca_t4_mag.convert_2_xml(p_employee_addr, 'empe_addr','T','','Y')||
1344: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1345: pay_ca_t4_mag.convert_2_xml(p_employer_name, 'empr_nm','T','','Y')||
1346: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1347: pay_ca_t4_mag.convert_2_xml(p_employer_addr, 'empr_addr','T','','Y')||
1348: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1342: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1343: pay_ca_t4_mag.convert_2_xml(p_employee_addr, 'empe_addr','T','','Y')||
1344: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1345: pay_ca_t4_mag.convert_2_xml(p_employer_name, 'empr_nm','T','','Y')||
1346: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1347: pay_ca_t4_mag.convert_2_xml(p_employer_addr, 'empr_addr','T','','Y')||
1348: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1349: pay_ca_t4_mag.convert_2_xml(p_gre_name, 'gre','T','','Y')||
1350: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1344: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1345: pay_ca_t4_mag.convert_2_xml(p_employer_name, 'empr_nm','T','','Y')||
1346: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1347: pay_ca_t4_mag.convert_2_xml(p_employer_addr, 'empr_addr','T','','Y')||
1348: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1349: pay_ca_t4_mag.convert_2_xml(p_gre_name, 'gre','T','','Y')||
1350: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1351: pay_ca_t4_mag.convert_2_xml(p_employer_bn, 'bn','T','','Y')||
1352: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1346: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1347: pay_ca_t4_mag.convert_2_xml(p_employer_addr, 'empr_addr','T','','Y')||
1348: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1349: pay_ca_t4_mag.convert_2_xml(p_gre_name, 'gre','T','','Y')||
1350: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1351: pay_ca_t4_mag.convert_2_xml(p_employer_bn, 'bn','T','','Y')||
1352: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1353: pay_ca_t4_mag.convert_2_xml(p_sin, 'sin','T','','Y')||
1354: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1348: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1349: pay_ca_t4_mag.convert_2_xml(p_gre_name, 'gre','T','','Y')||
1350: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1351: pay_ca_t4_mag.convert_2_xml(p_employer_bn, 'bn','T','','Y')||
1352: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1353: pay_ca_t4_mag.convert_2_xml(p_sin, 'sin','T','','Y')||
1354: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1355: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_exempt, 'cpp_qpp_xmpt_cd','T','','Y')||
1356: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1350: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1351: pay_ca_t4_mag.convert_2_xml(p_employer_bn, 'bn','T','','Y')||
1352: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1353: pay_ca_t4_mag.convert_2_xml(p_sin, 'sin','T','','Y')||
1354: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1355: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_exempt, 'cpp_qpp_xmpt_cd','T','','Y')||
1356: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1357: pay_ca_t4_mag.convert_2_xml(p_ppip_exempt, 'ppip_xmpt_cd','T','','Y')||
1358: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1352: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1353: pay_ca_t4_mag.convert_2_xml(p_sin, 'sin','T','','Y')||
1354: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1355: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_exempt, 'cpp_qpp_xmpt_cd','T','','Y')||
1356: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1357: pay_ca_t4_mag.convert_2_xml(p_ppip_exempt, 'ppip_xmpt_cd','T','','Y')||
1358: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1359: pay_ca_t4_mag.convert_2_xml(p_ei_exempt, 'ei_xmpt_cd','T','','Y')||
1360: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1354: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1355: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_exempt, 'cpp_qpp_xmpt_cd','T','','Y')||
1356: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1357: pay_ca_t4_mag.convert_2_xml(p_ppip_exempt, 'ppip_xmpt_cd','T','','Y')||
1358: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1359: pay_ca_t4_mag.convert_2_xml(p_ei_exempt, 'ei_xmpt_cd','T','','Y')||
1360: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1361: pay_ca_t4_mag.convert_2_xml(p_year, 'tx_yr','T','','Y')||
1362: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1356: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1357: pay_ca_t4_mag.convert_2_xml(p_ppip_exempt, 'ppip_xmpt_cd','T','','Y')||
1358: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1359: pay_ca_t4_mag.convert_2_xml(p_ei_exempt, 'ei_xmpt_cd','T','','Y')||
1360: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1361: pay_ca_t4_mag.convert_2_xml(p_year, 'tx_yr','T','','Y')||
1362: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1363: pay_ca_t4_mag.convert_2_xml(p_employment_prov, 'empt_prov_cd','T','','Y')||
1364: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1358: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1359: pay_ca_t4_mag.convert_2_xml(p_ei_exempt, 'ei_xmpt_cd','T','','Y')||
1360: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1361: pay_ca_t4_mag.convert_2_xml(p_year, 'tx_yr','T','','Y')||
1362: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1363: pay_ca_t4_mag.convert_2_xml(p_employment_prov, 'empt_prov_cd','T','','Y')||
1364: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1365: pay_ca_t4_mag.convert_2_xml(p_employment_code, 'empt_cd','T','','Y')||
1366: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1360: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1361: pay_ca_t4_mag.convert_2_xml(p_year, 'tx_yr','T','','Y')||
1362: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1363: pay_ca_t4_mag.convert_2_xml(p_employment_prov, 'empt_prov_cd','T','','Y')||
1364: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1365: pay_ca_t4_mag.convert_2_xml(p_employment_code, 'empt_cd','T','','Y')||
1366: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1367: pay_ca_t4_mag.convert_2_xml(p_employment_income, 'empt_incamt','T','','Y')||
1368: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1362: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1363: pay_ca_t4_mag.convert_2_xml(p_employment_prov, 'empt_prov_cd','T','','Y')||
1364: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1365: pay_ca_t4_mag.convert_2_xml(p_employment_code, 'empt_cd','T','','Y')||
1366: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1367: pay_ca_t4_mag.convert_2_xml(p_employment_income, 'empt_incamt','T','','Y')||
1368: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1369: pay_ca_t4_mag.convert_2_xml(p_registration_number, 'rpp_dpsp_rgst_nbr','T','','Y')||
1370: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1364: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1365: pay_ca_t4_mag.convert_2_xml(p_employment_code, 'empt_cd','T','','Y')||
1366: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1367: pay_ca_t4_mag.convert_2_xml(p_employment_income, 'empt_incamt','T','','Y')||
1368: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1369: pay_ca_t4_mag.convert_2_xml(p_registration_number, 'rpp_dpsp_rgst_nbr','T','','Y')||
1370: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1371: pay_ca_t4_mag.convert_2_xml(p_cpp_contributions, 'cpp_cntrb_amt','T','','Y')||
1372: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1366: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1367: pay_ca_t4_mag.convert_2_xml(p_employment_income, 'empt_incamt','T','','Y')||
1368: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1369: pay_ca_t4_mag.convert_2_xml(p_registration_number, 'rpp_dpsp_rgst_nbr','T','','Y')||
1370: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1371: pay_ca_t4_mag.convert_2_xml(p_cpp_contributions, 'cpp_cntrb_amt','T','','Y')||
1372: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1373: pay_ca_t4_mag.convert_2_xml(p_qpp_contributions, 'qpp_cntrb_amt','T','','Y')||
1374: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1368: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1369: pay_ca_t4_mag.convert_2_xml(p_registration_number, 'rpp_dpsp_rgst_nbr','T','','Y')||
1370: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1371: pay_ca_t4_mag.convert_2_xml(p_cpp_contributions, 'cpp_cntrb_amt','T','','Y')||
1372: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1373: pay_ca_t4_mag.convert_2_xml(p_qpp_contributions, 'qpp_cntrb_amt','T','','Y')||
1374: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1375: pay_ca_t4_mag.convert_2_xml(p_ei_contributions, 'empe_eip_amt','T','','Y')||
1376: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1370: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1371: pay_ca_t4_mag.convert_2_xml(p_cpp_contributions, 'cpp_cntrb_amt','T','','Y')||
1372: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1373: pay_ca_t4_mag.convert_2_xml(p_qpp_contributions, 'qpp_cntrb_amt','T','','Y')||
1374: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1375: pay_ca_t4_mag.convert_2_xml(p_ei_contributions, 'empe_eip_amt','T','','Y')||
1376: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1377: pay_ca_t4_mag.convert_2_xml(p_rpp_contributions, 'rpp_cntrb_amt','T','','Y')||
1378: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1372: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1373: pay_ca_t4_mag.convert_2_xml(p_qpp_contributions, 'qpp_cntrb_amt','T','','Y')||
1374: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1375: pay_ca_t4_mag.convert_2_xml(p_ei_contributions, 'empe_eip_amt','T','','Y')||
1376: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1377: pay_ca_t4_mag.convert_2_xml(p_rpp_contributions, 'rpp_cntrb_amt','T','','Y')||
1378: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1379: pay_ca_t4_mag.convert_2_xml(p_pension_adjustment, 'padj_amt','T','','Y')||
1380: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1374: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1375: pay_ca_t4_mag.convert_2_xml(p_ei_contributions, 'empe_eip_amt','T','','Y')||
1376: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1377: pay_ca_t4_mag.convert_2_xml(p_rpp_contributions, 'rpp_cntrb_amt','T','','Y')||
1378: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1379: pay_ca_t4_mag.convert_2_xml(p_pension_adjustment, 'padj_amt','T','','Y')||
1380: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1381: pay_ca_t4_mag.convert_2_xml(p_tax_deducted, 'itx_ddct_amt','T','','Y')||
1382: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1376: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1377: pay_ca_t4_mag.convert_2_xml(p_rpp_contributions, 'rpp_cntrb_amt','T','','Y')||
1378: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1379: pay_ca_t4_mag.convert_2_xml(p_pension_adjustment, 'padj_amt','T','','Y')||
1380: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1381: pay_ca_t4_mag.convert_2_xml(p_tax_deducted, 'itx_ddct_amt','T','','Y')||
1382: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1383: pay_ca_t4_mag.convert_2_xml(p_ei_earnings, 'ei_insu_ern_amt','T','','Y')||
1384: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1378: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1379: pay_ca_t4_mag.convert_2_xml(p_pension_adjustment, 'padj_amt','T','','Y')||
1380: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1381: pay_ca_t4_mag.convert_2_xml(p_tax_deducted, 'itx_ddct_amt','T','','Y')||
1382: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1383: pay_ca_t4_mag.convert_2_xml(p_ei_earnings, 'ei_insu_ern_amt','T','','Y')||
1384: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1385: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_earnings, 'cpp_qpp_ern_amt','T','','Y')||
1386: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1380: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1381: pay_ca_t4_mag.convert_2_xml(p_tax_deducted, 'itx_ddct_amt','T','','Y')||
1382: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1383: pay_ca_t4_mag.convert_2_xml(p_ei_earnings, 'ei_insu_ern_amt','T','','Y')||
1384: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1385: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_earnings, 'cpp_qpp_ern_amt','T','','Y')||
1386: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1387: pay_ca_t4_mag.convert_2_xml(p_union_dues, 'unn_dues_amt','T','','Y')||
1388: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1382: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1383: pay_ca_t4_mag.convert_2_xml(p_ei_earnings, 'ei_insu_ern_amt','T','','Y')||
1384: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1385: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_earnings, 'cpp_qpp_ern_amt','T','','Y')||
1386: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1387: pay_ca_t4_mag.convert_2_xml(p_union_dues, 'unn_dues_amt','T','','Y')||
1388: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1389: pay_ca_t4_mag.convert_2_xml(p_charitable_donations, 'chrty_dons_amt','T','','Y')||
1390: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1384: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1385: pay_ca_t4_mag.convert_2_xml(p_cpp_qpp_earnings, 'cpp_qpp_ern_amt','T','','Y')||
1386: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1387: pay_ca_t4_mag.convert_2_xml(p_union_dues, 'unn_dues_amt','T','','Y')||
1388: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1389: pay_ca_t4_mag.convert_2_xml(p_charitable_donations, 'chrty_dons_amt','T','','Y')||
1390: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1391: pay_ca_t4_mag.convert_2_xml(p_ppip_contributions, 'ppip_cntrb_amt','T','','Y')||
1392: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1386: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1387: pay_ca_t4_mag.convert_2_xml(p_union_dues, 'unn_dues_amt','T','','Y')||
1388: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1389: pay_ca_t4_mag.convert_2_xml(p_charitable_donations, 'chrty_dons_amt','T','','Y')||
1390: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1391: pay_ca_t4_mag.convert_2_xml(p_ppip_contributions, 'ppip_cntrb_amt','T','','Y')||
1392: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1393: pay_ca_t4_mag.convert_2_xml(p_ppip_earnings, 'ppip_insu_ern_amt','T','','Y')||
1394: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1388: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1389: pay_ca_t4_mag.convert_2_xml(p_charitable_donations, 'chrty_dons_amt','T','','Y')||
1390: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1391: pay_ca_t4_mag.convert_2_xml(p_ppip_contributions, 'ppip_cntrb_amt','T','','Y')||
1392: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1393: pay_ca_t4_mag.convert_2_xml(p_ppip_earnings, 'ppip_insu_ern_amt','T','','Y')||
1394: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1395: --3891966
1396: -- To get correct format for code 73, changes are done in pay_ca_t4_mag.convert_2_xml
1390: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1391: pay_ca_t4_mag.convert_2_xml(p_ppip_contributions, 'ppip_cntrb_amt','T','','Y')||
1392: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1393: pay_ca_t4_mag.convert_2_xml(p_ppip_earnings, 'ppip_insu_ern_amt','T','','Y')||
1394: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1395: --3891966
1396: -- To get correct format for code 73, changes are done in pay_ca_t4_mag.convert_2_xml
1397: l_single_xml := l_single_xml||
1398: pay_ca_t4_mag.convert_2_xml(p_other_code1, 'oth_code1','T','','Y')||
1395: --3891966
1396: -- To get correct format for code 73, changes are done in pay_ca_t4_mag.convert_2_xml
1397: l_single_xml := l_single_xml||
1398: pay_ca_t4_mag.convert_2_xml(p_other_code1, 'oth_code1','T','','Y')||
1399: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1400: if p_other_code1 = '73' then
1401: l_single_xml := l_single_xml||
1402: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount1),'oth_amnt1','Y','','Y')||
1403: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1399: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1400: if p_other_code1 = '73' then
1401: l_single_xml := l_single_xml||
1402: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount1),'oth_amnt1','Y','','Y')||
1403: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1404: else
1405: l_single_xml := l_single_xml||
1406: pay_ca_t4_mag.convert_2_xml(p_other_amount1, 'oth_amnt1','T','','Y')||
1407: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1403: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1404: else
1405: l_single_xml := l_single_xml||
1406: pay_ca_t4_mag.convert_2_xml(p_other_amount1, 'oth_amnt1','T','','Y')||
1407: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1408: end if;
1409:
1410: l_single_xml := l_single_xml||
1411: pay_ca_t4_mag.convert_2_xml(p_other_code2, 'oth_code2','T','','Y')||
1408: end if;
1409:
1410: l_single_xml := l_single_xml||
1411: pay_ca_t4_mag.convert_2_xml(p_other_code2, 'oth_code2','T','','Y')||
1412: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1413:
1414: if p_other_code2 = '73' then
1415: l_single_xml := l_single_xml||
1416: pay_ca_t4_mag.convert_2_xml(p_other_amount2,'oth_amnt2','Y','','Y')||
1413:
1414: if p_other_code2 = '73' then
1415: l_single_xml := l_single_xml||
1416: pay_ca_t4_mag.convert_2_xml(p_other_amount2,'oth_amnt2','Y','','Y')||
1417: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1418: else
1419: l_single_xml := l_single_xml||
1420: pay_ca_t4_mag.convert_2_xml(p_other_amount2, 'oth_amnt2','T','','Y')||
1421: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1417: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1418: else
1419: l_single_xml := l_single_xml||
1420: pay_ca_t4_mag.convert_2_xml(p_other_amount2, 'oth_amnt2','T','','Y')||
1421: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1422: end if;
1423: l_single_xml := l_single_xml||
1424: pay_ca_t4_mag.convert_2_xml(p_other_code3, 'oth_code3','T','','Y')||
1425: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1421: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1422: end if;
1423: l_single_xml := l_single_xml||
1424: pay_ca_t4_mag.convert_2_xml(p_other_code3, 'oth_code3','T','','Y')||
1425: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1426:
1427: if p_other_code3 = '73' then
1428: l_single_xml := l_single_xml||
1429: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount3),'oth_amnt3','Y','','Y')||
1426:
1427: if p_other_code3 = '73' then
1428: l_single_xml := l_single_xml||
1429: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount3),'oth_amnt3','Y','','Y')||
1430: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1431: else
1432: l_single_xml := l_single_xml||
1433: pay_ca_t4_mag.convert_2_xml(p_other_amount3, 'oth_amnt3','T','','Y')||
1434: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1430: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1431: else
1432: l_single_xml := l_single_xml||
1433: pay_ca_t4_mag.convert_2_xml(p_other_amount3, 'oth_amnt3','T','','Y')||
1434: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1435: end if;
1436: l_single_xml := l_single_xml||
1437: pay_ca_t4_mag.convert_2_xml(p_other_code4, 'oth_code4','T','','Y')||
1438: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1434: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1435: end if;
1436: l_single_xml := l_single_xml||
1437: pay_ca_t4_mag.convert_2_xml(p_other_code4, 'oth_code4','T','','Y')||
1438: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1439:
1440: if p_other_code4 = '73' then
1441: l_single_xml := l_single_xml||
1442: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount4),'oth_amnt4','Y','','Y')||
1439:
1440: if p_other_code4 = '73' then
1441: l_single_xml := l_single_xml||
1442: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount4),'oth_amnt4','Y','','Y')||
1443: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1444: else
1445: l_single_xml := l_single_xml||
1446: pay_ca_t4_mag.convert_2_xml(p_other_amount4, 'oth_amnt4','T','','Y')||
1447: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1443: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1444: else
1445: l_single_xml := l_single_xml||
1446: pay_ca_t4_mag.convert_2_xml(p_other_amount4, 'oth_amnt4','T','','Y')||
1447: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1448: end if;
1449: l_single_xml := l_single_xml||
1450: pay_ca_t4_mag.convert_2_xml(p_other_code5, 'oth_code5','T','','Y')||
1451: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1447: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1448: end if;
1449: l_single_xml := l_single_xml||
1450: pay_ca_t4_mag.convert_2_xml(p_other_code5, 'oth_code5','T','','Y')||
1451: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1452:
1453: if p_other_code5 = '73' then
1454: l_single_xml := l_single_xml||
1455: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount5),'oth_amnt5','Y','','Y')||
1452:
1453: if p_other_code5 = '73' then
1454: l_single_xml := l_single_xml||
1455: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount5),'oth_amnt5','Y','','Y')||
1456: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1457: else
1458: l_single_xml := l_single_xml||
1459: pay_ca_t4_mag.convert_2_xml(p_other_amount5, 'oth_amnt5','T','','Y')||
1460: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1456: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1457: else
1458: l_single_xml := l_single_xml||
1459: pay_ca_t4_mag.convert_2_xml(p_other_amount5, 'oth_amnt5','T','','Y')||
1460: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1461: end if;
1462: l_single_xml := l_single_xml||
1463: pay_ca_t4_mag.convert_2_xml(p_other_code6, 'oth_code6','T','','Y')||
1464: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1460: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1461: end if;
1462: l_single_xml := l_single_xml||
1463: pay_ca_t4_mag.convert_2_xml(p_other_code6, 'oth_code6','T','','Y')||
1464: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1465:
1466: if p_other_code6 = '73' then
1467: l_single_xml := l_single_xml||
1468: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount6),'oth_amnt6','Y','','Y')||
1465:
1466: if p_other_code6 = '73' then
1467: l_single_xml := l_single_xml||
1468: pay_ca_t4_mag.convert_2_xml(ceil(p_other_amount6),'oth_amnt6','Y','','Y')||
1469: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1470: else
1471: l_single_xml := l_single_xml||
1472: pay_ca_t4_mag.convert_2_xml(p_other_amount6, 'oth_amnt6','T','','Y')||
1473: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1469: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1470: else
1471: l_single_xml := l_single_xml||
1472: pay_ca_t4_mag.convert_2_xml(p_other_amount6, 'oth_amnt6','T','','Y')||
1473: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1474: end if;
1475:
1476:
1477: l_single_xml := l_single_xml||'
1476:
1477: l_single_xml := l_single_xml||'
1478: -- Commented below code by sneelapa for bug 7541442
1479: --pay_ca_t4_mag.convert_2_xml('RC-07-1122', 'cra_code','T','','Y')||
1480: --fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1481: l_single_xml := l_single_xml||''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1482: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1483:
1484: hr_utility.trace('XML string :' ||l_single_xml);
1477: l_single_xml := l_single_xml||'
1478: -- Commented below code by sneelapa for bug 7541442
1479: --pay_ca_t4_mag.convert_2_xml('RC-07-1122', 'cra_code','T','','Y')||
1480: --fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1481: l_single_xml := l_single_xml||''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1482: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1483:
1484: hr_utility.trace('XML string :' ||l_single_xml);
1485:
1478: -- Commented below code by sneelapa for bug 7541442
1479: --pay_ca_t4_mag.convert_2_xml('RC-07-1122', 'cra_code','T','','Y')||
1480: --fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1481: l_single_xml := l_single_xml||''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1482: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10);
1483:
1484: hr_utility.trace('XML string :' ||l_single_xml);
1485:
1486: return l_single_xml;
1499: begin
1500:
1501: l_header_xml_string :=
1502: '
1503: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1504:
1505: /* ''||
1506: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1507: '
1502: '
1503: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1504:
1505: /* ''||
1506: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1507: '
1508: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1509: */
1510: pay_core_files.write_to_magtape_lob(l_header_xml_string);
1504:
1505: /* ''||
1506: fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1507: '
1508: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1509: */
1510: pay_core_files.write_to_magtape_lob(l_header_xml_string);
1511:
1512: end get_header_xml;
1519: begin
1520:
1521: l_trailer_xml_string :=
1522: ''||
1523: fnd_global.local_chr(13)||fnd_global.local_chr(10);
1524:
1525: pay_core_files.write_to_magtape_lob(l_trailer_xml_string);
1526:
1527: end get_trailer_xml;