APPS.HRDPP_UPDATE_IN_PERSON_ADDRESS dependencies on HR_PUMP_GET

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

221: l.pval002 d2,
222: decode(l.pval003,cn,dn,vn,dh,d(l.pval003)) p3,
223: l.pval003 d3,
224: decode(l.pval004,cn,vn,vn,vh,
225: hr_pump_get.gl(l.pval004,'ADDRESS_TYPE',d(l.pval001),vn)) p4,
226: l.pval004 d4,
227: l.plongval plongval,
228: decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,
229: l.pval006 d6,

Line 239: hr_pump_get.gl(l.pval011,'IN_STATES',d(l.pval001),vn)) p11,

235: l.pval009 d9,
236: decode(l.pval010,cn,vn,vn,vh,l.pval010) p10,
237: l.pval010 d10,
238: decode(l.pval011,cn,vn,vn,vh,
239: hr_pump_get.gl(l.pval011,'IN_STATES',d(l.pval001),vn)) p11,
240: l.pval011 d11,
241: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
242: l.pval012 d12,
243: decode(l.pval013,cn,vn,vn,vh,l.pval013) p13,

Line 319: hr_pump_get.get_address_id

315: if c.p34 is null then
316: L_ADDRESS_ID:=nn;
317: else
318: L_ADDRESS_ID :=
319: hr_pump_get.get_address_id
320: (P_ADDRESS_USER_KEY => c.p34);
321: end if;
322: --
323: if c.p34 is null or

Line 328: hr_pump_get.GET_ADR_OVN

324: c.p1 is null then
325: L_OBJECT_VERSION_NUMBER:=nn;
326: else
327: L_OBJECT_VERSION_NUMBER :=
328: hr_pump_get.GET_ADR_OVN
329: (P_ADDRESS_USER_KEY => c.p34
330: ,P_EFFECTIVE_DATE => c.p1);
331: end if;
332: --

Line 339: hr_pump_get.GET_COUNTRY

335: elsif c.d35 is null then
336: L_COUNTRY:=vh;
337: else
338: L_COUNTRY :=
339: hr_pump_get.GET_COUNTRY
340: (P_COUNTRY => c.p35);
341: end if;
342: --
343: hr_data_pump.api_trc_on;