DBA Data[Home] [Help]

APPS.OTA_ONT_DEL dependencies on OTA_OFFERINGS_TL

Line 62: -- Delete the ota_offerings_tl row.

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

Line 64: delete from ota_offerings_tl

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

Line 184: (p_module_name => 'OTA_OFFERINGS_TL'

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

Line 279: from ota_offerings_tl ont

275: -- Cursor to obtain all the translation rows.
276: --
277: cursor csr_del_langs is
278: select ont.language
279: from ota_offerings_tl ont
280: where ont.offering_id = p_offering_id;
281: --
282: l_proc varchar2(72) := g_package||'del_tl';
283: --