80: --
81: -- {End Of Comments}
82: -- ----------------------------------------------------------------------------
83: Procedure insert_dml
84: (p_rec in out nocopy hxc_han_shd.g_rec_type
85: ) is
86: --
87: l_proc varchar2(72) := g_package||'insert_dml';
88: --
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: --
135: hxc_han_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: --
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: --
140: hxc_han_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: --
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: --
145: hxc_han_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: --
149: Raise;
186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure pre_insert
190: (p_rec in out nocopy hxc_han_shd.g_rec_type
191: ) is
192: --
193: Cursor C_Sel1 is select hxc_app_comp_notifications_s.nextval from sys.dual;
194: --
283: --
284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure post_insert
287: (p_rec in hxc_han_shd.g_rec_type
288: ) is
289: --
290: l_proc varchar2(72) := g_package||'post_insert';
291: --
328: -- ----------------------------------------------------------------------------
329: -- |---------------------------------< ins >----------------------------------|
330: -- ----------------------------------------------------------------------------
331: Procedure ins
332: (p_rec in out nocopy hxc_han_shd.g_rec_type
333: ) is
334: --
335: l_proc varchar2(72) := g_package||'ins';
336: --
381: ,p_comp_notification_id out nocopy number
382: ,p_object_version_number out nocopy number
383: ) is
384: --
385: l_rec hxc_han_shd.g_rec_type;
386: l_proc varchar2(72) := g_package||'ins';
387: --
388: Begin
389: if g_debug then
393: -- Call conversion function to turn arguments into the
394: -- p_rec structure.
395: --
396: l_rec :=
397: hxc_han_shd.convert_args
398: (null
399: ,null
400: ,p_notification_number_retries
401: ,p_notification_timeout_value