61: --
62: --
63: --
64: --
65: -- Insert the row into: per_qualifications_tl
66: --
67: insert into per_qualifications_tl
68: (qualification_id
69: ,language
63: --
64: --
65: -- Insert the row into: per_qualifications_tl
66: --
67: insert into per_qualifications_tl
68: (qualification_id
69: ,language
70: ,source_lang
71: ,title
238: --
239: when hr_api.cannot_find_prog_unit then
240: --
241: hr_api.cannot_find_prog_unit_error
242: (p_module_name => 'PER_QUALIFICATIONS_TL'
243: ,p_hook_type => 'AI');
244: --
245: end;
246: --
373: select l.language_code
374: from fnd_languages l
375: where l.installed_flag in ('I','B')
376: and not exists (select null
377: from per_qualifications_tl qat
378: where qat.qualification_id = p_qualification_id
379: and qat.language = l.language_code);
380: --
381: l_proc varchar2(72) := g_package || 'ins_tl';