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_QUA_LER dependencies on BENUTILS

Line 182: benutils.set_data_migrator_mode;

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: --

Line 428: benutils.exec_rule(

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),

Line 525: l_changed := (benutils.column_changed(p_old.start_date

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));

Line 527: benutils.column_changed(p_new.start_date

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: --

Line 533: l_changed := (benutils.column_changed(p_old.end_date

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));

Line 535: benutils.column_changed(p_new.end_date

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

Line 558: l_changed := (benutils.column_changed(p_old.qualification_type_id

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));

Line 560: benutils.column_changed(p_new.qualification_type_id

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);

Line 569: l_changed := (benutils.column_changed(p_old.title

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));

Line 571: benutils.column_changed(p_new.title

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:

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

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));

Line 580: benutils.column_changed(p_new.attribute1

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);

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

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));

Line 591: benutils.column_changed(p_new.attribute2

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;

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

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));

Line 600: benutils.column_changed(p_new.attribute3

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;

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

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));

Line 609: benutils.column_changed(p_new.attribute4

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;

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

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));

Line 618: benutils.column_changed(p_new.attribute5

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;

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

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));

Line 627: benutils.column_changed(p_new.attribute6

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;

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

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));

Line 636: benutils.column_changed(p_new.attribute7

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;

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

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));

Line 645: benutils.column_changed(p_new.attribute8

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;

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

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));

Line 654: benutils.column_changed(p_new.attribute9

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;

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

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));

Line 663: benutils.column_changed(p_new.attribute10

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;

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

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));

Line 672: benutils.column_changed(p_new.attribute11

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;

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

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));

Line 681: benutils.column_changed(p_new.attribute12

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;

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

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));

Line 690: benutils.column_changed(p_new.attribute13

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;

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

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));

Line 699: benutils.column_changed(p_new.attribute14

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;

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

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));

Line 708: benutils.column_changed(p_new.attribute15

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;

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

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));

Line 717: benutils.column_changed(p_new.attribute16

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;

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

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));

Line 726: benutils.column_changed(p_new.attribute17

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;

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

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));

Line 735: benutils.column_changed(p_new.attribute18

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;

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

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));

Line 744: benutils.column_changed(p_new.attribute19

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;

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

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));

Line 753: benutils.column_changed(p_new.attribute20

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;