APPS.PAY_PBC_BUS dependencies on PAY_PBC_SHD

Line 226: nvl(pay_pbc_shd.g_old_rec.category_name, hr_api.g_varchar2) <>

222: -- primary key value. For update it will be not null. For insert it will be
223: -- null, because pre_inset has not been called yet.
224: --
225: IF (((p_balance_category_id is not null) and
226: nvl(pay_pbc_shd.g_old_rec.category_name, hr_api.g_varchar2) <>
227: nvl(p_category_name, hr_api.g_varchar2))
228: or
229: (p_balance_category_id is null)) then
230: --

Line 359: nvl(pay_pbc_shd.g_old_rec.user_category_name, hr_api.g_varchar2) <>

355: -- primary key value. For update it will be not null. For insert it will be
356: -- null, because pre_inset has not been called yet.
357: --
358: IF (((p_balance_category_id is not null) and
359: nvl(pay_pbc_shd.g_old_rec.user_category_name, hr_api.g_varchar2) <>
360: nvl(p_user_category_name, hr_api.g_varchar2))
361: or
362: (p_balance_category_id is null)) then
363: --

Line 520: (p_rec in pay_pbc_shd.g_rec_type

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

Line 529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>

525: begin
526: hr_utility.set_location('Entering:'||l_proc,10);
527: --
528: if ((p_rec.balance_category_id is not null) and (
529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>

Line 531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>

527: --
528: if ((p_rec.balance_category_id is not null) and (
529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>

Line 533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>

529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>

Line 535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>

531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>

Line 537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>

533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>

Line 539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>

535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>

Line 541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>

537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>

Line 543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>

539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>

Line 545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>

541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>

Line 547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>

543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>

Line 549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>

545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>

Line 551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>

547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>

Line 553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>

549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>

Line 555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>

551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>

Line 557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>

553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>

Line 559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>

555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>

Line 561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>

557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>

Line 563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>

559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>

Line 565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>

561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>

Line 567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>

563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>

Line 569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>

565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>

Line 571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>

567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>

Line 573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>

569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>

Line 575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>

571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>

Line 577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>

573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>

Line 579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>

575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>

Line 581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>

577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>

Line 583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>

579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>

Line 585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>

581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>

Line 587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>

583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>
590: nvl(p_rec.pbc_information30, hr_api.g_varchar2) ))
591: or (p_rec.balance_category_id is null) then

Line 589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>

585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>
590: nvl(p_rec.pbc_information30, hr_api.g_varchar2) ))
591: or (p_rec.balance_category_id is null) then
592: --
593: -- Only execute the validation if absolutely necessary:

Line 818: ,p_rec in pay_pbc_shd.g_rec_type

814: -- {End Of Comments}
815: -- ----------------------------------------------------------------------------
816: Procedure chk_non_updateable_args
817: (p_effective_date in date
818: ,p_rec in pay_pbc_shd.g_rec_type
819: ) IS
820: --
821: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
822: l_error EXCEPTION;

Line 830: IF NOT pay_pbc_shd.api_updating

826: --
827: -- Only proceed with the validation if a row exists for the current
828: -- record in the HR Schema.
829: --
830: IF NOT pay_pbc_shd.api_updating
831: (p_balance_category_id => p_rec.balance_category_id
832: ,p_effective_date => p_effective_date
833: ,p_object_version_number => p_rec.object_version_number
834: ) THEN

Line 844: nvl(pay_pbc_shd.g_old_rec.business_group_id, hr_api.g_number) then

840: --
841: hr_utility.set_location(l_proc, 10);
842: --
843: if nvl(p_rec.business_group_id, hr_api.g_number) <>
844: nvl(pay_pbc_shd.g_old_rec.business_group_id, hr_api.g_number) then
845: l_argument := 'business_group_id';
846: raise l_error;
847: end if;
848: hr_utility.set_location(l_proc, 15);

Line 850: if p_rec.balance_category_id <> pay_pbc_shd.g_old_rec.balance_category_id then

846: raise l_error;
847: end if;
848: hr_utility.set_location(l_proc, 15);
849: --
850: if p_rec.balance_category_id <> pay_pbc_shd.g_old_rec.balance_category_id then
851: l_argument := 'balance_category_id';
852: raise l_error;
853: end if;
854: hr_utility.set_location(l_proc, 20);

Line 856: if p_rec.legislation_code <> pay_pbc_shd.g_old_rec.legislation_code then

852: raise l_error;
853: end if;
854: hr_utility.set_location(l_proc, 20);
855: --
856: if p_rec.legislation_code <> pay_pbc_shd.g_old_rec.legislation_code then
857: l_argument := 'legislation_code';
858: raise l_error;
859: end if;
860: hr_utility.set_location(l_proc, 25);

Line 862: if p_rec.category_name <> pay_pbc_shd.g_old_rec.category_name then

858: raise l_error;
859: end if;
860: hr_utility.set_location(l_proc, 25);
861: --
862: if p_rec.category_name <> pay_pbc_shd.g_old_rec.category_name then
863: l_argument := 'category_name';
864: raise l_error;
865: end if;
866: hr_utility.set_location(l_proc, 30);

Line 1100: (p_rec in pay_pbc_shd.g_rec_type

1096: -- ----------------------------------------------------------------------------
1097: -- |---------------------------< insert_validate >----------------------------|
1098: -- ----------------------------------------------------------------------------
1099: Procedure insert_validate
1100: (p_rec in pay_pbc_shd.g_rec_type
1101: ,p_effective_date in date
1102: ,p_datetrack_mode in varchar2
1103: ,p_validation_start_date in date
1104: ,p_validation_end_date in date

Line 1126: ,p_associated_column1 => pay_pbc_shd.g_tab_nam

1122: -- Validate Important Attributes
1123: --
1124: hr_api.validate_bus_grp_id
1125: (p_business_group_id => p_rec.business_group_id
1126: ,p_associated_column1 => pay_pbc_shd.g_tab_nam
1127: || '.BUSINESS_GROUP_ID');
1128: --
1129: -- after validating the set of important attributes,
1130: -- if Multiple Message Detection is enabled and at least

Line 1169: (p_rec in pay_pbc_shd.g_rec_type

1165: -- ----------------------------------------------------------------------------
1166: -- |---------------------------< update_validate >----------------------------|
1167: -- ----------------------------------------------------------------------------
1168: Procedure update_validate
1169: (p_rec in pay_pbc_shd.g_rec_type
1170: ,p_effective_date in date
1171: ,p_datetrack_mode in varchar2
1172: ,p_validation_start_date in date
1173: ,p_validation_end_date in date

Line 1196: ,p_associated_column1 => pay_pbc_shd.g_tab_nam

1192: -- Validate Important Attributes
1193: --
1194: hr_api.validate_bus_grp_id
1195: (p_business_group_id => p_rec.business_group_id
1196: ,p_associated_column1 => pay_pbc_shd.g_tab_nam
1197: || '.BUSINESS_GROUP_ID');
1198: --
1199: -- After validating the set of important attributes,
1200: -- if Multiple Message Detection is enabled and at least

Line 1253: (p_rec in pay_pbc_shd.g_rec_type

1249: -- ----------------------------------------------------------------------------
1250: -- |---------------------------< delete_validate >----------------------------|
1251: -- ----------------------------------------------------------------------------
1252: Procedure delete_validate
1253: (p_rec in pay_pbc_shd.g_rec_type
1254: ,p_effective_date in date
1255: ,p_datetrack_mode in varchar2
1256: ,p_validation_start_date in date
1257: ,p_validation_end_date in date

Line 1271: ,p_business_group_id => pay_pbc_shd.g_old_rec.business_group_id

1267: --
1268: chk_for_child_rows
1269: (p_balance_category_id => p_rec.balance_category_id
1270: ,p_effective_date => p_effective_date
1271: ,p_business_group_id => pay_pbc_shd.g_old_rec.business_group_id
1272: ,p_legislation_code => pay_pbc_shd.g_old_rec.legislation_code);
1273: --
1274: chk_startup_action(false
1275: ,pay_pbc_shd.g_old_rec.business_group_id

Line 1272: ,p_legislation_code => pay_pbc_shd.g_old_rec.legislation_code);

1268: chk_for_child_rows
1269: (p_balance_category_id => p_rec.balance_category_id
1270: ,p_effective_date => p_effective_date
1271: ,p_business_group_id => pay_pbc_shd.g_old_rec.business_group_id
1272: ,p_legislation_code => pay_pbc_shd.g_old_rec.legislation_code);
1273: --
1274: chk_startup_action(false
1275: ,pay_pbc_shd.g_old_rec.business_group_id
1276: ,pay_pbc_shd.g_old_rec.legislation_code

Line 1275: ,pay_pbc_shd.g_old_rec.business_group_id

1271: ,p_business_group_id => pay_pbc_shd.g_old_rec.business_group_id
1272: ,p_legislation_code => pay_pbc_shd.g_old_rec.legislation_code);
1273: --
1274: chk_startup_action(false
1275: ,pay_pbc_shd.g_old_rec.business_group_id
1276: ,pay_pbc_shd.g_old_rec.legislation_code
1277: );
1278: --
1279: -- Call all supporting business operations

Line 1276: ,pay_pbc_shd.g_old_rec.legislation_code

1272: ,p_legislation_code => pay_pbc_shd.g_old_rec.legislation_code);
1273: --
1274: chk_startup_action(false
1275: ,pay_pbc_shd.g_old_rec.business_group_id
1276: ,pay_pbc_shd.g_old_rec.legislation_code
1277: );
1278: --
1279: -- Call all supporting business operations
1280: --