82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pay_prf_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_prf_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_prf_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_prf_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin
203: pay_prf_rkd.after_delete
204: (p_range_table_id
205: => p_rec.range_table_id
206: ,p_effective_start_date_o
207: => pay_prf_shd.g_old_rec.effective_start_date
208: ,p_effective_end_date_o
209: => pay_prf_shd.g_old_rec.effective_end_date
210: ,p_range_table_number_o
211: => pay_prf_shd.g_old_rec.range_table_number
205: => p_rec.range_table_id
206: ,p_effective_start_date_o
207: => pay_prf_shd.g_old_rec.effective_start_date
208: ,p_effective_end_date_o
209: => pay_prf_shd.g_old_rec.effective_end_date
210: ,p_range_table_number_o
211: => pay_prf_shd.g_old_rec.range_table_number
212: ,p_row_value_uom_o
213: => pay_prf_shd.g_old_rec.row_value_uom
207: => pay_prf_shd.g_old_rec.effective_start_date
208: ,p_effective_end_date_o
209: => pay_prf_shd.g_old_rec.effective_end_date
210: ,p_range_table_number_o
211: => pay_prf_shd.g_old_rec.range_table_number
212: ,p_row_value_uom_o
213: => pay_prf_shd.g_old_rec.row_value_uom
214: ,p_period_frequency_o
215: => pay_prf_shd.g_old_rec.period_frequency
209: => pay_prf_shd.g_old_rec.effective_end_date
210: ,p_range_table_number_o
211: => pay_prf_shd.g_old_rec.range_table_number
212: ,p_row_value_uom_o
213: => pay_prf_shd.g_old_rec.row_value_uom
214: ,p_period_frequency_o
215: => pay_prf_shd.g_old_rec.period_frequency
216: ,p_earnings_type_o
217: => pay_prf_shd.g_old_rec.earnings_type
211: => pay_prf_shd.g_old_rec.range_table_number
212: ,p_row_value_uom_o
213: => pay_prf_shd.g_old_rec.row_value_uom
214: ,p_period_frequency_o
215: => pay_prf_shd.g_old_rec.period_frequency
216: ,p_earnings_type_o
217: => pay_prf_shd.g_old_rec.earnings_type
218: ,p_business_group_id_o
219: => pay_prf_shd.g_old_rec.business_group_id
213: => pay_prf_shd.g_old_rec.row_value_uom
214: ,p_period_frequency_o
215: => pay_prf_shd.g_old_rec.period_frequency
216: ,p_earnings_type_o
217: => pay_prf_shd.g_old_rec.earnings_type
218: ,p_business_group_id_o
219: => pay_prf_shd.g_old_rec.business_group_id
220: ,p_legislation_code_o
221: => pay_prf_shd.g_old_rec.legislation_code
215: => pay_prf_shd.g_old_rec.period_frequency
216: ,p_earnings_type_o
217: => pay_prf_shd.g_old_rec.earnings_type
218: ,p_business_group_id_o
219: => pay_prf_shd.g_old_rec.business_group_id
220: ,p_legislation_code_o
221: => pay_prf_shd.g_old_rec.legislation_code
222: ,p_last_updated_login_o
223: => pay_prf_shd.g_old_rec.last_updated_login
217: => pay_prf_shd.g_old_rec.earnings_type
218: ,p_business_group_id_o
219: => pay_prf_shd.g_old_rec.business_group_id
220: ,p_legislation_code_o
221: => pay_prf_shd.g_old_rec.legislation_code
222: ,p_last_updated_login_o
223: => pay_prf_shd.g_old_rec.last_updated_login
224: ,p_created_date_o
225: => pay_prf_shd.g_old_rec.created_date
219: => pay_prf_shd.g_old_rec.business_group_id
220: ,p_legislation_code_o
221: => pay_prf_shd.g_old_rec.legislation_code
222: ,p_last_updated_login_o
223: => pay_prf_shd.g_old_rec.last_updated_login
224: ,p_created_date_o
225: => pay_prf_shd.g_old_rec.created_date
226: ,p_object_version_number_o
227: => pay_prf_shd.g_old_rec.object_version_number
221: => pay_prf_shd.g_old_rec.legislation_code
222: ,p_last_updated_login_o
223: => pay_prf_shd.g_old_rec.last_updated_login
224: ,p_created_date_o
225: => pay_prf_shd.g_old_rec.created_date
226: ,p_object_version_number_o
227: => pay_prf_shd.g_old_rec.object_version_number
228: ,p_attribute_category_o
229: => pay_prf_shd.g_old_rec.attribute_category
223: => pay_prf_shd.g_old_rec.last_updated_login
224: ,p_created_date_o
225: => pay_prf_shd.g_old_rec.created_date
226: ,p_object_version_number_o
227: => pay_prf_shd.g_old_rec.object_version_number
228: ,p_attribute_category_o
229: => pay_prf_shd.g_old_rec.attribute_category
230: ,p_attribute1_o
231: => pay_prf_shd.g_old_rec.attribute1
225: => pay_prf_shd.g_old_rec.created_date
226: ,p_object_version_number_o
227: => pay_prf_shd.g_old_rec.object_version_number
228: ,p_attribute_category_o
229: => pay_prf_shd.g_old_rec.attribute_category
230: ,p_attribute1_o
231: => pay_prf_shd.g_old_rec.attribute1
232: ,p_attribute2_o
233: => pay_prf_shd.g_old_rec.attribute2
227: => pay_prf_shd.g_old_rec.object_version_number
228: ,p_attribute_category_o
229: => pay_prf_shd.g_old_rec.attribute_category
230: ,p_attribute1_o
231: => pay_prf_shd.g_old_rec.attribute1
232: ,p_attribute2_o
233: => pay_prf_shd.g_old_rec.attribute2
234: ,p_attribute3_o
235: => pay_prf_shd.g_old_rec.attribute3
229: => pay_prf_shd.g_old_rec.attribute_category
230: ,p_attribute1_o
231: => pay_prf_shd.g_old_rec.attribute1
232: ,p_attribute2_o
233: => pay_prf_shd.g_old_rec.attribute2
234: ,p_attribute3_o
235: => pay_prf_shd.g_old_rec.attribute3
236: ,p_attribute4_o
237: => pay_prf_shd.g_old_rec.attribute4
231: => pay_prf_shd.g_old_rec.attribute1
232: ,p_attribute2_o
233: => pay_prf_shd.g_old_rec.attribute2
234: ,p_attribute3_o
235: => pay_prf_shd.g_old_rec.attribute3
236: ,p_attribute4_o
237: => pay_prf_shd.g_old_rec.attribute4
238: ,p_attribute5_o
239: => pay_prf_shd.g_old_rec.attribute5
233: => pay_prf_shd.g_old_rec.attribute2
234: ,p_attribute3_o
235: => pay_prf_shd.g_old_rec.attribute3
236: ,p_attribute4_o
237: => pay_prf_shd.g_old_rec.attribute4
238: ,p_attribute5_o
239: => pay_prf_shd.g_old_rec.attribute5
240: ,p_attribute6_o
241: => pay_prf_shd.g_old_rec.attribute6
235: => pay_prf_shd.g_old_rec.attribute3
236: ,p_attribute4_o
237: => pay_prf_shd.g_old_rec.attribute4
238: ,p_attribute5_o
239: => pay_prf_shd.g_old_rec.attribute5
240: ,p_attribute6_o
241: => pay_prf_shd.g_old_rec.attribute6
242: ,p_attribute7_o
243: => pay_prf_shd.g_old_rec.attribute7
237: => pay_prf_shd.g_old_rec.attribute4
238: ,p_attribute5_o
239: => pay_prf_shd.g_old_rec.attribute5
240: ,p_attribute6_o
241: => pay_prf_shd.g_old_rec.attribute6
242: ,p_attribute7_o
243: => pay_prf_shd.g_old_rec.attribute7
244: ,p_attribute8_o
245: => pay_prf_shd.g_old_rec.attribute8
239: => pay_prf_shd.g_old_rec.attribute5
240: ,p_attribute6_o
241: => pay_prf_shd.g_old_rec.attribute6
242: ,p_attribute7_o
243: => pay_prf_shd.g_old_rec.attribute7
244: ,p_attribute8_o
245: => pay_prf_shd.g_old_rec.attribute8
246: ,p_attribute9_o
247: => pay_prf_shd.g_old_rec.attribute9
241: => pay_prf_shd.g_old_rec.attribute6
242: ,p_attribute7_o
243: => pay_prf_shd.g_old_rec.attribute7
244: ,p_attribute8_o
245: => pay_prf_shd.g_old_rec.attribute8
246: ,p_attribute9_o
247: => pay_prf_shd.g_old_rec.attribute9
248: ,p_attribute10_o
249: => pay_prf_shd.g_old_rec.attribute10
243: => pay_prf_shd.g_old_rec.attribute7
244: ,p_attribute8_o
245: => pay_prf_shd.g_old_rec.attribute8
246: ,p_attribute9_o
247: => pay_prf_shd.g_old_rec.attribute9
248: ,p_attribute10_o
249: => pay_prf_shd.g_old_rec.attribute10
250: ,p_attribute11_o
251: => pay_prf_shd.g_old_rec.attribute11
245: => pay_prf_shd.g_old_rec.attribute8
246: ,p_attribute9_o
247: => pay_prf_shd.g_old_rec.attribute9
248: ,p_attribute10_o
249: => pay_prf_shd.g_old_rec.attribute10
250: ,p_attribute11_o
251: => pay_prf_shd.g_old_rec.attribute11
252: ,p_attribute12_o
253: => pay_prf_shd.g_old_rec.attribute12
247: => pay_prf_shd.g_old_rec.attribute9
248: ,p_attribute10_o
249: => pay_prf_shd.g_old_rec.attribute10
250: ,p_attribute11_o
251: => pay_prf_shd.g_old_rec.attribute11
252: ,p_attribute12_o
253: => pay_prf_shd.g_old_rec.attribute12
254: ,p_attribute13_o
255: => pay_prf_shd.g_old_rec.attribute13
249: => pay_prf_shd.g_old_rec.attribute10
250: ,p_attribute11_o
251: => pay_prf_shd.g_old_rec.attribute11
252: ,p_attribute12_o
253: => pay_prf_shd.g_old_rec.attribute12
254: ,p_attribute13_o
255: => pay_prf_shd.g_old_rec.attribute13
256: ,p_attribute14_o
257: => pay_prf_shd.g_old_rec.attribute14
251: => pay_prf_shd.g_old_rec.attribute11
252: ,p_attribute12_o
253: => pay_prf_shd.g_old_rec.attribute12
254: ,p_attribute13_o
255: => pay_prf_shd.g_old_rec.attribute13
256: ,p_attribute14_o
257: => pay_prf_shd.g_old_rec.attribute14
258: ,p_attribute15_o
259: => pay_prf_shd.g_old_rec.attribute15
253: => pay_prf_shd.g_old_rec.attribute12
254: ,p_attribute13_o
255: => pay_prf_shd.g_old_rec.attribute13
256: ,p_attribute14_o
257: => pay_prf_shd.g_old_rec.attribute14
258: ,p_attribute15_o
259: => pay_prf_shd.g_old_rec.attribute15
260: ,p_attribute16_o
261: => pay_prf_shd.g_old_rec.attribute16
255: => pay_prf_shd.g_old_rec.attribute13
256: ,p_attribute14_o
257: => pay_prf_shd.g_old_rec.attribute14
258: ,p_attribute15_o
259: => pay_prf_shd.g_old_rec.attribute15
260: ,p_attribute16_o
261: => pay_prf_shd.g_old_rec.attribute16
262: ,p_attribute17_o
263: => pay_prf_shd.g_old_rec.attribute17
257: => pay_prf_shd.g_old_rec.attribute14
258: ,p_attribute15_o
259: => pay_prf_shd.g_old_rec.attribute15
260: ,p_attribute16_o
261: => pay_prf_shd.g_old_rec.attribute16
262: ,p_attribute17_o
263: => pay_prf_shd.g_old_rec.attribute17
264: ,p_attribute18_o
265: => pay_prf_shd.g_old_rec.attribute18
259: => pay_prf_shd.g_old_rec.attribute15
260: ,p_attribute16_o
261: => pay_prf_shd.g_old_rec.attribute16
262: ,p_attribute17_o
263: => pay_prf_shd.g_old_rec.attribute17
264: ,p_attribute18_o
265: => pay_prf_shd.g_old_rec.attribute18
266: ,p_attribute19_o
267: => pay_prf_shd.g_old_rec.attribute19
261: => pay_prf_shd.g_old_rec.attribute16
262: ,p_attribute17_o
263: => pay_prf_shd.g_old_rec.attribute17
264: ,p_attribute18_o
265: => pay_prf_shd.g_old_rec.attribute18
266: ,p_attribute19_o
267: => pay_prf_shd.g_old_rec.attribute19
268: ,p_attribute20_o
269: => pay_prf_shd.g_old_rec.attribute20
263: => pay_prf_shd.g_old_rec.attribute17
264: ,p_attribute18_o
265: => pay_prf_shd.g_old_rec.attribute18
266: ,p_attribute19_o
267: => pay_prf_shd.g_old_rec.attribute19
268: ,p_attribute20_o
269: => pay_prf_shd.g_old_rec.attribute20
270: ,p_attribute21_o
271: => pay_prf_shd.g_old_rec.attribute21
265: => pay_prf_shd.g_old_rec.attribute18
266: ,p_attribute19_o
267: => pay_prf_shd.g_old_rec.attribute19
268: ,p_attribute20_o
269: => pay_prf_shd.g_old_rec.attribute20
270: ,p_attribute21_o
271: => pay_prf_shd.g_old_rec.attribute21
272: ,p_attribute22_o
273: => pay_prf_shd.g_old_rec.attribute22
267: => pay_prf_shd.g_old_rec.attribute19
268: ,p_attribute20_o
269: => pay_prf_shd.g_old_rec.attribute20
270: ,p_attribute21_o
271: => pay_prf_shd.g_old_rec.attribute21
272: ,p_attribute22_o
273: => pay_prf_shd.g_old_rec.attribute22
274: ,p_attribute23_o
275: => pay_prf_shd.g_old_rec.attribute23
269: => pay_prf_shd.g_old_rec.attribute20
270: ,p_attribute21_o
271: => pay_prf_shd.g_old_rec.attribute21
272: ,p_attribute22_o
273: => pay_prf_shd.g_old_rec.attribute22
274: ,p_attribute23_o
275: => pay_prf_shd.g_old_rec.attribute23
276: ,p_attribute24_o
277: => pay_prf_shd.g_old_rec.attribute24
271: => pay_prf_shd.g_old_rec.attribute21
272: ,p_attribute22_o
273: => pay_prf_shd.g_old_rec.attribute22
274: ,p_attribute23_o
275: => pay_prf_shd.g_old_rec.attribute23
276: ,p_attribute24_o
277: => pay_prf_shd.g_old_rec.attribute24
278: ,p_attribute25_o
279: => pay_prf_shd.g_old_rec.attribute25
273: => pay_prf_shd.g_old_rec.attribute22
274: ,p_attribute23_o
275: => pay_prf_shd.g_old_rec.attribute23
276: ,p_attribute24_o
277: => pay_prf_shd.g_old_rec.attribute24
278: ,p_attribute25_o
279: => pay_prf_shd.g_old_rec.attribute25
280: ,p_attribute26_o
281: => pay_prf_shd.g_old_rec.attribute26
275: => pay_prf_shd.g_old_rec.attribute23
276: ,p_attribute24_o
277: => pay_prf_shd.g_old_rec.attribute24
278: ,p_attribute25_o
279: => pay_prf_shd.g_old_rec.attribute25
280: ,p_attribute26_o
281: => pay_prf_shd.g_old_rec.attribute26
282: ,p_attribute27_o
283: => pay_prf_shd.g_old_rec.attribute27
277: => pay_prf_shd.g_old_rec.attribute24
278: ,p_attribute25_o
279: => pay_prf_shd.g_old_rec.attribute25
280: ,p_attribute26_o
281: => pay_prf_shd.g_old_rec.attribute26
282: ,p_attribute27_o
283: => pay_prf_shd.g_old_rec.attribute27
284: ,p_attribute28_o
285: => pay_prf_shd.g_old_rec.attribute28
279: => pay_prf_shd.g_old_rec.attribute25
280: ,p_attribute26_o
281: => pay_prf_shd.g_old_rec.attribute26
282: ,p_attribute27_o
283: => pay_prf_shd.g_old_rec.attribute27
284: ,p_attribute28_o
285: => pay_prf_shd.g_old_rec.attribute28
286: ,p_attribute29_o
287: => pay_prf_shd.g_old_rec.attribute29
281: => pay_prf_shd.g_old_rec.attribute26
282: ,p_attribute27_o
283: => pay_prf_shd.g_old_rec.attribute27
284: ,p_attribute28_o
285: => pay_prf_shd.g_old_rec.attribute28
286: ,p_attribute29_o
287: => pay_prf_shd.g_old_rec.attribute29
288: ,p_attribute30_o
289: => pay_prf_shd.g_old_rec.attribute30
283: => pay_prf_shd.g_old_rec.attribute27
284: ,p_attribute28_o
285: => pay_prf_shd.g_old_rec.attribute28
286: ,p_attribute29_o
287: => pay_prf_shd.g_old_rec.attribute29
288: ,p_attribute30_o
289: => pay_prf_shd.g_old_rec.attribute30
290: ,p_ran_information_category_o
291: => pay_prf_shd.g_old_rec.ran_information_category
285: => pay_prf_shd.g_old_rec.attribute28
286: ,p_attribute29_o
287: => pay_prf_shd.g_old_rec.attribute29
288: ,p_attribute30_o
289: => pay_prf_shd.g_old_rec.attribute30
290: ,p_ran_information_category_o
291: => pay_prf_shd.g_old_rec.ran_information_category
292: ,p_ran_information1_o
293: => pay_prf_shd.g_old_rec.ran_information1
287: => pay_prf_shd.g_old_rec.attribute29
288: ,p_attribute30_o
289: => pay_prf_shd.g_old_rec.attribute30
290: ,p_ran_information_category_o
291: => pay_prf_shd.g_old_rec.ran_information_category
292: ,p_ran_information1_o
293: => pay_prf_shd.g_old_rec.ran_information1
294: ,p_ran_information2_o
295: => pay_prf_shd.g_old_rec.ran_information2
289: => pay_prf_shd.g_old_rec.attribute30
290: ,p_ran_information_category_o
291: => pay_prf_shd.g_old_rec.ran_information_category
292: ,p_ran_information1_o
293: => pay_prf_shd.g_old_rec.ran_information1
294: ,p_ran_information2_o
295: => pay_prf_shd.g_old_rec.ran_information2
296: ,p_ran_information3_o
297: => pay_prf_shd.g_old_rec.ran_information3
291: => pay_prf_shd.g_old_rec.ran_information_category
292: ,p_ran_information1_o
293: => pay_prf_shd.g_old_rec.ran_information1
294: ,p_ran_information2_o
295: => pay_prf_shd.g_old_rec.ran_information2
296: ,p_ran_information3_o
297: => pay_prf_shd.g_old_rec.ran_information3
298: ,p_ran_information4_o
299: => pay_prf_shd.g_old_rec.ran_information4
293: => pay_prf_shd.g_old_rec.ran_information1
294: ,p_ran_information2_o
295: => pay_prf_shd.g_old_rec.ran_information2
296: ,p_ran_information3_o
297: => pay_prf_shd.g_old_rec.ran_information3
298: ,p_ran_information4_o
299: => pay_prf_shd.g_old_rec.ran_information4
300: ,p_ran_information5_o
301: => pay_prf_shd.g_old_rec.ran_information5
295: => pay_prf_shd.g_old_rec.ran_information2
296: ,p_ran_information3_o
297: => pay_prf_shd.g_old_rec.ran_information3
298: ,p_ran_information4_o
299: => pay_prf_shd.g_old_rec.ran_information4
300: ,p_ran_information5_o
301: => pay_prf_shd.g_old_rec.ran_information5
302: ,p_ran_information6_o
303: => pay_prf_shd.g_old_rec.ran_information6
297: => pay_prf_shd.g_old_rec.ran_information3
298: ,p_ran_information4_o
299: => pay_prf_shd.g_old_rec.ran_information4
300: ,p_ran_information5_o
301: => pay_prf_shd.g_old_rec.ran_information5
302: ,p_ran_information6_o
303: => pay_prf_shd.g_old_rec.ran_information6
304: ,p_ran_information7_o
305: => pay_prf_shd.g_old_rec.ran_information7
299: => pay_prf_shd.g_old_rec.ran_information4
300: ,p_ran_information5_o
301: => pay_prf_shd.g_old_rec.ran_information5
302: ,p_ran_information6_o
303: => pay_prf_shd.g_old_rec.ran_information6
304: ,p_ran_information7_o
305: => pay_prf_shd.g_old_rec.ran_information7
306: ,p_ran_information8_o
307: => pay_prf_shd.g_old_rec.ran_information8
301: => pay_prf_shd.g_old_rec.ran_information5
302: ,p_ran_information6_o
303: => pay_prf_shd.g_old_rec.ran_information6
304: ,p_ran_information7_o
305: => pay_prf_shd.g_old_rec.ran_information7
306: ,p_ran_information8_o
307: => pay_prf_shd.g_old_rec.ran_information8
308: ,p_ran_information9_o
309: => pay_prf_shd.g_old_rec.ran_information9
303: => pay_prf_shd.g_old_rec.ran_information6
304: ,p_ran_information7_o
305: => pay_prf_shd.g_old_rec.ran_information7
306: ,p_ran_information8_o
307: => pay_prf_shd.g_old_rec.ran_information8
308: ,p_ran_information9_o
309: => pay_prf_shd.g_old_rec.ran_information9
310: ,p_ran_information10_o
311: => pay_prf_shd.g_old_rec.ran_information10
305: => pay_prf_shd.g_old_rec.ran_information7
306: ,p_ran_information8_o
307: => pay_prf_shd.g_old_rec.ran_information8
308: ,p_ran_information9_o
309: => pay_prf_shd.g_old_rec.ran_information9
310: ,p_ran_information10_o
311: => pay_prf_shd.g_old_rec.ran_information10
312: ,p_ran_information11_o
313: => pay_prf_shd.g_old_rec.ran_information11
307: => pay_prf_shd.g_old_rec.ran_information8
308: ,p_ran_information9_o
309: => pay_prf_shd.g_old_rec.ran_information9
310: ,p_ran_information10_o
311: => pay_prf_shd.g_old_rec.ran_information10
312: ,p_ran_information11_o
313: => pay_prf_shd.g_old_rec.ran_information11
314: ,p_ran_information12_o
315: => pay_prf_shd.g_old_rec.ran_information12
309: => pay_prf_shd.g_old_rec.ran_information9
310: ,p_ran_information10_o
311: => pay_prf_shd.g_old_rec.ran_information10
312: ,p_ran_information11_o
313: => pay_prf_shd.g_old_rec.ran_information11
314: ,p_ran_information12_o
315: => pay_prf_shd.g_old_rec.ran_information12
316: ,p_ran_information13_o
317: => pay_prf_shd.g_old_rec.ran_information13
311: => pay_prf_shd.g_old_rec.ran_information10
312: ,p_ran_information11_o
313: => pay_prf_shd.g_old_rec.ran_information11
314: ,p_ran_information12_o
315: => pay_prf_shd.g_old_rec.ran_information12
316: ,p_ran_information13_o
317: => pay_prf_shd.g_old_rec.ran_information13
318: ,p_ran_information14_o
319: => pay_prf_shd.g_old_rec.ran_information14
313: => pay_prf_shd.g_old_rec.ran_information11
314: ,p_ran_information12_o
315: => pay_prf_shd.g_old_rec.ran_information12
316: ,p_ran_information13_o
317: => pay_prf_shd.g_old_rec.ran_information13
318: ,p_ran_information14_o
319: => pay_prf_shd.g_old_rec.ran_information14
320: ,p_ran_information15_o
321: => pay_prf_shd.g_old_rec.ran_information15
315: => pay_prf_shd.g_old_rec.ran_information12
316: ,p_ran_information13_o
317: => pay_prf_shd.g_old_rec.ran_information13
318: ,p_ran_information14_o
319: => pay_prf_shd.g_old_rec.ran_information14
320: ,p_ran_information15_o
321: => pay_prf_shd.g_old_rec.ran_information15
322: ,p_ran_information16_o
323: => pay_prf_shd.g_old_rec.ran_information16
317: => pay_prf_shd.g_old_rec.ran_information13
318: ,p_ran_information14_o
319: => pay_prf_shd.g_old_rec.ran_information14
320: ,p_ran_information15_o
321: => pay_prf_shd.g_old_rec.ran_information15
322: ,p_ran_information16_o
323: => pay_prf_shd.g_old_rec.ran_information16
324: ,p_ran_information17_o
325: => pay_prf_shd.g_old_rec.ran_information17
319: => pay_prf_shd.g_old_rec.ran_information14
320: ,p_ran_information15_o
321: => pay_prf_shd.g_old_rec.ran_information15
322: ,p_ran_information16_o
323: => pay_prf_shd.g_old_rec.ran_information16
324: ,p_ran_information17_o
325: => pay_prf_shd.g_old_rec.ran_information17
326: ,p_ran_information18_o
327: => pay_prf_shd.g_old_rec.ran_information18
321: => pay_prf_shd.g_old_rec.ran_information15
322: ,p_ran_information16_o
323: => pay_prf_shd.g_old_rec.ran_information16
324: ,p_ran_information17_o
325: => pay_prf_shd.g_old_rec.ran_information17
326: ,p_ran_information18_o
327: => pay_prf_shd.g_old_rec.ran_information18
328: ,p_ran_information19_o
329: => pay_prf_shd.g_old_rec.ran_information19
323: => pay_prf_shd.g_old_rec.ran_information16
324: ,p_ran_information17_o
325: => pay_prf_shd.g_old_rec.ran_information17
326: ,p_ran_information18_o
327: => pay_prf_shd.g_old_rec.ran_information18
328: ,p_ran_information19_o
329: => pay_prf_shd.g_old_rec.ran_information19
330: ,p_ran_information20_o
331: => pay_prf_shd.g_old_rec.ran_information20
325: => pay_prf_shd.g_old_rec.ran_information17
326: ,p_ran_information18_o
327: => pay_prf_shd.g_old_rec.ran_information18
328: ,p_ran_information19_o
329: => pay_prf_shd.g_old_rec.ran_information19
330: ,p_ran_information20_o
331: => pay_prf_shd.g_old_rec.ran_information20
332: ,p_ran_information21_o
333: => pay_prf_shd.g_old_rec.ran_information21
327: => pay_prf_shd.g_old_rec.ran_information18
328: ,p_ran_information19_o
329: => pay_prf_shd.g_old_rec.ran_information19
330: ,p_ran_information20_o
331: => pay_prf_shd.g_old_rec.ran_information20
332: ,p_ran_information21_o
333: => pay_prf_shd.g_old_rec.ran_information21
334: ,p_ran_information22_o
335: => pay_prf_shd.g_old_rec.ran_information22
329: => pay_prf_shd.g_old_rec.ran_information19
330: ,p_ran_information20_o
331: => pay_prf_shd.g_old_rec.ran_information20
332: ,p_ran_information21_o
333: => pay_prf_shd.g_old_rec.ran_information21
334: ,p_ran_information22_o
335: => pay_prf_shd.g_old_rec.ran_information22
336: ,p_ran_information23_o
337: => pay_prf_shd.g_old_rec.ran_information23
331: => pay_prf_shd.g_old_rec.ran_information20
332: ,p_ran_information21_o
333: => pay_prf_shd.g_old_rec.ran_information21
334: ,p_ran_information22_o
335: => pay_prf_shd.g_old_rec.ran_information22
336: ,p_ran_information23_o
337: => pay_prf_shd.g_old_rec.ran_information23
338: ,p_ran_information24_o
339: => pay_prf_shd.g_old_rec.ran_information24
333: => pay_prf_shd.g_old_rec.ran_information21
334: ,p_ran_information22_o
335: => pay_prf_shd.g_old_rec.ran_information22
336: ,p_ran_information23_o
337: => pay_prf_shd.g_old_rec.ran_information23
338: ,p_ran_information24_o
339: => pay_prf_shd.g_old_rec.ran_information24
340: ,p_ran_information25_o
341: => pay_prf_shd.g_old_rec.ran_information25
335: => pay_prf_shd.g_old_rec.ran_information22
336: ,p_ran_information23_o
337: => pay_prf_shd.g_old_rec.ran_information23
338: ,p_ran_information24_o
339: => pay_prf_shd.g_old_rec.ran_information24
340: ,p_ran_information25_o
341: => pay_prf_shd.g_old_rec.ran_information25
342: ,p_ran_information26_o
343: => pay_prf_shd.g_old_rec.ran_information26
337: => pay_prf_shd.g_old_rec.ran_information23
338: ,p_ran_information24_o
339: => pay_prf_shd.g_old_rec.ran_information24
340: ,p_ran_information25_o
341: => pay_prf_shd.g_old_rec.ran_information25
342: ,p_ran_information26_o
343: => pay_prf_shd.g_old_rec.ran_information26
344: ,p_ran_information27_o
345: => pay_prf_shd.g_old_rec.ran_information27
339: => pay_prf_shd.g_old_rec.ran_information24
340: ,p_ran_information25_o
341: => pay_prf_shd.g_old_rec.ran_information25
342: ,p_ran_information26_o
343: => pay_prf_shd.g_old_rec.ran_information26
344: ,p_ran_information27_o
345: => pay_prf_shd.g_old_rec.ran_information27
346: ,p_ran_information28_o
347: => pay_prf_shd.g_old_rec.ran_information28
341: => pay_prf_shd.g_old_rec.ran_information25
342: ,p_ran_information26_o
343: => pay_prf_shd.g_old_rec.ran_information26
344: ,p_ran_information27_o
345: => pay_prf_shd.g_old_rec.ran_information27
346: ,p_ran_information28_o
347: => pay_prf_shd.g_old_rec.ran_information28
348: ,p_ran_information29_o
349: => pay_prf_shd.g_old_rec.ran_information29
343: => pay_prf_shd.g_old_rec.ran_information26
344: ,p_ran_information27_o
345: => pay_prf_shd.g_old_rec.ran_information27
346: ,p_ran_information28_o
347: => pay_prf_shd.g_old_rec.ran_information28
348: ,p_ran_information29_o
349: => pay_prf_shd.g_old_rec.ran_information29
350: ,p_ran_information30_o
351: => pay_prf_shd.g_old_rec.ran_information30
345: => pay_prf_shd.g_old_rec.ran_information27
346: ,p_ran_information28_o
347: => pay_prf_shd.g_old_rec.ran_information28
348: ,p_ran_information29_o
349: => pay_prf_shd.g_old_rec.ran_information29
350: ,p_ran_information30_o
351: => pay_prf_shd.g_old_rec.ran_information30
352: );
353: --
347: => pay_prf_shd.g_old_rec.ran_information28
348: ,p_ran_information29_o
349: => pay_prf_shd.g_old_rec.ran_information29
350: ,p_ran_information30_o
351: => pay_prf_shd.g_old_rec.ran_information30
352: );
353: --
354: exception
355: --
367: -- ----------------------------------------------------------------------------
368: -- |---------------------------------< del >----------------------------------|
369: -- ----------------------------------------------------------------------------
370: Procedure del
371: (p_rec in pay_prf_shd.g_rec_type
372: ) is
373: --
374: l_proc varchar2(72) := g_package||'del';
375: --
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- We must lock the row which we need to delete.
380: --
381: pay_prf_shd.lck
382: (p_rec.range_table_id
383: ,p_rec.object_version_number
384: );
385: --
417: (p_range_table_id in number
418: ,p_object_version_number in number
419: ) is
420: --
421: l_rec pay_prf_shd.g_rec_type;
422: l_proc varchar2(72) := g_package||'del';
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);