APPS.ITG_SETUP dependencies on HR_LOCATIONS_ALL

Line 17: -- HR_LOCATIONS_ALL table. This is required for the ITG XMLGateway trading partner setup.

13: -- This procedure does the setup required for ITG
14: -- i) Setup default TP location in HR_LOCATIONS
15: -- ii) Setup XMLGateway trading partner definition
16: -- iii) Enable all the ITG triggers
17: -- HR_LOCATIONS_ALL table. This is required for the ITG XMLGateway trading partner setup.
18: -- Arguments
19: -- x_err_buf => API out result param for concurrent program calls
20: -- x_retcode => API out result param for concurrent program calls
21: -- p_location_code => Should have value 'OIPC Default TP'

Line 146: -- HR_LOCATIONS_ALL table. This is required for the ITG XMLGateway trading partner setup.

142: -- Name
143: -- setup_hr_loc
144: -- Purpose
145: -- This procedure sets up the ITG default trading partner information (OIPC Default TP) in the
146: -- HR_LOCATIONS_ALL table. This is required for the ITG XMLGateway trading partner setup.
147: -- Arguments
148: -- x_err_buf => API param for concurrent program calls
149: -- x_retcode => API param for concurrent program calls
150: -- p_location_code => Should have value 'OIPC Default TP'

Line 394: -- The given location code should already be present in HR_Locations_all

390: -- x_err_buf => API param for concurrent program calls
391: -- x_retcode => API param for concurrent program calls
392: -- p_location_code => location code for which TP setup is defined
393: -- Notes
394: -- The given location code should already be present in HR_Locations_all
395: PROCEDURE setup_ecx_tp_header(
396: x_errbuf OUT NOCOPY VARCHAR2,
397: x_retcode OUT NOCOPY VARCHAR2,
398: x_tp_hdr_id OUT NOCOPY NUMBER,

Line 434: FROM hr_locations_all

430: END IF;
431:
432: SELECT location_id
433: INTO l_loc_id
434: FROM hr_locations_all
435: WHERE location_code = p_location_code;
436:
437: IF (l_Debug_Level <= 1 ) THEN
438: itg_debug_pub.Add('Obtained location id - ' || l_loc_id,1);