APPS.PAY_PBC_DEL dependencies on PAY_PBC_SHD

Line 54: (p_rec in out nocopy pay_pbc_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_pbc_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 134: (p_rec in out nocopy pay_pbc_shd.g_rec_type

130: -- ----------------------------------------------------------------------------
131: -- |------------------------------< delete_dml >------------------------------|
132: -- ----------------------------------------------------------------------------
133: Procedure delete_dml
134: (p_rec in out nocopy pay_pbc_shd.g_rec_type
135: ,p_effective_date in date
136: ,p_datetrack_mode in varchar2
137: ,p_validation_start_date in date
138: ,p_validation_end_date in date

Line 191: (p_rec in out nocopy pay_pbc_shd.g_rec_type

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure dt_pre_delete
191: (p_rec in out nocopy pay_pbc_shd.g_rec_type
192: ,p_effective_date in date
193: ,p_datetrack_mode in varchar2
194: ,p_validation_start_date in date
195: ,p_validation_end_date in date

Line 206: := pay_pbc_shd.g_old_rec.effective_start_date;

202: --
203: If (p_datetrack_mode <> hr_api.g_zap) then
204: --
205: p_rec.effective_start_date
206: := pay_pbc_shd.g_old_rec.effective_start_date;
207: --
208: If (p_datetrack_mode = hr_api.g_delete) then
209: p_rec.effective_end_date := p_validation_start_date - 1;
210: Else

Line 216: pay_pbc_shd.upd_effective_end_date

212: End If;
213: --
214: -- Update the current effective end date record
215: --
216: pay_pbc_shd.upd_effective_end_date
217: (p_effective_date => p_effective_date
218: ,p_base_key_value => p_rec.balance_category_id
219: ,p_new_effective_end_date => p_rec.effective_end_date
220: ,p_validation_start_date => p_validation_start_date

Line 265: (p_rec in out nocopy pay_pbc_shd.g_rec_type

261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure pre_delete
265: (p_rec in out nocopy pay_pbc_shd.g_rec_type
266: ,p_effective_date in date
267: ,p_datetrack_mode in varchar2
268: ,p_validation_start_date in date
269: ,p_validation_end_date in date

Line 325: (p_rec in pay_pbc_shd.g_rec_type

321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure post_delete
325: (p_rec in pay_pbc_shd.g_rec_type
326: ,p_effective_date in date
327: ,p_datetrack_mode in varchar2
328: ,p_validation_start_date in date
329: ,p_validation_end_date in date

Line 363: => pay_pbc_shd.g_old_rec.category_name

359: => p_rec.effective_end_date
360: ,p_object_version_number
361: => p_rec.object_version_number
362: ,p_category_name_o
363: => pay_pbc_shd.g_old_rec.category_name
364: ,p_effective_start_date_o
365: => pay_pbc_shd.g_old_rec.effective_start_date
366: ,p_effective_end_date_o
367: => pay_pbc_shd.g_old_rec.effective_end_date

Line 365: => pay_pbc_shd.g_old_rec.effective_start_date

361: => p_rec.object_version_number
362: ,p_category_name_o
363: => pay_pbc_shd.g_old_rec.category_name
364: ,p_effective_start_date_o
365: => pay_pbc_shd.g_old_rec.effective_start_date
366: ,p_effective_end_date_o
367: => pay_pbc_shd.g_old_rec.effective_end_date
368: ,p_legislation_code_o
369: => pay_pbc_shd.g_old_rec.legislation_code

Line 367: => pay_pbc_shd.g_old_rec.effective_end_date

363: => pay_pbc_shd.g_old_rec.category_name
364: ,p_effective_start_date_o
365: => pay_pbc_shd.g_old_rec.effective_start_date
366: ,p_effective_end_date_o
367: => pay_pbc_shd.g_old_rec.effective_end_date
368: ,p_legislation_code_o
369: => pay_pbc_shd.g_old_rec.legislation_code
370: ,p_business_group_id_o
371: => pay_pbc_shd.g_old_rec.business_group_id

Line 369: => pay_pbc_shd.g_old_rec.legislation_code

365: => pay_pbc_shd.g_old_rec.effective_start_date
366: ,p_effective_end_date_o
367: => pay_pbc_shd.g_old_rec.effective_end_date
368: ,p_legislation_code_o
369: => pay_pbc_shd.g_old_rec.legislation_code
370: ,p_business_group_id_o
371: => pay_pbc_shd.g_old_rec.business_group_id
372: ,p_save_run_balance_enabled_o
373: => pay_pbc_shd.g_old_rec.save_run_balance_enabled

Line 371: => pay_pbc_shd.g_old_rec.business_group_id

367: => pay_pbc_shd.g_old_rec.effective_end_date
368: ,p_legislation_code_o
369: => pay_pbc_shd.g_old_rec.legislation_code
370: ,p_business_group_id_o
371: => pay_pbc_shd.g_old_rec.business_group_id
372: ,p_save_run_balance_enabled_o
373: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
374: ,p_user_category_name_o
375: => pay_pbc_shd.g_old_rec.user_category_name

Line 373: => pay_pbc_shd.g_old_rec.save_run_balance_enabled

369: => pay_pbc_shd.g_old_rec.legislation_code
370: ,p_business_group_id_o
371: => pay_pbc_shd.g_old_rec.business_group_id
372: ,p_save_run_balance_enabled_o
373: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
374: ,p_user_category_name_o
375: => pay_pbc_shd.g_old_rec.user_category_name
376: ,p_pbc_information_category_o
377: => pay_pbc_shd.g_old_rec.pbc_information_category

Line 375: => pay_pbc_shd.g_old_rec.user_category_name

371: => pay_pbc_shd.g_old_rec.business_group_id
372: ,p_save_run_balance_enabled_o
373: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
374: ,p_user_category_name_o
375: => pay_pbc_shd.g_old_rec.user_category_name
376: ,p_pbc_information_category_o
377: => pay_pbc_shd.g_old_rec.pbc_information_category
378: ,p_pbc_information1_o
379: => pay_pbc_shd.g_old_rec.pbc_information1

Line 377: => pay_pbc_shd.g_old_rec.pbc_information_category

373: => pay_pbc_shd.g_old_rec.save_run_balance_enabled
374: ,p_user_category_name_o
375: => pay_pbc_shd.g_old_rec.user_category_name
376: ,p_pbc_information_category_o
377: => pay_pbc_shd.g_old_rec.pbc_information_category
378: ,p_pbc_information1_o
379: => pay_pbc_shd.g_old_rec.pbc_information1
380: ,p_pbc_information2_o
381: => pay_pbc_shd.g_old_rec.pbc_information2

Line 379: => pay_pbc_shd.g_old_rec.pbc_information1

375: => pay_pbc_shd.g_old_rec.user_category_name
376: ,p_pbc_information_category_o
377: => pay_pbc_shd.g_old_rec.pbc_information_category
378: ,p_pbc_information1_o
379: => pay_pbc_shd.g_old_rec.pbc_information1
380: ,p_pbc_information2_o
381: => pay_pbc_shd.g_old_rec.pbc_information2
382: ,p_pbc_information3_o
383: => pay_pbc_shd.g_old_rec.pbc_information3

Line 381: => pay_pbc_shd.g_old_rec.pbc_information2

377: => pay_pbc_shd.g_old_rec.pbc_information_category
378: ,p_pbc_information1_o
379: => pay_pbc_shd.g_old_rec.pbc_information1
380: ,p_pbc_information2_o
381: => pay_pbc_shd.g_old_rec.pbc_information2
382: ,p_pbc_information3_o
383: => pay_pbc_shd.g_old_rec.pbc_information3
384: ,p_pbc_information4_o
385: => pay_pbc_shd.g_old_rec.pbc_information4

Line 383: => pay_pbc_shd.g_old_rec.pbc_information3

379: => pay_pbc_shd.g_old_rec.pbc_information1
380: ,p_pbc_information2_o
381: => pay_pbc_shd.g_old_rec.pbc_information2
382: ,p_pbc_information3_o
383: => pay_pbc_shd.g_old_rec.pbc_information3
384: ,p_pbc_information4_o
385: => pay_pbc_shd.g_old_rec.pbc_information4
386: ,p_pbc_information5_o
387: => pay_pbc_shd.g_old_rec.pbc_information5

Line 385: => pay_pbc_shd.g_old_rec.pbc_information4

381: => pay_pbc_shd.g_old_rec.pbc_information2
382: ,p_pbc_information3_o
383: => pay_pbc_shd.g_old_rec.pbc_information3
384: ,p_pbc_information4_o
385: => pay_pbc_shd.g_old_rec.pbc_information4
386: ,p_pbc_information5_o
387: => pay_pbc_shd.g_old_rec.pbc_information5
388: ,p_pbc_information6_o
389: => pay_pbc_shd.g_old_rec.pbc_information6

Line 387: => pay_pbc_shd.g_old_rec.pbc_information5

383: => pay_pbc_shd.g_old_rec.pbc_information3
384: ,p_pbc_information4_o
385: => pay_pbc_shd.g_old_rec.pbc_information4
386: ,p_pbc_information5_o
387: => pay_pbc_shd.g_old_rec.pbc_information5
388: ,p_pbc_information6_o
389: => pay_pbc_shd.g_old_rec.pbc_information6
390: ,p_pbc_information7_o
391: => pay_pbc_shd.g_old_rec.pbc_information7

Line 389: => pay_pbc_shd.g_old_rec.pbc_information6

385: => pay_pbc_shd.g_old_rec.pbc_information4
386: ,p_pbc_information5_o
387: => pay_pbc_shd.g_old_rec.pbc_information5
388: ,p_pbc_information6_o
389: => pay_pbc_shd.g_old_rec.pbc_information6
390: ,p_pbc_information7_o
391: => pay_pbc_shd.g_old_rec.pbc_information7
392: ,p_pbc_information8_o
393: => pay_pbc_shd.g_old_rec.pbc_information8

Line 391: => pay_pbc_shd.g_old_rec.pbc_information7

387: => pay_pbc_shd.g_old_rec.pbc_information5
388: ,p_pbc_information6_o
389: => pay_pbc_shd.g_old_rec.pbc_information6
390: ,p_pbc_information7_o
391: => pay_pbc_shd.g_old_rec.pbc_information7
392: ,p_pbc_information8_o
393: => pay_pbc_shd.g_old_rec.pbc_information8
394: ,p_pbc_information9_o
395: => pay_pbc_shd.g_old_rec.pbc_information9

Line 393: => pay_pbc_shd.g_old_rec.pbc_information8

389: => pay_pbc_shd.g_old_rec.pbc_information6
390: ,p_pbc_information7_o
391: => pay_pbc_shd.g_old_rec.pbc_information7
392: ,p_pbc_information8_o
393: => pay_pbc_shd.g_old_rec.pbc_information8
394: ,p_pbc_information9_o
395: => pay_pbc_shd.g_old_rec.pbc_information9
396: ,p_pbc_information10_o
397: => pay_pbc_shd.g_old_rec.pbc_information10

Line 395: => pay_pbc_shd.g_old_rec.pbc_information9

391: => pay_pbc_shd.g_old_rec.pbc_information7
392: ,p_pbc_information8_o
393: => pay_pbc_shd.g_old_rec.pbc_information8
394: ,p_pbc_information9_o
395: => pay_pbc_shd.g_old_rec.pbc_information9
396: ,p_pbc_information10_o
397: => pay_pbc_shd.g_old_rec.pbc_information10
398: ,p_pbc_information11_o
399: => pay_pbc_shd.g_old_rec.pbc_information11

Line 397: => pay_pbc_shd.g_old_rec.pbc_information10

393: => pay_pbc_shd.g_old_rec.pbc_information8
394: ,p_pbc_information9_o
395: => pay_pbc_shd.g_old_rec.pbc_information9
396: ,p_pbc_information10_o
397: => pay_pbc_shd.g_old_rec.pbc_information10
398: ,p_pbc_information11_o
399: => pay_pbc_shd.g_old_rec.pbc_information11
400: ,p_pbc_information12_o
401: => pay_pbc_shd.g_old_rec.pbc_information12

Line 399: => pay_pbc_shd.g_old_rec.pbc_information11

395: => pay_pbc_shd.g_old_rec.pbc_information9
396: ,p_pbc_information10_o
397: => pay_pbc_shd.g_old_rec.pbc_information10
398: ,p_pbc_information11_o
399: => pay_pbc_shd.g_old_rec.pbc_information11
400: ,p_pbc_information12_o
401: => pay_pbc_shd.g_old_rec.pbc_information12
402: ,p_pbc_information13_o
403: => pay_pbc_shd.g_old_rec.pbc_information13

Line 401: => pay_pbc_shd.g_old_rec.pbc_information12

397: => pay_pbc_shd.g_old_rec.pbc_information10
398: ,p_pbc_information11_o
399: => pay_pbc_shd.g_old_rec.pbc_information11
400: ,p_pbc_information12_o
401: => pay_pbc_shd.g_old_rec.pbc_information12
402: ,p_pbc_information13_o
403: => pay_pbc_shd.g_old_rec.pbc_information13
404: ,p_pbc_information14_o
405: => pay_pbc_shd.g_old_rec.pbc_information14

Line 403: => pay_pbc_shd.g_old_rec.pbc_information13

399: => pay_pbc_shd.g_old_rec.pbc_information11
400: ,p_pbc_information12_o
401: => pay_pbc_shd.g_old_rec.pbc_information12
402: ,p_pbc_information13_o
403: => pay_pbc_shd.g_old_rec.pbc_information13
404: ,p_pbc_information14_o
405: => pay_pbc_shd.g_old_rec.pbc_information14
406: ,p_pbc_information15_o
407: => pay_pbc_shd.g_old_rec.pbc_information15

Line 405: => pay_pbc_shd.g_old_rec.pbc_information14

401: => pay_pbc_shd.g_old_rec.pbc_information12
402: ,p_pbc_information13_o
403: => pay_pbc_shd.g_old_rec.pbc_information13
404: ,p_pbc_information14_o
405: => pay_pbc_shd.g_old_rec.pbc_information14
406: ,p_pbc_information15_o
407: => pay_pbc_shd.g_old_rec.pbc_information15
408: ,p_pbc_information16_o
409: => pay_pbc_shd.g_old_rec.pbc_information16

Line 407: => pay_pbc_shd.g_old_rec.pbc_information15

403: => pay_pbc_shd.g_old_rec.pbc_information13
404: ,p_pbc_information14_o
405: => pay_pbc_shd.g_old_rec.pbc_information14
406: ,p_pbc_information15_o
407: => pay_pbc_shd.g_old_rec.pbc_information15
408: ,p_pbc_information16_o
409: => pay_pbc_shd.g_old_rec.pbc_information16
410: ,p_pbc_information17_o
411: => pay_pbc_shd.g_old_rec.pbc_information17

Line 409: => pay_pbc_shd.g_old_rec.pbc_information16

405: => pay_pbc_shd.g_old_rec.pbc_information14
406: ,p_pbc_information15_o
407: => pay_pbc_shd.g_old_rec.pbc_information15
408: ,p_pbc_information16_o
409: => pay_pbc_shd.g_old_rec.pbc_information16
410: ,p_pbc_information17_o
411: => pay_pbc_shd.g_old_rec.pbc_information17
412: ,p_pbc_information18_o
413: => pay_pbc_shd.g_old_rec.pbc_information18

Line 411: => pay_pbc_shd.g_old_rec.pbc_information17

407: => pay_pbc_shd.g_old_rec.pbc_information15
408: ,p_pbc_information16_o
409: => pay_pbc_shd.g_old_rec.pbc_information16
410: ,p_pbc_information17_o
411: => pay_pbc_shd.g_old_rec.pbc_information17
412: ,p_pbc_information18_o
413: => pay_pbc_shd.g_old_rec.pbc_information18
414: ,p_pbc_information19_o
415: => pay_pbc_shd.g_old_rec.pbc_information19

Line 413: => pay_pbc_shd.g_old_rec.pbc_information18

409: => pay_pbc_shd.g_old_rec.pbc_information16
410: ,p_pbc_information17_o
411: => pay_pbc_shd.g_old_rec.pbc_information17
412: ,p_pbc_information18_o
413: => pay_pbc_shd.g_old_rec.pbc_information18
414: ,p_pbc_information19_o
415: => pay_pbc_shd.g_old_rec.pbc_information19
416: ,p_pbc_information20_o
417: => pay_pbc_shd.g_old_rec.pbc_information20

Line 415: => pay_pbc_shd.g_old_rec.pbc_information19

411: => pay_pbc_shd.g_old_rec.pbc_information17
412: ,p_pbc_information18_o
413: => pay_pbc_shd.g_old_rec.pbc_information18
414: ,p_pbc_information19_o
415: => pay_pbc_shd.g_old_rec.pbc_information19
416: ,p_pbc_information20_o
417: => pay_pbc_shd.g_old_rec.pbc_information20
418: ,p_pbc_information21_o
419: => pay_pbc_shd.g_old_rec.pbc_information21

Line 417: => pay_pbc_shd.g_old_rec.pbc_information20

413: => pay_pbc_shd.g_old_rec.pbc_information18
414: ,p_pbc_information19_o
415: => pay_pbc_shd.g_old_rec.pbc_information19
416: ,p_pbc_information20_o
417: => pay_pbc_shd.g_old_rec.pbc_information20
418: ,p_pbc_information21_o
419: => pay_pbc_shd.g_old_rec.pbc_information21
420: ,p_pbc_information22_o
421: => pay_pbc_shd.g_old_rec.pbc_information22

Line 419: => pay_pbc_shd.g_old_rec.pbc_information21

415: => pay_pbc_shd.g_old_rec.pbc_information19
416: ,p_pbc_information20_o
417: => pay_pbc_shd.g_old_rec.pbc_information20
418: ,p_pbc_information21_o
419: => pay_pbc_shd.g_old_rec.pbc_information21
420: ,p_pbc_information22_o
421: => pay_pbc_shd.g_old_rec.pbc_information22
422: ,p_pbc_information23_o
423: => pay_pbc_shd.g_old_rec.pbc_information23

Line 421: => pay_pbc_shd.g_old_rec.pbc_information22

417: => pay_pbc_shd.g_old_rec.pbc_information20
418: ,p_pbc_information21_o
419: => pay_pbc_shd.g_old_rec.pbc_information21
420: ,p_pbc_information22_o
421: => pay_pbc_shd.g_old_rec.pbc_information22
422: ,p_pbc_information23_o
423: => pay_pbc_shd.g_old_rec.pbc_information23
424: ,p_pbc_information24_o
425: => pay_pbc_shd.g_old_rec.pbc_information24

Line 423: => pay_pbc_shd.g_old_rec.pbc_information23

419: => pay_pbc_shd.g_old_rec.pbc_information21
420: ,p_pbc_information22_o
421: => pay_pbc_shd.g_old_rec.pbc_information22
422: ,p_pbc_information23_o
423: => pay_pbc_shd.g_old_rec.pbc_information23
424: ,p_pbc_information24_o
425: => pay_pbc_shd.g_old_rec.pbc_information24
426: ,p_pbc_information25_o
427: => pay_pbc_shd.g_old_rec.pbc_information25

Line 425: => pay_pbc_shd.g_old_rec.pbc_information24

421: => pay_pbc_shd.g_old_rec.pbc_information22
422: ,p_pbc_information23_o
423: => pay_pbc_shd.g_old_rec.pbc_information23
424: ,p_pbc_information24_o
425: => pay_pbc_shd.g_old_rec.pbc_information24
426: ,p_pbc_information25_o
427: => pay_pbc_shd.g_old_rec.pbc_information25
428: ,p_pbc_information26_o
429: => pay_pbc_shd.g_old_rec.pbc_information26

Line 427: => pay_pbc_shd.g_old_rec.pbc_information25

423: => pay_pbc_shd.g_old_rec.pbc_information23
424: ,p_pbc_information24_o
425: => pay_pbc_shd.g_old_rec.pbc_information24
426: ,p_pbc_information25_o
427: => pay_pbc_shd.g_old_rec.pbc_information25
428: ,p_pbc_information26_o
429: => pay_pbc_shd.g_old_rec.pbc_information26
430: ,p_pbc_information27_o
431: => pay_pbc_shd.g_old_rec.pbc_information27

Line 429: => pay_pbc_shd.g_old_rec.pbc_information26

425: => pay_pbc_shd.g_old_rec.pbc_information24
426: ,p_pbc_information25_o
427: => pay_pbc_shd.g_old_rec.pbc_information25
428: ,p_pbc_information26_o
429: => pay_pbc_shd.g_old_rec.pbc_information26
430: ,p_pbc_information27_o
431: => pay_pbc_shd.g_old_rec.pbc_information27
432: ,p_pbc_information28_o
433: => pay_pbc_shd.g_old_rec.pbc_information28

Line 431: => pay_pbc_shd.g_old_rec.pbc_information27

427: => pay_pbc_shd.g_old_rec.pbc_information25
428: ,p_pbc_information26_o
429: => pay_pbc_shd.g_old_rec.pbc_information26
430: ,p_pbc_information27_o
431: => pay_pbc_shd.g_old_rec.pbc_information27
432: ,p_pbc_information28_o
433: => pay_pbc_shd.g_old_rec.pbc_information28
434: ,p_pbc_information29_o
435: => pay_pbc_shd.g_old_rec.pbc_information29

Line 433: => pay_pbc_shd.g_old_rec.pbc_information28

429: => pay_pbc_shd.g_old_rec.pbc_information26
430: ,p_pbc_information27_o
431: => pay_pbc_shd.g_old_rec.pbc_information27
432: ,p_pbc_information28_o
433: => pay_pbc_shd.g_old_rec.pbc_information28
434: ,p_pbc_information29_o
435: => pay_pbc_shd.g_old_rec.pbc_information29
436: ,p_pbc_information30_o
437: => pay_pbc_shd.g_old_rec.pbc_information30

Line 435: => pay_pbc_shd.g_old_rec.pbc_information29

431: => pay_pbc_shd.g_old_rec.pbc_information27
432: ,p_pbc_information28_o
433: => pay_pbc_shd.g_old_rec.pbc_information28
434: ,p_pbc_information29_o
435: => pay_pbc_shd.g_old_rec.pbc_information29
436: ,p_pbc_information30_o
437: => pay_pbc_shd.g_old_rec.pbc_information30
438: ,p_object_version_number_o
439: => pay_pbc_shd.g_old_rec.object_version_number

Line 437: => pay_pbc_shd.g_old_rec.pbc_information30

433: => pay_pbc_shd.g_old_rec.pbc_information28
434: ,p_pbc_information29_o
435: => pay_pbc_shd.g_old_rec.pbc_information29
436: ,p_pbc_information30_o
437: => pay_pbc_shd.g_old_rec.pbc_information30
438: ,p_object_version_number_o
439: => pay_pbc_shd.g_old_rec.object_version_number
440: );
441: --

Line 439: => pay_pbc_shd.g_old_rec.object_version_number

435: => pay_pbc_shd.g_old_rec.pbc_information29
436: ,p_pbc_information30_o
437: => pay_pbc_shd.g_old_rec.pbc_information30
438: ,p_object_version_number_o
439: => pay_pbc_shd.g_old_rec.object_version_number
440: );
441: --
442: exception
443: --

Line 461: ,p_rec in out nocopy pay_pbc_shd.g_rec_type

457: -- ----------------------------------------------------------------------------
458: Procedure del
459: (p_effective_date in date
460: ,p_datetrack_mode in varchar2
461: ,p_rec in out nocopy pay_pbc_shd.g_rec_type
462: ) is
463: --
464: l_proc varchar2(72) := g_package||'del';
465: l_validation_start_date date;

Line 477: pay_pbc_shd.lck

473: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
474: --
475: -- We must lock the row which we need to delete.
476: --
477: pay_pbc_shd.lck
478: (p_effective_date => p_effective_date
479: ,p_datetrack_mode => p_datetrack_mode
480: ,p_balance_category_id => p_rec.balance_category_id
481: ,p_object_version_number => p_rec.object_version_number

Line 546: l_rec pay_pbc_shd.g_rec_type;

542: ,p_effective_start_date out nocopy date
543: ,p_effective_end_date out nocopy date
544: ) is
545: --
546: l_rec pay_pbc_shd.g_rec_type;
547: l_proc varchar2(72) := g_package||'del';
548: --
549: Begin
550: hr_utility.set_location('Entering:'||l_proc, 5);