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_APC_DEL dependencies on HXC_APC_SHD

Line 53: (p_rec in hxc_apc_shd.g_rec_type

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

Line 64: hxc_apc_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_apc_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Delete the hxc_approval_period_comps row.
67: --
68: delete from hxc_approval_period_comps

Line 71: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

67: --
68: delete from hxc_approval_period_comps
69: where approval_period_comp_id = p_rec.approval_period_comp_id;
70: --
71: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
72: --
73: if g_debug then
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: end if;

Line 80: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

76: --
77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
81: hxc_apc_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

Line 81: hxc_apc_shd.constraint_error

77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
81: hxc_apc_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;

Line 84: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

80: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
81: hxc_apc_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;
86: End delete_dml;
87: --
88: -- ----------------------------------------------------------------------------

Line 120: Procedure pre_delete(p_rec in hxc_apc_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_apc_shd.g_rec_type) is
121: --
122: l_proc varchar2(72);
123: --
124: Begin

Line 165: Procedure post_delete(p_rec in hxc_apc_shd.g_rec_type) is

161: -- Internal Row Handler Use Only.
162: --
163: -- {End Of Comments}
164: -- -----------------------------------------------------------------------------
165: Procedure post_delete(p_rec in hxc_apc_shd.g_rec_type) is
166: --
167: l_proc varchar2(72);
168: --
169: Begin

Line 180: => hxc_apc_shd.g_old_rec.time_recipient_id

176: hxc_apc_rkd.after_delete
177: (p_approval_period_comp_id
178: => p_rec.approval_period_comp_id
179: ,p_time_recipient_id_o
180: => hxc_apc_shd.g_old_rec.time_recipient_id
181: ,p_recurring_period_id_o
182: => hxc_apc_shd.g_old_rec.recurring_period_id
183: ,p_approval_period_set_id_o
184: => hxc_apc_shd.g_old_rec.approval_period_set_id

Line 182: => hxc_apc_shd.g_old_rec.recurring_period_id

178: => p_rec.approval_period_comp_id
179: ,p_time_recipient_id_o
180: => hxc_apc_shd.g_old_rec.time_recipient_id
181: ,p_recurring_period_id_o
182: => hxc_apc_shd.g_old_rec.recurring_period_id
183: ,p_approval_period_set_id_o
184: => hxc_apc_shd.g_old_rec.approval_period_set_id
185: ,p_object_version_number_o
186: => hxc_apc_shd.g_old_rec.object_version_number

Line 184: => hxc_apc_shd.g_old_rec.approval_period_set_id

180: => hxc_apc_shd.g_old_rec.time_recipient_id
181: ,p_recurring_period_id_o
182: => hxc_apc_shd.g_old_rec.recurring_period_id
183: ,p_approval_period_set_id_o
184: => hxc_apc_shd.g_old_rec.approval_period_set_id
185: ,p_object_version_number_o
186: => hxc_apc_shd.g_old_rec.object_version_number
187: );
188: --

Line 186: => hxc_apc_shd.g_old_rec.object_version_number

182: => hxc_apc_shd.g_old_rec.recurring_period_id
183: ,p_approval_period_set_id_o
184: => hxc_apc_shd.g_old_rec.approval_period_set_id
185: ,p_object_version_number_o
186: => hxc_apc_shd.g_old_rec.object_version_number
187: );
188: --
189: exception
190: --

Line 208: (p_rec in hxc_apc_shd.g_rec_type

204: -- ----------------------------------------------------------------------------
205: -- |---------------------------------< del >----------------------------------|
206: -- ----------------------------------------------------------------------------
207: Procedure del
208: (p_rec in hxc_apc_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72);
212: --

Line 222: hxc_apc_shd.lck

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

Line 253: l_rec hxc_apc_shd.g_rec_type;

249: (p_approval_period_comp_id in number
250: ,p_object_version_number in number
251: ) is
252: --
253: l_rec hxc_apc_shd.g_rec_type;
254: l_proc varchar2(72);
255: --
256: Begin
257: g_debug:=hr_utility.debug_enabled;