eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_T4A_AMEND_MAG dependencies on PAY_CA_ARCHIVE_UTILS

Line 779: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

775:
776: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
777: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
778:
779: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
780: 'CAEOY_TRANSMITTER_NUMBER');
781: IF l_return IS NULL THEN
782: l_field_name := l_field_name || 'CAEOY_TRANSMITTER_NUMBER,';
783: l_status := FALSE;

Line 793: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

789: l_return := pay_magtape_generic.get_parameter_value('SBMT_REF_ID');
790: tab_transmitter(T619_sbmt_ref_id)
791: := convert_2_xml(nvl(l_return,' '),'sbmt_ref_id');
792: ----
793: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
794: 'CAEOY_TRANSMITTER_TYPE_INDICATOR');
795: IF l_return IS NULL THEN
796: l_field_name := l_field_name || 'CAEOY_TRANSMITTER_TYPE_INDICATOR,';
797: l_status := FALSE;

Line 802: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

798: END IF;
799: tab_transmitter(T619_trnmtr_tcd)
800: := convert_2_xml(l_return,'trnmtr_tcd');
801: ----
802: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
803: 'CAEOY_T4A_TOTAL_NO_SUMMARY_COUNT');
804: tab_transmitter(T619_summ_cnt)
805: := convert_2_xml(l_return,'summ_cnt');
806: ----

Line 807: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

803: 'CAEOY_T4A_TOTAL_NO_SUMMARY_COUNT');
804: tab_transmitter(T619_summ_cnt)
805: := convert_2_xml(l_return,'summ_cnt');
806: ----
807: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
808: 'CAEOY_TRANSMITTER_NAME');
809: tab_transmitter(T619_l1_nm)
810: := convert_2_xml
811: (upper(rpad(substr(l_return,1,30),30)) ,'l1_nm');

Line 816: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

812: tab_transmitter(T619_l2_nm)
813: := convert_2_xml
814: (upper(rpad(substr(l_return,31,30),30)) ,'l2_nm');
815: ----
816: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
817: 'CAEOY_TRANSMITTER_ADDRESS_LINE1');
818: tab_transmitter(T619_addr_l1_txt)
819: := convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
820: ----

Line 821: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

817: 'CAEOY_TRANSMITTER_ADDRESS_LINE1');
818: tab_transmitter(T619_addr_l1_txt)
819: := convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
820: ----
821: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
822: 'CAEOY_TRANSMITTER_ADDRESS_LINE2');
823: tab_transmitter(T619_addr_l2_txt)
824: := convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
825: ----

Line 826: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

822: 'CAEOY_TRANSMITTER_ADDRESS_LINE2');
823: tab_transmitter(T619_addr_l2_txt)
824: := convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
825: ----
826: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
827: 'CAEOY_TRANSMITTER_CITY');
828: tab_transmitter(T619_cty_nm)
829: := convert_2_xml(substr(l_return,1,28),'cty_nm');
830: ----

Line 831: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

827: 'CAEOY_TRANSMITTER_CITY');
828: tab_transmitter(T619_cty_nm)
829: := convert_2_xml(substr(l_return,1,28),'cty_nm');
830: ----
831: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
832: 'CAEOY_TRANSMITTER_PROVINCE');
833: tab_transmitter(T619_prov_cd)
834: := convert_2_xml(l_return,'prov_cd');
835: ----

Line 836: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

832: 'CAEOY_TRANSMITTER_PROVINCE');
833: tab_transmitter(T619_prov_cd)
834: := convert_2_xml(l_return,'prov_cd');
835: ----
836: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
837: 'CAEOY_TRANSMITTER_COUNTRY');
838: IF l_return IS NULL THEN
839: tab_transmitter(T619_cntry_cd) := NULL;
840: ELSIF l_return='CA' THEN

Line 846: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

842: ELSIF l_return='US' THEN
843: tab_transmitter(T619_cntry_cd) := convert_2_xml('USA', 'cntry_cd');
844: END IF;
845: ----
846: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
847: 'CAEOY_TRANSMITTER_POSTAL_CODE');
848: tab_transmitter(T619_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
849: ----
850: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

Line 850: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

846: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
847: 'CAEOY_TRANSMITTER_POSTAL_CODE');
848: tab_transmitter(T619_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
849: ----
850: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
851: 'CAEOY_TECHNICAL_CONTACT_NAME');
852: IF l_return IS NULL THEN
853: l_field_name := l_field_name || 'CAEOY_TECHNICAL_CONTACT_NAME,';
854: l_status := FALSE;

Line 860: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

856: tab_transmitter(T619_cntc_nm)
857: := convert_2_xml(substr(l_return,1,22),'cntc_nm');
858:
859: ----
860: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
861: 'CAEOY_TECHNICAL_CONTACT_AREA_CODE');
862: tab_transmitter(T619_cntc_area_cd)
863: := convert_2_xml(substr(l_return,1,3),'cntc_area_cd');
864: ----

Line 865: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

861: 'CAEOY_TECHNICAL_CONTACT_AREA_CODE');
862: tab_transmitter(T619_cntc_area_cd)
863: := convert_2_xml(substr(l_return,1,3),'cntc_area_cd');
864: ----
865: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
866: 'CAEOY_TECHNICAL_CONTACT_PHONE');
867: IF l_return IS NULL THEN
868: tab_transmitter(T619_cntc_phn_nbr) := NULL;
869: ELSE

Line 878: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

874: substr(l_return,4,4),
875: 'cntc_phn_nbr');
876: END IF;
877: ----
878: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
879: 'CAEOY_TECHNICAL_CONTACT_EXTN');
880: IF l_return IS NULL THEN
881: tab_transmitter(T619_cntc_extn_nbr) := NULL;
882: ELSE

Line 888: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

884: := convert_2_xml(substr(l_return,1,5),
885: 'cntc_extn_nbr');
886: END IF;
887: ----
888: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
889: 'CAEOY_TECHNICAL_CONTACT_EMAIL');
890: IF l_return IS NULL THEN
891: tab_transmitter(T619_cntc_email_area) := NULL;
892: l_field_name := l_field_name || 'CAEOY_TECHNICAL_CONTACT_EMAIL,';

Line 903: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

899: ----
900: tab_transmitter(T619_rpt_tcd)
901: := convert_2_xml('A','rpt_tcd'); -- A -> Amendment
902: ----
903: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
904: 'CAEOY_TECHNICAL_CONTACT_LANGUAGE');
905: tab_transmitter(T619_lang_cd)
906: := convert_2_xml(l_return,'lang_cd');
907: ----

Line 909: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

905: tab_transmitter(T619_lang_cd)
906: := convert_2_xml(l_return,'lang_cd');
907: ----
908: IF l_status = FALSE THEN
909: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
910: 'CAEOY_TRANSMITTER_NAME');
911: hr_utility.set_location('Error in T4A Transmitter record',10);
912: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
913: hr_utility.trace('Technical contact details missing');

Line 1042: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1038: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
1039: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1040: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1041: ----
1042: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1043: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1044: tab_employer(T4ASummary_bn):= convert_2_xml(l_return,'bn');
1045:
1046: ----

Line 1047: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1043: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1044: tab_employer(T4ASummary_bn):= convert_2_xml(l_return,'bn');
1045:
1046: ----
1047: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1048: 'CAEOY_EMPLOYER_NAME');
1049: tab_employer(T4ASummary_l1_nm):= convert_2_xml(substr(l_return,1,30),'l1_nm');
1050: tab_employer(T4ASummary_l2_nm):= convert_2_xml(substr(l_return,31,30),'l2_nm');
1051: tab_employer(T4ASummary_l3_nm):= convert_2_xml(substr(l_return,61,30),'l3_nm');

Line 1053: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1049: tab_employer(T4ASummary_l1_nm):= convert_2_xml(substr(l_return,1,30),'l1_nm');
1050: tab_employer(T4ASummary_l2_nm):= convert_2_xml(substr(l_return,31,30),'l2_nm');
1051: tab_employer(T4ASummary_l3_nm):= convert_2_xml(substr(l_return,61,30),'l3_nm');
1052: ----
1053: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1054: 'CAEOY_EMPLOYER_ADDRESS_LINE1');
1055: tab_employer(T4ASummary_addr_l1_txt):= convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
1056: ----
1057: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

Line 1057: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1053: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1054: 'CAEOY_EMPLOYER_ADDRESS_LINE1');
1055: tab_employer(T4ASummary_addr_l1_txt):= convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
1056: ----
1057: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1058: 'CAEOY_EMPLOYER_ADDRESS_LINE2');
1059: tab_employer(T4ASummary_addr_l2_txt):= convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
1060: ----
1061: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

Line 1061: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1057: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1058: 'CAEOY_EMPLOYER_ADDRESS_LINE2');
1059: tab_employer(T4ASummary_addr_l2_txt):= convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
1060: ----
1061: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1062: 'CAEOY_EMPLOYER_CITY');
1063: tab_employer(T4ASummary_cty_nm):= convert_2_xml(substr(l_return,1,28),'cty_nm');
1064: ----
1065: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

Line 1065: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1061: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1062: 'CAEOY_EMPLOYER_CITY');
1063: tab_employer(T4ASummary_cty_nm):= convert_2_xml(substr(l_return,1,28),'cty_nm');
1064: ----
1065: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1066: 'CAEOY_EMPLOYER_PROVINCE');
1067: tab_employer(T4ASummary_prov_cd):= convert_2_xml(substr(l_return,1,2),'prov_cd');
1068: ----
1069: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

Line 1069: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1065: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1066: 'CAEOY_EMPLOYER_PROVINCE');
1067: tab_employer(T4ASummary_prov_cd):= convert_2_xml(substr(l_return,1,2),'prov_cd');
1068: ----
1069: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1070: 'CAEOY_EMPLOYER_COUNTRY');
1071: IF l_return IS NULL THEN
1072: tab_employer(T4ASummary_cntry_cd) := NULL;
1073: ELSIF l_return ='CA' THEN

Line 1079: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1075: ELSIF l_return ='US' THEN
1076: tab_employer(T4ASummary_cntry_cd):= convert_2_xml('USA','cntry_cd');
1077: END IF;
1078: ----
1079: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1080: 'CAEOY_EMPLOYER_POSTAL_CODE');
1081: tab_employer(T4ASummary_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
1082: ----
1083: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

Line 1083: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1079: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1080: 'CAEOY_EMPLOYER_POSTAL_CODE');
1081: tab_employer(T4ASummary_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
1082: ----
1083: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1084: 'CAEOY_ACCOUNTING_CONTACT_NAME');
1085: IF l_return IS NULL THEN
1086: tab_employer(T4ASummary_cntc_nm):= convert_2_xml(' ', 'cntc_nm');
1087: ELSE

Line 1092: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1088: tab_employer(T4ASummary_cntc_nm):= convert_2_xml(substr(l_return,1,22)
1089: , 'cntc_nm');
1090: END IF;
1091: ----
1092: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1093: 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
1094: IF l_return IS NULL THEN
1095: tab_employer(T4ASummary_cntc_area_cd):= convert_2_xml(' ', 'cntc_area_cd');
1096: ELSE

Line 1101: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1097: tab_employer(T4ASummary_cntc_area_cd):= convert_2_xml(substr(l_return,1,22)
1098: , 'cntc_area_cd');
1099: END IF;
1100: ----
1101: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1102: 'CAEOY_ACCOUNTING_CONTACT_PHONE');
1103: IF l_return IS NULL THEN
1104: tab_employer(T4ASummary_cntc_phn_nbr):= convert_2_xml('000-0000 ', 'cntc_phn_nbr');
1105: ELSE

Line 1112: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1108: tab_employer(T4ASummary_cntc_phn_nbr):= convert_2_xml(substr(l_return,1,3)||'-'||substr(l_return,4,4)
1109: , 'cntc_phn_nbr');
1110: END IF;
1111: ----
1112: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1113: 'CAEOY_ACCOUNTING_CONTACT_EXTENSION');
1114: IF l_return IS NULL THEN
1115: tab_employer(T4ASummary_cntc_extn_nbr):= convert_2_xml(' ', 'cntc_extn_nbr');
1116: ELSE

Line 1121: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1117: tab_employer(T4ASummary_cntc_extn_nbr):= convert_2_xml(substr(l_return,1,5)
1118: , 'cntc_extn_nbr');
1119: END IF;
1120: ----
1121: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1122: 'CAEOY_TAXATION_YEAR');
1123: tab_employer(T4ASummary_tx_yr):= convert_2_xml(l_return, 'tx_yr');
1124: ----
1125:

Line 1139: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1135: ,'rpp_rgst_2_nbr');
1136: tab_employer(T4ASummary_rpp_rgst_3_nbr) := convert_2_xml(substr(lv_ppreg_no3,1,7)
1137: ,'rpp_rgst_3_nbr');
1138: ----
1139: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1140: 'CAEOY_PROPRIETOR_SIN1');
1141: -- 11074583 start
1142: if trim(l_return) IS NULL then
1143: l_return := lpad('0',9,'0');

Line 1148: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

1144: end if;
1145: -- 11074583 end
1146: tab_employer(T4ASummary_pprtr_1_sin):= convert_2_xml(substr(REPLACE(l_return,' ',''),1,9), 'pprtr_1_sin');
1147: ----
1148: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1149: 'CAEOY_PROPRIETOR_SIN2');
1150: -- 11074583 start
1151: if trim(l_return) IS NULL then
1152: l_return := lpad('0',9,'0');

Line 1324: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1320: CLOSE c_get_payroll_asg_actid;
1321: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);
1322: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);
1323: ----
1324: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1325: ,'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');
1326:
1327: IF(l_return='Y') THEN
1328: l_status := FALSE;

Line 1348: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1344: l_postal_code,
1345: l_country,
1346: l_emp_province);
1347:
1348: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1349: ,'CAEOY_EMPLOYEE_LAST_NAME');
1350: IF l_return IS NULL THEN
1351: l_status := FALSE;
1352: l_error_message := l_error_message||'Blank Last Name ';

Line 1357: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1353: END IF;
1354: tab_employee(T4ASlip_snm) :=convert_2_xml(substr(l_return,1,20),'snm');
1355:
1356: ----2
1357: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1358: ,'CAEOY_EMPLOYEE_FIRST_NAME');
1359: --bug 13105140
1360: /* IF l_return IS NULL THEN
1361: l_status := FALSE;

Line 1368: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1364:
1365: tab_employee(T4ASlip_gvn_nm) :=convert_2_xml(substr(l_return,1,12),'gvn_nm');
1366:
1367: ----3
1368: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1369: ,'CAEOY_EMPLOYEE_INITIAL');
1370: tab_employee(T4ASlip_init) :=convert_2_xml(substr(l_return,1,1),'init');
1371:
1372: ----4

Line 1373: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1369: ,'CAEOY_EMPLOYEE_INITIAL');
1370: tab_employee(T4ASlip_init) :=convert_2_xml(substr(l_return,1,1),'init');
1371:
1372: ----4
1373: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1374: ,'CAEOY_EMPLOYEE_SIN');
1375: IF l_return IS NULL THEN
1376: tab_employee(T4ASlip_sin) := convert_2_xml('000000000', 'sin');
1377: ELSE

Line 1409: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1405: tab_employee(T4ASlip_pstl_cd) := convert_2_xml(substr(REPLACE(l_postal_code,' ',''),1,10), 'pstl_cd');
1406:
1407: ----12
1408:
1409: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1410: ,'CAEOY_EMPLOYEE_NUMBER');
1411: tab_employee(T4ASlip_rcpnt_nbr) :=convert_2_xml(substr(l_return,1,20),'rcpnt_nbr');
1412:
1413: ----13

Line 1414: l_return := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid

1410: ,'CAEOY_EMPLOYEE_NUMBER');
1411: tab_employee(T4ASlip_rcpnt_nbr) :=convert_2_xml(substr(l_return,1,20),'rcpnt_nbr');
1412:
1413: ----13
1414: l_return := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid
1415: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1416: tab_employee(T4ASlip_bn) :=convert_2_xml(nvl(l_return,' '),'bn');
1417:
1418: ----14

Line 1419: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1415: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1416: tab_employee(T4ASlip_bn) :=convert_2_xml(nvl(l_return,' '),'bn');
1417:
1418: ----14
1419: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1420: ,'CAEOY_T4A_EMPLOYEE_REGISTRATION_NO');
1421: tab_employee(T4ASlip_ppln_dpsp_rgst_nbr) :=convert_2_xml(substr(l_return,1,7),'ppln_dpsp_rgst_nbr');
1422:
1423: ----15

Line 1453: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1449: /*****************************************************************************/
1450: /* T4A_AMT Tags begin */
1451:
1452: ----1
1453: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1454: ,'CAEOY_T4A_BOX16_PER_GRE_YTD');
1455: tab_employee(T4A_AMT_pens_spran_amt) :=convert_2_xml(nvl(l_return,'0'),'pens_spran_amt','C');
1456:
1457: ----2

Line 1458: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1454: ,'CAEOY_T4A_BOX16_PER_GRE_YTD');
1455: tab_employee(T4A_AMT_pens_spran_amt) :=convert_2_xml(nvl(l_return,'0'),'pens_spran_amt','C');
1456:
1457: ----2
1458: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1459: ,'CAEOY_T4A_BOX18_PER_GRE_YTD');
1460: tab_employee(T4A_AMT_lsp_amt) :=convert_2_xml(nvl(l_return,'0'),'lsp_amt','C');
1461:
1462: ----3

Line 1463: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1459: ,'CAEOY_T4A_BOX18_PER_GRE_YTD');
1460: tab_employee(T4A_AMT_lsp_amt) :=convert_2_xml(nvl(l_return,'0'),'lsp_amt','C');
1461:
1462: ----3
1463: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1464: ,'CAEOY_T4A_BOX20_PER_GRE_YTD');
1465: tab_employee(T4A_AMT_self_empl_cmsn_amt) :=convert_2_xml(nvl(l_return,'0'),'self_empl_cmsn_amt','C');
1466:
1467: ----4

Line 1468: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1464: ,'CAEOY_T4A_BOX20_PER_GRE_YTD');
1465: tab_employee(T4A_AMT_self_empl_cmsn_amt) :=convert_2_xml(nvl(l_return,'0'),'self_empl_cmsn_amt','C');
1466:
1467: ----4
1468: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1469: ,'CAEOY_FED_WITHHELD_PER_GRE_YTD');
1470:
1471: tab_employee(T4A_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1472:

Line 1474: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1470:
1471: tab_employee(T4A_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1472:
1473: ----5
1474: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1475: ,'CAEOY_T4A_BOX24_PER_GRE_YTD');
1476: tab_employee(T4A_AMT_annty_amt) :=convert_2_xml(nvl(l_return,'0'),'annty_amt','C');
1477:
1478: ----6

Line 1479: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1475: ,'CAEOY_T4A_BOX24_PER_GRE_YTD');
1476: tab_employee(T4A_AMT_annty_amt) :=convert_2_xml(nvl(l_return,'0'),'annty_amt','C');
1477:
1478: ----6
1479: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1480: ,'CAEOY_T4A_BOX48_PER_GRE_YTD');
1481: tab_employee(T4A_AMT_fee_or_oth_srvc_amt) :=convert_2_xml(nvl(l_return,'0'),'fee_or_oth_srvc_amt','C');
1482:
1483: l_T4A_AMT_xml_string := ''||

Line 1609: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1605: l_other_info_xml_string(4) := ' ';
1606:
1607: FOR i IN 1..tab_other_info_dbi.COUNT LOOP
1608:
1609: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1610: ,tab_other_info_dbi(i));
1611:
1612: IF nvl(l_return,0)<>0 THEN
1613: l_return_xml := convert_2_xml(l_return ,tab_other_info_tag(i),'C');