DBA Data[Home] [Help]

APPS.HXC_HAT_DEL dependencies on HXC_HAT_SHD

Line 53: (p_rec in hxc_hat_shd.g_rec_type

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

Line 81: hxc_hat_shd.constraint_error

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

Line 120: Procedure pre_delete(p_rec in hxc_hat_shd.g_rec_type) is

116: -- Internal Row Handler Use Only.
117: --
118: -- {End Of Comments}
119: -- ----------------------------------------------------------------------------
120: Procedure pre_delete(p_rec in hxc_hat_shd.g_rec_type) is
121: --
122: cursor c_dep_comp(p_alias_type_id hxc_alias_types.alias_type_id%TYPE) is
123: select alias_type_component_id,object_version_number
124: from hxc_alias_type_components hac

Line 183: Procedure post_delete(p_rec in hxc_hat_shd.g_rec_type) is

179: -- Internal Row Handler Use Only.
180: --
181: -- {End Of Comments}
182: -- -----------------------------------------------------------------------------
183: Procedure post_delete(p_rec in hxc_hat_shd.g_rec_type) is
184: --
185: l_proc varchar2(72);
186: --
187: Begin

Line 198: => hxc_hat_shd.g_old_rec.alias_type

194: hxc_hat_rkd.after_delete
195: (p_alias_type_id
196: => p_rec.alias_type_id
197: ,p_alias_type_o
198: => hxc_hat_shd.g_old_rec.alias_type
199: ,p_reference_object_o
200: => hxc_hat_shd.g_old_rec.reference_object
201: ,p_object_version_number_o
202: => hxc_hat_shd.g_old_rec.object_version_number

Line 200: => hxc_hat_shd.g_old_rec.reference_object

196: => p_rec.alias_type_id
197: ,p_alias_type_o
198: => hxc_hat_shd.g_old_rec.alias_type
199: ,p_reference_object_o
200: => hxc_hat_shd.g_old_rec.reference_object
201: ,p_object_version_number_o
202: => hxc_hat_shd.g_old_rec.object_version_number
203: );
204: --

Line 202: => hxc_hat_shd.g_old_rec.object_version_number

198: => hxc_hat_shd.g_old_rec.alias_type
199: ,p_reference_object_o
200: => hxc_hat_shd.g_old_rec.reference_object
201: ,p_object_version_number_o
202: => hxc_hat_shd.g_old_rec.object_version_number
203: );
204: --
205: exception
206: --

Line 224: (p_rec in hxc_hat_shd.g_rec_type

220: -- ----------------------------------------------------------------------------
221: -- |---------------------------------< del >----------------------------------|
222: -- ----------------------------------------------------------------------------
223: Procedure del
224: (p_rec in hxc_hat_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72);
228: --

Line 238: hxc_hat_shd.lck

234: end if;
235: --
236: -- We must lock the row which we need to delete.
237: --
238: hxc_hat_shd.lck
239: (p_rec.alias_type_id
240: ,p_rec.object_version_number
241: );
242: --

Line 275: l_rec hxc_hat_shd.g_rec_type;

271: (p_alias_type_id in number
272: ,p_object_version_number in number
273: ) is
274: --
275: l_rec hxc_hat_shd.g_rec_type;
276: l_proc varchar2(72);
277: --
278: Begin
279: g_debug:=hr_utility.debug_enabled;