66: --
67: --
68: --
69: --
70: -- Insert the row into: hxc_layouts_tl
71: --
72: insert into hxc_layouts_tl
73: (layout_id
74: ,display_layout_name
68: --
69: --
70: -- Insert the row into: hxc_layouts_tl
71: --
72: insert into hxc_layouts_tl
73: (layout_id
74: ,display_layout_name
75: ,language
76: ,source_lang
237: --
238: when hr_api.cannot_find_prog_unit then
239: --
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'HXC_LAYOUTS_TL'
242: ,p_hook_type => 'AI');
243: --
244: end;
245: --
357: select l.language_code
358: from fnd_languages l
359: where l.installed_flag in ('I','B')
360: and not exists (select null
361: from hxc_layouts_tl ult
362: where ult.layout_id = p_layout_id
363: and ult.language = l.language_code);
364: --
365: l_proc varchar2(72) ;