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

Line 318: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

314: and pai.action_information4 = 'G-1'
315: ) order by code;
316:
317: begin
318: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
319: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
320: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
321: ,'CAEOY_CPP_EE_TAXABLE_PER_YTD');
322:

Line 320: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

316:
317: begin
318: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
319: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
320: l_cpp_taxable := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
321: ,'CAEOY_CPP_EE_TAXABLE_PER_YTD');
322:
323: hr_utility.trace(' l_cpp_withheld ='|| l_cpp_withheld);
324: hr_utility.trace(' p_arch_assact_id ='|| p_arch_assact_id);

Line 935: pay_ca_archive_utils.get_archive_value(l_context1,

931: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
932: tab_transmitter(lTypeEnvoi));
933:
934: tab_transmitter(lProvenance) := '' ||
935: pay_ca_archive_utils.get_archive_value(l_context1,
936: 'CAEOY_RL1_SOURCE_OF_SLIPS') || '' || EOL;
937:
938: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
939:

Line 941: pay_ca_archive_utils.get_archive_value(l_context1,

937:
938: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
939:
940: tab_transmitter(lNo) := '' ||
941: pay_ca_archive_utils.get_archive_value(l_context1,
942: 'CAEOY_RL1_TRANSMITTER_NUMBER') || '' || EOL;
943:
944: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
945:

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

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

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

952: END IF;
953:
954: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));
955:
956: l_transmitter_name := pay_ca_archive_utils.get_archive_value(l_context1,
957: 'CAEOY_RL1_TRANSMITTER_NAME');
958:
959: tab_transmitter(lNom1) := '' ||
960: convert_special_char(substr(l_transmitter_name,1,30)) || '' || EOL;

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

969: END IF;
970:
971: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));
972:
973: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
974: 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE1');
975:
976: tab_transmitter(lLigne1) := '' ||
977: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;

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

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

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

989: END IF;
990:
991: hr_utility.trace('tab_transmitter(lLigne2) = ' || tab_transmitter(lLigne2));
992:
993: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
994: 'CAEOY_RL1_TRANSMITTER_CITY');
995:
996: IF l_address_line IS NOT NULL THEN
997: tab_transmitter(lVille) := '' ||

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

1001: END IF;
1002:
1003: hr_utility.trace('tab_transmitter(lVille) = ' || tab_transmitter(lVille));
1004:
1005: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1006: 'CAEOY_RL1_TRANSMITTER_PROVINCE');
1007:
1008: tab_transmitter(lProvince) := '' ||
1009: SUBSTR(hr_general.decode_lookup(

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

1010: 'CA_PROVINCE',l_address_line),1,20) || '' || EOL;
1011:
1012: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
1013:
1014: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1015: 'CAEOY_RL1_TRANSMITTER_POSTAL_CODE');
1016:
1017: tab_transmitter(lCodePostal) := '' ||
1018: substr(replace(l_address_line,' '),1,6) || '' || EOL;

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

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

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

1030: END IF;
1031:
1032: hr_utility.trace('tab_transmitter(lNom) = ' || tab_transmitter(lNom));
1033:
1034: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1035: 'CAEOY_RL1_TECHNICAL_CONTACT_AREA_CODE');
1036:
1037: IF l_contact IS NOT NULL THEN
1038: tab_transmitter(lIndRegional) := '' ||

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

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

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

1052: tab_transmitter(lTel) := NULL;
1053: END IF;
1054: hr_utility.trace('tab_transmitter(lTel) = ' || tab_transmitter(lTel));
1055:
1056: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1057: 'CAEOY_RL1_TECHNICAL_CONTACT_EXTENSION');
1058:
1059: IF l_contact IS NOT NULL THEN
1060: tab_transmitter(lPosteTel) := '' || l_contact ||

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

1064: END IF;
1065: hr_utility.trace('tab_transmitter(lPosteTel) = ' ||
1066: tab_transmitter(lPosteTel));
1067:
1068: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1069: 'CAEOY_RL1_TECHNICAL_CONTACT_LANGUAGE');
1070:
1071: IF l_contact IS NOT NULL THEN
1072: tab_transmitter(lLangue) := '' ||l_contact || '' || EOL;

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

1073: ELSE
1074: tab_transmitter(lLangue) := NULL;
1075: END IF;
1076:
1077: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1078: 'CAEOY_RL1_ACCOUNTING_CONTACT_NAME');
1079:
1080: IF l_contact IS NOT NULL THEN
1081: tab_transmitter(lANom) := '' ||

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

1084: tab_transmitter(lANom) := NULL;
1085: END IF;
1086: hr_utility.trace('tab_transmitter(lANom) = ' || tab_transmitter(lANom));
1087:
1088: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1089: 'CAEOY_RL1_ACCOUNTING_CONTACT_AREA_CODE');
1090:
1091: IF l_contact IS NOT NULL THEN
1092: tab_transmitter(lAIndRegional) := '' || l_contact ||

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

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

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

1106: tab_transmitter(lATel) := NULL;
1107: END IF;
1108: hr_utility.trace('tab_transmitter(lATel) = ' || tab_transmitter(lATel));
1109:
1110: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1111: 'CAEOY_RL1_ACCOUNTING_CONTACT_EXTENSION');
1112:
1113: IF l_contact IS NOT NULL THEN
1114: tab_transmitter(lAPosteTel) := '' || l_contact ||

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

1118: END IF;
1119: hr_utility.trace('tab_transmitter(lAPosteTel) = ' ||
1120: tab_transmitter(lAPosteTel));
1121:
1122: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
1123: 'CAEOY_RL1_ACCOUNTING_CONTACT_LANGUAGE');
1124: IF l_contact IS NOT NULL THEN
1125: tab_transmitter(lALangue) := '' || l_contact ||
1126: '' || EOL;

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

1690: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1691:
1692: l_authorization_header := 'No d''autorisation :';
1693:
1694: l_year := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid, 'CAEOY_TAXATION_YEAR');
1695:
1696: --Annee
1697: tab_employee(lAnnee) := '' || l_taxation_year || '' || EOL;
1698: hr_utility.trace('tab_employee(lAnnee) = ' || tab_employee(lAnnee));

Line 1701: l_person_id := to_number(pay_ca_archive_utils.get_archive_value(l_arch_action_id,

1697: tab_employee(lAnnee) := '' || l_taxation_year || '' || EOL;
1698: hr_utility.trace('tab_employee(lAnnee) = ' || tab_employee(lAnnee));
1699:
1700: --NoReleve
1701: l_person_id := to_number(pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1702: 'CAEOY_PERSON_ID'));
1703:
1704: hr_utility.trace('XML Employee: l_person_id = ' || to_char(l_person_id));
1705: /*Bug 13564765 starts here*/

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

1733: hr_utility.trace('tab_employee(lNoReleve) = ' || tab_employee(lNoReleve)|| lv_org_slip_no);
1734: hr_utility.trace('tab_xml_employee(lNoReleve) = ' || tab_xml_employee(lNoReleve)); --
1735:
1736: -- NAS
1737: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1738: 'CAEOY_EMPLOYEE_SIN');
1739:
1740: IF l_return IS NOT NULL THEN
1741: tab_employee(lNAS) := '' || l_return || '' || EOL;

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

1750: hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));
1751: hr_utility.trace('tab_xml_employee(lNAS) = ' || tab_xml_employee(lNAS));
1752:
1753: -- No
1754: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1755: 'CAEOY_EMPLOYEE_NUMBER');
1756: IF l_return IS NOT NULL THEN
1757: tab_employee(lNo) := '' || convert_special_char(l_return) || '' || EOL;
1758: tab_xml_employee(lNo) := convert_special_char(l_return); --

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

1763: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));
1764: hr_utility.trace('tab_xml_employee(lNo) = ' || tab_xml_employee(lNo)); --
1765:
1766: -- NomFamille
1767: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1768: 'CAEOY_EMPLOYEE_LAST_NAME');
1769: tab_employee(lNomFamille) := '' ||
1770: convert_special_char(substr(l_name,1,30)) || '' || EOL;
1771: tab_xml_employee(lNomFamille) := convert_special_char(substr(l_name,1,20)); --

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

1772: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
1773: hr_utility.trace('tab_xml_employee(lNomFamille) = ' || tab_xml_employee(lNomFamille)); --
1774:
1775: -- Prenom
1776: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1777: 'CAEOY_EMPLOYEE_FIRST_NAME');
1778: IF l_name is NOT NULL THEN
1779: tab_employee(lPrenom) := '' || convert_special_char(substr(l_name,1,30))
1780: || '' || EOL;

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

1789: hr_utility.trace('tab_employee(lPrenom) = ' || tab_employee(lPrenom));
1790: hr_utility.trace('tab_xml_employee(lPrenom) = ' || tab_xml_employee(lPrenom)); --
1791:
1792: -- Initiale
1793: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1794: 'CAEOY_EMPLOYEE_INITIAL');
1795: IF l_name is NOT NULL THEN
1796: tab_employee(lInitiale) := '' || substr(l_name,1,1)
1797: || '' || EOL;

Line 1906: l_box := pay_ca_archive_utils.get_archive_value(

1902:
1903: --end if;
1904: -- Summ (Box A)
1905:
1906: l_box := pay_ca_archive_utils.get_archive_value(
1907: l_arch_action_id,
1908: l_province,
1909: 'JURISDICTION_CODE',
1910: 'CAEOY_GROSS_EARNINGS_PER_JD_YTD');

Line 1936: l_box := pay_ca_archive_utils.get_archive_value(

1932: hr_utility.trace('tab_employee(lA_RevenuEmploi) = ' || tab_employee(lA_RevenuEmploi));
1933: hr_utility.trace('tab_xml_employee(lA_RevenuEmploi) = ' || tab_xml_employee(lA_RevenuEmploi));
1934:
1935: -- Summ (Box B)
1936: l_box := pay_ca_archive_utils.get_archive_value(
1937: l_arch_action_id,
1938: l_province,
1939: 'JURISDICTION_CODE',
1940: 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD');

Line 1972: l_box := pay_ca_archive_utils.get_archive_value(

1968: hr_utility.trace('tab_xml_employee(lB_CotisationRRQ) = ' ||
1969: tab_xml_employee(lB_CotisationRRQ)); --
1970:
1971: -- Summ (Box C)
1972: l_box := pay_ca_archive_utils.get_archive_value(
1973: l_arch_action_id,
1974: l_province,
1975: 'JURISDICTION_CODE',
1976: 'CAEOY_EI_EE_WITHHELD_PER_JD_YTD');

Line 2005: l_box := pay_ca_archive_utils.get_archive_value(

2001:
2002: hr_utility.trace('tab_xml_employee(lC_CotisationAssEmploi) = ' ||
2003: tab_xml_employee(lC_CotisationAssEmploi)); --
2004: -- Summ (Box D)
2005: l_box := pay_ca_archive_utils.get_archive_value(
2006: l_arch_action_id,
2007: l_province,
2008: 'JURISDICTION_CODE',
2009: 'CAEOY_RL1_BOXD_PER_JD_YTD');

Line 2039: l_box := pay_ca_archive_utils.get_archive_value(

2035:
2036:
2037: -- (Box E)
2038:
2039: l_box := pay_ca_archive_utils.get_archive_value(
2040: l_arch_action_id,
2041: l_province,
2042: 'JURISDICTION_CODE',
2043: 'CAEOY_PROV_WITHHELD_PER_JD_YTD');

Line 2072: l_box := pay_ca_archive_utils.get_archive_value(

2068: hr_utility.trace('tab_xml_employee(lE_ImpotQue) = ' ||
2069: tab_xml_employee(lE_ImpotQue)); --
2070:
2071: -- (Box F)
2072: l_box := pay_ca_archive_utils.get_archive_value(
2073: l_arch_action_id,
2074: l_province,
2075: 'JURISDICTION_CODE',
2076: 'CAEOY_RL1_BOXF_PER_JD_YTD');

Line 2104: l_box := pay_ca_archive_utils.get_archive_value(

2100:
2101: hr_utility.trace('tab_xml_employee(lF_CotisationSyndicale) = ' ||
2102: tab_xml_employee(lF_CotisationSyndicale));
2103: -- (Box Q)
2104: l_box := pay_ca_archive_utils.get_archive_value(
2105: l_arch_action_id,
2106: l_province,
2107: 'JURISDICTION_CODE',
2108: 'CAEOY_RL1_BOXQ_PER_JD_YTD');

Line 2137: l_box := pay_ca_archive_utils.get_archive_value(

2133:
2134: hr_utility.trace('tab_xml_employee(lQ_SalaireDiffere) = ' ||
2135: tab_xml_employee(lQ_SalaireDiffere));
2136: -- (Box U)
2137: l_box := pay_ca_archive_utils.get_archive_value(
2138: l_arch_action_id,
2139: l_province,
2140: 'JURISDICTION_CODE',
2141: 'CAEOY_RL1_BOXU_PER_JD_YTD');

Line 2172: l_box := pay_ca_archive_utils.get_archive_value(

2168:
2169: hr_utility.trace('tab_xml_employee(lU_RetraiteProgressive) = ' ||
2170: tab_xml_employee(lU_RetraiteProgressive));
2171: -- (Box G)
2172: l_box := pay_ca_archive_utils.get_archive_value(
2173: l_arch_action_id,
2174: l_province,
2175: 'JURISDICTION_CODE',
2176: --commented for bug 13360872

Line 2249: l_box := pay_ca_archive_utils.get_archive_value(

2245: tab_employee(lG_SalaireAdmisRRQ));
2246: END IF;
2247:
2248: -- (Box V)
2249: l_box := pay_ca_archive_utils.get_archive_value(
2250: l_arch_action_id,
2251: l_province,
2252: 'JURISDICTION_CODE',
2253: 'CAEOY_RL1_BOXV_PER_JD_YTD');

Line 2282: l_box := pay_ca_archive_utils.get_archive_value(

2278:
2279: hr_utility.trace('tab_xml_employee(lV_NourritureLogement) = ' ||
2280: tab_xml_employee(lV_NourritureLogement));
2281: -- (Box W)
2282: l_box := pay_ca_archive_utils.get_archive_value(
2283: l_arch_action_id,
2284: l_province,
2285: 'JURISDICTION_CODE',
2286: 'CAEOY_RL1_BOXW_PER_JD_YTD');

Line 2315: l_box := pay_ca_archive_utils.get_archive_value(

2311: hr_utility.trace('tab_xml_employee(lW_Vehicule) = ' ||
2312: tab_xml_employee(lW_Vehicule));
2313:
2314: --(BOX H)
2315: l_box := pay_ca_archive_utils.get_archive_value(
2316: l_arch_action_id,
2317: l_province,
2318: 'JURISDICTION_CODE',
2319: 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD');

Line 2347: l_box := pay_ca_archive_utils.get_archive_value(

2343: hr_utility.trace('tab_xml_employee(lH_CotisationRQAP) = ' ||
2344: tab_xml_employee(lH_CotisationRQAP));
2345:
2346: --(BOX I)
2347: l_box := pay_ca_archive_utils.get_archive_value(
2348: l_arch_action_id,
2349: l_province,
2350: 'JURISDICTION_CODE',
2351: -- commented for bug 6623199.

Line 2382: l_box := pay_ca_archive_utils.get_archive_value(

2378: hr_utility.trace('tab_xml_employee(lI_SalaireAdmisRQAP) = ' ||
2379: tab_xml_employee(lI_SalaireAdmisRQAP));
2380:
2381: -- (Box J)
2382: l_box := pay_ca_archive_utils.get_archive_value(
2383: l_arch_action_id,
2384: l_province,
2385: 'JURISDICTION_CODE',
2386: 'CAEOY_RL1_BOXJ_PER_JD_YTD');

Line 2415: l_box := pay_ca_archive_utils.get_archive_value(

2411: hr_utility.trace('tab_xml_employee(lJ_RegimeAssMaladie) = ' ||
2412: tab_xml_employee(lJ_RegimeAssMaladie));
2413:
2414: -- (Box K)
2415: l_box := pay_ca_archive_utils.get_archive_value(
2416: l_arch_action_id,
2417: l_province,
2418: 'JURISDICTION_CODE',
2419: 'CAEOY_RL1_BOXK_PER_JD_YTD');

Line 2447: l_box := pay_ca_archive_utils.get_archive_value(

2443:
2444: hr_utility.trace('tab_xml_employee(lK_Voyage) = ' ||
2445: tab_xml_employee(lK_Voyage));
2446: -- (Box L)
2447: l_box := pay_ca_archive_utils.get_archive_value(
2448: l_arch_action_id,
2449: l_province,
2450: 'JURISDICTION_CODE',
2451: 'CAEOY_RL1_BOXL_PER_JD_YTD');

Line 2479: l_box := pay_ca_archive_utils.get_archive_value(

2475:
2476: hr_utility.trace('tab_xml_employee(lL_AutreAvantage) = ' ||
2477: tab_xml_employee(lL_AutreAvantage));
2478: -- (Box M)
2479: l_box := pay_ca_archive_utils.get_archive_value(
2480: l_arch_action_id,
2481: l_province,
2482: 'JURISDICTION_CODE',
2483: 'CAEOY_RL1_BOXM_PER_JD_YTD');

Line 2511: l_box := pay_ca_archive_utils.get_archive_value(

2507:
2508: hr_utility.trace('tab_xml_employee(lM_Commission) = ' ||
2509: tab_xml_employee(lM_Commission));
2510: -- (Box N)
2511: l_box := pay_ca_archive_utils.get_archive_value(
2512: l_arch_action_id,
2513: l_province,
2514: 'JURISDICTION_CODE',
2515: 'CAEOY_RL1_BOXN_PER_JD_YTD');

Line 2544: l_box := pay_ca_archive_utils.get_archive_value(

2540:
2541: hr_utility.trace('tab_xml_employee(lN_DonBienfaisance) = ' ||
2542: tab_xml_employee(lN_DonBienfaisance));
2543: -- Summ (Box O)
2544: l_box := pay_ca_archive_utils.get_archive_value(
2545: l_arch_action_id,
2546: l_province,
2547: 'JURISDICTION_CODE',
2548: 'CAEOY_RL1_BOXO_PER_JD_YTD');

Line 2580: l_box := pay_ca_archive_utils.get_archive_value(

2576:
2577: -- SourceCasem
2578:
2579: IF to_number(l_boxO) <> 0 THEN
2580: l_box := pay_ca_archive_utils.get_archive_value(
2581: l_arch_action_id,
2582: l_province,
2583: 'JURISDICTION_CODE',
2584: 'CAEOY_RL1_BOXO_CODE_PER_JD_YTD');

Line 2607: l_box := pay_ca_archive_utils.get_archive_value(

2603: ||''||EOL;
2604: else
2605: l_O_AutreRevenu := null;
2606: end if;
2607: l_box := pay_ca_archive_utils.get_archive_value(
2608: l_arch_action_id,
2609: l_province,
2610: 'JURISDICTION_CODE',
2611: 'CAEOY_RL1_BOXP_PER_JD_YTD');

Line 2639: l_box := pay_ca_archive_utils.get_archive_value(

2635:
2636: hr_utility.trace('tab_xml_employee(lP_RegimeAssInterEntr) = ' ||
2637: tab_xml_employee(lP_RegimeAssInterEntr));
2638: -- (Box R)
2639: l_box := pay_ca_archive_utils.get_archive_value(
2640: l_arch_action_id,
2641: l_province,
2642: 'JURISDICTION_CODE',
2643: 'CAEOY_RL1_BOXR_PER_JD_YTD');

Line 2671: l_box := pay_ca_archive_utils.get_archive_value(

2667:
2668: hr_utility.trace('tab_xml_employee(lR_RevenuIndien) = ' ||
2669: tab_xml_employee(lR_RevenuIndien));
2670: -- (Box S)
2671: l_box := pay_ca_archive_utils.get_archive_value(
2672: l_arch_action_id,
2673: l_province,
2674: 'JURISDICTION_CODE',
2675: 'CAEOY_RL1_BOXS_PER_JD_YTD');

Line 2703: l_box := pay_ca_archive_utils.get_archive_value(

2699:
2700: hr_utility.trace('tab_xml_employee(lS_PourboireRecu) = ' ||
2701: tab_xml_employee(lS_PourboireRecu));
2702: -- (Box T)
2703: l_box := pay_ca_archive_utils.get_archive_value(
2704: l_arch_action_id,
2705: l_province,
2706: 'JURISDICTION_CODE',
2707: 'CAEOY_RL1_BOXT_PER_JD_YTD');

Line 2734: l_box := pay_ca_archive_utils.get_archive_value(

2730: tab_employee(lT_PourboireAttribue));
2731: hr_utility.trace('tab_xml_employee(lT_PourboireAttribue) = ' ||
2732: tab_xml_employee(lT_PourboireAttribue));
2733: -- (Box ContisationRPC)
2734: l_box := pay_ca_archive_utils.get_archive_value(
2735: l_arch_action_id,
2736: --l_province,
2737: --'JURISDICTION_CODE',
2738: 'CAEOY_CPP_EE_WITHHELD_PER_YTD');

Line 2764: l_box := pay_ca_archive_utils.get_archive_value(

2760: tab_employee(l_ContisationRPC));
2761:
2762: /* Changes for bug 13567075 starts here -- sbachu*/
2763:
2764: l_box := pay_ca_archive_utils.get_archive_value(
2765: l_arch_action_id,
2766: l_province,
2767: 'JURISDICTION_CODE',
2768: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_201_AMT_PER_JD_YTD');

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

2787: END IF;
2788: hr_utility.trace('tab_employee(l_FraisGarde) = ' ||
2789: tab_employee(l_FraisGarde));
2790:
2791: l_box := fnd_number.number_to_canonical(fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(
2792: l_arch_action_id,
2793: l_province,
2794: 'JURISDICTION_CODE',
2795: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A7_AMT_PER_JD_YTD')) +

Line 2796: fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(

2792: l_arch_action_id,
2793: l_province,
2794: 'JURISDICTION_CODE',
2795: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A7_AMT_PER_JD_YTD')) +
2796: fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(
2797: l_arch_action_id,
2798: l_province,
2799: 'JURISDICTION_CODE',
2800: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_A8_AMT_PER_JD_YTD')));

Line 2829: l_box := pay_ca_archive_utils.get_archive_value(

2825:
2826:
2827: -- Negative Balance Exists
2828: hr_utility.trace('finding if neg bal exists');
2829: l_box := pay_ca_archive_utils.get_archive_value(
2830: l_arch_action_id,
2831: l_province,
2832: 'JURISDICTION_CODE',
2833: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS');

Line 3135: l_quebec_bn := pay_ca_archive_utils.get_archive_value

3131:
3132: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
3133: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
3134:
3135: l_quebec_bn := pay_ca_archive_utils.get_archive_value
3136: (l_context1,'CAEOY_RL1_QUEBEC_BN');
3137:
3138: tab_employer(lNoId) := '' || substr(l_quebec_bn,1,10) ||
3139: '' || EOL;

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

3142: tab_employer(lNoDossier) := '' || substr(l_quebec_bn,13,4) ||
3143: '' || EOL;
3144: tab_employer(lNEQ) := '' || substr(l_quebec_bn,1,10) ||
3145: '' || EOL;
3146: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,
3147: 'CAEOY_RL1_EMPLOYER_NAME');
3148:
3149: tab_employer(lNom1) := '' ||
3150: convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;

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

3165: hr_utility.trace('tab_employer(lNom2) = ' || tab_employer(lNom2));
3166:
3167: -- Address Line 1
3168:
3169: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3170: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1');
3171:
3172: IF l_address_line IS NULL THEN
3173:

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

3189:
3190:
3191: -- Address Line 2
3192:
3193: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3194: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE2');
3195:
3196: IF l_address_line IS NOT NULL THEN
3197: tab_employer(lLigne2) := '' ||

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

3202: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
3203:
3204: -- Ville (City)
3205:
3206: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3207: 'CAEOY_RL1_EMPLOYER_CITY');
3208: IF l_address_line IS NOT NULL THEN
3209: tab_employer(lVille) := '' ||
3210: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;

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

3214: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
3215:
3216: -- Province
3217:
3218: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3219: 'CAEOY_RL1_EMPLOYER_PROVINCE');
3220:
3221: IF l_address_line IS NOT NULL THEN
3222: tab_employer(lProvince) := '' ||

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

3228: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
3229:
3230: -- Postal Code
3231:
3232: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
3233: 'CAEOY_RL1_EMPLOYER_POSTAL_CODE');
3234:
3235: IF l_address_line IS NOT NULL THEN
3236: tab_employer(lCodePostal) := '' ||