DBA Data[Home] [Help]

APPS.HXC_HAN_INS dependencies on HXC_HAN_SHD

Line 84: (p_rec in out nocopy hxc_han_shd.g_rec_type

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: --

Line 135: hxc_han_shd.constraint_error

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: --

Line 140: 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: --
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: --

Line 145: 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: --
145: hxc_han_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: --
149: Raise;

Line 190: (p_rec in out nocopy hxc_han_shd.g_rec_type

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: --

Line 287: (p_rec in hxc_han_shd.g_rec_type

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: --

Line 332: (p_rec in out nocopy hxc_han_shd.g_rec_type

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: --

Line 385: l_rec hxc_han_shd.g_rec_type;

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

Line 397: hxc_han_shd.convert_args

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