APPS.HRDPP_UPDATE_MX_LOC_PERSON_ADD dependencies on HR_PUMP_GET

Line 261: hr_pump_get.gl(l.pval005,'ADDRESS_TYPE',d(l.pval001),vn)) p5,

257: l.pval003 d3,
258: decode(l.pval004,cn,vn,vn,vh,l.pval004) p4,
259: l.pval004 d4,
260: decode(l.pval005,cn,vn,vn,vh,
261: hr_pump_get.gl(l.pval005,'ADDRESS_TYPE',d(l.pval001),vn)) p5,
262: l.pval005 d5,
263: decode(l.pval006,cn,vn,vn,null,l.pval006) p6,
264: l.pval006 d6,
265: decode(l.pval007,cn,vn,vn,vh,l.pval007) p7,

Line 276: hr_pump_get.gl(l.pval012,'PER_MX_STATE_CODES',d(l.pval001),vn)) p12,

272: l.pval010 d10,
273: decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
274: l.pval011 d11,
275: decode(l.pval012,cn,vn,vn,vh,
276: hr_pump_get.gl(l.pval012,'PER_MX_STATE_CODES',d(l.pval001),vn)) p12,
277: l.pval012 d12,
278: decode(l.pval013,cn,vn,vn,vh,l.pval013) p13,
279: l.pval013 d13,
280: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,

Line 370: hr_pump_get.get_address_id

366: if c.p45 is null then
367: L_ADDRESS_ID:=nn;
368: else
369: L_ADDRESS_ID :=
370: hr_pump_get.get_address_id
371: (P_ADDRESS_USER_KEY => c.p45);
372: end if;
373: --
374: if c.p45 is null or

Line 379: hr_pump_get.GET_ADR_OVN

375: c.p1 is null then
376: L_OBJECT_VERSION_NUMBER:=nn;
377: else
378: L_OBJECT_VERSION_NUMBER :=
379: hr_pump_get.GET_ADR_OVN
380: (P_ADDRESS_USER_KEY => c.p45
381: ,P_EFFECTIVE_DATE => c.p1);
382: end if;
383: --

Line 390: hr_pump_get.GET_COUNTRY

386: elsif c.d46 is null then
387: L_COUNTRY:=vh;
388: else
389: L_COUNTRY :=
390: hr_pump_get.GET_COUNTRY
391: (P_COUNTRY => c.p46);
392: end if;
393: --
394: hr_data_pump.api_trc_on;