59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: ben_dsq_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ben_ded_sched_py_freq
64: --
65: insert into ben_ded_sched_py_freq
66: ( ded_sched_py_freq_id,
67: py_freq_cd,
61: ben_dsq_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ben_ded_sched_py_freq
64: --
65: insert into ben_ded_sched_py_freq
66: ( ded_sched_py_freq_id,
67: py_freq_cd,
68: dflt_flag,
69: acty_rt_ded_sched_id,
205: Procedure pre_insert(p_rec in out nocopy ben_dsq_shd.g_rec_type) is
206: --
207: l_proc varchar2(72) := g_package||'pre_insert';
208: cursor c1 is
209: select ben_ded_sched_py_freq_s.nextval
210: from sys.dual;
211: --
212: Begin
213: hr_utility.set_location('Entering:'||l_proc, 5);
310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'ben_ded_sched_py_freq'
315: ,p_hook_type => 'AI');
316: --
317: end;
318: --