51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure insert_dml
55: (p_rec in out nocopy hxc_hav_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72);
59: --
167: Exception
168: When hr_api.check_integrity_violated Then
169: -- A check constraint has been violated
170: --
171: hxc_hav_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: --
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: --
176: hxc_hav_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: --
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: --
181: hxc_hav_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When Others Then
184: --
185: Raise;
222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure pre_insert
226: (p_rec in out nocopy hxc_hav_shd.g_rec_type
227: ) is
228: --
229: l_proc varchar2(72);
230: --
280: --
281: -- {End Of Comments}
282: -- ----------------------------------------------------------------------------
283: Procedure post_insert
284: (p_rec in hxc_hav_shd.g_rec_type
285: ) is
286: --
287: l_proc varchar2(72);
288: --
390: -- ----------------------------------------------------------------------------
391: -- |---------------------------------< ins >----------------------------------|
392: -- ----------------------------------------------------------------------------
393: Procedure ins
394: (p_rec in out nocopy hxc_hav_shd.g_rec_type
395: ) is
396: --
397: l_proc varchar2(72);
398: --
471: ,p_alias_value_id out nocopy number
472: ,p_object_version_number out nocopy number
473: ) is
474: --
475: l_rec hxc_hav_shd.g_rec_type;
476: l_proc varchar2(72);
477: --
478: Begin
479: g_debug:=hr_utility.debug_enabled;
485: -- Call conversion function to turn arguments into the
486: -- p_rec structure.
487: --
488: l_rec :=
489: hxc_hav_shd.convert_args
490: (null
491: ,p_alias_value_name
492: ,p_date_from
493: ,p_date_to