DBA Data[Home] [Help]

APPS.HR_LOC_INS dependencies on HR_LOCATIONS_ALL

Line 84: -- Insert the row into: hr_locations_all

80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: hr_loc_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: hr_locations_all
85: --
86: INSERT INTO hr_locations_all
87: ( location_id,
88: entered_by,

Line 86: INSERT INTO hr_locations_all

82: hr_loc_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: hr_locations_all
85: --
86: INSERT INTO hr_locations_all
87: ( location_id,
88: entered_by,
89: location_code,
90: timezone_code,

Line 339: -- Select the next sequence number for hr_locations_all.location_id:

335: BEGIN
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: --
339: -- Select the next sequence number for hr_locations_all.location_id:
340: --
341: OPEN csr_next_location_id;
342: FETCH csr_next_location_id INTO p_rec.location_id;
343: CLOSE csr_next_location_id;

Line 524: (p_module_name => 'HR_LOCATIONS_ALL'

520: );
521: EXCEPTION
522: WHEN hr_api.cannot_find_prog_unit THEN
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'HR_LOCATIONS_ALL'
525: ,p_hook_type => 'AI'
526: );
527: --
528: -- End of API User Hook for the before hook of create_location