62: --
63: --
64: --
65: --
66: -- Update the hr_all_organization_units_tl Row
67: --
68: update hr_all_organization_units_tl
69: set
70: organization_id = p_rec.organization_id
64: --
65: --
66: -- Update the hr_all_organization_units_tl Row
67: --
68: update hr_all_organization_units_tl
69: set
70: organization_id = p_rec.organization_id
71: ,language = p_rec.language
72: ,source_lang = p_rec.source_lang
204: --
205: when hr_api.cannot_find_prog_unit then
206: --
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'HR_ALL_ORGANIZATION_UNITS_TL'
209: ,p_hook_type => 'AU');
210: --
211: end;
212: --
375: -- source_lang match the specified language.
376: --
377: cursor csr_upd_langs is
378: select ort.language
379: from hr_all_organization_units_tl ort
380: where ort.organization_id = p_organization_id
381: and p_language_code in (ort.language
382: ,ort.source_lang);
383: --