APPS.PAY_PRT_DEL dependencies on PAY_PRT_SHD

Line 54: (p_rec in out nocopy pay_prt_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_prt_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 129: (p_rec in out nocopy pay_prt_shd.g_rec_type

125: -- ----------------------------------------------------------------------------
126: -- |------------------------------< delete_dml >------------------------------|
127: -- ----------------------------------------------------------------------------
128: Procedure delete_dml
129: (p_rec in out nocopy pay_prt_shd.g_rec_type
130: ,p_effective_date in date
131: ,p_datetrack_mode in varchar2
132: ,p_validation_start_date in date
133: ,p_validation_end_date in date

Line 186: (p_rec in out nocopy pay_prt_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure dt_pre_delete
186: (p_rec in out nocopy pay_prt_shd.g_rec_type
187: ,p_effective_date in date
188: ,p_datetrack_mode in varchar2
189: ,p_validation_start_date in date
190: ,p_validation_end_date in date

Line 201: := pay_prt_shd.g_old_rec.effective_start_date;

197: --
198: If (p_datetrack_mode <> hr_api.g_zap) then
199: --
200: p_rec.effective_start_date
201: := pay_prt_shd.g_old_rec.effective_start_date;
202: --
203: If (p_datetrack_mode = hr_api.g_delete) then
204: p_rec.effective_end_date := p_validation_start_date - 1;
205: Else

Line 211: pay_prt_shd.upd_effective_end_date

207: End If;
208: --
209: -- Update the current effective end date record
210: --
211: pay_prt_shd.upd_effective_end_date
212: (p_effective_date => p_effective_date
213: ,p_base_key_value => p_rec.run_type_id
214: ,p_new_effective_end_date => p_rec.effective_end_date
215: ,p_validation_start_date => p_validation_start_date

Line 260: (p_rec in out nocopy pay_prt_shd.g_rec_type

256: --
257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure pre_delete
260: (p_rec in out nocopy pay_prt_shd.g_rec_type
261: ,p_effective_date in date
262: ,p_datetrack_mode in varchar2
263: ,p_validation_start_date in date
264: ,p_validation_end_date in date

Line 320: (p_rec in pay_prt_shd.g_rec_type

316: --
317: -- {End Of Comments}
318: -- ----------------------------------------------------------------------------
319: Procedure post_delete
320: (p_rec in pay_prt_shd.g_rec_type
321: ,p_effective_date in date
322: ,p_datetrack_mode in varchar2
323: ,p_validation_start_date in date
324: ,p_validation_end_date in date

Line 360: => pay_prt_shd.g_old_rec.run_type_name

356: => p_rec.effective_end_date
357: ,p_object_version_number
358: => p_rec.object_version_number
359: ,p_run_type_name_o
360: => pay_prt_shd.g_old_rec.run_type_name
361: ,p_run_method_o
362: => pay_prt_shd.g_old_rec.run_method
363: ,p_effective_start_date_o
364: => pay_prt_shd.g_old_rec.effective_start_date

Line 362: => pay_prt_shd.g_old_rec.run_method

358: => p_rec.object_version_number
359: ,p_run_type_name_o
360: => pay_prt_shd.g_old_rec.run_type_name
361: ,p_run_method_o
362: => pay_prt_shd.g_old_rec.run_method
363: ,p_effective_start_date_o
364: => pay_prt_shd.g_old_rec.effective_start_date
365: ,p_effective_end_date_o
366: => pay_prt_shd.g_old_rec.effective_end_date

Line 364: => pay_prt_shd.g_old_rec.effective_start_date

360: => pay_prt_shd.g_old_rec.run_type_name
361: ,p_run_method_o
362: => pay_prt_shd.g_old_rec.run_method
363: ,p_effective_start_date_o
364: => pay_prt_shd.g_old_rec.effective_start_date
365: ,p_effective_end_date_o
366: => pay_prt_shd.g_old_rec.effective_end_date
367: ,p_business_group_id_o
368: => pay_prt_shd.g_old_rec.business_group_id

Line 366: => pay_prt_shd.g_old_rec.effective_end_date

362: => pay_prt_shd.g_old_rec.run_method
363: ,p_effective_start_date_o
364: => pay_prt_shd.g_old_rec.effective_start_date
365: ,p_effective_end_date_o
366: => pay_prt_shd.g_old_rec.effective_end_date
367: ,p_business_group_id_o
368: => pay_prt_shd.g_old_rec.business_group_id
369: ,p_legislation_code_o
370: => pay_prt_shd.g_old_rec.legislation_code

Line 368: => pay_prt_shd.g_old_rec.business_group_id

364: => pay_prt_shd.g_old_rec.effective_start_date
365: ,p_effective_end_date_o
366: => pay_prt_shd.g_old_rec.effective_end_date
367: ,p_business_group_id_o
368: => pay_prt_shd.g_old_rec.business_group_id
369: ,p_legislation_code_o
370: => pay_prt_shd.g_old_rec.legislation_code
371: ,p_shortname_o
372: => pay_prt_shd.g_old_rec.shortname

Line 370: => pay_prt_shd.g_old_rec.legislation_code

366: => pay_prt_shd.g_old_rec.effective_end_date
367: ,p_business_group_id_o
368: => pay_prt_shd.g_old_rec.business_group_id
369: ,p_legislation_code_o
370: => pay_prt_shd.g_old_rec.legislation_code
371: ,p_shortname_o
372: => pay_prt_shd.g_old_rec.shortname
373: ,p_srs_flag_o
374: => pay_prt_shd.g_old_rec.srs_flag

Line 372: => pay_prt_shd.g_old_rec.shortname

368: => pay_prt_shd.g_old_rec.business_group_id
369: ,p_legislation_code_o
370: => pay_prt_shd.g_old_rec.legislation_code
371: ,p_shortname_o
372: => pay_prt_shd.g_old_rec.shortname
373: ,p_srs_flag_o
374: => pay_prt_shd.g_old_rec.srs_flag
375: ,p_run_information_category_o
376: => pay_prt_shd.g_old_rec.run_information_category

Line 374: => pay_prt_shd.g_old_rec.srs_flag

370: => pay_prt_shd.g_old_rec.legislation_code
371: ,p_shortname_o
372: => pay_prt_shd.g_old_rec.shortname
373: ,p_srs_flag_o
374: => pay_prt_shd.g_old_rec.srs_flag
375: ,p_run_information_category_o
376: => pay_prt_shd.g_old_rec.run_information_category
377: ,p_run_information1_o
378: => pay_prt_shd.g_old_rec.run_information1

Line 376: => pay_prt_shd.g_old_rec.run_information_category

372: => pay_prt_shd.g_old_rec.shortname
373: ,p_srs_flag_o
374: => pay_prt_shd.g_old_rec.srs_flag
375: ,p_run_information_category_o
376: => pay_prt_shd.g_old_rec.run_information_category
377: ,p_run_information1_o
378: => pay_prt_shd.g_old_rec.run_information1
379: ,p_run_information2_o
380: => pay_prt_shd.g_old_rec.run_information2

Line 378: => pay_prt_shd.g_old_rec.run_information1

374: => pay_prt_shd.g_old_rec.srs_flag
375: ,p_run_information_category_o
376: => pay_prt_shd.g_old_rec.run_information_category
377: ,p_run_information1_o
378: => pay_prt_shd.g_old_rec.run_information1
379: ,p_run_information2_o
380: => pay_prt_shd.g_old_rec.run_information2
381: ,p_run_information3_o
382: => pay_prt_shd.g_old_rec.run_information3

Line 380: => pay_prt_shd.g_old_rec.run_information2

376: => pay_prt_shd.g_old_rec.run_information_category
377: ,p_run_information1_o
378: => pay_prt_shd.g_old_rec.run_information1
379: ,p_run_information2_o
380: => pay_prt_shd.g_old_rec.run_information2
381: ,p_run_information3_o
382: => pay_prt_shd.g_old_rec.run_information3
383: ,p_run_information4_o
384: => pay_prt_shd.g_old_rec.run_information4

Line 382: => pay_prt_shd.g_old_rec.run_information3

378: => pay_prt_shd.g_old_rec.run_information1
379: ,p_run_information2_o
380: => pay_prt_shd.g_old_rec.run_information2
381: ,p_run_information3_o
382: => pay_prt_shd.g_old_rec.run_information3
383: ,p_run_information4_o
384: => pay_prt_shd.g_old_rec.run_information4
385: ,p_run_information5_o
386: => pay_prt_shd.g_old_rec.run_information5

Line 384: => pay_prt_shd.g_old_rec.run_information4

380: => pay_prt_shd.g_old_rec.run_information2
381: ,p_run_information3_o
382: => pay_prt_shd.g_old_rec.run_information3
383: ,p_run_information4_o
384: => pay_prt_shd.g_old_rec.run_information4
385: ,p_run_information5_o
386: => pay_prt_shd.g_old_rec.run_information5
387: ,p_run_information6_o
388: => pay_prt_shd.g_old_rec.run_information6

Line 386: => pay_prt_shd.g_old_rec.run_information5

382: => pay_prt_shd.g_old_rec.run_information3
383: ,p_run_information4_o
384: => pay_prt_shd.g_old_rec.run_information4
385: ,p_run_information5_o
386: => pay_prt_shd.g_old_rec.run_information5
387: ,p_run_information6_o
388: => pay_prt_shd.g_old_rec.run_information6
389: ,p_run_information7_o
390: => pay_prt_shd.g_old_rec.run_information7

Line 388: => pay_prt_shd.g_old_rec.run_information6

384: => pay_prt_shd.g_old_rec.run_information4
385: ,p_run_information5_o
386: => pay_prt_shd.g_old_rec.run_information5
387: ,p_run_information6_o
388: => pay_prt_shd.g_old_rec.run_information6
389: ,p_run_information7_o
390: => pay_prt_shd.g_old_rec.run_information7
391: ,p_run_information8_o
392: => pay_prt_shd.g_old_rec.run_information8

Line 390: => pay_prt_shd.g_old_rec.run_information7

386: => pay_prt_shd.g_old_rec.run_information5
387: ,p_run_information6_o
388: => pay_prt_shd.g_old_rec.run_information6
389: ,p_run_information7_o
390: => pay_prt_shd.g_old_rec.run_information7
391: ,p_run_information8_o
392: => pay_prt_shd.g_old_rec.run_information8
393: ,p_run_information9_o
394: => pay_prt_shd.g_old_rec.run_information9

Line 392: => pay_prt_shd.g_old_rec.run_information8

388: => pay_prt_shd.g_old_rec.run_information6
389: ,p_run_information7_o
390: => pay_prt_shd.g_old_rec.run_information7
391: ,p_run_information8_o
392: => pay_prt_shd.g_old_rec.run_information8
393: ,p_run_information9_o
394: => pay_prt_shd.g_old_rec.run_information9
395: ,p_run_information10_o
396: => pay_prt_shd.g_old_rec.run_information10

Line 394: => pay_prt_shd.g_old_rec.run_information9

390: => pay_prt_shd.g_old_rec.run_information7
391: ,p_run_information8_o
392: => pay_prt_shd.g_old_rec.run_information8
393: ,p_run_information9_o
394: => pay_prt_shd.g_old_rec.run_information9
395: ,p_run_information10_o
396: => pay_prt_shd.g_old_rec.run_information10
397: ,p_run_information11_o
398: => pay_prt_shd.g_old_rec.run_information11

Line 396: => pay_prt_shd.g_old_rec.run_information10

392: => pay_prt_shd.g_old_rec.run_information8
393: ,p_run_information9_o
394: => pay_prt_shd.g_old_rec.run_information9
395: ,p_run_information10_o
396: => pay_prt_shd.g_old_rec.run_information10
397: ,p_run_information11_o
398: => pay_prt_shd.g_old_rec.run_information11
399: ,p_run_information12_o
400: => pay_prt_shd.g_old_rec.run_information12

Line 398: => pay_prt_shd.g_old_rec.run_information11

394: => pay_prt_shd.g_old_rec.run_information9
395: ,p_run_information10_o
396: => pay_prt_shd.g_old_rec.run_information10
397: ,p_run_information11_o
398: => pay_prt_shd.g_old_rec.run_information11
399: ,p_run_information12_o
400: => pay_prt_shd.g_old_rec.run_information12
401: ,p_run_information13_o
402: => pay_prt_shd.g_old_rec.run_information13

Line 400: => pay_prt_shd.g_old_rec.run_information12

396: => pay_prt_shd.g_old_rec.run_information10
397: ,p_run_information11_o
398: => pay_prt_shd.g_old_rec.run_information11
399: ,p_run_information12_o
400: => pay_prt_shd.g_old_rec.run_information12
401: ,p_run_information13_o
402: => pay_prt_shd.g_old_rec.run_information13
403: ,p_run_information14_o
404: => pay_prt_shd.g_old_rec.run_information14

Line 402: => pay_prt_shd.g_old_rec.run_information13

398: => pay_prt_shd.g_old_rec.run_information11
399: ,p_run_information12_o
400: => pay_prt_shd.g_old_rec.run_information12
401: ,p_run_information13_o
402: => pay_prt_shd.g_old_rec.run_information13
403: ,p_run_information14_o
404: => pay_prt_shd.g_old_rec.run_information14
405: ,p_run_information15_o
406: => pay_prt_shd.g_old_rec.run_information15

Line 404: => pay_prt_shd.g_old_rec.run_information14

400: => pay_prt_shd.g_old_rec.run_information12
401: ,p_run_information13_o
402: => pay_prt_shd.g_old_rec.run_information13
403: ,p_run_information14_o
404: => pay_prt_shd.g_old_rec.run_information14
405: ,p_run_information15_o
406: => pay_prt_shd.g_old_rec.run_information15
407: ,p_run_information16_o
408: => pay_prt_shd.g_old_rec.run_information16

Line 406: => pay_prt_shd.g_old_rec.run_information15

402: => pay_prt_shd.g_old_rec.run_information13
403: ,p_run_information14_o
404: => pay_prt_shd.g_old_rec.run_information14
405: ,p_run_information15_o
406: => pay_prt_shd.g_old_rec.run_information15
407: ,p_run_information16_o
408: => pay_prt_shd.g_old_rec.run_information16
409: ,p_run_information17_o
410: => pay_prt_shd.g_old_rec.run_information17

Line 408: => pay_prt_shd.g_old_rec.run_information16

404: => pay_prt_shd.g_old_rec.run_information14
405: ,p_run_information15_o
406: => pay_prt_shd.g_old_rec.run_information15
407: ,p_run_information16_o
408: => pay_prt_shd.g_old_rec.run_information16
409: ,p_run_information17_o
410: => pay_prt_shd.g_old_rec.run_information17
411: ,p_run_information18_o
412: => pay_prt_shd.g_old_rec.run_information18

Line 410: => pay_prt_shd.g_old_rec.run_information17

406: => pay_prt_shd.g_old_rec.run_information15
407: ,p_run_information16_o
408: => pay_prt_shd.g_old_rec.run_information16
409: ,p_run_information17_o
410: => pay_prt_shd.g_old_rec.run_information17
411: ,p_run_information18_o
412: => pay_prt_shd.g_old_rec.run_information18
413: ,p_run_information19_o
414: => pay_prt_shd.g_old_rec.run_information19

Line 412: => pay_prt_shd.g_old_rec.run_information18

408: => pay_prt_shd.g_old_rec.run_information16
409: ,p_run_information17_o
410: => pay_prt_shd.g_old_rec.run_information17
411: ,p_run_information18_o
412: => pay_prt_shd.g_old_rec.run_information18
413: ,p_run_information19_o
414: => pay_prt_shd.g_old_rec.run_information19
415: ,p_run_information20_o
416: => pay_prt_shd.g_old_rec.run_information20

Line 414: => pay_prt_shd.g_old_rec.run_information19

410: => pay_prt_shd.g_old_rec.run_information17
411: ,p_run_information18_o
412: => pay_prt_shd.g_old_rec.run_information18
413: ,p_run_information19_o
414: => pay_prt_shd.g_old_rec.run_information19
415: ,p_run_information20_o
416: => pay_prt_shd.g_old_rec.run_information20
417: ,p_run_information21_o
418: => pay_prt_shd.g_old_rec.run_information21

Line 416: => pay_prt_shd.g_old_rec.run_information20

412: => pay_prt_shd.g_old_rec.run_information18
413: ,p_run_information19_o
414: => pay_prt_shd.g_old_rec.run_information19
415: ,p_run_information20_o
416: => pay_prt_shd.g_old_rec.run_information20
417: ,p_run_information21_o
418: => pay_prt_shd.g_old_rec.run_information21
419: ,p_run_information22_o
420: => pay_prt_shd.g_old_rec.run_information22

Line 418: => pay_prt_shd.g_old_rec.run_information21

414: => pay_prt_shd.g_old_rec.run_information19
415: ,p_run_information20_o
416: => pay_prt_shd.g_old_rec.run_information20
417: ,p_run_information21_o
418: => pay_prt_shd.g_old_rec.run_information21
419: ,p_run_information22_o
420: => pay_prt_shd.g_old_rec.run_information22
421: ,p_run_information23_o
422: => pay_prt_shd.g_old_rec.run_information23

Line 420: => pay_prt_shd.g_old_rec.run_information22

416: => pay_prt_shd.g_old_rec.run_information20
417: ,p_run_information21_o
418: => pay_prt_shd.g_old_rec.run_information21
419: ,p_run_information22_o
420: => pay_prt_shd.g_old_rec.run_information22
421: ,p_run_information23_o
422: => pay_prt_shd.g_old_rec.run_information23
423: ,p_run_information24_o
424: => pay_prt_shd.g_old_rec.run_information24

Line 422: => pay_prt_shd.g_old_rec.run_information23

418: => pay_prt_shd.g_old_rec.run_information21
419: ,p_run_information22_o
420: => pay_prt_shd.g_old_rec.run_information22
421: ,p_run_information23_o
422: => pay_prt_shd.g_old_rec.run_information23
423: ,p_run_information24_o
424: => pay_prt_shd.g_old_rec.run_information24
425: ,p_run_information25_o
426: => pay_prt_shd.g_old_rec.run_information25

Line 424: => pay_prt_shd.g_old_rec.run_information24

420: => pay_prt_shd.g_old_rec.run_information22
421: ,p_run_information23_o
422: => pay_prt_shd.g_old_rec.run_information23
423: ,p_run_information24_o
424: => pay_prt_shd.g_old_rec.run_information24
425: ,p_run_information25_o
426: => pay_prt_shd.g_old_rec.run_information25
427: ,p_run_information26_o
428: => pay_prt_shd.g_old_rec.run_information26

Line 426: => pay_prt_shd.g_old_rec.run_information25

422: => pay_prt_shd.g_old_rec.run_information23
423: ,p_run_information24_o
424: => pay_prt_shd.g_old_rec.run_information24
425: ,p_run_information25_o
426: => pay_prt_shd.g_old_rec.run_information25
427: ,p_run_information26_o
428: => pay_prt_shd.g_old_rec.run_information26
429: ,p_run_information27_o
430: => pay_prt_shd.g_old_rec.run_information27

Line 428: => pay_prt_shd.g_old_rec.run_information26

424: => pay_prt_shd.g_old_rec.run_information24
425: ,p_run_information25_o
426: => pay_prt_shd.g_old_rec.run_information25
427: ,p_run_information26_o
428: => pay_prt_shd.g_old_rec.run_information26
429: ,p_run_information27_o
430: => pay_prt_shd.g_old_rec.run_information27
431: ,p_run_information28_o
432: => pay_prt_shd.g_old_rec.run_information28

Line 430: => pay_prt_shd.g_old_rec.run_information27

426: => pay_prt_shd.g_old_rec.run_information25
427: ,p_run_information26_o
428: => pay_prt_shd.g_old_rec.run_information26
429: ,p_run_information27_o
430: => pay_prt_shd.g_old_rec.run_information27
431: ,p_run_information28_o
432: => pay_prt_shd.g_old_rec.run_information28
433: ,p_run_information29_o
434: => pay_prt_shd.g_old_rec.run_information29

Line 432: => pay_prt_shd.g_old_rec.run_information28

428: => pay_prt_shd.g_old_rec.run_information26
429: ,p_run_information27_o
430: => pay_prt_shd.g_old_rec.run_information27
431: ,p_run_information28_o
432: => pay_prt_shd.g_old_rec.run_information28
433: ,p_run_information29_o
434: => pay_prt_shd.g_old_rec.run_information29
435: ,p_run_information30_o
436: => pay_prt_shd.g_old_rec.run_information30

Line 434: => pay_prt_shd.g_old_rec.run_information29

430: => pay_prt_shd.g_old_rec.run_information27
431: ,p_run_information28_o
432: => pay_prt_shd.g_old_rec.run_information28
433: ,p_run_information29_o
434: => pay_prt_shd.g_old_rec.run_information29
435: ,p_run_information30_o
436: => pay_prt_shd.g_old_rec.run_information30
437: ,p_object_version_number_o
438: => pay_prt_shd.g_old_rec.object_version_number

Line 436: => pay_prt_shd.g_old_rec.run_information30

432: => pay_prt_shd.g_old_rec.run_information28
433: ,p_run_information29_o
434: => pay_prt_shd.g_old_rec.run_information29
435: ,p_run_information30_o
436: => pay_prt_shd.g_old_rec.run_information30
437: ,p_object_version_number_o
438: => pay_prt_shd.g_old_rec.object_version_number
439: );
440: --

Line 438: => pay_prt_shd.g_old_rec.object_version_number

434: => pay_prt_shd.g_old_rec.run_information29
435: ,p_run_information30_o
436: => pay_prt_shd.g_old_rec.run_information30
437: ,p_object_version_number_o
438: => pay_prt_shd.g_old_rec.object_version_number
439: );
440: --
441: exception
442: --

Line 460: ,p_rec in out nocopy pay_prt_shd.g_rec_type

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

Line 476: pay_prt_shd.lck

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

Line 539: l_rec pay_prt_shd.g_rec_type;

535: ,p_effective_start_date out nocopy date
536: ,p_effective_end_date out nocopy date
537: ) is
538: --
539: l_rec pay_prt_shd.g_rec_type;
540: l_proc varchar2(72) := g_package||'del';
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);