61: --
62: --
63: --
64: --
65: -- Insert the row into: hr_ki_hierarchies_tl
66: --
67: insert into hr_ki_hierarchies_tl
68: (hierarchy_id
69: ,name
63: --
64: --
65: -- Insert the row into: hr_ki_hierarchies_tl
66: --
67: insert into hr_ki_hierarchies_tl
68: (hierarchy_id
69: ,name
70: ,description
71: ,language
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'HR_KI_HIERARCHIES_TL'
219: ,p_hook_type => 'AI');
220: --
221: end;
222: --
330: select l.language_code
331: from fnd_languages l
332: where l.installed_flag in ('I','B')
333: and not exists (select null
334: from hr_ki_hierarchies_tl htl
335: where
336: htl.hierarchy_id = p_hierarchy_id
337: and htl.language = l.language_code);
338: --