56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: -- hr_lei_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the hr_location_extra_info row.
61: --
62: delete from hr_location_extra_info
63: where location_extra_info_id = p_rec.location_extra_info_id;
64: --
58: -- hr_lei_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the hr_location_extra_info row.
61: --
62: delete from hr_location_extra_info
63: where location_extra_info_id = p_rec.location_extra_info_id;
64: --
65: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
66: --
224: );
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: ( p_module_name => 'HR_LOCATION_EXTRA_INFO'
229: ,p_hook_type => 'AD'
230: );
231: end;
232: -- End of API User Hook for post_delete.