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,
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,
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;
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