DBA Data[Home] [Help]

APPS.HXC_HAN_DEL dependencies on HXC_HAN_SHD

Line 53: (p_rec in hxc_han_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in hxc_han_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) := g_package||'delete_dml';
57: --

Line 82: hxc_han_shd.constraint_error

78: Exception
79: When hr_api.child_integrity_violated then
80: -- Child integrity has been violated
81: --
82: hxc_han_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: --
86: Raise;

Line 121: Procedure pre_delete(p_rec in hxc_han_shd.g_rec_type) is

117: -- Internal Row Handler Use Only.
118: --
119: -- {End Of Comments}
120: -- ----------------------------------------------------------------------------
121: Procedure pre_delete(p_rec in hxc_han_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) := g_package||'pre_delete';
124: --
125: Begin

Line 167: Procedure post_delete(p_rec in hxc_han_shd.g_rec_type) is

163: -- Internal Row Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- -----------------------------------------------------------------------------
167: Procedure post_delete(p_rec in hxc_han_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'post_delete';
170: --
171: Begin

Line 183: => hxc_han_shd.g_old_rec.notification_number_retries

179: => p_rec.comp_notification_id
180: ,p_object_version_number
181: => p_rec.object_version_number
182: ,p_notification_num_retries_o
183: => hxc_han_shd.g_old_rec.notification_number_retries
184: ,p_notification_timeout_value_o
185: => hxc_han_shd.g_old_rec.notification_timeout_value
186: ,p_notification_action_code_o
187: => hxc_han_shd.g_old_rec.notification_action_code

Line 185: => hxc_han_shd.g_old_rec.notification_timeout_value

181: => p_rec.object_version_number
182: ,p_notification_num_retries_o
183: => hxc_han_shd.g_old_rec.notification_number_retries
184: ,p_notification_timeout_value_o
185: => hxc_han_shd.g_old_rec.notification_timeout_value
186: ,p_notification_action_code_o
187: => hxc_han_shd.g_old_rec.notification_action_code
188: ,p_notification_recip_code_o
189: => hxc_han_shd.g_old_rec.notification_recipient_code

Line 187: => hxc_han_shd.g_old_rec.notification_action_code

183: => hxc_han_shd.g_old_rec.notification_number_retries
184: ,p_notification_timeout_value_o
185: => hxc_han_shd.g_old_rec.notification_timeout_value
186: ,p_notification_action_code_o
187: => hxc_han_shd.g_old_rec.notification_action_code
188: ,p_notification_recip_code_o
189: => hxc_han_shd.g_old_rec.notification_recipient_code
190: );
191: --

Line 189: => hxc_han_shd.g_old_rec.notification_recipient_code

185: => hxc_han_shd.g_old_rec.notification_timeout_value
186: ,p_notification_action_code_o
187: => hxc_han_shd.g_old_rec.notification_action_code
188: ,p_notification_recip_code_o
189: => hxc_han_shd.g_old_rec.notification_recipient_code
190: );
191: --
192: exception
193: --

Line 211: (p_rec in hxc_han_shd.g_rec_type

207: -- ----------------------------------------------------------------------------
208: -- |---------------------------------< del >----------------------------------|
209: -- ----------------------------------------------------------------------------
210: Procedure del
211: (p_rec in hxc_han_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'del';
215: --

Line 223: hxc_han_shd.lck

219: end if;
220: --
221: -- We must lock the row which we need to delete.
222: --
223: hxc_han_shd.lck
224: (p_rec.comp_notification_id
225: ,p_rec.object_version_number
226: );
227: --

Line 260: l_rec hxc_han_shd.g_rec_type;

256: (p_comp_notification_id in number
257: ,p_object_version_number in number
258: ) is
259: --
260: l_rec hxc_han_shd.g_rec_type;
261: l_proc varchar2(72) := g_package||'del';
262: --
263: Begin
264: if g_debug then