82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pay_rcu_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: --
109: pay_rcu_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;
144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in pay_rcu_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin
186: -- Internal Row Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- -----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in pay_rcu_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin
203: pay_rcu_rkd.after_delete
204: (p_retro_component_usage_id
205: => p_rec.retro_component_usage_id
206: ,p_business_group_id_o
207: => pay_rcu_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_rcu_shd.g_old_rec.legislation_code
210: ,p_retro_component_id_o
211: => pay_rcu_shd.g_old_rec.retro_component_id
205: => p_rec.retro_component_usage_id
206: ,p_business_group_id_o
207: => pay_rcu_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_rcu_shd.g_old_rec.legislation_code
210: ,p_retro_component_id_o
211: => pay_rcu_shd.g_old_rec.retro_component_id
212: ,p_creator_id_o
213: => pay_rcu_shd.g_old_rec.creator_id
207: => pay_rcu_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_rcu_shd.g_old_rec.legislation_code
210: ,p_retro_component_id_o
211: => pay_rcu_shd.g_old_rec.retro_component_id
212: ,p_creator_id_o
213: => pay_rcu_shd.g_old_rec.creator_id
214: ,p_creator_type_o
215: => pay_rcu_shd.g_old_rec.creator_type
209: => pay_rcu_shd.g_old_rec.legislation_code
210: ,p_retro_component_id_o
211: => pay_rcu_shd.g_old_rec.retro_component_id
212: ,p_creator_id_o
213: => pay_rcu_shd.g_old_rec.creator_id
214: ,p_creator_type_o
215: => pay_rcu_shd.g_old_rec.creator_type
216: ,p_default_component_o
217: => pay_rcu_shd.g_old_rec.default_component
211: => pay_rcu_shd.g_old_rec.retro_component_id
212: ,p_creator_id_o
213: => pay_rcu_shd.g_old_rec.creator_id
214: ,p_creator_type_o
215: => pay_rcu_shd.g_old_rec.creator_type
216: ,p_default_component_o
217: => pay_rcu_shd.g_old_rec.default_component
218: ,p_reprocess_type_o
219: => pay_rcu_shd.g_old_rec.reprocess_type
213: => pay_rcu_shd.g_old_rec.creator_id
214: ,p_creator_type_o
215: => pay_rcu_shd.g_old_rec.creator_type
216: ,p_default_component_o
217: => pay_rcu_shd.g_old_rec.default_component
218: ,p_reprocess_type_o
219: => pay_rcu_shd.g_old_rec.reprocess_type
220: ,p_object_version_number_o
221: => pay_rcu_shd.g_old_rec.object_version_number
215: => pay_rcu_shd.g_old_rec.creator_type
216: ,p_default_component_o
217: => pay_rcu_shd.g_old_rec.default_component
218: ,p_reprocess_type_o
219: => pay_rcu_shd.g_old_rec.reprocess_type
220: ,p_object_version_number_o
221: => pay_rcu_shd.g_old_rec.object_version_number
222: ,p_replace_run_flag_o
223: => pay_rcu_shd.g_old_rec.replace_run_flag
217: => pay_rcu_shd.g_old_rec.default_component
218: ,p_reprocess_type_o
219: => pay_rcu_shd.g_old_rec.reprocess_type
220: ,p_object_version_number_o
221: => pay_rcu_shd.g_old_rec.object_version_number
222: ,p_replace_run_flag_o
223: => pay_rcu_shd.g_old_rec.replace_run_flag
224: ,p_use_override_dates_o
225: => pay_rcu_shd.g_old_rec.use_override_dates
219: => pay_rcu_shd.g_old_rec.reprocess_type
220: ,p_object_version_number_o
221: => pay_rcu_shd.g_old_rec.object_version_number
222: ,p_replace_run_flag_o
223: => pay_rcu_shd.g_old_rec.replace_run_flag
224: ,p_use_override_dates_o
225: => pay_rcu_shd.g_old_rec.use_override_dates
226: );
227:
221: => pay_rcu_shd.g_old_rec.object_version_number
222: ,p_replace_run_flag_o
223: => pay_rcu_shd.g_old_rec.replace_run_flag
224: ,p_use_override_dates_o
225: => pay_rcu_shd.g_old_rec.use_override_dates
226: );
227:
228: --
229: exception
242: -- ----------------------------------------------------------------------------
243: -- |---------------------------------< del >----------------------------------|
244: -- ----------------------------------------------------------------------------
245: Procedure del
246: (p_rec in pay_rcu_shd.g_rec_type
247: ) is
248: --
249: l_proc varchar2(72) := g_package||'del';
250: --
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- We must lock the row which we need to delete.
255: --
256: pay_rcu_shd.lck
257: (p_rec.retro_component_usage_id
258: ,p_rec.object_version_number
259: );
260: --
289: (p_retro_component_usage_id in number
290: ,p_object_version_number in number
291: ) is
292: --
293: l_rec pay_rcu_shd.g_rec_type;
294: l_proc varchar2(72) := g_package||'del';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);