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.HRDPP_CREATE_CN_SECONDARY_EMP_ dependencies on HR_PUMP_GET

Line 529: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval132)) p3,

525: select l.rowid myrowid,
526: decode(l.pval001,cn,dn,d(l.pval001)) p1,
527: decode(l.pval002,cn,vn,l.pval002) p2,
528: decode(l.pval003,cn,vn,vn,vn,
529: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval132)) p3,
530: l.pval003 d3,
531: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
532: l.pval004 d4,
533: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,

Line 536: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval132)) p6,

532: l.pval004 d4,
533: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
534: l.pval005 d5,
535: decode(l.pval006,cn,vn,vn,vn,
536: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval132)) p6,
537: l.pval006 d6,
538: decode(l.pval007,cn,vn,vn,vn,
539: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval132)) p7,
540: l.pval007 d7,

Line 539: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval132)) p7,

535: decode(l.pval006,cn,vn,vn,vn,
536: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval132)) p6,
537: l.pval006 d6,
538: decode(l.pval007,cn,vn,vn,vn,
539: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval132)) p7,
540: l.pval007 d7,
541: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
542: l.pval008 d8,
543: decode(l.pval009,cn,vn,vn,vn,

Line 544: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval132)) p9,

540: l.pval007 d7,
541: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
542: l.pval008 d8,
543: decode(l.pval009,cn,vn,vn,vn,
544: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval132)) p9,
545: l.pval009 d9,
546: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
547: l.pval010 d10,
548: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,

Line 551: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval132)) p12,

547: l.pval010 d10,
548: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
549: l.pval011 d11,
550: decode(l.pval012,cn,vn,vn,vn,
551: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval132)) p12,
552: l.pval012 d12,
553: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
554: l.pval013 d13,
555: decode(l.pval014,cn,vn,vn,vn,

Line 556: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval132)) p14,

552: l.pval012 d12,
553: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
554: l.pval013 d13,
555: decode(l.pval014,cn,vn,vn,vn,
556: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval132)) p14,
557: l.pval014 d14,
558: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
559: l.pval015 d15,
560: decode(l.pval016,cn,vn,vn,vn,

Line 561: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval132)) p16,

557: l.pval014 d14,
558: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
559: l.pval015 d15,
560: decode(l.pval016,cn,vn,vn,vn,
561: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval132)) p16,
562: l.pval016 d16,
563: decode(l.pval017,cn,vn,vn,vn,
564: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval132)) p17,
565: l.pval017 d17,

Line 564: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval132)) p17,

560: decode(l.pval016,cn,vn,vn,vn,
561: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval132)) p16,
562: l.pval016 d16,
563: decode(l.pval017,cn,vn,vn,vn,
564: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval132)) p17,
565: l.pval017 d17,
566: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
567: l.pval018 d18,
568: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,

Line 571: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval132)) p20,

567: l.pval018 d18,
568: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
569: l.pval019 d19,
570: decode(l.pval020,cn,vn,vn,vn,
571: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval132)) p20,
572: l.pval020 d20,
573: decode(l.pval021,cn,vn,vn,'N',
574: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval132)) p21,
575: l.pval021 d21,

Line 574: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval132)) p21,

570: decode(l.pval020,cn,vn,vn,vn,
571: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval132)) p20,
572: l.pval020 d20,
573: decode(l.pval021,cn,vn,vn,'N',
574: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval132)) p21,
575: l.pval021 d21,
576: decode(l.pval022,cn,vn,vn,vn,
577: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval132)) p22,
578: l.pval022 d22,

Line 577: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval132)) p22,

573: decode(l.pval021,cn,vn,vn,'N',
574: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval132)) p21,
575: l.pval021 d21,
576: decode(l.pval022,cn,vn,vn,vn,
577: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval132)) p22,
578: l.pval022 d22,
579: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
580: l.pval023 d23,
581: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,

Line 644: hr_pump_get.gl(l.pval055,'CN_TAX_AREA',d(l.pval001),l.pval132)) p55,

640: l.pval053 d53,
641: decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
642: l.pval054 d54,
643: decode(l.pval055,cn,vn,
644: hr_pump_get.gl(l.pval055,'CN_TAX_AREA',d(l.pval001),l.pval132)) p55,
645: decode(l.pval056,cn,vn,
646: hr_pump_get.gl(l.pval056,'CN_SIC_AREA',d(l.pval001),l.pval132)) p56,
647: decode(l.pval057,cn,vn,vn,vn,
648: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval132)) p57,

Line 646: hr_pump_get.gl(l.pval056,'CN_SIC_AREA',d(l.pval001),l.pval132)) p56,

642: l.pval054 d54,
643: decode(l.pval055,cn,vn,
644: hr_pump_get.gl(l.pval055,'CN_TAX_AREA',d(l.pval001),l.pval132)) p55,
645: decode(l.pval056,cn,vn,
646: hr_pump_get.gl(l.pval056,'CN_SIC_AREA',d(l.pval001),l.pval132)) p56,
647: decode(l.pval057,cn,vn,vn,vn,
648: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval132)) p57,
649: l.pval057 d57,
650: decode(l.pval058,cn,vn,vn,vn,

Line 648: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval132)) p57,

644: hr_pump_get.gl(l.pval055,'CN_TAX_AREA',d(l.pval001),l.pval132)) p55,
645: decode(l.pval056,cn,vn,
646: hr_pump_get.gl(l.pval056,'CN_SIC_AREA',d(l.pval001),l.pval132)) p56,
647: decode(l.pval057,cn,vn,vn,vn,
648: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval132)) p57,
649: l.pval057 d57,
650: decode(l.pval058,cn,vn,vn,vn,
651: hr_pump_get.gl(l.pval058,'CN_SPL_TAX_EXMP_CATEGORY',d(l.pval001),l.pval132)) p58,
652: l.pval058 d58,

Line 651: hr_pump_get.gl(l.pval058,'CN_SPL_TAX_EXMP_CATEGORY',d(l.pval001),l.pval132)) p58,

647: decode(l.pval057,cn,vn,vn,vn,
648: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval132)) p57,
649: l.pval057 d57,
650: decode(l.pval058,cn,vn,vn,vn,
651: hr_pump_get.gl(l.pval058,'CN_SPL_TAX_EXMP_CATEGORY',d(l.pval001),l.pval132)) p58,
652: l.pval058 d58,
653: decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
654: l.pval059 d59,
655: decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,

Line 858: hr_pump_get.get_person_id

854: if c.p130 is null then
855: L_PERSON_ID:=nn;
856: else
857: L_PERSON_ID :=
858: hr_pump_get.get_person_id
859: (P_PERSON_USER_KEY => c.p130);
860: end if;
861: --
862: if c.p131 is null or

Line 868: hr_pump_get.get_organization_id

864: c.p132 is null then
865: L_ORGANIZATION_ID:=nn;
866: else
867: L_ORGANIZATION_ID :=
868: hr_pump_get.get_organization_id
869: (P_ORGANIZATION_NAME => c.p131
870: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
871: ,P_EFFECTIVE_DATE => c.p1
872: ,P_LANGUAGE_CODE => c.p132);

Line 880: hr_pump_get.get_grade_id

876: c.p1 is null then
877: L_GRADE_ID:=nn;
878: else
879: L_GRADE_ID :=
880: hr_pump_get.get_grade_id
881: (P_GRADE_NAME => c.p133
882: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
883: ,P_EFFECTIVE_DATE => c.p1);
884: end if;

Line 891: hr_pump_get.get_position_id

887: c.p1 is null then
888: L_POSITION_ID:=nn;
889: else
890: L_POSITION_ID :=
891: hr_pump_get.get_position_id
892: (P_POSITION_NAME => c.p134
893: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
894: ,P_EFFECTIVE_DATE => c.p1);
895: end if;

Line 902: hr_pump_get.get_job_id

898: c.p1 is null then
899: L_JOB_ID:=nn;
900: else
901: L_JOB_ID :=
902: hr_pump_get.get_job_id
903: (P_JOB_NAME => c.p135
904: ,P_EFFECTIVE_DATE => c.p1
905: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
906: end if;

Line 913: hr_pump_get.get_assignment_status_type_id

909: c.p132 is null then
910: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
911: else
912: L_ASSIGNMENT_STATUS_TYPE_ID :=
913: hr_pump_get.get_assignment_status_type_id
914: (P_USER_STATUS => c.p136
915: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
916: ,P_LANGUAGE_CODE => c.p132);
917: end if;

Line 924: hr_pump_get.get_payroll_id

920: c.p1 is null then
921: L_PAYROLL_ID:=nn;
922: else
923: L_PAYROLL_ID :=
924: hr_pump_get.get_payroll_id
925: (P_PAYROLL_NAME => c.p137
926: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
927: ,P_EFFECTIVE_DATE => c.p1);
928: end if;

Line 935: hr_pump_get.get_location_id

931: c.p132 is null then
932: L_LOCATION_ID:=nn;
933: else
934: L_LOCATION_ID :=
935: hr_pump_get.get_location_id
936: (P_LOCATION_CODE => c.p138
937: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
938: ,P_LANGUAGE_CODE => c.p132);
939: end if;

Line 945: hr_pump_get.get_supervisor_id

941: if c.p139 is null then
942: L_SUPERVISOR_ID:=nn;
943: else
944: L_SUPERVISOR_ID :=
945: hr_pump_get.get_supervisor_id
946: (P_SUPERVISOR_USER_KEY => c.p139);
947: end if;
948: --
949: if c.p140 is null then

Line 953: hr_pump_get.get_special_ceiling_step_id

949: if c.p140 is null then
950: L_SPECIAL_CEILING_STEP_ID:=nn;
951: else
952: L_SPECIAL_CEILING_STEP_ID :=
953: hr_pump_get.get_special_ceiling_step_id
954: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p140);
955: end if;
956: --
957: if c.p141 is null then

Line 961: hr_pump_get.get_pay_basis_id

957: if c.p141 is null then
958: L_PAY_BASIS_ID:=nn;
959: else
960: L_PAY_BASIS_ID :=
961: hr_pump_get.get_pay_basis_id
962: (P_PAY_BASIS_NAME => c.p141
963: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
964: end if;
965: --

Line 970: hr_pump_get.get_default_code_comb_id

966: if c.p142 is null then
967: L_DEFAULT_CODE_COMB_ID:=nn;
968: else
969: L_DEFAULT_CODE_COMB_ID :=
970: hr_pump_get.get_default_code_comb_id
971: (P_DEFAULT_CODE_COMB_USER_KEY => c.p142);
972: end if;
973: --
974: if c.p143 is null then

Line 978: hr_pump_get.get_set_of_books_id

974: if c.p143 is null then
975: L_SET_OF_BOOKS_ID:=nn;
976: else
977: L_SET_OF_BOOKS_ID :=
978: hr_pump_get.get_set_of_books_id
979: (P_SET_OF_BOOKS_NAME => c.p143);
980: end if;
981: --
982: if c.p144 is null then

Line 995: hr_pump_get.get_contract_id

991: if c.p145 is null then
992: L_CONTRACT_ID:=nn;
993: else
994: L_CONTRACT_ID :=
995: hr_pump_get.get_contract_id
996: (P_CONTRACT_USER_KEY => c.p145);
997: end if;
998: --
999: if c.p146 is null or

Line 1005: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

1001: c.p132 is null then
1002: L_ESTABLISHMENT_ID:=nn;
1003: else
1004: L_ESTABLISHMENT_ID :=
1005: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
1006: (P_ESTABLISHMENT_ORG_NAME => c.p146
1007: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1008: ,P_EFFECTIVE_DATE => c.p1
1009: ,P_LANGUAGE_CODE => c.p132);

Line 1017: hr_pump_get.get_collective_agreement_id

1013: c.p1 is null then
1014: L_COLLECTIVE_AGREEMENT_ID:=nn;
1015: else
1016: L_COLLECTIVE_AGREEMENT_ID :=
1017: hr_pump_get.get_collective_agreement_id
1018: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1019: ,P_CAGR_NAME => c.p147
1020: ,P_EFFECTIVE_DATE => c.p1);
1021: end if;

Line 1027: hr_pump_get.GET_CAGR_ID_FLEX_NUM

1023: if c.p148 is null then
1024: L_CAGR_ID_FLEX_NUM:=nn;
1025: else
1026: L_CAGR_ID_FLEX_NUM :=
1027: hr_pump_get.GET_CAGR_ID_FLEX_NUM
1028: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p148);
1029: end if;
1030: --
1031: hr_data_pump.api_trc_on;