DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_IN_LOCATION dependencies on HR_PUMP_GET

Line 334: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),l.pval002)) p10,

330: l.pval008 d8,
331: decode(l.pval009,cn,vn,vn,vh,l.pval009) p9,
332: l.pval009 d9,
333: decode(l.pval010,cn,vn,vn,vh,
334: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),l.pval002)) p10,
335: l.pval010 d10,
336: decode(l.pval011,cn,vn,vn,vh,
337: hr_pump_get.gl(l.pval011,'YES_NO',d(l.pval001),l.pval002)) p11,
338: l.pval011 d11,

Line 337: hr_pump_get.gl(l.pval011,'YES_NO',d(l.pval001),l.pval002)) p11,

333: decode(l.pval010,cn,vn,vn,vh,
334: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),l.pval002)) p10,
335: l.pval010 d10,
336: decode(l.pval011,cn,vn,vn,vh,
337: hr_pump_get.gl(l.pval011,'YES_NO',d(l.pval001),l.pval002)) p11,
338: l.pval011 d11,
339: decode(l.pval012,cn,dn,vn,dh,d(l.pval012)) p12,
340: l.pval012 d12,
341: decode(l.pval013,cn,vn,vn,vh,

Line 342: hr_pump_get.gl(l.pval013,'YES_NO',d(l.pval001),l.pval002)) p13,

338: l.pval011 d11,
339: decode(l.pval012,cn,dn,vn,dh,d(l.pval012)) p12,
340: l.pval012 d12,
341: decode(l.pval013,cn,vn,vn,vh,
342: hr_pump_get.gl(l.pval013,'YES_NO',d(l.pval001),l.pval002)) p13,
343: l.pval013 d13,
344: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
345: l.pval014 d14,
346: decode(l.pval015,cn,vn,vn,vh,

Line 347: hr_pump_get.gl(l.pval015,'YES_NO',d(l.pval001),l.pval002)) p15,

343: l.pval013 d13,
344: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
345: l.pval014 d14,
346: decode(l.pval015,cn,vn,vn,vh,
347: hr_pump_get.gl(l.pval015,'YES_NO',d(l.pval001),l.pval002)) p15,
348: l.pval015 d15,
349: decode(l.pval016,cn,vn,vn,vh,
350: hr_pump_get.gl(l.pval016,'YES_NO',d(l.pval001),l.pval002)) p16,
351: l.pval016 d16,

Line 350: hr_pump_get.gl(l.pval016,'YES_NO',d(l.pval001),l.pval002)) p16,

346: decode(l.pval015,cn,vn,vn,vh,
347: hr_pump_get.gl(l.pval015,'YES_NO',d(l.pval001),l.pval002)) p15,
348: l.pval015 d15,
349: decode(l.pval016,cn,vn,vn,vh,
350: hr_pump_get.gl(l.pval016,'YES_NO',d(l.pval001),l.pval002)) p16,
351: l.pval016 d16,
352: decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,
353: l.pval017 d17,
354: decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,

Line 487: hr_pump_get.get_location_id

483: c.p2 is null then
484: L_LOCATION_ID:=nn;
485: else
486: L_LOCATION_ID :=
487: hr_pump_get.get_location_id
488: (P_LOCATION_CODE => c.p3
489: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
490: ,P_LANGUAGE_CODE => c.p2);
491: end if;

Line 502: hr_pump_get.GET_COUNTRY

498: elsif c.d67 is null then
499: L_COUNTRY:=vh;
500: else
501: L_COUNTRY :=
502: hr_pump_get.GET_COUNTRY
503: (P_COUNTRY => c.p67);
504: end if;
505: --
506: L_DESIGNATED_RECEIVER_ID :=

Line 529: hr_pump_get.GET_LOC_OVN

525: if c.p3 is null then
526: L_OBJECT_VERSION_NUMBER:=nn;
527: else
528: L_OBJECT_VERSION_NUMBER :=
529: hr_pump_get.GET_LOC_OVN
530: (P_LOCATION_CODE => c.p3);
531: end if;
532: --
533: hr_data_pump.api_trc_on;