82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pay_bld_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_bld_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_bld_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_bld_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin
203: pay_bld_rkd.after_delete
204: (p_balance_dimension_id
205: => p_rec.balance_dimension_id
206: ,p_business_group_id_o
207: => pay_bld_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_bld_shd.g_old_rec.legislation_code
210: ,p_route_id_o
211: => pay_bld_shd.g_old_rec.route_id
205: => p_rec.balance_dimension_id
206: ,p_business_group_id_o
207: => pay_bld_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_bld_shd.g_old_rec.legislation_code
210: ,p_route_id_o
211: => pay_bld_shd.g_old_rec.route_id
212: ,p_database_item_suffix_o
213: => pay_bld_shd.g_old_rec.database_item_suffix
207: => pay_bld_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_bld_shd.g_old_rec.legislation_code
210: ,p_route_id_o
211: => pay_bld_shd.g_old_rec.route_id
212: ,p_database_item_suffix_o
213: => pay_bld_shd.g_old_rec.database_item_suffix
214: ,p_dimension_name_o
215: => pay_bld_shd.g_old_rec.dimension_name
209: => pay_bld_shd.g_old_rec.legislation_code
210: ,p_route_id_o
211: => pay_bld_shd.g_old_rec.route_id
212: ,p_database_item_suffix_o
213: => pay_bld_shd.g_old_rec.database_item_suffix
214: ,p_dimension_name_o
215: => pay_bld_shd.g_old_rec.dimension_name
216: ,p_dimension_type_o
217: => pay_bld_shd.g_old_rec.dimension_type
211: => pay_bld_shd.g_old_rec.route_id
212: ,p_database_item_suffix_o
213: => pay_bld_shd.g_old_rec.database_item_suffix
214: ,p_dimension_name_o
215: => pay_bld_shd.g_old_rec.dimension_name
216: ,p_dimension_type_o
217: => pay_bld_shd.g_old_rec.dimension_type
218: ,p_description_o
219: => pay_bld_shd.g_old_rec.description
213: => pay_bld_shd.g_old_rec.database_item_suffix
214: ,p_dimension_name_o
215: => pay_bld_shd.g_old_rec.dimension_name
216: ,p_dimension_type_o
217: => pay_bld_shd.g_old_rec.dimension_type
218: ,p_description_o
219: => pay_bld_shd.g_old_rec.description
220: ,p_feed_checking_code_o
221: => pay_bld_shd.g_old_rec.feed_checking_code
215: => pay_bld_shd.g_old_rec.dimension_name
216: ,p_dimension_type_o
217: => pay_bld_shd.g_old_rec.dimension_type
218: ,p_description_o
219: => pay_bld_shd.g_old_rec.description
220: ,p_feed_checking_code_o
221: => pay_bld_shd.g_old_rec.feed_checking_code
222: ,p_legislation_subgroup_o
223: => pay_bld_shd.g_old_rec.legislation_subgroup
217: => pay_bld_shd.g_old_rec.dimension_type
218: ,p_description_o
219: => pay_bld_shd.g_old_rec.description
220: ,p_feed_checking_code_o
221: => pay_bld_shd.g_old_rec.feed_checking_code
222: ,p_legislation_subgroup_o
223: => pay_bld_shd.g_old_rec.legislation_subgroup
224: ,p_payments_flag_o
225: => pay_bld_shd.g_old_rec.payments_flag
219: => pay_bld_shd.g_old_rec.description
220: ,p_feed_checking_code_o
221: => pay_bld_shd.g_old_rec.feed_checking_code
222: ,p_legislation_subgroup_o
223: => pay_bld_shd.g_old_rec.legislation_subgroup
224: ,p_payments_flag_o
225: => pay_bld_shd.g_old_rec.payments_flag
226: ,p_expiry_checking_code_o
227: => pay_bld_shd.g_old_rec.expiry_checking_code
221: => pay_bld_shd.g_old_rec.feed_checking_code
222: ,p_legislation_subgroup_o
223: => pay_bld_shd.g_old_rec.legislation_subgroup
224: ,p_payments_flag_o
225: => pay_bld_shd.g_old_rec.payments_flag
226: ,p_expiry_checking_code_o
227: => pay_bld_shd.g_old_rec.expiry_checking_code
228: ,p_expiry_checking_level_o
229: => pay_bld_shd.g_old_rec.expiry_checking_level
223: => pay_bld_shd.g_old_rec.legislation_subgroup
224: ,p_payments_flag_o
225: => pay_bld_shd.g_old_rec.payments_flag
226: ,p_expiry_checking_code_o
227: => pay_bld_shd.g_old_rec.expiry_checking_code
228: ,p_expiry_checking_level_o
229: => pay_bld_shd.g_old_rec.expiry_checking_level
230: ,p_feed_checking_type_o
231: => pay_bld_shd.g_old_rec.feed_checking_type
225: => pay_bld_shd.g_old_rec.payments_flag
226: ,p_expiry_checking_code_o
227: => pay_bld_shd.g_old_rec.expiry_checking_code
228: ,p_expiry_checking_level_o
229: => pay_bld_shd.g_old_rec.expiry_checking_level
230: ,p_feed_checking_type_o
231: => pay_bld_shd.g_old_rec.feed_checking_type
232: ,p_dimension_level_o
233: => pay_bld_shd.g_old_rec.dimension_level
227: => pay_bld_shd.g_old_rec.expiry_checking_code
228: ,p_expiry_checking_level_o
229: => pay_bld_shd.g_old_rec.expiry_checking_level
230: ,p_feed_checking_type_o
231: => pay_bld_shd.g_old_rec.feed_checking_type
232: ,p_dimension_level_o
233: => pay_bld_shd.g_old_rec.dimension_level
234: ,p_period_type_o
235: => pay_bld_shd.g_old_rec.period_type
229: => pay_bld_shd.g_old_rec.expiry_checking_level
230: ,p_feed_checking_type_o
231: => pay_bld_shd.g_old_rec.feed_checking_type
232: ,p_dimension_level_o
233: => pay_bld_shd.g_old_rec.dimension_level
234: ,p_period_type_o
235: => pay_bld_shd.g_old_rec.period_type
236: ,p_asg_action_balance_dim_id_o
237: => pay_bld_shd.g_old_rec.asg_action_balance_dim_id
231: => pay_bld_shd.g_old_rec.feed_checking_type
232: ,p_dimension_level_o
233: => pay_bld_shd.g_old_rec.dimension_level
234: ,p_period_type_o
235: => pay_bld_shd.g_old_rec.period_type
236: ,p_asg_action_balance_dim_id_o
237: => pay_bld_shd.g_old_rec.asg_action_balance_dim_id
238: ,p_database_item_function_o
239: => pay_bld_shd.g_old_rec.database_item_function
233: => pay_bld_shd.g_old_rec.dimension_level
234: ,p_period_type_o
235: => pay_bld_shd.g_old_rec.period_type
236: ,p_asg_action_balance_dim_id_o
237: => pay_bld_shd.g_old_rec.asg_action_balance_dim_id
238: ,p_database_item_function_o
239: => pay_bld_shd.g_old_rec.database_item_function
240: ,p_save_run_balance_enabled_o
241: => pay_bld_shd.g_old_rec.save_run_balance_enabled
235: => pay_bld_shd.g_old_rec.period_type
236: ,p_asg_action_balance_dim_id_o
237: => pay_bld_shd.g_old_rec.asg_action_balance_dim_id
238: ,p_database_item_function_o
239: => pay_bld_shd.g_old_rec.database_item_function
240: ,p_save_run_balance_enabled_o
241: => pay_bld_shd.g_old_rec.save_run_balance_enabled
242: ,p_start_date_code_o
243: => pay_bld_shd.g_old_rec.start_date_code
237: => pay_bld_shd.g_old_rec.asg_action_balance_dim_id
238: ,p_database_item_function_o
239: => pay_bld_shd.g_old_rec.database_item_function
240: ,p_save_run_balance_enabled_o
241: => pay_bld_shd.g_old_rec.save_run_balance_enabled
242: ,p_start_date_code_o
243: => pay_bld_shd.g_old_rec.start_date_code
244: );
245: --
239: => pay_bld_shd.g_old_rec.database_item_function
240: ,p_save_run_balance_enabled_o
241: => pay_bld_shd.g_old_rec.save_run_balance_enabled
242: ,p_start_date_code_o
243: => pay_bld_shd.g_old_rec.start_date_code
244: );
245: --
246: exception
247: --
259: -- ----------------------------------------------------------------------------
260: -- |---------------------------------< del >----------------------------------|
261: -- ----------------------------------------------------------------------------
262: Procedure del
263: (p_rec in pay_bld_shd.g_rec_type
264: ) is
265: --
266: l_proc varchar2(72) := g_package||'del';
267: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: -- We must lock the row which we need to delete.
272: --
273: pay_bld_shd.lck
274: (p_rec.balance_dimension_id
275: );
276: --
277: -- Call the supporting delete validate operation
304: Procedure del
305: (p_balance_dimension_id in number
306: ) is
307: --
308: l_rec pay_bld_shd.g_rec_type;
309: l_proc varchar2(72) := g_package||'del';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);