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: decode(l.pval007,cn,vn,vn,null,l.pval007) p7,
276: l.pval007 d7,
277: decode(l.pval008,cn,vn,l.pval008) p8,

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

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

Line 397: hr_pump_get.get_person_id

393: if c.p48 is null then
394: L_PERSON_ID:=nn;
395: else
396: L_PERSON_ID :=
397: hr_pump_get.get_person_id
398: (P_PERSON_USER_KEY => c.p48);
399: end if;
400: --
401: if c.p49 is null then

Line 405: hr_pump_get.GET_COUNTRY

401: if c.p49 is null then
402: L_COUNTRY:=vn;
403: else
404: L_COUNTRY :=
405: hr_pump_get.GET_COUNTRY
406: (P_COUNTRY => c.p49);
407: end if;
408: --
409: hr_data_pump.api_trc_on;