50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: --
54: -- Insert the row into: hr_locations_all_tl
55: --
56: insert into hr_locations_all_tl
57: ( location_id,
58: language,
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: --
54: -- Insert the row into: hr_locations_all_tl
55: --
56: insert into hr_locations_all_tl
57: ( location_id,
58: language,
59: source_lang,
60: location_code,
195: --
196: when hr_api.cannot_find_prog_unit then
197: --
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'HR_LOCATIONS_ALL_TL'
200: ,p_hook_type => 'AI');
201: --
202: end;
203: --
305: select l.language_code
306: from fnd_languages l
307: where l.installed_flag in ('I', 'B')
308: and not exists (select null
309: from hr_locations_all_tl lot
310: where lot.location_id = p_location_id
311: and lot.language = l.language_code);
312: --
313: --