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: l.plongval plongval,
302: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
303: l.pval010 d10,

Line 449: hr_pump_get.get_person_id

445: if c.p53 is null then
446: L_PERSON_ID:=nn;
447: else
448: L_PERSON_ID :=
449: hr_pump_get.get_person_id
450: (P_PERSON_USER_KEY => c.p53);
451: end if;
452: --
453: if c.p54 is null then

Line 457: hr_pump_get.GET_COUNTRY

453: if c.p54 is null then
454: L_COUNTRY:=vn;
455: else
456: L_COUNTRY :=
457: hr_pump_get.GET_COUNTRY
458: (P_COUNTRY => c.p54);
459: end if;
460: --
461: hr_data_pump.api_trc_on;