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

Line 159: benutils.set_data_migrator_mode;

155: l_trigger boolean := TRUE;
156: --
157: begin
158: -- Bug 3320133
159: benutils.set_data_migrator_mode;
160: if hr_general.g_data_migrator_mode in ( 'Y','P') then
161: --
162: return;
163: --

Line 470: benutils.exec_rule(

466: l_col_new_val := to_char(p_new.ORIGINAL_DATE_OF_HIRE, 'YYYY/MM/DD HH24:MI:SS');
467: end if;
468:
469: --
470: benutils.exec_rule(
471: p_formula_id => l_per_info_chg_cs_ler_rl,
472: p_effective_date => l_session_date,
473: p_lf_evt_ocrd_dt => null,
474: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 521: l_changed := (benutils.column_changed(p_old.date_of_birth

517: --
518: hr_utility.set_location(' ben_ppf_trigger'|| ' l_rule_output = ' || l_rule_output, 9999);
519: --
520: if l_column = 'DATE_OF_BIRTH' then
521: l_changed := (benutils.column_changed(p_old.date_of_birth
522: ,p_new.date_of_birth,l_new_val) AND
523: benutils.column_changed(p_new.date_of_birth
524: ,p_old.date_of_birth,l_old_val) AND
525: (l_changed));

Line 523: benutils.column_changed(p_new.date_of_birth

519: --
520: if l_column = 'DATE_OF_BIRTH' then
521: l_changed := (benutils.column_changed(p_old.date_of_birth
522: ,p_new.date_of_birth,l_new_val) AND
523: benutils.column_changed(p_new.date_of_birth
524: ,p_old.date_of_birth,l_old_val) AND
525: (l_changed));
526: hr_utility.set_location('NEW DOB'||p_new.date_of_birth, 50);
527: hr_utility.set_location('OLD DOB'||p_old.date_of_birth, 50);

Line 532: l_changed := (benutils.column_changed(p_old.date_of_death

528: hr_utility.set_location(' ben_ppf_trigger', 60);
529: end if;
530: --
531: if l_column = 'DATE_OF_DEATH' then
532: l_changed := (benutils.column_changed(p_old.date_of_death
533: ,p_new.date_of_death,l_new_val) AND
534: benutils.column_changed(p_new.date_of_death
535: ,p_old.date_of_death,l_old_val) AND
536: (l_changed));

Line 534: benutils.column_changed(p_new.date_of_death

530: --
531: if l_column = 'DATE_OF_DEATH' then
532: l_changed := (benutils.column_changed(p_old.date_of_death
533: ,p_new.date_of_death,l_new_val) AND
534: benutils.column_changed(p_new.date_of_death
535: ,p_old.date_of_death,l_old_val) AND
536: (l_changed));
537: --
538: -- If date of death set and is different than old value

Line 553: l_changed := (benutils.column_changed(p_old.marital_status

549: hr_utility.set_location(' ben_ppf_trigger', 70);
550: end if;
551:
552: if l_column = 'MARITAL_STATUS' then
553: l_changed := (benutils.column_changed(p_old.marital_status
554: ,p_new.marital_status,l_new_val) AND
555: benutils.column_changed(p_new.marital_status
556: ,p_old.marital_status,l_old_val) AND
557: (l_changed));

Line 555: benutils.column_changed(p_new.marital_status

551:
552: if l_column = 'MARITAL_STATUS' then
553: l_changed := (benutils.column_changed(p_old.marital_status
554: ,p_new.marital_status,l_new_val) AND
555: benutils.column_changed(p_new.marital_status
556: ,p_old.marital_status,l_old_val) AND
557: (l_changed));
558: hr_utility.set_location(' ben_ppf_trigger', 90);
559: hr_utility.set_location('NEW MS'||p_new.marital_status, 50);

Line 564: l_changed := (benutils.column_changed(p_old.on_military_service

560: hr_utility.set_location('OLD MS'||p_old.marital_status, 50);
561: end if;
562: --
563: if l_column = 'ON_MILITARY_SERVICE' then
564: l_changed := (benutils.column_changed(p_old.on_military_service
565: ,p_new.on_military_service,l_new_val) AND
566: benutils.column_changed(p_new.on_military_service
567: ,p_old.on_military_service,l_old_val) AND
568: (l_changed));

Line 566: benutils.column_changed(p_new.on_military_service

562: --
563: if l_column = 'ON_MILITARY_SERVICE' then
564: l_changed := (benutils.column_changed(p_old.on_military_service
565: ,p_new.on_military_service,l_new_val) AND
566: benutils.column_changed(p_new.on_military_service
567: ,p_old.on_military_service,l_old_val) AND
568: (l_changed));
569: hr_utility.set_location(' ben_ppf_trigger', 100);
570: end if;

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

569: hr_utility.set_location(' ben_ppf_trigger', 100);
570: end if;
571: --
572: if l_column = 'REGISTERED_DISABLED_FLAG' then
573: l_changed := (benutils.column_changed(p_old.registered_disabled_flag
574: ,p_new.registered_disabled_flag,l_new_val) AND
575: benutils.column_changed(p_new.registered_disabled_flag
576: ,p_old.registered_disabled_flag,l_old_val) AND
577: (l_changed));

Line 575: benutils.column_changed(p_new.registered_disabled_flag

571: --
572: if l_column = 'REGISTERED_DISABLED_FLAG' then
573: l_changed := (benutils.column_changed(p_old.registered_disabled_flag
574: ,p_new.registered_disabled_flag,l_new_val) AND
575: benutils.column_changed(p_new.registered_disabled_flag
576: ,p_old.registered_disabled_flag,l_old_val) AND
577: (l_changed));
578: hr_utility.set_location(' ben_ppf_trigger', 110);
579: end if;

Line 582: l_changed := (benutils.column_changed(p_old.sex

578: hr_utility.set_location(' ben_ppf_trigger', 110);
579: end if;
580: --
581: if l_column = 'SEX' then
582: l_changed := (benutils.column_changed(p_old.sex
583: ,p_new.sex,l_new_val) AND
584: benutils.column_changed(p_new.sex
585: ,p_old.sex,l_old_val) AND
586: (l_changed));

Line 584: benutils.column_changed(p_new.sex

580: --
581: if l_column = 'SEX' then
582: l_changed := (benutils.column_changed(p_old.sex
583: ,p_new.sex,l_new_val) AND
584: benutils.column_changed(p_new.sex
585: ,p_old.sex,l_old_val) AND
586: (l_changed));
587: hr_utility.set_location(' ben_ppf_trigger', 120);
588: end if;

Line 591: l_changed := (benutils.column_changed(p_old.student_status

587: hr_utility.set_location(' ben_ppf_trigger', 120);
588: end if;
589: --
590: if l_column = 'STUDENT_STATUS' then
591: l_changed := (benutils.column_changed(p_old.student_status
592: ,p_new.student_status,l_new_val) AND
593: benutils.column_changed(p_new.student_status
594: ,p_old.student_status,l_old_val) AND
595: (l_changed));

Line 593: benutils.column_changed(p_new.student_status

589: --
590: if l_column = 'STUDENT_STATUS' then
591: l_changed := (benutils.column_changed(p_old.student_status
592: ,p_new.student_status,l_new_val) AND
593: benutils.column_changed(p_new.student_status
594: ,p_old.student_status,l_old_val) AND
595: (l_changed));
596: hr_utility.set_location(' ben_ppf_trigger', 130);
597: end if;

Line 600: l_changed := (benutils.column_changed(p_old.coord_ben_med_pln_no

596: hr_utility.set_location(' ben_ppf_trigger', 130);
597: end if;
598: --
599: if l_column = 'COORD_BEN_MED_PLN_NO' then
600: l_changed := (benutils.column_changed(p_old.coord_ben_med_pln_no
601: ,p_new.coord_ben_med_pln_no,l_new_val) AND
602: benutils.column_changed(p_new.coord_ben_med_pln_no
603: ,p_old.coord_ben_med_pln_no,l_old_val) AND
604: (l_changed));

Line 602: benutils.column_changed(p_new.coord_ben_med_pln_no

598: --
599: if l_column = 'COORD_BEN_MED_PLN_NO' then
600: l_changed := (benutils.column_changed(p_old.coord_ben_med_pln_no
601: ,p_new.coord_ben_med_pln_no,l_new_val) AND
602: benutils.column_changed(p_new.coord_ben_med_pln_no
603: ,p_old.coord_ben_med_pln_no,l_old_val) AND
604: (l_changed));
605: hr_utility.set_location(' ben_ppf_trigger', 140);
606: end if;

Line 609: l_changed := (benutils.column_changed(p_old.coord_ben_no_cvg_flag

605: hr_utility.set_location(' ben_ppf_trigger', 140);
606: end if;
607: --
608: if l_column = 'COORD_BEN_NO_CVG_FLAG' then
609: l_changed := (benutils.column_changed(p_old.coord_ben_no_cvg_flag
610: ,p_new.coord_ben_no_cvg_flag,l_new_val) AND
611: benutils.column_changed(p_new.coord_ben_no_cvg_flag
612: ,p_old.coord_ben_no_cvg_flag,l_old_val) AND
613: (l_changed));

Line 611: benutils.column_changed(p_new.coord_ben_no_cvg_flag

607: --
608: if l_column = 'COORD_BEN_NO_CVG_FLAG' then
609: l_changed := (benutils.column_changed(p_old.coord_ben_no_cvg_flag
610: ,p_new.coord_ben_no_cvg_flag,l_new_val) AND
611: benutils.column_changed(p_new.coord_ben_no_cvg_flag
612: ,p_old.coord_ben_no_cvg_flag,l_old_val) AND
613: (l_changed));
614: hr_utility.set_location(' ben_ppf_trigger', 150);
615: end if;

Line 618: l_changed := (benutils.column_changed(p_old.uses_tobacco_flag

614: hr_utility.set_location(' ben_ppf_trigger', 150);
615: end if;
616: --
617: if l_column = 'USES_TOBACCO_FLAG' then
618: l_changed := (benutils.column_changed(p_old.uses_tobacco_flag
619: ,p_new.uses_tobacco_flag,l_new_val) AND
620: benutils.column_changed(p_new.uses_tobacco_flag
621: ,p_old.uses_tobacco_flag,l_old_val) AND
622: (l_changed));

Line 620: benutils.column_changed(p_new.uses_tobacco_flag

616: --
617: if l_column = 'USES_TOBACCO_FLAG' then
618: l_changed := (benutils.column_changed(p_old.uses_tobacco_flag
619: ,p_new.uses_tobacco_flag,l_new_val) AND
620: benutils.column_changed(p_new.uses_tobacco_flag
621: ,p_old.uses_tobacco_flag,l_old_val) AND
622: (l_changed));
623: hr_utility.set_location(' ben_ppf_trigger', 160);
624: end if;

Line 627: l_changed := (benutils.column_changed(p_old.benefit_group_id

623: hr_utility.set_location(' ben_ppf_trigger', 160);
624: end if;
625: --
626: if l_column = 'BENEFIT_GROUP_ID' then
627: l_changed := (benutils.column_changed(p_old.benefit_group_id
628: ,p_new.benefit_group_id,l_new_val) AND
629: benutils.column_changed(p_new.benefit_group_id
630: ,p_old.benefit_group_id,l_old_val) AND
631: (l_changed));

Line 629: benutils.column_changed(p_new.benefit_group_id

625: --
626: if l_column = 'BENEFIT_GROUP_ID' then
627: l_changed := (benutils.column_changed(p_old.benefit_group_id
628: ,p_new.benefit_group_id,l_new_val) AND
629: benutils.column_changed(p_new.benefit_group_id
630: ,p_old.benefit_group_id,l_old_val) AND
631: (l_changed));
632: hr_utility.set_location(' ben_ppf_trigger', 170);
633: end if;

Line 636: l_changed := (benutils.column_changed(p_old.per_information10

632: hr_utility.set_location(' ben_ppf_trigger', 170);
633: end if;
634: --
635: if l_column = 'PER_INFORMATION10' then
636: l_changed := (benutils.column_changed(p_old.per_information10
637: ,p_new.per_information10,l_new_val) AND
638: benutils.column_changed(p_new.per_information10
639: ,p_old.per_information10,l_old_val) AND
640: (l_changed));

Line 638: benutils.column_changed(p_new.per_information10

634: --
635: if l_column = 'PER_INFORMATION10' then
636: l_changed := (benutils.column_changed(p_old.per_information10
637: ,p_new.per_information10,l_new_val) AND
638: benutils.column_changed(p_new.per_information10
639: ,p_old.per_information10,l_old_val) AND
640: (l_changed));
641: hr_utility.set_location(' ben_ppf_trigger',180);
642: end if;

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

642: end if;
643: --
644: if l_column = 'DPDNT_VLNTRY_SVCE_FLAG' then
645: hr_utility.set_location(' ben_ppf_trigger', 190);
646: l_changed := (benutils.column_changed(p_old.dpdnt_vlntry_svce_flag
647: ,p_new.dpdnt_vlntry_svce_flag,l_new_val) AND
648: benutils.column_changed(p_new.dpdnt_vlntry_svce_flag
649: ,p_old.dpdnt_vlntry_svce_flag,l_old_val) AND
650: (l_changed));

Line 648: benutils.column_changed(p_new.dpdnt_vlntry_svce_flag

644: if l_column = 'DPDNT_VLNTRY_SVCE_FLAG' then
645: hr_utility.set_location(' ben_ppf_trigger', 190);
646: l_changed := (benutils.column_changed(p_old.dpdnt_vlntry_svce_flag
647: ,p_new.dpdnt_vlntry_svce_flag,l_new_val) AND
648: benutils.column_changed(p_new.dpdnt_vlntry_svce_flag
649: ,p_old.dpdnt_vlntry_svce_flag,l_old_val) AND
650: (l_changed));
651: hr_utility.set_location(' ben_ppf_trigger', 190);
652: end if;

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

651: hr_utility.set_location(' ben_ppf_trigger', 190);
652: end if;
653: --
654: if l_column = 'RECEIPT_OF_DEATH_CERT_DATE' then
655: l_changed := (benutils.column_changed(p_old.receipt_of_death_cert_date
656: ,p_new.receipt_of_death_cert_date,l_new_val) AND
657: benutils.column_changed(p_new.receipt_of_death_cert_date
658: ,p_old.receipt_of_death_cert_date,l_old_val) AND
659: (l_changed));

Line 657: benutils.column_changed(p_new.receipt_of_death_cert_date

653: --
654: if l_column = 'RECEIPT_OF_DEATH_CERT_DATE' then
655: l_changed := (benutils.column_changed(p_old.receipt_of_death_cert_date
656: ,p_new.receipt_of_death_cert_date,l_new_val) AND
657: benutils.column_changed(p_new.receipt_of_death_cert_date
658: ,p_old.receipt_of_death_cert_date,l_old_val) AND
659: (l_changed));
660: hr_utility.set_location(' ben_ppf_trigger', 200);
661: end if;

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

660: hr_utility.set_location(' ben_ppf_trigger', 200);
661: end if;
662: --
663: if l_column = 'ATTRIBUTE1' then
664: l_changed := (benutils.column_changed(p_old.attribute1
665: ,p_new.attribute1,l_new_val) AND
666: benutils.column_changed(p_new.attribute1
667: ,p_old.attribute1,l_old_val) AND
668: (l_changed));

Line 666: benutils.column_changed(p_new.attribute1

662: --
663: if l_column = 'ATTRIBUTE1' then
664: l_changed := (benutils.column_changed(p_old.attribute1
665: ,p_new.attribute1,l_new_val) AND
666: benutils.column_changed(p_new.attribute1
667: ,p_old.attribute1,l_old_val) AND
668: (l_changed));
669: hr_utility.set_location(' ben_ppf_trigger', 210);
670: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);

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

671: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
672: end if;
673: --
674: if l_column = 'ATTRIBUTE2' then
675: l_changed := (benutils.column_changed(p_old.attribute2
676: ,p_new.attribute2,l_new_val) AND
677: benutils.column_changed(p_new.attribute2
678: ,p_old.attribute2,l_old_val) AND
679: (l_changed));

Line 677: benutils.column_changed(p_new.attribute2

673: --
674: if l_column = 'ATTRIBUTE2' then
675: l_changed := (benutils.column_changed(p_old.attribute2
676: ,p_new.attribute2,l_new_val) AND
677: benutils.column_changed(p_new.attribute2
678: ,p_old.attribute2,l_old_val) AND
679: (l_changed));
680: hr_utility.set_location(' ben_ppf_trigger', 220);
681: end if;

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

680: hr_utility.set_location(' ben_ppf_trigger', 220);
681: end if;
682: --
683: if l_column = 'ATTRIBUTE3' then
684: l_changed := (benutils.column_changed(p_old.attribute3
685: ,p_new.attribute3,l_new_val) AND
686: benutils.column_changed(p_new.attribute3
687: ,p_old.attribute3,l_old_val) AND
688: (l_changed));

Line 686: benutils.column_changed(p_new.attribute3

682: --
683: if l_column = 'ATTRIBUTE3' then
684: l_changed := (benutils.column_changed(p_old.attribute3
685: ,p_new.attribute3,l_new_val) AND
686: benutils.column_changed(p_new.attribute3
687: ,p_old.attribute3,l_old_val) AND
688: (l_changed));
689: hr_utility.set_location(' ben_ppf_trigger', 230);
690: end if;

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

689: hr_utility.set_location(' ben_ppf_trigger', 230);
690: end if;
691: --
692: if l_column = 'ATTRIBUTE4' then
693: l_changed := (benutils.column_changed(p_old.attribute4
694: ,p_new.attribute4,l_new_val) AND
695: benutils.column_changed(p_new.attribute4
696: ,p_old.attribute4,l_old_val) AND
697: (l_changed));

Line 695: benutils.column_changed(p_new.attribute4

691: --
692: if l_column = 'ATTRIBUTE4' then
693: l_changed := (benutils.column_changed(p_old.attribute4
694: ,p_new.attribute4,l_new_val) AND
695: benutils.column_changed(p_new.attribute4
696: ,p_old.attribute4,l_old_val) AND
697: (l_changed));
698: hr_utility.set_location(' ben_ppf_trigger', 240);
699: end if;

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

698: hr_utility.set_location(' ben_ppf_trigger', 240);
699: end if;
700: --
701: if l_column = 'ATTRIBUTE5' then
702: l_changed := (benutils.column_changed(p_old.attribute5
703: ,p_new.attribute5,l_new_val) AND
704: benutils.column_changed(p_new.attribute5
705: ,p_old.attribute5,l_old_val) AND
706: (l_changed));

Line 704: benutils.column_changed(p_new.attribute5

700: --
701: if l_column = 'ATTRIBUTE5' then
702: l_changed := (benutils.column_changed(p_old.attribute5
703: ,p_new.attribute5,l_new_val) AND
704: benutils.column_changed(p_new.attribute5
705: ,p_old.attribute5,l_old_val) AND
706: (l_changed));
707: hr_utility.set_location(' ben_ppf_trigger', 250);
708: end if;

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

707: hr_utility.set_location(' ben_ppf_trigger', 250);
708: end if;
709: --
710: if l_column = 'ATTRIBUTE6' then
711: l_changed := (benutils.column_changed(p_old.attribute6
712: ,p_new.attribute6,l_new_val) AND
713: benutils.column_changed(p_new.attribute6
714: ,p_old.attribute6,l_old_val) AND
715: (l_changed));

Line 713: benutils.column_changed(p_new.attribute6

709: --
710: if l_column = 'ATTRIBUTE6' then
711: l_changed := (benutils.column_changed(p_old.attribute6
712: ,p_new.attribute6,l_new_val) AND
713: benutils.column_changed(p_new.attribute6
714: ,p_old.attribute6,l_old_val) AND
715: (l_changed));
716: hr_utility.set_location(' ben_ppf_trigger', 260);
717: end if;

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

716: hr_utility.set_location(' ben_ppf_trigger', 260);
717: end if;
718: --
719: if l_column = 'ATTRIBUTE7' then
720: l_changed := (benutils.column_changed(p_old.attribute7
721: ,p_new.attribute7,l_new_val) AND
722: benutils.column_changed(p_new.attribute7
723: ,p_old.attribute7,l_old_val) AND
724: (l_changed));

Line 722: benutils.column_changed(p_new.attribute7

718: --
719: if l_column = 'ATTRIBUTE7' then
720: l_changed := (benutils.column_changed(p_old.attribute7
721: ,p_new.attribute7,l_new_val) AND
722: benutils.column_changed(p_new.attribute7
723: ,p_old.attribute7,l_old_val) AND
724: (l_changed));
725: hr_utility.set_location(' ben_ppf_trigger', 270);
726: end if;

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

725: hr_utility.set_location(' ben_ppf_trigger', 270);
726: end if;
727: --
728: if l_column = 'ATTRIBUTE8' then
729: l_changed := (benutils.column_changed(p_old.attribute8
730: ,p_new.attribute8,l_new_val) AND
731: benutils.column_changed(p_new.attribute8
732: ,p_old.attribute8,l_old_val) AND
733: (l_changed));

Line 731: benutils.column_changed(p_new.attribute8

727: --
728: if l_column = 'ATTRIBUTE8' then
729: l_changed := (benutils.column_changed(p_old.attribute8
730: ,p_new.attribute8,l_new_val) AND
731: benutils.column_changed(p_new.attribute8
732: ,p_old.attribute8,l_old_val) AND
733: (l_changed));
734: hr_utility.set_location(' ben_ppf_trigger', 280);
735: end if;

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

734: hr_utility.set_location(' ben_ppf_trigger', 280);
735: end if;
736: --
737: if l_column = 'ATTRIBUTE9' then
738: l_changed := (benutils.column_changed(p_old.attribute9
739: ,p_new.attribute9,l_new_val) AND
740: benutils.column_changed(p_new.attribute9
741: ,p_old.attribute9,l_old_val) AND
742: (l_changed));

Line 740: benutils.column_changed(p_new.attribute9

736: --
737: if l_column = 'ATTRIBUTE9' then
738: l_changed := (benutils.column_changed(p_old.attribute9
739: ,p_new.attribute9,l_new_val) AND
740: benutils.column_changed(p_new.attribute9
741: ,p_old.attribute9,l_old_val) AND
742: (l_changed));
743: hr_utility.set_location(' ben_ppf_trigger', 290);
744: end if;

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

743: hr_utility.set_location(' ben_ppf_trigger', 290);
744: end if;
745: --
746: if l_column = 'ATTRIBUTE10' then
747: l_changed := (benutils.column_changed(p_old.attribute10
748: ,p_new.attribute10,l_new_val) AND
749: benutils.column_changed(p_new.attribute10
750: ,p_old.attribute10,l_old_val) AND
751: (l_changed));

Line 749: benutils.column_changed(p_new.attribute10

745: --
746: if l_column = 'ATTRIBUTE10' then
747: l_changed := (benutils.column_changed(p_old.attribute10
748: ,p_new.attribute10,l_new_val) AND
749: benutils.column_changed(p_new.attribute10
750: ,p_old.attribute10,l_old_val) AND
751: (l_changed));
752: hr_utility.set_location(' ben_ppf_trigger', 300);
753: end if;

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

752: hr_utility.set_location(' ben_ppf_trigger', 300);
753: end if;
754: --
755: if l_column = 'ATTRIBUTE11' then
756: l_changed := (benutils.column_changed(p_old.attribute11
757: ,p_new.attribute11,l_new_val) AND
758: benutils.column_changed(p_new.attribute11
759: ,p_old.attribute11,l_old_val) AND
760: (l_changed));

Line 758: benutils.column_changed(p_new.attribute11

754: --
755: if l_column = 'ATTRIBUTE11' then
756: l_changed := (benutils.column_changed(p_old.attribute11
757: ,p_new.attribute11,l_new_val) AND
758: benutils.column_changed(p_new.attribute11
759: ,p_old.attribute11,l_old_val) AND
760: (l_changed));
761: hr_utility.set_location(' ben_ppf_trigger', 310);
762: end if;

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

761: hr_utility.set_location(' ben_ppf_trigger', 310);
762: end if;
763: --
764: if l_column = 'ATTRIBUTE12' then
765: l_changed := (benutils.column_changed(p_old.attribute12
766: ,p_new.attribute12,l_new_val) AND
767: benutils.column_changed(p_new.attribute12
768: ,p_old.attribute12,l_old_val) AND
769: (l_changed));

Line 767: benutils.column_changed(p_new.attribute12

763: --
764: if l_column = 'ATTRIBUTE12' then
765: l_changed := (benutils.column_changed(p_old.attribute12
766: ,p_new.attribute12,l_new_val) AND
767: benutils.column_changed(p_new.attribute12
768: ,p_old.attribute12,l_old_val) AND
769: (l_changed));
770: hr_utility.set_location(' ben_ppf_trigger', 320);
771: end if;

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

770: hr_utility.set_location(' ben_ppf_trigger', 320);
771: end if;
772: --
773: if l_column = 'ATTRIBUTE13' then
774: l_changed := (benutils.column_changed(p_old.attribute13
775: ,p_new.attribute13,l_new_val) AND
776: benutils.column_changed(p_new.attribute13
777: ,p_old.attribute13,l_old_val) AND
778: (l_changed));

Line 776: benutils.column_changed(p_new.attribute13

772: --
773: if l_column = 'ATTRIBUTE13' then
774: l_changed := (benutils.column_changed(p_old.attribute13
775: ,p_new.attribute13,l_new_val) AND
776: benutils.column_changed(p_new.attribute13
777: ,p_old.attribute13,l_old_val) AND
778: (l_changed));
779: hr_utility.set_location(' ben_ppf_trigger', 330);
780: end if;

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

779: hr_utility.set_location(' ben_ppf_trigger', 330);
780: end if;
781: --
782: if l_column = 'ATTRIBUTE14' then
783: l_changed := (benutils.column_changed(p_old.attribute14
784: ,p_new.attribute14,l_new_val) AND
785: benutils.column_changed(p_new.attribute14
786: ,p_old.attribute14,l_old_val) AND
787: (l_changed));

Line 785: benutils.column_changed(p_new.attribute14

781: --
782: if l_column = 'ATTRIBUTE14' then
783: l_changed := (benutils.column_changed(p_old.attribute14
784: ,p_new.attribute14,l_new_val) AND
785: benutils.column_changed(p_new.attribute14
786: ,p_old.attribute14,l_old_val) AND
787: (l_changed));
788: hr_utility.set_location(' ben_ppf_trigger', 340);
789: end if;

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

788: hr_utility.set_location(' ben_ppf_trigger', 340);
789: end if;
790: --
791: if l_column = 'ATTRIBUTE15' then
792: l_changed := (benutils.column_changed(p_old.attribute15
793: ,p_new.attribute15,l_new_val) AND
794: benutils.column_changed(p_new.attribute15
795: ,p_old.attribute15,l_old_val) AND
796: (l_changed));

Line 794: benutils.column_changed(p_new.attribute15

790: --
791: if l_column = 'ATTRIBUTE15' then
792: l_changed := (benutils.column_changed(p_old.attribute15
793: ,p_new.attribute15,l_new_val) AND
794: benutils.column_changed(p_new.attribute15
795: ,p_old.attribute15,l_old_val) AND
796: (l_changed));
797: hr_utility.set_location(' ben_ppf_trigger', 350);
798: end if;

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

797: hr_utility.set_location(' ben_ppf_trigger', 350);
798: end if;
799: --
800: if l_column = 'ATTRIBUTE16' then
801: l_changed := (benutils.column_changed(p_old.attribute16
802: ,p_new.attribute16,l_new_val) AND
803: benutils.column_changed(p_new.attribute16
804: ,p_old.attribute16,l_old_val) AND
805: (l_changed));

Line 803: benutils.column_changed(p_new.attribute16

799: --
800: if l_column = 'ATTRIBUTE16' then
801: l_changed := (benutils.column_changed(p_old.attribute16
802: ,p_new.attribute16,l_new_val) AND
803: benutils.column_changed(p_new.attribute16
804: ,p_old.attribute16,l_old_val) AND
805: (l_changed));
806: hr_utility.set_location(' ben_ppf_trigger', 360);
807: end if;

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

806: hr_utility.set_location(' ben_ppf_trigger', 360);
807: end if;
808: --
809: if l_column = 'ATTRIBUTE17' then
810: l_changed := (benutils.column_changed(p_old.attribute17
811: ,p_new.attribute17,l_new_val) AND
812: benutils.column_changed(p_new.attribute17
813: ,p_old.attribute17,l_old_val) AND
814: (l_changed));

Line 812: benutils.column_changed(p_new.attribute17

808: --
809: if l_column = 'ATTRIBUTE17' then
810: l_changed := (benutils.column_changed(p_old.attribute17
811: ,p_new.attribute17,l_new_val) AND
812: benutils.column_changed(p_new.attribute17
813: ,p_old.attribute17,l_old_val) AND
814: (l_changed));
815: hr_utility.set_location(' ben_ppf_trigger', 370);
816: end if;

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

815: hr_utility.set_location(' ben_ppf_trigger', 370);
816: end if;
817: --
818: if l_column = 'ATTRIBUTE18' then
819: l_changed := (benutils.column_changed(p_old.attribute18
820: ,p_new.attribute18,l_new_val) AND
821: benutils.column_changed(p_new.attribute18
822: ,p_old.attribute18,l_old_val) AND
823: (l_changed));

Line 821: benutils.column_changed(p_new.attribute18

817: --
818: if l_column = 'ATTRIBUTE18' then
819: l_changed := (benutils.column_changed(p_old.attribute18
820: ,p_new.attribute18,l_new_val) AND
821: benutils.column_changed(p_new.attribute18
822: ,p_old.attribute18,l_old_val) AND
823: (l_changed));
824: hr_utility.set_location(' ben_ppf_trigger', 380);
825: end if;

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

824: hr_utility.set_location(' ben_ppf_trigger', 380);
825: end if;
826: --
827: if l_column = 'ATTRIBUTE19' then
828: l_changed := (benutils.column_changed(p_old.attribute19
829: ,p_new.attribute19,l_new_val) AND
830: benutils.column_changed(p_new.attribute19
831: ,p_old.attribute19,l_old_val) AND
832: (l_changed));

Line 830: benutils.column_changed(p_new.attribute19

826: --
827: if l_column = 'ATTRIBUTE19' then
828: l_changed := (benutils.column_changed(p_old.attribute19
829: ,p_new.attribute19,l_new_val) AND
830: benutils.column_changed(p_new.attribute19
831: ,p_old.attribute19,l_old_val) AND
832: (l_changed));
833: hr_utility.set_location(' ben_ppf_trigger', 390);
834: end if;

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

833: hr_utility.set_location(' ben_ppf_trigger', 390);
834: end if;
835: --
836: if l_column = 'ATTRIBUTE20' then
837: l_changed := (benutils.column_changed(p_old.attribute20
838: ,p_new.attribute20,l_new_val) AND
839: benutils.column_changed(p_new.attribute20
840: ,p_old.attribute20,l_old_val) AND
841: (l_changed));

Line 839: benutils.column_changed(p_new.attribute20

835: --
836: if l_column = 'ATTRIBUTE20' then
837: l_changed := (benutils.column_changed(p_old.attribute20
838: ,p_new.attribute20,l_new_val) AND
839: benutils.column_changed(p_new.attribute20
840: ,p_old.attribute20,l_old_val) AND
841: (l_changed));
842: hr_utility.set_location(' ben_ppf_trigger', 400);
843: end if;

Line 846: l_changed := (benutils.column_changed(p_old.attribute21

842: hr_utility.set_location(' ben_ppf_trigger', 400);
843: end if;
844: --
845: if l_column = 'ATTRIBUTE21' then
846: l_changed := (benutils.column_changed(p_old.attribute21
847: ,p_new.attribute21,l_new_val) AND
848: benutils.column_changed(p_new.attribute21
849: ,p_old.attribute21,l_old_val) AND
850: (l_changed));

Line 848: benutils.column_changed(p_new.attribute21

844: --
845: if l_column = 'ATTRIBUTE21' then
846: l_changed := (benutils.column_changed(p_old.attribute21
847: ,p_new.attribute21,l_new_val) AND
848: benutils.column_changed(p_new.attribute21
849: ,p_old.attribute21,l_old_val) AND
850: (l_changed));
851: hr_utility.set_location(' ben_ppf_trigger', 410);
852: end if;

Line 855: l_changed := (benutils.column_changed(p_old.attribute22

851: hr_utility.set_location(' ben_ppf_trigger', 410);
852: end if;
853: --
854: if l_column = 'ATTRIBUTE22' then
855: l_changed := (benutils.column_changed(p_old.attribute22
856: ,p_new.attribute22,l_new_val) AND
857: benutils.column_changed(p_new.attribute22
858: ,p_old.attribute22,l_old_val) AND
859: (l_changed));

Line 857: benutils.column_changed(p_new.attribute22

853: --
854: if l_column = 'ATTRIBUTE22' then
855: l_changed := (benutils.column_changed(p_old.attribute22
856: ,p_new.attribute22,l_new_val) AND
857: benutils.column_changed(p_new.attribute22
858: ,p_old.attribute22,l_old_val) AND
859: (l_changed));
860: hr_utility.set_location(' ben_ppf_trigger', 420);
861: end if;

Line 864: l_changed := (benutils.column_changed(p_old.attribute23

860: hr_utility.set_location(' ben_ppf_trigger', 420);
861: end if;
862: --
863: if l_column = 'ATTRIBUTE23' then
864: l_changed := (benutils.column_changed(p_old.attribute23
865: ,p_new.attribute23,l_new_val) AND
866: benutils.column_changed(p_new.attribute23
867: ,p_old.attribute23,l_old_val) AND
868: (l_changed));

Line 866: benutils.column_changed(p_new.attribute23

862: --
863: if l_column = 'ATTRIBUTE23' then
864: l_changed := (benutils.column_changed(p_old.attribute23
865: ,p_new.attribute23,l_new_val) AND
866: benutils.column_changed(p_new.attribute23
867: ,p_old.attribute23,l_old_val) AND
868: (l_changed));
869: hr_utility.set_location(' ben_ppf_trigger', 430);
870: end if;

Line 873: l_changed := (benutils.column_changed(p_old.attribute24

869: hr_utility.set_location(' ben_ppf_trigger', 430);
870: end if;
871: --
872: if l_column = 'ATTRIBUTE24' then
873: l_changed := (benutils.column_changed(p_old.attribute24
874: ,p_new.attribute24,l_new_val) AND
875: benutils.column_changed(p_new.attribute24
876: ,p_old.attribute24,l_old_val) AND
877: (l_changed));

Line 875: benutils.column_changed(p_new.attribute24

871: --
872: if l_column = 'ATTRIBUTE24' then
873: l_changed := (benutils.column_changed(p_old.attribute24
874: ,p_new.attribute24,l_new_val) AND
875: benutils.column_changed(p_new.attribute24
876: ,p_old.attribute24,l_old_val) AND
877: (l_changed));
878: hr_utility.set_location(' ben_ppf_trigger', 440);
879: end if;

Line 882: l_changed := (benutils.column_changed(p_old.attribute25

878: hr_utility.set_location(' ben_ppf_trigger', 440);
879: end if;
880: --
881: if l_column = 'ATTRIBUTE25' then
882: l_changed := (benutils.column_changed(p_old.attribute25
883: ,p_new.attribute25,l_new_val) AND
884: benutils.column_changed(p_new.attribute25
885: ,p_old.attribute25,l_old_val) AND
886: (l_changed));

Line 884: benutils.column_changed(p_new.attribute25

880: --
881: if l_column = 'ATTRIBUTE25' then
882: l_changed := (benutils.column_changed(p_old.attribute25
883: ,p_new.attribute25,l_new_val) AND
884: benutils.column_changed(p_new.attribute25
885: ,p_old.attribute25,l_old_val) AND
886: (l_changed));
887: hr_utility.set_location(' ben_ppf_trigger', 450);
888: end if;

Line 891: l_changed := (benutils.column_changed(p_old.attribute26

887: hr_utility.set_location(' ben_ppf_trigger', 450);
888: end if;
889: --
890: if l_column = 'ATTRIBUTE26' then
891: l_changed := (benutils.column_changed(p_old.attribute26
892: ,p_new.attribute26,l_new_val) AND
893: benutils.column_changed(p_new.attribute26
894: ,p_old.attribute26,l_old_val) AND
895: (l_changed));

Line 893: benutils.column_changed(p_new.attribute26

889: --
890: if l_column = 'ATTRIBUTE26' then
891: l_changed := (benutils.column_changed(p_old.attribute26
892: ,p_new.attribute26,l_new_val) AND
893: benutils.column_changed(p_new.attribute26
894: ,p_old.attribute26,l_old_val) AND
895: (l_changed));
896: hr_utility.set_location(' ben_ppf_trigger', 460);
897: end if;

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

896: hr_utility.set_location(' ben_ppf_trigger', 460);
897: end if;
898: --
899: if l_column = 'ATTRIBUTE27' then
900: l_changed := (benutils.column_changed(p_old.attribute27
901: ,p_new.attribute27,l_new_val) AND
902: benutils.column_changed(p_new.attribute27
903: ,p_old.attribute27,l_old_val) AND
904: (l_changed));

Line 902: benutils.column_changed(p_new.attribute27

898: --
899: if l_column = 'ATTRIBUTE27' then
900: l_changed := (benutils.column_changed(p_old.attribute27
901: ,p_new.attribute27,l_new_val) AND
902: benutils.column_changed(p_new.attribute27
903: ,p_old.attribute27,l_old_val) AND
904: (l_changed));
905: hr_utility.set_location(' ben_ppf_trigger', 470);
906: end if;

Line 909: l_changed := (benutils.column_changed(p_old.attribute28

905: hr_utility.set_location(' ben_ppf_trigger', 470);
906: end if;
907: --
908: if l_column = 'ATTRIBUTE28' then
909: l_changed := (benutils.column_changed(p_old.attribute28
910: ,p_new.attribute28,l_new_val) AND
911: benutils.column_changed(p_new.attribute28
912: ,p_old.attribute28,l_old_val) AND
913: (l_changed));

Line 911: benutils.column_changed(p_new.attribute28

907: --
908: if l_column = 'ATTRIBUTE28' then
909: l_changed := (benutils.column_changed(p_old.attribute28
910: ,p_new.attribute28,l_new_val) AND
911: benutils.column_changed(p_new.attribute28
912: ,p_old.attribute28,l_old_val) AND
913: (l_changed));
914: hr_utility.set_location(' ben_ppf_trigger', 480);
915: end if;

Line 918: l_changed := (benutils.column_changed(p_old.attribute29

914: hr_utility.set_location(' ben_ppf_trigger', 480);
915: end if;
916: --
917: if l_column = 'ATTRIBUTE29' then
918: l_changed := (benutils.column_changed(p_old.attribute29
919: ,p_new.attribute29,l_new_val) AND
920: benutils.column_changed(p_new.attribute29
921: ,p_old.attribute29,l_old_val) AND
922: (l_changed));

Line 920: benutils.column_changed(p_new.attribute29

916: --
917: if l_column = 'ATTRIBUTE29' then
918: l_changed := (benutils.column_changed(p_old.attribute29
919: ,p_new.attribute29,l_new_val) AND
920: benutils.column_changed(p_new.attribute29
921: ,p_old.attribute29,l_old_val) AND
922: (l_changed));
923: hr_utility.set_location(' ben_ppf_trigger', 490);
924: end if;

Line 927: l_changed := (benutils.column_changed(p_old.attribute30

923: hr_utility.set_location(' ben_ppf_trigger', 490);
924: end if;
925: --
926: if l_column = 'ATTRIBUTE30' then
927: l_changed := (benutils.column_changed(p_old.attribute30
928: ,p_new.attribute30,l_new_val) AND
929: benutils.column_changed(p_new.attribute30
930: ,p_old.attribute30,l_old_val) AND
931: (l_changed));

Line 929: benutils.column_changed(p_new.attribute30

925: --
926: if l_column = 'ATTRIBUTE30' then
927: l_changed := (benutils.column_changed(p_old.attribute30
928: ,p_new.attribute30,l_new_val) AND
929: benutils.column_changed(p_new.attribute30
930: ,p_old.attribute30,l_old_val) AND
931: (l_changed));
932: hr_utility.set_location(' ben_ppf_trigger', 500);
933: end if;