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