59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: ben_psq_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ben_pymt_sched_py_freq
64: --
65: insert into ben_pymt_sched_py_freq
66: ( pymt_sched_py_freq_id,
67: py_freq_cd,
61: ben_psq_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ben_pymt_sched_py_freq
64: --
65: insert into ben_pymt_sched_py_freq
66: ( pymt_sched_py_freq_id,
67: py_freq_cd,
68: dflt_flag,
69: business_group_id,
206: --
207: l_proc varchar2(72) := g_package||'pre_insert';
208: --
209: cursor c1 is
210: select BEN_PYMT_SCHED_PY_FREQ_S.nextval
211: from sys.dual;
212: --
213: --
214: Begin
315: --
316: when hr_api.cannot_find_prog_unit then
317: --
318: hr_api.cannot_find_prog_unit_error
319: (p_module_name => 'ben_pymt_sched_py_freq'
320: ,p_hook_type => 'AI');
321: --
322: end;
323: --