DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on FND_GLOBAL

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

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,

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

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:

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

1331:
1332: begin
1333:
1334: l_single_xml :=
1335: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1336: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
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')||

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

1332: begin
1333:
1334: l_single_xml :=
1335: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1336: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
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)||

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

1334: l_single_xml :=
1335: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
1336: ''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||
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)||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1392: 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

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

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

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

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

Line 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')||

Line 1412: 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')||
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')||

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

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

Line 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')||

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

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

Line 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')||

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

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

Line 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')||

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

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

Line 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')||

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

Line 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||''||p_blank_page_flg||''; /*11066853 */

Line 1480: --fnd_global.local_chr(13)||fnd_global.local_chr(10)||

1476:
1477: l_single_xml := l_single_xml||''||p_blank_page_flg||''; /*11066853 */
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);

Line 1481: l_single_xml := l_single_xml||''||fnd_global.local_chr(13)||fnd_global.local_chr(10)||

1477: l_single_xml := l_single_xml||''||p_blank_page_flg||''; /*11066853 */
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:

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

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;

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

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

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

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

Line 1508: 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);
1511:
1512: end get_header_xml;

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

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;