DBA Data[Home] [Help]

APPS.OTA_CTL_UPD dependencies on OTA_CERTIFICATIONS_TL

Line 66: -- Update the ota_certifications_tl Row

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

Line 68: update ota_certifications_tl

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

Line 245: (p_module_name => 'OTA_CERTIFICATIONS_TL'

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

Line 477: from ota_certifications_tl ctl

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