82: --
83: --
84: --
85: --
86: -- Insert the row into: hr_all_organization_units_tl
87: --
88: insert into hr_all_organization_units_tl
89: (organization_id
90: ,language
84: --
85: --
86: -- Insert the row into: hr_all_organization_units_tl
87: --
88: insert into hr_all_organization_units_tl
89: (organization_id
90: ,language
91: ,source_lang
92: ,name
231: --
232: when hr_api.cannot_find_prog_unit then
233: --
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'HR_ALL_ORGANIZATION_UNITS_TL'
236: ,p_hook_type => 'AI');
237: --
238: end;
239: --
337: select l.language_code
338: from fnd_languages l
339: where l.installed_flag in ('I','B')
340: and not exists (select null
341: from hr_all_organization_units_tl ort
342: where ort.organization_id = p_organization_id
343: and ort.language = l.language_code);
344: --
345: l_proc varchar2(72) := g_package || 'ins_tl';