DBA Data[Home] [Help]

APPS.HRDPP_CREATE_GB_PERSON_ADDRESS dependencies on HR_PUMP_GET

Line 268: hr_pump_get.gl(l.pval003,'YES_NO',d(l.pval001),vn)) p3,

264: decode(l.pval001,cn,dn,d(l.pval001)) p1,
265: decode(l.pval002,cn,vn,vn,null,l.pval002) p2,
266: l.pval002 d2,
267: decode(l.pval003,cn,vn,
268: hr_pump_get.gl(l.pval003,'YES_NO',d(l.pval001),vn)) p3,
269: decode(l.pval004,cn,dn,d(l.pval004)) p4,
270: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
271: l.pval005 d5,
272: decode(l.pval006,cn,vn,vn,vn,

Line 273: hr_pump_get.gl(l.pval006,'ADDRESS_TYPE',d(l.pval001),vn)) p6,

269: decode(l.pval004,cn,dn,d(l.pval004)) p4,
270: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
271: l.pval005 d5,
272: decode(l.pval006,cn,vn,vn,vn,
273: hr_pump_get.gl(l.pval006,'ADDRESS_TYPE',d(l.pval001),vn)) p6,
274: l.pval006 d6,
275: l.plongval plongval,
276: decode(l.pval008,cn,vn,l.pval008) p8,
277: decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,

Line 284: hr_pump_get.gl(l.pval012,'GB_COUNTY',d(l.pval001),vn)) p12,

280: l.pval010 d10,
281: decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
282: l.pval011 d11,
283: decode(l.pval012,cn,vn,vn,vn,
284: hr_pump_get.gl(l.pval012,'GB_COUNTY',d(l.pval001),vn)) p12,
285: l.pval012 d12,
286: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
287: l.pval013 d13,
288: decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,

Line 402: hr_pump_get.get_person_id

398: if c.p48 is null then
399: L_PERSON_ID:=nn;
400: else
401: L_PERSON_ID :=
402: hr_pump_get.get_person_id
403: (P_PERSON_USER_KEY => c.p48);
404: end if;
405: --
406: if c.p49 is null then

Line 410: hr_pump_get.GET_COUNTRY

406: if c.p49 is null then
407: L_COUNTRY:=vn;
408: else
409: L_COUNTRY :=
410: hr_pump_get.GET_COUNTRY
411: (P_COUNTRY => c.p49);
412: end if;
413: --
414: hr_data_pump.api_trc_on;