DBA Data[Home] [Help]

APPS.HR_LOC_INS dependencies on HR_LOCATIONS_ALL

Line 85: -- Insert the row into: hr_locations_all

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

Line 88: INSERT INTO hr_locations_all

84: --
85: -- Insert the row into: hr_locations_all
86: --
87:
88: INSERT INTO hr_locations_all
89: ( location_id,
90: entered_by,
91: location_code,
92: timezone_code,

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

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

Line 526: (p_module_name => 'HR_LOCATIONS_ALL'

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