APPS.OTA_CTL_DEL dependencies on OTA_CERTIFICATIONS_TL

Line 62: -- Delete the ota_certifications_tl row.

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

Line 64: delete from ota_certifications_tl

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

Line 195: (p_module_name => 'OTA_CERTIFICATIONS_TL'

191: --
192: when hr_api.cannot_find_prog_unit then
193: --
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'OTA_CERTIFICATIONS_TL'
196: ,p_hook_type => 'AD');
197: --
198: end;
199: --

Line 290: from ota_certifications_tl ctl

286: -- Cursor to obtain all the translation rows.
287: --
288: cursor csr_del_langs is
289: select ctl.language
290: from ota_certifications_tl ctl
291: where ctl.certification_id = p_certification_id;
292: --
293: l_proc varchar2(72) := g_package||'del_tl';
294: --