APPS.BEN_PPR_LER dependencies on BENUTILS

Line 150: benutils.set_data_migrator_mode;

146: --
147: begin
148:
149: -- Bug 3320133
150: benutils.set_data_migrator_mode;
151: if hr_general.g_data_migrator_mode in ( 'Y','P') then
152: --
153: return;
154: --

Line 410: benutils.exec_rule(

406: end if;
407: --
408:
409: --
410: benutils.exec_rule(
411: p_formula_id => l_per_info_chg_cs_ler_rl,
412: p_effective_date => l_session_date,
413: p_lf_evt_ocrd_dt => null,
414: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 507: l_changed := (benutils.column_changed(p_old.review_date

503:
504: --
505:
506: if l_column = 'REVIEW_DATE' then
507: l_changed := (benutils.column_changed(p_old.review_date
508: ,p_new.review_date,l_new_val) AND
509: benutils.column_changed(p_new.review_date
510: ,p_old.review_date,l_old_val) AND
511: (l_changed));

Line 509: benutils.column_changed(p_new.review_date

505:
506: if l_column = 'REVIEW_DATE' then
507: l_changed := (benutils.column_changed(p_old.review_date
508: ,p_new.review_date,l_new_val) AND
509: benutils.column_changed(p_new.review_date
510: ,p_old.review_date,l_old_val) AND
511: (l_changed));
512: end if;
513:

Line 516: l_changed := (benutils.column_changed(p_old.performance_rating

512: end if;
513:
514: --
515: if l_column = 'PERFORMANCE_RATING' then
516: l_changed := (benutils.column_changed(p_old.performance_rating
517: ,p_new.performance_rating,l_new_val) AND
518: benutils.column_changed(p_new.performance_rating
519: ,p_old.performance_rating,l_old_val) AND
520: (l_changed));

Line 518: benutils.column_changed(p_new.performance_rating

514: --
515: if l_column = 'PERFORMANCE_RATING' then
516: l_changed := (benutils.column_changed(p_old.performance_rating
517: ,p_new.performance_rating,l_new_val) AND
518: benutils.column_changed(p_new.performance_rating
519: ,p_old.performance_rating,l_old_val) AND
520: (l_changed));
521: hr_utility.set_location('NEW DOB'||p_new.performance_rating, 50);
522: hr_utility.set_location('OLD DOB'||p_old.performance_rating, 50);

Line 552: l_changed := (benutils.column_changed(l_old_review_type

548: --
549: l_new_review_type := nvl(l_new_review_type, p_new.event_id);
550: l_old_review_type := nvl(l_old_review_type, p_old.event_id);
551: --
552: l_changed := (benutils.column_changed(l_old_review_type
553: ,l_new_review_type,l_new_val) AND
554: benutils.column_changed(l_new_review_type
555: ,l_old_review_type,l_old_val) AND
556: (l_changed));

Line 554: benutils.column_changed(l_new_review_type

550: l_old_review_type := nvl(l_old_review_type, p_old.event_id);
551: --
552: l_changed := (benutils.column_changed(l_old_review_type
553: ,l_new_review_type,l_new_val) AND
554: benutils.column_changed(l_new_review_type
555: ,l_old_review_type,l_old_val) AND
556: (l_changed));
557: --
558: -- Bug : 3692707

Line 564: l_changed := (benutils.column_changed(p_old.attribute1

560: end if;
561:
562: --
563: if l_column = 'ATTRIBUTE1' then
564: l_changed := (benutils.column_changed(p_old.attribute1
565: ,p_new.attribute1,l_new_val) AND
566: benutils.column_changed(p_new.attribute1
567: ,p_old.attribute1,l_old_val) AND
568: (l_changed));

Line 566: benutils.column_changed(p_new.attribute1

562: --
563: if l_column = 'ATTRIBUTE1' then
564: l_changed := (benutils.column_changed(p_old.attribute1
565: ,p_new.attribute1,l_new_val) AND
566: benutils.column_changed(p_new.attribute1
567: ,p_old.attribute1,l_old_val) AND
568: (l_changed));
569: hr_utility.set_location(' ben_ppr_trigger', 210);
570: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);

Line 575: l_changed := (benutils.column_changed(p_old.attribute2

571: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
572: end if;
573: --
574: if l_column = 'ATTRIBUTE2' then
575: l_changed := (benutils.column_changed(p_old.attribute2
576: ,p_new.attribute2,l_new_val) AND
577: benutils.column_changed(p_new.attribute2
578: ,p_old.attribute2,l_old_val) AND
579: (l_changed));

Line 577: benutils.column_changed(p_new.attribute2

573: --
574: if l_column = 'ATTRIBUTE2' then
575: l_changed := (benutils.column_changed(p_old.attribute2
576: ,p_new.attribute2,l_new_val) AND
577: benutils.column_changed(p_new.attribute2
578: ,p_old.attribute2,l_old_val) AND
579: (l_changed));
580: hr_utility.set_location(' ben_ppr_trigger', 220);
581: end if;

Line 584: l_changed := (benutils.column_changed(p_old.attribute3

580: hr_utility.set_location(' ben_ppr_trigger', 220);
581: end if;
582: --
583: if l_column = 'ATTRIBUTE3' then
584: l_changed := (benutils.column_changed(p_old.attribute3
585: ,p_new.attribute3,l_new_val) AND
586: benutils.column_changed(p_new.attribute3
587: ,p_old.attribute3,l_old_val) AND
588: (l_changed));

Line 586: benutils.column_changed(p_new.attribute3

582: --
583: if l_column = 'ATTRIBUTE3' then
584: l_changed := (benutils.column_changed(p_old.attribute3
585: ,p_new.attribute3,l_new_val) AND
586: benutils.column_changed(p_new.attribute3
587: ,p_old.attribute3,l_old_val) AND
588: (l_changed));
589: hr_utility.set_location(' ben_ppr_trigger', 230);
590: end if;

Line 593: l_changed := (benutils.column_changed(p_old.attribute4

589: hr_utility.set_location(' ben_ppr_trigger', 230);
590: end if;
591: --
592: if l_column = 'ATTRIBUTE4' then
593: l_changed := (benutils.column_changed(p_old.attribute4
594: ,p_new.attribute4,l_new_val) AND
595: benutils.column_changed(p_new.attribute4
596: ,p_old.attribute4,l_old_val) AND
597: (l_changed));

Line 595: benutils.column_changed(p_new.attribute4

591: --
592: if l_column = 'ATTRIBUTE4' then
593: l_changed := (benutils.column_changed(p_old.attribute4
594: ,p_new.attribute4,l_new_val) AND
595: benutils.column_changed(p_new.attribute4
596: ,p_old.attribute4,l_old_val) AND
597: (l_changed));
598: hr_utility.set_location(' ben_ppr_trigger', 240);
599: end if;

Line 602: l_changed := (benutils.column_changed(p_old.attribute5

598: hr_utility.set_location(' ben_ppr_trigger', 240);
599: end if;
600: --
601: if l_column = 'ATTRIBUTE5' then
602: l_changed := (benutils.column_changed(p_old.attribute5
603: ,p_new.attribute5,l_new_val) AND
604: benutils.column_changed(p_new.attribute5
605: ,p_old.attribute5,l_old_val) AND
606: (l_changed));

Line 604: benutils.column_changed(p_new.attribute5

600: --
601: if l_column = 'ATTRIBUTE5' then
602: l_changed := (benutils.column_changed(p_old.attribute5
603: ,p_new.attribute5,l_new_val) AND
604: benutils.column_changed(p_new.attribute5
605: ,p_old.attribute5,l_old_val) AND
606: (l_changed));
607: hr_utility.set_location(' ben_ppr_trigger', 250);
608: end if;

Line 611: l_changed := (benutils.column_changed(p_old.attribute6

607: hr_utility.set_location(' ben_ppr_trigger', 250);
608: end if;
609: --
610: if l_column = 'ATTRIBUTE6' then
611: l_changed := (benutils.column_changed(p_old.attribute6
612: ,p_new.attribute6,l_new_val) AND
613: benutils.column_changed(p_new.attribute6
614: ,p_old.attribute6,l_old_val) AND
615: (l_changed));

Line 613: benutils.column_changed(p_new.attribute6

609: --
610: if l_column = 'ATTRIBUTE6' then
611: l_changed := (benutils.column_changed(p_old.attribute6
612: ,p_new.attribute6,l_new_val) AND
613: benutils.column_changed(p_new.attribute6
614: ,p_old.attribute6,l_old_val) AND
615: (l_changed));
616: hr_utility.set_location(' ben_ppr_trigger', 260);
617: end if;

Line 620: l_changed := (benutils.column_changed(p_old.attribute7

616: hr_utility.set_location(' ben_ppr_trigger', 260);
617: end if;
618: --
619: if l_column = 'ATTRIBUTE7' then
620: l_changed := (benutils.column_changed(p_old.attribute7
621: ,p_new.attribute7,l_new_val) AND
622: benutils.column_changed(p_new.attribute7
623: ,p_old.attribute7,l_old_val) AND
624: (l_changed));

Line 622: benutils.column_changed(p_new.attribute7

618: --
619: if l_column = 'ATTRIBUTE7' then
620: l_changed := (benutils.column_changed(p_old.attribute7
621: ,p_new.attribute7,l_new_val) AND
622: benutils.column_changed(p_new.attribute7
623: ,p_old.attribute7,l_old_val) AND
624: (l_changed));
625: hr_utility.set_location(' ben_ppr_trigger', 270);
626: end if;

Line 629: l_changed := (benutils.column_changed(p_old.attribute8

625: hr_utility.set_location(' ben_ppr_trigger', 270);
626: end if;
627: --
628: if l_column = 'ATTRIBUTE8' then
629: l_changed := (benutils.column_changed(p_old.attribute8
630: ,p_new.attribute8,l_new_val) AND
631: benutils.column_changed(p_new.attribute8
632: ,p_old.attribute8,l_old_val) AND
633: (l_changed));

Line 631: benutils.column_changed(p_new.attribute8

627: --
628: if l_column = 'ATTRIBUTE8' then
629: l_changed := (benutils.column_changed(p_old.attribute8
630: ,p_new.attribute8,l_new_val) AND
631: benutils.column_changed(p_new.attribute8
632: ,p_old.attribute8,l_old_val) AND
633: (l_changed));
634: hr_utility.set_location(' ben_ppr_trigger', 280);
635: end if;

Line 638: l_changed := (benutils.column_changed(p_old.attribute9

634: hr_utility.set_location(' ben_ppr_trigger', 280);
635: end if;
636: --
637: if l_column = 'ATTRIBUTE9' then
638: l_changed := (benutils.column_changed(p_old.attribute9
639: ,p_new.attribute9,l_new_val) AND
640: benutils.column_changed(p_new.attribute9
641: ,p_old.attribute9,l_old_val) AND
642: (l_changed));

Line 640: benutils.column_changed(p_new.attribute9

636: --
637: if l_column = 'ATTRIBUTE9' then
638: l_changed := (benutils.column_changed(p_old.attribute9
639: ,p_new.attribute9,l_new_val) AND
640: benutils.column_changed(p_new.attribute9
641: ,p_old.attribute9,l_old_val) AND
642: (l_changed));
643: hr_utility.set_location(' ben_ppr_trigger', 290);
644: end if;

Line 647: l_changed := (benutils.column_changed(p_old.attribute10

643: hr_utility.set_location(' ben_ppr_trigger', 290);
644: end if;
645: --
646: if l_column = 'ATTRIBUTE10' then
647: l_changed := (benutils.column_changed(p_old.attribute10
648: ,p_new.attribute10,l_new_val) AND
649: benutils.column_changed(p_new.attribute10
650: ,p_old.attribute10,l_old_val) AND
651: (l_changed));

Line 649: benutils.column_changed(p_new.attribute10

645: --
646: if l_column = 'ATTRIBUTE10' then
647: l_changed := (benutils.column_changed(p_old.attribute10
648: ,p_new.attribute10,l_new_val) AND
649: benutils.column_changed(p_new.attribute10
650: ,p_old.attribute10,l_old_val) AND
651: (l_changed));
652: hr_utility.set_location(' ben_ppr_trigger', 300);
653: end if;

Line 656: l_changed := (benutils.column_changed(p_old.attribute11

652: hr_utility.set_location(' ben_ppr_trigger', 300);
653: end if;
654: --
655: if l_column = 'ATTRIBUTE11' then
656: l_changed := (benutils.column_changed(p_old.attribute11
657: ,p_new.attribute11,l_new_val) AND
658: benutils.column_changed(p_new.attribute11
659: ,p_old.attribute11,l_old_val) AND
660: (l_changed));

Line 658: benutils.column_changed(p_new.attribute11

654: --
655: if l_column = 'ATTRIBUTE11' then
656: l_changed := (benutils.column_changed(p_old.attribute11
657: ,p_new.attribute11,l_new_val) AND
658: benutils.column_changed(p_new.attribute11
659: ,p_old.attribute11,l_old_val) AND
660: (l_changed));
661: hr_utility.set_location(' ben_ppr_trigger', 310);
662: end if;

Line 665: l_changed := (benutils.column_changed(p_old.attribute12

661: hr_utility.set_location(' ben_ppr_trigger', 310);
662: end if;
663: --
664: if l_column = 'ATTRIBUTE12' then
665: l_changed := (benutils.column_changed(p_old.attribute12
666: ,p_new.attribute12,l_new_val) AND
667: benutils.column_changed(p_new.attribute12
668: ,p_old.attribute12,l_old_val) AND
669: (l_changed));

Line 667: benutils.column_changed(p_new.attribute12

663: --
664: if l_column = 'ATTRIBUTE12' then
665: l_changed := (benutils.column_changed(p_old.attribute12
666: ,p_new.attribute12,l_new_val) AND
667: benutils.column_changed(p_new.attribute12
668: ,p_old.attribute12,l_old_val) AND
669: (l_changed));
670: hr_utility.set_location(' ben_ppr_trigger', 320);
671: end if;

Line 674: l_changed := (benutils.column_changed(p_old.attribute13

670: hr_utility.set_location(' ben_ppr_trigger', 320);
671: end if;
672: --
673: if l_column = 'ATTRIBUTE13' then
674: l_changed := (benutils.column_changed(p_old.attribute13
675: ,p_new.attribute13,l_new_val) AND
676: benutils.column_changed(p_new.attribute13
677: ,p_old.attribute13,l_old_val) AND
678: (l_changed));

Line 676: benutils.column_changed(p_new.attribute13

672: --
673: if l_column = 'ATTRIBUTE13' then
674: l_changed := (benutils.column_changed(p_old.attribute13
675: ,p_new.attribute13,l_new_val) AND
676: benutils.column_changed(p_new.attribute13
677: ,p_old.attribute13,l_old_val) AND
678: (l_changed));
679: hr_utility.set_location(' ben_ppr_trigger', 330);
680: end if;

Line 683: l_changed := (benutils.column_changed(p_old.attribute14

679: hr_utility.set_location(' ben_ppr_trigger', 330);
680: end if;
681: --
682: if l_column = 'ATTRIBUTE14' then
683: l_changed := (benutils.column_changed(p_old.attribute14
684: ,p_new.attribute14,l_new_val) AND
685: benutils.column_changed(p_new.attribute14
686: ,p_old.attribute14,l_old_val) AND
687: (l_changed));

Line 685: benutils.column_changed(p_new.attribute14

681: --
682: if l_column = 'ATTRIBUTE14' then
683: l_changed := (benutils.column_changed(p_old.attribute14
684: ,p_new.attribute14,l_new_val) AND
685: benutils.column_changed(p_new.attribute14
686: ,p_old.attribute14,l_old_val) AND
687: (l_changed));
688: hr_utility.set_location(' ben_ppr_trigger', 340);
689: end if;

Line 692: l_changed := (benutils.column_changed(p_old.attribute15

688: hr_utility.set_location(' ben_ppr_trigger', 340);
689: end if;
690: --
691: if l_column = 'ATTRIBUTE15' then
692: l_changed := (benutils.column_changed(p_old.attribute15
693: ,p_new.attribute15,l_new_val) AND
694: benutils.column_changed(p_new.attribute15
695: ,p_old.attribute15,l_old_val) AND
696: (l_changed));

Line 694: benutils.column_changed(p_new.attribute15

690: --
691: if l_column = 'ATTRIBUTE15' then
692: l_changed := (benutils.column_changed(p_old.attribute15
693: ,p_new.attribute15,l_new_val) AND
694: benutils.column_changed(p_new.attribute15
695: ,p_old.attribute15,l_old_val) AND
696: (l_changed));
697: hr_utility.set_location(' ben_ppr_trigger', 350);
698: end if;

Line 701: l_changed := (benutils.column_changed(p_old.attribute16

697: hr_utility.set_location(' ben_ppr_trigger', 350);
698: end if;
699: --
700: if l_column = 'ATTRIBUTE16' then
701: l_changed := (benutils.column_changed(p_old.attribute16
702: ,p_new.attribute16,l_new_val) AND
703: benutils.column_changed(p_new.attribute16
704: ,p_old.attribute16,l_old_val) AND
705: (l_changed));

Line 703: benutils.column_changed(p_new.attribute16

699: --
700: if l_column = 'ATTRIBUTE16' then
701: l_changed := (benutils.column_changed(p_old.attribute16
702: ,p_new.attribute16,l_new_val) AND
703: benutils.column_changed(p_new.attribute16
704: ,p_old.attribute16,l_old_val) AND
705: (l_changed));
706: hr_utility.set_location(' ben_ppr_trigger', 360);
707: end if;

Line 710: l_changed := (benutils.column_changed(p_old.attribute17

706: hr_utility.set_location(' ben_ppr_trigger', 360);
707: end if;
708: --
709: if l_column = 'ATTRIBUTE17' then
710: l_changed := (benutils.column_changed(p_old.attribute17
711: ,p_new.attribute17,l_new_val) AND
712: benutils.column_changed(p_new.attribute17
713: ,p_old.attribute17,l_old_val) AND
714: (l_changed));

Line 712: benutils.column_changed(p_new.attribute17

708: --
709: if l_column = 'ATTRIBUTE17' then
710: l_changed := (benutils.column_changed(p_old.attribute17
711: ,p_new.attribute17,l_new_val) AND
712: benutils.column_changed(p_new.attribute17
713: ,p_old.attribute17,l_old_val) AND
714: (l_changed));
715: hr_utility.set_location(' ben_ppr_trigger', 370);
716: end if;

Line 719: l_changed := (benutils.column_changed(p_old.attribute18

715: hr_utility.set_location(' ben_ppr_trigger', 370);
716: end if;
717: --
718: if l_column = 'ATTRIBUTE18' then
719: l_changed := (benutils.column_changed(p_old.attribute18
720: ,p_new.attribute18,l_new_val) AND
721: benutils.column_changed(p_new.attribute18
722: ,p_old.attribute18,l_old_val) AND
723: (l_changed));

Line 721: benutils.column_changed(p_new.attribute18

717: --
718: if l_column = 'ATTRIBUTE18' then
719: l_changed := (benutils.column_changed(p_old.attribute18
720: ,p_new.attribute18,l_new_val) AND
721: benutils.column_changed(p_new.attribute18
722: ,p_old.attribute18,l_old_val) AND
723: (l_changed));
724: hr_utility.set_location(' ben_ppr_trigger', 380);
725: end if;

Line 728: l_changed := (benutils.column_changed(p_old.attribute19

724: hr_utility.set_location(' ben_ppr_trigger', 380);
725: end if;
726: --
727: if l_column = 'ATTRIBUTE19' then
728: l_changed := (benutils.column_changed(p_old.attribute19
729: ,p_new.attribute19,l_new_val) AND
730: benutils.column_changed(p_new.attribute19
731: ,p_old.attribute19,l_old_val) AND
732: (l_changed));

Line 730: benutils.column_changed(p_new.attribute19

726: --
727: if l_column = 'ATTRIBUTE19' then
728: l_changed := (benutils.column_changed(p_old.attribute19
729: ,p_new.attribute19,l_new_val) AND
730: benutils.column_changed(p_new.attribute19
731: ,p_old.attribute19,l_old_val) AND
732: (l_changed));
733: hr_utility.set_location(' ben_ppr_trigger', 390);
734: end if;

Line 737: l_changed := (benutils.column_changed(p_old.attribute20

733: hr_utility.set_location(' ben_ppr_trigger', 390);
734: end if;
735: --
736: if l_column = 'ATTRIBUTE20' then
737: l_changed := (benutils.column_changed(p_old.attribute20
738: ,p_new.attribute20,l_new_val) AND
739: benutils.column_changed(p_new.attribute20
740: ,p_old.attribute20,l_old_val) AND
741: (l_changed));

Line 739: benutils.column_changed(p_new.attribute20

735: --
736: if l_column = 'ATTRIBUTE20' then
737: l_changed := (benutils.column_changed(p_old.attribute20
738: ,p_new.attribute20,l_new_val) AND
739: benutils.column_changed(p_new.attribute20
740: ,p_old.attribute20,l_old_val) AND
741: (l_changed));
742: hr_utility.set_location(' ben_ppr_trigger', 400);
743: end if;

Line 747: l_changed := (benutils.column_changed(p_old.attribute21

743: end if;
744: --
745:
746: if l_column = 'ATTRIBUTE21' then
747: l_changed := (benutils.column_changed(p_old.attribute21
748: ,p_new.attribute21,l_new_val) AND
749: benutils.column_changed(p_new.attribute21
750: ,p_old.attribute21,l_old_val) AND
751: (l_changed));

Line 749: benutils.column_changed(p_new.attribute21

745:
746: if l_column = 'ATTRIBUTE21' then
747: l_changed := (benutils.column_changed(p_old.attribute21
748: ,p_new.attribute21,l_new_val) AND
749: benutils.column_changed(p_new.attribute21
750: ,p_old.attribute21,l_old_val) AND
751: (l_changed));
752: end if;
753: --

Line 755: l_changed := (benutils.column_changed(p_old.attribute22

751: (l_changed));
752: end if;
753: --
754: if l_column = 'ATTRIBUTE22' then
755: l_changed := (benutils.column_changed(p_old.attribute22
756: ,p_new.attribute22,l_new_val) AND
757: benutils.column_changed(p_new.attribute22
758: ,p_old.attribute22,l_old_val) AND
759: (l_changed));

Line 757: benutils.column_changed(p_new.attribute22

753: --
754: if l_column = 'ATTRIBUTE22' then
755: l_changed := (benutils.column_changed(p_old.attribute22
756: ,p_new.attribute22,l_new_val) AND
757: benutils.column_changed(p_new.attribute22
758: ,p_old.attribute22,l_old_val) AND
759: (l_changed));
760: end if;
761: --

Line 763: l_changed := (benutils.column_changed(p_old.attribute23

759: (l_changed));
760: end if;
761: --
762: if l_column = 'ATTRIBUTE23' then
763: l_changed := (benutils.column_changed(p_old.attribute23
764: ,p_new.attribute23,l_new_val) AND
765: benutils.column_changed(p_new.attribute23
766: ,p_old.attribute23,l_old_val) AND
767: (l_changed));

Line 765: benutils.column_changed(p_new.attribute23

761: --
762: if l_column = 'ATTRIBUTE23' then
763: l_changed := (benutils.column_changed(p_old.attribute23
764: ,p_new.attribute23,l_new_val) AND
765: benutils.column_changed(p_new.attribute23
766: ,p_old.attribute23,l_old_val) AND
767: (l_changed));
768: end if;
769: --

Line 771: l_changed := (benutils.column_changed(p_old.attribute24

767: (l_changed));
768: end if;
769: --
770: if l_column = 'ATTRIBUTE24' then
771: l_changed := (benutils.column_changed(p_old.attribute24
772: ,p_new.attribute24,l_new_val) AND
773: benutils.column_changed(p_new.attribute24
774: ,p_old.attribute24,l_old_val) AND
775: (l_changed));

Line 773: benutils.column_changed(p_new.attribute24

769: --
770: if l_column = 'ATTRIBUTE24' then
771: l_changed := (benutils.column_changed(p_old.attribute24
772: ,p_new.attribute24,l_new_val) AND
773: benutils.column_changed(p_new.attribute24
774: ,p_old.attribute24,l_old_val) AND
775: (l_changed));
776: end if;
777: --

Line 779: l_changed := (benutils.column_changed(p_old.attribute25

775: (l_changed));
776: end if;
777: --
778: if l_column = 'ATTRIBUTE25' then
779: l_changed := (benutils.column_changed(p_old.attribute25
780: ,p_new.attribute25,l_new_val) AND
781: benutils.column_changed(p_new.attribute25
782: ,p_old.attribute25,l_old_val) AND
783: (l_changed));

Line 781: benutils.column_changed(p_new.attribute25

777: --
778: if l_column = 'ATTRIBUTE25' then
779: l_changed := (benutils.column_changed(p_old.attribute25
780: ,p_new.attribute25,l_new_val) AND
781: benutils.column_changed(p_new.attribute25
782: ,p_old.attribute25,l_old_val) AND
783: (l_changed));
784: end if;
785: --

Line 787: l_changed := (benutils.column_changed(p_old.attribute26

783: (l_changed));
784: end if;
785: --
786: if l_column = 'ATTRIBUTE26' then
787: l_changed := (benutils.column_changed(p_old.attribute26
788: ,p_new.attribute26,l_new_val) AND
789: benutils.column_changed(p_new.attribute26
790: ,p_old.attribute26,l_old_val) AND
791: (l_changed));

Line 789: benutils.column_changed(p_new.attribute26

785: --
786: if l_column = 'ATTRIBUTE26' then
787: l_changed := (benutils.column_changed(p_old.attribute26
788: ,p_new.attribute26,l_new_val) AND
789: benutils.column_changed(p_new.attribute26
790: ,p_old.attribute26,l_old_val) AND
791: (l_changed));
792: end if;
793: --

Line 795: l_changed := (benutils.column_changed(p_old.attribute27

791: (l_changed));
792: end if;
793: --
794: if l_column = 'ATTRIBUTE27' then
795: l_changed := (benutils.column_changed(p_old.attribute27
796: ,p_new.attribute27,l_new_val) AND
797: benutils.column_changed(p_new.attribute27
798: ,p_old.attribute27,l_old_val) AND
799: (l_changed));

Line 797: benutils.column_changed(p_new.attribute27

793: --
794: if l_column = 'ATTRIBUTE27' then
795: l_changed := (benutils.column_changed(p_old.attribute27
796: ,p_new.attribute27,l_new_val) AND
797: benutils.column_changed(p_new.attribute27
798: ,p_old.attribute27,l_old_val) AND
799: (l_changed));
800: end if;
801: --

Line 803: l_changed := (benutils.column_changed(p_old.attribute28

799: (l_changed));
800: end if;
801: --
802: if l_column = 'ATTRIBUTE28' then
803: l_changed := (benutils.column_changed(p_old.attribute28
804: ,p_new.attribute28,l_new_val) AND
805: benutils.column_changed(p_new.attribute28
806: ,p_old.attribute28,l_old_val) AND
807: (l_changed));

Line 805: benutils.column_changed(p_new.attribute28

801: --
802: if l_column = 'ATTRIBUTE28' then
803: l_changed := (benutils.column_changed(p_old.attribute28
804: ,p_new.attribute28,l_new_val) AND
805: benutils.column_changed(p_new.attribute28
806: ,p_old.attribute28,l_old_val) AND
807: (l_changed));
808: end if;
809: --

Line 811: l_changed := (benutils.column_changed(p_old.attribute29

807: (l_changed));
808: end if;
809: --
810: if l_column = 'ATTRIBUTE29' then
811: l_changed := (benutils.column_changed(p_old.attribute29
812: ,p_new.attribute29,l_new_val) AND
813: benutils.column_changed(p_new.attribute29
814: ,p_old.attribute29,l_old_val) AND
815: (l_changed));

Line 813: benutils.column_changed(p_new.attribute29

809: --
810: if l_column = 'ATTRIBUTE29' then
811: l_changed := (benutils.column_changed(p_old.attribute29
812: ,p_new.attribute29,l_new_val) AND
813: benutils.column_changed(p_new.attribute29
814: ,p_old.attribute29,l_old_val) AND
815: (l_changed));
816: end if;
817: --

Line 819: l_changed := (benutils.column_changed(p_old.attribute30

815: (l_changed));
816: end if;
817: --
818: if l_column = 'ATTRIBUTE30' then
819: l_changed := (benutils.column_changed(p_old.attribute30
820: ,p_new.attribute30,l_new_val) AND
821: benutils.column_changed(p_new.attribute30
822: ,p_old.attribute30,l_old_val) AND
823: (l_changed));

Line 821: benutils.column_changed(p_new.attribute30

817: --
818: if l_column = 'ATTRIBUTE30' then
819: l_changed := (benutils.column_changed(p_old.attribute30
820: ,p_new.attribute30,l_new_val) AND
821: benutils.column_changed(p_new.attribute30
822: ,p_old.attribute30,l_old_val) AND
823: (l_changed));
824: end if;
825: --