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

Line 298: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

294: and pai.action_information4 = 'G-1'
295: ) order by code;
296:
297: begin
298: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
299: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
300: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
301: ,'CAEOY_CPP_EE_TAXABLE_PER_YTD');
302:

Line 300: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

296:
297: begin
298: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
299: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
300: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
301: ,'CAEOY_CPP_EE_TAXABLE_PER_YTD');
302:
303: hr_utility.trace(' l_cpp_withheld ='|| l_cpp_withheld);
304: hr_utility.trace(' p_arch_assact_id ='|| p_arch_assact_id);

Line 988: pay_ca_archive_utils.get_archive_value(l_context1,

984: hr_utility.trace('tab_transmitter(lAnnee) = ' || tab_transmitter(lAnnee));
985:
986: -- TypeEnvoi
987: tab_transmitter(lTypeEnvoi) := '' ||
988: pay_ca_archive_utils.get_archive_value(l_context1,
989: 'CAEOY_RL1_TRANSMITTER_PACKAGE_TYPE') || '' || EOL;--Bug 9154497
990: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
991: tab_transmitter(lTypeEnvoi));
992:

Line 994: pay_ca_archive_utils.get_archive_value(l_context1,

990: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
991: tab_transmitter(lTypeEnvoi));
992:
993: tab_transmitter(lProvenance) := '' ||
994: pay_ca_archive_utils.get_archive_value(l_context1,
995: 'CAEOY_RL1_SOURCE_OF_SLIPS') || '' || EOL;
996:
997: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
998:

Line 1000: pay_ca_archive_utils.get_archive_value(l_context1,

996:
997: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
998:
999: tab_transmitter(lNo) := '' ||
1000: pay_ca_archive_utils.get_archive_value(l_context1,
1001: 'CAEOY_RL1_TRANSMITTER_NUMBER') || '' || EOL;
1002:
1003: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
1004:

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

1001: 'CAEOY_RL1_TRANSMITTER_NUMBER') || '' || EOL;
1002:
1003: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
1004:
1005: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
1006: 'CAEOY_RL1_TRANSMITTER_TYPE');
1007: IF l_return IS NOT NULL THEN
1008: tab_transmitter(lType) := '' || l_return || '' || EOL;
1009: ELSE

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

1011: END IF;
1012:
1013: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));
1014:
1015: l_transmitter_name := pay_ca_archive_utils.get_archive_value(l_context1,
1016: 'CAEOY_RL1_TRANSMITTER_NAME');
1017:
1018: tab_transmitter(lNom1) := '' ||
1019: pay_ca_rl1_mag.convert_special_char(substr(l_transmitter_name,1,30)) || '' || EOL;

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

1028: END IF;
1029:
1030: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));
1031:
1032: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1033: 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE1');
1034:
1035: tab_transmitter(lLigne1) := '' ||
1036: pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,30)) || '' || EOL;

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

1036: pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
1037:
1038: hr_utility.trace('tab_transmitter(lLigne1) = ' || tab_transmitter(lLigne1));
1039:
1040: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1041: 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE2');
1042:
1043: IF l_address_line IS NOT NULL THEN
1044: tab_transmitter(lLigne2) := '' ||

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

1048: END IF;
1049:
1050: hr_utility.trace('tab_transmitter(lLigne2) = ' || tab_transmitter(lLigne2));
1051:
1052: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1053: 'CAEOY_RL1_TRANSMITTER_CITY');
1054:
1055: IF l_address_line IS NOT NULL THEN
1056: tab_transmitter(lVille) := '' ||

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

1060: END IF;
1061:
1062: hr_utility.trace('tab_transmitter(lVille) = ' || tab_transmitter(lVille));
1063:
1064: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1065: 'CAEOY_RL1_TRANSMITTER_PROVINCE');
1066:
1067: tab_transmitter(lProvince) := '' ||
1068: SUBSTR(hr_general.decode_lookup(

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

1069: 'CA_PROVINCE',l_address_line),1,20) || '' || EOL;
1070:
1071: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
1072:
1073: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1074: 'CAEOY_RL1_TRANSMITTER_POSTAL_CODE');
1075:
1076: tab_transmitter(lCodePostal) := '' ||
1077: substr(replace(l_address_line,' '),1,6) || '' || EOL;

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

1077: substr(replace(l_address_line,' '),1,6) || '' || EOL;
1078:
1079: hr_utility.trace('tab_transmitter(lCodePostal) = ' || tab_transmitter(lCodePostal));
1080:
1081: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1082: 'CAEOY_RL1_TECHNICAL_CONTACT_NAME');
1083:
1084: IF l_contact IS NOT NULL THEN
1085: tab_transmitter(lNom) := '' ||

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

1089: END IF;
1090:
1091: hr_utility.trace('tab_transmitter(lNom) = ' || tab_transmitter(lNom));
1092:
1093: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1094: 'CAEOY_RL1_TECHNICAL_CONTACT_AREA_CODE');
1095:
1096: IF l_contact IS NOT NULL THEN
1097: tab_transmitter(lIndRegional) := '' ||

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

1101: END IF;
1102:
1103: hr_utility.trace('tab_transmitter(lIndRegional) = ' || tab_transmitter(lIndRegional));
1104:
1105: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1106: 'CAEOY_RL1_TECHNICAL_CONTACT_PHONE');
1107: IF l_contact IS NOT NULL THEN
1108: l_contact := substr(l_contact,1,3) || '-' || substr(l_contact,4,4);
1109: tab_transmitter(lTel) := '' || l_contact || '' || EOL;

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

1111: tab_transmitter(lTel) := NULL;
1112: END IF;
1113: hr_utility.trace('tab_transmitter(lTel) = ' || tab_transmitter(lTel));
1114:
1115: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1116: 'CAEOY_RL1_TECHNICAL_CONTACT_EXTENSION');
1117:
1118: IF l_contact IS NOT NULL THEN
1119: tab_transmitter(lPosteTel) := '' || l_contact ||

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

1123: END IF;
1124: hr_utility.trace('tab_transmitter(lPosteTel) = ' ||
1125: tab_transmitter(lPosteTel));
1126:
1127: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1128: 'CAEOY_RL1_TECHNICAL_CONTACT_LANGUAGE');
1129:
1130: IF l_contact IS NOT NULL THEN
1131: tab_transmitter(lLangue) := '' ||l_contact || '' || EOL;

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

1132: ELSE
1133: tab_transmitter(lLangue) := NULL;
1134: END IF;
1135:
1136: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1137: 'CAEOY_RL1_ACCOUNTING_CONTACT_NAME');
1138:
1139: IF l_contact IS NOT NULL THEN
1140: tab_transmitter(lANom) := '' ||

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

1143: tab_transmitter(lANom) := NULL;
1144: END IF;
1145: hr_utility.trace('tab_transmitter(lANom) = ' || tab_transmitter(lANom));
1146:
1147: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1148: 'CAEOY_RL1_ACCOUNTING_CONTACT_AREA_CODE');
1149:
1150: IF l_contact IS NOT NULL THEN
1151: tab_transmitter(lAIndRegional) := '' || l_contact ||

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

1154: tab_transmitter(lAIndRegional) := NULL;
1155: END IF;
1156: hr_utility.trace('tab_transmitter(lAIndRegional) = ' || tab_transmitter(lAIndRegional));
1157:
1158: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1159: 'CAEOY_RL1_ACCOUNTING_CONTACT_PHONE');
1160:
1161: IF l_contact IS NOT NULL THEN
1162: l_contact := substr(l_contact,1,3) || '-' || substr(l_contact,4,4);

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

1165: tab_transmitter(lATel) := NULL;
1166: END IF;
1167: hr_utility.trace('tab_transmitter(lATel) = ' || tab_transmitter(lATel));
1168:
1169: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1170: 'CAEOY_RL1_ACCOUNTING_CONTACT_EXTENSION');
1171:
1172: IF l_contact IS NOT NULL THEN
1173: tab_transmitter(lAPosteTel) := '' || l_contact ||

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

1177: END IF;
1178: hr_utility.trace('tab_transmitter(lAPosteTel) = ' ||
1179: tab_transmitter(lAPosteTel));
1180:
1181: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1182: 'CAEOY_RL1_ACCOUNTING_CONTACT_LANGUAGE');
1183: IF l_contact IS NOT NULL THEN
1184: tab_transmitter(lALangue) := '' || l_contact ||
1185: '' || EOL;

Line 1798: l_year := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid, 'CAEOY_TAXATION_YEAR');

1794: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1795:
1796: l_authorization_header := 'No d''autorisation :';
1797:
1798: l_year := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid, 'CAEOY_TAXATION_YEAR');
1799:
1800: /*if( l_year ='2006' ) then
1801: l_authorization_code := 'FS-06-01-103';
1802: elsif (l_year ='2007' ) then

Line 1817: lv_rl1_slip_no := pay_ca_archive_utils.get_archive_value(l_arch_action_id,

1813: tab_employee(lAnnee) := '' || l_taxation_year || '' || EOL;
1814: hr_utility.trace('tab_employee(lAnnee) = ' || tab_employee(lAnnee));
1815: --NoReleve
1816: /*Bug 13564765 here*/
1817: lv_rl1_slip_no := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1818: 'CAEOY_RL1_SLIP_NUMBER');
1819: l_return := pay_ca_rl1_mag.get_slip_seq_no('|',lv_rl1_slip_no,1);
1820:
1821: IF l_return IS NULL THEN

Line 1834: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,

1830: hr_utility.trace('tab_employee(lNoReleve) = ' || tab_employee(lNoReleve));
1831: hr_utility.trace('tab_xml_employee(lNoReleve) = ' || tab_xml_employee(lNoReleve)); --
1832:
1833: -- NAS
1834: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1835: 'CAEOY_EMPLOYEE_SIN');
1836:
1837: IF l_return IS NOT NULL THEN
1838: tab_employee(lNAS) := '' || l_return || '' || EOL;

Line 1851: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,

1847: hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));
1848: hr_utility.trace('tab_xml_employee(lNAS) = ' || tab_xml_employee(lNAS));
1849:
1850: -- No
1851: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1852: 'CAEOY_EMPLOYEE_NUMBER');
1853: IF l_return IS NOT NULL THEN
1854: tab_employee(lNo) := '' || pay_ca_rl1_mag.convert_special_char(l_return) || '' || EOL;
1855: tab_xml_employee(lNo) := pay_ca_rl1_mag.convert_special_char(l_return); --

Line 1864: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,

1860: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));
1861: hr_utility.trace('tab_xml_employee(lNo) = ' || tab_xml_employee(lNo)); --
1862:
1863: -- NomFamille
1864: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1865: 'CAEOY_EMPLOYEE_LAST_NAME');
1866: tab_employee(lNomFamille) := '' ||
1867: pay_ca_rl1_mag.convert_special_char(substr(l_name,1,30)) || '' || EOL;
1868: tab_xml_employee(lNomFamille) := pay_ca_rl1_mag.convert_special_char(substr(l_name,1,20)); --

Line 1873: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,

1869: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
1870: hr_utility.trace('tab_xml_employee(lNomFamille) = ' || tab_xml_employee(lNomFamille)); --
1871:
1872: -- Prenom
1873: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1874: 'CAEOY_EMPLOYEE_FIRST_NAME');
1875: IF l_name is NOT NULL THEN
1876: tab_employee(lPrenom) := '' || pay_ca_rl1_mag.convert_special_char(substr(l_name,1,30))
1877: || '' || EOL;

Line 1890: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,

1886: hr_utility.trace('tab_employee(lPrenom) = ' || tab_employee(lPrenom));
1887: hr_utility.trace('tab_xml_employee(lPrenom) = ' || tab_xml_employee(lPrenom)); --
1888:
1889: -- Initiale
1890: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1891: 'CAEOY_EMPLOYEE_INITIAL');
1892: IF l_name is NOT NULL THEN
1893: tab_employee(lInitiale) := '' || substr(l_name,1,1)
1894: || '' || EOL;

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

1900: END IF;
1901: hr_utility.trace('tab_employee(lInitiale) = ' || tab_employee(lInitiale));
1902: hr_utility.trace('tab_xml_employee(lInitiale) = ' || tab_xml_employee(lInitiale)); --
1903:
1904: l_person_id := to_number(pay_ca_archive_utils.get_archive_value(
1905: l_arch_action_id,
1906: 'CAEOY_PERSON_ID'));
1907: /***************************************************************/
1908:

Line 2008: l_box := pay_ca_archive_utils.get_archive_value(

2004:
2005:
2006: -- Summ (Box A)
2007:
2008: l_box := pay_ca_archive_utils.get_archive_value(
2009: l_arch_action_id,
2010: l_province,
2011: 'JURISDICTION_CODE',
2012: 'CAEOY_GROSS_EARNINGS_PER_JD_YTD');

Line 2038: l_box := pay_ca_archive_utils.get_archive_value(

2034: hr_utility.trace('tab_employee(lA_RevenuEmploi) = ' || tab_employee(lA_RevenuEmploi));
2035: hr_utility.trace('tab_xml_employee(lA_RevenuEmploi) = ' || tab_xml_employee(lA_RevenuEmploi));
2036:
2037: -- Summ (Box B)
2038: l_box := pay_ca_archive_utils.get_archive_value(
2039: l_arch_action_id,
2040: l_province,
2041: 'JURISDICTION_CODE',
2042: 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD');

Line 2074: l_box := pay_ca_archive_utils.get_archive_value(

2070: hr_utility.trace('tab_xml_employee(lB_CotisationRRQ) = ' ||
2071: tab_xml_employee(lB_CotisationRRQ)); --
2072:
2073: -- Summ (Box C)
2074: l_box := pay_ca_archive_utils.get_archive_value(
2075: l_arch_action_id,
2076: l_province,
2077: 'JURISDICTION_CODE',
2078: 'CAEOY_EI_EE_WITHHELD_PER_JD_YTD');

Line 2107: l_box := pay_ca_archive_utils.get_archive_value(

2103:
2104: hr_utility.trace('tab_xml_employee(lC_CotisationAssEmploi) = ' ||
2105: tab_xml_employee(lC_CotisationAssEmploi)); --
2106: -- Summ (Box D)
2107: l_box := pay_ca_archive_utils.get_archive_value(
2108: l_arch_action_id,
2109: l_province,
2110: 'JURISDICTION_CODE',
2111: 'CAEOY_RL1_BOXD_PER_JD_YTD');

Line 2141: l_box := pay_ca_archive_utils.get_archive_value(

2137:
2138:
2139: -- (Box E)
2140:
2141: l_box := pay_ca_archive_utils.get_archive_value(
2142: l_arch_action_id,
2143: l_province,
2144: 'JURISDICTION_CODE',
2145: 'CAEOY_PROV_WITHHELD_PER_JD_YTD');

Line 2174: l_box := pay_ca_archive_utils.get_archive_value(

2170: hr_utility.trace('tab_xml_employee(lE_ImpotQue) = ' ||
2171: tab_xml_employee(lE_ImpotQue)); --
2172:
2173: -- (Box F)
2174: l_box := pay_ca_archive_utils.get_archive_value(
2175: l_arch_action_id,
2176: l_province,
2177: 'JURISDICTION_CODE',
2178: 'CAEOY_RL1_BOXF_PER_JD_YTD');

Line 2206: l_box := pay_ca_archive_utils.get_archive_value(

2202:
2203: hr_utility.trace('tab_xml_employee(lF_CotisationSyndicale) = ' ||
2204: tab_xml_employee(lF_CotisationSyndicale));
2205: -- (Box Q)
2206: l_box := pay_ca_archive_utils.get_archive_value(
2207: l_arch_action_id,
2208: l_province,
2209: 'JURISDICTION_CODE',
2210: 'CAEOY_RL1_BOXQ_PER_JD_YTD');

Line 2239: l_box := pay_ca_archive_utils.get_archive_value(

2235:
2236: hr_utility.trace('tab_xml_employee(lQ_SalaireDiffere) = ' ||
2237: tab_xml_employee(lQ_SalaireDiffere));
2238: -- (Box U)
2239: l_box := pay_ca_archive_utils.get_archive_value(
2240: l_arch_action_id,
2241: l_province,
2242: 'JURISDICTION_CODE',
2243: 'CAEOY_RL1_BOXU_PER_JD_YTD');

Line 2274: l_box := pay_ca_archive_utils.get_archive_value(

2270:
2271: hr_utility.trace('tab_xml_employee(lU_RetraiteProgressive) = ' ||
2272: tab_xml_employee(lU_RetraiteProgressive));
2273: -- (Box G)
2274: l_box := pay_ca_archive_utils.get_archive_value(
2275: l_arch_action_id,
2276: l_province,
2277: 'JURISDICTION_CODE',
2278: --commented for bug 13360872

Line 2354: l_box := pay_ca_archive_utils.get_archive_value(

2350: tab_xml_employee(lG_SalaireAdmisRRQ));
2351:
2352:
2353: -- (Box V)
2354: l_box := pay_ca_archive_utils.get_archive_value(
2355: l_arch_action_id,
2356: l_province,
2357: 'JURISDICTION_CODE',
2358: 'CAEOY_RL1_BOXV_PER_JD_YTD');

Line 2387: l_box := pay_ca_archive_utils.get_archive_value(

2383:
2384: hr_utility.trace('tab_xml_employee(lV_NourritureLogement) = ' ||
2385: tab_xml_employee(lV_NourritureLogement));
2386: -- (Box W)
2387: l_box := pay_ca_archive_utils.get_archive_value(
2388: l_arch_action_id,
2389: l_province,
2390: 'JURISDICTION_CODE',
2391: 'CAEOY_RL1_BOXW_PER_JD_YTD');

Line 2420: l_box := pay_ca_archive_utils.get_archive_value(

2416: hr_utility.trace('tab_xml_employee(lW_Vehicule) = ' ||
2417: tab_xml_employee(lW_Vehicule));
2418:
2419: --(BOX H)
2420: l_box := pay_ca_archive_utils.get_archive_value(
2421: l_arch_action_id,
2422: l_province,
2423: 'JURISDICTION_CODE',
2424: 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD');

Line 2452: l_box := pay_ca_archive_utils.get_archive_value(

2448: hr_utility.trace('tab_xml_employee(lH_CotisationRQAP) = ' ||
2449: tab_xml_employee(lH_CotisationRQAP));
2450:
2451: --(BOX I)
2452: l_box := pay_ca_archive_utils.get_archive_value(
2453: l_arch_action_id,
2454: l_province,
2455: 'JURISDICTION_CODE',
2456: -- commented for bug 6623199.

Line 2487: l_box := pay_ca_archive_utils.get_archive_value(

2483: hr_utility.trace('tab_xml_employee(lI_SalaireAdmisRQAP) = ' ||
2484: tab_xml_employee(lI_SalaireAdmisRQAP));
2485:
2486: -- (Box J)
2487: l_box := pay_ca_archive_utils.get_archive_value(
2488: l_arch_action_id,
2489: l_province,
2490: 'JURISDICTION_CODE',
2491: 'CAEOY_RL1_BOXJ_PER_JD_YTD');

Line 2520: l_box := pay_ca_archive_utils.get_archive_value(

2516: hr_utility.trace('tab_xml_employee(lJ_RegimeAssMaladie) = ' ||
2517: tab_xml_employee(lJ_RegimeAssMaladie));
2518:
2519: -- (Box K)
2520: l_box := pay_ca_archive_utils.get_archive_value(
2521: l_arch_action_id,
2522: l_province,
2523: 'JURISDICTION_CODE',
2524: 'CAEOY_RL1_BOXK_PER_JD_YTD');

Line 2552: l_box := pay_ca_archive_utils.get_archive_value(

2548:
2549: hr_utility.trace('tab_xml_employee(lK_Voyage) = ' ||
2550: tab_xml_employee(lK_Voyage));
2551: -- (Box L)
2552: l_box := pay_ca_archive_utils.get_archive_value(
2553: l_arch_action_id,
2554: l_province,
2555: 'JURISDICTION_CODE',
2556: 'CAEOY_RL1_BOXL_PER_JD_YTD');

Line 2584: l_box := pay_ca_archive_utils.get_archive_value(

2580:
2581: hr_utility.trace('tab_xml_employee(lL_AutreAvantage) = ' ||
2582: tab_xml_employee(lL_AutreAvantage));
2583: -- (Box M)
2584: l_box := pay_ca_archive_utils.get_archive_value(
2585: l_arch_action_id,
2586: l_province,
2587: 'JURISDICTION_CODE',
2588: 'CAEOY_RL1_BOXM_PER_JD_YTD');

Line 2616: l_box := pay_ca_archive_utils.get_archive_value(

2612:
2613: hr_utility.trace('tab_xml_employee(lM_Commission) = ' ||
2614: tab_xml_employee(lM_Commission));
2615: -- (Box N)
2616: l_box := pay_ca_archive_utils.get_archive_value(
2617: l_arch_action_id,
2618: l_province,
2619: 'JURISDICTION_CODE',
2620: 'CAEOY_RL1_BOXN_PER_JD_YTD');

Line 2649: l_box := pay_ca_archive_utils.get_archive_value(

2645:
2646: hr_utility.trace('tab_xml_employee(lN_DonBienfaisance) = ' ||
2647: tab_xml_employee(lN_DonBienfaisance));
2648: -- Summ (Box O)
2649: l_box := pay_ca_archive_utils.get_archive_value(
2650: l_arch_action_id,
2651: l_province,
2652: 'JURISDICTION_CODE',
2653: 'CAEOY_RL1_BOXO_PER_JD_YTD');

Line 2685: l_box := pay_ca_archive_utils.get_archive_value(

2681:
2682: -- SourceCasem
2683:
2684: IF to_number(l_boxO) <> 0 THEN
2685: l_box := pay_ca_archive_utils.get_archive_value(
2686: l_arch_action_id,
2687: l_province,
2688: 'JURISDICTION_CODE',
2689: 'CAEOY_RL1_BOXO_CODE_PER_JD_YTD');

Line 2712: l_box := pay_ca_archive_utils.get_archive_value(

2708: ||''||EOL;
2709: else
2710: l_O_AutreRevenu := null;
2711: end if;
2712: l_box := pay_ca_archive_utils.get_archive_value(
2713: l_arch_action_id,
2714: l_province,
2715: 'JURISDICTION_CODE',
2716: 'CAEOY_RL1_BOXP_PER_JD_YTD');

Line 2744: l_box := pay_ca_archive_utils.get_archive_value(

2740:
2741: hr_utility.trace('tab_xml_employee(lP_RegimeAssInterEntr) = ' ||
2742: tab_xml_employee(lP_RegimeAssInterEntr));
2743: -- (Box R)
2744: l_box := pay_ca_archive_utils.get_archive_value(
2745: l_arch_action_id,
2746: l_province,
2747: 'JURISDICTION_CODE',
2748: 'CAEOY_RL1_BOXR_PER_JD_YTD');

Line 2776: l_box := pay_ca_archive_utils.get_archive_value(

2772:
2773: hr_utility.trace('tab_xml_employee(lR_RevenuIndien) = ' ||
2774: tab_xml_employee(lR_RevenuIndien));
2775: -- (Box S)
2776: l_box := pay_ca_archive_utils.get_archive_value(
2777: l_arch_action_id,
2778: l_province,
2779: 'JURISDICTION_CODE',
2780: 'CAEOY_RL1_BOXS_PER_JD_YTD');

Line 2808: l_box := pay_ca_archive_utils.get_archive_value(

2804:
2805: hr_utility.trace('tab_xml_employee(lS_PourboireRecu) = ' ||
2806: tab_xml_employee(lS_PourboireRecu));
2807: -- (Box T)
2808: l_box := pay_ca_archive_utils.get_archive_value(
2809: l_arch_action_id,
2810: l_province,
2811: 'JURISDICTION_CODE',
2812: 'CAEOY_RL1_BOXT_PER_JD_YTD');

Line 2839: l_box := pay_ca_archive_utils.get_archive_value(

2835: tab_employee(lT_PourboireAttribue));
2836: hr_utility.trace('tab_xml_employee(lT_PourboireAttribue) = ' ||
2837: tab_xml_employee(lT_PourboireAttribue));
2838: -- (Box ContisationRPC)
2839: l_box := pay_ca_archive_utils.get_archive_value(
2840: l_arch_action_id,
2841: --l_province,
2842: --'JURISDICTION_CODE',
2843: 'CAEOY_CPP_EE_WITHHELD_PER_YTD');

Line 2869: l_box := pay_ca_archive_utils.get_archive_value(

2865: tab_employee(l_ContisationRPC));
2866:
2867: /* Changes for bug 13567075 starts here -- sbachu*/
2868:
2869: l_box := pay_ca_archive_utils.get_archive_value(
2870: l_arch_action_id,
2871: l_province,
2872: 'JURISDICTION_CODE',
2873: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_201_AMT_PER_JD_YTD');

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

2893: END IF;
2894: hr_utility.trace('tab_employee(l_FraisGarde) = ' ||
2895: tab_employee(l_FraisGarde));
2896:
2897: l_box := fnd_number.number_to_canonical(fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(
2898: l_arch_action_id,
2899: l_province,
2900: 'JURISDICTION_CODE',
2901: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A7_AMT_PER_JD_YTD')) +

Line 2902: fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(

2898: l_arch_action_id,
2899: l_province,
2900: 'JURISDICTION_CODE',
2901: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A7_AMT_PER_JD_YTD')) +
2902: fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(
2903: l_arch_action_id,
2904: l_province,
2905: 'JURISDICTION_CODE',
2906: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A8_AMT_PER_JD_YTD')));

Line 2967: l_box := pay_ca_archive_utils.get_archive_value(

2963: END IF;
2964: /*Bug 13564765 ends here*/
2965: -- Negative Balance Exists
2966: hr_utility.trace('finding if neg bal exists');
2967: l_box := pay_ca_archive_utils.get_archive_value(
2968: l_arch_action_id,
2969: l_province,
2970: 'JURISDICTION_CODE',
2971: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS');

Line 3258: l_quebec_bn := pay_ca_archive_utils.get_archive_value

3254:
3255: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
3256: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
3257:
3258: l_quebec_bn := pay_ca_archive_utils.get_archive_value
3259: (l_context1,'CAEOY_RL1_QUEBEC_BN');
3260:
3261: tab_employer(lNoId) := '' || substr(l_quebec_bn,1,10) ||
3262: '' || EOL;

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

3265: tab_employer(lNoDossier) := '' || substr(l_quebec_bn,13,4) ||
3266: '' || EOL;
3267: tab_employer(lNEQ) := '' || substr(l_quebec_bn,1,10) ||
3268: '' || EOL;
3269: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,
3270: 'CAEOY_RL1_EMPLOYER_NAME');
3271:
3272: tab_employer(lNom1) := '' ||
3273: pay_ca_rl1_mag.convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;

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

3288: hr_utility.trace('tab_employer(lNom2) = ' || tab_employer(lNom2));
3289:
3290: -- Address Line 1
3291:
3292: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3293: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1');
3294:
3295: IF l_address_line IS NULL THEN
3296:

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

3312:
3313:
3314: -- Address Line 2
3315:
3316: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3317: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE2');
3318:
3319: IF l_address_line IS NOT NULL THEN
3320: tab_employer(lLigne2) := '' ||

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

3325: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
3326:
3327: -- Ville (City)
3328:
3329: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3330: 'CAEOY_RL1_EMPLOYER_CITY');
3331: IF l_address_line IS NOT NULL THEN
3332: tab_employer(lVille) := '' ||
3333: pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,30)) || '' || EOL;

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

3337: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
3338:
3339: -- Province
3340:
3341: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3342: 'CAEOY_RL1_EMPLOYER_PROVINCE');
3343:
3344: IF l_address_line IS NOT NULL THEN
3345: tab_employer(lProvince) := '' ||

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

3351: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
3352:
3353: -- Postal Code
3354:
3355: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3356: 'CAEOY_RL1_EMPLOYER_POSTAL_CODE');
3357:
3358: IF l_address_line IS NOT NULL THEN
3359: tab_employer(lCodePostal) := '' ||

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

3454:
3455: cursor c_get_language(p_assgn_id number) is
3456: select decode(correspondence_language,NULL,'US',correspondence_language)
3457: from per_all_people_f
3458: where person_id = to_number(pay_ca_archive_utils.get_archive_value(
3459: p_arch_assact_id,
3460: 'CAEOY_PERSON_ID'));
3461: cursor cur_boxo is
3462: SELECT 'BOXO-'||substr(fdi.user_name,23,2) DB_Name,to_number(fai.value) value

Line 3521: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

3517: SELECT
3518: fnd_global.local_chr(13) || fnd_global.local_chr(10)
3519: INTO EOL
3520: from dual;
3521: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
3522: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
3523: open c_get_language(p_assgn_id);
3524: fetch c_get_language into l_person_lang;
3525: close c_get_language;

Line 3667: l_quebec_bn := pay_ca_archive_utils.get_archive_value

3663: into l_context1;
3664: close c_get_arch_pay_actid;
3665: hr_utility.trace ('l_cvontext1 ='||l_context1);
3666:
3667: l_quebec_bn := pay_ca_archive_utils.get_archive_value
3668: (l_context1,'CAEOY_RL1_QUEBEC_BN');
3669: tab_employer(lNoId) := substr(l_quebec_bn,1,10); -- employer id
3670:
3671: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,

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

3667: l_quebec_bn := pay_ca_archive_utils.get_archive_value
3668: (l_context1,'CAEOY_RL1_QUEBEC_BN');
3669: tab_employer(lNoId) := substr(l_quebec_bn,1,10); -- employer id
3670:
3671: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,
3672: 'CAEOY_RL1_EMPLOYER_NAME');
3673:
3674: tab_employer(lNom1) := pay_ca_rl1_mag.convert_special_char(l_employer_name);
3675: hr_utility.trace('tab_employer(lNoId) = ' || tab_employer(lNoId));

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

3675: hr_utility.trace('tab_employer(lNoId) = ' || tab_employer(lNoId));
3676: hr_utility.trace('tab_employer(lNom1) = ' || tab_employer(lNom1));
3677:
3678: -- Address Line 1
3679: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3680: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1');
3681: tab_employer(lLigne1) := pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,40));
3682: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
3683:

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

3681: tab_employer(lLigne1) := pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,40));
3682: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
3683:
3684: -- Address Line 2
3685: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3686: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE2');
3687: tab_employer(lLigne2) := pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,40));
3688: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
3689:

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

3687: tab_employer(lLigne2) := pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,40));
3688: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
3689:
3690: -- Address Line 3
3691: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3692: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE3');
3693: tab_employer(lLigne3) := pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,40));
3694: hr_utility.trace('tab_employer(lLigne3) = ' || tab_employer(lLigne3));
3695:

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

3697: tab_employer(lLigne2) := tab_employer(lLigne2) ||' '|| tab_employer(lLigne3) ; /*******/
3698: end if;
3699:
3700: -- Ville (City)
3701: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3702: 'CAEOY_RL1_EMPLOYER_CITY');
3703: tab_employer(lVille) := pay_ca_rl1_mag.convert_special_char(substr(l_address_line,1,30));
3704: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
3705:

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

3704: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
3705:
3706: -- Province
3707:
3708: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3709: 'CAEOY_RL1_EMPLOYER_PROVINCE');
3710:
3711: tab_employer(lProvince) :=l_address_line;
3712: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));

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

3711: tab_employer(lProvince) :=l_address_line;
3712: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
3713:
3714: --Country
3715: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3716: 'CAEOY_RL1_EMPLOYER_COUNTRY');
3717: tab_employer(lCountry) :=l_address_line;
3718: hr_utility.trace('tab_employer(lCountry) = ' || tab_employer(lCountry));
3719:

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

3717: tab_employer(lCountry) :=l_address_line;
3718: hr_utility.trace('tab_employer(lCountry) = ' || tab_employer(lCountry));
3719:
3720: -- Postal Code
3721: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3722: 'CAEOY_RL1_EMPLOYER_POSTAL_CODE');
3723: tab_employer(lCodePostal) :=substr(replace(l_address_line,' '),1,6);
3724:
3725: --final city