DBA Data[Home] [Help]

APPS.PER_SHA_INS dependencies on PER_STD_HOLIDAY_ABSENCES

Line 56: -- Insert the row into: per_std_holiday_absences

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,

Line 58: insert into per_std_holiday_absences

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,

Line 180: Cursor C_Sel1 is select per_std_holiday_absences_s.nextval from sys.dual;

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: --

Line 270: (p_module_name => 'PER_STD_HOLIDAY_ABSENCES'

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.