65: --
66: --
67: --
68: --
69: -- Insert the row into: hxc_alias_definitions_tl
70: --
71: insert into hxc_alias_definitions_tl
72: (alias_definition_id
73: ,alias_definition_name
67: --
68: --
69: -- Insert the row into: hxc_alias_definitions_tl
70: --
71: insert into hxc_alias_definitions_tl
72: (alias_definition_id
73: ,alias_definition_name
74: ,description
75: ,prompt
243: --
244: when hr_api.cannot_find_prog_unit then
245: --
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'HXC_ALIAS_DEFINITIONS_TL'
248: ,p_hook_type => 'AI');
249: --
250: end;
251: --
369: select l.language_code
370: from fnd_languages l
371: where l.installed_flag in ('I','B')
372: and not exists (select null
373: from hxc_alias_definitions_tl dtl
374: where dtl.alias_definition_id = p_alias_definition_id
375: and dtl.language = l.language_code);
376: --
377: l_proc varchar2(72);