72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out NOCOPY per_ent_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
132: Exception
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: --
136: per_ent_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: --
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: --
141: per_ent_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: --
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: --
146: per_ent_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: --
150: Raise;
187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure pre_insert
191: (p_rec in out NOCOPY per_ent_shd.g_rec_type
192: ) is
193: --
194: Cursor C_Sel1 is select per_calendar_entries_s.nextval from sys.dual;
195: --
275: -- {End Of Comments}
276: -- ----------------------------------------------------------------------------
277: Procedure post_insert
278: (p_effective_date in date
279: ,p_rec in per_ent_shd.g_rec_type
280: ) is
281: --
282: l_proc varchar2(72) := g_package||'post_insert';
283: --
339: -- |---------------------------------< ins >----------------------------------|
340: -- ----------------------------------------------------------------------------
341: Procedure ins
342: (p_effective_date in date
343: ,p_rec in out nocopy per_ent_shd.g_rec_type
344: ) is
345: --
346: l_proc varchar2(72) := g_package||'ins';
347: --
403: ,p_calendar_entry_id out NOCOPY number
404: ,p_object_version_number out NOCOPY number
405: ) is
406: --
407: l_rec per_ent_shd.g_rec_type;
408: l_proc varchar2(72) := g_package||'ins';
409: --
410: Begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
413: -- Call conversion function to turn arguments into the
414: -- p_rec structure.
415: --
416: l_rec :=
417: per_ent_shd.convert_args
418: (null
419: ,p_business_group_id
420: ,p_name
421: ,p_type