APPS.BEN_PRO_LER dependencies on BENUTILS

Line 174: benutils.set_data_migrator_mode;

170: begin
171: --
172:
173: -- Bug 2016857
174: benutils.set_data_migrator_mode;
175: -- Bug 2016857
176:
177: if hr_general.g_data_migrator_mode in ( 'Y','P') then
178: --

Line 512: benutils.exec_rule(

508: l_col_old_val := l_old.ATTRIBUTE20;
509: l_col_new_val := p_new.ATTRIBUTE20;
510: end if;
511: --
512: benutils.exec_rule(
513: p_formula_id => l_per_info_chg_cs_ler_rl,
514: p_effective_date => l_session_date,
515: p_lf_evt_ocrd_dt => null,
516: p_business_group_id => nvl(p_new.business_group_id, l_old.business_group_id),

Line 589: l_changed := (benutils.column_changed(l_old.CHANGE_DATE

585: --
586:
587: --
588: if l_column = 'CHANGE_DATE' then
589: l_changed := (benutils.column_changed(l_old.CHANGE_DATE
590: ,p_new.CHANGE_DATE,l_new_val) AND
591: benutils.column_changed(p_new.CHANGE_DATE
592: ,l_old.CHANGE_DATE,l_old_val) AND
593: (l_changed));

Line 591: benutils.column_changed(p_new.CHANGE_DATE

587: --
588: if l_column = 'CHANGE_DATE' then
589: l_changed := (benutils.column_changed(l_old.CHANGE_DATE
590: ,p_new.CHANGE_DATE,l_new_val) AND
591: benutils.column_changed(p_new.CHANGE_DATE
592: ,l_old.CHANGE_DATE,l_old_val) AND
593: (l_changed));
594: hr_utility.set_location(' l_changed:',40);
595: end if;

Line 598: l_changed := (benutils.column_changed(l_old.LAST_CHANGE_DATE

594: hr_utility.set_location(' l_changed:',40);
595: end if;
596: --
597: if l_column = 'LAST_CHANGE_DATE' then
598: l_changed := (benutils.column_changed(l_old.LAST_CHANGE_DATE
599: ,p_new.LAST_CHANGE_DATE,l_new_val) AND
600: benutils.column_changed(p_new.LAST_CHANGE_DATE
601: ,l_old.LAST_CHANGE_DATE,l_old_val) AND
602: (l_changed));

Line 600: benutils.column_changed(p_new.LAST_CHANGE_DATE

596: --
597: if l_column = 'LAST_CHANGE_DATE' then
598: l_changed := (benutils.column_changed(l_old.LAST_CHANGE_DATE
599: ,p_new.LAST_CHANGE_DATE,l_new_val) AND
600: benutils.column_changed(p_new.LAST_CHANGE_DATE
601: ,l_old.LAST_CHANGE_DATE,l_old_val) AND
602: (l_changed));
603: --
604: end if;

Line 607: l_changed := (benutils.column_changed(l_old.NEXT_PERF_REVIEW_DATE

603: --
604: end if;
605: --
606: if l_column = 'NEXT_PERF_REVIEW_DATE' then
607: l_changed := (benutils.column_changed(l_old.NEXT_PERF_REVIEW_DATE
608: ,p_new.NEXT_PERF_REVIEW_DATE,l_new_val) AND
609: benutils.column_changed(p_new.NEXT_PERF_REVIEW_DATE
610: ,l_old.NEXT_PERF_REVIEW_DATE,l_old_val) AND
611: (l_changed));

Line 609: benutils.column_changed(p_new.NEXT_PERF_REVIEW_DATE

605: --
606: if l_column = 'NEXT_PERF_REVIEW_DATE' then
607: l_changed := (benutils.column_changed(l_old.NEXT_PERF_REVIEW_DATE
608: ,p_new.NEXT_PERF_REVIEW_DATE,l_new_val) AND
609: benutils.column_changed(p_new.NEXT_PERF_REVIEW_DATE
610: ,l_old.NEXT_PERF_REVIEW_DATE,l_old_val) AND
611: (l_changed));
612: end if;
613: --

Line 615: l_changed := (benutils.column_changed(l_old.NEXT_SAL_REVIEW_DATE

611: (l_changed));
612: end if;
613: --
614: if l_column = 'NEXT_SAL_REVIEW_DATE' then
615: l_changed := (benutils.column_changed(l_old.NEXT_SAL_REVIEW_DATE
616: ,p_new.NEXT_SAL_REVIEW_DATE,l_new_val) AND
617: benutils.column_changed(p_new.NEXT_SAL_REVIEW_DATE
618: ,l_old.NEXT_SAL_REVIEW_DATE,l_old_val) );
619: end if;

Line 617: benutils.column_changed(p_new.NEXT_SAL_REVIEW_DATE

613: --
614: if l_column = 'NEXT_SAL_REVIEW_DATE' then
615: l_changed := (benutils.column_changed(l_old.NEXT_SAL_REVIEW_DATE
616: ,p_new.NEXT_SAL_REVIEW_DATE,l_new_val) AND
617: benutils.column_changed(p_new.NEXT_SAL_REVIEW_DATE
618: ,l_old.NEXT_SAL_REVIEW_DATE,l_old_val) );
619: end if;
620: --
621: if l_column = 'PERFORMANCE_RATING' then

Line 622: l_changed := (benutils.column_changed(l_old.PERFORMANCE_RATING

618: ,l_old.NEXT_SAL_REVIEW_DATE,l_old_val) );
619: end if;
620: --
621: if l_column = 'PERFORMANCE_RATING' then
622: l_changed := (benutils.column_changed(l_old.PERFORMANCE_RATING
623: ,p_new.PERFORMANCE_RATING,l_new_val) AND
624: benutils.column_changed(p_new.PERFORMANCE_RATING
625: ,l_old.PERFORMANCE_RATING,l_old_val) );
626: end if;

Line 624: benutils.column_changed(p_new.PERFORMANCE_RATING

620: --
621: if l_column = 'PERFORMANCE_RATING' then
622: l_changed := (benutils.column_changed(l_old.PERFORMANCE_RATING
623: ,p_new.PERFORMANCE_RATING,l_new_val) AND
624: benutils.column_changed(p_new.PERFORMANCE_RATING
625: ,l_old.PERFORMANCE_RATING,l_old_val) );
626: end if;
627: --
628: if l_column = 'PROPOSED_SALARY_N' then

Line 629: l_changed := (benutils.column_changed(l_old.PROPOSED_SALARY_N

625: ,l_old.PERFORMANCE_RATING,l_old_val) );
626: end if;
627: --
628: if l_column = 'PROPOSED_SALARY_N' then
629: l_changed := (benutils.column_changed(l_old.PROPOSED_SALARY_N
630: ,p_new.PROPOSED_SALARY_N,l_new_val) AND
631: benutils.column_changed(p_new.PROPOSED_SALARY_N
632: ,l_old.PROPOSED_SALARY_N,l_old_val) );
633: end if;

Line 631: benutils.column_changed(p_new.PROPOSED_SALARY_N

627: --
628: if l_column = 'PROPOSED_SALARY_N' then
629: l_changed := (benutils.column_changed(l_old.PROPOSED_SALARY_N
630: ,p_new.PROPOSED_SALARY_N,l_new_val) AND
631: benutils.column_changed(p_new.PROPOSED_SALARY_N
632: ,l_old.PROPOSED_SALARY_N,l_old_val) );
633: end if;
634: --
635: if l_column = 'PROPOSAL_REASON' then

Line 636: l_changed := (benutils.column_changed(l_old.PROPOSAL_REASON

632: ,l_old.PROPOSED_SALARY_N,l_old_val) );
633: end if;
634: --
635: if l_column = 'PROPOSAL_REASON' then
636: l_changed := (benutils.column_changed(l_old.PROPOSAL_REASON
637: ,p_new.PROPOSAL_REASON,l_new_val) AND
638: benutils.column_changed(p_new.PROPOSAL_REASON
639: ,l_old.PROPOSAL_REASON,l_old_val) );
640: end if;

Line 638: benutils.column_changed(p_new.PROPOSAL_REASON

634: --
635: if l_column = 'PROPOSAL_REASON' then
636: l_changed := (benutils.column_changed(l_old.PROPOSAL_REASON
637: ,p_new.PROPOSAL_REASON,l_new_val) AND
638: benutils.column_changed(p_new.PROPOSAL_REASON
639: ,l_old.PROPOSAL_REASON,l_old_val) );
640: end if;
641: --
642: if l_column = 'REVIEW_DATE' then

Line 643: l_changed := (benutils.column_changed(l_old.REVIEW_DATE

639: ,l_old.PROPOSAL_REASON,l_old_val) );
640: end if;
641: --
642: if l_column = 'REVIEW_DATE' then
643: l_changed := (benutils.column_changed(l_old.REVIEW_DATE
644: ,p_new.REVIEW_DATE,l_new_val) AND
645: benutils.column_changed(p_new.REVIEW_DATE
646: ,l_old.REVIEW_DATE,l_old_val) );
647: end if;

Line 645: benutils.column_changed(p_new.REVIEW_DATE

641: --
642: if l_column = 'REVIEW_DATE' then
643: l_changed := (benutils.column_changed(l_old.REVIEW_DATE
644: ,p_new.REVIEW_DATE,l_new_val) AND
645: benutils.column_changed(p_new.REVIEW_DATE
646: ,l_old.REVIEW_DATE,l_old_val) );
647: end if;
648: --
649: if l_column = 'APPROVED' then

Line 650: l_changed := (benutils.column_changed(l_old.APPROVED

646: ,l_old.REVIEW_DATE,l_old_val) );
647: end if;
648: --
649: if l_column = 'APPROVED' then
650: l_changed := (benutils.column_changed(l_old.APPROVED
651: ,p_new.APPROVED,l_new_val) AND
652: benutils.column_changed(p_new.APPROVED
653: ,l_old.APPROVED,l_old_val) );
654: end if;

Line 652: benutils.column_changed(p_new.APPROVED

648: --
649: if l_column = 'APPROVED' then
650: l_changed := (benutils.column_changed(l_old.APPROVED
651: ,p_new.APPROVED,l_new_val) AND
652: benutils.column_changed(p_new.APPROVED
653: ,l_old.APPROVED,l_old_val) );
654: end if;
655: --
656: if l_column = 'MULTIPLE_COMPONENTS' then

Line 657: l_changed := (benutils.column_changed(l_old.MULTIPLE_COMPONENTS

653: ,l_old.APPROVED,l_old_val) );
654: end if;
655: --
656: if l_column = 'MULTIPLE_COMPONENTS' then
657: l_changed := (benutils.column_changed(l_old.MULTIPLE_COMPONENTS
658: ,p_new.MULTIPLE_COMPONENTS,l_new_val) AND
659: benutils.column_changed(p_new.MULTIPLE_COMPONENTS
660: ,l_old.MULTIPLE_COMPONENTS,l_old_val) );
661: end if;

Line 659: benutils.column_changed(p_new.MULTIPLE_COMPONENTS

655: --
656: if l_column = 'MULTIPLE_COMPONENTS' then
657: l_changed := (benutils.column_changed(l_old.MULTIPLE_COMPONENTS
658: ,p_new.MULTIPLE_COMPONENTS,l_new_val) AND
659: benutils.column_changed(p_new.MULTIPLE_COMPONENTS
660: ,l_old.MULTIPLE_COMPONENTS,l_old_val) );
661: end if;
662: --
663: if l_column = 'FORCED_RANKING' then

Line 664: l_changed := (benutils.column_changed(l_old.FORCED_RANKING

660: ,l_old.MULTIPLE_COMPONENTS,l_old_val) );
661: end if;
662: --
663: if l_column = 'FORCED_RANKING' then
664: l_changed := (benutils.column_changed(l_old.FORCED_RANKING
665: ,p_new.FORCED_RANKING,l_new_val) AND
666: benutils.column_changed(p_new.FORCED_RANKING
667: ,l_old.FORCED_RANKING,l_old_val) );
668: end if;

Line 666: benutils.column_changed(p_new.FORCED_RANKING

662: --
663: if l_column = 'FORCED_RANKING' then
664: l_changed := (benutils.column_changed(l_old.FORCED_RANKING
665: ,p_new.FORCED_RANKING,l_new_val) AND
666: benutils.column_changed(p_new.FORCED_RANKING
667: ,l_old.FORCED_RANKING,l_old_val) );
668: end if;
669: --
670: if l_column = 'PERFORMANCE_REVIEW_ID' then

Line 671: l_changed := (benutils.column_changed(l_old.PERFORMANCE_REVIEW_ID

667: ,l_old.FORCED_RANKING,l_old_val) );
668: end if;
669: --
670: if l_column = 'PERFORMANCE_REVIEW_ID' then
671: l_changed := (benutils.column_changed(l_old.PERFORMANCE_REVIEW_ID
672: ,p_new.PERFORMANCE_REVIEW_ID,l_new_val) AND
673: benutils.column_changed(p_new.PERFORMANCE_REVIEW_ID
674: ,l_old.PERFORMANCE_REVIEW_ID,l_old_val) );
675: end if;

Line 673: benutils.column_changed(p_new.PERFORMANCE_REVIEW_ID

669: --
670: if l_column = 'PERFORMANCE_REVIEW_ID' then
671: l_changed := (benutils.column_changed(l_old.PERFORMANCE_REVIEW_ID
672: ,p_new.PERFORMANCE_REVIEW_ID,l_new_val) AND
673: benutils.column_changed(p_new.PERFORMANCE_REVIEW_ID
674: ,l_old.PERFORMANCE_REVIEW_ID,l_old_val) );
675: end if;
676: --
677: if l_column = 'EVENT_ID' then

Line 678: l_changed := (benutils.column_changed(l_old.EVENT_ID

674: ,l_old.PERFORMANCE_REVIEW_ID,l_old_val) );
675: end if;
676: --
677: if l_column = 'EVENT_ID' then
678: l_changed := (benutils.column_changed(l_old.EVENT_ID
679: ,p_new.EVENT_ID,l_new_val) AND
680: benutils.column_changed(p_new.EVENT_ID
681: ,l_old.EVENT_ID,l_old_val) );
682: end if;

Line 680: benutils.column_changed(p_new.EVENT_ID

676: --
677: if l_column = 'EVENT_ID' then
678: l_changed := (benutils.column_changed(l_old.EVENT_ID
679: ,p_new.EVENT_ID,l_new_val) AND
680: benutils.column_changed(p_new.EVENT_ID
681: ,l_old.EVENT_ID,l_old_val) );
682: end if;
683: --
684: if l_column = 'PROPOSED_SALARY' then

Line 685: l_changed := (benutils.column_changed(l_old.PROPOSED_SALARY

681: ,l_old.EVENT_ID,l_old_val) );
682: end if;
683: --
684: if l_column = 'PROPOSED_SALARY' then
685: l_changed := (benutils.column_changed(l_old.PROPOSED_SALARY
686: ,p_new.PROPOSED_SALARY,l_new_val) AND
687: benutils.column_changed(p_new.PROPOSED_SALARY
688: ,l_old.PROPOSED_SALARY,l_old_val) );
689: end if;

Line 687: benutils.column_changed(p_new.PROPOSED_SALARY

683: --
684: if l_column = 'PROPOSED_SALARY' then
685: l_changed := (benutils.column_changed(l_old.PROPOSED_SALARY
686: ,p_new.PROPOSED_SALARY,l_new_val) AND
687: benutils.column_changed(p_new.PROPOSED_SALARY
688: ,l_old.PROPOSED_SALARY,l_old_val) );
689: end if;
690: --
691: if l_column = 'ATTRIBUTE1' then

Line 692: l_changed := (benutils.column_changed(l_old.ATTRIBUTE1

688: ,l_old.PROPOSED_SALARY,l_old_val) );
689: end if;
690: --
691: if l_column = 'ATTRIBUTE1' then
692: l_changed := (benutils.column_changed(l_old.ATTRIBUTE1
693: ,p_new.ATTRIBUTE1,l_new_val) AND
694: benutils.column_changed(p_new.ATTRIBUTE1
695: ,l_old.ATTRIBUTE1,l_old_val) );
696: end if;

Line 694: benutils.column_changed(p_new.ATTRIBUTE1

690: --
691: if l_column = 'ATTRIBUTE1' then
692: l_changed := (benutils.column_changed(l_old.ATTRIBUTE1
693: ,p_new.ATTRIBUTE1,l_new_val) AND
694: benutils.column_changed(p_new.ATTRIBUTE1
695: ,l_old.ATTRIBUTE1,l_old_val) );
696: end if;
697: --
698: if l_column = 'ATTRIBUTE2' then

Line 699: l_changed := (benutils.column_changed(l_old.ATTRIBUTE2

695: ,l_old.ATTRIBUTE1,l_old_val) );
696: end if;
697: --
698: if l_column = 'ATTRIBUTE2' then
699: l_changed := (benutils.column_changed(l_old.ATTRIBUTE2
700: ,p_new.ATTRIBUTE2,l_new_val) AND
701: benutils.column_changed(p_new.ATTRIBUTE2
702: ,l_old.ATTRIBUTE2,l_old_val) );
703: end if;

Line 701: benutils.column_changed(p_new.ATTRIBUTE2

697: --
698: if l_column = 'ATTRIBUTE2' then
699: l_changed := (benutils.column_changed(l_old.ATTRIBUTE2
700: ,p_new.ATTRIBUTE2,l_new_val) AND
701: benutils.column_changed(p_new.ATTRIBUTE2
702: ,l_old.ATTRIBUTE2,l_old_val) );
703: end if;
704: --
705: if l_column = 'ATTRIBUTE3' then

Line 706: l_changed := (benutils.column_changed(l_old.ATTRIBUTE3

702: ,l_old.ATTRIBUTE2,l_old_val) );
703: end if;
704: --
705: if l_column = 'ATTRIBUTE3' then
706: l_changed := (benutils.column_changed(l_old.ATTRIBUTE3
707: ,p_new.ATTRIBUTE3,l_new_val) AND
708: benutils.column_changed(p_new.ATTRIBUTE3
709: ,l_old.ATTRIBUTE3,l_old_val) );
710: end if;

Line 708: benutils.column_changed(p_new.ATTRIBUTE3

704: --
705: if l_column = 'ATTRIBUTE3' then
706: l_changed := (benutils.column_changed(l_old.ATTRIBUTE3
707: ,p_new.ATTRIBUTE3,l_new_val) AND
708: benutils.column_changed(p_new.ATTRIBUTE3
709: ,l_old.ATTRIBUTE3,l_old_val) );
710: end if;
711: --
712: if l_column = 'ATTRIBUTE4' then

Line 713: l_changed := (benutils.column_changed(l_old.ATTRIBUTE4

709: ,l_old.ATTRIBUTE3,l_old_val) );
710: end if;
711: --
712: if l_column = 'ATTRIBUTE4' then
713: l_changed := (benutils.column_changed(l_old.ATTRIBUTE4
714: ,p_new.ATTRIBUTE4,l_new_val) AND
715: benutils.column_changed(p_new.ATTRIBUTE4
716: ,l_old.ATTRIBUTE4,l_old_val) );
717: end if;

Line 715: benutils.column_changed(p_new.ATTRIBUTE4

711: --
712: if l_column = 'ATTRIBUTE4' then
713: l_changed := (benutils.column_changed(l_old.ATTRIBUTE4
714: ,p_new.ATTRIBUTE4,l_new_val) AND
715: benutils.column_changed(p_new.ATTRIBUTE4
716: ,l_old.ATTRIBUTE4,l_old_val) );
717: end if;
718: --
719: if l_column = 'ATTRIBUTE5' then

Line 720: l_changed := (benutils.column_changed(l_old.ATTRIBUTE5

716: ,l_old.ATTRIBUTE4,l_old_val) );
717: end if;
718: --
719: if l_column = 'ATTRIBUTE5' then
720: l_changed := (benutils.column_changed(l_old.ATTRIBUTE5
721: ,p_new.ATTRIBUTE5,l_new_val) AND
722: benutils.column_changed(p_new.ATTRIBUTE5
723: ,l_old.ATTRIBUTE5,l_old_val) );
724: end if;

Line 722: benutils.column_changed(p_new.ATTRIBUTE5

718: --
719: if l_column = 'ATTRIBUTE5' then
720: l_changed := (benutils.column_changed(l_old.ATTRIBUTE5
721: ,p_new.ATTRIBUTE5,l_new_val) AND
722: benutils.column_changed(p_new.ATTRIBUTE5
723: ,l_old.ATTRIBUTE5,l_old_val) );
724: end if;
725: --
726: if l_column = 'ATTRIBUTE6' then

Line 727: l_changed := (benutils.column_changed(l_old.ATTRIBUTE6

723: ,l_old.ATTRIBUTE5,l_old_val) );
724: end if;
725: --
726: if l_column = 'ATTRIBUTE6' then
727: l_changed := (benutils.column_changed(l_old.ATTRIBUTE6
728: ,p_new.ATTRIBUTE6,l_new_val) AND
729: benutils.column_changed(p_new.ATTRIBUTE6
730: ,l_old.ATTRIBUTE6,l_old_val) );
731: end if;

Line 729: benutils.column_changed(p_new.ATTRIBUTE6

725: --
726: if l_column = 'ATTRIBUTE6' then
727: l_changed := (benutils.column_changed(l_old.ATTRIBUTE6
728: ,p_new.ATTRIBUTE6,l_new_val) AND
729: benutils.column_changed(p_new.ATTRIBUTE6
730: ,l_old.ATTRIBUTE6,l_old_val) );
731: end if;
732: --
733: if l_column = 'ATTRIBUTE7' then

Line 734: l_changed := (benutils.column_changed(l_old.ATTRIBUTE7

730: ,l_old.ATTRIBUTE6,l_old_val) );
731: end if;
732: --
733: if l_column = 'ATTRIBUTE7' then
734: l_changed := (benutils.column_changed(l_old.ATTRIBUTE7
735: ,p_new.ATTRIBUTE7,l_new_val) AND
736: benutils.column_changed(p_new.ATTRIBUTE7
737: ,l_old.ATTRIBUTE7,l_old_val) );
738: end if;

Line 736: benutils.column_changed(p_new.ATTRIBUTE7

732: --
733: if l_column = 'ATTRIBUTE7' then
734: l_changed := (benutils.column_changed(l_old.ATTRIBUTE7
735: ,p_new.ATTRIBUTE7,l_new_val) AND
736: benutils.column_changed(p_new.ATTRIBUTE7
737: ,l_old.ATTRIBUTE7,l_old_val) );
738: end if;
739: --
740: if l_column = 'ATTRIBUTE8' then

Line 741: l_changed := (benutils.column_changed(l_old.ATTRIBUTE8

737: ,l_old.ATTRIBUTE7,l_old_val) );
738: end if;
739: --
740: if l_column = 'ATTRIBUTE8' then
741: l_changed := (benutils.column_changed(l_old.ATTRIBUTE8
742: ,p_new.ATTRIBUTE8,l_new_val) AND
743: benutils.column_changed(p_new.ATTRIBUTE8
744: ,l_old.ATTRIBUTE8,l_old_val) );
745: end if;

Line 743: benutils.column_changed(p_new.ATTRIBUTE8

739: --
740: if l_column = 'ATTRIBUTE8' then
741: l_changed := (benutils.column_changed(l_old.ATTRIBUTE8
742: ,p_new.ATTRIBUTE8,l_new_val) AND
743: benutils.column_changed(p_new.ATTRIBUTE8
744: ,l_old.ATTRIBUTE8,l_old_val) );
745: end if;
746: --
747: if l_column = 'ATTRIBUTE9' then

Line 748: l_changed := (benutils.column_changed(l_old.ATTRIBUTE9

744: ,l_old.ATTRIBUTE8,l_old_val) );
745: end if;
746: --
747: if l_column = 'ATTRIBUTE9' then
748: l_changed := (benutils.column_changed(l_old.ATTRIBUTE9
749: ,p_new.ATTRIBUTE9,l_new_val) AND
750: benutils.column_changed(p_new.ATTRIBUTE9
751: ,l_old.ATTRIBUTE9,l_old_val) );
752: end if;

Line 750: benutils.column_changed(p_new.ATTRIBUTE9

746: --
747: if l_column = 'ATTRIBUTE9' then
748: l_changed := (benutils.column_changed(l_old.ATTRIBUTE9
749: ,p_new.ATTRIBUTE9,l_new_val) AND
750: benutils.column_changed(p_new.ATTRIBUTE9
751: ,l_old.ATTRIBUTE9,l_old_val) );
752: end if;
753: --
754: if l_column = 'ATTRIBUTE10' then

Line 755: l_changed := (benutils.column_changed(l_old.ATTRIBUTE10

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

Line 757: benutils.column_changed(p_new.ATTRIBUTE10

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

Line 762: l_changed := (benutils.column_changed(l_old.ATTRIBUTE11

758: ,l_old.ATTRIBUTE10,l_old_val) );
759: end if;
760: --
761: if l_column = 'ATTRIBUTE11' then
762: l_changed := (benutils.column_changed(l_old.ATTRIBUTE11
763: ,p_new.ATTRIBUTE11,l_new_val) AND
764: benutils.column_changed(p_new.ATTRIBUTE11
765: ,l_old.ATTRIBUTE11,l_old_val) );
766: end if;

Line 764: benutils.column_changed(p_new.ATTRIBUTE11

760: --
761: if l_column = 'ATTRIBUTE11' then
762: l_changed := (benutils.column_changed(l_old.ATTRIBUTE11
763: ,p_new.ATTRIBUTE11,l_new_val) AND
764: benutils.column_changed(p_new.ATTRIBUTE11
765: ,l_old.ATTRIBUTE11,l_old_val) );
766: end if;
767: --
768: if l_column = 'ATTRIBUTE12' then

Line 769: l_changed := (benutils.column_changed(l_old.ATTRIBUTE12

765: ,l_old.ATTRIBUTE11,l_old_val) );
766: end if;
767: --
768: if l_column = 'ATTRIBUTE12' then
769: l_changed := (benutils.column_changed(l_old.ATTRIBUTE12
770: ,p_new.ATTRIBUTE12,l_new_val) AND
771: benutils.column_changed(p_new.ATTRIBUTE12
772: ,l_old.ATTRIBUTE12,l_old_val) );
773: end if;

Line 771: benutils.column_changed(p_new.ATTRIBUTE12

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

Line 776: l_changed := (benutils.column_changed(l_old.ATTRIBUTE13

772: ,l_old.ATTRIBUTE12,l_old_val) );
773: end if;
774: --
775: if l_column = 'ATTRIBUTE13' then
776: l_changed := (benutils.column_changed(l_old.ATTRIBUTE13
777: ,p_new.ATTRIBUTE13,l_new_val) AND
778: benutils.column_changed(p_new.ATTRIBUTE13
779: ,l_old.ATTRIBUTE13,l_old_val) );
780: end if;

Line 778: benutils.column_changed(p_new.ATTRIBUTE13

774: --
775: if l_column = 'ATTRIBUTE13' then
776: l_changed := (benutils.column_changed(l_old.ATTRIBUTE13
777: ,p_new.ATTRIBUTE13,l_new_val) AND
778: benutils.column_changed(p_new.ATTRIBUTE13
779: ,l_old.ATTRIBUTE13,l_old_val) );
780: end if;
781: --
782: if l_column = 'ATTRIBUTE14' then

Line 783: l_changed := (benutils.column_changed(l_old.ATTRIBUTE14

779: ,l_old.ATTRIBUTE13,l_old_val) );
780: end if;
781: --
782: if l_column = 'ATTRIBUTE14' then
783: l_changed := (benutils.column_changed(l_old.ATTRIBUTE14
784: ,p_new.ATTRIBUTE14,l_new_val) AND
785: benutils.column_changed(p_new.ATTRIBUTE14
786: ,l_old.ATTRIBUTE14,l_old_val) );
787: end if;

Line 785: benutils.column_changed(p_new.ATTRIBUTE14

781: --
782: if l_column = 'ATTRIBUTE14' then
783: l_changed := (benutils.column_changed(l_old.ATTRIBUTE14
784: ,p_new.ATTRIBUTE14,l_new_val) AND
785: benutils.column_changed(p_new.ATTRIBUTE14
786: ,l_old.ATTRIBUTE14,l_old_val) );
787: end if;
788: --
789: if l_column = 'ATTRIBUTE15' then

Line 790: l_changed := (benutils.column_changed(l_old.ATTRIBUTE15

786: ,l_old.ATTRIBUTE14,l_old_val) );
787: end if;
788: --
789: if l_column = 'ATTRIBUTE15' then
790: l_changed := (benutils.column_changed(l_old.ATTRIBUTE15
791: ,p_new.ATTRIBUTE15,l_new_val) AND
792: benutils.column_changed(p_new.ATTRIBUTE15
793: ,l_old.ATTRIBUTE15,l_old_val) );
794: end if;

Line 792: benutils.column_changed(p_new.ATTRIBUTE15

788: --
789: if l_column = 'ATTRIBUTE15' then
790: l_changed := (benutils.column_changed(l_old.ATTRIBUTE15
791: ,p_new.ATTRIBUTE15,l_new_val) AND
792: benutils.column_changed(p_new.ATTRIBUTE15
793: ,l_old.ATTRIBUTE15,l_old_val) );
794: end if;
795: --
796: if l_column = 'ATTRIBUTE16' then

Line 797: l_changed := (benutils.column_changed(l_old.ATTRIBUTE16

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

Line 799: benutils.column_changed(p_new.ATTRIBUTE16

795: --
796: if l_column = 'ATTRIBUTE16' then
797: l_changed := (benutils.column_changed(l_old.ATTRIBUTE16
798: ,p_new.ATTRIBUTE16,l_new_val) AND
799: benutils.column_changed(p_new.ATTRIBUTE16
800: ,l_old.ATTRIBUTE16,l_old_val) );
801: end if;
802: --
803: if l_column = 'ATTRIBUTE17' then

Line 804: l_changed := (benutils.column_changed(l_old.ATTRIBUTE17

800: ,l_old.ATTRIBUTE16,l_old_val) );
801: end if;
802: --
803: if l_column = 'ATTRIBUTE17' then
804: l_changed := (benutils.column_changed(l_old.ATTRIBUTE17
805: ,p_new.ATTRIBUTE17,l_new_val) AND
806: benutils.column_changed(p_new.ATTRIBUTE17
807: ,l_old.ATTRIBUTE17,l_old_val) );
808: end if;

Line 806: benutils.column_changed(p_new.ATTRIBUTE17

802: --
803: if l_column = 'ATTRIBUTE17' then
804: l_changed := (benutils.column_changed(l_old.ATTRIBUTE17
805: ,p_new.ATTRIBUTE17,l_new_val) AND
806: benutils.column_changed(p_new.ATTRIBUTE17
807: ,l_old.ATTRIBUTE17,l_old_val) );
808: end if;
809: --
810: if l_column = 'ATTRIBUTE18' then

Line 811: l_changed := (benutils.column_changed(l_old.ATTRIBUTE18

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

Line 813: benutils.column_changed(p_new.ATTRIBUTE18

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

Line 818: l_changed := (benutils.column_changed(l_old.ATTRIBUTE20

814: ,l_old.ATTRIBUTE18,l_old_val) );
815: end if;
816: --
817: if l_column = 'ATTRIBUTE20' then
818: l_changed := (benutils.column_changed(l_old.ATTRIBUTE20
819: ,p_new.ATTRIBUTE20,l_new_val) AND
820: benutils.column_changed(p_new.ATTRIBUTE20
821: ,l_old.ATTRIBUTE20,l_old_val) );
822: end if;

Line 820: benutils.column_changed(p_new.ATTRIBUTE20

816: --
817: if l_column = 'ATTRIBUTE20' then
818: l_changed := (benutils.column_changed(l_old.ATTRIBUTE20
819: ,p_new.ATTRIBUTE20,l_new_val) AND
820: benutils.column_changed(p_new.ATTRIBUTE20
821: ,l_old.ATTRIBUTE20,l_old_val) );
822: end if;
823: --
824: -- Checking the rule output and the rule override flag.