50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy hr_cnp_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
172: Exception
173: When hr_api.check_integrity_violated Then
174: -- A check constraint has been violated
175: --
176: hr_cnp_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.parent_integrity_violated Then
179: -- Parent integrity has been violated
180: --
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.parent_integrity_violated Then
179: -- Parent integrity has been violated
180: --
181: hr_cnp_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When hr_api.unique_integrity_violated Then
184: -- Unique integrity has been violated
185: --
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When hr_api.unique_integrity_violated Then
184: -- Unique integrity has been violated
185: --
186: hr_cnp_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When Others Then
189: --
190: Raise;
227: --
228: -- {End Of Comments}
229: -- ----------------------------------------------------------------------------
230: Procedure pre_insert
231: (p_rec in out nocopy hr_cnp_shd.g_rec_type
232: ) is
233: --
234: l_proc varchar2(72) := g_package||'pre_insert';
235: --
281: -- {End Of Comments}
282: -- ----------------------------------------------------------------------------
283: Procedure post_insert
284: (p_effective_date in date
285: ,p_rec in hr_cnp_shd.g_rec_type
286: ) is
287: --
288: l_proc varchar2(72) := g_package||'post_insert';
289: --
352: -- |---------------------------------< ins >----------------------------------|
353: -- ----------------------------------------------------------------------------
354: Procedure ins
355: (p_effective_date in date
356: ,p_rec in out nocopy hr_cnp_shd.g_rec_type
357: ) is
358: --
359: l_proc varchar2(72) := g_package||'ins';
360: --
432: ,p_canvas_property_id out nocopy number
433: ,p_object_version_number out nocopy number
434: ) is
435: --
436: l_rec hr_cnp_shd.g_rec_type;
437: l_proc varchar2(72) := g_package||'ins';
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);
442: -- Call conversion function to turn arguments into the
443: -- p_rec structure.
444: --
445: l_rec :=
446: hr_cnp_shd.convert_args
447: (null
448: ,p_form_canvas_id
449: ,p_object_version_number
450: ,p_template_canvas_id