APPS.HRDPP_UPDATE_US_PERSON_ADDRESS dependencies on HR_PUMP_GET

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

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

Line 281: hr_pump_get.gl(l.pval011,'US_STATE',d(l.pval001),vn)) p11,

277: l.pval009 d9,
278: decode(l.pval010,cn,vn,vn,vh,l.pval010) p10,
279: l.pval010 d10,
280: decode(l.pval011,cn,vn,vn,vh,
281: hr_pump_get.gl(l.pval011,'US_STATE',d(l.pval001),vn)) p11,
282: l.pval011 d11,
283: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
284: l.pval012 d12,
285: decode(l.pval013,cn,vn,vn,vh,l.pval013) p13,

Line 391: hr_pump_get.get_address_id

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

Line 400: hr_pump_get.GET_ADR_OVN

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

Line 411: hr_pump_get.GET_COUNTRY

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