APPS.PAY_BLT_DEL dependencies on PAY_BLT_SHD

Line 86: (p_rec in pay_blt_shd.g_rec_type

82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pay_blt_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --

Line 94: pay_blt_shd.g_api_dml := true; -- Set the api dml status

90: --
91: Begin
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: --
94: pay_blt_shd.g_api_dml := true; -- Set the api dml status
95: --
96: -- Delete the pay_balance_types row.
97: --
98: delete from pay_balance_types

Line 101: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

97: --
98: delete from pay_balance_types
99: where balance_type_id = p_rec.balance_type_id;
100: --
101: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception

Line 108: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

104: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
109: pay_blt_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

Line 109: pay_blt_shd.constraint_error

105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
109: pay_blt_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;

Line 112: pay_blt_shd.g_api_dml := false; -- Unset the api dml status

108: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
109: pay_blt_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End delete_dml;
115: --
116: -- ----------------------------------------------------------------------------

Line 148: Procedure pre_delete(p_rec in pay_blt_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_blt_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_blt_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_blt_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin

Line 207: => pay_blt_shd.g_old_rec.business_group_id

203: pay_blt_rkd.after_delete
204: (p_balance_type_id
205: => p_rec.balance_type_id
206: ,p_business_group_id_o
207: => pay_blt_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_blt_shd.g_old_rec.legislation_code
210: ,p_currency_code_o
211: => pay_blt_shd.g_old_rec.currency_code

Line 209: => pay_blt_shd.g_old_rec.legislation_code

205: => p_rec.balance_type_id
206: ,p_business_group_id_o
207: => pay_blt_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_blt_shd.g_old_rec.legislation_code
210: ,p_currency_code_o
211: => pay_blt_shd.g_old_rec.currency_code
212: ,p_assignment_remuneration_fl_o
213: => pay_blt_shd.g_old_rec.assignment_remuneration_flag

Line 211: => pay_blt_shd.g_old_rec.currency_code

207: => pay_blt_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => pay_blt_shd.g_old_rec.legislation_code
210: ,p_currency_code_o
211: => pay_blt_shd.g_old_rec.currency_code
212: ,p_assignment_remuneration_fl_o
213: => pay_blt_shd.g_old_rec.assignment_remuneration_flag
214: ,p_balance_name_o
215: => pay_blt_shd.g_old_rec.balance_name

Line 213: => pay_blt_shd.g_old_rec.assignment_remuneration_flag

209: => pay_blt_shd.g_old_rec.legislation_code
210: ,p_currency_code_o
211: => pay_blt_shd.g_old_rec.currency_code
212: ,p_assignment_remuneration_fl_o
213: => pay_blt_shd.g_old_rec.assignment_remuneration_flag
214: ,p_balance_name_o
215: => pay_blt_shd.g_old_rec.balance_name
216: ,p_balance_uom_o
217: => pay_blt_shd.g_old_rec.balance_uom

Line 215: => pay_blt_shd.g_old_rec.balance_name

211: => pay_blt_shd.g_old_rec.currency_code
212: ,p_assignment_remuneration_fl_o
213: => pay_blt_shd.g_old_rec.assignment_remuneration_flag
214: ,p_balance_name_o
215: => pay_blt_shd.g_old_rec.balance_name
216: ,p_balance_uom_o
217: => pay_blt_shd.g_old_rec.balance_uom
218: ,p_comments_o
219: => pay_blt_shd.g_old_rec.comments

Line 217: => pay_blt_shd.g_old_rec.balance_uom

213: => pay_blt_shd.g_old_rec.assignment_remuneration_flag
214: ,p_balance_name_o
215: => pay_blt_shd.g_old_rec.balance_name
216: ,p_balance_uom_o
217: => pay_blt_shd.g_old_rec.balance_uom
218: ,p_comments_o
219: => pay_blt_shd.g_old_rec.comments
220: ,p_legislation_subgroup_o
221: => pay_blt_shd.g_old_rec.legislation_subgroup

Line 219: => pay_blt_shd.g_old_rec.comments

215: => pay_blt_shd.g_old_rec.balance_name
216: ,p_balance_uom_o
217: => pay_blt_shd.g_old_rec.balance_uom
218: ,p_comments_o
219: => pay_blt_shd.g_old_rec.comments
220: ,p_legislation_subgroup_o
221: => pay_blt_shd.g_old_rec.legislation_subgroup
222: ,p_reporting_name_o
223: => pay_blt_shd.g_old_rec.reporting_name

Line 221: => pay_blt_shd.g_old_rec.legislation_subgroup

217: => pay_blt_shd.g_old_rec.balance_uom
218: ,p_comments_o
219: => pay_blt_shd.g_old_rec.comments
220: ,p_legislation_subgroup_o
221: => pay_blt_shd.g_old_rec.legislation_subgroup
222: ,p_reporting_name_o
223: => pay_blt_shd.g_old_rec.reporting_name
224: ,p_attribute_category_o
225: => pay_blt_shd.g_old_rec.attribute_category

Line 223: => pay_blt_shd.g_old_rec.reporting_name

219: => pay_blt_shd.g_old_rec.comments
220: ,p_legislation_subgroup_o
221: => pay_blt_shd.g_old_rec.legislation_subgroup
222: ,p_reporting_name_o
223: => pay_blt_shd.g_old_rec.reporting_name
224: ,p_attribute_category_o
225: => pay_blt_shd.g_old_rec.attribute_category
226: ,p_attribute1_o
227: => pay_blt_shd.g_old_rec.attribute1

Line 225: => pay_blt_shd.g_old_rec.attribute_category

221: => pay_blt_shd.g_old_rec.legislation_subgroup
222: ,p_reporting_name_o
223: => pay_blt_shd.g_old_rec.reporting_name
224: ,p_attribute_category_o
225: => pay_blt_shd.g_old_rec.attribute_category
226: ,p_attribute1_o
227: => pay_blt_shd.g_old_rec.attribute1
228: ,p_attribute2_o
229: => pay_blt_shd.g_old_rec.attribute2

Line 227: => pay_blt_shd.g_old_rec.attribute1

223: => pay_blt_shd.g_old_rec.reporting_name
224: ,p_attribute_category_o
225: => pay_blt_shd.g_old_rec.attribute_category
226: ,p_attribute1_o
227: => pay_blt_shd.g_old_rec.attribute1
228: ,p_attribute2_o
229: => pay_blt_shd.g_old_rec.attribute2
230: ,p_attribute3_o
231: => pay_blt_shd.g_old_rec.attribute3

Line 229: => pay_blt_shd.g_old_rec.attribute2

225: => pay_blt_shd.g_old_rec.attribute_category
226: ,p_attribute1_o
227: => pay_blt_shd.g_old_rec.attribute1
228: ,p_attribute2_o
229: => pay_blt_shd.g_old_rec.attribute2
230: ,p_attribute3_o
231: => pay_blt_shd.g_old_rec.attribute3
232: ,p_attribute4_o
233: => pay_blt_shd.g_old_rec.attribute4

Line 231: => pay_blt_shd.g_old_rec.attribute3

227: => pay_blt_shd.g_old_rec.attribute1
228: ,p_attribute2_o
229: => pay_blt_shd.g_old_rec.attribute2
230: ,p_attribute3_o
231: => pay_blt_shd.g_old_rec.attribute3
232: ,p_attribute4_o
233: => pay_blt_shd.g_old_rec.attribute4
234: ,p_attribute5_o
235: => pay_blt_shd.g_old_rec.attribute5

Line 233: => pay_blt_shd.g_old_rec.attribute4

229: => pay_blt_shd.g_old_rec.attribute2
230: ,p_attribute3_o
231: => pay_blt_shd.g_old_rec.attribute3
232: ,p_attribute4_o
233: => pay_blt_shd.g_old_rec.attribute4
234: ,p_attribute5_o
235: => pay_blt_shd.g_old_rec.attribute5
236: ,p_attribute6_o
237: => pay_blt_shd.g_old_rec.attribute6

Line 235: => pay_blt_shd.g_old_rec.attribute5

231: => pay_blt_shd.g_old_rec.attribute3
232: ,p_attribute4_o
233: => pay_blt_shd.g_old_rec.attribute4
234: ,p_attribute5_o
235: => pay_blt_shd.g_old_rec.attribute5
236: ,p_attribute6_o
237: => pay_blt_shd.g_old_rec.attribute6
238: ,p_attribute7_o
239: => pay_blt_shd.g_old_rec.attribute7

Line 237: => pay_blt_shd.g_old_rec.attribute6

233: => pay_blt_shd.g_old_rec.attribute4
234: ,p_attribute5_o
235: => pay_blt_shd.g_old_rec.attribute5
236: ,p_attribute6_o
237: => pay_blt_shd.g_old_rec.attribute6
238: ,p_attribute7_o
239: => pay_blt_shd.g_old_rec.attribute7
240: ,p_attribute8_o
241: => pay_blt_shd.g_old_rec.attribute8

Line 239: => pay_blt_shd.g_old_rec.attribute7

235: => pay_blt_shd.g_old_rec.attribute5
236: ,p_attribute6_o
237: => pay_blt_shd.g_old_rec.attribute6
238: ,p_attribute7_o
239: => pay_blt_shd.g_old_rec.attribute7
240: ,p_attribute8_o
241: => pay_blt_shd.g_old_rec.attribute8
242: ,p_attribute9_o
243: => pay_blt_shd.g_old_rec.attribute9

Line 241: => pay_blt_shd.g_old_rec.attribute8

237: => pay_blt_shd.g_old_rec.attribute6
238: ,p_attribute7_o
239: => pay_blt_shd.g_old_rec.attribute7
240: ,p_attribute8_o
241: => pay_blt_shd.g_old_rec.attribute8
242: ,p_attribute9_o
243: => pay_blt_shd.g_old_rec.attribute9
244: ,p_attribute10_o
245: => pay_blt_shd.g_old_rec.attribute10

Line 243: => pay_blt_shd.g_old_rec.attribute9

239: => pay_blt_shd.g_old_rec.attribute7
240: ,p_attribute8_o
241: => pay_blt_shd.g_old_rec.attribute8
242: ,p_attribute9_o
243: => pay_blt_shd.g_old_rec.attribute9
244: ,p_attribute10_o
245: => pay_blt_shd.g_old_rec.attribute10
246: ,p_attribute11_o
247: => pay_blt_shd.g_old_rec.attribute11

Line 245: => pay_blt_shd.g_old_rec.attribute10

241: => pay_blt_shd.g_old_rec.attribute8
242: ,p_attribute9_o
243: => pay_blt_shd.g_old_rec.attribute9
244: ,p_attribute10_o
245: => pay_blt_shd.g_old_rec.attribute10
246: ,p_attribute11_o
247: => pay_blt_shd.g_old_rec.attribute11
248: ,p_attribute12_o
249: => pay_blt_shd.g_old_rec.attribute12

Line 247: => pay_blt_shd.g_old_rec.attribute11

243: => pay_blt_shd.g_old_rec.attribute9
244: ,p_attribute10_o
245: => pay_blt_shd.g_old_rec.attribute10
246: ,p_attribute11_o
247: => pay_blt_shd.g_old_rec.attribute11
248: ,p_attribute12_o
249: => pay_blt_shd.g_old_rec.attribute12
250: ,p_attribute13_o
251: => pay_blt_shd.g_old_rec.attribute13

Line 249: => pay_blt_shd.g_old_rec.attribute12

245: => pay_blt_shd.g_old_rec.attribute10
246: ,p_attribute11_o
247: => pay_blt_shd.g_old_rec.attribute11
248: ,p_attribute12_o
249: => pay_blt_shd.g_old_rec.attribute12
250: ,p_attribute13_o
251: => pay_blt_shd.g_old_rec.attribute13
252: ,p_attribute14_o
253: => pay_blt_shd.g_old_rec.attribute14

Line 251: => pay_blt_shd.g_old_rec.attribute13

247: => pay_blt_shd.g_old_rec.attribute11
248: ,p_attribute12_o
249: => pay_blt_shd.g_old_rec.attribute12
250: ,p_attribute13_o
251: => pay_blt_shd.g_old_rec.attribute13
252: ,p_attribute14_o
253: => pay_blt_shd.g_old_rec.attribute14
254: ,p_attribute15_o
255: => pay_blt_shd.g_old_rec.attribute15

Line 253: => pay_blt_shd.g_old_rec.attribute14

249: => pay_blt_shd.g_old_rec.attribute12
250: ,p_attribute13_o
251: => pay_blt_shd.g_old_rec.attribute13
252: ,p_attribute14_o
253: => pay_blt_shd.g_old_rec.attribute14
254: ,p_attribute15_o
255: => pay_blt_shd.g_old_rec.attribute15
256: ,p_attribute16_o
257: => pay_blt_shd.g_old_rec.attribute16

Line 255: => pay_blt_shd.g_old_rec.attribute15

251: => pay_blt_shd.g_old_rec.attribute13
252: ,p_attribute14_o
253: => pay_blt_shd.g_old_rec.attribute14
254: ,p_attribute15_o
255: => pay_blt_shd.g_old_rec.attribute15
256: ,p_attribute16_o
257: => pay_blt_shd.g_old_rec.attribute16
258: ,p_attribute17_o
259: => pay_blt_shd.g_old_rec.attribute17

Line 257: => pay_blt_shd.g_old_rec.attribute16

253: => pay_blt_shd.g_old_rec.attribute14
254: ,p_attribute15_o
255: => pay_blt_shd.g_old_rec.attribute15
256: ,p_attribute16_o
257: => pay_blt_shd.g_old_rec.attribute16
258: ,p_attribute17_o
259: => pay_blt_shd.g_old_rec.attribute17
260: ,p_attribute18_o
261: => pay_blt_shd.g_old_rec.attribute18

Line 259: => pay_blt_shd.g_old_rec.attribute17

255: => pay_blt_shd.g_old_rec.attribute15
256: ,p_attribute16_o
257: => pay_blt_shd.g_old_rec.attribute16
258: ,p_attribute17_o
259: => pay_blt_shd.g_old_rec.attribute17
260: ,p_attribute18_o
261: => pay_blt_shd.g_old_rec.attribute18
262: ,p_attribute19_o
263: => pay_blt_shd.g_old_rec.attribute19

Line 261: => pay_blt_shd.g_old_rec.attribute18

257: => pay_blt_shd.g_old_rec.attribute16
258: ,p_attribute17_o
259: => pay_blt_shd.g_old_rec.attribute17
260: ,p_attribute18_o
261: => pay_blt_shd.g_old_rec.attribute18
262: ,p_attribute19_o
263: => pay_blt_shd.g_old_rec.attribute19
264: ,p_attribute20_o
265: => pay_blt_shd.g_old_rec.attribute20

Line 263: => pay_blt_shd.g_old_rec.attribute19

259: => pay_blt_shd.g_old_rec.attribute17
260: ,p_attribute18_o
261: => pay_blt_shd.g_old_rec.attribute18
262: ,p_attribute19_o
263: => pay_blt_shd.g_old_rec.attribute19
264: ,p_attribute20_o
265: => pay_blt_shd.g_old_rec.attribute20
266: ,p_jurisdiction_level_o
267: => pay_blt_shd.g_old_rec.jurisdiction_level

Line 265: => pay_blt_shd.g_old_rec.attribute20

261: => pay_blt_shd.g_old_rec.attribute18
262: ,p_attribute19_o
263: => pay_blt_shd.g_old_rec.attribute19
264: ,p_attribute20_o
265: => pay_blt_shd.g_old_rec.attribute20
266: ,p_jurisdiction_level_o
267: => pay_blt_shd.g_old_rec.jurisdiction_level
268: ,p_tax_type_o
269: => pay_blt_shd.g_old_rec.tax_type

Line 267: => pay_blt_shd.g_old_rec.jurisdiction_level

263: => pay_blt_shd.g_old_rec.attribute19
264: ,p_attribute20_o
265: => pay_blt_shd.g_old_rec.attribute20
266: ,p_jurisdiction_level_o
267: => pay_blt_shd.g_old_rec.jurisdiction_level
268: ,p_tax_type_o
269: => pay_blt_shd.g_old_rec.tax_type
270: ,p_object_version_number_o
271: => pay_blt_shd.g_old_rec.object_version_number

Line 269: => pay_blt_shd.g_old_rec.tax_type

265: => pay_blt_shd.g_old_rec.attribute20
266: ,p_jurisdiction_level_o
267: => pay_blt_shd.g_old_rec.jurisdiction_level
268: ,p_tax_type_o
269: => pay_blt_shd.g_old_rec.tax_type
270: ,p_object_version_number_o
271: => pay_blt_shd.g_old_rec.object_version_number
272: ,p_balance_category_id_o
273: => pay_blt_shd.g_old_rec.balance_category_id

Line 271: => pay_blt_shd.g_old_rec.object_version_number

267: => pay_blt_shd.g_old_rec.jurisdiction_level
268: ,p_tax_type_o
269: => pay_blt_shd.g_old_rec.tax_type
270: ,p_object_version_number_o
271: => pay_blt_shd.g_old_rec.object_version_number
272: ,p_balance_category_id_o
273: => pay_blt_shd.g_old_rec.balance_category_id
274: ,p_base_balance_type_id_o
275: => pay_blt_shd.g_old_rec.base_balance_type_id

Line 273: => pay_blt_shd.g_old_rec.balance_category_id

269: => pay_blt_shd.g_old_rec.tax_type
270: ,p_object_version_number_o
271: => pay_blt_shd.g_old_rec.object_version_number
272: ,p_balance_category_id_o
273: => pay_blt_shd.g_old_rec.balance_category_id
274: ,p_base_balance_type_id_o
275: => pay_blt_shd.g_old_rec.base_balance_type_id
276: ,p_input_value_id_o
277: => pay_blt_shd.g_old_rec.input_value_id

Line 275: => pay_blt_shd.g_old_rec.base_balance_type_id

271: => pay_blt_shd.g_old_rec.object_version_number
272: ,p_balance_category_id_o
273: => pay_blt_shd.g_old_rec.balance_category_id
274: ,p_base_balance_type_id_o
275: => pay_blt_shd.g_old_rec.base_balance_type_id
276: ,p_input_value_id_o
277: => pay_blt_shd.g_old_rec.input_value_id
278: );
279: --

Line 277: => pay_blt_shd.g_old_rec.input_value_id

273: => pay_blt_shd.g_old_rec.balance_category_id
274: ,p_base_balance_type_id_o
275: => pay_blt_shd.g_old_rec.base_balance_type_id
276: ,p_input_value_id_o
277: => pay_blt_shd.g_old_rec.input_value_id
278: );
279: --
280: exception
281: --

Line 297: (p_rec in pay_blt_shd.g_rec_type

293: -- ----------------------------------------------------------------------------
294: -- |---------------------------------< del >----------------------------------|
295: -- ----------------------------------------------------------------------------
296: Procedure del
297: (p_rec in pay_blt_shd.g_rec_type
298: ) is
299: --
300: l_proc varchar2(72) := g_package||'del';
301: --

Line 307: pay_blt_shd.lck

303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- We must lock the row which we need to delete.
306: --
307: pay_blt_shd.lck
308: (p_rec.balance_type_id
309: ,p_rec.object_version_number
310: );
311: --

Line 348: l_rec pay_blt_shd.g_rec_type;

344: (p_balance_type_id in number
345: ,p_object_version_number in number
346: ) is
347: --
348: l_rec pay_blt_shd.g_rec_type;
349: l_proc varchar2(72) := g_package||'del';
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);