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

Line 610: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval159)) p3,

606: select l.rowid myrowid,
607: decode(l.pval001,cn,dn,d(l.pval001)) p1,
608: decode(l.pval002,cn,vn,l.pval002) p2,
609: decode(l.pval003,cn,vn,vn,vn,
610: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval159)) p3,
611: l.pval003 d3,
612: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
613: l.pval004 d4,
614: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,

Line 617: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval159)) p6,

613: l.pval004 d4,
614: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
615: l.pval005 d5,
616: decode(l.pval006,cn,vn,vn,vn,
617: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval159)) p6,
618: l.pval006 d6,
619: decode(l.pval007,cn,vn,vn,vn,
620: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval159)) p7,
621: l.pval007 d7,

Line 620: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval159)) p7,

616: decode(l.pval006,cn,vn,vn,vn,
617: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval159)) p6,
618: l.pval006 d6,
619: decode(l.pval007,cn,vn,vn,vn,
620: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval159)) p7,
621: l.pval007 d7,
622: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
623: l.pval008 d8,
624: decode(l.pval009,cn,vn,vn,vn,

Line 625: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval159)) p9,

621: l.pval007 d7,
622: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
623: l.pval008 d8,
624: decode(l.pval009,cn,vn,vn,vn,
625: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval159)) p9,
626: l.pval009 d9,
627: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
628: l.pval010 d10,
629: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,

Line 632: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval159)) p12,

628: l.pval010 d10,
629: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
630: l.pval011 d11,
631: decode(l.pval012,cn,vn,vn,vn,
632: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval159)) p12,
633: l.pval012 d12,
634: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
635: l.pval013 d13,
636: decode(l.pval014,cn,vn,vn,vn,

Line 637: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval159)) p14,

633: l.pval012 d12,
634: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
635: l.pval013 d13,
636: decode(l.pval014,cn,vn,vn,vn,
637: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval159)) p14,
638: l.pval014 d14,
639: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
640: l.pval015 d15,
641: decode(l.pval016,cn,vn,vn,vn,

Line 642: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval159)) p16,

638: l.pval014 d14,
639: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
640: l.pval015 d15,
641: decode(l.pval016,cn,vn,vn,vn,
642: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval159)) p16,
643: l.pval016 d16,
644: decode(l.pval017,cn,vn,vn,vn,
645: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval159)) p17,
646: l.pval017 d17,

Line 645: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval159)) p17,

641: decode(l.pval016,cn,vn,vn,vn,
642: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval159)) p16,
643: l.pval016 d16,
644: decode(l.pval017,cn,vn,vn,vn,
645: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval159)) p17,
646: l.pval017 d17,
647: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
648: l.pval018 d18,
649: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,

Line 652: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval159)) p20,

648: l.pval018 d18,
649: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
650: l.pval019 d19,
651: decode(l.pval020,cn,vn,vn,vn,
652: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval159)) p20,
653: l.pval020 d20,
654: decode(l.pval021,cn,vn,vn,'N',
655: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval159)) p21,
656: l.pval021 d21,

Line 655: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval159)) p21,

651: decode(l.pval020,cn,vn,vn,vn,
652: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval159)) p20,
653: l.pval020 d20,
654: decode(l.pval021,cn,vn,vn,'N',
655: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval159)) p21,
656: l.pval021 d21,
657: decode(l.pval022,cn,vn,vn,vn,
658: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval159)) p22,
659: l.pval022 d22,

Line 658: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval159)) p22,

654: decode(l.pval021,cn,vn,vn,'N',
655: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval159)) p21,
656: l.pval021 d21,
657: decode(l.pval022,cn,vn,vn,vn,
658: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval159)) p22,
659: l.pval022 d22,
660: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
661: l.pval023 d23,
662: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,

Line 994: hr_pump_get.get_person_id

990: if c.p157 is null then
991: L_PERSON_ID:=nn;
992: else
993: L_PERSON_ID :=
994: hr_pump_get.get_person_id
995: (P_PERSON_USER_KEY => c.p157);
996: end if;
997: --
998: if c.p158 is null or

Line 1004: hr_pump_get.get_organization_id

1000: c.p159 is null then
1001: L_ORGANIZATION_ID:=nn;
1002: else
1003: L_ORGANIZATION_ID :=
1004: hr_pump_get.get_organization_id
1005: (P_ORGANIZATION_NAME => c.p158
1006: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1007: ,P_EFFECTIVE_DATE => c.p1
1008: ,P_LANGUAGE_CODE => c.p159);

Line 1016: hr_pump_get.get_grade_id

1012: c.p1 is null then
1013: L_GRADE_ID:=nn;
1014: else
1015: L_GRADE_ID :=
1016: hr_pump_get.get_grade_id
1017: (P_GRADE_NAME => c.p160
1018: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1019: ,P_EFFECTIVE_DATE => c.p1);
1020: end if;

Line 1027: hr_pump_get.get_position_id

1023: c.p1 is null then
1024: L_POSITION_ID:=nn;
1025: else
1026: L_POSITION_ID :=
1027: hr_pump_get.get_position_id
1028: (P_POSITION_NAME => c.p161
1029: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1030: ,P_EFFECTIVE_DATE => c.p1);
1031: end if;

Line 1038: hr_pump_get.get_job_id

1034: c.p1 is null then
1035: L_JOB_ID:=nn;
1036: else
1037: L_JOB_ID :=
1038: hr_pump_get.get_job_id
1039: (P_JOB_NAME => c.p162
1040: ,P_EFFECTIVE_DATE => c.p1
1041: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1042: end if;

Line 1049: hr_pump_get.get_assignment_status_type_id

1045: c.p159 is null then
1046: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
1047: else
1048: L_ASSIGNMENT_STATUS_TYPE_ID :=
1049: hr_pump_get.get_assignment_status_type_id
1050: (P_USER_STATUS => c.p163
1051: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1052: ,P_LANGUAGE_CODE => c.p159);
1053: end if;

Line 1060: hr_pump_get.get_payroll_id

1056: c.p1 is null then
1057: L_PAYROLL_ID:=nn;
1058: else
1059: L_PAYROLL_ID :=
1060: hr_pump_get.get_payroll_id
1061: (P_PAYROLL_NAME => c.p164
1062: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1063: ,P_EFFECTIVE_DATE => c.p1);
1064: end if;

Line 1071: hr_pump_get.get_location_id

1067: c.p159 is null then
1068: L_LOCATION_ID:=nn;
1069: else
1070: L_LOCATION_ID :=
1071: hr_pump_get.get_location_id
1072: (P_LOCATION_CODE => c.p165
1073: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1074: ,P_LANGUAGE_CODE => c.p159);
1075: end if;

Line 1081: hr_pump_get.get_supervisor_id

1077: if c.p166 is null then
1078: L_SUPERVISOR_ID:=nn;
1079: else
1080: L_SUPERVISOR_ID :=
1081: hr_pump_get.get_supervisor_id
1082: (P_SUPERVISOR_USER_KEY => c.p166);
1083: end if;
1084: --
1085: if c.p167 is null then

Line 1089: hr_pump_get.get_special_ceiling_step_id

1085: if c.p167 is null then
1086: L_SPECIAL_CEILING_STEP_ID:=nn;
1087: else
1088: L_SPECIAL_CEILING_STEP_ID :=
1089: hr_pump_get.get_special_ceiling_step_id
1090: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p167);
1091: end if;
1092: --
1093: if c.p168 is null then

Line 1097: hr_pump_get.get_pay_basis_id

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

Line 1106: hr_pump_get.get_default_code_comb_id

1102: if c.p169 is null then
1103: L_DEFAULT_CODE_COMB_ID:=nn;
1104: else
1105: L_DEFAULT_CODE_COMB_ID :=
1106: hr_pump_get.get_default_code_comb_id
1107: (P_DEFAULT_CODE_COMB_USER_KEY => c.p169);
1108: end if;
1109: --
1110: if c.p170 is null then

Line 1114: hr_pump_get.get_set_of_books_id

1110: if c.p170 is null then
1111: L_SET_OF_BOOKS_ID:=nn;
1112: else
1113: L_SET_OF_BOOKS_ID :=
1114: hr_pump_get.get_set_of_books_id
1115: (P_SET_OF_BOOKS_NAME => c.p170);
1116: end if;
1117: --
1118: if c.p171 is null then

Line 1122: hr_pump_get.get_contract_id

1118: if c.p171 is null then
1119: L_CONTRACT_ID:=nn;
1120: else
1121: L_CONTRACT_ID :=
1122: hr_pump_get.get_contract_id
1123: (P_CONTRACT_USER_KEY => c.p171);
1124: end if;
1125: --
1126: if c.p172 is null or

Line 1132: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

1128: c.p159 is null then
1129: L_ESTABLISHMENT_ID:=nn;
1130: else
1131: L_ESTABLISHMENT_ID :=
1132: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
1133: (P_ESTABLISHMENT_ORG_NAME => c.p172
1134: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1135: ,P_EFFECTIVE_DATE => c.p1
1136: ,P_LANGUAGE_CODE => c.p159);

Line 1144: hr_pump_get.get_collective_agreement_id

1140: c.p1 is null then
1141: L_COLLECTIVE_AGREEMENT_ID:=nn;
1142: else
1143: L_COLLECTIVE_AGREEMENT_ID :=
1144: hr_pump_get.get_collective_agreement_id
1145: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1146: ,P_CAGR_NAME => c.p173
1147: ,P_EFFECTIVE_DATE => c.p1);
1148: end if;

Line 1154: hr_pump_get.GET_CAGR_ID_FLEX_NUM

1150: if c.p174 is null then
1151: L_CAGR_ID_FLEX_NUM:=nn;
1152: else
1153: L_CAGR_ID_FLEX_NUM :=
1154: hr_pump_get.GET_CAGR_ID_FLEX_NUM
1155: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p174);
1156: end if;
1157: --
1158: if c.p175 is null or

Line 1163: hr_pump_get.GET_GRADE_LADDER_PGM_ID

1159: c.p1 is null then
1160: L_GRADE_LADDER_PGM_ID:=nn;
1161: else
1162: L_GRADE_LADDER_PGM_ID :=
1163: hr_pump_get.GET_GRADE_LADDER_PGM_ID
1164: (P_GRADE_LADDER_NAME => c.p175
1165: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1166: ,P_EFFECTIVE_DATE => c.p1);
1167: end if;

Line 1173: hr_pump_get.GET_SUPERVISOR_ASSIGNMENT_ID

1169: if c.p176 is null then
1170: L_SUPERVISOR_ASSIGNMENT_ID:=nn;
1171: else
1172: L_SUPERVISOR_ASSIGNMENT_ID :=
1173: hr_pump_get.GET_SUPERVISOR_ASSIGNMENT_ID
1174: (P_SVR_ASSIGNMENT_USER_KEY => c.p176);
1175: end if;
1176: --
1177: hr_data_pump.api_trc_on;