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

Line 611: hr_pump_get.gl(l.pval014,'BARGAINING_UNIT_CODE',d(l.pval007),l.pval009)) p14,

607: l.pval012 d12,
608: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
609: l.pval013 d13,
610: decode(l.pval014,cn,vn,vn,vn,
611: hr_pump_get.gl(l.pval014,'BARGAINING_UNIT_CODE',d(l.pval007),l.pval009)) p14,
612: l.pval014 d14,
613: decode(l.pval015,cn,vn,vn,null,l.pval015) p15,
614: l.pval015 d15,
615: decode(l.pval016,cn,dn,vn,dn,d(l.pval016)) p16,

Line 628: hr_pump_get.gl(l.pval022,'FREQUENCY',d(l.pval007),l.pval009)) p22,

624: l.pval020 d20,
625: decode(l.pval021,cn,dn,vn,dn,d(l.pval021)) p21,
626: l.pval021 d21,
627: decode(l.pval022,cn,vn,vn,vn,
628: hr_pump_get.gl(l.pval022,'FREQUENCY',d(l.pval007),l.pval009)) p22,
629: l.pval022 d22,
630: decode(l.pval023,cn,nn,vn,nn,n(l.pval023)) p23,
631: l.pval023 d23,
632: decode(l.pval024,cn,nn,vn,nn,n(l.pval024)) p24,

Line 637: hr_pump_get.gl(l.pval026,'FREQUENCY',d(l.pval007),l.pval009)) p26,

633: l.pval024 d24,
634: decode(l.pval025,cn,nn,vn,nn,n(l.pval025)) p25,
635: l.pval025 d25,
636: decode(l.pval026,cn,vn,vn,vn,
637: hr_pump_get.gl(l.pval026,'FREQUENCY',d(l.pval007),l.pval009)) p26,
638: l.pval026 d26,
639: decode(l.pval027,cn,vn,vn,vn,
640: hr_pump_get.gl(l.pval027,'DAY_CODE',d(l.pval007),l.pval009)) p27,
641: l.pval027 d27,

Line 640: hr_pump_get.gl(l.pval027,'DAY_CODE',d(l.pval007),l.pval009)) p27,

636: decode(l.pval026,cn,vn,vn,vn,
637: hr_pump_get.gl(l.pval026,'FREQUENCY',d(l.pval007),l.pval009)) p26,
638: l.pval026 d26,
639: decode(l.pval027,cn,vn,vn,vn,
640: hr_pump_get.gl(l.pval027,'DAY_CODE',d(l.pval007),l.pval009)) p27,
641: l.pval027 d27,
642: decode(l.pval028,cn,vn,vn,vn,
643: hr_pump_get.gl(l.pval028,'MONTH_CODE',d(l.pval007),l.pval009)) p28,
644: l.pval028 d28,

Line 643: hr_pump_get.gl(l.pval028,'MONTH_CODE',d(l.pval007),l.pval009)) p28,

639: decode(l.pval027,cn,vn,vn,vn,
640: hr_pump_get.gl(l.pval027,'DAY_CODE',d(l.pval007),l.pval009)) p27,
641: l.pval027 d27,
642: decode(l.pval028,cn,vn,vn,vn,
643: hr_pump_get.gl(l.pval028,'MONTH_CODE',d(l.pval007),l.pval009)) p28,
644: l.pval028 d28,
645: decode(l.pval029,cn,vn,vn,vn,
646: hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval007),l.pval009)) p29,
647: l.pval029 d29,

Line 646: hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval007),l.pval009)) p29,

642: decode(l.pval028,cn,vn,vn,vn,
643: hr_pump_get.gl(l.pval028,'MONTH_CODE',d(l.pval007),l.pval009)) p28,
644: l.pval028 d28,
645: decode(l.pval029,cn,vn,vn,vn,
646: hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval007),l.pval009)) p29,
647: l.pval029 d29,
648: decode(l.pval030,cn,vn,vn,vn,
649: hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval007),l.pval009)) p30,
650: l.pval030 d30,

Line 649: hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval007),l.pval009)) p30,

645: decode(l.pval029,cn,vn,vn,vn,
646: hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval007),l.pval009)) p29,
647: l.pval029 d29,
648: decode(l.pval030,cn,vn,vn,vn,
649: hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval007),l.pval009)) p30,
650: l.pval030 d30,
651: decode(l.pval031,cn,vn,vn,'NONE',
652: hr_pump_get.gl(l.pval031,'POSITION_TYPE',d(l.pval007),l.pval009)) p31,
653: l.pval031 d31,

Line 652: hr_pump_get.gl(l.pval031,'POSITION_TYPE',d(l.pval007),l.pval009)) p31,

648: decode(l.pval030,cn,vn,vn,vn,
649: hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval007),l.pval009)) p30,
650: l.pval030 d30,
651: decode(l.pval031,cn,vn,vn,'NONE',
652: hr_pump_get.gl(l.pval031,'POSITION_TYPE',d(l.pval007),l.pval009)) p31,
653: l.pval031 d31,
654: decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
655: l.pval032 d32,
656: decode(l.pval033,cn,nn,vn,nn,n(l.pval033)) p33,

Line 659: hr_pump_get.gl(l.pval034,'QUALIFYING_UNITS',d(l.pval007),l.pval009)) p34,

655: l.pval032 d32,
656: decode(l.pval033,cn,nn,vn,nn,n(l.pval033)) p33,
657: l.pval033 d33,
658: decode(l.pval034,cn,vn,vn,vn,
659: hr_pump_get.gl(l.pval034,'QUALIFYING_UNITS',d(l.pval007),l.pval009)) p34,
660: l.pval034 d34,
661: decode(l.pval035,cn,vn,vn,vn,
662: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval007),l.pval009)) p35,
663: l.pval035 d35,

Line 662: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval007),l.pval009)) p35,

658: decode(l.pval034,cn,vn,vn,vn,
659: hr_pump_get.gl(l.pval034,'QUALIFYING_UNITS',d(l.pval007),l.pval009)) p34,
660: l.pval034 d34,
661: decode(l.pval035,cn,vn,vn,vn,
662: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval007),l.pval009)) p35,
663: l.pval035 d35,
664: decode(l.pval036,cn,vn,vn,vn,
665: hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval007),l.pval009)) p36,
666: l.pval036 d36,

Line 665: hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval007),l.pval009)) p36,

661: decode(l.pval035,cn,vn,vn,vn,
662: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval007),l.pval009)) p35,
663: l.pval035 d35,
664: decode(l.pval036,cn,vn,vn,vn,
665: hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval007),l.pval009)) p36,
666: l.pval036 d36,
667: decode(l.pval037,cn,vn,vn,vn,
668: hr_pump_get.gl(l.pval037,'YES_NO',d(l.pval007),l.pval009)) p37,
669: l.pval037 d37,

Line 668: hr_pump_get.gl(l.pval037,'YES_NO',d(l.pval007),l.pval009)) p37,

664: decode(l.pval036,cn,vn,vn,vn,
665: hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval007),l.pval009)) p36,
666: l.pval036 d36,
667: decode(l.pval037,cn,vn,vn,vn,
668: hr_pump_get.gl(l.pval037,'YES_NO',d(l.pval007),l.pval009)) p37,
669: l.pval037 d37,
670: decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
671: l.pval038 d38,
672: decode(l.pval039,cn,vn,vn,vn,

Line 673: hr_pump_get.gl(l.pval039,'POSITION_STATUS',d(l.pval007),l.pval009)) p39,

669: l.pval037 d37,
670: decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
671: l.pval038 d38,
672: decode(l.pval039,cn,vn,vn,vn,
673: hr_pump_get.gl(l.pval039,'POSITION_STATUS',d(l.pval007),l.pval009)) p39,
674: l.pval039 d39,
675: decode(l.pval040,cn,vn,vn,vn,
676: hr_pump_get.gl(l.pval040,'DAY_CODE',d(l.pval007),l.pval009)) p40,
677: l.pval040 d40,

Line 676: hr_pump_get.gl(l.pval040,'DAY_CODE',d(l.pval007),l.pval009)) p40,

672: decode(l.pval039,cn,vn,vn,vn,
673: hr_pump_get.gl(l.pval039,'POSITION_STATUS',d(l.pval007),l.pval009)) p39,
674: l.pval039 d39,
675: decode(l.pval040,cn,vn,vn,vn,
676: hr_pump_get.gl(l.pval040,'DAY_CODE',d(l.pval007),l.pval009)) p40,
677: l.pval040 d40,
678: decode(l.pval041,cn,vn,vn,vn,
679: hr_pump_get.gl(l.pval041,'MONTH_CODE',d(l.pval007),l.pval009)) p41,
680: l.pval041 d41,

Line 679: hr_pump_get.gl(l.pval041,'MONTH_CODE',d(l.pval007),l.pval009)) p41,

675: decode(l.pval040,cn,vn,vn,vn,
676: hr_pump_get.gl(l.pval040,'DAY_CODE',d(l.pval007),l.pval009)) p40,
677: l.pval040 d40,
678: decode(l.pval041,cn,vn,vn,vn,
679: hr_pump_get.gl(l.pval041,'MONTH_CODE',d(l.pval007),l.pval009)) p41,
680: l.pval041 d41,
681: decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
682: l.pval042 d42,
683: decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,

Line 690: hr_pump_get.gl(l.pval046,'YES_NO',d(l.pval007),l.pval009)) p46,

686: l.pval044 d44,
687: decode(l.pval045,cn,nn,vn,nn,n(l.pval045)) p45,
688: l.pval045 d45,
689: decode(l.pval046,cn,vn,vn,vn,
690: hr_pump_get.gl(l.pval046,'YES_NO',d(l.pval007),l.pval009)) p46,
691: l.pval046 d46,
692: decode(l.pval047,cn,vn,vn,vn,
693: hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval007),l.pval009)) p47,
694: l.pval047 d47,

Line 693: hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval007),l.pval009)) p47,

689: decode(l.pval046,cn,vn,vn,vn,
690: hr_pump_get.gl(l.pval046,'YES_NO',d(l.pval007),l.pval009)) p46,
691: l.pval046 d46,
692: decode(l.pval047,cn,vn,vn,vn,
693: hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval007),l.pval009)) p47,
694: l.pval047 d47,
695: decode(l.pval048,cn,vn,vn,vn,
696: hr_pump_get.gl(l.pval048,'DAY_CODE',d(l.pval007),l.pval009)) p48,
697: l.pval048 d48,

Line 696: hr_pump_get.gl(l.pval048,'DAY_CODE',d(l.pval007),l.pval009)) p48,

692: decode(l.pval047,cn,vn,vn,vn,
693: hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval007),l.pval009)) p47,
694: l.pval047 d47,
695: decode(l.pval048,cn,vn,vn,vn,
696: hr_pump_get.gl(l.pval048,'DAY_CODE',d(l.pval007),l.pval009)) p48,
697: l.pval048 d48,
698: decode(l.pval049,cn,vn,vn,vn,
699: hr_pump_get.gl(l.pval049,'MONTH_CODE',d(l.pval007),l.pval009)) p49,
700: l.pval049 d49,

Line 699: hr_pump_get.gl(l.pval049,'MONTH_CODE',d(l.pval007),l.pval009)) p49,

695: decode(l.pval048,cn,vn,vn,vn,
696: hr_pump_get.gl(l.pval048,'DAY_CODE',d(l.pval007),l.pval009)) p48,
697: l.pval048 d48,
698: decode(l.pval049,cn,vn,vn,vn,
699: hr_pump_get.gl(l.pval049,'MONTH_CODE',d(l.pval007),l.pval009)) p49,
700: l.pval049 d49,
701: decode(l.pval050,cn,nn,vn,nn,n(l.pval050)) p50,
702: l.pval050 d50,
703: decode(l.pval051,cn,dn,vn,dn,d(l.pval051)) p51,

Line 966: hr_pump_get.get_job_id

962: c.p7 is null then
963: L_JOB_ID:=nn;
964: else
965: L_JOB_ID :=
966: hr_pump_get.get_job_id
967: (P_JOB_NAME => c.p150
968: ,P_EFFECTIVE_DATE => c.p7
969: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
970: end if;

Line 978: hr_pump_get.get_organization_id

974: c.p9 is null then
975: L_ORGANIZATION_ID:=nn;
976: else
977: L_ORGANIZATION_ID :=
978: hr_pump_get.get_organization_id
979: (P_ORGANIZATION_NAME => c.p151
980: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
981: ,P_EFFECTIVE_DATE => c.p7
982: ,P_LANGUAGE_CODE => c.p9);

Line 991: hr_pump_get.get_availability_status_id

987: c.p9 is null then
988: L_AVAILABILITY_STATUS_ID:=nn;
989: else
990: L_AVAILABILITY_STATUS_ID :=
991: hr_pump_get.get_availability_status_id
992: (P_SHARED_TYPE_NAME => c.p152
993: ,P_SYSTEM_TYPE_CD => c.p153
994: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
995: ,P_LANGUAGE_CODE => c.p9);

Line 1002: hr_pump_get.get_entry_step_id

998: if c.p154 is null then
999: L_ENTRY_STEP_ID:=nn;
1000: else
1001: L_ENTRY_STEP_ID :=
1002: hr_pump_get.get_entry_step_id
1003: (P_ENTRY_STEP_USER_KEY => c.p154);
1004: end if;
1005: --
1006: if c.p155 is null then

Line 1010: hr_pump_get.get_entry_grade_rule_id

1006: if c.p155 is null then
1007: L_ENTRY_GRADE_RULE_ID:=nn;
1008: else
1009: L_ENTRY_GRADE_RULE_ID :=
1010: hr_pump_get.get_entry_grade_rule_id
1011: (P_ENTRY_GRADE_RULE_USER_KEY => c.p155);
1012: end if;
1013: --
1014: if c.p156 is null or

Line 1019: hr_pump_get.get_location_id

1015: c.p9 is null then
1016: L_LOCATION_ID:=nn;
1017: else
1018: L_LOCATION_ID :=
1019: hr_pump_get.get_location_id
1020: (P_LOCATION_CODE => c.p156
1021: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1022: ,P_LANGUAGE_CODE => c.p9);
1023: end if;

Line 1030: hr_pump_get.get_pay_freq_payroll_id

1026: c.p7 is null then
1027: L_PAY_FREQ_PAYROLL_ID:=nn;
1028: else
1029: L_PAY_FREQ_PAYROLL_ID :=
1030: hr_pump_get.get_pay_freq_payroll_id
1031: (P_PAY_FREQ_PAYROLL_NAME => c.p157
1032: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1033: ,P_EFFECTIVE_DATE => c.p7);
1034: end if;

Line 1041: hr_pump_get.get_prior_position_id

1037: c.p7 is null then
1038: L_PRIOR_POSITION_ID:=nn;
1039: else
1040: L_PRIOR_POSITION_ID :=
1041: hr_pump_get.get_prior_position_id
1042: (P_PRIOR_POSITION_NAME => c.p158
1043: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1044: ,P_EFFECTIVE_DATE => c.p7);
1045: end if;

Line 1052: hr_pump_get.get_relief_position_id

1048: c.p7 is null then
1049: L_RELIEF_POSITION_ID:=nn;
1050: else
1051: L_RELIEF_POSITION_ID :=
1052: hr_pump_get.get_relief_position_id
1053: (P_RELIEF_POSITION_NAME => c.p159
1054: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1055: ,P_EFFECTIVE_DATE => c.p7);
1056: end if;

Line 1063: hr_pump_get.get_entry_grade_id

1059: c.p7 is null then
1060: L_ENTRY_GRADE_ID:=nn;
1061: else
1062: L_ENTRY_GRADE_ID :=
1063: hr_pump_get.get_entry_grade_id
1064: (P_ENTRY_GRADE_NAME => c.p160
1065: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1066: ,P_EFFECTIVE_DATE => c.p7);
1067: end if;

Line 1074: hr_pump_get.get_successor_position_id

1070: c.p7 is null then
1071: L_SUCCESSOR_POSITION_ID:=nn;
1072: else
1073: L_SUCCESSOR_POSITION_ID :=
1074: hr_pump_get.get_successor_position_id
1075: (P_SUCCESSOR_POSITION_NAME => c.p161
1076: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1077: ,P_EFFECTIVE_DATE => c.p7);
1078: end if;

Line 1085: hr_pump_get.get_supervisor_position_id

1081: c.p7 is null then
1082: L_SUPERVISOR_POSITION_ID:=nn;
1083: else
1084: L_SUPERVISOR_POSITION_ID :=
1085: hr_pump_get.get_supervisor_position_id
1086: (P_SUPERVISOR_POSITION_NAME => c.p162
1087: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1088: ,P_EFFECTIVE_DATE => c.p7);
1089: end if;

Line 1095: hr_pump_get.get_pay_basis_id

1091: if c.p163 is null then
1092: L_PAY_BASIS_ID:=nn;
1093: else
1094: L_PAY_BASIS_ID :=
1095: hr_pump_get.get_pay_basis_id
1096: (P_PAY_BASIS_NAME => c.p163
1097: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1098: end if;
1099: --

Line 1104: hr_pump_get.get_supervisor_id

1100: if c.p164 is null then
1101: L_SUPERVISOR_ID:=nn;
1102: else
1103: L_SUPERVISOR_ID :=
1104: hr_pump_get.get_supervisor_id
1105: (P_SUPERVISOR_USER_KEY => c.p164);
1106: end if;
1107: --
1108: hr_data_pump.api_trc_on;