APPS.HRDPP_UPDATE_ELIG_DPNT dependencies on HR_PUMP_GET

Line 265: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval040),vn)) p4,

261: l.pval002 d2,
262: decode(l.pval003,cn,dn,vn,dh,d(l.pval003)) p3,
263: l.pval003 d3,
264: decode(l.pval004,cn,vn,vn,vh,
265: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval040),vn)) p4,
266: l.pval004 d4,
267: decode(l.pval005,cn,dn,vn,dh,d(l.pval005)) p5,
268: l.pval005 d5,
269: decode(l.pval006,cn,vn,vn,vh,

Line 270: hr_pump_get.gl(l.pval006,'BEN_INELG_RSN',d(l.pval040),vn)) p6,

266: l.pval004 d4,
267: decode(l.pval005,cn,dn,vn,dh,d(l.pval005)) p5,
268: l.pval005 d5,
269: decode(l.pval006,cn,vn,vn,vh,
270: hr_pump_get.gl(l.pval006,'BEN_INELG_RSN',d(l.pval040),vn)) p6,
271: l.pval006 d6,
272: decode(l.pval007,cn,vn,vn,vh,
273: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval040),vn)) p7,
274: l.pval007 d7,

Line 273: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval040),vn)) p7,

269: decode(l.pval006,cn,vn,vn,vh,
270: hr_pump_get.gl(l.pval006,'BEN_INELG_RSN',d(l.pval040),vn)) p6,
271: l.pval006 d6,
272: decode(l.pval007,cn,vn,vn,vh,
273: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval040),vn)) p7,
274: l.pval007 d7,
275: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
276: l.pval008 d8,
277: decode(l.pval009,cn,vn,vn,vh,l.pval009) p9,

Line 386: hr_pump_get.get_elig_dpnt_id

382: if c.p41 is null then
383: L_ELIG_DPNT_ID:=nn;
384: else
385: L_ELIG_DPNT_ID :=
386: hr_pump_get.get_elig_dpnt_id
387: (P_ELIG_DPNT_USER_KEY => c.p41);
388: end if;
389: --
390: if c.d42=cn then

Line 396: hr_pump_get.get_elig_per_elctbl_chc_id

392: elsif c.d42 is null then
393: L_ELIG_PER_ELCTBL_CHC_ID:=nh;
394: else
395: L_ELIG_PER_ELCTBL_CHC_ID :=
396: hr_pump_get.get_elig_per_elctbl_chc_id
397: (P_ELIG_PER_ELCTBL_CHC_USER_KEY => c.p42);
398: end if;
399: --
400: if c.d43=cn then

Line 406: hr_pump_get.get_per_in_ler_id

402: elsif c.d43 is null then
403: L_PER_IN_LER_ID:=nh;
404: else
405: L_PER_IN_LER_ID :=
406: hr_pump_get.get_per_in_ler_id
407: (P_PER_IN_LER_USER_KEY => c.p43);
408: end if;
409: --
410: if c.d44=cn then

Line 416: hr_pump_get.get_elig_per_id

412: elsif c.d44 is null then
413: L_ELIG_PER_ID:=nh;
414: else
415: L_ELIG_PER_ID :=
416: hr_pump_get.get_elig_per_id
417: (P_ELIG_PER_USER_KEY => c.p44);
418: end if;
419: --
420: if c.d45=cn then

Line 426: hr_pump_get.get_elig_per_opt_id

422: elsif c.d45 is null then
423: L_ELIG_PER_OPT_ID:=nh;
424: else
425: L_ELIG_PER_OPT_ID :=
426: hr_pump_get.get_elig_per_opt_id
427: (P_ELIG_PER_OPT_USER_KEY => c.p45);
428: end if;
429: --
430: if c.d46=cn then

Line 436: hr_pump_get.get_elig_cvrd_dpnt_id

432: elsif c.d46 is null then
433: L_ELIG_CVRD_DPNT_ID:=nh;
434: else
435: L_ELIG_CVRD_DPNT_ID :=
436: hr_pump_get.get_elig_cvrd_dpnt_id
437: (P_ELIG_CVRD_DPNT_USER_KEY => c.p46);
438: end if;
439: --
440: if c.d47=cn then

Line 446: hr_pump_get.get_dpnt_person_id

442: elsif c.d47 is null then
443: L_DPNT_PERSON_ID:=nh;
444: else
445: L_DPNT_PERSON_ID :=
446: hr_pump_get.get_dpnt_person_id
447: (P_DPNT_PERSON_USER_KEY => c.p47);
448: end if;
449: --
450: L_REQUEST_ID :=

Line 451: hr_pump_get.get_request_id;

447: (P_DPNT_PERSON_USER_KEY => c.p47);
448: end if;
449: --
450: L_REQUEST_ID :=
451: hr_pump_get.get_request_id;
452: --
453: L_PROGRAM_APPLICATION_ID :=
454: hr_pump_get.get_program_application_id;
455: --

Line 454: hr_pump_get.get_program_application_id;

450: L_REQUEST_ID :=
451: hr_pump_get.get_request_id;
452: --
453: L_PROGRAM_APPLICATION_ID :=
454: hr_pump_get.get_program_application_id;
455: --
456: L_PROGRAM_ID :=
457: hr_pump_get.get_program_id;
458: --

Line 457: hr_pump_get.get_program_id;

453: L_PROGRAM_APPLICATION_ID :=
454: hr_pump_get.get_program_application_id;
455: --
456: L_PROGRAM_ID :=
457: hr_pump_get.get_program_id;
458: --
459: if c.p41 is null then
460: L_OBJECT_VERSION_NUMBER:=nn;
461: else

Line 463: hr_pump_get.GET_ELIG_DPNT_OVN

459: if c.p41 is null then
460: L_OBJECT_VERSION_NUMBER:=nn;
461: else
462: L_OBJECT_VERSION_NUMBER :=
463: hr_pump_get.GET_ELIG_DPNT_OVN
464: (P_ELIG_DPNT_USER_KEY => c.p41);
465: end if;
466: --
467: hr_data_pump.api_trc_on;