DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_PERSON_ADDRESS dependencies on HR_PUMP_GET

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

279: l.pval004 d4,
280: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
281: l.pval005 d5,
282: decode(l.pval006,cn,vn,vn,vh,
283: hr_pump_get.gl(l.pval006,'ADDRESS_TYPE',d(l.pval001),vn)) p6,
284: l.pval006 d6,
285: decode(l.pval007,cn,vn,vn,null,l.pval007) p7,
286: l.pval007 d7,
287: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,

Line 411: hr_pump_get.get_address_id

407: if c.p49 is null then
408: L_ADDRESS_ID:=nn;
409: else
410: L_ADDRESS_ID :=
411: hr_pump_get.get_address_id
412: (P_ADDRESS_USER_KEY => c.p49);
413: end if;
414: --
415: if c.p49 is null or

Line 420: hr_pump_get.GET_ADR_OVN

416: c.p1 is null then
417: L_OBJECT_VERSION_NUMBER:=nn;
418: else
419: L_OBJECT_VERSION_NUMBER :=
420: hr_pump_get.GET_ADR_OVN
421: (P_ADDRESS_USER_KEY => c.p49
422: ,P_EFFECTIVE_DATE => c.p1);
423: end if;
424: --

Line 431: hr_pump_get.GET_COUNTRY

427: elsif c.d50 is null then
428: L_COUNTRY:=vh;
429: else
430: L_COUNTRY :=
431: hr_pump_get.GET_COUNTRY
432: (P_COUNTRY => c.p50);
433: end if;
434: --
435: hr_data_pump.api_trc_on;