48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: -- Delete the hr_locations_all_tl row.
53: --
54: delete from hr_locations_all_tl
55: where location_id = p_rec.location_id
56: and language = p_rec.language;
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: -- Delete the hr_locations_all_tl row.
53: --
54: delete from hr_locations_all_tl
55: where location_id = p_rec.location_id
56: and language = p_rec.language;
57: --
58: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: --
166: when hr_api.cannot_find_prog_unit then
167: --
168: hr_api.cannot_find_prog_unit_error
169: (p_module_name => 'HR_LOCATIONS_ALL_TL'
170: ,p_hook_type => 'AD');
171: --
172: end;
173: --
260: -- Cursor to obtain all the translation rows.
261: --
262: cursor csr_del_langs is
263: select lot.language
264: from hr_locations_all_tl lot
265: where lot.location_id = p_location_id;
266: --
267: l_proc varchar2(72) := g_package||'del_tl';
268: l_deleted_anything boolean := false;