DBA Data[Home] [Help]

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: l.plongval plongval,
271: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
272: l.pval008 d8,

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

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

Line 392: hr_pump_get.get_address_id

388: if c.p44 is null then
389: L_ADDRESS_ID:=nn;
390: else
391: L_ADDRESS_ID :=
392: hr_pump_get.get_address_id
393: (P_ADDRESS_USER_KEY => c.p44);
394: end if;
395: --
396: if c.p44 is null or

Line 401: hr_pump_get.GET_ADR_OVN

397: c.p1 is null then
398: L_OBJECT_VERSION_NUMBER:=nn;
399: else
400: L_OBJECT_VERSION_NUMBER :=
401: hr_pump_get.GET_ADR_OVN
402: (P_ADDRESS_USER_KEY => c.p44
403: ,P_EFFECTIVE_DATE => c.p1);
404: end if;
405: --

Line 412: hr_pump_get.GET_COUNTRY

408: elsif c.d45 is null then
409: L_COUNTRY:=vh;
410: else
411: L_COUNTRY :=
412: hr_pump_get.GET_COUNTRY
413: (P_COUNTRY => c.p45);
414: end if;
415: --
416: hr_data_pump.api_trc_on;