DBA Data[Home] [Help]

APPS.PAY_BLD_DEL dependencies on PAY_BLD_SHD

Line 86: (p_rec in pay_bld_shd.g_rec_type

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: --

Line 109: pay_bld_shd.constraint_error

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;

Line 148: Procedure pre_delete(p_rec in pay_bld_shd.g_rec_type) is

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

Line 190: Procedure post_delete(p_rec in pay_bld_shd.g_rec_type) is

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

Line 207: => pay_bld_shd.g_old_rec.business_group_id

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

Line 209: => pay_bld_shd.g_old_rec.legislation_code

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

Line 211: => pay_bld_shd.g_old_rec.route_id

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

Line 213: => pay_bld_shd.g_old_rec.database_item_suffix

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

Line 215: => pay_bld_shd.g_old_rec.dimension_name

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

Line 217: => pay_bld_shd.g_old_rec.dimension_type

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

Line 219: => pay_bld_shd.g_old_rec.description

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

Line 221: => pay_bld_shd.g_old_rec.feed_checking_code

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

Line 223: => pay_bld_shd.g_old_rec.legislation_subgroup

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

Line 225: => pay_bld_shd.g_old_rec.payments_flag

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

Line 227: => pay_bld_shd.g_old_rec.expiry_checking_code

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

Line 229: => pay_bld_shd.g_old_rec.expiry_checking_level

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

Line 231: => pay_bld_shd.g_old_rec.feed_checking_type

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

Line 233: => pay_bld_shd.g_old_rec.dimension_level

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

Line 235: => pay_bld_shd.g_old_rec.period_type

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

Line 237: => pay_bld_shd.g_old_rec.asg_action_balance_dim_id

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

Line 239: => pay_bld_shd.g_old_rec.database_item_function

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

Line 241: => pay_bld_shd.g_old_rec.save_run_balance_enabled

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: --

Line 243: => pay_bld_shd.g_old_rec.start_date_code

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: --

Line 263: (p_rec in pay_bld_shd.g_rec_type

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: --

Line 273: pay_bld_shd.lck

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

Line 308: l_rec pay_bld_shd.g_rec_type;

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);