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

Line 621: hr_pump_get.gl(l.pval011,'BARGAINING_UNIT_CODE',d(l.pval146),l.pval006)) p11,

617: l.pval009 d9,
618: decode(l.pval010,cn,vn,vn,vh,l.pval010) p10,
619: l.pval010 d10,
620: decode(l.pval011,cn,vn,vn,vh,
621: hr_pump_get.gl(l.pval011,'BARGAINING_UNIT_CODE',d(l.pval146),l.pval006)) p11,
622: l.pval011 d11,
623: l.plongval plongval,
624: decode(l.pval013,cn,dn,vn,dh,d(l.pval013)) p13,
625: l.pval013 d13,

Line 639: hr_pump_get.gl(l.pval020,'FREQUENCY',d(l.pval146),l.pval006)) p20,

635: l.pval018 d18,
636: decode(l.pval019,cn,dn,vn,dh,d(l.pval019)) p19,
637: l.pval019 d19,
638: decode(l.pval020,cn,vn,vn,vh,
639: hr_pump_get.gl(l.pval020,'FREQUENCY',d(l.pval146),l.pval006)) p20,
640: l.pval020 d20,
641: decode(l.pval021,cn,nn,vn,nh,n(l.pval021)) p21,
642: l.pval021 d21,
643: decode(l.pval022,cn,nn,vn,nh,n(l.pval022)) p22,

Line 648: hr_pump_get.gl(l.pval024,'FREQUENCY',d(l.pval146),l.pval006)) p24,

644: l.pval022 d22,
645: decode(l.pval023,cn,nn,vn,nh,n(l.pval023)) p23,
646: l.pval023 d23,
647: decode(l.pval024,cn,vn,vn,vh,
648: hr_pump_get.gl(l.pval024,'FREQUENCY',d(l.pval146),l.pval006)) p24,
649: l.pval024 d24,
650: decode(l.pval025,cn,vn,vn,vh,
651: hr_pump_get.gl(l.pval025,'DAY_CODE',d(l.pval146),l.pval006)) p25,
652: l.pval025 d25,

Line 651: hr_pump_get.gl(l.pval025,'DAY_CODE',d(l.pval146),l.pval006)) p25,

647: decode(l.pval024,cn,vn,vn,vh,
648: hr_pump_get.gl(l.pval024,'FREQUENCY',d(l.pval146),l.pval006)) p24,
649: l.pval024 d24,
650: decode(l.pval025,cn,vn,vn,vh,
651: hr_pump_get.gl(l.pval025,'DAY_CODE',d(l.pval146),l.pval006)) p25,
652: l.pval025 d25,
653: decode(l.pval026,cn,vn,vn,vh,
654: hr_pump_get.gl(l.pval026,'MONTH_CODE',d(l.pval146),l.pval006)) p26,
655: l.pval026 d26,

Line 654: hr_pump_get.gl(l.pval026,'MONTH_CODE',d(l.pval146),l.pval006)) p26,

650: decode(l.pval025,cn,vn,vn,vh,
651: hr_pump_get.gl(l.pval025,'DAY_CODE',d(l.pval146),l.pval006)) p25,
652: l.pval025 d25,
653: decode(l.pval026,cn,vn,vn,vh,
654: hr_pump_get.gl(l.pval026,'MONTH_CODE',d(l.pval146),l.pval006)) p26,
655: l.pval026 d26,
656: decode(l.pval027,cn,vn,vn,vh,
657: hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval146),l.pval006)) p27,
658: l.pval027 d27,

Line 657: hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval146),l.pval006)) p27,

653: decode(l.pval026,cn,vn,vn,vh,
654: hr_pump_get.gl(l.pval026,'MONTH_CODE',d(l.pval146),l.pval006)) p26,
655: l.pval026 d26,
656: decode(l.pval027,cn,vn,vn,vh,
657: hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval146),l.pval006)) p27,
658: l.pval027 d27,
659: decode(l.pval028,cn,vn,vn,vh,
660: hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval146),l.pval006)) p28,
661: l.pval028 d28,

Line 660: hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval146),l.pval006)) p28,

656: decode(l.pval027,cn,vn,vn,vh,
657: hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval146),l.pval006)) p27,
658: l.pval027 d27,
659: decode(l.pval028,cn,vn,vn,vh,
660: hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval146),l.pval006)) p28,
661: l.pval028 d28,
662: decode(l.pval029,cn,vn,vn,vh,
663: hr_pump_get.gl(l.pval029,'POSITION_TYPE',d(l.pval146),l.pval006)) p29,
664: l.pval029 d29,

Line 663: hr_pump_get.gl(l.pval029,'POSITION_TYPE',d(l.pval146),l.pval006)) p29,

659: decode(l.pval028,cn,vn,vn,vh,
660: hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval146),l.pval006)) p28,
661: l.pval028 d28,
662: decode(l.pval029,cn,vn,vn,vh,
663: hr_pump_get.gl(l.pval029,'POSITION_TYPE',d(l.pval146),l.pval006)) p29,
664: l.pval029 d29,
665: decode(l.pval030,cn,vn,vn,vh,l.pval030) p30,
666: l.pval030 d30,
667: decode(l.pval031,cn,nn,vn,nh,n(l.pval031)) p31,

Line 670: hr_pump_get.gl(l.pval032,'QUALIFYING_UNITS',d(l.pval146),l.pval006)) p32,

666: l.pval030 d30,
667: decode(l.pval031,cn,nn,vn,nh,n(l.pval031)) p31,
668: l.pval031 d31,
669: decode(l.pval032,cn,vn,vn,vh,
670: hr_pump_get.gl(l.pval032,'QUALIFYING_UNITS',d(l.pval146),l.pval006)) p32,
671: l.pval032 d32,
672: decode(l.pval033,cn,vn,vn,vh,
673: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval146),l.pval006)) p33,
674: l.pval033 d33,

Line 673: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval146),l.pval006)) p33,

669: decode(l.pval032,cn,vn,vn,vh,
670: hr_pump_get.gl(l.pval032,'QUALIFYING_UNITS',d(l.pval146),l.pval006)) p32,
671: l.pval032 d32,
672: decode(l.pval033,cn,vn,vn,vh,
673: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval146),l.pval006)) p33,
674: l.pval033 d33,
675: decode(l.pval034,cn,vn,vn,vh,
676: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval146),l.pval006)) p34,
677: l.pval034 d34,

Line 676: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval146),l.pval006)) p34,

672: decode(l.pval033,cn,vn,vn,vh,
673: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval146),l.pval006)) p33,
674: l.pval033 d33,
675: decode(l.pval034,cn,vn,vn,vh,
676: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval146),l.pval006)) p34,
677: l.pval034 d34,
678: decode(l.pval035,cn,vn,vn,vh,
679: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval146),l.pval006)) p35,
680: l.pval035 d35,

Line 679: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval146),l.pval006)) p35,

675: decode(l.pval034,cn,vn,vn,vh,
676: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval146),l.pval006)) p34,
677: l.pval034 d34,
678: decode(l.pval035,cn,vn,vn,vh,
679: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval146),l.pval006)) p35,
680: l.pval035 d35,
681: decode(l.pval036,cn,vn,vn,vh,l.pval036) p36,
682: l.pval036 d36,
683: decode(l.pval037,cn,vn,vn,vh,

Line 684: hr_pump_get.gl(l.pval037,'POSITION_STATUS',d(l.pval146),l.pval006)) p37,

680: l.pval035 d35,
681: decode(l.pval036,cn,vn,vn,vh,l.pval036) p36,
682: l.pval036 d36,
683: decode(l.pval037,cn,vn,vn,vh,
684: hr_pump_get.gl(l.pval037,'POSITION_STATUS',d(l.pval146),l.pval006)) p37,
685: l.pval037 d37,
686: decode(l.pval038,cn,vn,vn,vh,
687: hr_pump_get.gl(l.pval038,'DAY_CODE',d(l.pval146),l.pval006)) p38,
688: l.pval038 d38,

Line 687: hr_pump_get.gl(l.pval038,'DAY_CODE',d(l.pval146),l.pval006)) p38,

683: decode(l.pval037,cn,vn,vn,vh,
684: hr_pump_get.gl(l.pval037,'POSITION_STATUS',d(l.pval146),l.pval006)) p37,
685: l.pval037 d37,
686: decode(l.pval038,cn,vn,vn,vh,
687: hr_pump_get.gl(l.pval038,'DAY_CODE',d(l.pval146),l.pval006)) p38,
688: l.pval038 d38,
689: decode(l.pval039,cn,vn,vn,vh,
690: hr_pump_get.gl(l.pval039,'MONTH_CODE',d(l.pval146),l.pval006)) p39,
691: l.pval039 d39,

Line 690: hr_pump_get.gl(l.pval039,'MONTH_CODE',d(l.pval146),l.pval006)) p39,

686: decode(l.pval038,cn,vn,vn,vh,
687: hr_pump_get.gl(l.pval038,'DAY_CODE',d(l.pval146),l.pval006)) p38,
688: l.pval038 d38,
689: decode(l.pval039,cn,vn,vn,vh,
690: hr_pump_get.gl(l.pval039,'MONTH_CODE',d(l.pval146),l.pval006)) p39,
691: l.pval039 d39,
692: decode(l.pval040,cn,vn,vn,vh,l.pval040) p40,
693: l.pval040 d40,
694: decode(l.pval041,cn,vn,vn,vh,l.pval041) p41,

Line 701: hr_pump_get.gl(l.pval044,'YES_NO',d(l.pval146),l.pval006)) p44,

697: l.pval042 d42,
698: decode(l.pval043,cn,nn,vn,nh,n(l.pval043)) p43,
699: l.pval043 d43,
700: decode(l.pval044,cn,vn,vn,vh,
701: hr_pump_get.gl(l.pval044,'YES_NO',d(l.pval146),l.pval006)) p44,
702: l.pval044 d44,
703: decode(l.pval045,cn,vn,vn,vh,
704: hr_pump_get.gl(l.pval045,'YES_NO',d(l.pval146),l.pval006)) p45,
705: l.pval045 d45,

Line 704: hr_pump_get.gl(l.pval045,'YES_NO',d(l.pval146),l.pval006)) p45,

700: decode(l.pval044,cn,vn,vn,vh,
701: hr_pump_get.gl(l.pval044,'YES_NO',d(l.pval146),l.pval006)) p44,
702: l.pval044 d44,
703: decode(l.pval045,cn,vn,vn,vh,
704: hr_pump_get.gl(l.pval045,'YES_NO',d(l.pval146),l.pval006)) p45,
705: l.pval045 d45,
706: decode(l.pval046,cn,vn,vn,vh,
707: hr_pump_get.gl(l.pval046,'DAY_CODE',d(l.pval146),l.pval006)) p46,
708: l.pval046 d46,

Line 707: hr_pump_get.gl(l.pval046,'DAY_CODE',d(l.pval146),l.pval006)) p46,

703: decode(l.pval045,cn,vn,vn,vh,
704: hr_pump_get.gl(l.pval045,'YES_NO',d(l.pval146),l.pval006)) p45,
705: l.pval045 d45,
706: decode(l.pval046,cn,vn,vn,vh,
707: hr_pump_get.gl(l.pval046,'DAY_CODE',d(l.pval146),l.pval006)) p46,
708: l.pval046 d46,
709: decode(l.pval047,cn,vn,vn,vh,
710: hr_pump_get.gl(l.pval047,'MONTH_CODE',d(l.pval146),l.pval006)) p47,
711: l.pval047 d47,

Line 710: hr_pump_get.gl(l.pval047,'MONTH_CODE',d(l.pval146),l.pval006)) p47,

706: decode(l.pval046,cn,vn,vn,vh,
707: hr_pump_get.gl(l.pval046,'DAY_CODE',d(l.pval146),l.pval006)) p46,
708: l.pval046 d46,
709: decode(l.pval047,cn,vn,vn,vh,
710: hr_pump_get.gl(l.pval047,'MONTH_CODE',d(l.pval146),l.pval006)) p47,
711: l.pval047 d47,
712: decode(l.pval048,cn,nn,vn,nh,n(l.pval048)) p48,
713: l.pval048 d48,
714: decode(l.pval049,cn,dn,vn,dh,d(l.pval049)) p49,

Line 982: hr_pump_get.get_position_id

978: c.p146 is null then
979: L_POSITION_ID:=nn;
980: else
981: L_POSITION_ID :=
982: hr_pump_get.get_position_id
983: (P_POSITION_NAME => c.p148
984: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
985: ,P_EFFECTIVE_DATE => c.p146);
986: end if;

Line 998: hr_pump_get.get_availability_status_id

994: c.d6 is null then
995: L_AVAILABILITY_STATUS_ID:=nh;
996: else
997: L_AVAILABILITY_STATUS_ID :=
998: hr_pump_get.get_availability_status_id
999: (P_SHARED_TYPE_NAME => c.p149
1000: ,P_SYSTEM_TYPE_CD => c.p150
1001: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1002: ,P_LANGUAGE_CODE => c.p6);

Line 1011: hr_pump_get.get_entry_step_id

1007: elsif c.d151 is null then
1008: L_ENTRY_STEP_ID:=nh;
1009: else
1010: L_ENTRY_STEP_ID :=
1011: hr_pump_get.get_entry_step_id
1012: (P_ENTRY_STEP_USER_KEY => c.p151);
1013: end if;
1014: --
1015: if c.d152=cn then

Line 1021: hr_pump_get.get_entry_grade_rule_id

1017: elsif c.d152 is null then
1018: L_ENTRY_GRADE_RULE_ID:=nh;
1019: else
1020: L_ENTRY_GRADE_RULE_ID :=
1021: hr_pump_get.get_entry_grade_rule_id
1022: (P_ENTRY_GRADE_RULE_USER_KEY => c.p152);
1023: end if;
1024: --
1025: if c.d153=cn or

Line 1033: hr_pump_get.get_location_id

1029: c.d6 is null then
1030: L_LOCATION_ID:=nh;
1031: else
1032: L_LOCATION_ID :=
1033: hr_pump_get.get_location_id
1034: (P_LOCATION_CODE => c.p153
1035: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1036: ,P_LANGUAGE_CODE => c.p6);
1037: end if;

Line 1046: hr_pump_get.get_pay_freq_payroll_id

1042: elsif c.d154 is null then
1043: L_PAY_FREQ_PAYROLL_ID:=nh;
1044: else
1045: L_PAY_FREQ_PAYROLL_ID :=
1046: hr_pump_get.get_pay_freq_payroll_id
1047: (P_PAY_FREQ_PAYROLL_NAME => c.p154
1048: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1049: ,P_EFFECTIVE_DATE => c.p146);
1050: end if;

Line 1059: hr_pump_get.get_prior_position_id

1055: elsif c.d155 is null then
1056: L_PRIOR_POSITION_ID:=nh;
1057: else
1058: L_PRIOR_POSITION_ID :=
1059: hr_pump_get.get_prior_position_id
1060: (P_PRIOR_POSITION_NAME => c.p155
1061: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1062: ,P_EFFECTIVE_DATE => c.p146);
1063: end if;

Line 1072: hr_pump_get.get_relief_position_id

1068: elsif c.d156 is null then
1069: L_RELIEF_POSITION_ID:=nh;
1070: else
1071: L_RELIEF_POSITION_ID :=
1072: hr_pump_get.get_relief_position_id
1073: (P_RELIEF_POSITION_NAME => c.p156
1074: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1075: ,P_EFFECTIVE_DATE => c.p146);
1076: end if;

Line 1085: hr_pump_get.get_entry_grade_id

1081: elsif c.d157 is null then
1082: L_ENTRY_GRADE_ID:=nh;
1083: else
1084: L_ENTRY_GRADE_ID :=
1085: hr_pump_get.get_entry_grade_id
1086: (P_ENTRY_GRADE_NAME => c.p157
1087: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1088: ,P_EFFECTIVE_DATE => c.p146);
1089: end if;

Line 1098: hr_pump_get.get_successor_position_id

1094: elsif c.d158 is null then
1095: L_SUCCESSOR_POSITION_ID:=nh;
1096: else
1097: L_SUCCESSOR_POSITION_ID :=
1098: hr_pump_get.get_successor_position_id
1099: (P_SUCCESSOR_POSITION_NAME => c.p158
1100: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1101: ,P_EFFECTIVE_DATE => c.p146);
1102: end if;

Line 1111: hr_pump_get.get_supervisor_position_id

1107: elsif c.d159 is null then
1108: L_SUPERVISOR_POSITION_ID:=nh;
1109: else
1110: L_SUPERVISOR_POSITION_ID :=
1111: hr_pump_get.get_supervisor_position_id
1112: (P_SUPERVISOR_POSITION_NAME => c.p159
1113: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1114: ,P_EFFECTIVE_DATE => c.p146);
1115: end if;

Line 1123: hr_pump_get.get_pay_basis_id

1119: elsif c.d160 is null then
1120: L_PAY_BASIS_ID:=nh;
1121: else
1122: L_PAY_BASIS_ID :=
1123: hr_pump_get.get_pay_basis_id
1124: (P_PAY_BASIS_NAME => c.p160
1125: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1126: end if;
1127: --

Line 1134: hr_pump_get.get_supervisor_id

1130: elsif c.d161 is null then
1131: L_SUPERVISOR_ID:=nh;
1132: else
1133: L_SUPERVISOR_ID :=
1134: hr_pump_get.get_supervisor_id
1135: (P_SUPERVISOR_USER_KEY => c.p161);
1136: end if;
1137: --
1138: L_PROGRAM_ID :=

Line 1139: hr_pump_get.get_program_id;

1135: (P_SUPERVISOR_USER_KEY => c.p161);
1136: end if;
1137: --
1138: L_PROGRAM_ID :=
1139: hr_pump_get.get_program_id;
1140: --
1141: if c.p148 is null or
1142: c.p146 is null then
1143: L_OBJECT_VERSION_NUMBER:=nn;

Line 1146: hr_pump_get.GET_POS_OVN

1142: c.p146 is null then
1143: L_OBJECT_VERSION_NUMBER:=nn;
1144: else
1145: L_OBJECT_VERSION_NUMBER :=
1146: hr_pump_get.GET_POS_OVN
1147: (P_POSITION_NAME => c.p148
1148: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1149: ,P_EFFECTIVE_DATE => c.p146);
1150: end if;