eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ASG_LER dependencies on BENUTILS

Line 141: benutils.set_data_migrator_mode;

137: --
138: --
139: begin
140: -- Bug 3320133
141: benutils.set_data_migrator_mode;
142: if hr_general.g_data_migrator_mode in ( 'Y','P') then
143: --
144: return;
145: --

Line 490: benutils.exec_rule(

486: l_col_old_val := p_old.NORMAL_HOURS;
487: l_col_new_val := p_new.NORMAL_HOURS;
488: end if;
489: --
490: benutils.exec_rule(
491: p_formula_id => l_per_info_chg_cs_ler_rl,
492: p_effective_date => l_session_date,
493: p_lf_evt_ocrd_dt => null,
494: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 565: l_changed := (benutils.column_changed(p_old.assignment_status_type_id

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

Line 567: benutils.column_changed(p_new.assignment_status_type_id

563: --
564: if l_column = 'ASSIGNMENT_STATUS_TYPE_ID' then
565: l_changed := (benutils.column_changed(p_old.assignment_status_type_id
566: ,p_new.assignment_status_type_id,l_new_val) AND
567: benutils.column_changed(p_new.assignment_status_type_id
568: ,p_old.assignment_status_type_id,l_old_val) AND
569: (l_changed));
570: end if;
571: --

Line 573: l_changed := (benutils.column_changed(p_old.organization_id

569: (l_changed));
570: end if;
571: --
572: if l_column = 'ORGANIZATION_ID' then
573: l_changed := (benutils.column_changed(p_old.organization_id
574: ,p_new.organization_id,l_new_val) AND
575: benutils.column_changed(p_new.organization_id
576: ,p_old.organization_id,l_old_val) AND
577: (l_changed));

Line 575: benutils.column_changed(p_new.organization_id

571: --
572: if l_column = 'ORGANIZATION_ID' then
573: l_changed := (benutils.column_changed(p_old.organization_id
574: ,p_new.organization_id,l_new_val) AND
575: benutils.column_changed(p_new.organization_id
576: ,p_old.organization_id,l_old_val) AND
577: (l_changed));
578: end if;
579: --

Line 581: l_changed := (benutils.column_changed(p_old.assignment_type

577: (l_changed));
578: end if;
579: --
580: if l_column = 'ASSIGNMENT_TYPE' then
581: l_changed := (benutils.column_changed(p_old.assignment_type
582: ,p_new.assignment_type,l_new_val) AND
583: benutils.column_changed(p_new.assignment_type
584: ,p_old.assignment_type,l_old_val) AND
585: (l_changed));

Line 583: benutils.column_changed(p_new.assignment_type

579: --
580: if l_column = 'ASSIGNMENT_TYPE' then
581: l_changed := (benutils.column_changed(p_old.assignment_type
582: ,p_new.assignment_type,l_new_val) AND
583: benutils.column_changed(p_new.assignment_type
584: ,p_old.assignment_type,l_old_val) AND
585: (l_changed));
586: end if;
587: --

Line 589: l_changed := (benutils.column_changed(p_old.primary_flag

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

Line 591: benutils.column_changed(p_new.primary_flag

587: --
588: if l_column = 'PRIMARY_FLAG' then
589: l_changed := (benutils.column_changed(p_old.primary_flag
590: ,p_new.primary_flag,l_new_val) AND
591: benutils.column_changed(p_new.primary_flag
592: ,p_old.primary_flag,l_old_val) AND
593: (l_changed));
594: end if;
595: --

Line 597: l_changed := (benutils.column_changed(p_old.change_reason

593: (l_changed));
594: end if;
595: --
596: if l_column = 'CHANGE_REASON' then
597: l_changed := (benutils.column_changed(p_old.change_reason
598: ,p_new.change_reason,l_new_val) AND
599: benutils.column_changed(p_new.change_reason
600: ,p_old.change_reason,l_old_val) AND
601: (l_changed));

Line 599: benutils.column_changed(p_new.change_reason

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

Line 605: l_changed := (benutils.column_changed(p_old.employment_category

601: (l_changed));
602: end if;
603: --
604: if l_column = 'EMPLOYMENT_CATEGORY' then
605: l_changed := (benutils.column_changed(p_old.employment_category
606: ,p_new.employment_category,l_new_val) AND
607: benutils.column_changed(p_new.employment_category
608: ,p_old.employment_category,l_old_val) AND
609: (l_changed));

Line 607: benutils.column_changed(p_new.employment_category

603: --
604: if l_column = 'EMPLOYMENT_CATEGORY' then
605: l_changed := (benutils.column_changed(p_old.employment_category
606: ,p_new.employment_category,l_new_val) AND
607: benutils.column_changed(p_new.employment_category
608: ,p_old.employment_category,l_old_val) AND
609: (l_changed));
610: hr_utility.set_location('NEW EC'||p_new.employment_category, 50);
611: hr_utility.set_location('OLD EC'||p_old.employment_category, 50);

Line 614: l_changed := (benutils.column_changed(p_old.frequency

610: hr_utility.set_location('NEW EC'||p_new.employment_category, 50);
611: hr_utility.set_location('OLD EC'||p_old.employment_category, 50);
612: end if;
613: if l_column = 'FREQUENCY' then
614: l_changed := (benutils.column_changed(p_old.frequency
615: ,p_new.frequency,l_new_val) AND
616: benutils.column_changed(p_new.frequency
617: ,p_old.frequency,l_old_val) AND
618: (l_changed));

Line 616: benutils.column_changed(p_new.frequency

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

Line 622: l_changed := (benutils.column_changed(p_old.grade_id

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

Line 624: benutils.column_changed(p_new.grade_id

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

Line 630: l_changed := (benutils.column_changed(p_old.job_id

626: (l_changed));
627: end if;
628: --
629: if l_column = 'JOB_ID' then
630: l_changed := (benutils.column_changed(p_old.job_id
631: ,p_new.job_id,l_new_val) AND
632: benutils.column_changed(p_new.job_id
633: ,p_old.job_id,l_old_val) AND
634: (l_changed));

Line 632: benutils.column_changed(p_new.job_id

628: --
629: if l_column = 'JOB_ID' then
630: l_changed := (benutils.column_changed(p_old.job_id
631: ,p_new.job_id,l_new_val) AND
632: benutils.column_changed(p_new.job_id
633: ,p_old.job_id,l_old_val) AND
634: (l_changed));
635: end if;
636: --

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

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

Line 640: benutils.column_changed(p_new.position_id

636: --
637: if l_column = 'POSITION_ID' then
638: l_changed := (benutils.column_changed(p_old.position_id
639: ,p_new.position_id,l_new_val) AND
640: benutils.column_changed(p_new.position_id
641: ,p_old.position_id,l_old_val) AND
642: (l_changed));
643: end if;
644: --

Line 646: l_changed := (benutils.column_changed(p_old.location_id

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

Line 648: benutils.column_changed(p_new.location_id

644: --
645: if l_column = 'LOCATION_ID' then
646: l_changed := (benutils.column_changed(p_old.location_id
647: ,p_new.location_id,l_new_val) AND
648: benutils.column_changed(p_new.location_id
649: ,p_old.location_id,l_old_val) AND
650: (l_changed));
651:
652: -- When called from Termination, do not trigger Location LE

Line 660: l_changed := (benutils.column_changed(p_old.normal_hours

656:
657: end if;
658: --
659: if l_column = 'NORMAL_HOURS' then
660: l_changed := (benutils.column_changed(p_old.normal_hours
661: ,p_new.normal_hours,l_new_val) AND
662: benutils.column_changed(p_new.normal_hours
663: ,p_old.normal_hours,l_old_val) AND
664: (l_changed));

Line 662: benutils.column_changed(p_new.normal_hours

658: --
659: if l_column = 'NORMAL_HOURS' then
660: l_changed := (benutils.column_changed(p_old.normal_hours
661: ,p_new.normal_hours,l_new_val) AND
662: benutils.column_changed(p_new.normal_hours
663: ,p_old.normal_hours,l_old_val) AND
664: (l_changed));
665: end if;
666: --

Line 668: l_changed := (benutils.column_changed(p_old.payroll_id

664: (l_changed));
665: end if;
666: --
667: if l_column = 'PAYROLL_ID' then
668: l_changed := (benutils.column_changed(p_old.payroll_id
669: ,p_new.payroll_id,l_new_val) AND
670: benutils.column_changed(p_new.payroll_id
671: ,p_old.payroll_id,l_old_val) AND
672: (l_changed));

Line 670: benutils.column_changed(p_new.payroll_id

666: --
667: if l_column = 'PAYROLL_ID' then
668: l_changed := (benutils.column_changed(p_old.payroll_id
669: ,p_new.payroll_id,l_new_val) AND
670: benutils.column_changed(p_new.payroll_id
671: ,p_old.payroll_id,l_old_val) AND
672: (l_changed));
673: end if;
674: --

Line 676: l_changed := (benutils.column_changed(p_old.pay_basis_id

672: (l_changed));
673: end if;
674: --
675: if l_column = 'PAY_BASIS_ID' then
676: l_changed := (benutils.column_changed(p_old.pay_basis_id
677: ,p_new.pay_basis_id,l_new_val) AND
678: benutils.column_changed(p_new.pay_basis_id
679: ,p_old.pay_basis_id,l_old_val) AND
680: (l_changed));

Line 678: benutils.column_changed(p_new.pay_basis_id

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

Line 684: l_changed := (benutils.column_changed(p_old.bargaining_unit_code

680: (l_changed));
681: end if;
682: --
683: if l_column = 'BARGAINING_UNIT_CODE' then
684: l_changed := (benutils.column_changed(p_old.bargaining_unit_code
685: ,p_new.bargaining_unit_code,l_new_val) AND
686: benutils.column_changed(p_new.bargaining_unit_code
687: ,p_old.bargaining_unit_code,l_old_val) AND
688: (l_changed));

Line 686: benutils.column_changed(p_new.bargaining_unit_code

682: --
683: if l_column = 'BARGAINING_UNIT_CODE' then
684: l_changed := (benutils.column_changed(p_old.bargaining_unit_code
685: ,p_new.bargaining_unit_code,l_new_val) AND
686: benutils.column_changed(p_new.bargaining_unit_code
687: ,p_old.bargaining_unit_code,l_old_val) AND
688: (l_changed));
689: end if;
690: --

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

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

Line 694: benutils.column_changed(p_new.labour_union_member_flag

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

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

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

Line 702: benutils.column_changed(p_new.people_group_id

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

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

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

Line 710: benutils.column_changed(p_new.hourly_salaried_code

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

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

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

Line 718: benutils.column_changed(p_new.ass_attribute1

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

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

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

Line 726: benutils.column_changed(p_new.ass_attribute2

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

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

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

Line 734: benutils.column_changed(p_new.ass_attribute3

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

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

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

Line 742: benutils.column_changed(p_new.ass_attribute4

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

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

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

Line 750: benutils.column_changed(p_new.ass_attribute5

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

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

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

Line 758: benutils.column_changed(p_new.ass_attribute6

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

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

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

Line 766: benutils.column_changed(p_new.ass_attribute7

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

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

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

Line 774: benutils.column_changed(p_new.ass_attribute8

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

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

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

Line 782: benutils.column_changed(p_new.ass_attribute9

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

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

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

Line 790: benutils.column_changed(p_new.ass_attribute10

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

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

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

Line 798: benutils.column_changed(p_new.ass_attribute11

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

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

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

Line 806: benutils.column_changed(p_new.ass_attribute12

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

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

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

Line 814: benutils.column_changed(p_new.ass_attribute13

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

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

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

Line 822: benutils.column_changed(p_new.ass_attribute14

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

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

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

Line 830: benutils.column_changed(p_new.ass_attribute15

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

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

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

Line 838: benutils.column_changed(p_new.ass_attribute16

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

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

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

Line 846: benutils.column_changed(p_new.ass_attribute17

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

Line 852: l_changed := (benutils.column_changed(p_old.ass_attribute18

848: (l_changed));
849: end if;
850: --
851: if l_column = 'ASS_ATTRIBUTE18' then
852: l_changed := (benutils.column_changed(p_old.ass_attribute18
853: ,p_new.ass_attribute18,l_new_val) AND
854: benutils.column_changed(p_new.ass_attribute18
855: ,p_old.ass_attribute18,l_old_val) AND
856: (l_changed));

Line 854: benutils.column_changed(p_new.ass_attribute18

850: --
851: if l_column = 'ASS_ATTRIBUTE18' then
852: l_changed := (benutils.column_changed(p_old.ass_attribute18
853: ,p_new.ass_attribute18,l_new_val) AND
854: benutils.column_changed(p_new.ass_attribute18
855: ,p_old.ass_attribute18,l_old_val) AND
856: (l_changed));
857: end if;
858: --

Line 860: l_changed := (benutils.column_changed(p_old.ass_attribute19

856: (l_changed));
857: end if;
858: --
859: if l_column = 'ASS_ATTRIBUTE19' then
860: l_changed := (benutils.column_changed(p_old.ass_attribute19
861: ,p_new.ass_attribute19,l_new_val) AND
862: benutils.column_changed(p_new.ass_attribute19
863: ,p_old.ass_attribute19,l_old_val) AND
864: (l_changed));

Line 862: benutils.column_changed(p_new.ass_attribute19

858: --
859: if l_column = 'ASS_ATTRIBUTE19' then
860: l_changed := (benutils.column_changed(p_old.ass_attribute19
861: ,p_new.ass_attribute19,l_new_val) AND
862: benutils.column_changed(p_new.ass_attribute19
863: ,p_old.ass_attribute19,l_old_val) AND
864: (l_changed));
865: end if;
866: --

Line 868: l_changed := (benutils.column_changed(p_old.ass_attribute20

864: (l_changed));
865: end if;
866: --
867: if l_column = 'ASS_ATTRIBUTE20' then
868: l_changed := (benutils.column_changed(p_old.ass_attribute20
869: ,p_new.ass_attribute20,l_new_val) AND
870: benutils.column_changed(p_new.ass_attribute20
871: ,p_old.ass_attribute20,l_old_val) AND
872: (l_changed));

Line 870: benutils.column_changed(p_new.ass_attribute20

866: --
867: if l_column = 'ASS_ATTRIBUTE20' then
868: l_changed := (benutils.column_changed(p_old.ass_attribute20
869: ,p_new.ass_attribute20,l_new_val) AND
870: benutils.column_changed(p_new.ass_attribute20
871: ,p_old.ass_attribute20,l_old_val) AND
872: (l_changed));
873: end if;
874: --

Line 876: l_changed := (benutils.column_changed(p_old.ass_attribute21

872: (l_changed));
873: end if;
874: --
875: if l_column = 'ASS_ATTRIBUTE21' then
876: l_changed := (benutils.column_changed(p_old.ass_attribute21
877: ,p_new.ass_attribute21,l_new_val) AND
878: benutils.column_changed(p_new.ass_attribute21
879: ,p_old.ass_attribute21,l_old_val) AND
880: (l_changed));

Line 878: benutils.column_changed(p_new.ass_attribute21

874: --
875: if l_column = 'ASS_ATTRIBUTE21' then
876: l_changed := (benutils.column_changed(p_old.ass_attribute21
877: ,p_new.ass_attribute21,l_new_val) AND
878: benutils.column_changed(p_new.ass_attribute21
879: ,p_old.ass_attribute21,l_old_val) AND
880: (l_changed));
881: end if;
882: --

Line 884: l_changed := (benutils.column_changed(p_old.ass_attribute22

880: (l_changed));
881: end if;
882: --
883: if l_column = 'ASS_ATTRIBUTE22' then
884: l_changed := (benutils.column_changed(p_old.ass_attribute22
885: ,p_new.ass_attribute22,l_new_val) AND
886: benutils.column_changed(p_new.ass_attribute22
887: ,p_old.ass_attribute22,l_old_val) AND
888: (l_changed));

Line 886: benutils.column_changed(p_new.ass_attribute22

882: --
883: if l_column = 'ASS_ATTRIBUTE22' then
884: l_changed := (benutils.column_changed(p_old.ass_attribute22
885: ,p_new.ass_attribute22,l_new_val) AND
886: benutils.column_changed(p_new.ass_attribute22
887: ,p_old.ass_attribute22,l_old_val) AND
888: (l_changed));
889: end if;
890: --

Line 892: l_changed := (benutils.column_changed(p_old.ass_attribute23

888: (l_changed));
889: end if;
890: --
891: if l_column = 'ASS_ATTRIBUTE23' then
892: l_changed := (benutils.column_changed(p_old.ass_attribute23
893: ,p_new.ass_attribute23,l_new_val) AND
894: benutils.column_changed(p_new.ass_attribute23
895: ,p_old.ass_attribute23,l_old_val) AND
896: (l_changed));

Line 894: benutils.column_changed(p_new.ass_attribute23

890: --
891: if l_column = 'ASS_ATTRIBUTE23' then
892: l_changed := (benutils.column_changed(p_old.ass_attribute23
893: ,p_new.ass_attribute23,l_new_val) AND
894: benutils.column_changed(p_new.ass_attribute23
895: ,p_old.ass_attribute23,l_old_val) AND
896: (l_changed));
897: end if;
898: --

Line 900: l_changed := (benutils.column_changed(p_old.ass_attribute24

896: (l_changed));
897: end if;
898: --
899: if l_column = 'ASS_ATTRIBUTE24' then
900: l_changed := (benutils.column_changed(p_old.ass_attribute24
901: ,p_new.ass_attribute24,l_new_val) AND
902: benutils.column_changed(p_new.ass_attribute24
903: ,p_old.ass_attribute24,l_old_val) AND
904: (l_changed));

Line 902: benutils.column_changed(p_new.ass_attribute24

898: --
899: if l_column = 'ASS_ATTRIBUTE24' then
900: l_changed := (benutils.column_changed(p_old.ass_attribute24
901: ,p_new.ass_attribute24,l_new_val) AND
902: benutils.column_changed(p_new.ass_attribute24
903: ,p_old.ass_attribute24,l_old_val) AND
904: (l_changed));
905: end if;
906: --

Line 908: l_changed := (benutils.column_changed(p_old.ass_attribute25

904: (l_changed));
905: end if;
906: --
907: if l_column = 'ASS_ATTRIBUTE25' then
908: l_changed := (benutils.column_changed(p_old.ass_attribute25
909: ,p_new.ass_attribute25,l_new_val) AND
910: benutils.column_changed(p_new.ass_attribute25
911: ,p_old.ass_attribute25,l_old_val) AND
912: (l_changed));

Line 910: benutils.column_changed(p_new.ass_attribute25

906: --
907: if l_column = 'ASS_ATTRIBUTE25' then
908: l_changed := (benutils.column_changed(p_old.ass_attribute25
909: ,p_new.ass_attribute25,l_new_val) AND
910: benutils.column_changed(p_new.ass_attribute25
911: ,p_old.ass_attribute25,l_old_val) AND
912: (l_changed));
913: end if;
914: --

Line 916: l_changed := (benutils.column_changed(p_old.ass_attribute26

912: (l_changed));
913: end if;
914: --
915: if l_column = 'ASS_ATTRIBUTE26' then
916: l_changed := (benutils.column_changed(p_old.ass_attribute26
917: ,p_new.ass_attribute26,l_new_val) AND
918: benutils.column_changed(p_new.ass_attribute26
919: ,p_old.ass_attribute26,l_old_val) AND
920: (l_changed));

Line 918: benutils.column_changed(p_new.ass_attribute26

914: --
915: if l_column = 'ASS_ATTRIBUTE26' then
916: l_changed := (benutils.column_changed(p_old.ass_attribute26
917: ,p_new.ass_attribute26,l_new_val) AND
918: benutils.column_changed(p_new.ass_attribute26
919: ,p_old.ass_attribute26,l_old_val) AND
920: (l_changed));
921: end if;
922: --

Line 924: l_changed := (benutils.column_changed(p_old.ass_attribute27

920: (l_changed));
921: end if;
922: --
923: if l_column = 'ASS_ATTRIBUTE27' then
924: l_changed := (benutils.column_changed(p_old.ass_attribute27
925: ,p_new.ass_attribute27,l_new_val) AND
926: benutils.column_changed(p_new.ass_attribute27
927: ,p_old.ass_attribute27,l_old_val) AND
928: (l_changed));

Line 926: benutils.column_changed(p_new.ass_attribute27

922: --
923: if l_column = 'ASS_ATTRIBUTE27' then
924: l_changed := (benutils.column_changed(p_old.ass_attribute27
925: ,p_new.ass_attribute27,l_new_val) AND
926: benutils.column_changed(p_new.ass_attribute27
927: ,p_old.ass_attribute27,l_old_val) AND
928: (l_changed));
929: end if;
930: --

Line 932: l_changed := (benutils.column_changed(p_old.ass_attribute28

928: (l_changed));
929: end if;
930: --
931: if l_column = 'ASS_ATTRIBUTE28' then
932: l_changed := (benutils.column_changed(p_old.ass_attribute28
933: ,p_new.ass_attribute28,l_new_val) AND
934: benutils.column_changed(p_new.ass_attribute28
935: ,p_old.ass_attribute28,l_old_val) AND
936: (l_changed));

Line 934: benutils.column_changed(p_new.ass_attribute28

930: --
931: if l_column = 'ASS_ATTRIBUTE28' then
932: l_changed := (benutils.column_changed(p_old.ass_attribute28
933: ,p_new.ass_attribute28,l_new_val) AND
934: benutils.column_changed(p_new.ass_attribute28
935: ,p_old.ass_attribute28,l_old_val) AND
936: (l_changed));
937: end if;
938: --

Line 940: l_changed := (benutils.column_changed(p_old.ass_attribute29

936: (l_changed));
937: end if;
938: --
939: if l_column = 'ASS_ATTRIBUTE29' then
940: l_changed := (benutils.column_changed(p_old.ass_attribute29
941: ,p_new.ass_attribute29,l_new_val) AND
942: benutils.column_changed(p_new.ass_attribute29
943: ,p_old.ass_attribute29,l_old_val) AND
944: (l_changed));

Line 942: benutils.column_changed(p_new.ass_attribute29

938: --
939: if l_column = 'ASS_ATTRIBUTE29' then
940: l_changed := (benutils.column_changed(p_old.ass_attribute29
941: ,p_new.ass_attribute29,l_new_val) AND
942: benutils.column_changed(p_new.ass_attribute29
943: ,p_old.ass_attribute29,l_old_val) AND
944: (l_changed));
945: end if;
946: --

Line 948: l_changed := (benutils.column_changed(p_old.ass_attribute30

944: (l_changed));
945: end if;
946: --
947: if l_column = 'ASS_ATTRIBUTE30' then
948: l_changed := (benutils.column_changed(p_old.ass_attribute30
949: ,p_new.ass_attribute30,l_new_val) AND
950: benutils.column_changed(p_new.ass_attribute30
951: ,p_old.ass_attribute30,l_old_val) AND
952: (l_changed));

Line 950: benutils.column_changed(p_new.ass_attribute30

946: --
947: if l_column = 'ASS_ATTRIBUTE30' then
948: l_changed := (benutils.column_changed(p_old.ass_attribute30
949: ,p_new.ass_attribute30,l_new_val) AND
950: benutils.column_changed(p_new.ass_attribute30
951: ,p_old.ass_attribute30,l_old_val) AND
952: (l_changed));
953: end if;
954: --

Line 1088: benutils.set_data_migrator_mode; -- Bug 3320133

1084: hr_utility.set_location(' ben_asg_trigger', 110);
1085: close get_ler;
1086: hr_utility.set_location(' Leaving: ben_asg_trigger', 120);
1087:
1088: benutils.set_data_migrator_mode; -- Bug 3320133
1089: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1090: -- If Pay Basis or Grade is changed then check for Quartile in Grade life event, Bug 2628274
1091: if ( nvl(p_old.grade_id,0) <> nvl(p_new.grade_id,0) ) or
1092: ( nvl(p_old.pay_basis_id,0) <> nvl(p_new.pay_basis_id,0) ) then