APPS.HRDPP_UPDATE_ELIG_CVRD_DPNT dependencies on HR_PUMP_GET

Line 263: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval040),vn)) p5,

259: l.pval003 d3,
260: decode(l.pval004,cn,dn,vn,dh,d(l.pval004)) p4,
261: l.pval004 d4,
262: decode(l.pval005,cn,vn,vn,vh,
263: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval040),vn)) p5,
264: l.pval005 d5,
265: decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,
266: l.pval006 d6,
267: decode(l.pval007,cn,vn,vn,vh,l.pval007) p7,

Line 330: hr_pump_get.gl(l.pval038,'YES_NO',d(l.pval040),vn)) p38,

326: l.pval036 d36,
327: decode(l.pval037,cn,dn,vn,dh,d(l.pval037)) p37,
328: l.pval037 d37,
329: decode(l.pval038,cn,vn,vn,vh,
330: hr_pump_get.gl(l.pval038,'YES_NO',d(l.pval040),vn)) p38,
331: l.pval038 d38,
332: decode(l.pval039,cn,dn,vn,dh,d(l.pval039)) p39,
333: l.pval039 d39,
334: decode(l.pval040,cn,dn,d(l.pval040)) p40,

Line 389: hr_pump_get.get_elig_cvrd_dpnt_id

385: if c.p43 is null then
386: L_ELIG_CVRD_DPNT_ID:=nn;
387: else
388: L_ELIG_CVRD_DPNT_ID :=
389: hr_pump_get.get_elig_cvrd_dpnt_id
390: (P_ELIG_CVRD_DPNT_USER_KEY => c.p43);
391: end if;
392: --
393: if c.d44=cn then

Line 399: hr_pump_get.get_prtt_enrt_rslt_id

395: elsif c.d44 is null then
396: L_PRTT_ENRT_RSLT_ID:=nh;
397: else
398: L_PRTT_ENRT_RSLT_ID :=
399: hr_pump_get.get_prtt_enrt_rslt_id
400: (P_PRTT_ENRT_RSLT_USER_KEY => c.p44);
401: end if;
402: --
403: if c.d45=cn then

Line 409: hr_pump_get.get_dpnt_person_id

405: elsif c.d45 is null then
406: L_DPNT_PERSON_ID:=nh;
407: else
408: L_DPNT_PERSON_ID :=
409: hr_pump_get.get_dpnt_person_id
410: (P_DPNT_PERSON_USER_KEY => c.p45);
411: end if;
412: --
413: L_REQUEST_ID :=

Line 414: hr_pump_get.get_request_id;

410: (P_DPNT_PERSON_USER_KEY => c.p45);
411: end if;
412: --
413: L_REQUEST_ID :=
414: hr_pump_get.get_request_id;
415: --
416: L_PROGRAM_APPLICATION_ID :=
417: hr_pump_get.get_program_application_id;
418: --

Line 417: hr_pump_get.get_program_application_id;

413: L_REQUEST_ID :=
414: hr_pump_get.get_request_id;
415: --
416: L_PROGRAM_APPLICATION_ID :=
417: hr_pump_get.get_program_application_id;
418: --
419: L_PROGRAM_ID :=
420: hr_pump_get.get_program_id;
421: --

Line 420: hr_pump_get.get_program_id;

416: L_PROGRAM_APPLICATION_ID :=
417: hr_pump_get.get_program_application_id;
418: --
419: L_PROGRAM_ID :=
420: hr_pump_get.get_program_id;
421: --
422: if c.p43 is null or
423: c.p40 is null then
424: L_OBJECT_VERSION_NUMBER:=nn;

Line 427: hr_pump_get.GET_ELIG_CVRD_DPNT_OVN

423: c.p40 is null then
424: L_OBJECT_VERSION_NUMBER:=nn;
425: else
426: L_OBJECT_VERSION_NUMBER :=
427: hr_pump_get.GET_ELIG_CVRD_DPNT_OVN
428: (P_ELIG_CVRD_DPNT_USER_KEY => c.p43
429: ,P_EFFECTIVE_DATE => c.p40);
430: end if;
431: --

Line 438: hr_pump_get.get_per_in_ler_id

434: elsif c.d46 is null then
435: L_PER_IN_LER_ID:=nh;
436: else
437: L_PER_IN_LER_ID :=
438: hr_pump_get.get_per_in_ler_id
439: (P_PER_IN_LER_USER_KEY => c.p46);
440: end if;
441: --
442: hr_data_pump.api_trc_on;