61: --
62: --
63: --
64: --
65: -- Insert the row into: hr_all_positions_f_tl
66: --
67: insert into hr_all_positions_f_tl
68: (position_id
69: ,language
63: --
64: --
65: -- Insert the row into: hr_all_positions_f_tl
66: --
67: insert into hr_all_positions_f_tl
68: (position_id
69: ,language
70: ,source_lang
71: ,name
210: --
211: when hr_api.cannot_find_prog_unit then
212: --
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'HR_ALL_POSITIONS_F_TL'
215: ,p_hook_type => 'AI');
216: --
217: end;
218: --
322: select l.language_code
323: from fnd_languages l
324: where l.installed_flag in ('I','B')
325: and not exists (select null
326: from hr_all_positions_f_tl pft
327: where pft.position_id = p_position_id
328: and pft.language = l.language_code);
329: --
330: l_proc varchar2(72) := g_package || 'ins_tl';