DBA Data[Home] [Help]

APPS.PAY_PRT_BUS dependencies on PAY_PRT_SHD

Line 382: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) <>

378: -- primary key value. For update it will be not null. For insert it will be
379: -- null, because pre_inset has not been called yet.
380: --
381: IF (((p_run_type_id is not null) and
382: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) <>
383: nvl(p_run_type_name, hr_api.g_varchar2))
384: or
385: (p_run_type_id is null)) then
386: --

Line 521: (p_rec in pay_prt_shd.g_rec_type

517: -- Internal Row Handler Use Only.
518: --
519: -- ----------------------------------------------------------------------------
520: procedure chk_ddf
521: (p_rec in pay_prt_shd.g_rec_type
522: ) is
523: --
524: l_proc varchar2(72) := g_package || 'chk_ddf';
525: --

Line 530: (nvl(pay_prt_shd.g_old_rec.run_information_category,

526: begin
527: hr_utility.set_location('Entering:'||l_proc,10);
528: --
529: if ((p_rec.run_type_id is not null) and
530: (nvl(pay_prt_shd.g_old_rec.run_information_category,
531: hr_api.g_varchar2) <>
532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or

Line 533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>

529: if ((p_rec.run_type_id is not null) and
530: (nvl(pay_prt_shd.g_old_rec.run_information_category,
531: hr_api.g_varchar2) <>
532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>

Line 535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>

531: hr_api.g_varchar2) <>
532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>

Line 537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>

533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>

Line 539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>

535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>

Line 541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>

537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>

Line 543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>

539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>

Line 545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>

541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>

Line 547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>

543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>

Line 549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>

545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>

Line 551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>

547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>

Line 553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>

549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>

Line 555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>

551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>

Line 557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>

553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>

Line 559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>

555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>

Line 561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>

557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>

Line 563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>

559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>

Line 565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>

561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>

Line 567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>

563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>

Line 569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>

565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>

Line 571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>

567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>

Line 573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>

569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>

Line 575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>

571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>

Line 577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>

573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>

Line 579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>

575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>

Line 581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>

577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>

Line 583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>

579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>

Line 585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>

581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>

Line 587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>

583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>

Line 589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>

585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>
592: nvl(p_rec.run_information30, hr_api.g_varchar2)) )
593: or (p_rec.run_type_id is null) then

Line 591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>

587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>
592: nvl(p_rec.run_information30, hr_api.g_varchar2)) )
593: or (p_rec.run_type_id is null) then
594: --
595: -- Only execute the validation if absolutely necessary:

Line 854: ,p_rec in pay_prt_shd.g_rec_type

850: -- {End Of Comments}
851: -- ----------------------------------------------------------------------------
852: Procedure chk_non_updateable_args
853: (p_effective_date in date
854: ,p_rec in pay_prt_shd.g_rec_type
855: ) IS
856: --
857: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
858: l_error EXCEPTION;

Line 866: IF NOT pay_prt_shd.api_updating

862: --
863: -- Only proceed with the validation if a row exists for the current
864: -- record in the HR Schema.
865: --
866: IF NOT pay_prt_shd.api_updating
867: (p_run_type_id => p_rec.run_type_id
868: ,p_effective_date => p_effective_date
869: ,p_object_version_number => p_rec.object_version_number
870: ) THEN

Line 879: if p_rec.run_type_id <> pay_prt_shd.g_old_rec.run_type_id then

875: END IF;
876: --
877: hr_utility.set_location(l_proc, 10);
878: --
879: if p_rec.run_type_id <> pay_prt_shd.g_old_rec.run_type_id then
880: l_argument := 'run_type_id';
881: raise l_error;
882: end if;
883: hr_utility.set_location(l_proc, 20);

Line 886: nvl(pay_prt_shd.g_old_rec.business_group_id, hr_api.g_number) then

882: end if;
883: hr_utility.set_location(l_proc, 20);
884: --
885: if nvl(p_rec.business_group_id, hr_api.g_number) <>
886: nvl(pay_prt_shd.g_old_rec.business_group_id, hr_api.g_number) then
887: l_argument := 'business_group_id';
888: raise l_error;
889: end if;
890: hr_utility.set_location(l_proc, 25);

Line 893: nvl(pay_prt_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

889: end if;
890: hr_utility.set_location(l_proc, 25);
891: --
892: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
893: nvl(pay_prt_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
894: l_argument := 'legislation_code';
895: raise l_error;
896: end if;
897: hr_utility.set_location(l_proc, 30);

Line 900: nvl(pay_prt_shd.g_old_rec.run_method, hr_api.g_varchar2) then

896: end if;
897: hr_utility.set_location(l_proc, 30);
898: --
899: if nvl(p_rec.run_method, hr_api.g_varchar2) <>
900: nvl(pay_prt_shd.g_old_rec.run_method, hr_api.g_varchar2) then
901: l_argument := 'run_method';
902: raise l_error;
903: end if;
904: hr_utility.set_location(l_proc, 35);

Line 910: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) then

906: -- RET 12-DEC-2001 making run_type_name non-updateable as is the key
907: -- for uploading ldts.
908: --
909: if nvl(p_rec.run_type_name, hr_api.g_varchar2) <>
910: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) then
911: l_argument := 'run_type_name';
912: raise l_error;
913: end if;
914: hr_utility.set_location(l_proc, 40);

Line 1212: (p_rec in pay_prt_shd.g_rec_type

1208: -- ----------------------------------------------------------------------------
1209: -- |---------------------------< insert_validate >----------------------------|
1210: -- ----------------------------------------------------------------------------
1211: Procedure insert_validate
1212: (p_rec in pay_prt_shd.g_rec_type
1213: ,p_effective_date in date
1214: ,p_datetrack_mode in varchar2
1215: ,p_validation_start_date in date
1216: ,p_validation_end_date in date

Line 1269: (p_rec in pay_prt_shd.g_rec_type

1265: -- ----------------------------------------------------------------------------
1266: -- |---------------------------< update_validate >----------------------------|
1267: -- ----------------------------------------------------------------------------
1268: Procedure update_validate
1269: (p_rec in pay_prt_shd.g_rec_type
1270: ,p_effective_date in date
1271: ,p_datetrack_mode in varchar2
1272: ,p_validation_start_date in date
1273: ,p_validation_end_date in date

Line 1347: (p_rec in pay_prt_shd.g_rec_type

1343: -- ----------------------------------------------------------------------------
1344: -- |---------------------------< delete_validate >----------------------------|
1345: -- ----------------------------------------------------------------------------
1346: Procedure delete_validate
1347: (p_rec in pay_prt_shd.g_rec_type
1348: ,p_effective_date in date
1349: ,p_datetrack_mode in varchar2
1350: ,p_validation_start_date in date
1351: ,p_validation_end_date in date

Line 1367: ,p_business_group_id => pay_prt_shd.g_old_rec.business_group_id

1363: --
1364: chk_for_child_actions
1365: (p_run_type_id => p_rec.run_type_id
1366: ,p_effective_date => p_effective_date
1367: ,p_business_group_id => pay_prt_shd.g_old_rec.business_group_id
1368: ,p_legislation_code => pay_prt_shd.g_old_rec.legislation_code);
1369: --
1370: chk_startup_action(false
1371: ,pay_prt_shd.g_old_rec.business_group_id

Line 1368: ,p_legislation_code => pay_prt_shd.g_old_rec.legislation_code);

1364: chk_for_child_actions
1365: (p_run_type_id => p_rec.run_type_id
1366: ,p_effective_date => p_effective_date
1367: ,p_business_group_id => pay_prt_shd.g_old_rec.business_group_id
1368: ,p_legislation_code => pay_prt_shd.g_old_rec.legislation_code);
1369: --
1370: chk_startup_action(false
1371: ,pay_prt_shd.g_old_rec.business_group_id
1372: ,pay_prt_shd.g_old_rec.legislation_code

Line 1371: ,pay_prt_shd.g_old_rec.business_group_id

1367: ,p_business_group_id => pay_prt_shd.g_old_rec.business_group_id
1368: ,p_legislation_code => pay_prt_shd.g_old_rec.legislation_code);
1369: --
1370: chk_startup_action(false
1371: ,pay_prt_shd.g_old_rec.business_group_id
1372: ,pay_prt_shd.g_old_rec.legislation_code
1373: );
1374: --
1375: dt_delete_validate

Line 1372: ,pay_prt_shd.g_old_rec.legislation_code

1368: ,p_legislation_code => pay_prt_shd.g_old_rec.legislation_code);
1369: --
1370: chk_startup_action(false
1371: ,pay_prt_shd.g_old_rec.business_group_id
1372: ,pay_prt_shd.g_old_rec.legislation_code
1373: );
1374: --
1375: dt_delete_validate
1376: (p_datetrack_mode => p_datetrack_mode