62: --
63: --
64: --
65: --
66: -- Update the per_qualifications_tl Row
67: --
68: update per_qualifications_tl
69: set
70: qualification_id = p_rec.qualification_id
64: --
65: --
66: -- Update the per_qualifications_tl Row
67: --
68: update per_qualifications_tl
69: set
70: qualification_id = p_rec.qualification_id
71: ,language = p_rec.language
72: ,source_lang = p_rec.source_lang
239: --
240: when hr_api.cannot_find_prog_unit then
241: --
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'PER_QUALIFICATIONS_TL'
244: ,p_hook_type => 'AU');
245: --
246: end;
247: --
465: -- source_lang match the specified language.
466: --
467: cursor csr_upd_langs is
468: select qat.language
469: from per_qualifications_tl qat
470: where qat.qualification_id = p_qualification_id
471: and p_language_code in (qat.language
472: ,qat.source_lang);
473: --