52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: ghr_noac_remarks
57: --
58: insert into ghr_noac_remarks
59: ( noac_remark_id,
60: nature_of_action_id,
54: --
55: --
56: -- Insert the row into: ghr_noac_remarks
57: --
58: insert into ghr_noac_remarks
59: ( noac_remark_id,
60: nature_of_action_id,
61: remark_id,
62: required_flag,
135: Procedure pre_insert(p_rec in out ghr_nre_shd.g_rec_type) is
136: --
137: l_proc varchar2(72) := g_package||'pre_insert';
138: --
139: Cursor C_Sel1 is select ghr_noac_remarks_s.nextval from sys.dual;
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
213: --
214: when hr_api.cannot_find_prog_unit then
215: --
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'ghr_noac_remarks'
218: ,p_hook_type => 'AI');
219: --
220: end;
221: --