APPS.HRDPP_CREATE_CN_PERSON_ADDRESS dependencies on HR_PUMP_GET

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

271: l.pval002 d2,
272: decode(l.pval003,cn,vn,vn,null,l.pval003) p3,
273: l.pval003 d3,
274: decode(l.pval004,cn,vn,
275: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),vn)) p4,
276: decode(l.pval005,cn,dn,d(l.pval005)) p5,
277: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
278: l.pval006 d6,
279: decode(l.pval007,cn,vn,vn,vn,

Line 280: hr_pump_get.gl(l.pval007,'ADDRESS_TYPE',d(l.pval001),vn)) p7,

276: decode(l.pval005,cn,dn,d(l.pval005)) p5,
277: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
278: l.pval006 d6,
279: decode(l.pval007,cn,vn,vn,vn,
280: hr_pump_get.gl(l.pval007,'ADDRESS_TYPE',d(l.pval001),vn)) p7,
281: l.pval007 d7,
282: l.plongval plongval,
283: decode(l.pval009,cn,vn,l.pval009) p9,
284: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,

Line 417: hr_pump_get.get_person_id

413: if c.p47 is null then
414: L_PERSON_ID:=nn;
415: else
416: L_PERSON_ID :=
417: hr_pump_get.get_person_id
418: (P_PERSON_USER_KEY => c.p47);
419: end if;
420: --
421: if c.p48 is null then

Line 425: hr_pump_get.GET_COUNTRY

421: if c.p48 is null then
422: L_COUNTRY:=vn;
423: else
424: L_COUNTRY :=
425: hr_pump_get.GET_COUNTRY
426: (P_COUNTRY => c.p48);
427: end if;
428: --
429: hr_data_pump.api_trc_on;