62: --
63: --
64: --
65: --
66: -- Update the ota_certifications_tl Row
67: --
68: update ota_certifications_tl
69: set
70: certification_id = p_rec.certification_id
64: --
65: --
66: -- Update the ota_certifications_tl Row
67: --
68: update ota_certifications_tl
69: set
70: certification_id = p_rec.certification_id
71: ,language = p_rec.language
72: ,name = p_rec.name
241: --
242: when hr_api.cannot_find_prog_unit then
243: --
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'OTA_CERTIFICATIONS_TL'
246: ,p_hook_type => 'AU');
247: --
248: end;
249: --
473: -- source_lang match the specified language.
474: --
475: cursor csr_upd_langs is
476: select ctl.language
477: from ota_certifications_tl ctl
478: where ctl.certification_id = p_certification_id
479: and p_language_code in (ctl.language
480: ,ctl.source_lang);
481: --