DBA Data[Home] [Help]

APPS.OTA_ANT_UPD dependencies on OTA_ANNOUNCEMENTS_TL

Line 66: -- Update the ota_announcements_tl Row

62: --
63: --
64: --
65: --
66: -- Update the ota_announcements_tl Row
67: --
68: update ota_announcements_tl
69: set
70: announcement_id = p_rec.announcement_id

Line 68: update ota_announcements_tl

64: --
65: --
66: -- Update the ota_announcements_tl Row
67: --
68: update ota_announcements_tl
69: set
70: announcement_id = p_rec.announcement_id
71: ,language = p_rec.language
72: ,source_lang = p_rec.source_lang

Line 215: (p_module_name => 'OTA_ANNOUNCEMENTS_TL'

211: --
212: when hr_api.cannot_find_prog_unit then
213: --
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'OTA_ANNOUNCEMENTS_TL'
216: ,p_hook_type => 'AU');
217: --
218: end;
219: --

Line 405: from ota_announcements_tl ant

401: -- source_lang match the specified language.
402: --
403: cursor csr_upd_langs is
404: select ant.language
405: from ota_announcements_tl ant
406: where ant.announcement_id = p_announcement_id
407: and p_language_code in (ant.language
408: ,ant.source_lang);
409: --