DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_GB_PERSON_ADDRESS dependencies on HR_PUMP_GET

Line 252: hr_pump_get.gl(l.pval004,'ADDRESS_TYPE',d(l.pval001),vn)) p4,

248: l.pval002 d2,
249: decode(l.pval003,cn,dn,vn,dh,d(l.pval003)) p3,
250: l.pval003 d3,
251: decode(l.pval004,cn,vn,vn,vh,
252: hr_pump_get.gl(l.pval004,'ADDRESS_TYPE',d(l.pval001),vn)) p4,
253: l.pval004 d4,
254: decode(l.pval005,cn,vn,vn,null,l.pval005) p5,
255: l.pval005 d5,
256: decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,

Line 265: hr_pump_get.gl(l.pval010,'GB_COUNTY',d(l.pval001),vn)) p10,

261: l.pval008 d8,
262: decode(l.pval009,cn,vn,vn,vh,l.pval009) p9,
263: l.pval009 d9,
264: decode(l.pval010,cn,vn,vn,vh,
265: hr_pump_get.gl(l.pval010,'GB_COUNTY',d(l.pval001),vn)) p10,
266: l.pval010 d10,
267: decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
268: l.pval011 d11,
269: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,

Line 359: hr_pump_get.get_address_id

355: if c.p43 is null then
356: L_ADDRESS_ID:=nn;
357: else
358: L_ADDRESS_ID :=
359: hr_pump_get.get_address_id
360: (P_ADDRESS_USER_KEY => c.p43);
361: end if;
362: --
363: if c.p43 is null or

Line 368: hr_pump_get.GET_ADR_OVN

364: c.p1 is null then
365: L_OBJECT_VERSION_NUMBER:=nn;
366: else
367: L_OBJECT_VERSION_NUMBER :=
368: hr_pump_get.GET_ADR_OVN
369: (P_ADDRESS_USER_KEY => c.p43
370: ,P_EFFECTIVE_DATE => c.p1);
371: end if;
372: --

Line 379: hr_pump_get.GET_COUNTRY

375: elsif c.d44 is null then
376: L_COUNTRY:=vh;
377: else
378: L_COUNTRY :=
379: hr_pump_get.GET_COUNTRY
380: (P_COUNTRY => c.p44);
381: end if;
382: --
383: hr_data_pump.api_trc_on;