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: per_std_holiday_absences
57: --
58: insert into per_std_holiday_absences
59: ( std_holiday_absences_id,
60: date_not_taken,
54: --
55: --
56: -- Insert the row into: per_std_holiday_absences
57: --
58: insert into per_std_holiday_absences
59: ( std_holiday_absences_id,
60: date_not_taken,
61: person_id,
62: standard_holiday_id,
176: Procedure pre_insert(p_rec in out nocopy per_sha_shd.g_rec_type) is
177: --
178: l_proc varchar2(72) := g_package||'pre_insert';
179: --
180: Cursor C_Sel1 is select per_std_holiday_absences_s.nextval from sys.dual;
181: --
182: Begin
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (p_module_name => 'PER_STD_HOLIDAY_ABSENCES'
271: ,p_hook_type => 'AI'
272: );
273: end;
274: -- End of API User Hook for post_insert.