DBA Data[Home] [Help]

APPS.HRDPP_CREATE_PERSON_ADDRESS dependencies on HR_PUMP_GET

Line 293: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),vn)) p4,

289: l.pval002 d2,
290: decode(l.pval003,cn,vn,vn,null,l.pval003) p3,
291: l.pval003 d3,
292: decode(l.pval004,cn,vn,
293: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),vn)) p4,
294: decode(l.pval005,cn,vn,l.pval005) p5,
295: decode(l.pval006,cn,dn,d(l.pval006)) p6,
296: decode(l.pval007,cn,dn,vn,dn,d(l.pval007)) p7,
297: l.pval007 d7,

Line 299: hr_pump_get.gl(l.pval008,'ADDRESS_TYPE',d(l.pval001),vn)) p8,

295: decode(l.pval006,cn,dn,d(l.pval006)) p6,
296: decode(l.pval007,cn,dn,vn,dn,d(l.pval007)) p7,
297: l.pval007 d7,
298: decode(l.pval008,cn,vn,vn,vn,
299: hr_pump_get.gl(l.pval008,'ADDRESS_TYPE',d(l.pval001),vn)) p8,
300: l.pval008 d8,
301: decode(l.pval009,cn,vn,vn,null,l.pval009) p9,
302: l.pval009 d9,
303: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,

Line 444: hr_pump_get.get_person_id

440: if c.p53 is null then
441: L_PERSON_ID:=nn;
442: else
443: L_PERSON_ID :=
444: hr_pump_get.get_person_id
445: (P_PERSON_USER_KEY => c.p53);
446: end if;
447: --
448: if c.p54 is null then

Line 452: hr_pump_get.GET_COUNTRY

448: if c.p54 is null then
449: L_COUNTRY:=vn;
450: else
451: L_COUNTRY :=
452: hr_pump_get.GET_COUNTRY
453: (P_COUNTRY => c.p54);
454: end if;
455: --
456: hr_data_pump.api_trc_on;