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: l.plongval plongval,
255: decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,
256: l.pval006 d6,

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

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

Line 364: hr_pump_get.get_address_id

360: if c.p43 is null then
361: L_ADDRESS_ID:=nn;
362: else
363: L_ADDRESS_ID :=
364: hr_pump_get.get_address_id
365: (P_ADDRESS_USER_KEY => c.p43);
366: end if;
367: --
368: if c.p43 is null or

Line 373: hr_pump_get.GET_ADR_OVN

369: c.p1 is null then
370: L_OBJECT_VERSION_NUMBER:=nn;
371: else
372: L_OBJECT_VERSION_NUMBER :=
373: hr_pump_get.GET_ADR_OVN
374: (P_ADDRESS_USER_KEY => c.p43
375: ,P_EFFECTIVE_DATE => c.p1);
376: end if;
377: --

Line 384: hr_pump_get.GET_COUNTRY

380: elsif c.d44 is null then
381: L_COUNTRY:=vh;
382: else
383: L_COUNTRY :=
384: hr_pump_get.GET_COUNTRY
385: (P_COUNTRY => c.p44);
386: end if;
387: --
388: hr_data_pump.api_trc_on;