50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy per_pgv_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: --
229: per_pgv_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.parent_integrity_violated Then
232: -- Parent integrity has been violated
233: --
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.parent_integrity_violated Then
232: -- Parent integrity has been violated
233: --
234: per_pgv_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: --
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: --
239: per_pgv_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: --
243: Raise;
280: --
281: -- {End Of Comments}
282: -- ----------------------------------------------------------------------------
283: Procedure pre_insert
284: (p_rec in out nocopy per_pgv_shd.g_rec_type
285: ) is
286: --
287: l_proc varchar2(72) := g_package||'pre_insert';
288: --
334: -- {End Of Comments}
335: -- ----------------------------------------------------------------------------
336: Procedure post_insert
337: (p_effective_date in date
338: ,p_rec in per_pgv_shd.g_rec_type
339: ) is
340: --
341: l_proc varchar2(72) := g_package||'post_insert';
342: --
515: -- |---------------------------------< ins >----------------------------------|
516: -- ----------------------------------------------------------------------------
517: Procedure ins
518: (p_effective_date in date
519: ,p_rec in out nocopy per_pgv_shd.g_rec_type
520: ) is
521: --
522: l_proc varchar2(72) := g_package||'ins';
523: --
630: ,p_hierarchy_version_id out nocopy number
631: ,p_object_version_number out nocopy number
632: ) is
633: --
634: l_rec per_pgv_shd.g_rec_type;
635: l_proc varchar2(72) := g_package||'ins';
636: --
637: Begin
638: hr_utility.set_location('Entering:'||l_proc, 5);
640: -- Call conversion function to turn arguments into the
641: -- p_rec structure.
642: --
643: l_rec :=
644: per_pgv_shd.convert_args
645: (null
646: ,p_business_group_id
647: ,p_version_number
648: ,p_hierarchy_id