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

Line 574: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval146)) p6,

570: l.pval004 d4,
571: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
572: l.pval005 d5,
573: decode(l.pval006,cn,vn,vn,vn,
574: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval146)) p6,
575: l.pval006 d6,
576: decode(l.pval007,cn,vn,vn,vn,
577: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval146)) p7,
578: l.pval007 d7,

Line 577: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval146)) p7,

573: decode(l.pval006,cn,vn,vn,vn,
574: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval146)) p6,
575: l.pval006 d6,
576: decode(l.pval007,cn,vn,vn,vn,
577: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval146)) p7,
578: l.pval007 d7,
579: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
580: l.pval008 d8,
581: decode(l.pval009,cn,vn,vn,vn,

Line 582: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval146)) p9,

578: l.pval007 d7,
579: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
580: l.pval008 d8,
581: decode(l.pval009,cn,vn,vn,vn,
582: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval146)) p9,
583: l.pval009 d9,
584: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
585: l.pval010 d10,
586: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,

Line 589: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval146)) p12,

585: l.pval010 d10,
586: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
587: l.pval011 d11,
588: decode(l.pval012,cn,vn,vn,vn,
589: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval146)) p12,
590: l.pval012 d12,
591: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
592: l.pval013 d13,
593: decode(l.pval014,cn,vn,vn,vn,

Line 594: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval146)) p14,

590: l.pval012 d12,
591: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
592: l.pval013 d13,
593: decode(l.pval014,cn,vn,vn,vn,
594: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval146)) p14,
595: l.pval014 d14,
596: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
597: l.pval015 d15,
598: decode(l.pval016,cn,vn,vn,vn,

Line 599: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval146)) p16,

595: l.pval014 d14,
596: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
597: l.pval015 d15,
598: decode(l.pval016,cn,vn,vn,vn,
599: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval146)) p16,
600: l.pval016 d16,
601: decode(l.pval017,cn,vn,vn,vn,
602: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval146)) p17,
603: l.pval017 d17,

Line 602: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval146)) p17,

598: decode(l.pval016,cn,vn,vn,vn,
599: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval146)) p16,
600: l.pval016 d16,
601: decode(l.pval017,cn,vn,vn,vn,
602: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval146)) p17,
603: l.pval017 d17,
604: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
605: l.pval018 d18,
606: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,

Line 609: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval146)) p20,

605: l.pval018 d18,
606: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
607: l.pval019 d19,
608: decode(l.pval020,cn,vn,vn,vn,
609: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval146)) p20,
610: l.pval020 d20,
611: decode(l.pval021,cn,vn,vn,'N',
612: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval146)) p21,
613: l.pval021 d21,

Line 612: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval146)) p21,

608: decode(l.pval020,cn,vn,vn,vn,
609: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval146)) p20,
610: l.pval020 d20,
611: decode(l.pval021,cn,vn,vn,'N',
612: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval146)) p21,
613: l.pval021 d21,
614: decode(l.pval022,cn,vn,vn,vn,
615: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval146)) p22,
616: l.pval022 d22,

Line 615: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval146)) p22,

611: decode(l.pval021,cn,vn,vn,'N',
612: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval146)) p21,
613: l.pval021 d21,
614: decode(l.pval022,cn,vn,vn,vn,
615: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval146)) p22,
616: l.pval022 d22,
617: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
618: l.pval023 d23,
619: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,

Line 682: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval146)) p55,

678: l.pval053 d53,
679: decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
680: l.pval054 d54,
681: decode(l.pval055,cn,vn,vn,vn,
682: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval146)) p55,
683: l.pval055 d55,
684: decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
685: l.pval056 d56,
686: decode(l.pval057,cn,dn,vn,dn,d(l.pval057)) p57,

Line 691: hr_pump_get.gl(l.pval059,'RU_LIMITED_CONTRACT_REASON',d(l.pval001),l.pval146)) p59,

687: l.pval057 d57,
688: decode(l.pval058,cn,dn,vn,dn,d(l.pval058)) p58,
689: l.pval058 d58,
690: decode(l.pval059,cn,vn,vn,vn,
691: hr_pump_get.gl(l.pval059,'RU_LIMITED_CONTRACT_REASON',d(l.pval001),l.pval146)) p59,
692: l.pval059 d59,
693: decode(l.pval060,cn,vn,vn,vn,
694: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval146)) p60,
695: l.pval060 d60,

Line 694: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval146)) p60,

690: decode(l.pval059,cn,vn,vn,vn,
691: hr_pump_get.gl(l.pval059,'RU_LIMITED_CONTRACT_REASON',d(l.pval001),l.pval146)) p59,
692: l.pval059 d59,
693: decode(l.pval060,cn,vn,vn,vn,
694: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval146)) p60,
695: l.pval060 d60,
696: decode(l.pval061,cn,vn,vn,vn,
697: hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval146)) p61,
698: l.pval061 d61,

Line 697: hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval146)) p61,

693: decode(l.pval060,cn,vn,vn,vn,
694: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval146)) p60,
695: l.pval060 d60,
696: decode(l.pval061,cn,vn,vn,vn,
697: hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval146)) p61,
698: l.pval061 d61,
699: decode(l.pval062,cn,vn,vn,vn,
700: hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval146)) p62,
701: l.pval062 d62,

Line 700: hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval146)) p62,

696: decode(l.pval061,cn,vn,vn,vn,
697: hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval146)) p61,
698: l.pval061 d61,
699: decode(l.pval062,cn,vn,vn,vn,
700: hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval146)) p62,
701: l.pval062 d62,
702: decode(l.pval063,cn,vn,vn,vn,
703: hr_pump_get.gl(l.pval063,'RU_CALC_RECORD_SERVICE',d(l.pval001),l.pval146)) p63,
704: l.pval063 d63,

Line 703: hr_pump_get.gl(l.pval063,'RU_CALC_RECORD_SERVICE',d(l.pval001),l.pval146)) p63,

699: decode(l.pval062,cn,vn,vn,vn,
700: hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval146)) p62,
701: l.pval062 d62,
702: decode(l.pval063,cn,vn,vn,vn,
703: hr_pump_get.gl(l.pval063,'RU_CALC_RECORD_SERVICE',d(l.pval001),l.pval146)) p63,
704: l.pval063 d63,
705: decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
706: l.pval064 d64,
707: decode(l.pval065,cn,vn,vn,vn,

Line 708: hr_pump_get.gl(l.pval065,'RU_LONG_SERVICE',d(l.pval001),l.pval146)) p65,

704: l.pval063 d63,
705: decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
706: l.pval064 d64,
707: decode(l.pval065,cn,vn,vn,vn,
708: hr_pump_get.gl(l.pval065,'RU_LONG_SERVICE',d(l.pval001),l.pval146)) p65,
709: l.pval065 d65,
710: decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
711: l.pval066 d66,
712: decode(l.pval067,cn,vn,vn,vn,

Line 713: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval146)) p67,

709: l.pval065 d65,
710: decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
711: l.pval066 d66,
712: decode(l.pval067,cn,vn,vn,vn,
713: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval146)) p67,
714: l.pval067 d67,
715: decode(l.pval068,cn,vn,vn,vn,
716: hr_pump_get.gl(l.pval068,'YES_NO',d(l.pval001),l.pval146)) p68,
717: l.pval068 d68,

Line 716: hr_pump_get.gl(l.pval068,'YES_NO',d(l.pval001),l.pval146)) p68,

712: decode(l.pval067,cn,vn,vn,vn,
713: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval146)) p67,
714: l.pval067 d67,
715: decode(l.pval068,cn,vn,vn,vn,
716: hr_pump_get.gl(l.pval068,'YES_NO',d(l.pval001),l.pval146)) p68,
717: l.pval068 d68,
718: decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
719: l.pval069 d69,
720: decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,

Line 937: hr_pump_get.get_person_id

933: if c.p144 is null then
934: L_PERSON_ID:=nn;
935: else
936: L_PERSON_ID :=
937: hr_pump_get.get_person_id
938: (P_PERSON_USER_KEY => c.p144);
939: end if;
940: --
941: if c.p145 is null or

Line 947: hr_pump_get.get_organization_id

943: c.p146 is null then
944: L_ORGANIZATION_ID:=nn;
945: else
946: L_ORGANIZATION_ID :=
947: hr_pump_get.get_organization_id
948: (P_ORGANIZATION_NAME => c.p145
949: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
950: ,P_EFFECTIVE_DATE => c.p1
951: ,P_LANGUAGE_CODE => c.p146);

Line 959: hr_pump_get.get_grade_id

955: c.p1 is null then
956: L_GRADE_ID:=nn;
957: else
958: L_GRADE_ID :=
959: hr_pump_get.get_grade_id
960: (P_GRADE_NAME => c.p147
961: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
962: ,P_EFFECTIVE_DATE => c.p1);
963: end if;

Line 970: hr_pump_get.get_position_id

966: c.p1 is null then
967: L_POSITION_ID:=nn;
968: else
969: L_POSITION_ID :=
970: hr_pump_get.get_position_id
971: (P_POSITION_NAME => c.p148
972: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
973: ,P_EFFECTIVE_DATE => c.p1);
974: end if;

Line 981: hr_pump_get.get_job_id

977: c.p1 is null then
978: L_JOB_ID:=nn;
979: else
980: L_JOB_ID :=
981: hr_pump_get.get_job_id
982: (P_JOB_NAME => c.p149
983: ,P_EFFECTIVE_DATE => c.p1
984: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
985: end if;

Line 992: hr_pump_get.get_assignment_status_type_id

988: c.p146 is null then
989: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
990: else
991: L_ASSIGNMENT_STATUS_TYPE_ID :=
992: hr_pump_get.get_assignment_status_type_id
993: (P_USER_STATUS => c.p150
994: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
995: ,P_LANGUAGE_CODE => c.p146);
996: end if;

Line 1003: hr_pump_get.get_payroll_id

999: c.p1 is null then
1000: L_PAYROLL_ID:=nn;
1001: else
1002: L_PAYROLL_ID :=
1003: hr_pump_get.get_payroll_id
1004: (P_PAYROLL_NAME => c.p151
1005: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1006: ,P_EFFECTIVE_DATE => c.p1);
1007: end if;

Line 1014: hr_pump_get.get_location_id

1010: c.p146 is null then
1011: L_LOCATION_ID:=nn;
1012: else
1013: L_LOCATION_ID :=
1014: hr_pump_get.get_location_id
1015: (P_LOCATION_CODE => c.p152
1016: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1017: ,P_LANGUAGE_CODE => c.p146);
1018: end if;

Line 1024: hr_pump_get.get_supervisor_id

1020: if c.p153 is null then
1021: L_SUPERVISOR_ID:=nn;
1022: else
1023: L_SUPERVISOR_ID :=
1024: hr_pump_get.get_supervisor_id
1025: (P_SUPERVISOR_USER_KEY => c.p153);
1026: end if;
1027: --
1028: if c.p154 is null then

Line 1032: hr_pump_get.get_special_ceiling_step_id

1028: if c.p154 is null then
1029: L_SPECIAL_CEILING_STEP_ID:=nn;
1030: else
1031: L_SPECIAL_CEILING_STEP_ID :=
1032: hr_pump_get.get_special_ceiling_step_id
1033: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p154);
1034: end if;
1035: --
1036: if c.p155 is null then

Line 1040: hr_pump_get.get_pay_basis_id

1036: if c.p155 is null then
1037: L_PAY_BASIS_ID:=nn;
1038: else
1039: L_PAY_BASIS_ID :=
1040: hr_pump_get.get_pay_basis_id
1041: (P_PAY_BASIS_NAME => c.p155
1042: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1043: end if;
1044: --

Line 1049: hr_pump_get.get_default_code_comb_id

1045: if c.p156 is null then
1046: L_DEFAULT_CODE_COMB_ID:=nn;
1047: else
1048: L_DEFAULT_CODE_COMB_ID :=
1049: hr_pump_get.get_default_code_comb_id
1050: (P_DEFAULT_CODE_COMB_USER_KEY => c.p156);
1051: end if;
1052: --
1053: if c.p157 is null then

Line 1057: hr_pump_get.get_set_of_books_id

1053: if c.p157 is null then
1054: L_SET_OF_BOOKS_ID:=nn;
1055: else
1056: L_SET_OF_BOOKS_ID :=
1057: hr_pump_get.get_set_of_books_id
1058: (P_SET_OF_BOOKS_NAME => c.p157);
1059: end if;
1060: --
1061: if c.p158 is null or

Line 1078: hr_pump_get.get_contract_id

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

Line 1088: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

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

Line 1100: hr_pump_get.get_collective_agreement_id

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

Line 1110: hr_pump_get.GET_CAGR_ID_FLEX_NUM

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

Line 1119: hr_pump_get.get_grade_ladder_pgm_id

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

Line 1129: hr_pump_get.get_supervisor_assignment_id

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