eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_HAC_DEL dependencies on HXC_HAC_SHD

Line 53: (p_rec in hxc_hac_shd.g_rec_type

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

Line 64: hxc_hac_shd.g_api_dml := true; -- Set the api dml status

60: l_proc := g_package||'delete_dml';
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63: --
64: hxc_hac_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Delete the hxc_approval_comps row.
67: --
68:

Line 76: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status

72:
73: delete from hxc_approval_comps
74: where approval_comp_id = p_rec.approval_comp_id;
75: --
76: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
77: --
78: if g_debug then
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: end if;

Line 85: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status

81: --
82: Exception
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
86: hxc_hac_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status

Line 86: hxc_hac_shd.constraint_error

82: Exception
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
86: hxc_hac_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
90: Raise;

Line 89: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status

85: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
86: hxc_hac_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
90: Raise;
91: End delete_dml;
92: --
93: -- ----------------------------------------------------------------------------

Line 125: Procedure pre_delete(p_rec in hxc_hac_shd.g_rec_type) is

121: -- Internal Row Handler Use Only.
122: --
123: -- {End Of Comments}
124: -- ----------------------------------------------------------------------------
125: Procedure pre_delete(p_rec in hxc_hac_shd.g_rec_type) is
126: --
127: l_proc varchar2(72);
128: --
129: Begin

Line 170: Procedure post_delete(p_rec in hxc_hac_shd.g_rec_type) is

166: -- Internal Row Handler Use Only.
167: --
168: -- {End Of Comments}
169: -- -----------------------------------------------------------------------------
170: Procedure post_delete(p_rec in hxc_hac_shd.g_rec_type) is
171: --
172: l_proc varchar2(72);
173: --
174: Begin

Line 185: => hxc_hac_shd.g_old_rec.approval_style_id

181: hxc_hac_rkd.after_delete
182: (p_approval_comp_id
183: => p_rec.approval_comp_id
184: ,p_approval_style_id_o
185: => hxc_hac_shd.g_old_rec.approval_style_id
186: ,p_time_recipient_id_o
187: => hxc_hac_shd.g_old_rec.time_recipient_id
188: ,p_approval_mechanism_o
189: => hxc_hac_shd.g_old_rec.approval_mechanism

Line 187: => hxc_hac_shd.g_old_rec.time_recipient_id

183: => p_rec.approval_comp_id
184: ,p_approval_style_id_o
185: => hxc_hac_shd.g_old_rec.approval_style_id
186: ,p_time_recipient_id_o
187: => hxc_hac_shd.g_old_rec.time_recipient_id
188: ,p_approval_mechanism_o
189: => hxc_hac_shd.g_old_rec.approval_mechanism
190: ,p_approval_mechanism_id_o
191: => hxc_hac_shd.g_old_rec.approval_mechanism_id

Line 189: => hxc_hac_shd.g_old_rec.approval_mechanism

185: => hxc_hac_shd.g_old_rec.approval_style_id
186: ,p_time_recipient_id_o
187: => hxc_hac_shd.g_old_rec.time_recipient_id
188: ,p_approval_mechanism_o
189: => hxc_hac_shd.g_old_rec.approval_mechanism
190: ,p_approval_mechanism_id_o
191: => hxc_hac_shd.g_old_rec.approval_mechanism_id
192: ,p_wf_item_type_o
193: => hxc_hac_shd.g_old_rec.wf_item_type

Line 191: => hxc_hac_shd.g_old_rec.approval_mechanism_id

187: => hxc_hac_shd.g_old_rec.time_recipient_id
188: ,p_approval_mechanism_o
189: => hxc_hac_shd.g_old_rec.approval_mechanism
190: ,p_approval_mechanism_id_o
191: => hxc_hac_shd.g_old_rec.approval_mechanism_id
192: ,p_wf_item_type_o
193: => hxc_hac_shd.g_old_rec.wf_item_type
194: ,p_wf_name_o
195: => hxc_hac_shd.g_old_rec.wf_name

Line 193: => hxc_hac_shd.g_old_rec.wf_item_type

189: => hxc_hac_shd.g_old_rec.approval_mechanism
190: ,p_approval_mechanism_id_o
191: => hxc_hac_shd.g_old_rec.approval_mechanism_id
192: ,p_wf_item_type_o
193: => hxc_hac_shd.g_old_rec.wf_item_type
194: ,p_wf_name_o
195: => hxc_hac_shd.g_old_rec.wf_name
196: ,p_start_date_o
197: => hxc_hac_shd.g_old_rec.start_date

Line 195: => hxc_hac_shd.g_old_rec.wf_name

191: => hxc_hac_shd.g_old_rec.approval_mechanism_id
192: ,p_wf_item_type_o
193: => hxc_hac_shd.g_old_rec.wf_item_type
194: ,p_wf_name_o
195: => hxc_hac_shd.g_old_rec.wf_name
196: ,p_start_date_o
197: => hxc_hac_shd.g_old_rec.start_date
198: ,p_end_date_o
199: => hxc_hac_shd.g_old_rec.end_date

Line 197: => hxc_hac_shd.g_old_rec.start_date

193: => hxc_hac_shd.g_old_rec.wf_item_type
194: ,p_wf_name_o
195: => hxc_hac_shd.g_old_rec.wf_name
196: ,p_start_date_o
197: => hxc_hac_shd.g_old_rec.start_date
198: ,p_end_date_o
199: => hxc_hac_shd.g_old_rec.end_date
200: ,p_object_version_number_o
201: => hxc_hac_shd.g_old_rec.object_version_number

Line 199: => hxc_hac_shd.g_old_rec.end_date

195: => hxc_hac_shd.g_old_rec.wf_name
196: ,p_start_date_o
197: => hxc_hac_shd.g_old_rec.start_date
198: ,p_end_date_o
199: => hxc_hac_shd.g_old_rec.end_date
200: ,p_object_version_number_o
201: => hxc_hac_shd.g_old_rec.object_version_number
202: ,p_approval_order_o
203: => hxc_hac_shd.g_old_rec.approval_order

Line 201: => hxc_hac_shd.g_old_rec.object_version_number

197: => hxc_hac_shd.g_old_rec.start_date
198: ,p_end_date_o
199: => hxc_hac_shd.g_old_rec.end_date
200: ,p_object_version_number_o
201: => hxc_hac_shd.g_old_rec.object_version_number
202: ,p_approval_order_o
203: => hxc_hac_shd.g_old_rec.approval_order
204: ,p_time_category_id_o
205: => hxc_hac_shd.g_old_rec.time_category_id

Line 203: => hxc_hac_shd.g_old_rec.approval_order

199: => hxc_hac_shd.g_old_rec.end_date
200: ,p_object_version_number_o
201: => hxc_hac_shd.g_old_rec.object_version_number
202: ,p_approval_order_o
203: => hxc_hac_shd.g_old_rec.approval_order
204: ,p_time_category_id_o
205: => hxc_hac_shd.g_old_rec.time_category_id
206: ,p_parent_comp_id_o
207: => hxc_hac_shd.g_old_rec.parent_comp_id

Line 205: => hxc_hac_shd.g_old_rec.time_category_id

201: => hxc_hac_shd.g_old_rec.object_version_number
202: ,p_approval_order_o
203: => hxc_hac_shd.g_old_rec.approval_order
204: ,p_time_category_id_o
205: => hxc_hac_shd.g_old_rec.time_category_id
206: ,p_parent_comp_id_o
207: => hxc_hac_shd.g_old_rec.parent_comp_id
208: ,p_parent_comp_ovn_o
209: => hxc_hac_shd.g_old_rec.parent_comp_ovn

Line 207: => hxc_hac_shd.g_old_rec.parent_comp_id

203: => hxc_hac_shd.g_old_rec.approval_order
204: ,p_time_category_id_o
205: => hxc_hac_shd.g_old_rec.time_category_id
206: ,p_parent_comp_id_o
207: => hxc_hac_shd.g_old_rec.parent_comp_id
208: ,p_parent_comp_ovn_o
209: => hxc_hac_shd.g_old_rec.parent_comp_ovn
210: ,p_run_recipient_extensions_o
211: =>hxc_hac_shd.g_old_rec.run_recipient_extensions

Line 209: => hxc_hac_shd.g_old_rec.parent_comp_ovn

205: => hxc_hac_shd.g_old_rec.time_category_id
206: ,p_parent_comp_id_o
207: => hxc_hac_shd.g_old_rec.parent_comp_id
208: ,p_parent_comp_ovn_o
209: => hxc_hac_shd.g_old_rec.parent_comp_ovn
210: ,p_run_recipient_extensions_o
211: =>hxc_hac_shd.g_old_rec.run_recipient_extensions
212: );
213: --

Line 211: =>hxc_hac_shd.g_old_rec.run_recipient_extensions

207: => hxc_hac_shd.g_old_rec.parent_comp_id
208: ,p_parent_comp_ovn_o
209: => hxc_hac_shd.g_old_rec.parent_comp_ovn
210: ,p_run_recipient_extensions_o
211: =>hxc_hac_shd.g_old_rec.run_recipient_extensions
212: );
213: --
214: exception
215: --

Line 233: (p_rec in hxc_hac_shd.g_rec_type

229: -- ----------------------------------------------------------------------------
230: -- |---------------------------------< del >----------------------------------|
231: -- ----------------------------------------------------------------------------
232: Procedure del
233: (p_rec in hxc_hac_shd.g_rec_type
234: ) is
235: --
236: l_proc varchar2(72);
237: --

Line 247: hxc_hac_shd.lck

243: end if;
244: --
245: -- We must lock the row which we need to delete.
246: --
247: hxc_hac_shd.lck
248: (p_rec.approval_comp_id
249: ,p_rec.object_version_number
250: );
251: --

Line 278: l_rec hxc_hac_shd.g_rec_type;

274: (p_approval_comp_id in number
275: ,p_object_version_number in number
276: ) is
277: --
278: l_rec hxc_hac_shd.g_rec_type;
279: l_proc varchar2(72);
280: --
281: Begin
282: g_debug:=hr_utility.debug_enabled;