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
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
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: --
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: --