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_IN_SECONDARY_EMP_ dependencies on HR_PUMP_GET

Line 550: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval133)) p3,

546: select l.rowid myrowid,
547: decode(l.pval001,cn,dn,d(l.pval001)) p1,
548: decode(l.pval002,cn,vn,l.pval002) p2,
549: decode(l.pval003,cn,vn,vn,vn,
550: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval133)) p3,
551: l.pval003 d3,
552: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
553: l.pval004 d4,
554: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,

Line 557: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval133)) p6,

553: l.pval004 d4,
554: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
555: l.pval005 d5,
556: decode(l.pval006,cn,vn,vn,vn,
557: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval133)) p6,
558: l.pval006 d6,
559: decode(l.pval007,cn,vn,vn,vn,
560: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval133)) p7,
561: l.pval007 d7,

Line 560: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval133)) p7,

556: decode(l.pval006,cn,vn,vn,vn,
557: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval133)) p6,
558: l.pval006 d6,
559: decode(l.pval007,cn,vn,vn,vn,
560: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval133)) p7,
561: l.pval007 d7,
562: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
563: l.pval008 d8,
564: decode(l.pval009,cn,vn,vn,vn,

Line 565: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval133)) p9,

561: l.pval007 d7,
562: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
563: l.pval008 d8,
564: decode(l.pval009,cn,vn,vn,vn,
565: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval133)) p9,
566: l.pval009 d9,
567: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
568: l.pval010 d10,
569: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,

Line 572: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval133)) p12,

568: l.pval010 d10,
569: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
570: l.pval011 d11,
571: decode(l.pval012,cn,vn,vn,vn,
572: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval133)) p12,
573: l.pval012 d12,
574: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
575: l.pval013 d13,
576: decode(l.pval014,cn,vn,vn,vn,

Line 577: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval133)) p14,

573: l.pval012 d12,
574: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
575: l.pval013 d13,
576: decode(l.pval014,cn,vn,vn,vn,
577: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval133)) p14,
578: l.pval014 d14,
579: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
580: l.pval015 d15,
581: decode(l.pval016,cn,vn,vn,vn,

Line 582: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval133)) p16,

578: l.pval014 d14,
579: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
580: l.pval015 d15,
581: decode(l.pval016,cn,vn,vn,vn,
582: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval133)) p16,
583: l.pval016 d16,
584: decode(l.pval017,cn,vn,vn,vn,
585: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval133)) p17,
586: l.pval017 d17,

Line 585: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval133)) p17,

581: decode(l.pval016,cn,vn,vn,vn,
582: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval133)) p16,
583: l.pval016 d16,
584: decode(l.pval017,cn,vn,vn,vn,
585: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval133)) p17,
586: l.pval017 d17,
587: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
588: l.pval018 d18,
589: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,

Line 592: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval133)) p20,

588: l.pval018 d18,
589: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
590: l.pval019 d19,
591: decode(l.pval020,cn,vn,vn,vn,
592: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval133)) p20,
593: l.pval020 d20,
594: decode(l.pval021,cn,vn,vn,'N',
595: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval133)) p21,
596: l.pval021 d21,

Line 595: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval133)) p21,

591: decode(l.pval020,cn,vn,vn,vn,
592: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval133)) p20,
593: l.pval020 d20,
594: decode(l.pval021,cn,vn,vn,'N',
595: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval133)) p21,
596: l.pval021 d21,
597: decode(l.pval022,cn,vn,vn,vn,
598: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval133)) p22,
599: l.pval022 d22,

Line 598: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval133)) p22,

594: decode(l.pval021,cn,vn,vn,'N',
595: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval133)) p21,
596: l.pval021 d21,
597: decode(l.pval022,cn,vn,vn,vn,
598: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval133)) p22,
599: l.pval022 d22,
600: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
601: l.pval023 d23,
602: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,

Line 665: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval133)) p55,

661: l.pval053 d53,
662: decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
663: l.pval054 d54,
664: decode(l.pval055,cn,vn,vn,'N',
665: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval133)) p55,
666: l.pval055 d55,
667: decode(l.pval056,cn,vn,vn,'N',
668: hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval133)) p56,
669: l.pval056 d56,

Line 668: hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval133)) p56,

664: decode(l.pval055,cn,vn,vn,'N',
665: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval133)) p55,
666: l.pval055 d55,
667: decode(l.pval056,cn,vn,vn,'N',
668: hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval133)) p56,
669: l.pval056 d56,
670: decode(l.pval057,cn,vn,vn,'N',
671: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval133)) p57,
672: l.pval057 d57,

Line 671: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval133)) p57,

667: decode(l.pval056,cn,vn,vn,'N',
668: hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval133)) p56,
669: l.pval056 d56,
670: decode(l.pval057,cn,vn,vn,'N',
671: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval133)) p57,
672: l.pval057 d57,
673: decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
674: l.pval058 d58,
675: decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,

Line 784: hr_pump_get.gl(l.pval113,'EMPLOYEE_CATG',d(l.pval001),l.pval133)) p113,

780: l.pval111 d111,
781: decode(l.pval112,cn,vn,vn,vn,l.pval112) p112,
782: l.pval112 d112,
783: decode(l.pval113,cn,vn,vn,vn,
784: hr_pump_get.gl(l.pval113,'EMPLOYEE_CATG',d(l.pval001),l.pval133)) p113,
785: l.pval113 d113,
786: decode(l.pval114,cn,vn,vn,vn,l.pval114) p114,
787: l.pval114 d114,
788: decode(l.pval115,cn,vn,vn,vn,l.pval115) p115,

Line 903: hr_pump_get.get_person_id

899: if c.p131 is null then
900: L_PERSON_ID:=nn;
901: else
902: L_PERSON_ID :=
903: hr_pump_get.get_person_id
904: (P_PERSON_USER_KEY => c.p131);
905: end if;
906: --
907: if c.p132 is null or

Line 913: hr_pump_get.GET_ORGANIZATION_ID

909: c.p133 is null then
910: L_ORGANIZATION_ID:=nn;
911: else
912: L_ORGANIZATION_ID :=
913: hr_pump_get.GET_ORGANIZATION_ID
914: (P_ORGANIZATION_NAME => c.p132
915: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
916: ,P_EFFECTIVE_DATE => c.p1
917: ,P_LANGUAGE_CODE => c.p133);

Line 925: hr_pump_get.get_grade_id

921: c.p1 is null then
922: L_GRADE_ID:=nn;
923: else
924: L_GRADE_ID :=
925: hr_pump_get.get_grade_id
926: (P_GRADE_NAME => c.p134
927: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
928: ,P_EFFECTIVE_DATE => c.p1);
929: end if;

Line 936: hr_pump_get.get_position_id

932: c.p1 is null then
933: L_POSITION_ID:=nn;
934: else
935: L_POSITION_ID :=
936: hr_pump_get.get_position_id
937: (P_POSITION_NAME => c.p135
938: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
939: ,P_EFFECTIVE_DATE => c.p1);
940: end if;

Line 947: hr_pump_get.get_job_id

943: c.p1 is null then
944: L_JOB_ID:=nn;
945: else
946: L_JOB_ID :=
947: hr_pump_get.get_job_id
948: (P_JOB_NAME => c.p136
949: ,P_EFFECTIVE_DATE => c.p1
950: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
951: end if;

Line 958: hr_pump_get.get_assignment_status_type_id

954: c.p133 is null then
955: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
956: else
957: L_ASSIGNMENT_STATUS_TYPE_ID :=
958: hr_pump_get.get_assignment_status_type_id
959: (P_USER_STATUS => c.p137
960: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
961: ,P_LANGUAGE_CODE => c.p133);
962: end if;

Line 969: hr_pump_get.get_payroll_id

965: c.p1 is null then
966: L_PAYROLL_ID:=nn;
967: else
968: L_PAYROLL_ID :=
969: hr_pump_get.get_payroll_id
970: (P_PAYROLL_NAME => c.p138
971: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
972: ,P_EFFECTIVE_DATE => c.p1);
973: end if;

Line 980: hr_pump_get.get_location_id

976: c.p133 is null then
977: L_LOCATION_ID:=nn;
978: else
979: L_LOCATION_ID :=
980: hr_pump_get.get_location_id
981: (P_LOCATION_CODE => c.p139
982: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
983: ,P_LANGUAGE_CODE => c.p133);
984: end if;

Line 990: hr_pump_get.get_supervisor_id

986: if c.p140 is null then
987: L_SUPERVISOR_ID:=nn;
988: else
989: L_SUPERVISOR_ID :=
990: hr_pump_get.get_supervisor_id
991: (P_SUPERVISOR_USER_KEY => c.p140);
992: end if;
993: --
994: if c.p141 is null then

Line 998: hr_pump_get.get_special_ceiling_step_id

994: if c.p141 is null then
995: L_SPECIAL_CEILING_STEP_ID:=nn;
996: else
997: L_SPECIAL_CEILING_STEP_ID :=
998: hr_pump_get.get_special_ceiling_step_id
999: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p141);
1000: end if;
1001: --
1002: if c.p142 is null then

Line 1006: hr_pump_get.get_pay_basis_id

1002: if c.p142 is null then
1003: L_PAY_BASIS_ID:=nn;
1004: else
1005: L_PAY_BASIS_ID :=
1006: hr_pump_get.get_pay_basis_id
1007: (P_PAY_BASIS_NAME => c.p142
1008: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1009: end if;
1010: --

Line 1015: hr_pump_get.get_default_code_comb_id

1011: if c.p143 is null then
1012: L_DEFAULT_CODE_COMB_ID:=nn;
1013: else
1014: L_DEFAULT_CODE_COMB_ID :=
1015: hr_pump_get.get_default_code_comb_id
1016: (P_DEFAULT_CODE_COMB_USER_KEY => c.p143);
1017: end if;
1018: --
1019: if c.p144 is null then

Line 1023: hr_pump_get.get_set_of_books_id

1019: if c.p144 is null then
1020: L_SET_OF_BOOKS_ID:=nn;
1021: else
1022: L_SET_OF_BOOKS_ID :=
1023: hr_pump_get.get_set_of_books_id
1024: (P_SET_OF_BOOKS_NAME => c.p144);
1025: end if;
1026: --
1027: if c.p145 is null then

Line 1079: hr_pump_get.get_contract_id

1075: if c.p151 is null then
1076: L_CONTRACT_ID:=nn;
1077: else
1078: L_CONTRACT_ID :=
1079: hr_pump_get.get_contract_id
1080: (P_CONTRACT_USER_KEY => c.p151);
1081: end if;
1082: --
1083: if c.p152 is null or

Line 1089: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

1085: c.p133 is null then
1086: L_ESTABLISHMENT_ID:=nn;
1087: else
1088: L_ESTABLISHMENT_ID :=
1089: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
1090: (P_ESTABLISHMENT_ORG_NAME => c.p152
1091: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1092: ,P_EFFECTIVE_DATE => c.p1
1093: ,P_LANGUAGE_CODE => c.p133);

Line 1101: hr_pump_get.get_collective_agreement_id

1097: c.p1 is null then
1098: L_COLLECTIVE_AGREEMENT_ID:=nn;
1099: else
1100: L_COLLECTIVE_AGREEMENT_ID :=
1101: hr_pump_get.get_collective_agreement_id
1102: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1103: ,P_CAGR_NAME => c.p153
1104: ,P_EFFECTIVE_DATE => c.p1);
1105: end if;

Line 1111: hr_pump_get.GET_CAGR_ID_FLEX_NUM

1107: if c.p154 is null then
1108: L_CAGR_ID_FLEX_NUM:=nn;
1109: else
1110: L_CAGR_ID_FLEX_NUM :=
1111: hr_pump_get.GET_CAGR_ID_FLEX_NUM
1112: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p154);
1113: end if;
1114: --
1115: if c.p155 is null or

Line 1120: hr_pump_get.get_grade_ladder_pgm_id

1116: c.p1 is null then
1117: L_GRADE_LADDER_PGM_ID:=nn;
1118: else
1119: L_GRADE_LADDER_PGM_ID :=
1120: hr_pump_get.get_grade_ladder_pgm_id
1121: (P_GRADE_LADDER_NAME => c.p155
1122: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1123: ,P_EFFECTIVE_DATE => c.p1);
1124: end if;

Line 1130: hr_pump_get.get_supervisor_assignment_id

1126: if c.p156 is null then
1127: L_SUPERVISOR_ASSIGNMENT_ID:=nn;
1128: else
1129: L_SUPERVISOR_ASSIGNMENT_ID :=
1130: hr_pump_get.get_supervisor_assignment_id
1131: (P_SVR_ASSIGNMENT_USER_KEY => c.p156);
1132: end if;
1133: --
1134: hr_data_pump.api_trc_on;