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_CANCEL_MAG dependencies on PAY_CA_ARCHIVE_UTILS

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

703:
704: -- l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
705: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
706:
707: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
708: 'CAEOY_TRANSMITTER_NUMBER');
709: IF l_return IS NULL THEN
710: l_field_name := l_field_name || 'CAEOY_TRANSMITTER_NUMBER,';
711: l_status := FALSE;

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

719: l_return := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
720: tab_transmitter(T619_sbmt_ref_id)
721: := convert_2_xml(nvl(l_return,' '),'sbmt_ref_id');
722: ----
723: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
724: 'CAEOY_TRANSMITTER_TYPE_INDICATOR');
725: IF l_return IS NULL THEN
726: l_field_name := l_field_name || 'CAEOY_TRANSMITTER_TYPE_INDICATOR,';
727: l_status := FALSE;

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

728: END IF;
729: tab_transmitter(T619_trnmtr_tcd)
730: := convert_2_xml(l_return,'trnmtr_tcd');
731: ----
732: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
733: 'CAEOY_T4A_TOTAL_NO_SUMMARY_COUNT');
734: tab_transmitter(T619_summ_cnt)
735: := convert_2_xml(l_return,'summ_cnt');
736: ----

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

733: 'CAEOY_T4A_TOTAL_NO_SUMMARY_COUNT');
734: tab_transmitter(T619_summ_cnt)
735: := convert_2_xml(l_return,'summ_cnt');
736: ----
737: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
738: 'CAEOY_TRANSMITTER_NAME');
739: tab_transmitter(T619_l1_nm)
740: := convert_2_xml
741: (upper(rpad(substr(l_return,1,30),30)) ,'l1_nm');

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

742: tab_transmitter(T619_l2_nm)
743: := convert_2_xml
744: (upper(rpad(substr(l_return,31,30),30)) ,'l2_nm');
745: ----
746: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
747: 'CAEOY_TRANSMITTER_ADDRESS_LINE1');
748: tab_transmitter(T619_addr_l1_txt)
749: := convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
750: ----

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

747: 'CAEOY_TRANSMITTER_ADDRESS_LINE1');
748: tab_transmitter(T619_addr_l1_txt)
749: := convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
750: ----
751: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
752: 'CAEOY_TRANSMITTER_ADDRESS_LINE2');
753: tab_transmitter(T619_addr_l2_txt)
754: := convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
755: ----

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

752: 'CAEOY_TRANSMITTER_ADDRESS_LINE2');
753: tab_transmitter(T619_addr_l2_txt)
754: := convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
755: ----
756: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
757: 'CAEOY_TRANSMITTER_CITY');
758: tab_transmitter(T619_cty_nm)
759: := convert_2_xml(substr(l_return,1,28),'cty_nm');
760: ----

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

757: 'CAEOY_TRANSMITTER_CITY');
758: tab_transmitter(T619_cty_nm)
759: := convert_2_xml(substr(l_return,1,28),'cty_nm');
760: ----
761: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
762: 'CAEOY_TRANSMITTER_PROVINCE');
763: tab_transmitter(T619_prov_cd)
764: := convert_2_xml(l_return,'prov_cd');
765: ----

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

762: 'CAEOY_TRANSMITTER_PROVINCE');
763: tab_transmitter(T619_prov_cd)
764: := convert_2_xml(l_return,'prov_cd');
765: ----
766: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
767: 'CAEOY_TRANSMITTER_COUNTRY');
768: IF l_return IS NULL THEN
769: tab_transmitter(T619_cntry_cd) := NULL;
770: ELSIF l_return='CA' THEN

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

772: ELSIF l_return='US' THEN
773: tab_transmitter(T619_cntry_cd) := convert_2_xml('USA', 'cntry_cd');
774: END IF;
775: ----
776: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
777: 'CAEOY_TRANSMITTER_POSTAL_CODE');
778: tab_transmitter(T619_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
779: ----
780: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

776: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
777: 'CAEOY_TRANSMITTER_POSTAL_CODE');
778: tab_transmitter(T619_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
779: ----
780: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
781: 'CAEOY_TECHNICAL_CONTACT_NAME');
782: IF l_return IS NULL THEN
783: l_field_name := l_field_name || 'CAEOY_TECHNICAL_CONTACT_NAME,';
784: l_status := FALSE;

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

786: tab_transmitter(T619_cntc_nm)
787: := convert_2_xml(substr(l_return,1,22),'cntc_nm');
788:
789: ----
790: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
791: 'CAEOY_TECHNICAL_CONTACT_AREA_CODE');
792: tab_transmitter(T619_cntc_area_cd)
793: := convert_2_xml(substr(l_return,1,3),'cntc_area_cd');
794: ----

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

791: 'CAEOY_TECHNICAL_CONTACT_AREA_CODE');
792: tab_transmitter(T619_cntc_area_cd)
793: := convert_2_xml(substr(l_return,1,3),'cntc_area_cd');
794: ----
795: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
796: 'CAEOY_TECHNICAL_CONTACT_PHONE');
797: IF l_return IS NULL THEN
798: tab_transmitter(T619_cntc_phn_nbr) := NULL;
799: ELSE

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

804: substr(l_return,4,4),
805: 'cntc_phn_nbr');
806: END IF;
807: ----
808: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
809: 'CAEOY_TECHNICAL_CONTACT_EXTN');
810: IF l_return IS NULL THEN
811: tab_transmitter(T619_cntc_extn_nbr) := NULL;
812: ELSE

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

814: := convert_2_xml(substr(l_return,1,5),
815: 'cntc_extn_nbr');
816: END IF;
817: ----
818: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
819: 'CAEOY_TECHNICAL_CONTACT_EMAIL');
820: IF l_return IS NULL THEN
821: tab_transmitter(T619_cntc_email_area) := NULL;
822: l_field_name := l_field_name || 'CAEOY_TECHNICAL_CONTACT_EMAIL,';

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

829: ----
830: tab_transmitter(T619_rpt_tcd)
831: := convert_2_xml('A','rpt_tcd');
832: ----
833: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
834: 'CAEOY_TECHNICAL_CONTACT_LANGUAGE');
835: tab_transmitter(T619_lang_cd)
836: := convert_2_xml(l_return,'lang_cd');
837: ----

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

835: tab_transmitter(T619_lang_cd)
836: := convert_2_xml(l_return,'lang_cd');
837: ----
838: IF l_status = FALSE THEN
839: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
840: 'CAEOY_TRANSMITTER_NAME');
841: hr_utility.set_location('Error in T4A Transmitter record',10);
842: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
843: hr_utility.trace('Technical contact details missing');

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

968: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
969: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
970: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
971: ----
972: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
973: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
974: tab_employer(T4ASummary_bn):= convert_2_xml(l_return,'bn');
975:
976: ----

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

973: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
974: tab_employer(T4ASummary_bn):= convert_2_xml(l_return,'bn');
975:
976: ----
977: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
978: 'CAEOY_EMPLOYER_NAME');
979: tab_employer(T4ASummary_l1_nm):= convert_2_xml(substr(l_return,1,30),'l1_nm');
980: tab_employer(T4ASummary_l2_nm):= convert_2_xml(substr(l_return,31,30),'l2_nm');
981: tab_employer(T4ASummary_l3_nm):= convert_2_xml(substr(l_return,61,30),'l3_nm');

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

979: tab_employer(T4ASummary_l1_nm):= convert_2_xml(substr(l_return,1,30),'l1_nm');
980: tab_employer(T4ASummary_l2_nm):= convert_2_xml(substr(l_return,31,30),'l2_nm');
981: tab_employer(T4ASummary_l3_nm):= convert_2_xml(substr(l_return,61,30),'l3_nm');
982: ----
983: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
984: 'CAEOY_EMPLOYER_ADDRESS_LINE1');
985: tab_employer(T4ASummary_addr_l1_txt):= convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
986: ----
987: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

983: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
984: 'CAEOY_EMPLOYER_ADDRESS_LINE1');
985: tab_employer(T4ASummary_addr_l1_txt):= convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
986: ----
987: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
988: 'CAEOY_EMPLOYER_ADDRESS_LINE2');
989: tab_employer(T4ASummary_addr_l2_txt):= convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
990: ----
991: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

987: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
988: 'CAEOY_EMPLOYER_ADDRESS_LINE2');
989: tab_employer(T4ASummary_addr_l2_txt):= convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
990: ----
991: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
992: 'CAEOY_EMPLOYER_CITY');
993: tab_employer(T4ASummary_cty_nm):= convert_2_xml(substr(l_return,1,28),'cty_nm');
994: ----
995: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

991: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
992: 'CAEOY_EMPLOYER_CITY');
993: tab_employer(T4ASummary_cty_nm):= convert_2_xml(substr(l_return,1,28),'cty_nm');
994: ----
995: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
996: 'CAEOY_EMPLOYER_PROVINCE');
997: tab_employer(T4ASummary_prov_cd):= convert_2_xml(substr(l_return,1,2),'prov_cd');
998: ----
999: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

995: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
996: 'CAEOY_EMPLOYER_PROVINCE');
997: tab_employer(T4ASummary_prov_cd):= convert_2_xml(substr(l_return,1,2),'prov_cd');
998: ----
999: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1000: 'CAEOY_EMPLOYER_COUNTRY');
1001: IF l_return IS NULL THEN
1002: tab_employer(T4ASummary_cntry_cd) := NULL;
1003: ELSIF l_return ='CA' THEN

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

1005: ELSIF l_return ='US' THEN
1006: tab_employer(T4ASummary_cntry_cd):= convert_2_xml('USA','cntry_cd');
1007: END IF;
1008: ----
1009: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1010: 'CAEOY_EMPLOYER_POSTAL_CODE');
1011: tab_employer(T4ASummary_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
1012: ----
1013: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

1009: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1010: 'CAEOY_EMPLOYER_POSTAL_CODE');
1011: tab_employer(T4ASummary_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
1012: ----
1013: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1014: 'CAEOY_ACCOUNTING_CONTACT_NAME');
1015: IF l_return IS NULL THEN
1016: tab_employer(T4ASummary_cntc_nm):= convert_2_xml(' ', 'cntc_nm');
1017: ELSE

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

1018: tab_employer(T4ASummary_cntc_nm):= convert_2_xml(substr(l_return,1,22)
1019: , 'cntc_nm');
1020: END IF;
1021: ----
1022: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1023: 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
1024: IF l_return IS NULL THEN
1025: tab_employer(T4ASummary_cntc_area_cd):= convert_2_xml(' ', 'cntc_area_cd');
1026: ELSE

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

1027: tab_employer(T4ASummary_cntc_area_cd):= convert_2_xml(substr(l_return,1,22)
1028: , 'cntc_area_cd');
1029: END IF;
1030: ----
1031: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1032: 'CAEOY_ACCOUNTING_CONTACT_PHONE');
1033: IF l_return IS NULL THEN
1034: tab_employer(T4ASummary_cntc_phn_nbr):= convert_2_xml('000-0000 ', 'cntc_phn_nbr');
1035: ELSE

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

1038: tab_employer(T4ASummary_cntc_phn_nbr):= convert_2_xml(substr(l_return,1,3)||'-'||substr(l_return,4,4)
1039: , 'cntc_phn_nbr');
1040: END IF;
1041: ----
1042: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1043: 'CAEOY_ACCOUNTING_CONTACT_EXTENSION');
1044: IF l_return IS NULL THEN
1045: tab_employer(T4ASummary_cntc_extn_nbr):= convert_2_xml(' ', 'cntc_extn_nbr');
1046: ELSE

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

1047: tab_employer(T4ASummary_cntc_extn_nbr):= convert_2_xml(substr(l_return,1,5)
1048: , 'cntc_extn_nbr');
1049: END IF;
1050: ----
1051: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1052: 'CAEOY_TAXATION_YEAR');
1053: tab_employer(T4ASummary_tx_yr):= convert_2_xml(l_return, 'tx_yr');
1054: ----
1055:

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

1065: ,'rpp_rgst_2_nbr');
1066: tab_employer(T4ASummary_rpp_rgst_3_nbr) := convert_2_xml(substr(lv_ppreg_no3,1,7)
1067: ,'rpp_rgst_3_nbr');
1068: ----
1069: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1070: 'CAEOY_PROPRIETOR_SIN1');
1071: -- 11074583 start
1072: if trim(l_return) IS NULL then
1073: l_return := lpad('0',9,'0');

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

1074: end if;
1075: -- 11074583 end
1076: tab_employer(T4ASummary_pprtr_1_sin):= convert_2_xml(substr(REPLACE(l_return,' ',''),1,9), 'pprtr_1_sin');
1077: ----
1078: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1079: 'CAEOY_PROPRIETOR_SIN2');
1080: -- 11074583 start
1081: if trim(l_return) IS NULL then
1082: l_return := lpad('0',9,'0');

Line 1257: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1253: CLOSE c_get_payroll_asg_actid;
1254: hr_utility.trace('Archiver Assignment action='|| l_arch_action_id);
1255: hr_utility.trace('Archiver Payroll action='|| l_arch_pay_actid);
1256: ----
1257: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1258: ,'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');
1259:
1260: IF(l_return='Y') THEN
1261: l_status := FALSE;

Line 1281: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1277: l_postal_code,
1278: l_country,
1279: l_emp_province);
1280:
1281: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1282: ,'CAEOY_EMPLOYEE_LAST_NAME');
1283: IF l_return IS NULL THEN
1284: l_status := FALSE;
1285: l_error_message := l_error_message||'Blank Last Name ';

Line 1290: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1286: END IF;
1287: tab_employee(T4ASlip_snm) :=convert_2_xml(substr(l_return,1,20),'snm');
1288:
1289: ----2
1290: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1291: ,'CAEOY_EMPLOYEE_FIRST_NAME');
1292: --bug 13105140
1293: /* IF l_return IS NULL THEN
1294: l_status := FALSE;

Line 1301: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1297:
1298: tab_employee(T4ASlip_gvn_nm) :=convert_2_xml(substr(l_return,1,12),'gvn_nm');
1299:
1300: ----3
1301: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1302: ,'CAEOY_EMPLOYEE_INITIAL');
1303: tab_employee(T4ASlip_init) :=convert_2_xml(substr(l_return,1,1),'init');
1304:
1305: ----4

Line 1306: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1302: ,'CAEOY_EMPLOYEE_INITIAL');
1303: tab_employee(T4ASlip_init) :=convert_2_xml(substr(l_return,1,1),'init');
1304:
1305: ----4
1306: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1307: ,'CAEOY_EMPLOYEE_SIN');
1308: IF l_return IS NULL THEN
1309: tab_employee(T4ASlip_sin) := convert_2_xml('000000000', 'sin');
1310: ELSE

Line 1342: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1338: tab_employee(T4ASlip_pstl_cd) := convert_2_xml(substr(REPLACE(l_postal_code,' ',''),1,10), 'pstl_cd');
1339:
1340: ----12
1341:
1342: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1343: ,'CAEOY_EMPLOYEE_NUMBER');
1344: tab_employee(T4ASlip_rcpnt_nbr) :=convert_2_xml(substr(l_return,1,20),'rcpnt_nbr');
1345:
1346: ----13

Line 1347: l_return := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid

1343: ,'CAEOY_EMPLOYEE_NUMBER');
1344: tab_employee(T4ASlip_rcpnt_nbr) :=convert_2_xml(substr(l_return,1,20),'rcpnt_nbr');
1345:
1346: ----13
1347: l_return := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid
1348: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1349: tab_employee(T4ASlip_bn) :=convert_2_xml(nvl(l_return,' '),'bn');
1350:
1351: ----14

Line 1352: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1348: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1349: tab_employee(T4ASlip_bn) :=convert_2_xml(nvl(l_return,' '),'bn');
1350:
1351: ----14
1352: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1353: ,'CAEOY_T4A_EMPLOYEE_REGISTRATION_NO');
1354: tab_employee(T4ASlip_ppln_dpsp_rgst_nbr) :=convert_2_xml(substr(l_return,1,7),'ppln_dpsp_rgst_nbr');
1355:
1356: ----15

Line 1386: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1382: /*****************************************************************************/
1383: /* T4A_AMT Tags begin */
1384:
1385: ----1
1386: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1387: ,'CAEOY_T4A_BOX16_PER_GRE_YTD');
1388: tab_employee(T4A_AMT_pens_spran_amt) :=convert_2_xml(nvl(l_return,'0'),'pens_spran_amt','C');
1389:
1390: ----2

Line 1391: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1387: ,'CAEOY_T4A_BOX16_PER_GRE_YTD');
1388: tab_employee(T4A_AMT_pens_spran_amt) :=convert_2_xml(nvl(l_return,'0'),'pens_spran_amt','C');
1389:
1390: ----2
1391: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1392: ,'CAEOY_T4A_BOX18_PER_GRE_YTD');
1393: tab_employee(T4A_AMT_lsp_amt) :=convert_2_xml(nvl(l_return,'0'),'lsp_amt','C');
1394:
1395: ----3

Line 1396: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1392: ,'CAEOY_T4A_BOX18_PER_GRE_YTD');
1393: tab_employee(T4A_AMT_lsp_amt) :=convert_2_xml(nvl(l_return,'0'),'lsp_amt','C');
1394:
1395: ----3
1396: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1397: ,'CAEOY_T4A_BOX20_PER_GRE_YTD');
1398: tab_employee(T4A_AMT_self_empl_cmsn_amt) :=convert_2_xml(nvl(l_return,'0'),'self_empl_cmsn_amt','C');
1399:
1400: ----4

Line 1401: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1397: ,'CAEOY_T4A_BOX20_PER_GRE_YTD');
1398: tab_employee(T4A_AMT_self_empl_cmsn_amt) :=convert_2_xml(nvl(l_return,'0'),'self_empl_cmsn_amt','C');
1399:
1400: ----4
1401: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1402: ,'CAEOY_FED_WITHHELD_PER_GRE_YTD');
1403:
1404: tab_employee(T4A_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1405:

Line 1407: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1403:
1404: tab_employee(T4A_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1405:
1406: ----5
1407: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1408: ,'CAEOY_T4A_BOX24_PER_GRE_YTD');
1409: tab_employee(T4A_AMT_annty_amt) :=convert_2_xml(nvl(l_return,'0'),'annty_amt','C');
1410:
1411: ----6

Line 1412: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1408: ,'CAEOY_T4A_BOX24_PER_GRE_YTD');
1409: tab_employee(T4A_AMT_annty_amt) :=convert_2_xml(nvl(l_return,'0'),'annty_amt','C');
1410:
1411: ----6
1412: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1413: ,'CAEOY_T4A_BOX48_PER_GRE_YTD');
1414: tab_employee(T4A_AMT_fee_or_oth_srvc_amt) :=convert_2_xml(nvl(l_return,'0'),'fee_or_oth_srvc_amt','C');
1415:
1416: l_T4A_AMT_xml_string := ''||

Line 1542: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1538: l_other_info_xml_string(4) := ' ';
1539:
1540: FOR i IN 1..tab_other_info_dbi.COUNT LOOP
1541:
1542: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1543: ,tab_other_info_dbi(i));
1544:
1545: IF nvl(l_return,0)<>0 THEN
1546: l_return_xml := convert_2_xml(l_return ,tab_other_info_tag(i),'C');