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

Line 150: benutils.set_data_migrator_mode;

146: --
147: begin
148:
149: -- Bug 3320133
150: benutils.set_data_migrator_mode;
151: if hr_general.g_data_migrator_mode in ( 'Y','P') then
152: --
153: return;
154: --

Line 376: benutils.exec_rule(

372: l_col_old_val := p_old.ATTRIBUTE20;
373: l_col_new_val := p_new.ATTRIBUTE20;
374: end if;
375: --
376: benutils.exec_rule(
377: p_formula_id => l_per_info_chg_cs_ler_rl,
378: p_effective_date => l_session_date,
379: p_lf_evt_ocrd_dt => null,
380: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 469: l_changed := (benutils.column_changed(p_old.COMPETENCE_ID

465: if l_column = 'COMPETENCE_ID' then
466: hr_utility.set_location('p_old.COMPETENCE_ID '||p_old.COMPETENCE_ID, 111);
467: hr_utility.set_location('p_new.COMPETENCE_ID '||p_new.COMPETENCE_ID, 222);
468:
469: l_changed := (benutils.column_changed(p_old.COMPETENCE_ID
470: ,p_new.COMPETENCE_ID,l_new_val) AND
471: benutils.column_changed(p_new.COMPETENCE_ID
472: ,p_old.COMPETENCE_ID,l_old_val) AND
473: (l_changed));

Line 471: benutils.column_changed(p_new.COMPETENCE_ID

467: hr_utility.set_location('p_new.COMPETENCE_ID '||p_new.COMPETENCE_ID, 222);
468:
469: l_changed := (benutils.column_changed(p_old.COMPETENCE_ID
470: ,p_new.COMPETENCE_ID,l_new_val) AND
471: benutils.column_changed(p_new.COMPETENCE_ID
472: ,p_old.COMPETENCE_ID,l_old_val) AND
473: (l_changed));
474: end if;
475: --

Line 479: l_changed := (benutils.column_changed(p_old.PROFICIENCY_LEVEL_ID

475: --
476: if l_column = 'PROFICIENCY_LEVEL_ID' then
477: hr_utility.set_location('p_old.PROFICIENCY_LEVEL_ID '||p_old.PROFICIENCY_LEVEL_ID, 111);
478: hr_utility.set_location('p_new.PROFICIENCY_LEVEL_ID '||p_new.PROFICIENCY_LEVEL_ID, 222);
479: l_changed := (benutils.column_changed(p_old.PROFICIENCY_LEVEL_ID
480: ,p_new.PROFICIENCY_LEVEL_ID,l_new_val) AND
481: benutils.column_changed(p_new.PROFICIENCY_LEVEL_ID
482: ,p_old.PROFICIENCY_LEVEL_ID,l_old_val) AND
483: (l_changed));

Line 481: benutils.column_changed(p_new.PROFICIENCY_LEVEL_ID

477: hr_utility.set_location('p_old.PROFICIENCY_LEVEL_ID '||p_old.PROFICIENCY_LEVEL_ID, 111);
478: hr_utility.set_location('p_new.PROFICIENCY_LEVEL_ID '||p_new.PROFICIENCY_LEVEL_ID, 222);
479: l_changed := (benutils.column_changed(p_old.PROFICIENCY_LEVEL_ID
480: ,p_new.PROFICIENCY_LEVEL_ID,l_new_val) AND
481: benutils.column_changed(p_new.PROFICIENCY_LEVEL_ID
482: ,p_old.PROFICIENCY_LEVEL_ID,l_old_val) AND
483: (l_changed));
484: end if;
485: --

Line 491: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_FROM

487: if l_column = 'EFFECTIVE_DATE_FROM' then
488: hr_utility.set_location('p_old.EFFECTIVE_DATE_FROM '||p_old.EFFECTIVE_DATE_FROM, 111);
489: hr_utility.set_location('p_new.EFFECTIVE_DATE_FROM '||p_new.EFFECTIVE_DATE_FROM, 222);
490:
491: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_FROM
492: ,p_new.EFFECTIVE_DATE_FROM,l_new_val) AND
493: benutils.column_changed(p_new.EFFECTIVE_DATE_FROM
494: ,p_old.EFFECTIVE_DATE_FROM,l_old_val) AND
495: (l_changed));

Line 493: benutils.column_changed(p_new.EFFECTIVE_DATE_FROM

489: hr_utility.set_location('p_new.EFFECTIVE_DATE_FROM '||p_new.EFFECTIVE_DATE_FROM, 222);
490:
491: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_FROM
492: ,p_new.EFFECTIVE_DATE_FROM,l_new_val) AND
493: benutils.column_changed(p_new.EFFECTIVE_DATE_FROM
494: ,p_old.EFFECTIVE_DATE_FROM,l_old_val) AND
495: (l_changed));
496: end if;
497: --

Line 503: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_TO

499: hr_utility.set_location('p_old.EFFECTIVE_DATE_TO '||p_old.EFFECTIVE_DATE_TO, 111);
500: hr_utility.set_location('p_new.EFFECTIVE_DATE_TO '||p_new.EFFECTIVE_DATE_TO, 222);
501:
502:
503: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_TO
504: ,p_new.EFFECTIVE_DATE_TO,l_new_val) AND
505: benutils.column_changed(p_new.EFFECTIVE_DATE_TO
506: ,p_old.EFFECTIVE_DATE_TO,l_old_val) AND
507: (l_changed));

Line 505: benutils.column_changed(p_new.EFFECTIVE_DATE_TO

501:
502:
503: l_changed := (benutils.column_changed(p_old.EFFECTIVE_DATE_TO
504: ,p_new.EFFECTIVE_DATE_TO,l_new_val) AND
505: benutils.column_changed(p_new.EFFECTIVE_DATE_TO
506: ,p_old.EFFECTIVE_DATE_TO,l_old_val) AND
507: (l_changed));
508:
509: if l_ocrd_dt_cd is null then

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

521: end if;
522: end if;
523: --
524: if l_column = 'ATTRIBUTE1' then
525: l_changed := (benutils.column_changed(p_old.attribute1
526: ,p_new.attribute1,l_new_val) AND
527: benutils.column_changed(p_new.attribute1
528: ,p_old.attribute1,l_old_val) AND
529: (l_changed));

Line 527: benutils.column_changed(p_new.attribute1

523: --
524: if l_column = 'ATTRIBUTE1' then
525: l_changed := (benutils.column_changed(p_old.attribute1
526: ,p_new.attribute1,l_new_val) AND
527: benutils.column_changed(p_new.attribute1
528: ,p_old.attribute1,l_old_val) AND
529: (l_changed));
530: end if;
531: --

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

529: (l_changed));
530: end if;
531: --
532: if l_column = 'ATTRIBUTE2' then
533: l_changed := (benutils.column_changed(p_old.attribute2
534: ,p_new.attribute2,l_new_val) AND
535: benutils.column_changed(p_new.attribute2
536: ,p_old.attribute2,l_old_val) AND
537: (l_changed));

Line 535: benutils.column_changed(p_new.attribute2

531: --
532: if l_column = 'ATTRIBUTE2' then
533: l_changed := (benutils.column_changed(p_old.attribute2
534: ,p_new.attribute2,l_new_val) AND
535: benutils.column_changed(p_new.attribute2
536: ,p_old.attribute2,l_old_val) AND
537: (l_changed));
538: end if;
539: --

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

537: (l_changed));
538: end if;
539: --
540: if l_column = 'ATTRIBUTE3' then
541: l_changed := (benutils.column_changed(p_old.attribute3
542: ,p_new.attribute3,l_new_val) AND
543: benutils.column_changed(p_new.attribute3
544: ,p_old.attribute3,l_old_val) AND
545: (l_changed));

Line 543: benutils.column_changed(p_new.attribute3

539: --
540: if l_column = 'ATTRIBUTE3' then
541: l_changed := (benutils.column_changed(p_old.attribute3
542: ,p_new.attribute3,l_new_val) AND
543: benutils.column_changed(p_new.attribute3
544: ,p_old.attribute3,l_old_val) AND
545: (l_changed));
546: end if;
547: --

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

545: (l_changed));
546: end if;
547: --
548: if l_column = 'ATTRIBUTE4' then
549: l_changed := (benutils.column_changed(p_old.attribute4
550: ,p_new.attribute4,l_new_val) AND
551: benutils.column_changed(p_new.attribute4
552: ,p_old.attribute4,l_old_val) AND
553: (l_changed));

Line 551: benutils.column_changed(p_new.attribute4

547: --
548: if l_column = 'ATTRIBUTE4' then
549: l_changed := (benutils.column_changed(p_old.attribute4
550: ,p_new.attribute4,l_new_val) AND
551: benutils.column_changed(p_new.attribute4
552: ,p_old.attribute4,l_old_val) AND
553: (l_changed));
554: end if;
555: --

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

553: (l_changed));
554: end if;
555: --
556: if l_column = 'ATTRIBUTE5' then
557: l_changed := (benutils.column_changed(p_old.attribute5
558: ,p_new.attribute5,l_new_val) AND
559: benutils.column_changed(p_new.attribute5
560: ,p_old.attribute5,l_old_val) AND
561: (l_changed));

Line 559: benutils.column_changed(p_new.attribute5

555: --
556: if l_column = 'ATTRIBUTE5' then
557: l_changed := (benutils.column_changed(p_old.attribute5
558: ,p_new.attribute5,l_new_val) AND
559: benutils.column_changed(p_new.attribute5
560: ,p_old.attribute5,l_old_val) AND
561: (l_changed));
562: end if;
563: --

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

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

Line 567: benutils.column_changed(p_new.attribute6

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

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

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

Line 575: benutils.column_changed(p_new.attribute7

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

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

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

Line 583: benutils.column_changed(p_new.attribute8

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

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

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

Line 591: benutils.column_changed(p_new.attribute9

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

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

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

Line 599: benutils.column_changed(p_new.attribute10

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

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

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

Line 607: benutils.column_changed(p_new.attribute11

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

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

609: (l_changed));
610: end if;
611: --
612: if l_column = 'ATTRIBUTE12' then
613: l_changed := (benutils.column_changed(p_old.attribute12
614: ,p_new.attribute12,l_new_val) AND
615: benutils.column_changed(p_new.attribute12
616: ,p_old.attribute12,l_old_val) AND
617: (l_changed));

Line 615: benutils.column_changed(p_new.attribute12

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

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

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

Line 623: benutils.column_changed(p_new.attribute13

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

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

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

Line 631: benutils.column_changed(p_new.attribute14

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

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

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

Line 639: benutils.column_changed(p_new.attribute15

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

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

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

Line 647: benutils.column_changed(p_new.attribute16

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

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

649: (l_changed));
650: end if;
651: --
652: if l_column = 'ATTRIBUTE17' then
653: l_changed := (benutils.column_changed(p_old.attribute17
654: ,p_new.attribute17,l_new_val) AND
655: benutils.column_changed(p_new.attribute17
656: ,p_old.attribute17,l_old_val) AND
657: (l_changed));

Line 655: benutils.column_changed(p_new.attribute17

651: --
652: if l_column = 'ATTRIBUTE17' then
653: l_changed := (benutils.column_changed(p_old.attribute17
654: ,p_new.attribute17,l_new_val) AND
655: benutils.column_changed(p_new.attribute17
656: ,p_old.attribute17,l_old_val) AND
657: (l_changed));
658: end if;
659: --

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

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

Line 663: benutils.column_changed(p_new.attribute18

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

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

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

Line 671: benutils.column_changed(p_new.attribute19

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

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

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

Line 679: benutils.column_changed(p_new.attribute20

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