APPS.PAY_PRF_DEL dependencies on PAY_PRF_SHD

Line 86: (p_rec in pay_prf_shd.g_rec_type

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

Line 109: pay_prf_shd.constraint_error

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;

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

Line 207: => pay_prf_shd.g_old_rec.effective_start_date

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

Line 209: => pay_prf_shd.g_old_rec.effective_end_date

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

Line 211: => pay_prf_shd.g_old_rec.range_table_number

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

Line 213: => pay_prf_shd.g_old_rec.row_value_uom

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

Line 215: => pay_prf_shd.g_old_rec.period_frequency

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

Line 217: => pay_prf_shd.g_old_rec.earnings_type

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

Line 219: => pay_prf_shd.g_old_rec.business_group_id

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

Line 221: => pay_prf_shd.g_old_rec.legislation_code

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

Line 223: => pay_prf_shd.g_old_rec.last_updated_login

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

Line 225: => pay_prf_shd.g_old_rec.created_date

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

Line 227: => pay_prf_shd.g_old_rec.object_version_number

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

Line 229: => pay_prf_shd.g_old_rec.attribute_category

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

Line 231: => pay_prf_shd.g_old_rec.attribute1

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

Line 233: => pay_prf_shd.g_old_rec.attribute2

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

Line 235: => pay_prf_shd.g_old_rec.attribute3

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

Line 237: => pay_prf_shd.g_old_rec.attribute4

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

Line 239: => pay_prf_shd.g_old_rec.attribute5

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

Line 241: => pay_prf_shd.g_old_rec.attribute6

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

Line 243: => pay_prf_shd.g_old_rec.attribute7

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

Line 245: => pay_prf_shd.g_old_rec.attribute8

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

Line 247: => pay_prf_shd.g_old_rec.attribute9

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

Line 249: => pay_prf_shd.g_old_rec.attribute10

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

Line 251: => pay_prf_shd.g_old_rec.attribute11

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

Line 253: => pay_prf_shd.g_old_rec.attribute12

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

Line 255: => pay_prf_shd.g_old_rec.attribute13

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

Line 257: => pay_prf_shd.g_old_rec.attribute14

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

Line 259: => pay_prf_shd.g_old_rec.attribute15

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

Line 261: => pay_prf_shd.g_old_rec.attribute16

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

Line 263: => pay_prf_shd.g_old_rec.attribute17

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

Line 265: => pay_prf_shd.g_old_rec.attribute18

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

Line 267: => pay_prf_shd.g_old_rec.attribute19

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

Line 269: => pay_prf_shd.g_old_rec.attribute20

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

Line 271: => pay_prf_shd.g_old_rec.attribute21

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

Line 273: => pay_prf_shd.g_old_rec.attribute22

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

Line 275: => pay_prf_shd.g_old_rec.attribute23

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

Line 277: => pay_prf_shd.g_old_rec.attribute24

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

Line 279: => pay_prf_shd.g_old_rec.attribute25

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

Line 281: => pay_prf_shd.g_old_rec.attribute26

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

Line 283: => pay_prf_shd.g_old_rec.attribute27

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

Line 285: => pay_prf_shd.g_old_rec.attribute28

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

Line 287: => pay_prf_shd.g_old_rec.attribute29

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

Line 289: => pay_prf_shd.g_old_rec.attribute30

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

Line 291: => pay_prf_shd.g_old_rec.ran_information_category

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

Line 293: => pay_prf_shd.g_old_rec.ran_information1

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

Line 295: => pay_prf_shd.g_old_rec.ran_information2

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

Line 297: => pay_prf_shd.g_old_rec.ran_information3

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

Line 299: => pay_prf_shd.g_old_rec.ran_information4

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

Line 301: => pay_prf_shd.g_old_rec.ran_information5

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

Line 303: => pay_prf_shd.g_old_rec.ran_information6

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

Line 305: => pay_prf_shd.g_old_rec.ran_information7

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

Line 307: => pay_prf_shd.g_old_rec.ran_information8

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

Line 309: => pay_prf_shd.g_old_rec.ran_information9

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

Line 311: => pay_prf_shd.g_old_rec.ran_information10

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

Line 313: => pay_prf_shd.g_old_rec.ran_information11

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

Line 315: => pay_prf_shd.g_old_rec.ran_information12

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

Line 317: => pay_prf_shd.g_old_rec.ran_information13

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

Line 319: => pay_prf_shd.g_old_rec.ran_information14

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

Line 321: => pay_prf_shd.g_old_rec.ran_information15

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

Line 323: => pay_prf_shd.g_old_rec.ran_information16

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

Line 325: => pay_prf_shd.g_old_rec.ran_information17

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

Line 327: => pay_prf_shd.g_old_rec.ran_information18

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

Line 329: => pay_prf_shd.g_old_rec.ran_information19

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

Line 331: => pay_prf_shd.g_old_rec.ran_information20

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

Line 333: => pay_prf_shd.g_old_rec.ran_information21

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

Line 335: => pay_prf_shd.g_old_rec.ran_information22

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

Line 337: => pay_prf_shd.g_old_rec.ran_information23

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

Line 339: => pay_prf_shd.g_old_rec.ran_information24

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

Line 341: => pay_prf_shd.g_old_rec.ran_information25

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

Line 343: => pay_prf_shd.g_old_rec.ran_information26

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

Line 345: => pay_prf_shd.g_old_rec.ran_information27

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

Line 347: => pay_prf_shd.g_old_rec.ran_information28

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

Line 349: => pay_prf_shd.g_old_rec.ran_information29

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

Line 351: => pay_prf_shd.g_old_rec.ran_information30

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

Line 371: (p_rec in pay_prf_shd.g_rec_type

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

Line 381: pay_prf_shd.lck

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

Line 421: l_rec pay_prf_shd.g_rec_type;

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