65: p_rec.object_version_number := 1; -- Initialise the object version
66: --
67: hxc_aps_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Insert the row into: hxc_approval_period_sets
70: --
71: insert into hxc_approval_period_sets
72: (approval_period_set_id
73: ,name
67: hxc_aps_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Insert the row into: hxc_approval_period_sets
70: --
71: insert into hxc_approval_period_sets
72: (approval_period_set_id
73: ,name
74: ,object_version_number
75: ,creation_date
157: ) is
158: --
159: l_proc varchar2(72);
160: --
161: Cursor C_Sel1 is select hxc_approval_period_sets_s.nextval from sys.dual;
162: --
163: Begin
164: if g_debug then
165: l_proc:= g_package||'pre_insert';
237: --
238: when hr_api.cannot_find_prog_unit then
239: --
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'HXC_APPROVAL_PERIOD_SETS'
242: ,p_hook_type => 'AI');
243: --
244: end;
245: --