APPS.HRDPP_UPDATE_CN_PERSON_ADDRESS dependencies on HR_PUMP_GET

Line 268: hr_pump_get.gl(l.pval006,'ADDRESS_TYPE',d(l.pval001),vn)) p6,

264: l.pval004 d4,
265: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
266: l.pval005 d5,
267: decode(l.pval006,cn,vn,vn,vh,
268: hr_pump_get.gl(l.pval006,'ADDRESS_TYPE',d(l.pval001),vn)) p6,
269: l.pval006 d6,
270: decode(l.pval007,cn,vn,vn,null,l.pval007) p7,
271: l.pval007 d7,
272: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,

Line 277: hr_pump_get.gl(l.pval010,'CN_PROVINCE',d(l.pval001),vn)) p10,

273: l.pval008 d8,
274: decode(l.pval009,cn,vn,vn,vh,l.pval009) p9,
275: l.pval009 d9,
276: decode(l.pval010,cn,vn,vn,vh,
277: hr_pump_get.gl(l.pval010,'CN_PROVINCE',d(l.pval001),vn)) p10,
278: l.pval010 d10,
279: decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
280: l.pval011 d11,
281: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,

Line 387: hr_pump_get.get_address_id

383: if c.p44 is null then
384: L_ADDRESS_ID:=nn;
385: else
386: L_ADDRESS_ID :=
387: hr_pump_get.get_address_id
388: (P_ADDRESS_USER_KEY => c.p44);
389: end if;
390: --
391: if c.p44 is null or

Line 396: hr_pump_get.GET_ADR_OVN

392: c.p1 is null then
393: L_OBJECT_VERSION_NUMBER:=nn;
394: else
395: L_OBJECT_VERSION_NUMBER :=
396: hr_pump_get.GET_ADR_OVN
397: (P_ADDRESS_USER_KEY => c.p44
398: ,P_EFFECTIVE_DATE => c.p1);
399: end if;
400: --

Line 407: hr_pump_get.GET_COUNTRY

403: elsif c.d45 is null then
404: L_COUNTRY:=vh;
405: else
406: L_COUNTRY :=
407: hr_pump_get.GET_COUNTRY
408: (P_COUNTRY => c.p45);
409: end if;
410: --
411: hr_data_pump.api_trc_on;