82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pay_pbd_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_pbd_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_pbd_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_pbd_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin
203: pay_pbd_rkd.after_delete
204: (p_bal_attribute_default_id
205: => p_rec.bal_attribute_default_id
206: ,p_attribute_id_o
207: => pay_pbd_shd.g_old_rec.attribute_id
208: ,p_balance_dimension_id_o
209: => pay_pbd_shd.g_old_rec.balance_dimension_id
210: ,p_balance_category_id_o
211: => pay_pbd_shd.g_old_rec.balance_category_id
205: => p_rec.bal_attribute_default_id
206: ,p_attribute_id_o
207: => pay_pbd_shd.g_old_rec.attribute_id
208: ,p_balance_dimension_id_o
209: => pay_pbd_shd.g_old_rec.balance_dimension_id
210: ,p_balance_category_id_o
211: => pay_pbd_shd.g_old_rec.balance_category_id
212: ,p_legislation_code_o
213: => pay_pbd_shd.g_old_rec.legislation_code
207: => pay_pbd_shd.g_old_rec.attribute_id
208: ,p_balance_dimension_id_o
209: => pay_pbd_shd.g_old_rec.balance_dimension_id
210: ,p_balance_category_id_o
211: => pay_pbd_shd.g_old_rec.balance_category_id
212: ,p_legislation_code_o
213: => pay_pbd_shd.g_old_rec.legislation_code
214: ,p_business_group_id_o
215: => pay_pbd_shd.g_old_rec.business_group_id
209: => pay_pbd_shd.g_old_rec.balance_dimension_id
210: ,p_balance_category_id_o
211: => pay_pbd_shd.g_old_rec.balance_category_id
212: ,p_legislation_code_o
213: => pay_pbd_shd.g_old_rec.legislation_code
214: ,p_business_group_id_o
215: => pay_pbd_shd.g_old_rec.business_group_id
216: );
217: --
211: => pay_pbd_shd.g_old_rec.balance_category_id
212: ,p_legislation_code_o
213: => pay_pbd_shd.g_old_rec.legislation_code
214: ,p_business_group_id_o
215: => pay_pbd_shd.g_old_rec.business_group_id
216: );
217: --
218: exception
219: --
231: -- ----------------------------------------------------------------------------
232: -- |---------------------------------< del >----------------------------------|
233: -- ----------------------------------------------------------------------------
234: Procedure del
235: (p_rec in pay_pbd_shd.g_rec_type
236: ) is
237: --
238: l_proc varchar2(72) := g_package||'del';
239: --
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- We must lock the row which we need to delete.
244: --
245: pay_pbd_shd.lck
246: (p_rec.bal_attribute_default_id
247: );
248: --
249: -- Call the supporting delete validate operation
276: Procedure del
277: (p_bal_attribute_default_id in number
278: ) is
279: --
280: l_rec pay_pbd_shd.g_rec_type;
281: l_proc varchar2(72) := g_package||'del';
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);