66: p_rec.object_version_number := 1; -- Initialise the object version
67: --
68: --
69: --
70: -- Insert the row into: hxc_layouts
71: --
72: insert into hxc_layouts
73: (layout_id
74: ,layout_name
68: --
69: --
70: -- Insert the row into: hxc_layouts
71: --
72: insert into hxc_layouts
73: (layout_id
74: ,layout_name
75: ,application_id
76: ,layout_type
166: ) is
167: --
168: l_proc varchar2(72) ;
169: --
170: Cursor C_Sel1 is select hxc_layouts_s.nextval from sys.dual;
171: --
172: Begin
173:
174: if g_debug then
257: --
258: when hr_api.cannot_find_prog_unit then
259: --
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'HXC_LAYOUTS'
262: ,p_hook_type => 'AI');
263: --
264: end;
265: --
357: );
358: --
359: -- insert the row into the tl table
360: --
361: -- call the api to insert the row into hxc_layouts_tl
362: --
363: hxc_ult_ins.ins_tl
364: (p_language_code => USERENV('LANG')
365: ,p_layout_id => l_rec.layout_id