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

Line 239: lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(p_assignment_action_id ,

235: from pay_assignment_actions paa
236: where paa.assignment_action_id = p_assignment_action_id;
237:
238: lv_negative_bal_flag := 'N';
239: lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(p_assignment_action_id ,
240: 'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');
241: hr_utility.trace('lv_negative_bal_flag '||lv_negative_bal_flag);
242:
243: if (lv_negative_bal_flag is NULL or lv_negative_bal_flag = 'N') then

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

571: /* To get person language */
572: cursor c_get_language(p_effective_date DATE) is
573: select decode(correspondence_language,NULL,'US',correspondence_language)
574: from per_all_people_f
575: where person_id = to_number(pay_ca_archive_utils.get_archive_value(
576: l_aa_id, 'CAEOY_PERSON_ID'))
577: and p_effective_date between effective_start_date and effective_end_date;
578:
579: /* Bug 12943928 - Following is the cursor to fetch GRE Name of the Employer.

Line 612: pay_ca_archive_utils.get_archive_value(l_pa_id,

608:
609: if p_print = 'Y' then
610:
611: lv_employer_address1 :=
612: pay_ca_archive_utils.get_archive_value(l_pa_id,
613: 'CAEOY_EMPLOYER_ADDRESS_LINE1'); -- employer address1
614:
615: lv_employer_address2 :=
616: pay_ca_archive_utils.get_archive_value(l_pa_id,

Line 616: pay_ca_archive_utils.get_archive_value(l_pa_id,

612: pay_ca_archive_utils.get_archive_value(l_pa_id,
613: 'CAEOY_EMPLOYER_ADDRESS_LINE1'); -- employer address1
614:
615: lv_employer_address2 :=
616: pay_ca_archive_utils.get_archive_value(l_pa_id,
617: 'CAEOY_EMPLOYER_ADDRESS_LINE2'); -- employer address2
618:
619: lv_employer_address3 :=
620: pay_ca_archive_utils.get_archive_value(l_pa_id,

Line 620: pay_ca_archive_utils.get_archive_value(l_pa_id,

616: pay_ca_archive_utils.get_archive_value(l_pa_id,
617: 'CAEOY_EMPLOYER_ADDRESS_LINE2'); -- employer address2
618:
619: lv_employer_address3 :=
620: pay_ca_archive_utils.get_archive_value(l_pa_id,
621: 'CAEOY_EMPLOYER_ADDRESS_LINE3'); -- employer address3
622:
623: lv_employer_city :=
624: pay_ca_archive_utils.get_archive_value(l_pa_id,

Line 624: pay_ca_archive_utils.get_archive_value(l_pa_id,

620: pay_ca_archive_utils.get_archive_value(l_pa_id,
621: 'CAEOY_EMPLOYER_ADDRESS_LINE3'); -- employer address3
622:
623: lv_employer_city :=
624: pay_ca_archive_utils.get_archive_value(l_pa_id,
625: 'CAEOY_EMPLOYER_CITY'); -- employer_city
626:
627: lv_employer_province :=
628: pay_ca_archive_utils.get_archive_value(l_pa_id,

Line 628: pay_ca_archive_utils.get_archive_value(l_pa_id,

624: pay_ca_archive_utils.get_archive_value(l_pa_id,
625: 'CAEOY_EMPLOYER_CITY'); -- employer_city
626:
627: lv_employer_province :=
628: pay_ca_archive_utils.get_archive_value(l_pa_id,
629: 'CAEOY_EMPLOYER_PROVINCE'); -- employer_province
630:
631: lv_employer_country :=
632: pay_ca_archive_utils.get_archive_value(l_pa_id,

Line 632: pay_ca_archive_utils.get_archive_value(l_pa_id,

628: pay_ca_archive_utils.get_archive_value(l_pa_id,
629: 'CAEOY_EMPLOYER_PROVINCE'); -- employer_province
630:
631: lv_employer_country :=
632: pay_ca_archive_utils.get_archive_value(l_pa_id,
633: 'CAEOY_EMPLOYER_COUNTRY'); -- employer_country
634:
635: lv_employer_postal_code :=
636: pay_ca_archive_utils.get_archive_value(l_pa_id,

Line 636: pay_ca_archive_utils.get_archive_value(l_pa_id,

632: pay_ca_archive_utils.get_archive_value(l_pa_id,
633: 'CAEOY_EMPLOYER_COUNTRY'); -- employer_country
634:
635: lv_employer_postal_code :=
636: pay_ca_archive_utils.get_archive_value(l_pa_id,
637: 'CAEOY_EMPLOYER_POSTAL_CODE'); -- employer_postal_code
638:
639:
640: if ((lv_employer_address2 is null) and

Line 668: l_year := pay_ca_archive_utils.get_archive_value(l_pa_id,

664: close cur_gre_name;
665:
666: end if;
667:
668: l_year := pay_ca_archive_utils.get_archive_value(l_pa_id,
669: 'CAEOY_TAXATION_YEAR');
670:
671: l_person_id := pay_ca_archive_utils.get_archive_value(l_aa_id,'CAEOY_PERSON_ID');
672:

Line 671: l_person_id := pay_ca_archive_utils.get_archive_value(l_aa_id,'CAEOY_PERSON_ID');

667:
668: l_year := pay_ca_archive_utils.get_archive_value(l_pa_id,
669: 'CAEOY_TAXATION_YEAR');
670:
671: l_person_id := pay_ca_archive_utils.get_archive_value(l_aa_id,'CAEOY_PERSON_ID');
672:
673: address := pay_ca_rl1_reg.get_primary_address(l_person_id, sysdate());
674:
675: lv_employee_address1 := substr(address.addr_line_1,1,60);

Line 711: l_last_nm := upper(substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,

707: || lv_employee_province || ' '
708: || lv_employee_country || ' '
709: || lv_employee_postal_code;
710: */
711: l_last_nm := upper(substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
712: 'CAEOY_EMPLOYEE_LAST_NAME'),1,27)); -- # 10174115 Changed from 22 to 27
713: l_first_nm := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
714: 'CAEOY_EMPLOYEE_FIRST_NAME'),1,15);--# 10174115 Changed from 12 to 15
715: l_init := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,

Line 713: l_first_nm := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,

709: || lv_employee_postal_code;
710: */
711: l_last_nm := upper(substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
712: 'CAEOY_EMPLOYEE_LAST_NAME'),1,27)); -- # 10174115 Changed from 22 to 27
713: l_first_nm := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
714: 'CAEOY_EMPLOYEE_FIRST_NAME'),1,15);--# 10174115 Changed from 12 to 15
715: l_init := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
716: 'CAEOY_EMPLOYEE_INITIAL'),1,1);
717:

Line 715: l_init := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,

711: l_last_nm := upper(substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
712: 'CAEOY_EMPLOYEE_LAST_NAME'),1,27)); -- # 10174115 Changed from 22 to 27
713: l_first_nm := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
714: 'CAEOY_EMPLOYEE_FIRST_NAME'),1,15);--# 10174115 Changed from 12 to 15
715: l_init := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
716: 'CAEOY_EMPLOYEE_INITIAL'),1,1);
717:
718: l_box16 := pay_ca_archive_utils.get_archive_value(l_aa_id
719: ,'CAEOY_T4A_BOX16_PER_GRE_YTD');

Line 718: l_box16 := pay_ca_archive_utils.get_archive_value(l_aa_id

714: 'CAEOY_EMPLOYEE_FIRST_NAME'),1,15);--# 10174115 Changed from 12 to 15
715: l_init := substr(pay_ca_archive_utils.get_archive_value(l_aa_id ,
716: 'CAEOY_EMPLOYEE_INITIAL'),1,1);
717:
718: l_box16 := pay_ca_archive_utils.get_archive_value(l_aa_id
719: ,'CAEOY_T4A_BOX16_PER_GRE_YTD');
720: if (fnd_number.canonical_to_number(l_box16) = 0 ) then
721: l_box16 := null;
722: end if;

Line 724: l_box18 := pay_ca_archive_utils.get_archive_value(l_aa_id

720: if (fnd_number.canonical_to_number(l_box16) = 0 ) then
721: l_box16 := null;
722: end if;
723:
724: l_box18 := pay_ca_archive_utils.get_archive_value(l_aa_id
725: ,'CAEOY_T4A_BOX18_PER_GRE_YTD');
726: if (fnd_number.canonical_to_number(l_box18) = 0 ) then
727: l_box18 := null;
728: end if;

Line 730: l_box20 := pay_ca_archive_utils.get_archive_value(l_aa_id

726: if (fnd_number.canonical_to_number(l_box18) = 0 ) then
727: l_box18 := null;
728: end if;
729:
730: l_box20 := pay_ca_archive_utils.get_archive_value(l_aa_id
731: ,'CAEOY_T4A_BOX20_PER_GRE_YTD');
732: if (fnd_number.canonical_to_number(l_box20) = 0 ) then
733: l_box20 := null;
734: end if;

Line 736: l_box22 := pay_ca_archive_utils.get_archive_value(l_aa_id

732: if (fnd_number.canonical_to_number(l_box20) = 0 ) then
733: l_box20 := null;
734: end if;
735:
736: l_box22 := pay_ca_archive_utils.get_archive_value(l_aa_id
737: ,'CAEOY_FED_WITHHELD_PER_GRE_YTD');
738: if (fnd_number.canonical_to_number(l_box22) = 0 ) then
739: l_box22 := null;
740: end if;

Line 742: l_box24 := pay_ca_archive_utils.get_archive_value(l_aa_id

738: if (fnd_number.canonical_to_number(l_box22) = 0 ) then
739: l_box22 := null;
740: end if;
741:
742: l_box24 := pay_ca_archive_utils.get_archive_value(l_aa_id
743: ,'CAEOY_T4A_BOX24_PER_GRE_YTD');
744: if (fnd_number.canonical_to_number(l_box24) = 0 ) then
745: l_box24 := null;
746: end if;

Line 748: l_box26 := pay_ca_archive_utils.get_archive_value(l_aa_id

744: if (fnd_number.canonical_to_number(l_box24) = 0 ) then
745: l_box24 := null;
746: end if;
747:
748: l_box26 := pay_ca_archive_utils.get_archive_value(l_aa_id
749: ,'CAEOY_T4A_BOX26_PER_GRE_YTD');
750: if (fnd_number.canonical_to_number(l_box26) = 0 ) then
751: l_box26 := null;
752: end if;

Line 754: l_box27 := pay_ca_archive_utils.get_archive_value(l_aa_id

750: if (fnd_number.canonical_to_number(l_box26) = 0 ) then
751: l_box26 := null;
752: end if;
753:
754: l_box27 := pay_ca_archive_utils.get_archive_value(l_aa_id
755: ,'CAEOY_T4A_BOX27_PER_GRE_YTD');
756: if (fnd_number.canonical_to_number(l_box27) = 0 ) then
757: l_box27 := null;
758: end if;

Line 760: l_box28 := pay_ca_archive_utils.get_archive_value(l_aa_id

756: if (fnd_number.canonical_to_number(l_box27) = 0 ) then
757: l_box27 := null;
758: end if;
759:
760: l_box28 := pay_ca_archive_utils.get_archive_value(l_aa_id
761: ,'CAEOY_T4A_BOX28_PER_GRE_YTD');
762: if (fnd_number.canonical_to_number(l_box28) = 0 ) then
763: l_box28 := null;
764: end if;

Line 766: l_box30 := pay_ca_archive_utils.get_archive_value(l_aa_id

762: if (fnd_number.canonical_to_number(l_box28) = 0 ) then
763: l_box28 := null;
764: end if;
765:
766: l_box30 := pay_ca_archive_utils.get_archive_value(l_aa_id
767: ,'CAEOY_T4A_BOX30_PER_GRE_YTD');
768: if (fnd_number.canonical_to_number(l_box30) = 0 ) then
769: l_box30 := null;
770: end if;

Line 772: l_box32 := pay_ca_archive_utils.get_archive_value(l_aa_id

768: if (fnd_number.canonical_to_number(l_box30) = 0 ) then
769: l_box30 := null;
770: end if;
771:
772: l_box32 := pay_ca_archive_utils.get_archive_value(l_aa_id
773: ,'CAEOY_T4A_BOX32_PER_GRE_YTD');
774: if (fnd_number.canonical_to_number(l_box32) = 0 ) then
775: l_box32 := null;
776: end if;

Line 778: l_box34 := pay_ca_archive_utils.get_archive_value(l_aa_id

774: if (fnd_number.canonical_to_number(l_box32) = 0 ) then
775: l_box32 := null;
776: end if;
777:
778: l_box34 := pay_ca_archive_utils.get_archive_value(l_aa_id
779: ,'CAEOY_T4A_BOX34_PER_GRE_YTD');
780: if (fnd_number.canonical_to_number(l_box34) = 0 ) then
781: l_box34 := null;
782: end if;

Line 784: l_box36 := pay_ca_archive_utils.get_archive_value(l_aa_id

780: if (fnd_number.canonical_to_number(l_box34) = 0 ) then
781: l_box34 := null;
782: end if;
783:
784: l_box36 := pay_ca_archive_utils.get_archive_value(l_aa_id
785: ,'CAEOY_T4A_EMPLOYEE_REGISTRATION_NO');
786:
787: l_box40 := pay_ca_archive_utils.get_archive_value(l_aa_id
788: ,'CAEOY_T4A_BOX40_PER_GRE_YTD');

Line 787: l_box40 := pay_ca_archive_utils.get_archive_value(l_aa_id

783:
784: l_box36 := pay_ca_archive_utils.get_archive_value(l_aa_id
785: ,'CAEOY_T4A_EMPLOYEE_REGISTRATION_NO');
786:
787: l_box40 := pay_ca_archive_utils.get_archive_value(l_aa_id
788: ,'CAEOY_T4A_BOX40_PER_GRE_YTD');
789: if (fnd_number.canonical_to_number(l_box40) = 0 ) then
790: l_box40 := null;
791: end if;

Line 793: l_box42 := pay_ca_archive_utils.get_archive_value(l_aa_id

789: if (fnd_number.canonical_to_number(l_box40) = 0 ) then
790: l_box40 := null;
791: end if;
792:
793: l_box42 := pay_ca_archive_utils.get_archive_value(l_aa_id
794: ,'CAEOY_T4A_BOX42_PER_GRE_YTD');
795: if (fnd_number.canonical_to_number(l_box42) = 0 ) then
796: l_box42 := null;
797: end if;

Line 799: l_box46 := pay_ca_archive_utils.get_archive_value(l_aa_id

795: if (fnd_number.canonical_to_number(l_box42) = 0 ) then
796: l_box42 := null;
797: end if;
798:
799: l_box46 := pay_ca_archive_utils.get_archive_value(l_aa_id
800: ,'CAEOY_T4A_BOX46_PER_GRE_YTD');
801: if (fnd_number.canonical_to_number(l_box46) = 0 ) then
802: l_box46 := null;
803: end if;

Line 805: l_box48 := pay_ca_archive_utils.get_archive_value(l_aa_id

801: if (fnd_number.canonical_to_number(l_box46) = 0 ) then
802: l_box46 := null;
803: end if;
804:
805: l_box48 := pay_ca_archive_utils.get_archive_value(l_aa_id
806: ,'CAEOY_T4A_BOX48_PER_GRE_YTD');
807: if (fnd_number.canonical_to_number(l_box48) = 0 ) then
808: l_box48 := null;
809: end if;

Line 818: l_box12 := pay_ca_archive_utils.get_archive_value(l_aa_id

814: l_box22_1:=l_box22;
815: l_box24_1:=l_box24;
816: l_box48_1:=l_box48; --end
817:
818: l_box12 := pay_ca_archive_utils.get_archive_value(l_aa_id
819: ,'CAEOY_EMPLOYEE_SIN');
820: if l_box12 is null then
821: l_box12 := '000000000';
822: end if;

Line 827: l_box38 := pay_ca_archive_utils.get_archive_value(l_aa_id

823: l_box12 := substr(l_box12,1,3)||' '||
824: substr(l_box12,4,3)||' '||
825: substr(l_box12,7,3);
826:
827: l_box38 := pay_ca_archive_utils.get_archive_value(l_aa_id
828: ,'CAEOY_T4A_FOOTNOTE_CODE');
829:
830: /* l_box13 := pay_ca_archive_utils.get_archive_value(l_aa_id
831: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER'); */

Line 830: /* l_box13 := pay_ca_archive_utils.get_archive_value(l_aa_id

826:
827: l_box38 := pay_ca_archive_utils.get_archive_value(l_aa_id
828: ,'CAEOY_T4A_FOOTNOTE_CODE');
829:
830: /* l_box13 := pay_ca_archive_utils.get_archive_value(l_aa_id
831: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER'); */
832:
833: l_box14 := pay_ca_archive_utils.get_archive_value(l_aa_id
834: ,'CAEOY_EMPLOYEE_NUMBER');

Line 833: l_box14 := pay_ca_archive_utils.get_archive_value(l_aa_id

829:
830: /* l_box13 := pay_ca_archive_utils.get_archive_value(l_aa_id
831: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER'); */
832:
833: l_box14 := pay_ca_archive_utils.get_archive_value(l_aa_id
834: ,'CAEOY_EMPLOYEE_NUMBER');
835:
836: l_box61 := pay_ca_archive_utils.get_archive_value(l_pa_id
837: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');

Line 836: l_box61 := pay_ca_archive_utils.get_archive_value(l_pa_id

832:
833: l_box14 := pay_ca_archive_utils.get_archive_value(l_aa_id
834: ,'CAEOY_EMPLOYEE_NUMBER');
835:
836: l_box61 := pay_ca_archive_utils.get_archive_value(l_pa_id
837: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
838:
839: /*l_organization_id := pay_ca_archive_utils.get_archive_value(l_pa_id
840: ,'CAEOY_T4_ORGANIZATION_ID'); */

Line 839: /*l_organization_id := pay_ca_archive_utils.get_archive_value(l_pa_id

835:
836: l_box61 := pay_ca_archive_utils.get_archive_value(l_pa_id
837: ,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
838:
839: /*l_organization_id := pay_ca_archive_utils.get_archive_value(l_pa_id
840: ,'CAEOY_T4_ORGANIZATION_ID'); */
841:
842: l_payer_nm := pay_ca_archive_utils.get_archive_value(l_pa_id
843: ,'CAEOY_EMPLOYER_NAME');

Line 842: l_payer_nm := pay_ca_archive_utils.get_archive_value(l_pa_id

838:
839: /*l_organization_id := pay_ca_archive_utils.get_archive_value(l_pa_id
840: ,'CAEOY_T4_ORGANIZATION_ID'); */
841:
842: l_payer_nm := pay_ca_archive_utils.get_archive_value(l_pa_id
843: ,'CAEOY_EMPLOYER_NAME');
844:
845: --lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(l_aa_id ,
846: -- 'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');

Line 845: --lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(l_aa_id ,

841:
842: l_payer_nm := pay_ca_archive_utils.get_archive_value(l_pa_id
843: ,'CAEOY_EMPLOYER_NAME');
844:
845: --lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(l_aa_id ,
846: -- 'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS');
847:
848: l_date := ADD_MONTHS(TRUNC(TO_DATE(l_year,'YYYY'),'Y'), 12)-1;
849: