58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the hr_ki_topics_tl row.
63: --
64: delete from hr_ki_topics_tl
65: where topic_id = p_rec.topic_id and language = p_rec.language
66: ;
60: --
61: --
62: -- Delete the hr_ki_topics_tl row.
63: --
64: delete from hr_ki_topics_tl
65: where topic_id = p_rec.topic_id and language = p_rec.language
66: ;
67: --
68: --
177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'HR_KI_TOPICS_TL'
182: ,p_hook_type => 'AD');
183: --
184: end;
185: --
271: -- Cursor to obtain all the translation rows.
272: --
273: cursor csr_del_langs is
274: select ttl.language
275: from hr_ki_topics_tl ttl
276: where
277: ttl.topic_id = p_topic_id;
278: --
279: l_proc varchar2(72) := g_package||'del_tl';