DBA Data[Home] [Help]

APPS.HR_OTT_DEL dependencies on HR_KI_OPTION_TYPES_TL

Line 62: -- Delete the hr_ki_option_types_tl row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the hr_ki_option_types_tl row.
63: --
64: delete from hr_ki_option_types_tl
65: where option_type_id = p_rec.option_type_id
66: and language = p_rec.language;

Line 64: delete from hr_ki_option_types_tl

60: --
61: --
62: -- Delete the hr_ki_option_types_tl row.
63: --
64: delete from hr_ki_option_types_tl
65: where option_type_id = p_rec.option_type_id
66: and language = p_rec.language;
67: --
68: --

Line 182: (p_module_name => 'HR_KI_OPTION_TYPES_TL'

178: --
179: when hr_api.cannot_find_prog_unit then
180: --
181: hr_api.cannot_find_prog_unit_error
182: (p_module_name => 'HR_KI_OPTION_TYPES_TL'
183: ,p_hook_type => 'AD');
184: --
185: end;
186: --

Line 276: from hr_ki_option_types_tl ott

272: -- Cursor to obtain all the translation rows.
273: --
274: cursor csr_del_langs is
275: select ott.language
276: from hr_ki_option_types_tl ott
277: where
278: ott.option_type_id = p_option_type_id;
279: --
280: l_proc varchar2(72) := g_package||'del_tl';