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 726: pay_ca_archive_utils.get_archive_value(l_context1,

722: hr_utility.trace('tab_transmitter(lAnnee) = ' || tab_transmitter(lAnnee));
723:
724: -- TypeEnvoi
725: tab_transmitter(lTypeEnvoi) := '' ||
726: pay_ca_archive_utils.get_archive_value(l_context1,
727: 'CAEOY_RL1_TRANSMITTER_PACKAGE_TYPE') || '' || EOL;
728: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
729: tab_transmitter(lTypeEnvoi));
730:

Line 732: pay_ca_archive_utils.get_archive_value(l_context1,

728: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
729: tab_transmitter(lTypeEnvoi));
730:
731: tab_transmitter(lProvenance) := '' ||
732: pay_ca_archive_utils.get_archive_value(l_context1,
733: 'CAEOY_RL1_SOURCE_OF_SLIPS') || '' || EOL;
734:
735: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
736:

Line 738: pay_ca_archive_utils.get_archive_value(l_context1,

734:
735: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
736:
737: tab_transmitter(lNo) := '' ||
738: pay_ca_archive_utils.get_archive_value(l_context1,
739: 'CAEOY_RL1_TRANSMITTER_NUMBER') || '' || EOL;
740:
741: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
742:

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

739: 'CAEOY_RL1_TRANSMITTER_NUMBER') || '' || EOL;
740:
741: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
742:
743: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
744: 'CAEOY_RL1_TRANSMITTER_TYPE');
745: IF l_return IS NOT NULL THEN
746: tab_transmitter(lType) := '' || l_return || '' || EOL;
747: ELSE

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

749: END IF;
750:
751: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));
752:
753: l_transmitter_name := pay_ca_archive_utils.get_archive_value(l_context1,
754: 'CAEOY_RL1_TRANSMITTER_NAME');
755:
756: tab_transmitter(lNom1) := '' ||
757: convert_special_char(substr(l_transmitter_name,1,30)) || '' || EOL;

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

766: END IF;
767:
768: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));
769:
770: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
771: 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE1');
772:
773: tab_transmitter(lLigne1) := '' ||
774: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;

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

774: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;
775:
776: hr_utility.trace('tab_transmitter(lLigne1) = ' || tab_transmitter(lLigne1));
777:
778: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
779: 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE2');
780:
781: IF l_address_line IS NOT NULL THEN
782: tab_transmitter(lLigne2) := '' ||

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

786: END IF;
787:
788: hr_utility.trace('tab_transmitter(lLigne2) = ' || tab_transmitter(lLigne2));
789:
790: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
791: 'CAEOY_RL1_TRANSMITTER_CITY');
792:
793: IF l_address_line IS NOT NULL THEN
794: tab_transmitter(lVille) := '' ||

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

798: END IF;
799:
800: hr_utility.trace('tab_transmitter(lVille) = ' || tab_transmitter(lVille));
801:
802: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
803: 'CAEOY_RL1_TRANSMITTER_PROVINCE');
804:
805: tab_transmitter(lProvince) := '' ||
806: SUBSTR(hr_general.decode_lookup(

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

807: 'CA_PROVINCE',l_address_line),1,20) || '' || EOL;
808:
809: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
810:
811: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
812: 'CAEOY_RL1_TRANSMITTER_POSTAL_CODE');
813:
814: tab_transmitter(lCodePostal) := '' ||
815: substr(replace(l_address_line,' '),1,6) || '' || EOL;

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

815: substr(replace(l_address_line,' '),1,6) || '' || EOL;
816:
817: hr_utility.trace('tab_transmitter(lCodePostal) = ' || tab_transmitter(lCodePostal));
818:
819: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
820: 'CAEOY_RL1_TECHNICAL_CONTACT_NAME');
821:
822: IF l_contact IS NOT NULL THEN
823: tab_transmitter(lNom) := '' ||

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

827: END IF;
828:
829: hr_utility.trace('tab_transmitter(lNom) = ' || tab_transmitter(lNom));
830:
831: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
832: 'CAEOY_RL1_TECHNICAL_CONTACT_AREA_CODE');
833:
834: IF l_contact IS NOT NULL THEN
835: tab_transmitter(lIndRegional) := '' ||

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

839: END IF;
840:
841: hr_utility.trace('tab_transmitter(lIndRegional) = ' || tab_transmitter(lIndRegional));
842:
843: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
844: 'CAEOY_RL1_TECHNICAL_CONTACT_PHONE');
845: IF l_contact IS NOT NULL THEN
846: l_contact := substr(l_contact,1,3) || '-' || substr(l_contact,4,4);
847: tab_transmitter(lTel) := '' || l_contact || '' || EOL;

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

849: tab_transmitter(lTel) := NULL;
850: END IF;
851: hr_utility.trace('tab_transmitter(lTel) = ' || tab_transmitter(lTel));
852:
853: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
854: 'CAEOY_RL1_TECHNICAL_CONTACT_EXTENSION');
855:
856: IF l_contact IS NOT NULL THEN
857: tab_transmitter(lPosteTel) := '' || l_contact ||

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

861: END IF;
862: hr_utility.trace('tab_transmitter(lPosteTel) = ' ||
863: tab_transmitter(lPosteTel));
864:
865: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
866: 'CAEOY_RL1_TECHNICAL_CONTACT_LANGUAGE');
867:
868: IF l_contact IS NOT NULL THEN
869: tab_transmitter(lLangue) := '' ||l_contact || '' || EOL;

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

870: ELSE
871: tab_transmitter(lLangue) := NULL;
872: END IF;
873:
874: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
875: 'CAEOY_RL1_ACCOUNTING_CONTACT_NAME');
876:
877: IF l_contact IS NOT NULL THEN
878: tab_transmitter(lANom) := '' ||

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

881: tab_transmitter(lANom) := NULL;
882: END IF;
883: hr_utility.trace('tab_transmitter(lANom) = ' || tab_transmitter(lANom));
884:
885: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
886: 'CAEOY_RL1_ACCOUNTING_CONTACT_AREA_CODE');
887:
888: IF l_contact IS NOT NULL THEN
889: tab_transmitter(lAIndRegional) := '' || l_contact ||

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

892: tab_transmitter(lAIndRegional) := NULL;
893: END IF;
894: hr_utility.trace('tab_transmitter(lAIndRegional) = ' || tab_transmitter(lAIndRegional));
895:
896: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
897: 'CAEOY_RL1_ACCOUNTING_CONTACT_PHONE');
898:
899: IF l_contact IS NOT NULL THEN
900: l_contact := substr(l_contact,1,3) || '-' || substr(l_contact,4,4);

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

903: tab_transmitter(lATel) := NULL;
904: END IF;
905: hr_utility.trace('tab_transmitter(lATel) = ' || tab_transmitter(lATel));
906:
907: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
908: 'CAEOY_RL1_ACCOUNTING_CONTACT_EXTENSION');
909:
910: IF l_contact IS NOT NULL THEN
911: tab_transmitter(lAPosteTel) := '' || l_contact ||

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

915: END IF;
916: hr_utility.trace('tab_transmitter(lAPosteTel) = ' ||
917: tab_transmitter(lAPosteTel));
918:
919: l_contact := pay_ca_archive_utils.get_archive_value(l_context1,
920: 'CAEOY_RL1_ACCOUNTING_CONTACT_LANGUAGE');
921: IF l_contact IS NOT NULL THEN
922: tab_transmitter(lALangue) := '' || l_contact ||
923: '' || EOL;

Line 1413: if( pay_ca_archive_utils.get_archive_value(l_arch_pay_actid, 'CAEOY_TAXATION_YEAR')='2006' ) then

1409: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1410:
1411: l_authorization_header := 'No d''autorisation :';
1412:
1413: if( pay_ca_archive_utils.get_archive_value(l_arch_pay_actid, 'CAEOY_TAXATION_YEAR')='2006' ) then
1414: l_authorization_code := 'FS-06-01-103';
1415: else
1416: l_authorization_code := 'FS-07-01-107'; --Bug 6747916
1417: end if;

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

1419: --Annee
1420: tab_employee(lAnnee) := '' || l_taxation_year || '' || EOL;
1421: hr_utility.trace('tab_employee(lAnnee) = ' || tab_employee(lAnnee));
1422: --NoReleve
1423: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1424: 'CAEOY_RL1_SLIP_NUMBER');
1425:
1426: IF l_return IS NULL THEN
1427: l_status := 'Failed';

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

1435: hr_utility.trace('tab_employee(lNoReleve) = ' || tab_employee(lNoReleve));
1436: hr_utility.trace('tab_xml_employee(lNoReleve) = ' || tab_xml_employee(lNoReleve)); --
1437:
1438: -- NAS
1439: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1440: 'CAEOY_EMPLOYEE_SIN');
1441:
1442: IF l_return IS NOT NULL THEN
1443: tab_employee(lNAS) := '' || l_return || '' || EOL;

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

1452: hr_utility.trace('tab_employee(lNAS) = ' || tab_employee(lNAS));
1453: hr_utility.trace('tab_xml_employee(lNAS) = ' || tab_xml_employee(lNAS));
1454:
1455: -- No
1456: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1457: 'CAEOY_EMPLOYEE_NUMBER');
1458: IF l_return IS NOT NULL THEN
1459: tab_employee(lNo) := '' || convert_special_char(l_return) || '' || EOL;
1460: tab_xml_employee(lNo) := convert_special_char(l_return); --

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

1465: hr_utility.trace('tab_employee(lNo) = ' || tab_employee(lNo));
1466: hr_utility.trace('tab_xml_employee(lNo) = ' || tab_xml_employee(lNo)); --
1467:
1468: -- NomFamille
1469: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1470: 'CAEOY_EMPLOYEE_LAST_NAME');
1471: tab_employee(lNomFamille) := '' ||
1472: convert_special_char(substr(l_name,1,30)) || '' || EOL;
1473: tab_xml_employee(lNomFamille) := convert_special_char(substr(l_name,1,20)); --

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

1474: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
1475: hr_utility.trace('tab_xml_employee(lNomFamille) = ' || tab_xml_employee(lNomFamille)); --
1476:
1477: -- Prenom
1478: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1479: 'CAEOY_EMPLOYEE_FIRST_NAME');
1480: IF l_name is NOT NULL THEN
1481: tab_employee(lPrenom) := '' || convert_special_char(substr(l_name,1,30))
1482: || '' || EOL;

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

1491: hr_utility.trace('tab_employee(lPrenom) = ' || tab_employee(lPrenom));
1492: hr_utility.trace('tab_xml_employee(lPrenom) = ' || tab_xml_employee(lPrenom)); --
1493:
1494: -- Initiale
1495: l_name := pay_ca_archive_utils.get_archive_value(l_arch_action_id,
1496: 'CAEOY_EMPLOYEE_INITIAL');
1497: IF l_name is NOT NULL THEN
1498: tab_employee(lInitiale) := '' || substr(l_name,1,1)
1499: || '' || EOL;

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

1505: END IF;
1506: hr_utility.trace('tab_employee(lInitiale) = ' || tab_employee(lInitiale));
1507: hr_utility.trace('tab_xml_employee(lInitiale) = ' || tab_xml_employee(lInitiale)); --
1508:
1509: l_person_id := to_number(pay_ca_archive_utils.get_archive_value(
1510: l_arch_action_id,
1511: 'CAEOY_PERSON_ID'));
1512: /***************************************************************/
1513: if(l_rep_type='RL1PAPERPDF') then

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

1510: l_arch_action_id,
1511: 'CAEOY_PERSON_ID'));
1512: /***************************************************************/
1513: if(l_rep_type='RL1PAPERPDF') then
1514: l_person_id1 := to_number(pay_ca_archive_utils.get_archive_value(
1515: l_arch_action_id,
1516: 'CAEOY_PERSON_ID'));
1517:
1518: select trunc(sysdate) into l_session_date from dual;

Line 1525: tab_xml_employee(lForm_number) := pay_ca_archive_utils.get_archive_value(l_mag_asg_action_id, --l_arch_action_id,

1521: addr := pay_ca_rl1_reg.get_primary_address(l_person_id1, l_session_date);
1522: tab_xml_employee(lLigne1) := convert_special_char(substr(addr.addr_line_1,1,40));
1523: tab_xml_employee(lLigne2) := convert_special_char(substr(addr.addr_line_2,1,40)||' '||substr(addr.addr_line_3,1,40));
1524: tab_xml_employee(lVille) := convert_special_char(substr(addr.addr_line_4,1,40));
1525: tab_xml_employee(lForm_number) := pay_ca_archive_utils.get_archive_value(l_mag_asg_action_id, --l_arch_action_id,
1526: 'CAEOY_RL1_PRE_PRINTED_FORM_NO');
1527: hr_utility.trace('tab_xml_employee(lForm_number) = ' || tab_xml_employee(lForm_number));
1528:
1529:

Line 1530: tab_xml_employee(lAnnee) := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid,

1526: 'CAEOY_RL1_PRE_PRINTED_FORM_NO');
1527: hr_utility.trace('tab_xml_employee(lForm_number) = ' || tab_xml_employee(lForm_number));
1528:
1529:
1530: tab_xml_employee(lAnnee) := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid,
1531: 'CAEOY_TAXATION_YEAR');
1532: hr_utility.trace('tab_xml_employee(lAnnee) = ' || tab_xml_employee(lAnnee)); --
1533: /***************************** *****************************/
1534: else /***if not paper report***/

Line 1634: l_box := pay_ca_archive_utils.get_archive_value(

1630:
1631: end if; /***************end of address******/ --
1632: -- Summ (Box A)
1633:
1634: l_box := pay_ca_archive_utils.get_archive_value(
1635: l_arch_action_id,
1636: l_province,
1637: 'JURISDICTION_CODE',
1638: 'CAEOY_GROSS_EARNINGS_PER_JD_YTD');

Line 1664: l_box := pay_ca_archive_utils.get_archive_value(

1660: hr_utility.trace('tab_employee(lA_RevenuEmploi) = ' || tab_employee(lA_RevenuEmploi));
1661: hr_utility.trace('tab_xml_employee(lA_RevenuEmploi) = ' || tab_xml_employee(lA_RevenuEmploi));
1662:
1663: -- Summ (Box B)
1664: l_box := pay_ca_archive_utils.get_archive_value(
1665: l_arch_action_id,
1666: l_province,
1667: 'JURISDICTION_CODE',
1668: 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD');

Line 1700: l_box := pay_ca_archive_utils.get_archive_value(

1696: hr_utility.trace('tab_xml_employee(lB_CotisationRRQ) = ' ||
1697: tab_xml_employee(lB_CotisationRRQ)); --
1698:
1699: -- Summ (Box C)
1700: l_box := pay_ca_archive_utils.get_archive_value(
1701: l_arch_action_id,
1702: l_province,
1703: 'JURISDICTION_CODE',
1704: 'CAEOY_EI_EE_WITHHELD_PER_JD_YTD');

Line 1733: l_box := pay_ca_archive_utils.get_archive_value(

1729:
1730: hr_utility.trace('tab_xml_employee(lC_CotisationAssEmploi) = ' ||
1731: tab_xml_employee(lC_CotisationAssEmploi)); --
1732: -- Summ (Box D)
1733: l_box := pay_ca_archive_utils.get_archive_value(
1734: l_arch_action_id,
1735: l_province,
1736: 'JURISDICTION_CODE',
1737: 'CAEOY_RL1_BOXD_PER_JD_YTD');

Line 1767: l_box := pay_ca_archive_utils.get_archive_value(

1763:
1764:
1765: -- (Box E)
1766:
1767: l_box := pay_ca_archive_utils.get_archive_value(
1768: l_arch_action_id,
1769: l_province,
1770: 'JURISDICTION_CODE',
1771: 'CAEOY_PROV_WITHHELD_PER_JD_YTD');

Line 1800: l_box := pay_ca_archive_utils.get_archive_value(

1796: hr_utility.trace('tab_xml_employee(lE_ImpotQue) = ' ||
1797: tab_xml_employee(lE_ImpotQue)); --
1798:
1799: -- (Box F)
1800: l_box := pay_ca_archive_utils.get_archive_value(
1801: l_arch_action_id,
1802: l_province,
1803: 'JURISDICTION_CODE',
1804: 'CAEOY_RL1_BOXF_PER_JD_YTD');

Line 1832: l_box := pay_ca_archive_utils.get_archive_value(

1828:
1829: hr_utility.trace('tab_xml_employee(lF_CotisationSyndicale) = ' ||
1830: tab_xml_employee(lF_CotisationSyndicale));
1831: -- (Box Q)
1832: l_box := pay_ca_archive_utils.get_archive_value(
1833: l_arch_action_id,
1834: l_province,
1835: 'JURISDICTION_CODE',
1836: 'CAEOY_RL1_BOXQ_PER_JD_YTD');

Line 1865: l_box := pay_ca_archive_utils.get_archive_value(

1861:
1862: hr_utility.trace('tab_xml_employee(lQ_SalaireDiffere) = ' ||
1863: tab_xml_employee(lQ_SalaireDiffere));
1864: -- (Box U)
1865: l_box := pay_ca_archive_utils.get_archive_value(
1866: l_arch_action_id,
1867: l_province,
1868: 'JURISDICTION_CODE',
1869: 'CAEOY_RL1_BOXU_PER_JD_YTD');

Line 1900: l_box := pay_ca_archive_utils.get_archive_value(

1896:
1897: hr_utility.trace('tab_xml_employee(lU_RetraiteProgressive) = ' ||
1898: tab_xml_employee(lU_RetraiteProgressive));
1899: -- (Box G)
1900: l_box := pay_ca_archive_utils.get_archive_value(
1901: l_arch_action_id,
1902: l_province,
1903: 'JURISDICTION_CODE',
1904: 'CAEOY_QPP_REDUCED_SUBJECT_PER_JD_YTD');

Line 1987: l_box := pay_ca_archive_utils.get_archive_value(

1983: END IF;
1984:
1985:
1986: -- (Box V)
1987: l_box := pay_ca_archive_utils.get_archive_value(
1988: l_arch_action_id,
1989: l_province,
1990: 'JURISDICTION_CODE',
1991: 'CAEOY_RL1_BOXV_PER_JD_YTD');

Line 2020: l_box := pay_ca_archive_utils.get_archive_value(

2016:
2017: hr_utility.trace('tab_xml_employee(lV_NourritureLogement) = ' ||
2018: tab_xml_employee(lV_NourritureLogement));
2019: -- (Box W)
2020: l_box := pay_ca_archive_utils.get_archive_value(
2021: l_arch_action_id,
2022: l_province,
2023: 'JURISDICTION_CODE',
2024: 'CAEOY_RL1_BOXW_PER_JD_YTD');

Line 2053: l_box := pay_ca_archive_utils.get_archive_value(

2049: hr_utility.trace('tab_xml_employee(lW_Vehicule) = ' ||
2050: tab_xml_employee(lW_Vehicule));
2051:
2052: --(BOX H)
2053: l_box := pay_ca_archive_utils.get_archive_value(
2054: l_arch_action_id,
2055: l_province,
2056: 'JURISDICTION_CODE',
2057: 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD');

Line 2085: l_box := pay_ca_archive_utils.get_archive_value(

2081: hr_utility.trace('tab_xml_employee(lH_CotisationRQAP) = ' ||
2082: tab_xml_employee(lH_CotisationRQAP));
2083:
2084: --(BOX I)
2085: l_box := pay_ca_archive_utils.get_archive_value(
2086: l_arch_action_id,
2087: l_province,
2088: 'JURISDICTION_CODE',
2089: -- commented for bug 6623199.

Line 2120: l_box := pay_ca_archive_utils.get_archive_value(

2116: hr_utility.trace('tab_xml_employee(lI_SalaireAdmisRQAP) = ' ||
2117: tab_xml_employee(lI_SalaireAdmisRQAP));
2118:
2119: -- (Box J)
2120: l_box := pay_ca_archive_utils.get_archive_value(
2121: l_arch_action_id,
2122: l_province,
2123: 'JURISDICTION_CODE',
2124: 'CAEOY_RL1_BOXJ_PER_JD_YTD');

Line 2153: l_box := pay_ca_archive_utils.get_archive_value(

2149: hr_utility.trace('tab_xml_employee(lJ_RegimeAssMaladie) = ' ||
2150: tab_xml_employee(lJ_RegimeAssMaladie));
2151:
2152: -- (Box K)
2153: l_box := pay_ca_archive_utils.get_archive_value(
2154: l_arch_action_id,
2155: l_province,
2156: 'JURISDICTION_CODE',
2157: 'CAEOY_RL1_BOXK_PER_JD_YTD');

Line 2185: l_box := pay_ca_archive_utils.get_archive_value(

2181:
2182: hr_utility.trace('tab_xml_employee(lK_Voyage) = ' ||
2183: tab_xml_employee(lK_Voyage));
2184: -- (Box L)
2185: l_box := pay_ca_archive_utils.get_archive_value(
2186: l_arch_action_id,
2187: l_province,
2188: 'JURISDICTION_CODE',
2189: 'CAEOY_RL1_BOXL_PER_JD_YTD');

Line 2217: l_box := pay_ca_archive_utils.get_archive_value(

2213:
2214: hr_utility.trace('tab_xml_employee(lL_AutreAvantage) = ' ||
2215: tab_xml_employee(lL_AutreAvantage));
2216: -- (Box M)
2217: l_box := pay_ca_archive_utils.get_archive_value(
2218: l_arch_action_id,
2219: l_province,
2220: 'JURISDICTION_CODE',
2221: 'CAEOY_RL1_BOXM_PER_JD_YTD');

Line 2249: l_box := pay_ca_archive_utils.get_archive_value(

2245:
2246: hr_utility.trace('tab_xml_employee(lM_Commission) = ' ||
2247: tab_xml_employee(lM_Commission));
2248: -- (Box N)
2249: l_box := pay_ca_archive_utils.get_archive_value(
2250: l_arch_action_id,
2251: l_province,
2252: 'JURISDICTION_CODE',
2253: 'CAEOY_RL1_BOXN_PER_JD_YTD');

Line 2282: l_box := pay_ca_archive_utils.get_archive_value(

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

Line 2318: l_box := pay_ca_archive_utils.get_archive_value(

2314:
2315: -- SourceCasem
2316:
2317: IF to_number(l_boxO) <> 0 THEN
2318: l_box := pay_ca_archive_utils.get_archive_value(
2319: l_arch_action_id,
2320: l_province,
2321: 'JURISDICTION_CODE',
2322: 'CAEOY_RL1_BOXO_CODE_PER_JD_YTD');

Line 2345: l_box := pay_ca_archive_utils.get_archive_value(

2341: ||''||EOL;
2342: else
2343: l_O_AutreRevenu := null;
2344: end if;
2345: l_box := pay_ca_archive_utils.get_archive_value(
2346: l_arch_action_id,
2347: l_province,
2348: 'JURISDICTION_CODE',
2349: 'CAEOY_RL1_BOXP_PER_JD_YTD');

Line 2377: l_box := pay_ca_archive_utils.get_archive_value(

2373:
2374: hr_utility.trace('tab_xml_employee(lP_RegimeAssInterEntr) = ' ||
2375: tab_xml_employee(lP_RegimeAssInterEntr));
2376: -- (Box R)
2377: l_box := pay_ca_archive_utils.get_archive_value(
2378: l_arch_action_id,
2379: l_province,
2380: 'JURISDICTION_CODE',
2381: 'CAEOY_RL1_BOXR_PER_JD_YTD');

Line 2409: l_box := pay_ca_archive_utils.get_archive_value(

2405:
2406: hr_utility.trace('tab_xml_employee(lR_RevenuIndien) = ' ||
2407: tab_xml_employee(lR_RevenuIndien));
2408: -- (Box S)
2409: l_box := pay_ca_archive_utils.get_archive_value(
2410: l_arch_action_id,
2411: l_province,
2412: 'JURISDICTION_CODE',
2413: 'CAEOY_RL1_BOXS_PER_JD_YTD');

Line 2441: l_box := pay_ca_archive_utils.get_archive_value(

2437:
2438: hr_utility.trace('tab_xml_employee(lS_PourboireRecu) = ' ||
2439: tab_xml_employee(lS_PourboireRecu));
2440: -- (Box T)
2441: l_box := pay_ca_archive_utils.get_archive_value(
2442: l_arch_action_id,
2443: l_province,
2444: 'JURISDICTION_CODE',
2445: 'CAEOY_RL1_BOXT_PER_JD_YTD');

Line 2472: l_box := pay_ca_archive_utils.get_archive_value(

2468: tab_employee(lT_PourboireAttribue));
2469: hr_utility.trace('tab_xml_employee(lT_PourboireAttribue) = ' ||
2470: tab_xml_employee(lT_PourboireAttribue));
2471: -- (Box ContisationRPC)
2472: l_box := pay_ca_archive_utils.get_archive_value(
2473: l_arch_action_id,
2474: --l_province,
2475: --'JURISDICTION_CODE',
2476: 'CAEOY_CPP_EE_WITHHELD_PER_YTD');

Line 2501: l_box := pay_ca_archive_utils.get_archive_value(

2497: tab_employee(l_ContisationRPC));
2498:
2499: -- Negative Balance Exists
2500: hr_utility.trace('finding if neg bal exists');
2501: l_box := pay_ca_archive_utils.get_archive_value(
2502: l_arch_action_id,
2503: l_province,
2504: 'JURISDICTION_CODE',
2505: 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS');

Line 2522: l_box := pay_ca_archive_utils.get_archive_value(

2518:
2519: IF l_status = 'Failed' and l_rep_type <>'RL1PAPERPDF' THEN
2520:
2521: -- Box A, 01
2522: l_box := pay_ca_archive_utils.get_archive_value(
2523: l_arch_action_id,
2524: l_province,
2525: 'JURISDICTION_CODE',
2526: 'CAEOY_RL1_BOXA_01_AMT_PER_JD_YTD');

Line 2544: l_box := pay_ca_archive_utils.get_archive_value(

2540: hr_utility.trace('tab_employee(lBoxA_01) = ' ||
2541: tab_employee(lBoxA_01));
2542:
2543: -- Box A, 02
2544: l_box := pay_ca_archive_utils.get_archive_value(
2545: l_arch_action_id,
2546: l_province,
2547: 'JURISDICTION_CODE',
2548: 'CAEOY_RL1_BOXA_02_AMT_PER_JD_YTD');

Line 2566: l_box := pay_ca_archive_utils.get_archive_value(

2562: hr_utility.trace('tab_employee(lBoxA_02) = ' ||
2563: tab_employee(lBoxA_02));
2564:
2565: -- Box A, 15
2566: l_box := pay_ca_archive_utils.get_archive_value(
2567: l_arch_action_id,
2568: l_province,
2569: 'JURISDICTION_CODE',
2570: 'CAEOY_RL1_BOXA_15_AMT_PER_JD_YTD');

Line 2588: l_box := pay_ca_archive_utils.get_archive_value(

2584: hr_utility.trace('tab_employee(lBoxA_15) = ' ||
2585: tab_employee(lBoxA_15));
2586:
2587: -- Box A, 16
2588: l_box := pay_ca_archive_utils.get_archive_value(
2589: l_arch_action_id,
2590: l_province,
2591: 'JURISDICTION_CODE',
2592: 'CAEOY_RL1_BOXA_16_AMT_PER_JD_YTD');

Line 2610: l_box := pay_ca_archive_utils.get_archive_value(

2606: hr_utility.trace('tab_employee(lBoxA_16) = ' ||
2607: tab_employee(lBoxA_16));
2608:
2609: -- Box A, 17
2610: l_box := pay_ca_archive_utils.get_archive_value(
2611: l_arch_action_id,
2612: l_province,
2613: 'JURISDICTION_CODE',
2614: 'CAEOY_RL1_BOXA_17_AMT_PER_JD_YTD');

Line 2632: l_box := pay_ca_archive_utils.get_archive_value(

2628: hr_utility.trace('tab_employee(lBoxA_17) = ' ||
2629: tab_employee(lBoxA_17));
2630:
2631: -- Box A, 18
2632: l_box := pay_ca_archive_utils.get_archive_value(
2633: l_arch_action_id,
2634: l_province,
2635: 'JURISDICTION_CODE',
2636: 'CAEOY_RL1_BOXA_18_AMT_PER_JD_YTD');

Line 2654: l_box := pay_ca_archive_utils.get_archive_value(

2650: hr_utility.trace('tab_employee(lBoxA_18) = ' ||
2651: tab_employee(lBoxA_18));
2652:
2653: -- Box A, 19
2654: l_box := pay_ca_archive_utils.get_archive_value(
2655: l_arch_action_id,
2656: l_province,
2657: 'JURISDICTION_CODE',
2658: 'CAEOY_RL1_BOXA_19_AMT_PER_JD_YTD');

Line 2676: l_box := pay_ca_archive_utils.get_archive_value(

2672: hr_utility.trace('tab_employee(lBoxA_19) = ' ||
2673: tab_employee(lBoxA_19));
2674:
2675: -- Box A, 25
2676: l_box := pay_ca_archive_utils.get_archive_value(
2677: l_arch_action_id,
2678: l_province,
2679: 'JURISDICTION_CODE',
2680: 'CAEOY_RL1_BOXA_25_AMT_PER_JD_YTD');

Line 2698: l_box := pay_ca_archive_utils.get_archive_value(

2694: hr_utility.trace('tab_employee(lBoxA_25) = ' ||
2695: tab_employee(lBoxA_25));
2696:
2697: -- Box A, 26
2698: l_box := pay_ca_archive_utils.get_archive_value(
2699: l_arch_action_id,
2700: l_province,
2701: 'JURISDICTION_CODE',
2702: 'CAEOY_RL1_BOXA_26_AMT_PER_JD_YTD');

Line 2720: l_box := pay_ca_archive_utils.get_archive_value(

2716: hr_utility.trace('tab_employee(lBoxA_26) = ' ||
2717: tab_employee(lBoxA_26));
2718:
2719: -- Box A, 27
2720: l_box := pay_ca_archive_utils.get_archive_value(
2721: l_arch_action_id,
2722: l_province,
2723: 'JURISDICTION_CODE',
2724: 'CAEOY_RL1_BOXA_27_AMT_PER_JD_YTD');

Line 2742: l_box := pay_ca_archive_utils.get_archive_value(

2738: hr_utility.trace('tab_employee(lBoxA_27) = ' ||
2739: tab_employee(lBoxA_27));
2740:
2741: -- Box A, 29
2742: l_box := pay_ca_archive_utils.get_archive_value(
2743: l_arch_action_id,
2744: l_province,
2745: 'JURISDICTION_CODE',
2746: 'CAEOY_RL1_BOXA_29_AMT_PER_JD_YTD');

Line 2764: l_box := pay_ca_archive_utils.get_archive_value(

2760: hr_utility.trace('tab_employee(lBoxA_27) = ' ||
2761: tab_employee(lBoxA_29));
2762:
2763: -- Box A, 30
2764: l_box := pay_ca_archive_utils.get_archive_value(
2765: l_arch_action_id,
2766: l_province,
2767: 'JURISDICTION_CODE',
2768: 'CAEOY_RL1_BOXA_30_AMT_PER_JD_YTD');

Line 2786: l_box := pay_ca_archive_utils.get_archive_value(

2782: hr_utility.trace('tab_employee(lBoxA_30) = ' ||
2783: tab_employee(lBoxA_30));
2784:
2785: -- Box D, 07
2786: l_box := pay_ca_archive_utils.get_archive_value(
2787: l_arch_action_id,
2788: l_province,
2789: 'JURISDICTION_CODE',
2790: 'CAEOY_RL1_BOXD_07_AMT_PER_JD_YTD');

Line 2808: l_box := pay_ca_archive_utils.get_archive_value(

2804: hr_utility.trace('tab_employee(lBoxD_07) = ' ||
2805: tab_employee(lBoxD_07));
2806:
2807: -- Box D, 08
2808: l_box := pay_ca_archive_utils.get_archive_value(
2809: l_arch_action_id,
2810: l_province,
2811: 'JURISDICTION_CODE',
2812: 'CAEOY_RL1_BOXD_08_AMT_PER_JD_YTD');

Line 2830: l_box := pay_ca_archive_utils.get_archive_value(

2826: hr_utility.trace('tab_employee(lBoxD_08) = ' ||
2827: tab_employee(lBoxD_08));
2828:
2829: -- Box D, 20
2830: l_box := pay_ca_archive_utils.get_archive_value(
2831: l_arch_action_id,
2832: l_province,
2833: 'JURISDICTION_CODE',
2834: 'CAEOY_RL1_BOXD_20_AMT_PER_JD_YTD');

Line 2852: l_box := pay_ca_archive_utils.get_archive_value(

2848: hr_utility.trace('tab_employee(lBoxD_20) = ' ||
2849: tab_employee(lBoxD_20));
2850:
2851: -- Box K, 11
2852: l_box := pay_ca_archive_utils.get_archive_value(
2853: l_arch_action_id,
2854: l_province,
2855: 'JURISDICTION_CODE',
2856: 'CAEOY_RL1_BOXK_11_AMT_PER_JD_YTD');

Line 2874: l_box := pay_ca_archive_utils.get_archive_value(

2870: hr_utility.trace('tab_employee(lBoxK_11) = ' ||
2871: tab_employee(lBoxK_11));
2872:
2873: -- Box O, RA
2874: l_box := pay_ca_archive_utils.get_archive_value(
2875: l_arch_action_id,
2876: l_province,
2877: 'JURISDICTION_CODE',
2878: 'CAEOY_RL1_BOXO_AMOUNT_RA_PER_JD_YTD');

Line 2896: l_box := pay_ca_archive_utils.get_archive_value(

2892: hr_utility.trace('tab_employee(lBoxO_RA) = ' ||
2893: tab_employee(lBoxO_RA));
2894:
2895: -- Box O, RB
2896: l_box := pay_ca_archive_utils.get_archive_value(
2897: l_arch_action_id,
2898: l_province,
2899: 'JURISDICTION_CODE',
2900: 'CAEOY_RL1_BOXO_AMOUNT_RB_PER_JD_YTD');

Line 2918: l_box := pay_ca_archive_utils.get_archive_value(

2914: hr_utility.trace('tab_employee(lBoxO_RB) = ' ||
2915: tab_employee(lBoxO_RB));
2916:
2917: -- Box O, RC
2918: l_box := pay_ca_archive_utils.get_archive_value(
2919: l_arch_action_id,
2920: l_province,
2921: 'JURISDICTION_CODE',
2922: 'CAEOY_RL1_BOXC_AMOUNT_RA_PER_JD_YTD');

Line 2940: l_box := pay_ca_archive_utils.get_archive_value(

2936: hr_utility.trace('tab_employee(lBoxO_RC) = ' ||
2937: tab_employee(lBoxO_RC));
2938:
2939: -- Box O, RD
2940: l_box := pay_ca_archive_utils.get_archive_value(
2941: l_arch_action_id,
2942: l_province,
2943: 'JURISDICTION_CODE',
2944: 'CAEOY_RL1_BOXO_AMOUNT_RD_PER_JD_YTD');

Line 2962: l_box := pay_ca_archive_utils.get_archive_value(

2958: hr_utility.trace('tab_employee(lBoxO_RD) = ' ||
2959: tab_employee(lBoxO_RD));
2960:
2961: -- Box O, RE
2962: l_box := pay_ca_archive_utils.get_archive_value(
2963: l_arch_action_id,
2964: l_province,
2965: 'JURISDICTION_CODE',
2966: 'CAEOY_RL1_BOXO_AMOUNT_RE_PER_JD_YTD');

Line 2984: l_box := pay_ca_archive_utils.get_archive_value(

2980: hr_utility.trace('tab_employee(lBoxO_RE) = ' ||
2981: tab_employee(lBoxO_RE));
2982:
2983: -- Box O, RF
2984: l_box := pay_ca_archive_utils.get_archive_value(
2985: l_arch_action_id,
2986: l_province,
2987: 'JURISDICTION_CODE',
2988: 'CAEOY_RL1_BOXO_AMOUNT_RF_PER_JD_YTD');

Line 3006: l_box := pay_ca_archive_utils.get_archive_value(

3002: hr_utility.trace('tab_employee(lBoxO_RF) = ' ||
3003: tab_employee(lBoxO_RF));
3004:
3005: -- Box O, RG
3006: l_box := pay_ca_archive_utils.get_archive_value(
3007: l_arch_action_id,
3008: l_province,
3009: 'JURISDICTION_CODE',
3010: 'CAEOY_RL1_BOXO_AMOUNT_RG_PER_JD_YTD');

Line 3028: l_box := pay_ca_archive_utils.get_archive_value(

3024: hr_utility.trace('tab_employee(lBoxO_RG) = ' ||
3025: tab_employee(lBoxO_RG));
3026:
3027: -- Box O, RH
3028: l_box := pay_ca_archive_utils.get_archive_value(
3029: l_arch_action_id,
3030: l_province,
3031: 'JURISDICTION_CODE',
3032: 'CAEOY_RL1_BOXO_AMOUNT_RH_PER_JD_YTD');

Line 3050: l_box := pay_ca_archive_utils.get_archive_value(

3046: hr_utility.trace('tab_employee(lBoxO_RH) = ' ||
3047: tab_employee(lBoxO_RH));
3048:
3049: -- Box O, RI
3050: l_box := pay_ca_archive_utils.get_archive_value(
3051: l_arch_action_id,
3052: l_province,
3053: 'JURISDICTION_CODE',
3054: 'CAEOY_RL1_BOXO_AMOUNT_RI_PER_JD_YTD');

Line 3072: l_box := pay_ca_archive_utils.get_archive_value(

3068: hr_utility.trace('tab_employee(lBoxO_RI) = ' ||
3069: tab_employee(lBoxO_RI));
3070:
3071: -- Box O, RJ
3072: l_box := pay_ca_archive_utils.get_archive_value(
3073: l_arch_action_id,
3074: l_province,
3075: 'JURISDICTION_CODE',
3076: 'CAEOY_RL1_BOXO_AMOUNT_RJ_PER_JD_YTD');

Line 3094: l_box := pay_ca_archive_utils.get_archive_value(

3090: hr_utility.trace('tab_employee(lBoxO_RJ) = ' ||
3091: tab_employee(lBoxO_RJ));
3092:
3093: -- Box O, RK
3094: l_box := pay_ca_archive_utils.get_archive_value(
3095: l_arch_action_id,
3096: l_province,
3097: 'JURISDICTION_CODE',
3098: 'CAEOY_RL1_BOXO_AMOUNT_RK_PER_JD_YTD');

Line 3116: l_box := pay_ca_archive_utils.get_archive_value(

3112: hr_utility.trace('tab_employee(lBoxO_RK) = ' ||
3113: tab_employee(lBoxO_RK));
3114:
3115: -- Box O, RL
3116: l_box := pay_ca_archive_utils.get_archive_value(
3117: l_arch_action_id,
3118: l_province,
3119: 'JURISDICTION_CODE',
3120: 'CAEOY_RL1_BOXO_AMOUNT_RL_PER_JD_YTD');

Line 3138: l_box := pay_ca_archive_utils.get_archive_value(

3134: hr_utility.trace('tab_employee(lBoxO_RL) = ' ||
3135: tab_employee(lBoxO_RL));
3136:
3137: -- Box O, RL(22)
3138: l_box := pay_ca_archive_utils.get_archive_value(
3139: l_arch_action_id,
3140: l_province,
3141: 'JURISDICTION_CODE',
3142: 'CAEOY_RL1_BOXO_AMOUNT_RL_22_AMT_PER_JD_YTD');

Line 3160: l_box := pay_ca_archive_utils.get_archive_value(

3156: hr_utility.trace('tab_employee(lBoxO_RL22) = ' ||
3157: tab_employee(lBoxO_RL22));
3158:
3159: -- Box O, RL(28)
3160: l_box := pay_ca_archive_utils.get_archive_value(
3161: l_arch_action_id,
3162: l_province,
3163: 'JURISDICTION_CODE',
3164: 'CAEOY_RL1_BOXO_AMOUNT_RL_28_AMT_PER_JD_YTD');

Line 3182: l_box := pay_ca_archive_utils.get_archive_value(

3178: hr_utility.trace('tab_employee(lBoxO_RL28) = ' ||
3179: tab_employee(lBoxO_RL28));
3180:
3181: -- Box O, RM
3182: l_box := pay_ca_archive_utils.get_archive_value(
3183: l_arch_action_id,
3184: l_province,
3185: 'JURISDICTION_CODE',
3186: 'CAEOY_RL1_BOXO_AMOUNT_RM_PER_JD_YTD');

Line 3204: l_box := pay_ca_archive_utils.get_archive_value(

3200: hr_utility.trace('tab_employee(lBoxO_RM) = ' ||
3201: tab_employee(lBoxO_RM));
3202:
3203: -- Box O, RN
3204: l_box := pay_ca_archive_utils.get_archive_value(
3205: l_arch_action_id,
3206: l_province,
3207: 'JURISDICTION_CODE',
3208: 'CAEOY_RL1_BOXO_AMOUNT_RN_PER_JD_YTD');

Line 3228: l_box := pay_ca_archive_utils.get_archive_value(

3224:
3225: hr_utility.trace('l_person_id = ' || to_char(l_person_id));
3226:
3227: -- Box O, RN 31
3228: l_box := pay_ca_archive_utils.get_archive_value(
3229: l_arch_action_id,
3230: l_province,
3231: 'JURISDICTION_CODE',
3232: 'CAEOY_RL1_BOXO_AMOUNT_RN_31_AMT_PER_JD_YTD');

Line 3249: l_box := pay_ca_archive_utils.get_archive_value(

3245: END IF;
3246: hr_utility.trace('tab_employee(lBoxO_RN_31) = ' ||
3247: tab_employee(lBoxO_RN_31));
3248: -- Box O, RO
3249: l_box := pay_ca_archive_utils.get_archive_value(
3250: l_arch_action_id,
3251: l_province,
3252: 'JURISDICTION_CODE',
3253: 'CAEOY_RL1_BOXO_AMOUNT_RO_PER_JD_YTD');

Line 3271: l_box := pay_ca_archive_utils.get_archive_value(

3267: hr_utility.trace('tab_employee(lBoxO_RO) = ' ||
3268: tab_employee(lBoxO_RO));
3269:
3270: -- Box O, RP
3271: l_box := pay_ca_archive_utils.get_archive_value(
3272: l_arch_action_id,
3273: l_province,
3274: 'JURISDICTION_CODE',
3275: 'CAEOY_RL1_BOXO_AMOUNT_RP_PER_JD_YTD');

Line 3293: l_box := pay_ca_archive_utils.get_archive_value(

3289: hr_utility.trace('tab_employee(lBoxO_RP) = ' ||
3290: tab_employee(lBoxO_RP));
3291:
3292: -- Box O, RQ
3293: l_box := pay_ca_archive_utils.get_archive_value(
3294: l_arch_action_id,
3295: l_province,
3296: 'JURISDICTION_CODE',
3297: 'CAEOY_RL1_BOXO_AMOUNT_RQ_PER_JD_YTD');

Line 3315: l_box := pay_ca_archive_utils.get_archive_value(

3311: hr_utility.trace('tab_employee(lBoxO_RQ) = ' ||
3312: tab_employee(lBoxO_RQ));
3313:
3314: -- Box O, RR
3315: l_box := pay_ca_archive_utils.get_archive_value(
3316: l_arch_action_id,
3317: l_province,
3318: 'JURISDICTION_CODE',
3319: 'CAEOY_RL1_BOXO_AMOUNT_RR_PER_JD_YTD');

Line 3337: l_box := pay_ca_archive_utils.get_archive_value(

3333: hr_utility.trace('tab_employee(lBoxO_RR) = ' ||
3334: tab_employee(lBoxO_RR));
3335:
3336: -- Box O, RS
3337: l_box := pay_ca_archive_utils.get_archive_value(
3338: l_arch_action_id,
3339: l_province,
3340: 'JURISDICTION_CODE',
3341: 'CAEOY_RL1_BOXO_AMOUNT_RS_PER_JD_YTD');

Line 3359: l_box := pay_ca_archive_utils.get_archive_value(

3355: hr_utility.trace('tab_employee(lBoxO_RS) = ' ||
3356: tab_employee(lBoxO_RS));
3357:
3358: -- Box O, RT
3359: l_box := pay_ca_archive_utils.get_archive_value(
3360: l_arch_action_id,
3361: l_province,
3362: 'JURISDICTION_CODE',
3363: 'CAEOY_RL1_BOXO_AMOUNT_RT_PER_JD_YTD');

Line 3381: l_box := pay_ca_archive_utils.get_archive_value(

3377: hr_utility.trace('tab_employee(lBoxO_RT) = ' ||
3378: tab_employee(lBoxO_RT));
3379:
3380: -- Box O, RU
3381: l_box := pay_ca_archive_utils.get_archive_value(
3382: l_arch_action_id,
3383: l_province,
3384: 'JURISDICTION_CODE',
3385: 'CAEOY_RL1_BOXO_AMOUNT_RU_PER_JD_YTD');

Line 3403: l_box := pay_ca_archive_utils.get_archive_value(

3399: hr_utility.trace('tab_employee(lBoxO_RU) = ' ||
3400: tab_employee(lBoxO_RU));
3401:
3402: -- Box O, RV
3403: l_box := pay_ca_archive_utils.get_archive_value(
3404: l_arch_action_id,
3405: l_province,
3406: 'JURISDICTION_CODE',
3407: 'CAEOY_RL1_BOXO_AMOUNT_RV_PER_JD_YTD');

Line 3425: l_box := pay_ca_archive_utils.get_archive_value(

3421: hr_utility.trace('tab_employee(lBoxO_RV) = ' ||
3422: tab_employee(lBoxO_RV));
3423:
3424: -- Box O, RW
3425: l_box := pay_ca_archive_utils.get_archive_value(
3426: l_arch_action_id,
3427: l_province,
3428: 'JURISDICTION_CODE',
3429: 'CAEOY_RL1_BOXO_AMOUNT_RW_PER_JD_YTD');

Line 3447: l_box := pay_ca_archive_utils.get_archive_value(

3443: hr_utility.trace('tab_employee(lBoxO_RW) = ' ||
3444: tab_employee(lBoxO_RW));
3445:
3446: -- Box Q, 24
3447: l_box := pay_ca_archive_utils.get_archive_value(
3448: l_arch_action_id,
3449: l_province,
3450: 'JURISDICTION_CODE',
3451: 'CAEOY_RL1_BOXQ_24_AMT_PER_JD_YTD');

Line 3469: l_box := pay_ca_archive_utils.get_archive_value(

3465: hr_utility.trace('tab_employee(lBoxQ_24) = ' ||
3466: tab_employee(lBoxQ_24));
3467:
3468: -- Box R, 14
3469: l_box := pay_ca_archive_utils.get_archive_value(
3470: l_arch_action_id,
3471: l_province,
3472: 'JURISDICTION_CODE',
3473: 'CAEOY_RL1_BOXR_14_AMT_PER_JD_YTD');

Line 4198: l_quebec_bn := pay_ca_archive_utils.get_archive_value

4194:
4195: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;
4196: tab_employer(lNbReleves) := '' || 'Running Total' || '' || EOL;
4197:
4198: l_quebec_bn := pay_ca_archive_utils.get_archive_value
4199: (l_context1,'CAEOY_RL1_QUEBEC_BN');
4200:
4201: tab_employer(lNoId) := '' || substr(l_quebec_bn,1,10) ||
4202: '' || EOL;

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

4205: tab_employer(lNoDossier) := '' || substr(l_quebec_bn,13,4) ||
4206: '' || EOL;
4207: tab_employer(lNEQ) := '' || substr(l_quebec_bn,1,10) ||
4208: '' || EOL;
4209: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,
4210: 'CAEOY_RL1_EMPLOYER_NAME');
4211:
4212: tab_employer(lNom1) := '' ||
4213: convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;

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

4228: hr_utility.trace('tab_employer(lNom2) = ' || tab_employer(lNom2));
4229:
4230: -- Address Line 1
4231:
4232: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4233: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1');
4234:
4235: IF l_address_line IS NULL THEN
4236:

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

4252:
4253:
4254: -- Address Line 2
4255:
4256: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4257: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE2');
4258:
4259: IF l_address_line IS NOT NULL THEN
4260: tab_employer(lLigne2) := '' ||

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

4265: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
4266:
4267: -- Ville (City)
4268:
4269: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4270: 'CAEOY_RL1_EMPLOYER_CITY');
4271: IF l_address_line IS NOT NULL THEN
4272: tab_employer(lVille) := '' ||
4273: convert_special_char(substr(l_address_line,1,30)) || '' || EOL;

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

4277: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
4278:
4279: -- Province
4280:
4281: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4282: 'CAEOY_RL1_EMPLOYER_PROVINCE');
4283:
4284: IF l_address_line IS NOT NULL THEN
4285: tab_employer(lProvince) := '' ||

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

4291: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
4292:
4293: -- Postal Code
4294:
4295: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4296: 'CAEOY_RL1_EMPLOYER_POSTAL_CODE');
4297:
4298: IF l_address_line IS NOT NULL THEN
4299: tab_employer(lCodePostal) := '' ||

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

4394:
4395: cursor c_get_language(p_assgn_id number) is
4396: select decode(correspondence_language,NULL,'US',correspondence_language)
4397: from per_all_people_f
4398: where person_id = to_number(pay_ca_archive_utils.get_archive_value(
4399: p_arch_assact_id,
4400: 'CAEOY_PERSON_ID'));
4401: cursor cur_boxo is
4402: SELECT 'BOXO-'||substr(fdi.user_name,23,2) DB_Name,to_number(fai.value) value

Line 4461: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id

4457: SELECT
4458: fnd_global.local_chr(13) || fnd_global.local_chr(10)
4459: INTO EOL
4460: from dual;
4461: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
4462: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
4463: open c_get_language(p_assgn_id);
4464: fetch c_get_language into l_person_lang;
4465: close c_get_language;

Line 4608: l_quebec_bn := pay_ca_archive_utils.get_archive_value

4604: into l_context1;
4605: close c_get_arch_pay_actid;
4606: hr_utility.trace ('l_cvontext1 ='||l_context1);
4607:
4608: l_quebec_bn := pay_ca_archive_utils.get_archive_value
4609: (l_context1,'CAEOY_RL1_QUEBEC_BN');
4610: tab_employer(lNoId) := substr(l_quebec_bn,1,10); -- employer id
4611:
4612: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,

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

4608: l_quebec_bn := pay_ca_archive_utils.get_archive_value
4609: (l_context1,'CAEOY_RL1_QUEBEC_BN');
4610: tab_employer(lNoId) := substr(l_quebec_bn,1,10); -- employer id
4611:
4612: l_employer_name := pay_ca_archive_utils.get_archive_value(l_context1,
4613: 'CAEOY_RL1_EMPLOYER_NAME');
4614:
4615: tab_employer(lNom1) := convert_special_char(l_employer_name);
4616: hr_utility.trace('tab_employer(lNoId) = ' || tab_employer(lNoId));

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

4616: hr_utility.trace('tab_employer(lNoId) = ' || tab_employer(lNoId));
4617: hr_utility.trace('tab_employer(lNom1) = ' || tab_employer(lNom1));
4618:
4619: -- Address Line 1
4620: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4621: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1');
4622: tab_employer(lLigne1) := convert_special_char(substr(l_address_line,1,40));
4623: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
4624:

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

4622: tab_employer(lLigne1) := convert_special_char(substr(l_address_line,1,40));
4623: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
4624:
4625: -- Address Line 2
4626: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4627: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE2');
4628: tab_employer(lLigne2) := convert_special_char(substr(l_address_line,1,40));
4629: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
4630:

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

4628: tab_employer(lLigne2) := convert_special_char(substr(l_address_line,1,40));
4629: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));
4630:
4631: -- Address Line 3
4632: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4633: 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE3');
4634: tab_employer(lLigne3) := convert_special_char(substr(l_address_line,1,40));
4635: hr_utility.trace('tab_employer(lLigne3) = ' || tab_employer(lLigne3));
4636:

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

4638: tab_employer(lLigne2) := tab_employer(lLigne2) ||' '|| tab_employer(lLigne3) ; /*******/
4639: end if;
4640:
4641: -- Ville (City)
4642: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4643: 'CAEOY_RL1_EMPLOYER_CITY');
4644: tab_employer(lVille) := convert_special_char(substr(l_address_line,1,30));
4645: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
4646:

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

4645: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));
4646:
4647: -- Province
4648:
4649: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4650: 'CAEOY_RL1_EMPLOYER_PROVINCE');
4651:
4652: tab_employer(lProvince) :=l_address_line;
4653: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));

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

4652: tab_employer(lProvince) :=l_address_line;
4653: hr_utility.trace('tab_employer(lProvince) = ' || tab_employer(lProvince));
4654:
4655: --Country
4656: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4657: 'CAEOY_RL1_EMPLOYER_COUNTRY');
4658: tab_employer(lCountry) :=l_address_line;
4659: hr_utility.trace('tab_employer(lCountry) = ' || tab_employer(lCountry));
4660:

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

4658: tab_employer(lCountry) :=l_address_line;
4659: hr_utility.trace('tab_employer(lCountry) = ' || tab_employer(lCountry));
4660:
4661: -- Postal Code
4662: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
4663: 'CAEOY_RL1_EMPLOYER_POSTAL_CODE');
4664: tab_employer(lCodePostal) :=substr(replace(l_address_line,' '),1,6);
4665:
4666: --final city