178: --
179: begin
180:
181: -- Bug 3320133
182: benutils.set_data_migrator_mode;
183: if hr_general.g_data_migrator_mode in ( 'Y','P') then
184: --
185: return;
186: --
424: l_col_new_val := p_new.ATTRIBUTE20;
425: end if;
426: --
427: --
428: benutils.exec_rule(
429: p_formula_id => l_per_info_chg_cs_ler_rl,
430: p_effective_date => l_session_date,
431: p_lf_evt_ocrd_dt => null,
432: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),
521:
522: if l_column = 'START_DATE' then
523: hr_utility.set_location('Old Start Date '||p_old.start_date,10);
524: hr_utility.set_location('New Start Date '||p_new.start_date,10);
525: l_changed := (benutils.column_changed(p_old.start_date
526: ,p_new.start_date,l_new_val) AND
527: benutils.column_changed(p_new.start_date
528: ,p_old.start_date,l_old_val) AND
529: (l_changed));
523: hr_utility.set_location('Old Start Date '||p_old.start_date,10);
524: hr_utility.set_location('New Start Date '||p_new.start_date,10);
525: l_changed := (benutils.column_changed(p_old.start_date
526: ,p_new.start_date,l_new_val) AND
527: benutils.column_changed(p_new.start_date
528: ,p_old.start_date,l_old_val) AND
529: (l_changed));
530: end if;
531: --
529: (l_changed));
530: end if;
531: --
532: if l_column = 'END_DATE' then
533: l_changed := (benutils.column_changed(p_old.end_date
534: ,p_new.end_date,l_new_val) AND
535: benutils.column_changed(p_new.end_date
536: ,p_old.end_date,l_old_val) AND
537: (l_changed));
531: --
532: if l_column = 'END_DATE' then
533: l_changed := (benutils.column_changed(p_old.end_date
534: ,p_new.end_date,l_new_val) AND
535: benutils.column_changed(p_new.end_date
536: ,p_old.end_date,l_old_val) AND
537: (l_changed));
538: --
539: if l_ocrd_dt_cd is null then
554:
555: --
556: --
557: if l_column = 'QUALIFICATION_TYPE_ID' then
558: l_changed := (benutils.column_changed(p_old.qualification_type_id
559: ,p_new.qualification_type_id,l_new_val) AND
560: benutils.column_changed(p_new.qualification_type_id
561: ,p_old.qualification_type_id,l_old_val) AND
562: (l_changed));
556: --
557: if l_column = 'QUALIFICATION_TYPE_ID' then
558: l_changed := (benutils.column_changed(p_old.qualification_type_id
559: ,p_new.qualification_type_id,l_new_val) AND
560: benutils.column_changed(p_new.qualification_type_id
561: ,p_old.qualification_type_id,l_old_val) AND
562: (l_changed));
563: hr_utility.set_location('NEW DOB'||p_new.qualification_type_id, 50);
564: hr_utility.set_location('OLD DOB'||p_old.qualification_type_id, 50);
565: hr_utility.set_location(' ben_qua_trigger', 60);
566: end if;
567: --
568: if l_column = 'TITLE' then
569: l_changed := (benutils.column_changed(p_old.title
570: ,p_new.title,l_new_val) AND
571: benutils.column_changed(p_new.title
572: ,p_old.title,l_old_val) AND
573: (l_changed));
567: --
568: if l_column = 'TITLE' then
569: l_changed := (benutils.column_changed(p_old.title
570: ,p_new.title,l_new_val) AND
571: benutils.column_changed(p_new.title
572: ,p_old.title,l_old_val) AND
573: (l_changed));
574: end if;
575:
574: end if;
575:
576: --
577: if l_column = 'ATTRIBUTE1' then
578: l_changed := (benutils.column_changed(p_old.attribute1
579: ,p_new.attribute1,l_new_val) AND
580: benutils.column_changed(p_new.attribute1
581: ,p_old.attribute1,l_old_val) AND
582: (l_changed));
576: --
577: if l_column = 'ATTRIBUTE1' then
578: l_changed := (benutils.column_changed(p_old.attribute1
579: ,p_new.attribute1,l_new_val) AND
580: benutils.column_changed(p_new.attribute1
581: ,p_old.attribute1,l_old_val) AND
582: (l_changed));
583: hr_utility.set_location(' ben_qua_trigger', 210);
584: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
585: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
586: end if;
587: --
588: if l_column = 'ATTRIBUTE2' then
589: l_changed := (benutils.column_changed(p_old.attribute2
590: ,p_new.attribute2,l_new_val) AND
591: benutils.column_changed(p_new.attribute2
592: ,p_old.attribute2,l_old_val) AND
593: (l_changed));
587: --
588: if l_column = 'ATTRIBUTE2' then
589: l_changed := (benutils.column_changed(p_old.attribute2
590: ,p_new.attribute2,l_new_val) AND
591: benutils.column_changed(p_new.attribute2
592: ,p_old.attribute2,l_old_val) AND
593: (l_changed));
594: hr_utility.set_location(' ben_qua_trigger', 220);
595: end if;
594: hr_utility.set_location(' ben_qua_trigger', 220);
595: end if;
596: --
597: if l_column = 'ATTRIBUTE3' then
598: l_changed := (benutils.column_changed(p_old.attribute3
599: ,p_new.attribute3,l_new_val) AND
600: benutils.column_changed(p_new.attribute3
601: ,p_old.attribute3,l_old_val) AND
602: (l_changed));
596: --
597: if l_column = 'ATTRIBUTE3' then
598: l_changed := (benutils.column_changed(p_old.attribute3
599: ,p_new.attribute3,l_new_val) AND
600: benutils.column_changed(p_new.attribute3
601: ,p_old.attribute3,l_old_val) AND
602: (l_changed));
603: hr_utility.set_location(' ben_qua_trigger', 230);
604: end if;
603: hr_utility.set_location(' ben_qua_trigger', 230);
604: end if;
605: --
606: if l_column = 'ATTRIBUTE4' then
607: l_changed := (benutils.column_changed(p_old.attribute4
608: ,p_new.attribute4,l_new_val) AND
609: benutils.column_changed(p_new.attribute4
610: ,p_old.attribute4,l_old_val) AND
611: (l_changed));
605: --
606: if l_column = 'ATTRIBUTE4' then
607: l_changed := (benutils.column_changed(p_old.attribute4
608: ,p_new.attribute4,l_new_val) AND
609: benutils.column_changed(p_new.attribute4
610: ,p_old.attribute4,l_old_val) AND
611: (l_changed));
612: hr_utility.set_location(' ben_qua_trigger', 240);
613: end if;
612: hr_utility.set_location(' ben_qua_trigger', 240);
613: end if;
614: --
615: if l_column = 'ATTRIBUTE5' then
616: l_changed := (benutils.column_changed(p_old.attribute5
617: ,p_new.attribute5,l_new_val) AND
618: benutils.column_changed(p_new.attribute5
619: ,p_old.attribute5,l_old_val) AND
620: (l_changed));
614: --
615: if l_column = 'ATTRIBUTE5' then
616: l_changed := (benutils.column_changed(p_old.attribute5
617: ,p_new.attribute5,l_new_val) AND
618: benutils.column_changed(p_new.attribute5
619: ,p_old.attribute5,l_old_val) AND
620: (l_changed));
621: hr_utility.set_location(' ben_qua_trigger', 250);
622: end if;
621: hr_utility.set_location(' ben_qua_trigger', 250);
622: end if;
623: --
624: if l_column = 'ATTRIBUTE6' then
625: l_changed := (benutils.column_changed(p_old.attribute6
626: ,p_new.attribute6,l_new_val) AND
627: benutils.column_changed(p_new.attribute6
628: ,p_old.attribute6,l_old_val) AND
629: (l_changed));
623: --
624: if l_column = 'ATTRIBUTE6' then
625: l_changed := (benutils.column_changed(p_old.attribute6
626: ,p_new.attribute6,l_new_val) AND
627: benutils.column_changed(p_new.attribute6
628: ,p_old.attribute6,l_old_val) AND
629: (l_changed));
630: hr_utility.set_location(' ben_qua_trigger', 260);
631: end if;
630: hr_utility.set_location(' ben_qua_trigger', 260);
631: end if;
632: --
633: if l_column = 'ATTRIBUTE7' then
634: l_changed := (benutils.column_changed(p_old.attribute7
635: ,p_new.attribute7,l_new_val) AND
636: benutils.column_changed(p_new.attribute7
637: ,p_old.attribute7,l_old_val) AND
638: (l_changed));
632: --
633: if l_column = 'ATTRIBUTE7' then
634: l_changed := (benutils.column_changed(p_old.attribute7
635: ,p_new.attribute7,l_new_val) AND
636: benutils.column_changed(p_new.attribute7
637: ,p_old.attribute7,l_old_val) AND
638: (l_changed));
639: hr_utility.set_location(' ben_qua_trigger', 270);
640: end if;
639: hr_utility.set_location(' ben_qua_trigger', 270);
640: end if;
641: --
642: if l_column = 'ATTRIBUTE8' then
643: l_changed := (benutils.column_changed(p_old.attribute8
644: ,p_new.attribute8,l_new_val) AND
645: benutils.column_changed(p_new.attribute8
646: ,p_old.attribute8,l_old_val) AND
647: (l_changed));
641: --
642: if l_column = 'ATTRIBUTE8' then
643: l_changed := (benutils.column_changed(p_old.attribute8
644: ,p_new.attribute8,l_new_val) AND
645: benutils.column_changed(p_new.attribute8
646: ,p_old.attribute8,l_old_val) AND
647: (l_changed));
648: hr_utility.set_location(' ben_qua_trigger', 280);
649: end if;
648: hr_utility.set_location(' ben_qua_trigger', 280);
649: end if;
650: --
651: if l_column = 'ATTRIBUTE9' then
652: l_changed := (benutils.column_changed(p_old.attribute9
653: ,p_new.attribute9,l_new_val) AND
654: benutils.column_changed(p_new.attribute9
655: ,p_old.attribute9,l_old_val) AND
656: (l_changed));
650: --
651: if l_column = 'ATTRIBUTE9' then
652: l_changed := (benutils.column_changed(p_old.attribute9
653: ,p_new.attribute9,l_new_val) AND
654: benutils.column_changed(p_new.attribute9
655: ,p_old.attribute9,l_old_val) AND
656: (l_changed));
657: hr_utility.set_location(' ben_qua_trigger', 290);
658: end if;
657: hr_utility.set_location(' ben_qua_trigger', 290);
658: end if;
659: --
660: if l_column = 'ATTRIBUTE10' then
661: l_changed := (benutils.column_changed(p_old.attribute10
662: ,p_new.attribute10,l_new_val) AND
663: benutils.column_changed(p_new.attribute10
664: ,p_old.attribute10,l_old_val) AND
665: (l_changed));
659: --
660: if l_column = 'ATTRIBUTE10' then
661: l_changed := (benutils.column_changed(p_old.attribute10
662: ,p_new.attribute10,l_new_val) AND
663: benutils.column_changed(p_new.attribute10
664: ,p_old.attribute10,l_old_val) AND
665: (l_changed));
666: hr_utility.set_location(' ben_qua_trigger', 300);
667: end if;
666: hr_utility.set_location(' ben_qua_trigger', 300);
667: end if;
668: --
669: if l_column = 'ATTRIBUTE11' then
670: l_changed := (benutils.column_changed(p_old.attribute11
671: ,p_new.attribute11,l_new_val) AND
672: benutils.column_changed(p_new.attribute11
673: ,p_old.attribute11,l_old_val) AND
674: (l_changed));
668: --
669: if l_column = 'ATTRIBUTE11' then
670: l_changed := (benutils.column_changed(p_old.attribute11
671: ,p_new.attribute11,l_new_val) AND
672: benutils.column_changed(p_new.attribute11
673: ,p_old.attribute11,l_old_val) AND
674: (l_changed));
675: hr_utility.set_location(' ben_qua_trigger', 310);
676: end if;
675: hr_utility.set_location(' ben_qua_trigger', 310);
676: end if;
677: --
678: if l_column = 'ATTRIBUTE12' then
679: l_changed := (benutils.column_changed(p_old.attribute12
680: ,p_new.attribute12,l_new_val) AND
681: benutils.column_changed(p_new.attribute12
682: ,p_old.attribute12,l_old_val) AND
683: (l_changed));
677: --
678: if l_column = 'ATTRIBUTE12' then
679: l_changed := (benutils.column_changed(p_old.attribute12
680: ,p_new.attribute12,l_new_val) AND
681: benutils.column_changed(p_new.attribute12
682: ,p_old.attribute12,l_old_val) AND
683: (l_changed));
684: hr_utility.set_location(' ben_qua_trigger', 320);
685: end if;
684: hr_utility.set_location(' ben_qua_trigger', 320);
685: end if;
686: --
687: if l_column = 'ATTRIBUTE13' then
688: l_changed := (benutils.column_changed(p_old.attribute13
689: ,p_new.attribute13,l_new_val) AND
690: benutils.column_changed(p_new.attribute13
691: ,p_old.attribute13,l_old_val) AND
692: (l_changed));
686: --
687: if l_column = 'ATTRIBUTE13' then
688: l_changed := (benutils.column_changed(p_old.attribute13
689: ,p_new.attribute13,l_new_val) AND
690: benutils.column_changed(p_new.attribute13
691: ,p_old.attribute13,l_old_val) AND
692: (l_changed));
693: hr_utility.set_location(' ben_qua_trigger', 330);
694: end if;
693: hr_utility.set_location(' ben_qua_trigger', 330);
694: end if;
695: --
696: if l_column = 'ATTRIBUTE14' then
697: l_changed := (benutils.column_changed(p_old.attribute14
698: ,p_new.attribute14,l_new_val) AND
699: benutils.column_changed(p_new.attribute14
700: ,p_old.attribute14,l_old_val) AND
701: (l_changed));
695: --
696: if l_column = 'ATTRIBUTE14' then
697: l_changed := (benutils.column_changed(p_old.attribute14
698: ,p_new.attribute14,l_new_val) AND
699: benutils.column_changed(p_new.attribute14
700: ,p_old.attribute14,l_old_val) AND
701: (l_changed));
702: hr_utility.set_location(' ben_qua_trigger', 340);
703: end if;
702: hr_utility.set_location(' ben_qua_trigger', 340);
703: end if;
704: --
705: if l_column = 'ATTRIBUTE15' then
706: l_changed := (benutils.column_changed(p_old.attribute15
707: ,p_new.attribute15,l_new_val) AND
708: benutils.column_changed(p_new.attribute15
709: ,p_old.attribute15,l_old_val) AND
710: (l_changed));
704: --
705: if l_column = 'ATTRIBUTE15' then
706: l_changed := (benutils.column_changed(p_old.attribute15
707: ,p_new.attribute15,l_new_val) AND
708: benutils.column_changed(p_new.attribute15
709: ,p_old.attribute15,l_old_val) AND
710: (l_changed));
711: hr_utility.set_location(' ben_qua_trigger', 350);
712: end if;
711: hr_utility.set_location(' ben_qua_trigger', 350);
712: end if;
713: --
714: if l_column = 'ATTRIBUTE16' then
715: l_changed := (benutils.column_changed(p_old.attribute16
716: ,p_new.attribute16,l_new_val) AND
717: benutils.column_changed(p_new.attribute16
718: ,p_old.attribute16,l_old_val) AND
719: (l_changed));
713: --
714: if l_column = 'ATTRIBUTE16' then
715: l_changed := (benutils.column_changed(p_old.attribute16
716: ,p_new.attribute16,l_new_val) AND
717: benutils.column_changed(p_new.attribute16
718: ,p_old.attribute16,l_old_val) AND
719: (l_changed));
720: hr_utility.set_location(' ben_qua_trigger', 360);
721: end if;
720: hr_utility.set_location(' ben_qua_trigger', 360);
721: end if;
722: --
723: if l_column = 'ATTRIBUTE17' then
724: l_changed := (benutils.column_changed(p_old.attribute17
725: ,p_new.attribute17,l_new_val) AND
726: benutils.column_changed(p_new.attribute17
727: ,p_old.attribute17,l_old_val) AND
728: (l_changed));
722: --
723: if l_column = 'ATTRIBUTE17' then
724: l_changed := (benutils.column_changed(p_old.attribute17
725: ,p_new.attribute17,l_new_val) AND
726: benutils.column_changed(p_new.attribute17
727: ,p_old.attribute17,l_old_val) AND
728: (l_changed));
729: hr_utility.set_location(' ben_qua_trigger', 370);
730: end if;
729: hr_utility.set_location(' ben_qua_trigger', 370);
730: end if;
731: --
732: if l_column = 'ATTRIBUTE18' then
733: l_changed := (benutils.column_changed(p_old.attribute18
734: ,p_new.attribute18,l_new_val) AND
735: benutils.column_changed(p_new.attribute18
736: ,p_old.attribute18,l_old_val) AND
737: (l_changed));
731: --
732: if l_column = 'ATTRIBUTE18' then
733: l_changed := (benutils.column_changed(p_old.attribute18
734: ,p_new.attribute18,l_new_val) AND
735: benutils.column_changed(p_new.attribute18
736: ,p_old.attribute18,l_old_val) AND
737: (l_changed));
738: hr_utility.set_location(' ben_qua_trigger', 380);
739: end if;
738: hr_utility.set_location(' ben_qua_trigger', 380);
739: end if;
740: --
741: if l_column = 'ATTRIBUTE19' then
742: l_changed := (benutils.column_changed(p_old.attribute19
743: ,p_new.attribute19,l_new_val) AND
744: benutils.column_changed(p_new.attribute19
745: ,p_old.attribute19,l_old_val) AND
746: (l_changed));
740: --
741: if l_column = 'ATTRIBUTE19' then
742: l_changed := (benutils.column_changed(p_old.attribute19
743: ,p_new.attribute19,l_new_val) AND
744: benutils.column_changed(p_new.attribute19
745: ,p_old.attribute19,l_old_val) AND
746: (l_changed));
747: hr_utility.set_location(' ben_qua_trigger', 390);
748: end if;
747: hr_utility.set_location(' ben_qua_trigger', 390);
748: end if;
749: --
750: if l_column = 'ATTRIBUTE20' then
751: l_changed := (benutils.column_changed(p_old.attribute20
752: ,p_new.attribute20,l_new_val) AND
753: benutils.column_changed(p_new.attribute20
754: ,p_old.attribute20,l_old_val) AND
755: (l_changed));
749: --
750: if l_column = 'ATTRIBUTE20' then
751: l_changed := (benutils.column_changed(p_old.attribute20
752: ,p_new.attribute20,l_new_val) AND
753: benutils.column_changed(p_new.attribute20
754: ,p_old.attribute20,l_old_val) AND
755: (l_changed));
756: hr_utility.set_location(' ben_qua_trigger', 400);
757: end if;