73: --
74: -- {End Of Comments}
75: -- ----------------------------------------------------------------------------
76: Procedure insert_dml
77: (p_rec in out nocopy per_pac_shd.g_rec_type
78: ) is
79: --
80: l_proc varchar2(72) := g_package||'insert_dml';
81: --
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: --
202: per_pac_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.parent_integrity_violated Then
205: -- Parent integrity has been violated
206: --
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.parent_integrity_violated Then
205: -- Parent integrity has been violated
206: --
207: per_pac_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When hr_api.unique_integrity_violated Then
210: -- Unique integrity has been violated
211: --
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When hr_api.unique_integrity_violated Then
210: -- Unique integrity has been violated
211: --
212: per_pac_shd.constraint_error
213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
214: When Others Then
215: --
216: Raise;
253: --
254: -- {End Of Comments}
255: -- ----------------------------------------------------------------------------
256: Procedure pre_insert
257: (p_rec in out nocopy per_pac_shd.g_rec_type
258: ) is
259: --
260: Cursor C_Sel1 is select per_allocated_checklists_s.nextval from sys.dual;
261: --
341: -- {End Of Comments}
342: -- ----------------------------------------------------------------------------
343: Procedure post_insert
344: (p_effective_date in date
345: ,p_rec in per_pac_shd.g_rec_type
346: ) is
347: --
348: l_proc varchar2(72) := g_package||'post_insert';
349: --
472: -- |---------------------------------< ins >----------------------------------|
473: -- ----------------------------------------------------------------------------
474: Procedure ins
475: (p_effective_date in date
476: ,p_rec in out nocopy per_pac_shd.g_rec_type
477: ) is
478: --
479: l_proc varchar2(72) := g_package||'ins';
480: --
568: ,p_allocated_checklist_id out nocopy number
569: ,p_object_version_number out nocopy number
570: ) is
571: --
572: l_rec per_pac_shd.g_rec_type;
573: l_proc varchar2(72) := g_package||'ins';
574: --
575: Begin
576: hr_utility.set_location('Entering:'||l_proc, 5);
578: -- Call conversion function to turn arguments into the
579: -- p_rec structure.
580: --
581: l_rec :=
582: per_pac_shd.convert_args
583: (null
584: ,p_checklist_id
585: ,p_person_id
586: ,p_assignment_id