DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_PTNL_LER_FOR_PER dependencies on HR_PUMP_GET

Line 178: hr_pump_get.gl(l.pval002,'BEN_PTNL_LER_FOR_PER_STAT',d(l.pval012),vn)) p2,

174: select l.rowid myrowid,
175: decode(l.pval001,cn,dn,vn,dh,d(l.pval001)) p1,
176: l.pval001 d1,
177: decode(l.pval002,cn,vn,vn,vh,
178: hr_pump_get.gl(l.pval002,'BEN_PTNL_LER_FOR_PER_STAT',d(l.pval012),vn)) p2,
179: l.pval002 d2,
180: decode(l.pval003,cn,vn,vn,vh,
181: hr_pump_get.gl(l.pval003,'BEN_PTNL_LER_FOR_PER_SRC',d(l.pval012),vn)) p3,
182: l.pval003 d3,

Line 181: hr_pump_get.gl(l.pval003,'BEN_PTNL_LER_FOR_PER_SRC',d(l.pval012),vn)) p3,

177: decode(l.pval002,cn,vn,vn,vh,
178: hr_pump_get.gl(l.pval002,'BEN_PTNL_LER_FOR_PER_STAT',d(l.pval012),vn)) p2,
179: l.pval002 d2,
180: decode(l.pval003,cn,vn,vn,vh,
181: hr_pump_get.gl(l.pval003,'BEN_PTNL_LER_FOR_PER_SRC',d(l.pval012),vn)) p3,
182: l.pval003 d3,
183: decode(l.pval004,cn,dn,vn,dh,d(l.pval004)) p4,
184: l.pval004 d4,
185: decode(l.pval005,cn,dn,vn,dh,d(l.pval005)) p5,

Line 243: hr_pump_get.get_ptnl_ler_for_per_id

239: if c.p13 is null then
240: L_PTNL_LER_FOR_PER_ID:=nn;
241: else
242: L_PTNL_LER_FOR_PER_ID :=
243: hr_pump_get.get_ptnl_ler_for_per_id
244: (P_PTNL_LER_FOR_PER_USER_KEY => c.p13);
245: end if;
246: --
247: if c.d14=cn then

Line 253: hr_pump_get.get_csd_by_ptnl_ler_for_per_id

249: elsif c.d14 is null then
250: L_CSD_BY_PTNL_LER_FOR_PER_ID:=nh;
251: else
252: L_CSD_BY_PTNL_LER_FOR_PER_ID :=
253: hr_pump_get.get_csd_by_ptnl_ler_for_per_id
254: (P_CSD_BY_PPL_USER_KEY => c.p14);
255: end if;
256: --
257: if c.d15=cn then

Line 263: hr_pump_get.get_trgr_table_pk_id

259: elsif c.d15 is null then
260: L_TRGR_TABLE_PK_ID:=nh;
261: else
262: L_TRGR_TABLE_PK_ID :=
263: hr_pump_get.get_trgr_table_pk_id
264: (P_TRGR_TABLE_PK_USER_KEY => c.p15);
265: end if;
266: --
267: if c.d16=cn then

Line 273: hr_pump_get.get_enrt_perd_id

269: elsif c.d16 is null then
270: L_ENRT_PERD_ID:=nh;
271: else
272: L_ENRT_PERD_ID :=
273: hr_pump_get.get_enrt_perd_id
274: (P_ENRT_PERD_USER_KEY => c.p16);
275: end if;
276: --
277: if c.d17=cn or

Line 284: hr_pump_get.get_ler_id

280: elsif c.d17 is null then
281: L_LER_ID:=nh;
282: else
283: L_LER_ID :=
284: hr_pump_get.get_ler_id
285: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
286: ,P_LIFE_EVENT_REASON => c.p17
287: ,P_EFFECTIVE_DATE => c.p12);
288: end if;

Line 296: hr_pump_get.get_person_id

292: elsif c.d18 is null then
293: L_PERSON_ID:=nh;
294: else
295: L_PERSON_ID :=
296: hr_pump_get.get_person_id
297: (P_PERSON_USER_KEY => c.p18);
298: end if;
299: --
300: L_REQUEST_ID :=

Line 301: hr_pump_get.get_request_id;

297: (P_PERSON_USER_KEY => c.p18);
298: end if;
299: --
300: L_REQUEST_ID :=
301: hr_pump_get.get_request_id;
302: --
303: L_PROGRAM_APPLICATION_ID :=
304: hr_pump_get.get_program_application_id;
305: --

Line 304: hr_pump_get.get_program_application_id;

300: L_REQUEST_ID :=
301: hr_pump_get.get_request_id;
302: --
303: L_PROGRAM_APPLICATION_ID :=
304: hr_pump_get.get_program_application_id;
305: --
306: L_PROGRAM_ID :=
307: hr_pump_get.get_program_id;
308: --

Line 307: hr_pump_get.get_program_id;

303: L_PROGRAM_APPLICATION_ID :=
304: hr_pump_get.get_program_application_id;
305: --
306: L_PROGRAM_ID :=
307: hr_pump_get.get_program_id;
308: --
309: if c.p13 is null then
310: L_OBJECT_VERSION_NUMBER:=nn;
311: else

Line 313: hr_pump_get.GET_PTNL_LER_FOR_PER_OVN

309: if c.p13 is null then
310: L_OBJECT_VERSION_NUMBER:=nn;
311: else
312: L_OBJECT_VERSION_NUMBER :=
313: hr_pump_get.GET_PTNL_LER_FOR_PER_OVN
314: (P_PTNL_LER_FOR_PER_USER_KEY => c.p13);
315: end if;
316: --
317: hr_data_pump.api_trc_on;