APPS.PAY_CA_T4_XML dependencies on PAY_CA_ARCHIVE_UTILS

Line 461: pay_ca_archive_utils.get_archive_value(p_assignment_action_id, p_province,

457: hr_utility.trace('payroll_action_id '||l_pa_id);
458:
459: lv_negative_bal_flag := 'N';
460: lv_negative_bal_flag :=
461: pay_ca_archive_utils.get_archive_value(p_assignment_action_id, p_province,
462: 'JURISDICTION_CODE',
463: 'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');
464:
465: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);

Line 692: pay_ca_archive_utils.get_archive_value(p_pa_id,

688: and paa.tax_unit_id = hou.organization_id;
689:
690: begin
691: lv_year :=
692: pay_ca_archive_utils.get_archive_value(p_pa_id,
693: 'CAEOY_TAXATION_YEAR'); -- year
694:
695: lv_employer_name :=
696: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 696: pay_ca_archive_utils.get_archive_value(p_pa_id,

692: pay_ca_archive_utils.get_archive_value(p_pa_id,
693: 'CAEOY_TAXATION_YEAR'); -- year
694:
695: lv_employer_name :=
696: pay_ca_archive_utils.get_archive_value(p_pa_id,
697: 'CAEOY_EMPLOYER_NAME'); -- employer name
698:
699: if p_print = 'Y' then
700:

Line 702: pay_ca_archive_utils.get_archive_value(p_pa_id,

698:
699: if p_print = 'Y' then
700:
701: lv_employer_address1 :=
702: pay_ca_archive_utils.get_archive_value(p_pa_id,
703: 'CAEOY_EMPLOYER_ADDRESS_LINE1'); -- employer address1
704:
705: lv_employer_address2 :=
706: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 706: pay_ca_archive_utils.get_archive_value(p_pa_id,

702: pay_ca_archive_utils.get_archive_value(p_pa_id,
703: 'CAEOY_EMPLOYER_ADDRESS_LINE1'); -- employer address1
704:
705: lv_employer_address2 :=
706: pay_ca_archive_utils.get_archive_value(p_pa_id,
707: 'CAEOY_EMPLOYER_ADDRESS_LINE2'); -- employer address2
708:
709: lv_employer_address3 :=
710: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 710: pay_ca_archive_utils.get_archive_value(p_pa_id,

706: pay_ca_archive_utils.get_archive_value(p_pa_id,
707: 'CAEOY_EMPLOYER_ADDRESS_LINE2'); -- employer address2
708:
709: lv_employer_address3 :=
710: pay_ca_archive_utils.get_archive_value(p_pa_id,
711: 'CAEOY_EMPLOYER_ADDRESS_LINE3'); -- employer address3
712:
713: lv_employer_city :=
714: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 714: pay_ca_archive_utils.get_archive_value(p_pa_id,

710: pay_ca_archive_utils.get_archive_value(p_pa_id,
711: 'CAEOY_EMPLOYER_ADDRESS_LINE3'); -- employer address3
712:
713: lv_employer_city :=
714: pay_ca_archive_utils.get_archive_value(p_pa_id,
715: 'CAEOY_EMPLOYER_CITY'); -- employer_city
716:
717: lv_employer_province :=
718: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 718: pay_ca_archive_utils.get_archive_value(p_pa_id,

714: pay_ca_archive_utils.get_archive_value(p_pa_id,
715: 'CAEOY_EMPLOYER_CITY'); -- employer_city
716:
717: lv_employer_province :=
718: pay_ca_archive_utils.get_archive_value(p_pa_id,
719: 'CAEOY_EMPLOYER_PROVINCE'); -- employer_province
720:
721: lv_employer_country :=
722: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 722: pay_ca_archive_utils.get_archive_value(p_pa_id,

718: pay_ca_archive_utils.get_archive_value(p_pa_id,
719: 'CAEOY_EMPLOYER_PROVINCE'); -- employer_province
720:
721: lv_employer_country :=
722: pay_ca_archive_utils.get_archive_value(p_pa_id,
723: 'CAEOY_EMPLOYER_COUNTRY'); -- employer_country
724:
725: lv_employer_postal_code :=
726: pay_ca_archive_utils.get_archive_value(p_pa_id,

Line 726: pay_ca_archive_utils.get_archive_value(p_pa_id,

722: pay_ca_archive_utils.get_archive_value(p_pa_id,
723: 'CAEOY_EMPLOYER_COUNTRY'); -- employer_country
724:
725: lv_employer_postal_code :=
726: pay_ca_archive_utils.get_archive_value(p_pa_id,
727: 'CAEOY_EMPLOYER_POSTAL_CODE'); -- employer_postal_code
728:
729:
730: if ((lv_employer_address2 is null) and

Line 756: pay_ca_archive_utils.get_archive_value(p_pa_id,

752:
753: if p_type = 'T4ERPAPER' then
754:
755: lv_employer_business_no :=
756: pay_ca_archive_utils.get_archive_value(p_pa_id,
757: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER'); -- business number
758: end if;
759:
760: lv_sin :=

Line 761: pay_ca_archive_utils.get_archive_value(p_aa_id,

757: 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER'); -- business number
758: end if;
759:
760: lv_sin :=
761: pay_ca_archive_utils.get_archive_value(p_aa_id,
762: 'CAEOY_EMPLOYEE_SIN'); -- sin
763:
764: -- changes started for bug 6434602
765: if lv_sin is null then

Line 773: substr(pay_ca_archive_utils.get_archive_value(p_aa_id,

769: lv_sin := ltrim(rtrim(replace(lv_sin, ' ')));
770: lv_sin := substr(lv_sin,1,3)||' '||substr(lv_sin,4,3)||' '||substr(lv_sin,7,3);
771:
772: lv_employee_name :=
773: substr(pay_ca_archive_utils.get_archive_value(p_aa_id,
774: 'CAEOY_EMPLOYEE_FIRST_NAME'),1,15); -- employee_name
775:
776: lv_employee_initial :=
777: pay_ca_archive_utils.get_archive_value(p_aa_id,

Line 777: pay_ca_archive_utils.get_archive_value(p_aa_id,

773: substr(pay_ca_archive_utils.get_archive_value(p_aa_id,
774: 'CAEOY_EMPLOYEE_FIRST_NAME'),1,15); -- employee_name
775:
776: lv_employee_initial :=
777: pay_ca_archive_utils.get_archive_value(p_aa_id,
778: 'CAEOY_EMPLOYEE_INITIAL'); -- employee_initial
779:
780: if lv_employee_initial is not null then
781: lv_employee_initial := upper(substr(lv_employee_initial,1,1));

Line 785: substr(upper(pay_ca_archive_utils.get_archive_value(p_aa_id,

781: lv_employee_initial := upper(substr(lv_employee_initial,1,1));
782: end if;
783:
784: lv_employee_last_name :=
785: substr(upper(pay_ca_archive_utils.get_archive_value(p_aa_id,
786: 'CAEOY_EMPLOYEE_LAST_NAME')),1,30); -- employee_last_name
787:
788:
789: lv_person_id := fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,

Line 789: lv_person_id := fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,

785: substr(upper(pay_ca_archive_utils.get_archive_value(p_aa_id,
786: 'CAEOY_EMPLOYEE_LAST_NAME')),1,30); -- employee_last_name
787:
788:
789: lv_person_id := fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,
790: 'CAEOY_PERSON_ID'));
791:
792: address := pay_ca_rl1_reg.get_primary_address(lv_person_id, sysdate());
793:

Line 818: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

814: end if;
815:
816:
817: lv_cpp_qpp_exempt :=
818: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
819: 'JURISDICTION_CODE',
820: 'CAEOY_CPP_QPP_EXEMPT'); -- cpp_qpp_exempt
821:
822: lv_ei_exempt :=

Line 823: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

819: 'JURISDICTION_CODE',
820: 'CAEOY_CPP_QPP_EXEMPT'); -- cpp_qpp_exempt
821:
822: lv_ei_exempt :=
823: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
824: 'JURISDICTION_CODE',
825: 'CAEOY_EI_EXEMPT'); -- ei_exempt
826:
827:

Line 829: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

825: 'CAEOY_EI_EXEMPT'); -- ei_exempt
826:
827:
828: lv_employment_code :=
829: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
830: 'JURISDICTION_CODE',
831: 'CAEOY_EMPLOYMENT_CODE'); -- employment_code
832:
833: /* lv_rpp_dpsp_reg_no :=

Line 834: pay_ca_archive_utils.get_archive_value(p_aa_id,

830: 'JURISDICTION_CODE',
831: 'CAEOY_EMPLOYMENT_CODE'); -- employment_code
832:
833: /* lv_rpp_dpsp_reg_no :=
834: pay_ca_archive_utils.get_archive_value(p_aa_id,
835: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO'); -- rpp_dpsp_reg_no
836: */
837:
838: -- JURISDICTION_CODE context added for bug 7611439

Line 841: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

837:
838: -- JURISDICTION_CODE context added for bug 7611439
839:
840: lv_rpp_dpsp_reg_no :=
841: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
842: 'JURISDICTION_CODE',
843: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO'); -- rpp_dpsp_reg_no
844:
845: lv_employment_income :=

Line 846: pay_ca_archive_utils.get_archive_value(p_aa_id,p_prov,

842: 'JURISDICTION_CODE',
843: 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO'); -- rpp_dpsp_reg_no
844:
845: lv_employment_income :=
846: pay_ca_archive_utils.get_archive_value(p_aa_id,p_prov,
847: 'JURISDICTION_CODE',
848: 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD'); -- employment_income
849:
850: if fnd_number.canonical_to_number(lv_employment_income) = 0 then

Line 855: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

851: lv_employment_income := null;
852: end if;
853:
854: lv_income_tax_deducted :=
855: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
856: 'JURISDICTION_CODE',
857: 'CAEOY_FED_WITHHELD_PER_JD_GRE_YTD'); -- income_tax_deducted
858:
859: if fnd_number.canonical_to_number(lv_income_tax_deducted) = 0 then

Line 864: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

860: lv_income_tax_deducted := null;
861: end if;
862:
863: lv_employees_cpp :=
864: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
865: 'JURISDICTION_CODE',
866: 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_cpp
867:
868: if fnd_number.canonical_to_number(lv_employees_cpp) = 0 then

Line 873: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

869: lv_employees_cpp := null;
870: end if;
871:
872: lv_employees_qpp :=
873: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
874: 'JURISDICTION_CODE',
875: 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_qpp
876:
877: if fnd_number.canonical_to_number(lv_employees_qpp) = 0 then

Line 882: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

878: lv_employees_qpp := null;
879: end if;
880:
881: lv_employees_ei :=
882: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
883: 'JURISDICTION_CODE',
884: 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_ei
885:
886: if fnd_number.canonical_to_number(lv_employees_ei) = 0 then

Line 894: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

890: /* Added by ssmukher for including PPIP taxes */
891: if p_prov = 'QC' then
892:
893: lv_ppip_exempt :=
894: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
895: 'JURISDICTION_CODE',
896: 'CAEOY_PPIP_EXEMPT'); -- ppip_exempt
897:
898: lv_employees_ppip :=

Line 899: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

895: 'JURISDICTION_CODE',
896: 'CAEOY_PPIP_EXEMPT'); -- ppip_exempt
897:
898: lv_employees_ppip :=
899: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
900: 'JURISDICTION_CODE',
901: 'CAEOY_PPIP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_ppip
902:
903: if fnd_number.canonical_to_number(lv_employees_ppip) = 0 then

Line 913: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

909: into lv_max_ppip_earning;
910: close cur_max_ppip_earning;
911:
912: lv_ppip_insurable_earnings :=
913: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
914: 'JURISDICTION_CODE',
915: 'CAEOY_PPIP_EE_TAXABLE_PER_JD_GRE_YTD'); -- ppip_insurable_earnings
916:
917: -- commented by sneelapa for bug 6434613

Line 961: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

957: lv_ppip_insurable_earnings := null;
958: end if;
959:
960: lv_rpp_contribution :=
961: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
962: 'JURISDICTION_CODE',
963: 'CAEOY_T4_BOX20_PER_JD_GRE_YTD'); -- rpp_contribution
964:
965: if fnd_number.canonical_to_number(lv_rpp_contribution) = 0 then

Line 970: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

966: lv_rpp_contribution := null;
967: end if;
968:
969: lv_pension_adjustment :=
970: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
971: 'JURISDICTION_CODE',
972: 'CAEOY_T4_BOX52_PER_JD_GRE_YTD'); -- pension_adjustment
973:
974: if fnd_number.canonical_to_number(lv_pension_adjustment) = 0 then

Line 979: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

975: lv_pension_adjustment := null;
976: end if;
977:
978: lv_ei_insurable_earnings :=
979: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
980: 'JURISDICTION_CODE',
981: 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD'); -- ei_insurable_earnings
982:
983: open cur_max_ei_earning;

Line 1020: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

1016:
1017: if p_prov = 'QC' then
1018:
1019: lv_cpp_qpp_earnings :=
1020: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
1021: 'JURISDICTION_CODE',
1022: 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD');
1023: else
1024: lv_cpp_qpp_earnings :=

Line 1025: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

1021: 'JURISDICTION_CODE',
1022: 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD');
1023: else
1024: lv_cpp_qpp_earnings :=
1025: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
1026: 'JURISDICTION_CODE',
1027: 'CAEOY_CPP_EE_TAXABLE_PER_JD_GRE_YTD');
1028: end if;
1029:

Line 1049: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

1045:
1046: end if;
1047: end if; --to_number(lv_year) < 2011
1048: lv_union_dues :=
1049: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
1050: 'JURISDICTION_CODE',
1051: 'CAEOY_T4_BOX44_PER_JD_GRE_YTD'); -- union_dues
1052:
1053: if fnd_number.canonical_to_number(lv_union_dues) = 0 then

Line 1058: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,

1054: lv_union_dues := null;
1055: end if;
1056:
1057: lv_charitable_donations :=
1058: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
1059: 'JURISDICTION_CODE',
1060: 'CAEOY_T4_BOX46_PER_JD_GRE_YTD'); -- charitable_donations
1061:
1062: if fnd_number.canonical_to_number(lv_charitable_donations) = 0 then