65: --
66: --
67: --
68: --
69: -- Insert the row into: hxc_alias_values_tl
70: --
71: insert into hxc_alias_values_tl
72: (alias_value_id
73: ,alias_value_name
67: --
68: --
69: -- Insert the row into: hxc_alias_values_tl
70: --
71: insert into hxc_alias_values_tl
72: (alias_value_id
73: ,alias_value_name
74: ,language
75: ,source_lang
236: --
237: when hr_api.cannot_find_prog_unit then
238: --
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'HXC_ALIAS_VALUES_TL'
241: ,p_hook_type => 'AI');
242: --
243: end;
244: --
356: select l.language_code
357: from fnd_languages l
358: where l.installed_flag in ('I','B')
359: and not exists (select null
360: from hxc_alias_values_tl vtl
361: where vtl.alias_value_id = p_alias_value_id
362: and vtl.language = l.language_code);
363: --
364: l_proc varchar2(72) ;