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

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

766:
767: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
768: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
769:
770: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
771: 'CAEOY_TRANSMITTER_NUMBER');
772: IF l_return IS NULL THEN
773: l_field_name := l_field_name || 'CAEOY_TRANSMITTER_NUMBER,';
774: l_status := FALSE;

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

780: l_return := pay_magtape_generic.get_parameter_value('SBMT_REF_ID');
781: tab_transmitter(T619_sbmt_ref_id)
782: := convert_2_xml(nvl(l_return,' '),'sbmt_ref_id');
783: ----
784: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
785: 'CAEOY_TRANSMITTER_TYPE_INDICATOR');
786: IF l_return IS NULL THEN
787: l_field_name := l_field_name || 'CAEOY_TRANSMITTER_TYPE_INDICATOR,';
788: l_status := FALSE;

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

789: END IF;
790: tab_transmitter(T619_trnmtr_tcd)
791: := convert_2_xml(l_return,'trnmtr_tcd');
792: ----
793: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
794: 'CAEOY_T4_TOTAL_NO_SUMMARY_COUNT');
795: tab_transmitter(T619_summ_cnt)
796: := convert_2_xml(l_return,'summ_cnt');
797: ----

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

794: 'CAEOY_T4_TOTAL_NO_SUMMARY_COUNT');
795: tab_transmitter(T619_summ_cnt)
796: := convert_2_xml(l_return,'summ_cnt');
797: ----
798: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
799: 'CAEOY_TRANSMITTER_NAME');
800: tab_transmitter(T619_l1_nm)
801: := convert_2_xml
802: (upper(rpad(substr(l_return,1,30),30)) ,'l1_nm');

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

803: tab_transmitter(T619_l2_nm)
804: := convert_2_xml
805: (upper(rpad(substr(l_return,31,30),30)) ,'l2_nm');
806: ----
807: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
808: 'CAEOY_TRANSMITTER_ADDRESS_LINE1');
809: tab_transmitter(T619_addr_l1_txt)
810: := convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
811: ----

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

808: 'CAEOY_TRANSMITTER_ADDRESS_LINE1');
809: tab_transmitter(T619_addr_l1_txt)
810: := convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
811: ----
812: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
813: 'CAEOY_TRANSMITTER_ADDRESS_LINE2');
814: tab_transmitter(T619_addr_l2_txt)
815: := convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
816: ----

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

813: 'CAEOY_TRANSMITTER_ADDRESS_LINE2');
814: tab_transmitter(T619_addr_l2_txt)
815: := convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
816: ----
817: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
818: 'CAEOY_TRANSMITTER_CITY');
819: tab_transmitter(T619_cty_nm)
820: := convert_2_xml(substr(l_return,1,28),'cty_nm');
821: ----

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

818: 'CAEOY_TRANSMITTER_CITY');
819: tab_transmitter(T619_cty_nm)
820: := convert_2_xml(substr(l_return,1,28),'cty_nm');
821: ----
822: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
823: 'CAEOY_TRANSMITTER_PROVINCE');
824: tab_transmitter(T619_prov_cd)
825: := convert_2_xml(l_return,'prov_cd');
826: ----

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

823: 'CAEOY_TRANSMITTER_PROVINCE');
824: tab_transmitter(T619_prov_cd)
825: := convert_2_xml(l_return,'prov_cd');
826: ----
827: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
828: 'CAEOY_TRANSMITTER_COUNTRY');
829: IF l_return IS NULL THEN
830: tab_transmitter(T619_cntry_cd) := NULL;
831: ELSIF l_return='CA' THEN

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

833: ELSIF l_return='US' THEN
834: tab_transmitter(T619_cntry_cd) := convert_2_xml('USA', 'cntry_cd');
835: END IF;
836: ----
837: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
838: 'CAEOY_TRANSMITTER_POSTAL_CODE');
839: tab_transmitter(T619_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
840: ----
841: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

837: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
838: 'CAEOY_TRANSMITTER_POSTAL_CODE');
839: tab_transmitter(T619_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
840: ----
841: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
842: 'CAEOY_TECHNICAL_CONTACT_NAME');
843: IF l_return IS NULL THEN
844: l_field_name := l_field_name || 'CAEOY_TECHNICAL_CONTACT_NAME,';
845: l_status := FALSE;

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

847: tab_transmitter(T619_cntc_nm)
848: := convert_2_xml(substr(l_return,1,22),'cntc_nm');
849:
850: ----
851: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
852: 'CAEOY_TECHNICAL_CONTACT_AREA_CODE');
853: tab_transmitter(T619_cntc_area_cd)
854: := convert_2_xml(substr(l_return,1,3),'cntc_area_cd');
855: ----

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

852: 'CAEOY_TECHNICAL_CONTACT_AREA_CODE');
853: tab_transmitter(T619_cntc_area_cd)
854: := convert_2_xml(substr(l_return,1,3),'cntc_area_cd');
855: ----
856: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
857: 'CAEOY_TECHNICAL_CONTACT_PHONE');
858: IF l_return IS NULL THEN
859: tab_transmitter(T619_cntc_phn_nbr) := NULL;
860: ELSE

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

865: substr(l_return,4,4),
866: 'cntc_phn_nbr');
867: END IF;
868: ----
869: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
870: 'CAEOY_TECHNICAL_CONTACT_EXTN');
871: IF l_return IS NULL THEN
872: tab_transmitter(T619_cntc_extn_nbr) := NULL;
873: ELSE

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

875: := convert_2_xml(substr(l_return,1,5),
876: 'cntc_extn_nbr');
877: END IF;
878: ----
879: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
880: 'CAEOY_TECHNICAL_CONTACT_EMAIL');
881: IF l_return IS NULL THEN
882: tab_transmitter(T619_cntc_email_area) := NULL;
883: l_field_name := l_field_name || 'CAEOY_TECHNICAL_CONTACT_EMAIL,';

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

890: ----
891: tab_transmitter(T619_rpt_tcd)
892: := convert_2_xml('A','rpt_tcd');
893: ----
894: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
895: 'CAEOY_TECHNICAL_CONTACT_LANGUAGE');
896: tab_transmitter(T619_lang_cd)
897: := convert_2_xml(l_return,'lang_cd');
898: ----

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

1024: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
1025: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);
1026: hr_utility.trace('TRANSFER_EI_ER_RATE l_transfer_ei_er_rate = ' ||l_transfer_ei_er_rate);
1027: ----
1028: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1029: 'CAEOY_GRE_EI_RATE');
1030: hr_utility.trace('CAEOY_GRE_EI_RATE = ' ||l_return);
1031: IF (l_return IS NULL) OR (to_number(l_return) = 0) THEN
1032: tab_employer(EIRate):= convert_2_xml(l_transfer_ei_er_rate,'EIRate');

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

1034: tab_employer(EIRate):= convert_2_xml(l_return,'EIRate');
1035: END IF;
1036: -- EIRate is an internal tag used for muliplying in XSL for last T4Summary tag tot_empr_eip_amt
1037: ----
1038: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1039: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1040: tab_employer(T4Summary_bn):= convert_2_xml(l_return,'bn');
1041:
1042: ----

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

1039: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1040: tab_employer(T4Summary_bn):= convert_2_xml(l_return,'bn');
1041:
1042: ----
1043: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1044: 'CAEOY_EMPLOYER_NAME');
1045: tab_employer(T4Summary_l1_nm):= convert_2_xml(substr(l_return,1,30),'l1_nm');
1046: tab_employer(T4Summary_l2_nm):= convert_2_xml(substr(l_return,31,30),'l2_nm');
1047: tab_employer(T4Summary_l3_nm):= convert_2_xml(substr(l_return,61,30),'l3_nm');

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

1045: tab_employer(T4Summary_l1_nm):= convert_2_xml(substr(l_return,1,30),'l1_nm');
1046: tab_employer(T4Summary_l2_nm):= convert_2_xml(substr(l_return,31,30),'l2_nm');
1047: tab_employer(T4Summary_l3_nm):= convert_2_xml(substr(l_return,61,30),'l3_nm');
1048: ----
1049: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1050: 'CAEOY_EMPLOYER_ADDRESS_LINE1');
1051: tab_employer(T4Summary_addr_l1_txt):= convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
1052: ----
1053: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

1049: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1050: 'CAEOY_EMPLOYER_ADDRESS_LINE1');
1051: tab_employer(T4Summary_addr_l1_txt):= convert_2_xml(substr(l_return,1,30),'addr_l1_txt');
1052: ----
1053: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1054: 'CAEOY_EMPLOYER_ADDRESS_LINE2');
1055: tab_employer(T4Summary_addr_l2_txt):= convert_2_xml(substr(l_return,1,30),'addr_l2_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_LINE2');
1055: tab_employer(T4Summary_addr_l2_txt):= convert_2_xml(substr(l_return,1,30),'addr_l2_txt');
1056: ----
1057: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1058: 'CAEOY_EMPLOYER_CITY');
1059: tab_employer(T4Summary_cty_nm):= convert_2_xml(substr(l_return,1,28),'cty_nm');
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_CITY');
1059: tab_employer(T4Summary_cty_nm):= convert_2_xml(substr(l_return,1,28),'cty_nm');
1060: ----
1061: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1062: 'CAEOY_EMPLOYER_PROVINCE');
1063: tab_employer(T4Summary_prov_cd):= convert_2_xml(substr(l_return,1,2),'prov_cd');
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_PROVINCE');
1063: tab_employer(T4Summary_prov_cd):= convert_2_xml(substr(l_return,1,2),'prov_cd');
1064: ----
1065: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1066: 'CAEOY_EMPLOYER_COUNTRY');
1067: IF l_return IS NULL THEN
1068: tab_employer(T4Summary_cntry_cd) := NULL;
1069: ELSIF l_return ='CA' THEN

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

1071: ELSIF l_return ='US' THEN
1072: tab_employer(T4Summary_cntry_cd):= convert_2_xml('USA','cntry_cd');
1073: END IF;
1074: ----
1075: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1076: 'CAEOY_EMPLOYER_POSTAL_CODE');
1077: tab_employer(T4Summary_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
1078: ----
1079: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

1075: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1076: 'CAEOY_EMPLOYER_POSTAL_CODE');
1077: tab_employer(T4Summary_pstl_cd) := convert_2_xml(substr(REPLACE(l_return,' ',''),1,10), 'pstl_cd');
1078: ----
1079: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1080: 'CAEOY_ACCOUNTING_CONTACT_NAME');
1081: IF l_return IS NULL THEN
1082: tab_employer(T4Summary_cntc_nm):= convert_2_xml(' ', 'cntc_nm');
1083: ELSE

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

1084: tab_employer(T4Summary_cntc_nm):= convert_2_xml(substr(l_return,1,22)
1085: , 'cntc_nm');
1086: END IF;
1087: ----
1088: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1089: 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
1090: IF l_return IS NULL THEN
1091: tab_employer(T4Summary_cntc_area_cd):= convert_2_xml(' ', 'cntc_area_cd');
1092: ELSE

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

1093: tab_employer(T4Summary_cntc_area_cd):= convert_2_xml(substr(l_return,1,3)
1094: , 'cntc_area_cd');
1095: END IF;
1096: ----
1097: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1098: 'CAEOY_ACCOUNTING_CONTACT_PHONE');
1099: IF l_return IS NULL THEN
1100: tab_employer(T4Summary_cntc_phn_nbr):= convert_2_xml('000-0000 ', 'cntc_phn_nbr');
1101: ELSE

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

1104: tab_employer(T4Summary_cntc_phn_nbr):= convert_2_xml(substr(l_return,1,3)||'-'||substr(l_return,4,4)
1105: , 'cntc_phn_nbr');
1106: END IF;
1107: ----
1108: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1109: 'CAEOY_ACCOUNTING_CONTACT_EXTENSION');
1110: IF l_return IS NULL THEN
1111: tab_employer(T4Summary_cntc_extn_nbr):= convert_2_xml(' ', 'cntc_extn_nbr');
1112: ELSE

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

1113: tab_employer(T4Summary_cntc_extn_nbr):= convert_2_xml(substr(l_return,1,5)
1114: , 'cntc_extn_nbr');
1115: END IF;
1116: ----
1117: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1118: 'CAEOY_TAXATION_YEAR');
1119: tab_employer(T4Summary_tx_yr):= convert_2_xml(l_return, 'tx_yr');
1120: ----
1121:

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

1118: 'CAEOY_TAXATION_YEAR');
1119: tab_employer(T4Summary_tx_yr):= convert_2_xml(l_return, 'tx_yr');
1120: ----
1121:
1122: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1123: 'CAEOY_PROPRIETOR_SIN1');
1124: -- 11074583 start
1125: if trim(l_return) IS NULL then
1126: l_return := lpad('0',9,'0');

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

1127: end if;
1128: -- 11074583 end
1129: tab_employer(T4Summary_pprtr_1_sin):= convert_2_xml(substr(REPLACE(l_return,' ',''),1,9), 'pprtr_1_sin');
1130: ----
1131: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1132: 'CAEOY_PROPRIETOR_SIN2');
1133: -- 11074583 start
1134: if trim(l_return) IS NULL then
1135: l_return := lpad('0',9,'0');

Line 1479: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1475: l_city,
1476: l_postal_code,
1477: l_country,
1478: l_emp_province);
1479: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1480: ,'CAEOY_EMPLOYEE_LAST_NAME');
1481: IF l_return IS NULL THEN
1482: l_name_status := FALSE;
1483: l_name_error_message := l_name_error_message||'Blank Last Name ';

Line 1488: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1484: END IF;
1485: tab_employee_common(T4Slip_snm) :=convert_2_xml(substr(l_return,1,20),'snm');
1486:
1487: ----2
1488: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1489: ,'CAEOY_EMPLOYEE_FIRST_NAME');
1490: --bug 13105140
1491: /* IF l_return IS NULL THEN
1492: l_name_status := FALSE;

Line 1499: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1495:
1496: tab_employee_common(T4Slip_gvn_nm) :=convert_2_xml(substr(l_return,1,12),'gvn_nm');
1497:
1498: ----3
1499: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1500: ,'CAEOY_EMPLOYEE_INITIAL');
1501: tab_employee_common(T4Slip_init) :=convert_2_xml(substr(l_return,1,1),'init');
1502:
1503: ----4,5

Line 1526: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1522: ----9
1523: tab_employee_common(T4Slip_pstl_cd) := convert_2_xml(substr(REPLACE(l_postal_code,' ',''),1,10), 'pstl_cd');
1524:
1525: ----10
1526: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1527: ,'CAEOY_EMPLOYEE_SIN');
1528: IF l_return IS NULL THEN
1529: tab_employee_common(T4Slip_sin) := convert_2_xml('000000000', 'sin');
1530: ELSE

Line 1536: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1532: END IF;
1533:
1534: ----11
1535:
1536: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1537: ,'CAEOY_EMPLOYEE_NUMBER');
1538: tab_employee_common(T4Slip_empe_nbr) :=convert_2_xml(substr(l_return,1,20),'empe_nbr');
1539:
1540: ----12

Line 1541: l_return := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid

1537: ,'CAEOY_EMPLOYEE_NUMBER');
1538: tab_employee_common(T4Slip_empe_nbr) :=convert_2_xml(substr(l_return,1,20),'empe_nbr');
1539:
1540: ----12
1541: l_return := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid
1542: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
1543: tab_employee_common(T4Slip_bn) :=convert_2_xml(substr(nvl(l_return,' '),1,15),'bn');
1544:
1545: ----13

Line 1547: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1543: tab_employee_common(T4Slip_bn) :=convert_2_xml(substr(nvl(l_return,' '),1,15),'bn');
1544:
1545: ----13
1546: /*
1547: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1548: ,'CAEOY_T4_EMPLOYEE_REGISTRATION_NO');
1549: tab_employee_common(T4Slip_rpp_dpsp_rgst_nbr) :=convert_2_xml(substr(l_return,1,7),'rpp_dpsp_rgst_nbr');
1550: */
1551:

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

1573: tab_employee.DELETE;
1574: ----
1575:
1576: -- JURISDICTION_CODE context added for bug 13427161
1577: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id, l_jurisdiction_code,
1578: 'JURISDICTION_CODE',
1579: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO');
1580:
1581: tab_employee_common(T4Slip_rpp_dpsp_rgst_nbr) :=convert_2_xml(substr(l_return,1,7),'rpp_dpsp_rgst_nbr');

Line 1583: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1579: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO');
1580:
1581: tab_employee_common(T4Slip_rpp_dpsp_rgst_nbr) :=convert_2_xml(substr(l_return,1,7),'rpp_dpsp_rgst_nbr');
1582:
1583: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1584: ,l_jurisdiction_code,'JURISDICTION_CODE'
1585: ,'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
1586: IF(l_return='Y') THEN
1587: l_status := FALSE;

Line 1592: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1588: l_error_message := l_error_message||hr_general.decode_lookup('PAY_CA_MAG_EXCEPTIONS','NEG');
1589: END IF;
1590:
1591: ---14
1592: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1593: ,l_jurisdiction_code,'JURISDICTION_CODE'
1594: ,'CAEOY_CPP_QPP_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_cpp_qpp_xmpt_cd) := convert_2_xml('1','cpp_qpp_xmpt_cd');
1600: END IF;
1601:
1602: ---15
1603: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1604: ,l_jurisdiction_code,'JURISDICTION_CODE'
1605: ,'CAEOY_EI_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_ei_xmpt_cd) := convert_2_xml('1','ei_xmpt_cd');
1611: END IF;
1612:
1613: ---16
1614: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1615: ,l_jurisdiction_code,'JURISDICTION_CODE'
1616: ,'CAEOY_PPIP_EXEMPT');
1617:
1618: IF l_return IS NULL THEN

Line 1625: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1621: tab_employee(T4Slip_prov_pip_xmpt_cd) := convert_2_xml('1','prov_pip_xmpt_cd');
1622: END IF;
1623:
1624: ----17
1625: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1626: ,l_jurisdiction_code,'JURISDICTION_CODE'
1627: ,'CAEOY_EMPLOYMENT_CODE');
1628:
1629: tab_employee(T4Slip_empt_cd) := convert_2_xml(substr(nvl(l_return,' '),1,2),'empt_cd');

Line 1635: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1631: ----18
1632: tab_employee(T4Slip_rpt_tcd) := convert_2_xml('A', 'rpt_tcd'); --Amendment
1633:
1634: ----19
1635: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1636: ,l_jurisdiction_code,'JURISDICTION_CODE'
1637: ,'CAEOY_PROVINCE_OF_EMPLOYMENT');
1638:
1639: IF l_return = 'NF' THEN

Line 1676: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1672: /*****************************************************************************/
1673: /* T4_AMT Tags begin */
1674:
1675: ----1
1676: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1677: ,l_jurisdiction_code,'JURISDICTION_CODE'
1678: ,'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD');
1679: l_return2 := l_return; --Used in 7 and 8
1680: tab_employee(T4_AMT_empt_incamt) :=convert_2_xml(nvl(l_return,'0'),'empt_incamt','C');

Line 1683: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1679: l_return2 := l_return; --Used in 7 and 8
1680: tab_employee(T4_AMT_empt_incamt) :=convert_2_xml(nvl(l_return,'0'),'empt_incamt','C');
1681:
1682: ----2
1683: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1684: ,l_jurisdiction_code,'JURISDICTION_CODE'
1685: ,'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD');
1686: tab_employee(T4_AMT_cpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'cpp_cntrb_amt','C');
1687:

Line 1689: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1685: ,'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD');
1686: tab_employee(T4_AMT_cpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'cpp_cntrb_amt','C');
1687:
1688: ----3
1689: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1690: ,l_jurisdiction_code,'JURISDICTION_CODE'
1691: ,'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD');
1692: tab_employee(T4_AMT_qpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'qpp_cntrb_amt','C');
1693:

Line 1695: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1691: ,'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD');
1692: tab_employee(T4_AMT_qpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'qpp_cntrb_amt','C');
1693:
1694: ----4
1695: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1696: ,l_jurisdiction_code,'JURISDICTION_CODE'
1697: ,'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD');
1698: tab_employee(T4_AMT_empe_eip_amt) :=convert_2_xml(nvl(l_return,'0'),'empe_eip_amt','C');
1699:

Line 1701: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1697: ,'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD');
1698: tab_employee(T4_AMT_empe_eip_amt) :=convert_2_xml(nvl(l_return,'0'),'empe_eip_amt','C');
1699:
1700: /* Bug 15953807 */
1701: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1702: ,l_jurisdiction_code,'JURISDICTION_CODE'
1703: ,'CAEOY_EI_ER_LIABILITY_PER_JD_GRE_YTD');
1704: tab_employee(T4_AMT_empr_eip_amt) :=convert_2_xml(nvl(l_return,'0'),'empr_eip_amt','C');
1705: /* Bug 15953807 */

Line 1708: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1704: tab_employee(T4_AMT_empr_eip_amt) :=convert_2_xml(nvl(l_return,'0'),'empr_eip_amt','C');
1705: /* Bug 15953807 */
1706:
1707: ----5
1708: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1709: ,l_jurisdiction_code,'JURISDICTION_CODE'
1710: ,'CAEOY_T4_BOX20_PER_JD_GRE_YTD');
1711: tab_employee(T4_AMT_rpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'rpp_cntrb_amt','C');
1712:

Line 1714: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1710: ,'CAEOY_T4_BOX20_PER_JD_GRE_YTD');
1711: tab_employee(T4_AMT_rpp_cntrb_amt) :=convert_2_xml(nvl(l_return,'0'),'rpp_cntrb_amt','C');
1712:
1713: ----6
1714: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1715: ,l_jurisdiction_code,'JURISDICTION_CODE'
1716: ,'CAEOY_FED_WITHHELD_PER_JD_GRE_YTD');
1717: tab_employee(T4_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1718:

Line 1720: lv_year := pay_ca_archive_utils.get_archive_value(

1716: ,'CAEOY_FED_WITHHELD_PER_JD_GRE_YTD');
1717: tab_employee(T4_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1718:
1719: ----7
1720: lv_year := pay_ca_archive_utils.get_archive_value(
1721: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),
1722: 'CAEOY_TAXATION_YEAR'); -- bug 13087483
1723: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1724: ,l_jurisdiction_code,'JURISDICTION_CODE'

Line 1723: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1719: ----7
1720: lv_year := pay_ca_archive_utils.get_archive_value(
1721: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),
1722: 'CAEOY_TAXATION_YEAR'); -- bug 13087483
1723: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1724: ,l_jurisdiction_code,'JURISDICTION_CODE'
1725: ,'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD');
1726:
1727: -- if condition added for bug 13087483

Line 1742: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1738: END IF;
1739:
1740: ----8
1741:
1742: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1743: ,l_jurisdiction_code,'JURISDICTION_CODE'
1744: ,'CAEOY_CPP_EE_TAXABLE_PER_JD_GRE_YTD');
1745: IF to_number(l_return) = 0 THEN
1746: /* 'CAEOY_QPP_EE_RSUBJECT_PER_JD_GRE_YTD' contains exact value of QPP amount

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

1746: /* 'CAEOY_QPP_EE_RSUBJECT_PER_JD_GRE_YTD' contains exact value of QPP amount
1747: 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD' contains exact value of QPP if
1748: it is not more than max limit other wise it contains max limit
1749: */
1750: /*l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1751: ,l_jurisdiction_code,'JURISDICTION_CODE'
1752: ,'CAEOY_QPP_EE_RSUBJECT_PER_JD_GRE_YTD');*/
1753:
1754: l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id

Line 1754: l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1750: /*l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1751: ,l_jurisdiction_code,'JURISDICTION_CODE'
1752: ,'CAEOY_QPP_EE_RSUBJECT_PER_JD_GRE_YTD');*/
1753:
1754: l_return1 := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1755: ,l_jurisdiction_code,'JURISDICTION_CODE'
1756: ,'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD');
1757: -- if condition added for bug 13087483
1758: IF to_number(ltrim(rtrim(lv_year))) < 2011 then

Line 1786: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1782: END IF;
1783: END IF;
1784:
1785: ----9
1786: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1787: ,l_jurisdiction_code,'JURISDICTION_CODE'
1788: ,'CAEOY_T4_BOX44_PER_JD_GRE_YTD');
1789: tab_employee(T4_AMT_unn_dues_amt) :=convert_2_xml(nvl(l_return,'0'),'unn_dues_amt','C');
1790:

Line 1792: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1788: ,'CAEOY_T4_BOX44_PER_JD_GRE_YTD');
1789: tab_employee(T4_AMT_unn_dues_amt) :=convert_2_xml(nvl(l_return,'0'),'unn_dues_amt','C');
1790:
1791: ----10
1792: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1793: ,l_jurisdiction_code,'JURISDICTION_CODE'
1794: ,'CAEOY_T4_BOX46_PER_JD_GRE_YTD');
1795:
1796: tab_employee(T4_AMT_chrty_dons_amt) :=convert_2_xml(nvl(l_return,'0'),'chrty_dons_amt','C');

Line 1799: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1795:
1796: tab_employee(T4_AMT_chrty_dons_amt) :=convert_2_xml(nvl(l_return,'0'),'chrty_dons_amt','C');
1797:
1798: ----11
1799: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1800: ,l_jurisdiction_code,'JURISDICTION_CODE'
1801: ,'CAEOY_T4_BOX52_PER_JD_GRE_YTD');
1802: tab_employee(T4_AMT_padj_amt) :=convert_2_xml(nvl(l_return,'0'),'padj_amt','C');
1803:

Line 1805: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1801: ,'CAEOY_T4_BOX52_PER_JD_GRE_YTD');
1802: tab_employee(T4_AMT_padj_amt) :=convert_2_xml(nvl(l_return,'0'),'padj_amt','C');
1803:
1804: ----12
1805: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1806: ,l_jurisdiction_code,'JURISDICTION_CODE'
1807: ,'CAEOY_PPIP_EE_WITHHELD_PER_JD_GRE_YTD');
1808: tab_employee(T4_AMT_prov_pip_amt) :=convert_2_xml(nvl(l_return,'0'),'prov_pip_amt','C');
1809:

Line 1812: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1808: tab_employee(T4_AMT_prov_pip_amt) :=convert_2_xml(nvl(l_return,'0'),'prov_pip_amt','C');
1809:
1810:
1811: ----13
1812: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1813: ,l_jurisdiction_code,'JURISDICTION_CODE'
1814: ,'CAEOY_PPIP_EE_TAXABLE_PER_JD_GRE_YTD');
1815: IF to_number(l_return) = to_number(l_return2)
1816: OR to_number(l_return) >= to_number(transfer_ppip_max)

Line 1851: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id

1847:
1848:
1849: FOR i IN 1..tab_other_info_dbi.COUNT LOOP
1850:
1851: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1852: ,l_jurisdiction_code,'JURISDICTION_CODE'
1853: ,tab_other_info_dbi(i));
1854:
1855: IF nvl(l_return,0)<>0 THEN