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

Line 125: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

121: and pai.action_information4 = 'G-1'
122: ) order by code;
123:
124: begin
125: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
126: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
127: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
128: ,'CAEOY_CPP_EE_TAXABLE_PER_YTD');/* Bug 14701466,14616599 sbachu*/
129:

Line 127: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

123:
124: begin
125: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
126: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
127: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
128: ,'CAEOY_CPP_EE_TAXABLE_PER_YTD');/* Bug 14701466,14616599 sbachu*/
129:
130: hr_utility.trace(' l_cpp_withheld ='|| l_cpp_withheld);
131: hr_utility.trace(' p_arch_assact_id ='|| p_arch_assact_id);

Line 925: pay_ca_archive_utils.get_archive_value(l_context1,

921: hr_utility.trace('tab_transmitter(lAnnee) = ' || tab_transmitter(lAnnee));
922:
923: -- TypeEnvoi
924: tab_transmitter(lTypeEnvoi) := '' ||
925: pay_ca_archive_utils.get_archive_value(l_context1,
926: 'CAEOY_RL1_TRANSMITTER_PACKAGE_TYPE') || '' || EOL;
927: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
928: tab_transmitter(lTypeEnvoi));
929:

Line 931: pay_ca_archive_utils.get_archive_value(l_context1,

927: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
928: tab_transmitter(lTypeEnvoi));
929:
930: tab_transmitter(lProvenance) := '' ||
931: pay_ca_archive_utils.get_archive_value(l_context1,
932: 'CAEOY_RL1_SOURCE_OF_SLIPS') || '' || EOL;
933:
934: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
935:

Line 937: pay_ca_archive_utils.get_archive_value(l_context1,

933:
934: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
935:
936: tab_transmitter(lNo) := '' ||
937: pay_ca_archive_utils.get_archive_value(l_context1,
938: 'CAEOY_RL1_TRANSMITTER_NUMBER') || '' || EOL;
939:
940: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
941:

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

938: 'CAEOY_RL1_TRANSMITTER_NUMBER') || '' || EOL;
939:
940: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
941:
942: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
943: 'CAEOY_RL1_TRANSMITTER_TYPE');
944: IF l_return IS NOT NULL THEN
945: tab_transmitter(lType) := '' || l_return || '' || EOL;
946: ELSE

Line 952: l_transmitter_name := pay_ca_archive_utils.get_archive_value(l_context1,

948: END IF;
949:
950: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));
951:
952: l_transmitter_name := pay_ca_archive_utils.get_archive_value(l_context1,
953: 'CAEOY_RL1_TRANSMITTER_NAME');
954:
955: tab_transmitter(lNom1) := '' ||
956: convert_special_char(substr(l_transmitter_name,1,30)) || '' || EOL;

Line 969: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

965: END IF;
966:
967: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));
968:
969: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
970: 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE1');
971:
972: tab_transmitter(lLigne1) := '' ||
973: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;

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

973: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
974:
975: hr_utility.trace('tab_transmitter(lLigne1) = ' || tab_transmitter(lLigne1));
976:
977: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
978: 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE2');
979:
980: IF l_address_line IS NOT NULL THEN
981: tab_transmitter(lLigne2) := '' ||

Line 989: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

985: END IF;
986:
987: hr_utility.trace('tab_transmitter(lLigne2) = ' || tab_transmitter(lLigne2));
988:
989: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
990: 'CAEOY_RL1_TRANSMITTER_CITY');
991:
992: IF l_address_line IS NOT NULL THEN
993: tab_transmitter(lVille) := '' ||

Line 1001: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

997: END IF;
998:
999: hr_utility.trace('tab_transmitter(lVille) = ' || tab_transmitter(lVille));
1000:
1001: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1002: 'CAEOY_RL1_TRANSMITTER_PROVINCE');
1003:
1004: tab_transmitter(lProvince) := '' ||
1005: SUBSTR(hr_general.decode_lookup(

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

1006: 'CA_PROVINCE',l_address_line),1,20) || '' || EOL;
1007:
1008: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
1009:
1010: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1011: 'CAEOY_RL1_TRANSMITTER_POSTAL_CODE');
1012:
1013: tab_transmitter(lCodePostal) := '' ||
1014: substr(replace(l_address_line,' '),1,6) || '' || EOL;

Line 1018: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1014: substr(replace(l_address_line,' '),1,6) || '' || EOL;
1015:
1016: hr_utility.trace('tab_transmitter(lCodePostal) = ' || tab_transmitter(lCodePostal));
1017:
1018: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1019: 'CAEOY_RL1_TECHNICAL_CONTACT_NAME');
1020:
1021: IF l_contact IS NOT NULL THEN
1022: tab_transmitter(lNom) := '' ||

Line 1030: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1026: END IF;
1027:
1028: hr_utility.trace('tab_transmitter(lNom) = ' || tab_transmitter(lNom));
1029:
1030: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1031: 'CAEOY_RL1_TECHNICAL_CONTACT_AREA_CODE');
1032:
1033: IF l_contact IS NOT NULL THEN
1034: tab_transmitter(lIndRegional) := '' ||

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

1038: END IF;
1039:
1040: hr_utility.trace('tab_transmitter(lIndRegional) = ' || tab_transmitter(lIndRegional));
1041:
1042: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1043: 'CAEOY_RL1_TECHNICAL_CONTACT_PHONE');
1044: IF l_contact IS NOT NULL THEN
1045: l_contact := substr(l_contact,1,3) || '-' || substr(l_contact,4,4);
1046: tab_transmitter(lTel) := '' || l_contact || '' || EOL;

Line 1052: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1048: tab_transmitter(lTel) := NULL;
1049: END IF;
1050: hr_utility.trace('tab_transmitter(lTel) = ' || tab_transmitter(lTel));
1051:
1052: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1053: 'CAEOY_RL1_TECHNICAL_CONTACT_EXTENSION');
1054:
1055: IF l_contact IS NOT NULL THEN
1056: tab_transmitter(lPosteTel) := '' || l_contact ||

Line 1064: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1060: END IF;
1061: hr_utility.trace('tab_transmitter(lPosteTel) = ' ||
1062: tab_transmitter(lPosteTel));
1063:
1064: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1065: 'CAEOY_RL1_TECHNICAL_CONTACT_LANGUAGE');
1066:
1067: IF l_contact IS NOT NULL THEN
1068: tab_transmitter(lLangue) := '' ||l_contact || '' || EOL;

Line 1073: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1069: ELSE
1070: tab_transmitter(lLangue) := NULL;
1071: END IF;
1072:
1073: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1074: 'CAEOY_RL1_ACCOUNTING_CONTACT_NAME');
1075:
1076: IF l_contact IS NOT NULL THEN
1077: tab_transmitter(lANom) := '' ||

Line 1084: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1080: tab_transmitter(lANom) := NULL;
1081: END IF;
1082: hr_utility.trace('tab_transmitter(lANom) = ' || tab_transmitter(lANom));
1083:
1084: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1085: 'CAEOY_RL1_ACCOUNTING_CONTACT_AREA_CODE');
1086:
1087: IF l_contact IS NOT NULL THEN
1088: tab_transmitter(lAIndRegional) := '' || l_contact ||

Line 1095: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1091: tab_transmitter(lAIndRegional) := NULL;
1092: END IF;
1093: hr_utility.trace('tab_transmitter(lAIndRegional) = ' || tab_transmitter(lAIndRegional));
1094:
1095: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1096: 'CAEOY_RL1_ACCOUNTING_CONTACT_PHONE');
1097:
1098: IF l_contact IS NOT NULL THEN
1099: l_contact := substr(l_contact,1,3) || '-' || substr(l_contact,4,4);

Line 1106: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1102: tab_transmitter(lATel) := NULL;
1103: END IF;
1104: hr_utility.trace('tab_transmitter(lATel) = ' || tab_transmitter(lATel));
1105:
1106: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1107: 'CAEOY_RL1_ACCOUNTING_CONTACT_EXTENSION');
1108:
1109: IF l_contact IS NOT NULL THEN
1110: tab_transmitter(lAPosteTel) := '' || l_contact ||

Line 1118: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,

1114: END IF;
1115: hr_utility.trace('tab_transmitter(lAPosteTel) = ' ||
1116: tab_transmitter(lAPosteTel));
1117:
1118: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1119: 'CAEOY_RL1_ACCOUNTING_CONTACT_LANGUAGE');
1120: IF l_contact IS NOT NULL THEN
1121: tab_transmitter(lALangue) := '' || l_contact ||
1122: '' || EOL;

Line 1288: lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(p_arch_action_id,

1284: open c_payroll_asgid(p_arch_action_id);
1285: fetch c_payroll_asgid into l_arch_pay_actid,l_asg_id;
1286: close c_payroll_asgid;
1287:
1288: lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(p_arch_action_id,
1289: l_province,
1290: 'JURISDICTION_CODE',
1291: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS');
1292: if (lv_negative_bal_flag is NULL or lv_negative_bal_flag = 'N') then

Line 1929: l_year := pay_ca_archive_utils.get_archive_value(p_arch_pay_actid, 'CAEOY_TAXATION_YEAR');

1925: hr_utility.trace('fetch_rl1_xml: called_from = '||called_from);
1926:
1927: l_authorization_header := 'No d''autorisation :';
1928:
1929: l_year := pay_ca_archive_utils.get_archive_value(p_arch_pay_actid, 'CAEOY_TAXATION_YEAR');
1930:
1931: /*if( l_year ='2006' ) then
1932: l_authorization_code := 'FS-06-01-103';
1933: elsif (l_year ='2007' ) then

Line 1948: lv_rl1_slip_no := pay_ca_archive_utils.get_archive_value(p_arch_action_id,

1944: tab_employee(lAnnee) := '' || p_taxation_year || '' || EOL;
1945: hr_utility.trace('tab_employee(lAnnee) = ' || tab_employee(lAnnee));
1946: --NoReleve
1947: /* Bug 13564765 sbachu*/
1948: lv_rl1_slip_no := pay_ca_archive_utils.get_archive_value(p_arch_action_id,
1949: 'CAEOY_RL1_SLIP_NUMBER');
1950: l_return := get_slip_seq_no('|',lv_rl1_slip_no,1);
1951:
1952: IF l_return IS NULL THEN

Line 1958: if ((pay_ca_archive_utils.get_archive_value(p_arch_pay_actid,

1954: tab_employee(lNoReleve) := NULL;
1955: tab_xml_employee(lNoReleve) := NULL; --
1956: ELSE
1957: --added for bug 10420127
1958: if ((pay_ca_archive_utils.get_archive_value(p_arch_pay_actid,
1959: 'CAEOY_TAXATION_YEAR')) >= '2010') then
1960: hr_utility.trace('p_taxation_year is greater than or equal 2010');
1961: l_return := substr(l_return,1,3)||
1962: '-'||substr(l_return,4,3)||

Line 1976: lv_pre_pr_form_no := pay_ca_archive_utils.get_archive_value(p_arch_action_id,

1972: --Added for bug 5046006
1973: --NoOrigReleve
1974: IF p_rep_type in ('PAYCARL1AMPDF','PAYCARL1CLPDF') THEN
1975: /* Bug 13564765 sbachu*/
1976: lv_pre_pr_form_no := pay_ca_archive_utils.get_archive_value(p_arch_action_id,
1977: 'CAEOY_RL1_PRE_PRINTED_FORM_NO');
1978: l_return := get_slip_seq_no('|',lv_pre_pr_form_no,1);
1979: IF l_return IS NULL THEN
1980: l_status := 'Failed';

Line 1984: if ((pay_ca_archive_utils.get_archive_value(p_arch_pay_actid,

1980: l_status := 'Failed';
1981: tab_employee(lNoOrigReleve) := NULL;
1982: tab_xml_employee(lNoOrigReleve) := NULL; --
1983: ELSE
1984: if ((pay_ca_archive_utils.get_archive_value(p_arch_pay_actid,
1985: 'CAEOY_TAXATION_YEAR')) >= '2010') then
1986: l_return := substr(l_return,1,3)||'-'||
1987: substr(l_return,4,3)||'-'||
1988: substr(l_return,7);

Line 1999: l_return := pay_ca_archive_utils.get_archive_value(p_arch_action_id,

1995: hr_utility.trace('tab_xml_employee(lNoOrigReleve) = ' || tab_xml_employee(lNoOrigReleve));
1996: END IF;
1997: -- End bug 5046006
1998: -- NAS
1999: l_return := pay_ca_archive_utils.get_archive_value(p_arch_action_id,
2000: 'CAEOY_EMPLOYEE_SIN');
2001:
2002: IF l_return IS NOT NULL THEN
2003: tab_employee(lNAS) := '' || l_return || '' || EOL;

Line 2016: l_return := pay_ca_archive_utils.get_archive_value(p_arch_action_id,

2012: hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));
2013: hr_utility.trace('tab_xml_employee(lNAS) = ' || tab_xml_employee(lNAS));
2014:
2015: -- No
2016: l_return := pay_ca_archive_utils.get_archive_value(p_arch_action_id,
2017: 'CAEOY_EMPLOYEE_NUMBER');
2018: IF l_return IS NOT NULL THEN
2019: tab_employee(lNo) := '' || convert_special_char(l_return) || '' || EOL;
2020: tab_xml_employee(lNo) := convert_special_char(l_return); --

Line 2029: l_name := pay_ca_archive_utils.get_archive_value(p_arch_action_id,

2025: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));
2026: hr_utility.trace('tab_xml_employee(lNo) = ' || tab_xml_employee(lNo)); --
2027:
2028: -- NomFamille
2029: l_name := pay_ca_archive_utils.get_archive_value(p_arch_action_id,
2030: 'CAEOY_EMPLOYEE_LAST_NAME');
2031: tab_employee(lNomFamille) := '' ||
2032: convert_special_char(substr(l_name,1,30)) || '' || EOL;
2033: tab_xml_employee(lNomFamille) := convert_special_char(substr(l_name,1,20)); --

Line 2038: l_name := pay_ca_archive_utils.get_archive_value(p_arch_action_id,

2034: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
2035: hr_utility.trace('tab_xml_employee(lNomFamille) = ' || tab_xml_employee(lNomFamille)); --
2036:
2037: -- Prenom
2038: l_name := pay_ca_archive_utils.get_archive_value(p_arch_action_id,
2039: 'CAEOY_EMPLOYEE_FIRST_NAME');
2040: IF l_name is NOT NULL THEN
2041: tab_employee(lPrenom) := '' || convert_special_char(substr(l_name,1,30))
2042: || '' || EOL;

Line 2055: l_name := pay_ca_archive_utils.get_archive_value(p_arch_action_id,

2051: hr_utility.trace('tab_employee(lPrenom) = ' || tab_employee(lPrenom));
2052: hr_utility.trace('tab_xml_employee(lPrenom) = ' || tab_xml_employee(lPrenom)); --
2053:
2054: -- Initiale
2055: l_name := pay_ca_archive_utils.get_archive_value(p_arch_action_id,
2056: 'CAEOY_EMPLOYEE_INITIAL');
2057: IF l_name is NOT NULL THEN
2058: tab_employee(lInitiale) := '' || substr(l_name,1,1)
2059: || '' || EOL;

Line 2069: l_person_id := to_number(pay_ca_archive_utils.get_archive_value(

2065: END IF;
2066: hr_utility.trace('tab_employee(lInitiale) = ' || tab_employee(lInitiale));
2067: hr_utility.trace('tab_xml_employee(lInitiale) = ' || tab_xml_employee(lInitiale)); --
2068:
2069: l_person_id := to_number(pay_ca_archive_utils.get_archive_value(
2070: p_arch_action_id,
2071: 'CAEOY_PERSON_ID'));
2072: /***************************************************************/
2073: if(p_rep_type='RL1PAPERPDF' or p_rep_type='PAYCARL1AMPDF' or p_rep_type='PAYCARL1CLPDF') then /*Added for Bug#5046006*/

Line 2074: l_person_id1 := to_number(pay_ca_archive_utils.get_archive_value(

2070: p_arch_action_id,
2071: 'CAEOY_PERSON_ID'));
2072: /***************************************************************/
2073: if(p_rep_type='RL1PAPERPDF' or p_rep_type='PAYCARL1AMPDF' or p_rep_type='PAYCARL1CLPDF') then /*Added for Bug#5046006*/
2074: l_person_id1 := to_number(pay_ca_archive_utils.get_archive_value(
2075: p_arch_action_id,
2076: 'CAEOY_PERSON_ID'));
2077:
2078: select trunc(sysdate) into l_session_date from dual;

Line 2085: tab_xml_employee(lForm_number) := pay_ca_archive_utils.get_archive_value(p_arch_action_id, --l_mag_asg_action_id

2081: addr := pay_ca_rl1_reg.get_primary_address(l_person_id1, l_session_date);
2082: tab_xml_employee(lLigne1) := convert_special_char(substr(addr.addr_line_1,1,40));
2083: tab_xml_employee(lLigne2) := convert_special_char(substr(addr.addr_line_2,1,40)||' '||substr(addr.addr_line_3,1,40));
2084: tab_xml_employee(lVille) := convert_special_char(substr(addr.addr_line_4,1,40));
2085: tab_xml_employee(lForm_number) := pay_ca_archive_utils.get_archive_value(p_arch_action_id, --l_mag_asg_action_id
2086: 'CAEOY_RL1_PRE_PRINTED_FORM_NO');
2087: hr_utility.trace('tab_xml_employee(lForm_number) = ' || tab_xml_employee(lForm_number));
2088:
2089:

Line 2090: tab_xml_employee(lAnnee) := pay_ca_archive_utils.get_archive_value(p_arch_pay_actid,

2086: 'CAEOY_RL1_PRE_PRINTED_FORM_NO');
2087: hr_utility.trace('tab_xml_employee(lForm_number) = ' || tab_xml_employee(lForm_number));
2088:
2089:
2090: tab_xml_employee(lAnnee) := pay_ca_archive_utils.get_archive_value(p_arch_pay_actid,
2091: 'CAEOY_TAXATION_YEAR');
2092: hr_utility.trace('tab_xml_employee(lAnnee) = ' || tab_xml_employee(lAnnee)); --
2093: /***************************** *****************************/
2094: else /***if not paper report***/

Line 2212: l_box := pay_ca_archive_utils.get_archive_value(

2208: end if;
2209: -- end of bug 12973486
2210: -- Summ (Box A)
2211:
2212: l_box := pay_ca_archive_utils.get_archive_value(
2213: p_arch_action_id,
2214: p_province,
2215: 'JURISDICTION_CODE',
2216: 'CAEOY_GROSS_EARNINGS_PER_JD_YTD');

Line 2242: l_box := pay_ca_archive_utils.get_archive_value(

2238: hr_utility.trace('tab_employee(lA_RevenuEmploi) = ' || tab_employee(lA_RevenuEmploi));
2239: hr_utility.trace('tab_xml_employee(lA_RevenuEmploi) = ' || tab_xml_employee(lA_RevenuEmploi));
2240:
2241: -- Summ (Box B)
2242: l_box := pay_ca_archive_utils.get_archive_value(
2243: p_arch_action_id,
2244: p_province,
2245: 'JURISDICTION_CODE',
2246: 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD');

Line 2278: l_box := pay_ca_archive_utils.get_archive_value(

2274: hr_utility.trace('tab_xml_employee(lB_CotisationRRQ) = ' ||
2275: tab_xml_employee(lB_CotisationRRQ)); --
2276:
2277: -- Summ (Box C)
2278: l_box := pay_ca_archive_utils.get_archive_value(
2279: p_arch_action_id,
2280: p_province,
2281: 'JURISDICTION_CODE',
2282: 'CAEOY_EI_EE_WITHHELD_PER_JD_YTD');

Line 2311: l_box := pay_ca_archive_utils.get_archive_value(

2307:
2308: hr_utility.trace('tab_xml_employee(lC_CotisationAssEmploi) = ' ||
2309: tab_xml_employee(lC_CotisationAssEmploi)); --
2310: -- Summ (Box D)
2311: l_box := pay_ca_archive_utils.get_archive_value(
2312: p_arch_action_id,
2313: p_province,
2314: 'JURISDICTION_CODE',
2315: 'CAEOY_RL1_BOXD_PER_JD_YTD');

Line 2345: l_box := pay_ca_archive_utils.get_archive_value(

2341:
2342:
2343: -- (Box E)
2344:
2345: l_box := pay_ca_archive_utils.get_archive_value(
2346: p_arch_action_id,
2347: p_province,
2348: 'JURISDICTION_CODE',
2349: 'CAEOY_PROV_WITHHELD_PER_JD_YTD');

Line 2378: l_box := pay_ca_archive_utils.get_archive_value(

2374: hr_utility.trace('tab_xml_employee(lE_ImpotQue) = ' ||
2375: tab_xml_employee(lE_ImpotQue)); --
2376:
2377: -- (Box F)
2378: l_box := pay_ca_archive_utils.get_archive_value(
2379: p_arch_action_id,
2380: p_province,
2381: 'JURISDICTION_CODE',
2382: 'CAEOY_RL1_BOXF_PER_JD_YTD');

Line 2410: l_box := pay_ca_archive_utils.get_archive_value(

2406:
2407: hr_utility.trace('tab_xml_employee(lF_CotisationSyndicale) = ' ||
2408: tab_xml_employee(lF_CotisationSyndicale));
2409: -- (Box Q)
2410: l_box := pay_ca_archive_utils.get_archive_value(
2411: p_arch_action_id,
2412: p_province,
2413: 'JURISDICTION_CODE',
2414: 'CAEOY_RL1_BOXQ_PER_JD_YTD');

Line 2443: l_box := pay_ca_archive_utils.get_archive_value(

2439:
2440: hr_utility.trace('tab_xml_employee(lQ_SalaireDiffere) = ' ||
2441: tab_xml_employee(lQ_SalaireDiffere));
2442: -- (Box U)
2443: l_box := pay_ca_archive_utils.get_archive_value(
2444: p_arch_action_id,
2445: p_province,
2446: 'JURISDICTION_CODE',
2447: 'CAEOY_RL1_BOXU_PER_JD_YTD');

Line 2478: l_box := pay_ca_archive_utils.get_archive_value(

2474:
2475: hr_utility.trace('tab_xml_employee(lU_RetraiteProgressive) = ' ||
2476: tab_xml_employee(lU_RetraiteProgressive));
2477: -- (Box G)
2478: l_box := pay_ca_archive_utils.get_archive_value(
2479: p_arch_action_id,
2480: p_province,
2481: 'JURISDICTION_CODE',
2482: --'CAEOY_QPP_REDUCED_SUBJECT_PER_JD_YTD');

Line 2595: l_box := pay_ca_archive_utils.get_archive_value(

2591: END IF;
2592:
2593:
2594: -- (Box V)
2595: l_box := pay_ca_archive_utils.get_archive_value(
2596: p_arch_action_id,
2597: p_province,
2598: 'JURISDICTION_CODE',
2599: 'CAEOY_RL1_BOXV_PER_JD_YTD');

Line 2628: l_box := pay_ca_archive_utils.get_archive_value(

2624:
2625: hr_utility.trace('tab_xml_employee(lV_NourritureLogement) = ' ||
2626: tab_xml_employee(lV_NourritureLogement));
2627: -- (Box W)
2628: l_box := pay_ca_archive_utils.get_archive_value(
2629: p_arch_action_id,
2630: p_province,
2631: 'JURISDICTION_CODE',
2632: 'CAEOY_RL1_BOXW_PER_JD_YTD');

Line 2661: l_box := pay_ca_archive_utils.get_archive_value(

2657: hr_utility.trace('tab_xml_employee(lW_Vehicule) = ' ||
2658: tab_xml_employee(lW_Vehicule));
2659:
2660: --(BOX H)
2661: l_box := pay_ca_archive_utils.get_archive_value(
2662: p_arch_action_id,
2663: p_province,
2664: 'JURISDICTION_CODE',
2665: 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD');

Line 2693: l_box := pay_ca_archive_utils.get_archive_value(

2689: hr_utility.trace('tab_xml_employee(lH_CotisationRQAP) = ' ||
2690: tab_xml_employee(lH_CotisationRQAP));
2691:
2692: --(BOX I)
2693: l_box := pay_ca_archive_utils.get_archive_value(
2694: p_arch_action_id,
2695: p_province,
2696: 'JURISDICTION_CODE',
2697: -- commented for bug 6623199.

Line 2728: l_box := pay_ca_archive_utils.get_archive_value(

2724: hr_utility.trace('tab_xml_employee(lI_SalaireAdmisRQAP) = ' ||
2725: tab_xml_employee(lI_SalaireAdmisRQAP));
2726:
2727: -- (Box J)
2728: l_box := pay_ca_archive_utils.get_archive_value(
2729: p_arch_action_id,
2730: p_province,
2731: 'JURISDICTION_CODE',
2732: 'CAEOY_RL1_BOXJ_PER_JD_YTD');

Line 2761: l_box := pay_ca_archive_utils.get_archive_value(

2757: hr_utility.trace('tab_xml_employee(lJ_RegimeAssMaladie) = ' ||
2758: tab_xml_employee(lJ_RegimeAssMaladie));
2759:
2760: -- (Box K)
2761: l_box := pay_ca_archive_utils.get_archive_value(
2762: p_arch_action_id,
2763: p_province,
2764: 'JURISDICTION_CODE',
2765: 'CAEOY_RL1_BOXK_PER_JD_YTD');

Line 2793: l_box := pay_ca_archive_utils.get_archive_value(

2789:
2790: hr_utility.trace('tab_xml_employee(lK_Voyage) = ' ||
2791: tab_xml_employee(lK_Voyage));
2792: -- (Box L)
2793: l_box := pay_ca_archive_utils.get_archive_value(
2794: p_arch_action_id,
2795: p_province,
2796: 'JURISDICTION_CODE',
2797: 'CAEOY_RL1_BOXL_PER_JD_YTD');

Line 2825: l_box := pay_ca_archive_utils.get_archive_value(

2821:
2822: hr_utility.trace('tab_xml_employee(lL_AutreAvantage) = ' ||
2823: tab_xml_employee(lL_AutreAvantage));
2824: -- (Box M)
2825: l_box := pay_ca_archive_utils.get_archive_value(
2826: p_arch_action_id,
2827: p_province,
2828: 'JURISDICTION_CODE',
2829: 'CAEOY_RL1_BOXM_PER_JD_YTD');

Line 2857: l_box := pay_ca_archive_utils.get_archive_value(

2853:
2854: hr_utility.trace('tab_xml_employee(lM_Commission) = ' ||
2855: tab_xml_employee(lM_Commission));
2856: -- (Box N)
2857: l_box := pay_ca_archive_utils.get_archive_value(
2858: p_arch_action_id,
2859: p_province,
2860: 'JURISDICTION_CODE',
2861: 'CAEOY_RL1_BOXN_PER_JD_YTD');

Line 2890: l_box := pay_ca_archive_utils.get_archive_value(

2886:
2887: hr_utility.trace('tab_xml_employee(lN_DonBienfaisance) = ' ||
2888: tab_xml_employee(lN_DonBienfaisance));
2889: -- Summ (Box O)
2890: l_box := pay_ca_archive_utils.get_archive_value(
2891: p_arch_action_id,
2892: p_province,
2893: 'JURISDICTION_CODE',
2894: 'CAEOY_RL1_BOXO_PER_JD_YTD');

Line 2926: l_box := pay_ca_archive_utils.get_archive_value(

2922:
2923: -- SourceCasem
2924:
2925: IF to_number(l_boxO) <> 0 THEN
2926: l_box := pay_ca_archive_utils.get_archive_value(
2927: p_arch_action_id,
2928: p_province,
2929: 'JURISDICTION_CODE',
2930: 'CAEOY_RL1_BOXO_CODE_PER_JD_YTD');

Line 2953: l_box := pay_ca_archive_utils.get_archive_value(

2949: ||''||EOL;
2950: else
2951: l_O_AutreRevenu := null;
2952: end if;
2953: l_box := pay_ca_archive_utils.get_archive_value(
2954: p_arch_action_id,
2955: p_province,
2956: 'JURISDICTION_CODE',
2957: 'CAEOY_RL1_BOXP_PER_JD_YTD');

Line 2985: l_box := pay_ca_archive_utils.get_archive_value(

2981:
2982: hr_utility.trace('tab_xml_employee(lP_RegimeAssInterEntr) = ' ||
2983: tab_xml_employee(lP_RegimeAssInterEntr));
2984: -- (Box R)
2985: l_box := pay_ca_archive_utils.get_archive_value(
2986: p_arch_action_id,
2987: p_province,
2988: 'JURISDICTION_CODE',
2989: 'CAEOY_RL1_BOXR_PER_JD_YTD');

Line 3017: l_box := pay_ca_archive_utils.get_archive_value(

3013:
3014: hr_utility.trace('tab_xml_employee(lR_RevenuIndien) = ' ||
3015: tab_xml_employee(lR_RevenuIndien));
3016: -- (Box S)
3017: l_box := pay_ca_archive_utils.get_archive_value(
3018: p_arch_action_id,
3019: p_province,
3020: 'JURISDICTION_CODE',
3021: 'CAEOY_RL1_BOXS_PER_JD_YTD');

Line 3049: l_box := pay_ca_archive_utils.get_archive_value(

3045:
3046: hr_utility.trace('tab_xml_employee(lS_PourboireRecu) = ' ||
3047: tab_xml_employee(lS_PourboireRecu));
3048: -- (Box T)
3049: l_box := pay_ca_archive_utils.get_archive_value(
3050: p_arch_action_id,
3051: p_province,
3052: 'JURISDICTION_CODE',
3053: 'CAEOY_RL1_BOXT_PER_JD_YTD');

Line 3081: l_box := pay_ca_archive_utils.get_archive_value(

3077: hr_utility.trace('tab_xml_employee(lT_PourboireAttribue) = ' ||
3078: tab_xml_employee(lT_PourboireAttribue));
3079:
3080: -- (Box ContisationRPC)
3081: l_box := pay_ca_archive_utils.get_archive_value(
3082: p_arch_action_id,
3083: --p_province,
3084: --'JURISDICTION_CODE',
3085: 'CAEOY_CPP_EE_WITHHELD_PER_YTD');

Line 3111: l_box := pay_ca_archive_utils.get_archive_value(

3107: tab_employee(l_ContisationRPC));
3108:
3109: /* Changes for bug 13567075 starts here -- sbachu*/
3110:
3111: l_box := pay_ca_archive_utils.get_archive_value(
3112: p_arch_action_id,
3113: p_province,
3114: 'JURISDICTION_CODE',
3115: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_201_AMT_PER_JD_YTD');

Line 3139: l_box := fnd_number.number_to_canonical(fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(

3135: END IF;
3136: hr_utility.trace('tab_employee(l_FraisGarde) = ' ||
3137: tab_employee(l_FraisGarde));
3138:
3139: l_box := fnd_number.number_to_canonical(fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(
3140: p_arch_action_id,
3141: p_province,
3142: 'JURISDICTION_CODE',
3143: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A7_AMT_PER_JD_YTD')) +

Line 3144: fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(

3140: p_arch_action_id,
3141: p_province,
3142: 'JURISDICTION_CODE',
3143: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A7_AMT_PER_JD_YTD')) +
3144: fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(
3145: p_arch_action_id,
3146: p_province,
3147: 'JURISDICTION_CODE',
3148: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A8_AMT_PER_JD_YTD')));

Line 3176: l_box := pay_ca_archive_utils.get_archive_value(

3172: /*Changes for bug 13567075 ends here --sbachu*/
3173:
3174: -- Negative Balance Exists
3175: hr_utility.trace('finding if neg bal exists');
3176: l_box := pay_ca_archive_utils.get_archive_value(
3177: p_arch_action_id,
3178: p_province,
3179: 'JURISDICTION_CODE',
3180: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS');

Line 4235: l_quebec_bn := pay_ca_archive_utils.get_archive_value

4231:
4232: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
4233: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
4234:
4235: l_quebec_bn := pay_ca_archive_utils.get_archive_value
4236: (l_context1,'CAEOY_RL1_QUEBEC_BN');
4237:
4238: tab_employer(lNoId) := '' || substr(l_quebec_bn,1,10) ||
4239: '' || EOL;

Line 4246: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,

4242: tab_employer(lNoDossier) := '' || substr(l_quebec_bn,13,4) ||
4243: '' || EOL;
4244: tab_employer(lNEQ) := '' || substr(l_quebec_bn,1,10) ||
4245: '' || EOL;
4246: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,
4247: 'CAEOY_RL1_EMPLOYER_NAME');
4248:
4249: tab_employer(lNom1) := '' ||
4250: convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;

Line 4269: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4265: hr_utility.trace('tab_employer(lNom2) = ' || tab_employer(lNom2));
4266:
4267: -- Address Line 1
4268:
4269: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4270: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1');
4271:
4272: IF l_address_line IS NULL THEN
4273:

Line 4293: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4289:
4290:
4291: -- Address Line 2
4292:
4293: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4294: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE2');
4295:
4296: IF l_address_line IS NOT NULL THEN
4297: tab_employer(lLigne2) := '' ||

Line 4306: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4302: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
4303:
4304: -- Ville (City)
4305:
4306: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4307: 'CAEOY_RL1_EMPLOYER_CITY');
4308: IF l_address_line IS NOT NULL THEN
4309: tab_employer(lVille) := '' ||
4310: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;

Line 4318: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4314: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
4315:
4316: -- Province
4317:
4318: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4319: 'CAEOY_RL1_EMPLOYER_PROVINCE');
4320:
4321: IF l_address_line IS NOT NULL THEN
4322: tab_employer(lProvince) := '' ||

Line 4332: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4328: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
4329:
4330: -- Postal Code
4331:
4332: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4333: 'CAEOY_RL1_EMPLOYER_POSTAL_CODE');
4334:
4335: IF l_address_line IS NOT NULL THEN
4336: tab_employer(lCodePostal) := '' ||

Line 4435: where person_id = to_number(pay_ca_archive_utils.get_archive_value(

4431:
4432: cursor c_get_language(p_assgn_id number) is
4433: select decode(correspondence_language,NULL,'US',correspondence_language)
4434: from per_all_people_f
4435: where person_id = to_number(pay_ca_archive_utils.get_archive_value(
4436: p_arch_assact_id,
4437: 'CAEOY_PERSON_ID'));
4438: cursor cur_boxo is
4439: SELECT 'BOXO-'||substr(fdi.user_name,23,2) DB_Name,to_number(fai.value) value

Line 4500: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

4496: SELECT
4497: fnd_global.local_chr(13) || fnd_global.local_chr(10)
4498: INTO EOL
4499: from dual;
4500: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
4501: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
4502: open c_get_language(p_assgn_id);
4503: fetch c_get_language into l_person_lang;
4504: close c_get_language;

Line 4660: l_quebec_bn := pay_ca_archive_utils.get_archive_value

4656: into l_context1;
4657: close c_get_arch_pay_actid;
4658: hr_utility.trace ('l_cvontext1 ='||l_context1);
4659:
4660: l_quebec_bn := pay_ca_archive_utils.get_archive_value
4661: (l_context1,'CAEOY_RL1_QUEBEC_BN');
4662: tab_employer(lNoId) := substr(l_quebec_bn,1,10); -- employer id
4663:
4664: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,

Line 4664: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,

4660: l_quebec_bn := pay_ca_archive_utils.get_archive_value
4661: (l_context1,'CAEOY_RL1_QUEBEC_BN');
4662: tab_employer(lNoId) := substr(l_quebec_bn,1,10); -- employer id
4663:
4664: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,
4665: 'CAEOY_RL1_EMPLOYER_NAME');
4666:
4667: tab_employer(lNom1) := convert_special_char(l_employer_name);
4668: hr_utility.trace('tab_employer(lNoId) = ' || tab_employer(lNoId));

Line 4672: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4668: hr_utility.trace('tab_employer(lNoId) = ' || tab_employer(lNoId));
4669: hr_utility.trace('tab_employer(lNom1) = ' || tab_employer(lNom1));
4670:
4671: -- Address Line 1
4672: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4673: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1');
4674: tab_employer(lLigne1) := convert_special_char(substr(l_address_line,1,40));
4675: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
4676:

Line 4678: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4674: tab_employer(lLigne1) := convert_special_char(substr(l_address_line,1,40));
4675: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
4676:
4677: -- Address Line 2
4678: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4679: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE2');
4680: tab_employer(lLigne2) := convert_special_char(substr(l_address_line,1,40));
4681: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
4682:

Line 4684: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4680: tab_employer(lLigne2) := convert_special_char(substr(l_address_line,1,40));
4681: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
4682:
4683: -- Address Line 3
4684: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4685: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE3');
4686: tab_employer(lLigne3) := convert_special_char(substr(l_address_line,1,40));
4687: hr_utility.trace('tab_employer(lLigne3) = ' || tab_employer(lLigne3));
4688:

Line 4694: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4690: tab_employer(lLigne2) := tab_employer(lLigne2) ||' '|| tab_employer(lLigne3) ; /*******/
4691: end if;
4692:
4693: -- Ville (City)
4694: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4695: 'CAEOY_RL1_EMPLOYER_CITY');
4696: tab_employer(lVille) := convert_special_char(substr(l_address_line,1,30));
4697: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
4698:

Line 4701: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4697: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
4698:
4699: -- Province
4700:
4701: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4702: 'CAEOY_RL1_EMPLOYER_PROVINCE');
4703:
4704: tab_employer(lProvince) :=l_address_line;
4705: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));

Line 4708: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4704: tab_employer(lProvince) :=l_address_line;
4705: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
4706:
4707: --Country
4708: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4709: 'CAEOY_RL1_EMPLOYER_COUNTRY');
4710: tab_employer(lCountry) :=l_address_line;
4711: hr_utility.trace('tab_employer(lCountry) = ' || tab_employer(lCountry));
4712:

Line 4714: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,

4710: tab_employer(lCountry) :=l_address_line;
4711: hr_utility.trace('tab_employer(lCountry) = ' || tab_employer(lCountry));
4712:
4713: -- Postal Code
4714: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4715: 'CAEOY_RL1_EMPLOYER_POSTAL_CODE');
4716: tab_employer(lCodePostal) :=substr(replace(l_address_line,' '),1,6);
4717:
4718: --final city