DBA Data[Home] [Help]

APPS.OTA_AVT_DEL dependencies on OTA_ACTIVITY_VERSIONS_TL

Line 62: -- Delete the ota_activity_versions_tl row.

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

Line 64: delete from ota_activity_versions_tl

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

Line 189: (p_module_name => 'OTA_ACTIVITY_VERSIONS_TL'

185: --
186: when hr_api.cannot_find_prog_unit then
187: --
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'OTA_ACTIVITY_VERSIONS_TL'
190: ,p_hook_type => 'AD');
191: --
192: end;
193: --

Line 284: from ota_activity_versions_tl avt

280: -- Cursor to obtain all the translation rows.
281: --
282: cursor csr_del_langs is
283: select avt.language
284: from ota_activity_versions_tl avt
285: where avt.activity_version_id = p_activity_version_id;
286: --
287: l_proc varchar2(72) := g_package||'del_tl';
288: --