DBA Data[Home] [Help]

APPS.BEN_CON_LER dependencies on BENUTILS

Line 179: benutils.set_data_migrator_mode;

175:
176: begin
177: --
178: -- Bug 2016857
179: benutils.set_data_migrator_mode;
180: -- Bug 2016857
181: if hr_general.g_data_migrator_mode in ( 'Y','P') then
182: --
183: return;

Line 571: benutils.exec_rule(

567: populate_param_tab('BEN_IV_LER_ID', to_char(l_ler_id));
568: hr_utility.set_location('Done Populating the g_param_tab', 66);
569: -- End Fix 4911130
570:
571: benutils.exec_rule(
572: p_formula_id => l_per_info_chg_cs_ler_rl,
573: p_effective_date => l_session_date,
574: p_lf_evt_ocrd_dt => null,
575: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 592: l_changed := (benutils.column_changed(p_old.date_start

588: --
589: if l_column = 'DATE_START' then
590: hr_utility.set_location('Old Start Date '||p_old.date_start,10);
591: hr_utility.set_location('New Start Date '||p_new.date_start,10);
592: l_changed := (benutils.column_changed(p_old.date_start
593: ,p_new.date_start,l_new_val) AND
594: benutils.column_changed(p_new.date_start
595: ,p_old.date_start,l_old_val) AND
596: (l_changed));

Line 594: benutils.column_changed(p_new.date_start

590: hr_utility.set_location('Old Start Date '||p_old.date_start,10);
591: hr_utility.set_location('New Start Date '||p_new.date_start,10);
592: l_changed := (benutils.column_changed(p_old.date_start
593: ,p_new.date_start,l_new_val) AND
594: benutils.column_changed(p_new.date_start
595: ,p_old.date_start,l_old_val) AND
596: (l_changed));
597: l_dtctd_dt := l_date_start;
598: end if;

Line 601: l_changed := (benutils.column_changed(p_old.date_end

597: l_dtctd_dt := l_date_start;
598: end if;
599:
600: if l_column = 'DATE_END' then
601: l_changed := (benutils.column_changed(p_old.date_end
602: ,p_new.date_end,l_new_val) AND
603: benutils.column_changed(p_new.date_end
604: ,p_old.date_end,l_old_val) AND
605: (l_person_esd <= l_session_date) AND -- Added for 3105696

Line 603: benutils.column_changed(p_new.date_end

599:
600: if l_column = 'DATE_END' then
601: l_changed := (benutils.column_changed(p_old.date_end
602: ,p_new.date_end,l_new_val) AND
603: benutils.column_changed(p_new.date_end
604: ,p_old.date_end,l_old_val) AND
605: (l_person_esd <= l_session_date) AND -- Added for 3105696
606: (l_changed));
607: hr_utility.set_location(' l_person_esd (DATE END) ' ||l_person_esd, 70);

Line 628: l_changed := (benutils.column_changed(p_old.contact_type

624:
625: if l_column = 'CONTACT_TYPE' then
626: hr_utility.set_location('Old ConTYp '||p_old.contact_type, 80);
627: hr_utility.set_location('New ConTYp '||p_new.contact_type, 80);
628: l_changed := (benutils.column_changed(p_old.contact_type
629: ,p_new.contact_type,l_new_val) AND
630: benutils.column_changed(p_new.contact_type
631: ,p_old.contact_type,l_old_val) AND
632: (l_changed));

Line 630: benutils.column_changed(p_new.contact_type

626: hr_utility.set_location('Old ConTYp '||p_old.contact_type, 80);
627: hr_utility.set_location('New ConTYp '||p_new.contact_type, 80);
628: l_changed := (benutils.column_changed(p_old.contact_type
629: ,p_new.contact_type,l_new_val) AND
630: benutils.column_changed(p_new.contact_type
631: ,p_old.contact_type,l_old_val) AND
632: (l_changed));
633: end if;
634:

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

634:
635: if l_column = 'PERSONAL_FLAG' then
636: hr_utility.set_location('Old Per_flag '||p_old.personal_flag, 90);
637: hr_utility.set_location('New Per_flag '||p_new.personal_flag, 90);
638: l_changed := (benutils.column_changed(p_old.personal_flag
639: ,p_new.personal_flag,l_new_val) AND
640: benutils.column_changed(p_new.personal_flag
641: ,p_old.personal_flag,l_old_val) AND
642: (l_changed));

Line 640: benutils.column_changed(p_new.personal_flag

636: hr_utility.set_location('Old Per_flag '||p_old.personal_flag, 90);
637: hr_utility.set_location('New Per_flag '||p_new.personal_flag, 90);
638: l_changed := (benutils.column_changed(p_old.personal_flag
639: ,p_new.personal_flag,l_new_val) AND
640: benutils.column_changed(p_new.personal_flag
641: ,p_old.personal_flag,l_old_val) AND
642: (l_changed));
643: end if;
644:

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

643: end if;
644:
645: if l_column = 'START_LIFE_REASON_ID' then
646:
647: l_changed := (benutils.column_changed(p_old.start_life_reason_id
648: ,p_new.start_life_reason_id,l_new_val) AND
649: benutils.column_changed(p_new.start_life_reason_id
650: ,p_old.start_life_reason_id,l_old_val) AND
651: (l_changed));

Line 649: benutils.column_changed(p_new.start_life_reason_id

645: if l_column = 'START_LIFE_REASON_ID' then
646:
647: l_changed := (benutils.column_changed(p_old.start_life_reason_id
648: ,p_new.start_life_reason_id,l_new_val) AND
649: benutils.column_changed(p_new.start_life_reason_id
650: ,p_old.start_life_reason_id,l_old_val) AND
651: (l_changed));
652: end if;
653:

Line 655: l_changed := (benutils.column_changed(p_old.end_life_reason_id

651: (l_changed));
652: end if;
653:
654: if l_column = 'END_LIFE_REASON_ID' then
655: l_changed := (benutils.column_changed(p_old.end_life_reason_id
656: ,p_new.end_life_reason_id,l_new_val) AND
657: benutils.column_changed(p_new.end_life_reason_id
658: ,p_old.end_life_reason_id,l_old_val) AND
659: (l_person_esd <= l_session_date) AND -- Added for 3105696

Line 657: benutils.column_changed(p_new.end_life_reason_id

653:
654: if l_column = 'END_LIFE_REASON_ID' then
655: l_changed := (benutils.column_changed(p_old.end_life_reason_id
656: ,p_new.end_life_reason_id,l_new_val) AND
657: benutils.column_changed(p_new.end_life_reason_id
658: ,p_old.end_life_reason_id,l_old_val) AND
659: (l_person_esd <= l_session_date) AND -- Added for 3105696
660: (l_changed));
661: hr_utility.set_location(' l_person_esd (END_LIFE_REASON_ID) ' ||l_person_esd, 70);

Line 680: l_changed := (benutils.column_changed(p_old.rltd_per_rsds_w_dsgntr_flag

676: l_dtctd_dt := l_date_end;
677: end if;
678:
679: if l_column = 'RLTD_PER_RSDS_W_DSGNTR_FLAG' then
680: l_changed := (benutils.column_changed(p_old.rltd_per_rsds_w_dsgntr_flag
681: ,p_new.rltd_per_rsds_w_dsgntr_flag,l_new_val) AND
682: benutils.column_changed(p_new.rltd_per_rsds_w_dsgntr_flag
683: ,p_old.rltd_per_rsds_w_dsgntr_flag,l_old_val) AND
684: (l_changed));

Line 682: benutils.column_changed(p_new.rltd_per_rsds_w_dsgntr_flag

678:
679: if l_column = 'RLTD_PER_RSDS_W_DSGNTR_FLAG' then
680: l_changed := (benutils.column_changed(p_old.rltd_per_rsds_w_dsgntr_flag
681: ,p_new.rltd_per_rsds_w_dsgntr_flag,l_new_val) AND
682: benutils.column_changed(p_new.rltd_per_rsds_w_dsgntr_flag
683: ,p_old.rltd_per_rsds_w_dsgntr_flag,l_old_val) AND
684: (l_changed));
685: end if;
686: --

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

688: --
689: -- Bug 1772037 fix
690: --
691: if l_column = 'CONT_ATTRIBUTE1' then
692: l_changed := (benutils.column_changed(p_old.cont_attribute1
693: ,p_new.cont_attribute1,l_new_val) AND
694: benutils.column_changed(p_new.cont_attribute1
695: ,p_old.cont_attribute1,l_old_val) AND
696: (l_changed));

Line 694: benutils.column_changed(p_new.cont_attribute1

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

Line 700: l_changed := (benutils.column_changed(p_old.cont_attribute2

696: (l_changed));
697: end if;
698: --
699: if l_column = 'CONT_ATTRIBUTE2' then
700: l_changed := (benutils.column_changed(p_old.cont_attribute2
701: ,p_new.cont_attribute2,l_new_val) AND
702: benutils.column_changed(p_new.cont_attribute2
703: ,p_old.cont_attribute2,l_old_val) AND
704: (l_changed));

Line 702: benutils.column_changed(p_new.cont_attribute2

698: --
699: if l_column = 'CONT_ATTRIBUTE2' then
700: l_changed := (benutils.column_changed(p_old.cont_attribute2
701: ,p_new.cont_attribute2,l_new_val) AND
702: benutils.column_changed(p_new.cont_attribute2
703: ,p_old.cont_attribute2,l_old_val) AND
704: (l_changed));
705: end if;
706: --

Line 708: l_changed := (benutils.column_changed(p_old.cont_attribute3

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

Line 710: benutils.column_changed(p_new.cont_attribute3

706: --
707: if l_column = 'CONT_ATTRIBUTE3' then
708: l_changed := (benutils.column_changed(p_old.cont_attribute3
709: ,p_new.cont_attribute3,l_new_val) AND
710: benutils.column_changed(p_new.cont_attribute3
711: ,p_old.cont_attribute3,l_old_val) AND
712: (l_changed));
713: end if;
714: --

Line 716: l_changed := (benutils.column_changed(p_old.cont_attribute4

712: (l_changed));
713: end if;
714: --
715: if l_column = 'CONT_ATTRIBUTE4' then
716: l_changed := (benutils.column_changed(p_old.cont_attribute4
717: ,p_new.cont_attribute4,l_new_val) AND
718: benutils.column_changed(p_new.cont_attribute4
719: ,p_old.cont_attribute4,l_old_val) AND
720: (l_changed));

Line 718: benutils.column_changed(p_new.cont_attribute4

714: --
715: if l_column = 'CONT_ATTRIBUTE4' then
716: l_changed := (benutils.column_changed(p_old.cont_attribute4
717: ,p_new.cont_attribute4,l_new_val) AND
718: benutils.column_changed(p_new.cont_attribute4
719: ,p_old.cont_attribute4,l_old_val) AND
720: (l_changed));
721: end if;
722: --

Line 724: l_changed := (benutils.column_changed(p_old.cont_attribute5

720: (l_changed));
721: end if;
722: --
723: if l_column = 'CONT_ATTRIBUTE5' then
724: l_changed := (benutils.column_changed(p_old.cont_attribute5
725: ,p_new.cont_attribute5,l_new_val) AND
726: benutils.column_changed(p_new.cont_attribute5
727: ,p_old.cont_attribute5,l_old_val) AND
728: (l_changed));

Line 726: benutils.column_changed(p_new.cont_attribute5

722: --
723: if l_column = 'CONT_ATTRIBUTE5' then
724: l_changed := (benutils.column_changed(p_old.cont_attribute5
725: ,p_new.cont_attribute5,l_new_val) AND
726: benutils.column_changed(p_new.cont_attribute5
727: ,p_old.cont_attribute5,l_old_val) AND
728: (l_changed));
729: end if;
730: --

Line 732: l_changed := (benutils.column_changed(p_old.cont_attribute6

728: (l_changed));
729: end if;
730: --
731: if l_column = 'CONT_ATTRIBUTE6' then
732: l_changed := (benutils.column_changed(p_old.cont_attribute6
733: ,p_new.cont_attribute6,l_new_val) AND
734: benutils.column_changed(p_new.cont_attribute6
735: ,p_old.cont_attribute6,l_old_val) AND
736: (l_changed));

Line 734: benutils.column_changed(p_new.cont_attribute6

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

Line 740: l_changed := (benutils.column_changed(p_old.cont_attribute7

736: (l_changed));
737: end if;
738: --
739: if l_column = 'CONT_ATTRIBUTE7' then
740: l_changed := (benutils.column_changed(p_old.cont_attribute7
741: ,p_new.cont_attribute7,l_new_val) AND
742: benutils.column_changed(p_new.cont_attribute7
743: ,p_old.cont_attribute7,l_old_val) AND
744: (l_changed));

Line 742: benutils.column_changed(p_new.cont_attribute7

738: --
739: if l_column = 'CONT_ATTRIBUTE7' then
740: l_changed := (benutils.column_changed(p_old.cont_attribute7
741: ,p_new.cont_attribute7,l_new_val) AND
742: benutils.column_changed(p_new.cont_attribute7
743: ,p_old.cont_attribute7,l_old_val) AND
744: (l_changed));
745: end if;
746: --

Line 748: l_changed := (benutils.column_changed(p_old.cont_attribute8

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

Line 750: benutils.column_changed(p_new.cont_attribute8

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

Line 756: l_changed := (benutils.column_changed(p_old.cont_attribute9

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

Line 758: benutils.column_changed(p_new.cont_attribute9

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

Line 764: l_changed := (benutils.column_changed(p_old.cont_attribute10

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

Line 766: benutils.column_changed(p_new.cont_attribute10

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

Line 772: l_changed := (benutils.column_changed(p_old.cont_attribute11

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

Line 774: benutils.column_changed(p_new.cont_attribute11

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

Line 780: l_changed := (benutils.column_changed(p_old.cont_attribute12

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

Line 782: benutils.column_changed(p_new.cont_attribute12

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

Line 788: l_changed := (benutils.column_changed(p_old.cont_attribute13

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

Line 790: benutils.column_changed(p_new.cont_attribute13

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

Line 796: l_changed := (benutils.column_changed(p_old.cont_attribute14

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

Line 798: benutils.column_changed(p_new.cont_attribute14

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

Line 804: l_changed := (benutils.column_changed(p_old.cont_attribute15

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

Line 806: benutils.column_changed(p_new.cont_attribute15

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

Line 812: l_changed := (benutils.column_changed(p_old.cont_attribute16

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

Line 814: benutils.column_changed(p_new.cont_attribute16

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

Line 820: l_changed := (benutils.column_changed(p_old.cont_attribute17

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

Line 822: benutils.column_changed(p_new.cont_attribute17

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

Line 828: l_changed := (benutils.column_changed(p_old.cont_attribute18

824: (l_changed));
825: end if;
826: --
827: if l_column = 'CONT_ATTRIBUTE18' then
828: l_changed := (benutils.column_changed(p_old.cont_attribute18
829: ,p_new.cont_attribute18,l_new_val) AND
830: benutils.column_changed(p_new.cont_attribute18
831: ,p_old.cont_attribute18,l_old_val) AND
832: (l_changed));

Line 830: benutils.column_changed(p_new.cont_attribute18

826: --
827: if l_column = 'CONT_ATTRIBUTE18' then
828: l_changed := (benutils.column_changed(p_old.cont_attribute18
829: ,p_new.cont_attribute18,l_new_val) AND
830: benutils.column_changed(p_new.cont_attribute18
831: ,p_old.cont_attribute18,l_old_val) AND
832: (l_changed));
833: end if;
834: --

Line 836: l_changed := (benutils.column_changed(p_old.cont_attribute19

832: (l_changed));
833: end if;
834: --
835: if l_column = 'CONT_ATTRIBUTE19' then
836: l_changed := (benutils.column_changed(p_old.cont_attribute19
837: ,p_new.cont_attribute19,l_new_val) AND
838: benutils.column_changed(p_new.cont_attribute19
839: ,p_old.cont_attribute19,l_old_val) AND
840: (l_changed));

Line 838: benutils.column_changed(p_new.cont_attribute19

834: --
835: if l_column = 'CONT_ATTRIBUTE19' then
836: l_changed := (benutils.column_changed(p_old.cont_attribute19
837: ,p_new.cont_attribute19,l_new_val) AND
838: benutils.column_changed(p_new.cont_attribute19
839: ,p_old.cont_attribute19,l_old_val) AND
840: (l_changed));
841: end if;
842: --

Line 844: l_changed := (benutils.column_changed(p_old.cont_attribute20

840: (l_changed));
841: end if;
842: --
843: if l_column = 'CONT_ATTRIBUTE20' then
844: l_changed := (benutils.column_changed(p_old.cont_attribute20
845: ,p_new.cont_attribute20,l_new_val) AND
846: benutils.column_changed(p_new.cont_attribute20
847: ,p_old.cont_attribute20,l_old_val) AND
848: (l_changed));

Line 846: benutils.column_changed(p_new.cont_attribute20

842: --
843: if l_column = 'CONT_ATTRIBUTE20' then
844: l_changed := (benutils.column_changed(p_old.cont_attribute20
845: ,p_new.cont_attribute20,l_new_val) AND
846: benutils.column_changed(p_new.cont_attribute20
847: ,p_old.cont_attribute20,l_old_val) AND
848: (l_changed));
849: end if;
850: --