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.

[Home] [Help]

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: l.plongval plongval,
614: decode(l.pval016,cn,dn,vn,dn,d(l.pval016)) p16,
615: l.pval016 d16,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 971: hr_pump_get.get_job_id

967: c.p7 is null then
968: L_JOB_ID:=nn;
969: else
970: L_JOB_ID :=
971: hr_pump_get.get_job_id
972: (P_JOB_NAME => c.p150
973: ,P_EFFECTIVE_DATE => c.p7
974: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
975: end if;

Line 983: hr_pump_get.get_organization_id

979: c.p9 is null then
980: L_ORGANIZATION_ID:=nn;
981: else
982: L_ORGANIZATION_ID :=
983: hr_pump_get.get_organization_id
984: (P_ORGANIZATION_NAME => c.p151
985: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
986: ,P_EFFECTIVE_DATE => c.p7
987: ,P_LANGUAGE_CODE => c.p9);

Line 996: hr_pump_get.get_availability_status_id

992: c.p9 is null then
993: L_AVAILABILITY_STATUS_ID:=nn;
994: else
995: L_AVAILABILITY_STATUS_ID :=
996: hr_pump_get.get_availability_status_id
997: (P_SHARED_TYPE_NAME => c.p152
998: ,P_SYSTEM_TYPE_CD => c.p153
999: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1000: ,P_LANGUAGE_CODE => c.p9);

Line 1007: hr_pump_get.get_entry_step_id

1003: if c.p154 is null then
1004: L_ENTRY_STEP_ID:=nn;
1005: else
1006: L_ENTRY_STEP_ID :=
1007: hr_pump_get.get_entry_step_id
1008: (P_ENTRY_STEP_USER_KEY => c.p154);
1009: end if;
1010: --
1011: if c.p155 is null then

Line 1015: hr_pump_get.get_entry_grade_rule_id

1011: if c.p155 is null then
1012: L_ENTRY_GRADE_RULE_ID:=nn;
1013: else
1014: L_ENTRY_GRADE_RULE_ID :=
1015: hr_pump_get.get_entry_grade_rule_id
1016: (P_ENTRY_GRADE_RULE_USER_KEY => c.p155);
1017: end if;
1018: --
1019: if c.p156 is null or

Line 1024: hr_pump_get.get_location_id

1020: c.p9 is null then
1021: L_LOCATION_ID:=nn;
1022: else
1023: L_LOCATION_ID :=
1024: hr_pump_get.get_location_id
1025: (P_LOCATION_CODE => c.p156
1026: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1027: ,P_LANGUAGE_CODE => c.p9);
1028: end if;

Line 1035: hr_pump_get.get_pay_freq_payroll_id

1031: c.p7 is null then
1032: L_PAY_FREQ_PAYROLL_ID:=nn;
1033: else
1034: L_PAY_FREQ_PAYROLL_ID :=
1035: hr_pump_get.get_pay_freq_payroll_id
1036: (P_PAY_FREQ_PAYROLL_NAME => c.p157
1037: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1038: ,P_EFFECTIVE_DATE => c.p7);
1039: end if;

Line 1046: hr_pump_get.get_prior_position_id

1042: c.p7 is null then
1043: L_PRIOR_POSITION_ID:=nn;
1044: else
1045: L_PRIOR_POSITION_ID :=
1046: hr_pump_get.get_prior_position_id
1047: (P_PRIOR_POSITION_NAME => c.p158
1048: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1049: ,P_EFFECTIVE_DATE => c.p7);
1050: end if;

Line 1057: hr_pump_get.get_relief_position_id

1053: c.p7 is null then
1054: L_RELIEF_POSITION_ID:=nn;
1055: else
1056: L_RELIEF_POSITION_ID :=
1057: hr_pump_get.get_relief_position_id
1058: (P_RELIEF_POSITION_NAME => c.p159
1059: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1060: ,P_EFFECTIVE_DATE => c.p7);
1061: end if;

Line 1068: hr_pump_get.get_entry_grade_id

1064: c.p7 is null then
1065: L_ENTRY_GRADE_ID:=nn;
1066: else
1067: L_ENTRY_GRADE_ID :=
1068: hr_pump_get.get_entry_grade_id
1069: (P_ENTRY_GRADE_NAME => c.p160
1070: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1071: ,P_EFFECTIVE_DATE => c.p7);
1072: end if;

Line 1079: hr_pump_get.get_successor_position_id

1075: c.p7 is null then
1076: L_SUCCESSOR_POSITION_ID:=nn;
1077: else
1078: L_SUCCESSOR_POSITION_ID :=
1079: hr_pump_get.get_successor_position_id
1080: (P_SUCCESSOR_POSITION_NAME => c.p161
1081: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1082: ,P_EFFECTIVE_DATE => c.p7);
1083: end if;

Line 1090: hr_pump_get.get_supervisor_position_id

1086: c.p7 is null then
1087: L_SUPERVISOR_POSITION_ID:=nn;
1088: else
1089: L_SUPERVISOR_POSITION_ID :=
1090: hr_pump_get.get_supervisor_position_id
1091: (P_SUPERVISOR_POSITION_NAME => c.p162
1092: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1093: ,P_EFFECTIVE_DATE => c.p7);
1094: end if;

Line 1100: hr_pump_get.get_pay_basis_id

1096: if c.p163 is null then
1097: L_PAY_BASIS_ID:=nn;
1098: else
1099: L_PAY_BASIS_ID :=
1100: hr_pump_get.get_pay_basis_id
1101: (P_PAY_BASIS_NAME => c.p163
1102: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1103: end if;
1104: --

Line 1109: hr_pump_get.get_supervisor_id

1105: if c.p164 is null then
1106: L_SUPERVISOR_ID:=nn;
1107: else
1108: L_SUPERVISOR_ID :=
1109: hr_pump_get.get_supervisor_id
1110: (P_SUPERVISOR_USER_KEY => c.p164);
1111: end if;
1112: --
1113: hr_data_pump.api_trc_on;