APPS.HRDPP_CREATE_SUPPLEMENTARY_ROL dependencies on HR_PUMP_GET

Line 284: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval001),l.pval056)) p5,

280: l.pval003 d3,
281: decode(l.pval004,cn,dn,vn,dn,d(l.pval004)) p4,
282: l.pval004 d4,
283: decode(l.pval005,cn,vn,vn,vn,
284: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval001),l.pval056)) p5,
285: l.pval005 d5,
286: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
287: l.pval006 d6,
288: decode(l.pval007,cn,vn,vn,vn,

Line 289: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval001),l.pval056)) p7,

285: l.pval005 d5,
286: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
287: l.pval006 d6,
288: decode(l.pval007,cn,vn,vn,vn,
289: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval001),l.pval056)) p7,
290: l.pval007 d7,
291: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
292: l.pval008 d8,
293: decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,

Line 412: hr_pump_get.get_job_id

408: c.p1 is null then
409: L_JOB_ID:=nn;
410: else
411: L_JOB_ID :=
412: hr_pump_get.get_job_id
413: (P_JOB_NAME => c.p52
414: ,P_EFFECTIVE_DATE => c.p1
415: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
416: end if;

Line 422: hr_pump_get.get_job_group_id

418: if c.p53 is null then
419: L_JOB_GROUP_ID:=nn;
420: else
421: L_JOB_GROUP_ID :=
422: hr_pump_get.get_job_group_id
423: (P_JOB_GROUP_USER_KEY => c.p53);
424: end if;
425: --
426: if c.p54 is null then

Line 430: hr_pump_get.get_person_id

426: if c.p54 is null then
427: L_PERSON_ID:=nn;
428: else
429: L_PERSON_ID :=
430: hr_pump_get.get_person_id
431: (P_PERSON_USER_KEY => c.p54);
432: end if;
433: --
434: if c.p55 is null or

Line 440: hr_pump_get.get_organization_id

436: c.p56 is null then
437: L_ORGANIZATION_ID:=nn;
438: else
439: L_ORGANIZATION_ID :=
440: hr_pump_get.get_organization_id
441: (P_ORGANIZATION_NAME => c.p55
442: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
443: ,P_EFFECTIVE_DATE => c.p1
444: ,P_LANGUAGE_CODE => c.p56);