50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy hr_itp_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
260: Exception
261: When hr_api.check_integrity_violated Then
262: -- A check constraint has been violated
263: --
264: hr_itp_shd.constraint_error
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When hr_api.parent_integrity_violated Then
267: -- Parent integrity has been violated
268: --
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When hr_api.parent_integrity_violated Then
267: -- Parent integrity has been violated
268: --
269: hr_itp_shd.constraint_error
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated
273: --
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated
273: --
274: hr_itp_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When Others Then
277: --
278: Raise;
315: --
316: -- {End Of Comments}
317: -- ----------------------------------------------------------------------------
318: Procedure pre_insert
319: (p_rec in out nocopy hr_itp_shd.g_rec_type
320: ) is
321: --
322: l_proc varchar2(72) := g_package||'pre_insert';
323: --
369: -- {End Of Comments}
370: -- ----------------------------------------------------------------------------
371: Procedure post_insert
372: (p_effective_date in date
373: ,p_rec in hr_itp_shd.g_rec_type
374: ) is
375: --
376: l_proc varchar2(72) := g_package||'post_insert';
377: --
540: -- |---------------------------------< ins >----------------------------------|
541: -- ----------------------------------------------------------------------------
542: Procedure ins
543: (p_effective_date in date
544: ,p_rec in out nocopy hr_itp_shd.g_rec_type
545: ) is
546: --
547: l_proc varchar2(72) := g_package||'ins';
548: --
650: ,p_item_property_id out nocopy number
651: ,p_object_version_number out nocopy number
652: ) is
653: --
654: l_rec hr_itp_shd.g_rec_type;
655: l_proc varchar2(72) := g_package||'ins';
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
660: -- Call conversion function to turn arguments into the
661: -- p_rec structure.
662: --
663: l_rec :=
664: hr_itp_shd.convert_args
665: (null
666: ,p_object_version_number
667: ,p_form_item_id
668: ,p_template_item_id