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

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

709: end;
710:
711: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
712:
713: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
714: 'CAEOY_TRANSMITTER_NUMBER');
715: IF l_return IS NULL THEN
716: l_field_name := l_field_name || 'CAEOY_TRANSMITTER_NUMBER,';
717: l_status := FALSE;

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

725: l_return := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
726: tab_transmitter(T619_sbmt_ref_id)
727: := convert_2_xml(nvl(l_return,' '),'sbmt_ref_id');
728: ----
729: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
730: 'CAEOY_TRANSMITTER_TYPE_INDICATOR');
731: IF l_return IS NULL THEN
732: l_field_name := l_field_name || 'CAEOY_TRANSMITTER_TYPE_INDICATOR,';
733: l_status := FALSE;

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

734: END IF;
735: tab_transmitter(T619_trnmtr_tcd)
736: := convert_2_xml(l_return,'trnmtr_tcd');
737: ----
738: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
739: 'CAEOY_T4_TOTAL_NO_SUMMARY_COUNT');
740: tab_transmitter(T619_summ_cnt)
741: := convert_2_xml(l_return,'summ_cnt');
742: ----

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

739: 'CAEOY_T4_TOTAL_NO_SUMMARY_COUNT');
740: tab_transmitter(T619_summ_cnt)
741: := convert_2_xml(l_return,'summ_cnt');
742: ----
743: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
744: 'CAEOY_TRANSMITTER_NAME');
745: tab_transmitter(T619_l1_nm)
746: := convert_2_xml
747: (upper(rpad(substr(l_return,1,30),30)) ,'l1_nm');

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

748: tab_transmitter(T619_l2_nm)
749: := convert_2_xml
750: (upper(rpad(substr(l_return,31,30),30)) ,'l2_nm');
751: ----
752: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
753: 'CAEOY_TRANSMITTER_ADDRESS_LINE1');
754: tab_transmitter(T619_addr_l1_txt)
755: := convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
756: ----

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

753: 'CAEOY_TRANSMITTER_ADDRESS_LINE1');
754: tab_transmitter(T619_addr_l1_txt)
755: := convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
756: ----
757: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
758: 'CAEOY_TRANSMITTER_ADDRESS_LINE2');
759: tab_transmitter(T619_addr_l2_txt)
760: := convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
761: ----

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

758: 'CAEOY_TRANSMITTER_ADDRESS_LINE2');
759: tab_transmitter(T619_addr_l2_txt)
760: := convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
761: ----
762: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
763: 'CAEOY_TRANSMITTER_CITY');
764: tab_transmitter(T619_cty_nm)
765: := convert_2_xml(substr(l_return,1,28),'cty_nm');
766: ----

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

763: 'CAEOY_TRANSMITTER_CITY');
764: tab_transmitter(T619_cty_nm)
765: := convert_2_xml(substr(l_return,1,28),'cty_nm');
766: ----
767: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
768: 'CAEOY_TRANSMITTER_PROVINCE');
769: tab_transmitter(T619_prov_cd)
770: := convert_2_xml(l_return,'prov_cd');
771: ----

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

768: 'CAEOY_TRANSMITTER_PROVINCE');
769: tab_transmitter(T619_prov_cd)
770: := convert_2_xml(l_return,'prov_cd');
771: ----
772: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
773: 'CAEOY_TRANSMITTER_COUNTRY');
774: IF l_return IS NULL THEN
775: tab_transmitter(T619_cntry_cd) := NULL;
776: ELSIF l_return='CA' THEN

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

778: ELSIF l_return='US' THEN
779: tab_transmitter(T619_cntry_cd) := convert_2_xml('USA', 'cntry_cd');
780: END IF;
781: ----
782: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
783: 'CAEOY_TRANSMITTER_POSTAL_CODE');
784: tab_transmitter(T619_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
785: ----
786: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

782: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
783: 'CAEOY_TRANSMITTER_POSTAL_CODE');
784: tab_transmitter(T619_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
785: ----
786: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
787: 'CAEOY_TECHNICAL_CONTACT_NAME');
788: IF l_return IS NULL THEN
789: l_field_name := l_field_name || 'CAEOY_TECHNICAL_CONTACT_NAME,';
790: l_status := FALSE;

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

792: tab_transmitter(T619_cntc_nm)
793: := convert_2_xml(substr(l_return,1,22),'cntc_nm');
794:
795: ----
796: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
797: 'CAEOY_TECHNICAL_CONTACT_AREA_CODE');
798: tab_transmitter(T619_cntc_area_cd)
799: := convert_2_xml(substr(l_return,1,3),'cntc_area_cd');
800: ----

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

797: 'CAEOY_TECHNICAL_CONTACT_AREA_CODE');
798: tab_transmitter(T619_cntc_area_cd)
799: := convert_2_xml(substr(l_return,1,3),'cntc_area_cd');
800: ----
801: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
802: 'CAEOY_TECHNICAL_CONTACT_PHONE');
803: IF l_return IS NULL THEN
804: tab_transmitter(T619_cntc_phn_nbr) := NULL;
805: ELSE

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

810: substr(l_return,4,4),
811: 'cntc_phn_nbr');
812: END IF;
813: ----
814: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
815: 'CAEOY_TECHNICAL_CONTACT_EXTN');
816: IF l_return IS NULL THEN
817: tab_transmitter(T619_cntc_extn_nbr) := NULL;
818: ELSE

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

820: := convert_2_xml(substr(l_return,1,5),
821: 'cntc_extn_nbr');
822: END IF;
823: ----
824: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
825: 'CAEOY_TECHNICAL_CONTACT_EMAIL');
826: IF l_return IS NULL THEN
827: tab_transmitter(T619_cntc_email_area) := NULL;
828: l_field_name := l_field_name || 'CAEOY_TECHNICAL_CONTACT_EMAIL,';

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

835: ----
836: tab_transmitter(T619_rpt_tcd)
837: := convert_2_xml('A','rpt_tcd'); -- A -> Cancel
838: ----
839: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
840: 'CAEOY_TECHNICAL_CONTACT_LANGUAGE');
841: tab_transmitter(T619_lang_cd)
842: := convert_2_xml(l_return,'lang_cd');
843: ----

Line 973: l_return := pay_ca_archive_utils.get_archive_value(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: hr_utility.trace('TRANSFER_EI_ER_RATE l_transfer_ei_er_rate = ' ||l_transfer_ei_er_rate);
972: ----
973: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
974: 'CAEOY_GRE_EI_RATE');
975: hr_utility.trace('CAEOY_GRE_EI_RATE = ' ||l_return);
976: IF (l_return IS NULL) OR (to_number(l_return) = 0) THEN
977: tab_employer(EIRate):= convert_2_xml(l_transfer_ei_er_rate,'EIRate');

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

979: tab_employer(EIRate):= convert_2_xml(l_return,'EIRate');
980: END IF;
981: -- EIRate is an internal tag used for muliplying in XSL for last T4Summary tag tot_empr_eip_amt
982: ----
983: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
984: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
985: tab_employer(T4Summary_bn):= convert_2_xml(l_return,'bn');
986:
987: ----

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

984: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
985: tab_employer(T4Summary_bn):= convert_2_xml(l_return,'bn');
986:
987: ----
988: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
989: 'CAEOY_EMPLOYER_NAME');
990: tab_employer(T4Summary_l1_nm):= convert_2_xml(substr(l_return,1,30),'l1_nm');
991: tab_employer(T4Summary_l2_nm):= convert_2_xml(substr(l_return,31,30),'l2_nm');
992: tab_employer(T4Summary_l3_nm):= convert_2_xml(substr(l_return,61,30),'l3_nm');

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

990: tab_employer(T4Summary_l1_nm):= convert_2_xml(substr(l_return,1,30),'l1_nm');
991: tab_employer(T4Summary_l2_nm):= convert_2_xml(substr(l_return,31,30),'l2_nm');
992: tab_employer(T4Summary_l3_nm):= convert_2_xml(substr(l_return,61,30),'l3_nm');
993: ----
994: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
995: 'CAEOY_EMPLOYER_ADDRESS_LINE1');
996: tab_employer(T4Summary_addr_l1_txt):= convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
997: ----
998: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

994: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
995: 'CAEOY_EMPLOYER_ADDRESS_LINE1');
996: tab_employer(T4Summary_addr_l1_txt):= convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
997: ----
998: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
999: 'CAEOY_EMPLOYER_ADDRESS_LINE2');
1000: tab_employer(T4Summary_addr_l2_txt):= convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
1001: ----
1002: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

998: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
999: 'CAEOY_EMPLOYER_ADDRESS_LINE2');
1000: tab_employer(T4Summary_addr_l2_txt):= convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
1001: ----
1002: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1003: 'CAEOY_EMPLOYER_CITY');
1004: tab_employer(T4Summary_cty_nm):= convert_2_xml(substr(l_return,1,28),'cty_nm');
1005: ----
1006: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

1002: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1003: 'CAEOY_EMPLOYER_CITY');
1004: tab_employer(T4Summary_cty_nm):= convert_2_xml(substr(l_return,1,28),'cty_nm');
1005: ----
1006: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1007: 'CAEOY_EMPLOYER_PROVINCE');
1008: tab_employer(T4Summary_prov_cd):= convert_2_xml(substr(l_return,1,2),'prov_cd');
1009: ----
1010: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

1006: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1007: 'CAEOY_EMPLOYER_PROVINCE');
1008: tab_employer(T4Summary_prov_cd):= convert_2_xml(substr(l_return,1,2),'prov_cd');
1009: ----
1010: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1011: 'CAEOY_EMPLOYER_COUNTRY');
1012: IF l_return IS NULL THEN
1013: tab_employer(T4Summary_cntry_cd) := NULL;
1014: ELSIF l_return ='CA' THEN

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

1016: ELSIF l_return ='US' THEN
1017: tab_employer(T4Summary_cntry_cd):= convert_2_xml('USA','cntry_cd');
1018: END IF;
1019: ----
1020: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1021: 'CAEOY_EMPLOYER_POSTAL_CODE');
1022: tab_employer(T4Summary_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
1023: ----
1024: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

1020: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1021: 'CAEOY_EMPLOYER_POSTAL_CODE');
1022: tab_employer(T4Summary_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
1023: ----
1024: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1025: 'CAEOY_ACCOUNTING_CONTACT_NAME');
1026: IF l_return IS NULL THEN
1027: tab_employer(T4Summary_cntc_nm):= convert_2_xml(' ', 'cntc_nm');
1028: ELSE

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

1029: tab_employer(T4Summary_cntc_nm):= convert_2_xml(substr(l_return,1,22)
1030: , 'cntc_nm');
1031: END IF;
1032: ----
1033: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1034: 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
1035: IF l_return IS NULL THEN
1036: tab_employer(T4Summary_cntc_area_cd):= convert_2_xml(' ', 'cntc_area_cd');
1037: ELSE

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

1038: tab_employer(T4Summary_cntc_area_cd):= convert_2_xml(substr(l_return,1,3)
1039: , 'cntc_area_cd');
1040: END IF;
1041: ----
1042: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1043: 'CAEOY_ACCOUNTING_CONTACT_PHONE');
1044: IF l_return IS NULL THEN
1045: tab_employer(T4Summary_cntc_phn_nbr):= convert_2_xml('000-0000 ', 'cntc_phn_nbr');
1046: ELSE

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

1049: tab_employer(T4Summary_cntc_phn_nbr):= convert_2_xml(substr(l_return,1,3)||'-'||substr(l_return,4,4)
1050: , 'cntc_phn_nbr');
1051: END IF;
1052: ----
1053: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1054: 'CAEOY_ACCOUNTING_CONTACT_EXTENSION');
1055: IF l_return IS NULL THEN
1056: tab_employer(T4Summary_cntc_extn_nbr):= convert_2_xml(' ', 'cntc_extn_nbr');
1057: ELSE

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

1058: tab_employer(T4Summary_cntc_extn_nbr):= convert_2_xml(substr(l_return,1,5)
1059: , 'cntc_extn_nbr');
1060: END IF;
1061: ----
1062: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1063: 'CAEOY_TAXATION_YEAR');
1064: tab_employer(T4Summary_tx_yr):= convert_2_xml(l_return, 'tx_yr');
1065: ----
1066:

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

1063: 'CAEOY_TAXATION_YEAR');
1064: tab_employer(T4Summary_tx_yr):= convert_2_xml(l_return, 'tx_yr');
1065: ----
1066:
1067: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1068: 'CAEOY_PROPRIETOR_SIN1');
1069: -- 11074583 start
1070: if trim(l_return) IS NULL then
1071: l_return := lpad('0',9,'0');

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

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

Line 1435: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1431: l_arch_pay_actid
1432: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1433: */
1434: ----
1435: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1436: ,'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
1437:
1438: IF(l_return='Y') THEN
1439: l_status := FALSE;

Line 1458: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1454: l_city,
1455: l_postal_code,
1456: l_country,
1457: l_emp_province);
1458: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1459: ,'CAEOY_EMPLOYEE_LAST_NAME');
1460: IF l_return IS NULL THEN
1461: l_name_status := FALSE;
1462: l_name_error_message := l_name_error_message||'Blank Last Name ';

Line 1467: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1463: END IF;
1464: tab_employee_common(T4Slip_snm) :=convert_2_xml(substr(l_return,1,20),'snm');
1465:
1466: ----2
1467: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1468: ,'CAEOY_EMPLOYEE_FIRST_NAME');
1469: -- bug 13105140
1470: /* IF l_return IS NULL THEN
1471: l_name_status := FALSE;

Line 1478: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1474:
1475: tab_employee_common(T4Slip_gvn_nm) :=convert_2_xml(substr(l_return,1,12),'gvn_nm');
1476:
1477: ----3
1478: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1479: ,'CAEOY_EMPLOYEE_INITIAL');
1480: tab_employee_common(T4Slip_init) :=convert_2_xml(substr(l_return,1,1),'init');
1481:
1482: ----4,5

Line 1505: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1501: ----9
1502: tab_employee_common(T4Slip_pstl_cd) := convert_2_xml(substr(REPLACE(l_postal_code,' ',''),1,10), 'pstl_cd');
1503:
1504: ----10
1505: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1506: ,'CAEOY_EMPLOYEE_SIN');
1507: IF l_return IS NULL THEN
1508: tab_employee_common(T4Slip_sin) := convert_2_xml('000000000', 'sin');
1509: ELSE

Line 1515: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1511: END IF;
1512:
1513: ----11
1514:
1515: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1516: ,'CAEOY_EMPLOYEE_NUMBER');
1517: tab_employee_common(T4Slip_empe_nbr) :=convert_2_xml(substr(l_return,1,20),'empe_nbr');
1518:
1519: ----12

Line 1520: l_return := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid

1516: ,'CAEOY_EMPLOYEE_NUMBER');
1517: tab_employee_common(T4Slip_empe_nbr) :=convert_2_xml(substr(l_return,1,20),'empe_nbr');
1518:
1519: ----12
1520: l_return := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid
1521: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1522: tab_employee_common(T4Slip_bn) :=convert_2_xml(substr(nvl(l_return,' '),1,15),'bn');
1523:
1524: ----13

Line 1525: /* l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1521: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1522: tab_employee_common(T4Slip_bn) :=convert_2_xml(substr(nvl(l_return,' '),1,15),'bn');
1523:
1524: ----13
1525: /* l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1526: ,'CAEOY_T4_EMPLOYEE_REGISTRATION_NO');
1527: tab_employee_common(T4Slip_rpp_dpsp_rgst_nbr) :=convert_2_xml(substr(l_return,1,7),'rpp_dpsp_rgst_nbr');
1528: */
1529:

Line 1566: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id, l_jurisdiction_code,

1562: l_final_xml_string:=' ';
1563: tab_employee.DELETE;
1564:
1565: -- JURISDICTION_CODE context added for bug 13427161
1566: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id, l_jurisdiction_code,
1567: 'JURISDICTION_CODE',
1568: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO');
1569: tab_employee_common(T4Slip_rpp_dpsp_rgst_nbr) :=convert_2_xml(substr(l_return,1,7),'rpp_dpsp_rgst_nbr');
1570:

Line 1572: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1568: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO');
1569: tab_employee_common(T4Slip_rpp_dpsp_rgst_nbr) :=convert_2_xml(substr(l_return,1,7),'rpp_dpsp_rgst_nbr');
1570:
1571: ----
1572: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1573: ,l_jurisdiction_code,'JURISDICTION_CODE'
1574: ,'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
1575: IF(l_return='Y') THEN
1576: l_status := FALSE;

Line 1581: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1577: l_error_message := l_error_message||hr_general.decode_lookup('PAY_CA_MAG_EXCEPTIONS','NEG');
1578: END IF;
1579:
1580: ---14
1581: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1582: ,l_jurisdiction_code,'JURISDICTION_CODE'
1583: ,'CAEOY_CPP_QPP_EXEMPT');
1584:
1585: IF l_return IS NULL THEN

Line 1592: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1588: tab_employee(T4Slip_cpp_qpp_xmpt_cd) := convert_2_xml('1','cpp_qpp_xmpt_cd');
1589: END IF;
1590:
1591: ---15
1592: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1593: ,l_jurisdiction_code,'JURISDICTION_CODE'
1594: ,'CAEOY_EI_EXEMPT');
1595:
1596: IF l_return IS NULL THEN

Line 1603: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1599: tab_employee(T4Slip_ei_xmpt_cd) := convert_2_xml('1','ei_xmpt_cd');
1600: END IF;
1601:
1602: ---16
1603: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1604: ,l_jurisdiction_code,'JURISDICTION_CODE'
1605: ,'CAEOY_PPIP_EXEMPT');
1606:
1607: IF l_return IS NULL THEN

Line 1614: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1610: tab_employee(T4Slip_prov_pip_xmpt_cd) := convert_2_xml('1','prov_pip_xmpt_cd');
1611: END IF;
1612:
1613: ----17
1614: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1615: ,l_jurisdiction_code,'JURISDICTION_CODE'
1616: ,'CAEOY_EMPLOYMENT_CODE');
1617:
1618: tab_employee(T4Slip_empt_cd) := convert_2_xml(substr(nvl(l_return,' '),1,2),'empt_cd');

Line 1624: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1620: ----18
1621: tab_employee(T4Slip_rpt_tcd) := convert_2_xml('C', 'rpt_tcd'); --Cancellation
1622:
1623: ----19
1624: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1625: ,l_jurisdiction_code,'JURISDICTION_CODE'
1626: ,'CAEOY_PROVINCE_OF_EMPLOYMENT');
1627:
1628: IF l_return = 'NF' THEN

Line 1665: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1661: /*****************************************************************************/
1662: /* T4_AMT Tags begin */
1663:
1664: ----1
1665: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1666: ,l_jurisdiction_code,'JURISDICTION_CODE'
1667: ,'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD');
1668: l_return2 := l_return; --Used in 7 and 8
1669: tab_employee(T4_AMT_empt_incamt) :=convert_2_xml(nvl(l_return,'0'),'empt_incamt','C');

Line 1672: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1668: l_return2 := l_return; --Used in 7 and 8
1669: tab_employee(T4_AMT_empt_incamt) :=convert_2_xml(nvl(l_return,'0'),'empt_incamt','C');
1670:
1671: ----2
1672: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1673: ,l_jurisdiction_code,'JURISDICTION_CODE'
1674: ,'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD');
1675: tab_employee(T4_AMT_cpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'cpp_cntrb_amt','C');
1676:

Line 1678: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1674: ,'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD');
1675: tab_employee(T4_AMT_cpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'cpp_cntrb_amt','C');
1676:
1677: ----3
1678: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1679: ,l_jurisdiction_code,'JURISDICTION_CODE'
1680: ,'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD');
1681: tab_employee(T4_AMT_qpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'qpp_cntrb_amt','C');
1682:

Line 1684: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1680: ,'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD');
1681: tab_employee(T4_AMT_qpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'qpp_cntrb_amt','C');
1682:
1683: ----4
1684: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1685: ,l_jurisdiction_code,'JURISDICTION_CODE'
1686: ,'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD');
1687: tab_employee(T4_AMT_empe_eip_amt) :=convert_2_xml(nvl(l_return,'0'),'empe_eip_amt','C');
1688:

Line 1690: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1686: ,'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD');
1687: tab_employee(T4_AMT_empe_eip_amt) :=convert_2_xml(nvl(l_return,'0'),'empe_eip_amt','C');
1688:
1689: /* Bug 15953807 */
1690: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1691: ,l_jurisdiction_code,'JURISDICTION_CODE'
1692: ,'CAEOY_EI_ER_LIABILITY_PER_JD_GRE_YTD');
1693: tab_employee(T4_AMT_empr_eip_amt) :=convert_2_xml(nvl(l_return,'0'),'empr_eip_amt','C');
1694: /* Bug 15953807 */

Line 1697: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1693: tab_employee(T4_AMT_empr_eip_amt) :=convert_2_xml(nvl(l_return,'0'),'empr_eip_amt','C');
1694: /* Bug 15953807 */
1695:
1696: ----5
1697: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1698: ,l_jurisdiction_code,'JURISDICTION_CODE'
1699: ,'CAEOY_T4_BOX20_PER_JD_GRE_YTD');
1700: tab_employee(T4_AMT_rpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'rpp_cntrb_amt','C');
1701:

Line 1703: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1699: ,'CAEOY_T4_BOX20_PER_JD_GRE_YTD');
1700: tab_employee(T4_AMT_rpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'rpp_cntrb_amt','C');
1701:
1702: ----6
1703: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1704: ,l_jurisdiction_code,'JURISDICTION_CODE'
1705: ,'CAEOY_FED_WITHHELD_PER_JD_GRE_YTD');
1706: tab_employee(T4_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1707:

Line 1709: lv_year := pay_ca_archive_utils.get_archive_value(

1705: ,'CAEOY_FED_WITHHELD_PER_JD_GRE_YTD');
1706: tab_employee(T4_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1707:
1708: ----7
1709: lv_year := pay_ca_archive_utils.get_archive_value(
1710: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),
1711: 'CAEOY_TAXATION_YEAR'); -- bug 13087483
1712: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1713: ,l_jurisdiction_code,'JURISDICTION_CODE'

Line 1712: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1708: ----7
1709: lv_year := pay_ca_archive_utils.get_archive_value(
1710: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),
1711: 'CAEOY_TAXATION_YEAR'); -- bug 13087483
1712: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1713: ,l_jurisdiction_code,'JURISDICTION_CODE'
1714: ,'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD');
1715:
1716: -- if condition added for bug 13087483

Line 1731: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1727: END IF;
1728:
1729: ----8
1730:
1731: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1732: ,l_jurisdiction_code,'JURISDICTION_CODE'
1733: ,'CAEOY_CPP_EE_TAXABLE_PER_JD_GRE_YTD');
1734: IF to_number(l_return) = 0 THEN
1735: /* 'CAEOY_QPP_EE_RSUBJECT_PER_JD_GRE_YTD' contains exact value of QPP amount

Line 1739: /*l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1735: /* 'CAEOY_QPP_EE_RSUBJECT_PER_JD_GRE_YTD' contains exact value of QPP amount
1736: 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD' contains exact value of QPP if
1737: it is not more than max limit other wise it contains max limit
1738: */
1739: /*l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1740: ,l_jurisdiction_code,'JURISDICTION_CODE'
1741: ,'CAEOY_QPP_EE_RSUBJECT_PER_JD_GRE_YTD');*/
1742:
1743: l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id

Line 1743: l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1739: /*l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1740: ,l_jurisdiction_code,'JURISDICTION_CODE'
1741: ,'CAEOY_QPP_EE_RSUBJECT_PER_JD_GRE_YTD');*/
1742:
1743: l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1744: ,l_jurisdiction_code,'JURISDICTION_CODE'
1745: ,'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD');
1746: -- if condition added for bug 13087483
1747: IF to_number(ltrim(rtrim(lv_year))) < 2011 then

Line 1774: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1770: END IF;
1771: END IF;
1772:
1773: ----9
1774: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1775: ,l_jurisdiction_code,'JURISDICTION_CODE'
1776: ,'CAEOY_T4_BOX44_PER_JD_GRE_YTD');
1777: tab_employee(T4_AMT_unn_dues_amt) :=convert_2_xml(nvl(l_return,'0'),'unn_dues_amt','C');
1778:

Line 1780: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1776: ,'CAEOY_T4_BOX44_PER_JD_GRE_YTD');
1777: tab_employee(T4_AMT_unn_dues_amt) :=convert_2_xml(nvl(l_return,'0'),'unn_dues_amt','C');
1778:
1779: ----10
1780: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1781: ,l_jurisdiction_code,'JURISDICTION_CODE'
1782: ,'CAEOY_T4_BOX46_PER_JD_GRE_YTD');
1783:
1784: tab_employee(T4_AMT_chrty_dons_amt) :=convert_2_xml(nvl(l_return,'0'),'chrty_dons_amt','C');

Line 1787: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1783:
1784: tab_employee(T4_AMT_chrty_dons_amt) :=convert_2_xml(nvl(l_return,'0'),'chrty_dons_amt','C');
1785:
1786: ----11
1787: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1788: ,l_jurisdiction_code,'JURISDICTION_CODE'
1789: ,'CAEOY_T4_BOX52_PER_JD_GRE_YTD');
1790: tab_employee(T4_AMT_padj_amt) :=convert_2_xml(nvl(l_return,'0'),'padj_amt','C');
1791:

Line 1793: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1789: ,'CAEOY_T4_BOX52_PER_JD_GRE_YTD');
1790: tab_employee(T4_AMT_padj_amt) :=convert_2_xml(nvl(l_return,'0'),'padj_amt','C');
1791:
1792: ----12
1793: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1794: ,l_jurisdiction_code,'JURISDICTION_CODE'
1795: ,'CAEOY_PPIP_EE_WITHHELD_PER_JD_GRE_YTD');
1796: tab_employee(T4_AMT_prov_pip_amt) :=convert_2_xml(nvl(l_return,'0'),'prov_pip_amt','C');
1797:

Line 1800: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1796: tab_employee(T4_AMT_prov_pip_amt) :=convert_2_xml(nvl(l_return,'0'),'prov_pip_amt','C');
1797:
1798:
1799: ----13
1800: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1801: ,l_jurisdiction_code,'JURISDICTION_CODE'
1802: ,'CAEOY_PPIP_EE_TAXABLE_PER_JD_GRE_YTD');
1803: IF to_number(l_return) = to_number(l_return2)
1804: OR to_number(l_return) >= to_number(transfer_ppip_max)

Line 1839: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1835:
1836:
1837: FOR i IN 1..tab_other_info_dbi.COUNT LOOP
1838:
1839: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1840: ,l_jurisdiction_code,'JURISDICTION_CODE'
1841: ,tab_other_info_dbi(i));
1842:
1843: IF nvl(l_return,0)<>0 THEN