DBA Data[Home] [Help]

APPS.HXC_HRR_DEL dependencies on HXC_HRR_SHD

Line 53: (p_rec in hxc_hrr_shd.g_rec_type

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

Line 81: hxc_hrr_shd.constraint_error

77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: --
81: hxc_hrr_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_hrr_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_hrr_shd.g_rec_type) is
121: --
122: l_proc varchar2(72);
123: --
124: Begin

Line 165: Procedure post_delete(p_rec in hxc_hrr_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_hrr_shd.g_rec_type) is
166: --
167: l_proc varchar2(72);
168: --
169: Begin

Line 180: => hxc_hrr_shd.g_old_rec.name

176: hxc_hrr_rkd.after_delete
177: (p_resource_rule_id
178: => p_rec.resource_rule_id
179: ,p_name_o
180: => hxc_hrr_shd.g_old_rec.name
181: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
182: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
183: ,p_eligibility_criteria_type_o
184: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type

Line 184: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type

180: => hxc_hrr_shd.g_old_rec.name
181: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
182: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
183: ,p_eligibility_criteria_type_o
184: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type
185: ,p_eligibility_criteria_id_o
186: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id
187: ,p_pref_hierarchy_id_o
188: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id

Line 186: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id

182: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
183: ,p_eligibility_criteria_type_o
184: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type
185: ,p_eligibility_criteria_id_o
186: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id
187: ,p_pref_hierarchy_id_o
188: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id
189: ,p_rule_evaluation_order_o
190: => hxc_hrr_shd.g_old_rec.rule_evaluation_order

Line 188: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id

184: => hxc_hrr_shd.g_old_rec.eligibility_criteria_type
185: ,p_eligibility_criteria_id_o
186: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id
187: ,p_pref_hierarchy_id_o
188: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id
189: ,p_rule_evaluation_order_o
190: => hxc_hrr_shd.g_old_rec.rule_evaluation_order
191: ,p_resource_type_o
192: => hxc_hrr_shd.g_old_rec.resource_type

Line 190: => hxc_hrr_shd.g_old_rec.rule_evaluation_order

186: => hxc_hrr_shd.g_old_rec.eligibility_criteria_id
187: ,p_pref_hierarchy_id_o
188: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id
189: ,p_rule_evaluation_order_o
190: => hxc_hrr_shd.g_old_rec.rule_evaluation_order
191: ,p_resource_type_o
192: => hxc_hrr_shd.g_old_rec.resource_type
193: ,p_start_date_o
194: => hxc_hrr_shd.g_old_rec.start_date

Line 192: => hxc_hrr_shd.g_old_rec.resource_type

188: => hxc_hrr_shd.g_old_rec.pref_hierarchy_id
189: ,p_rule_evaluation_order_o
190: => hxc_hrr_shd.g_old_rec.rule_evaluation_order
191: ,p_resource_type_o
192: => hxc_hrr_shd.g_old_rec.resource_type
193: ,p_start_date_o
194: => hxc_hrr_shd.g_old_rec.start_date
195: ,p_end_date_o
196: => hxc_hrr_shd.g_old_rec.end_date

Line 194: => hxc_hrr_shd.g_old_rec.start_date

190: => hxc_hrr_shd.g_old_rec.rule_evaluation_order
191: ,p_resource_type_o
192: => hxc_hrr_shd.g_old_rec.resource_type
193: ,p_start_date_o
194: => hxc_hrr_shd.g_old_rec.start_date
195: ,p_end_date_o
196: => hxc_hrr_shd.g_old_rec.end_date
197: ,p_object_version_number_o
198: => hxc_hrr_shd.g_old_rec.object_version_number

Line 196: => hxc_hrr_shd.g_old_rec.end_date

192: => hxc_hrr_shd.g_old_rec.resource_type
193: ,p_start_date_o
194: => hxc_hrr_shd.g_old_rec.start_date
195: ,p_end_date_o
196: => hxc_hrr_shd.g_old_rec.end_date
197: ,p_object_version_number_o
198: => hxc_hrr_shd.g_old_rec.object_version_number
199: );
200: --

Line 198: => hxc_hrr_shd.g_old_rec.object_version_number

194: => hxc_hrr_shd.g_old_rec.start_date
195: ,p_end_date_o
196: => hxc_hrr_shd.g_old_rec.end_date
197: ,p_object_version_number_o
198: => hxc_hrr_shd.g_old_rec.object_version_number
199: );
200: --
201: exception
202: --

Line 220: (p_rec in hxc_hrr_shd.g_rec_type

216: -- ----------------------------------------------------------------------------
217: -- |---------------------------------< del >----------------------------------|
218: -- ----------------------------------------------------------------------------
219: Procedure del
220: (p_rec in hxc_hrr_shd.g_rec_type
221: ) is
222: --
223: l_proc varchar2(72);
224: --

Line 234: hxc_hrr_shd.lck

230: end if;
231: --
232: -- We must lock the row which we need to delete.
233: --
234: hxc_hrr_shd.lck
235: (p_rec.resource_rule_id
236: ,p_rec.object_version_number
237: );
238: --

Line 265: l_rec hxc_hrr_shd.g_rec_type;

261: (p_resource_rule_id in number
262: ,p_object_version_number in number
263: ) is
264: --
265: l_rec hxc_hrr_shd.g_rec_type;
266: l_proc varchar2(72);
267: --
268: Begin
269: g_debug:=hr_utility.debug_enabled;