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_DRU_DEL dependencies on HXC_DRU_SHD

Line 53: (p_rec in hxc_dru_shd.g_rec_type

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

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

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

67: --
68: delete from hxc_data_app_rule_usages
69: where data_app_rule_usage_id = p_rec.data_app_rule_usage_id;
70: --
71: hxc_dru_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_dru_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_dru_shd.g_api_dml := false; -- Unset the api dml status
81: hxc_dru_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status

Line 81: hxc_dru_shd.constraint_error

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

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

80: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status
81: hxc_dru_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: hxc_dru_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_dru_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_dru_shd.g_rec_type) is
121: --
122: l_proc varchar2(72);
123: --
124: Begin

Line 167: Procedure post_delete(p_rec in hxc_dru_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_dru_shd.g_rec_type) is
168: --
169: l_proc varchar2(72);
170: --
171: Begin

Line 182: => hxc_dru_shd.g_old_rec.approval_style_id

178: hxc_dru_rkd.after_delete
179: (p_data_app_rule_usage_id
180: => p_rec.data_app_rule_usage_id
181: ,p_approval_style_id_o
182: => hxc_dru_shd.g_old_rec.approval_style_id
183: ,p_time_entry_rule_id_o
184: => hxc_dru_shd.g_old_rec.time_entry_rule_id
185: ,p_time_recipient_id_o
186: => hxc_dru_shd.g_old_rec.time_recipient_id

Line 184: => hxc_dru_shd.g_old_rec.time_entry_rule_id

180: => p_rec.data_app_rule_usage_id
181: ,p_approval_style_id_o
182: => hxc_dru_shd.g_old_rec.approval_style_id
183: ,p_time_entry_rule_id_o
184: => hxc_dru_shd.g_old_rec.time_entry_rule_id
185: ,p_time_recipient_id_o
186: => hxc_dru_shd.g_old_rec.time_recipient_id
187: ,p_object_version_number_o
188: => hxc_dru_shd.g_old_rec.object_version_number

Line 186: => hxc_dru_shd.g_old_rec.time_recipient_id

182: => hxc_dru_shd.g_old_rec.approval_style_id
183: ,p_time_entry_rule_id_o
184: => hxc_dru_shd.g_old_rec.time_entry_rule_id
185: ,p_time_recipient_id_o
186: => hxc_dru_shd.g_old_rec.time_recipient_id
187: ,p_object_version_number_o
188: => hxc_dru_shd.g_old_rec.object_version_number
189: );
190: --

Line 188: => hxc_dru_shd.g_old_rec.object_version_number

184: => hxc_dru_shd.g_old_rec.time_entry_rule_id
185: ,p_time_recipient_id_o
186: => hxc_dru_shd.g_old_rec.time_recipient_id
187: ,p_object_version_number_o
188: => hxc_dru_shd.g_old_rec.object_version_number
189: );
190: --
191: exception
192: --

Line 210: (p_rec in hxc_dru_shd.g_rec_type

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

Line 224: hxc_dru_shd.lck

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

Line 255: l_rec hxc_dru_shd.g_rec_type;

251: (p_data_app_rule_usage_id in number
252: ,p_object_version_number in number
253: ) is
254: --
255: l_rec hxc_dru_shd.g_rec_type;
256: l_proc varchar2(72);
257: --
258: Begin
259: g_debug:=hr_utility.debug_enabled;