APPS.OTA_AVT_UPD dependencies on OTA_ACTIVITY_VERSIONS_TL

Line 66: -- Update the ota_activity_versions_tl Row

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

Line 68: update ota_activity_versions_tl

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

Line 230: (p_module_name => 'OTA_ACTIVITY_VERSIONS_TL'

226: --
227: when hr_api.cannot_find_prog_unit then
228: --
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'OTA_ACTIVITY_VERSIONS_TL'
231: ,p_hook_type => 'AU');
232: --
233: end;
234: --

Line 441: from ota_activity_versions_tl avt

437: -- source_lang match the specified language.
438: --
439: cursor csr_upd_langs is
440: select avt.language
441: from ota_activity_versions_tl avt
442: where avt.activity_version_id = p_activity_version_id
443: and p_language_code in (avt.language
444: ,avt.source_lang);
445: --