61: --
62: --
63: --
64: --
65: -- Insert the row into: hr_ki_option_types_tl
66: --
67: insert into hr_ki_option_types_tl
68: (option_type_id
69: ,option_name
63: --
64: --
65: -- Insert the row into: hr_ki_option_types_tl
66: --
67: insert into hr_ki_option_types_tl
68: (option_type_id
69: ,option_name
70: ,language
71: ,source_lang
211: --
212: when hr_api.cannot_find_prog_unit then
213: --
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'HR_KI_OPTION_TYPES_TL'
216: ,p_hook_type => 'AI');
217: --
218: end;
219: --
324: select l.language_code
325: from fnd_languages l
326: where l.installed_flag in ('I','B')
327: and not exists (select null
328: from hr_ki_option_types_tl ott
329: where
330: ott.option_type_id = p_option_type_id
331: and ott.language = l.language_code);
332: --