APPS.M4U_SETUP_PACKAGE dependencies on HR_LOCATIONS

Line 340: -- i) Setup default TP location in HR_LOCATIONS

336: -- SETUP
337: -- Purpose
338: -- This procedure is called from a concurrent program(can be called from anywhere actually).
339: -- This procedure does the setup required for m4u
340: -- i) Setup default TP location in HR_LOCATIONS
341: -- ii) Setup XMLGateway trading partner definition
342: -- Arguments
343: -- x_err_buf => API out result param for concurrent program calls
344: -- x_retcode => API out result param for concurrent program calls

Line 353: -- All the input arguments are used in the call to setup_hr_locations

349: -- p_region_2 => Some region 2 (State)
350: -- p_town_or_city => Some city
351: -- p_postal_code => Some postal code
352: -- Notes
353: -- All the input arguments are used in the call to setup_hr_locations
354: -- The concurrent program will be failed in case of any error
355: -- All arguments are moved into the code
356: PROCEDURE SETUP(
357: x_errbuf OUT NOCOPY VARCHAR2,

Line 405: -- Setup HR Locations

401: IF (l_Debug_Level <= 1) THEN
402: cln_debug_pub.Add('+++++++++ Check HR Location Values in DB +++++++++', 1);
403: END IF;
404:
405: -- Setup HR Locations
406: -- Check if record exists. Create Locations if it does not else Update Location value
407: BEGIN
408: SELECT location_id, object_version_number
409: INTO l_location_id, l_obj_ver_num

Line 410: FROM hr_locations_all

406: -- Check if record exists. Create Locations if it does not else Update Location value
407: BEGIN
408: SELECT location_id, object_version_number
409: INTO l_location_id, l_obj_ver_num
410: FROM hr_locations_all
411: WHERE location_code = l_location_code;
412:
413: l_record_found := TRUE;
414:

Line 436: FROM hr_locations

432: END IF;
433:
434: SELECT location_id, object_version_number
435: INTO l_location_id, l_obj_ver_num
436: FROM hr_locations
437: WHERE location_code = l_location_code
438: AND ROWNUM < 2;
439:
440: l_record_found := TRUE;