APPS.BEN_PAC_LER dependencies on BENUTILS

Line 127: l_outputs := benutils.formula

123: end if;
124: --
125: --
126: hr_utility.set_location('assignment_id '||l_ass_rec.assignment_id , 13);
127: l_outputs := benutils.formula
128: (p_formula_id => p_formula_id,
129: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
130: p_assignment_id => l_ass_rec.assignment_id,
131: p_organization_id => l_ass_rec.organization_id,

Line 420: benutils.set_data_migrator_mode;

416: l_ret_date date;
417: --
418: begin
419: --
420: benutils.set_data_migrator_mode;
421: if hr_general.g_data_migrator_mode in ( 'Y','P') then
422: --
423: return;
424: --

Line 784: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || l_rule_output, 40);

780: p_param_tab => l_param_tab ,
781: p_ret_val => l_rule_output,
782: p_ret_date => l_ret_date );
783: --
784: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || l_rule_output, 40);
785: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || to_char(l_ret_date), 40);
786: --
787: -- rule date overrides all dates
788: l_lf_evt_ocrd_date := nvl(l_ret_date , l_lf_evt_ocrd_date ) ;

Line 785: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || to_char(l_ret_date), 40);

781: p_ret_val => l_rule_output,
782: p_ret_date => l_ret_date );
783: --
784: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || l_rule_output, 40);
785: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || to_char(l_ret_date), 40);
786: --
787: -- rule date overrides all dates
788: l_lf_evt_ocrd_date := nvl(l_ret_date , l_lf_evt_ocrd_date ) ;
789: --

Line 794: l_changed := (benutils.column_changed(p_old.DATE_FROM

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

Line 796: benutils.column_changed(p_new.DATE_FROM

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

Line 803: l_changed := (benutils.column_changed(p_old.DATE_TO

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

Line 805: benutils.column_changed(p_new.DATE_TO

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

Line 811: l_changed := (benutils.column_changed(p_old.ANALYSIS_CRITERIA_ID

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

Line 813: benutils.column_changed(p_new.ANALYSIS_CRITERIA_ID

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

Line 819: l_changed := (benutils.column_changed(l_old_pac.SEGMENT1

815: (l_changed));
816: end if;
817: --
818: if l_column = 'SEGMENT1' then
819: l_changed := (benutils.column_changed(l_old_pac.SEGMENT1
820: ,l_new_pac.SEGMENT1,l_new_val) AND
821: benutils.column_changed(l_new_pac.SEGMENT1
822: ,l_old_pac.SEGMENT1,l_old_val) AND
823: (l_changed));

Line 821: benutils.column_changed(l_new_pac.SEGMENT1

817: --
818: if l_column = 'SEGMENT1' then
819: l_changed := (benutils.column_changed(l_old_pac.SEGMENT1
820: ,l_new_pac.SEGMENT1,l_new_val) AND
821: benutils.column_changed(l_new_pac.SEGMENT1
822: ,l_old_pac.SEGMENT1,l_old_val) AND
823: (l_changed));
824: end if;
825: --

Line 827: l_changed := (benutils.column_changed(l_old_pac.SEGMENT2

823: (l_changed));
824: end if;
825: --
826: if l_column = 'SEGMENT2' then
827: l_changed := (benutils.column_changed(l_old_pac.SEGMENT2
828: ,l_new_pac.SEGMENT2,l_new_val) AND
829: benutils.column_changed(l_new_pac.SEGMENT2
830: ,l_old_pac.SEGMENT2,l_old_val) AND
831: (l_changed));

Line 829: benutils.column_changed(l_new_pac.SEGMENT2

825: --
826: if l_column = 'SEGMENT2' then
827: l_changed := (benutils.column_changed(l_old_pac.SEGMENT2
828: ,l_new_pac.SEGMENT2,l_new_val) AND
829: benutils.column_changed(l_new_pac.SEGMENT2
830: ,l_old_pac.SEGMENT2,l_old_val) AND
831: (l_changed));
832: end if;
833: --

Line 835: l_changed := (benutils.column_changed(l_old_pac.SEGMENT3

831: (l_changed));
832: end if;
833: --
834: if l_column = 'SEGMENT3' then
835: l_changed := (benutils.column_changed(l_old_pac.SEGMENT3
836: ,l_new_pac.SEGMENT3,l_new_val) AND
837: benutils.column_changed(l_new_pac.SEGMENT3
838: ,l_old_pac.SEGMENT3,l_old_val) AND
839: (l_changed));

Line 837: benutils.column_changed(l_new_pac.SEGMENT3

833: --
834: if l_column = 'SEGMENT3' then
835: l_changed := (benutils.column_changed(l_old_pac.SEGMENT3
836: ,l_new_pac.SEGMENT3,l_new_val) AND
837: benutils.column_changed(l_new_pac.SEGMENT3
838: ,l_old_pac.SEGMENT3,l_old_val) AND
839: (l_changed));
840: end if;
841: --

Line 843: l_changed := (benutils.column_changed(l_old_pac.SEGMENT4

839: (l_changed));
840: end if;
841: --
842: if l_column = 'SEGMENT4' then
843: l_changed := (benutils.column_changed(l_old_pac.SEGMENT4
844: ,l_new_pac.SEGMENT4,l_new_val) AND
845: benutils.column_changed(l_new_pac.SEGMENT4
846: ,l_old_pac.SEGMENT4,l_old_val) AND
847: (l_changed));

Line 845: benutils.column_changed(l_new_pac.SEGMENT4

841: --
842: if l_column = 'SEGMENT4' then
843: l_changed := (benutils.column_changed(l_old_pac.SEGMENT4
844: ,l_new_pac.SEGMENT4,l_new_val) AND
845: benutils.column_changed(l_new_pac.SEGMENT4
846: ,l_old_pac.SEGMENT4,l_old_val) AND
847: (l_changed));
848: end if;
849: --

Line 851: l_changed := (benutils.column_changed(l_old_pac.SEGMENT5

847: (l_changed));
848: end if;
849: --
850: if l_column = 'SEGMENT5' then
851: l_changed := (benutils.column_changed(l_old_pac.SEGMENT5
852: ,l_new_pac.SEGMENT5,l_new_val) AND
853: benutils.column_changed(l_new_pac.SEGMENT5
854: ,l_old_pac.SEGMENT5,l_old_val) AND
855: (l_changed));

Line 853: benutils.column_changed(l_new_pac.SEGMENT5

849: --
850: if l_column = 'SEGMENT5' then
851: l_changed := (benutils.column_changed(l_old_pac.SEGMENT5
852: ,l_new_pac.SEGMENT5,l_new_val) AND
853: benutils.column_changed(l_new_pac.SEGMENT5
854: ,l_old_pac.SEGMENT5,l_old_val) AND
855: (l_changed));
856: end if;
857: --

Line 859: l_changed := (benutils.column_changed(l_old_pac.SEGMENT6

855: (l_changed));
856: end if;
857: --
858: if l_column = 'SEGMENT6' then
859: l_changed := (benutils.column_changed(l_old_pac.SEGMENT6
860: ,l_new_pac.SEGMENT6,l_new_val) AND
861: benutils.column_changed(l_new_pac.SEGMENT6
862: ,l_old_pac.SEGMENT6,l_old_val) AND
863: (l_changed));

Line 861: benutils.column_changed(l_new_pac.SEGMENT6

857: --
858: if l_column = 'SEGMENT6' then
859: l_changed := (benutils.column_changed(l_old_pac.SEGMENT6
860: ,l_new_pac.SEGMENT6,l_new_val) AND
861: benutils.column_changed(l_new_pac.SEGMENT6
862: ,l_old_pac.SEGMENT6,l_old_val) AND
863: (l_changed));
864: end if;
865: --

Line 867: l_changed := (benutils.column_changed(l_old_pac.SEGMENT7

863: (l_changed));
864: end if;
865: --
866: if l_column = 'SEGMENT7' then
867: l_changed := (benutils.column_changed(l_old_pac.SEGMENT7
868: ,l_new_pac.SEGMENT7,l_new_val) AND
869: benutils.column_changed(l_new_pac.SEGMENT7
870: ,l_old_pac.SEGMENT7,l_old_val) AND
871: (l_changed));

Line 869: benutils.column_changed(l_new_pac.SEGMENT7

865: --
866: if l_column = 'SEGMENT7' then
867: l_changed := (benutils.column_changed(l_old_pac.SEGMENT7
868: ,l_new_pac.SEGMENT7,l_new_val) AND
869: benutils.column_changed(l_new_pac.SEGMENT7
870: ,l_old_pac.SEGMENT7,l_old_val) AND
871: (l_changed));
872: end if;
873: --

Line 875: l_changed := (benutils.column_changed(l_old_pac.SEGMENT8

871: (l_changed));
872: end if;
873: --
874: if l_column = 'SEGMENT8' then
875: l_changed := (benutils.column_changed(l_old_pac.SEGMENT8
876: ,l_new_pac.SEGMENT8,l_new_val) AND
877: benutils.column_changed(l_new_pac.SEGMENT8
878: ,l_old_pac.SEGMENT8,l_old_val) AND
879: (l_changed));

Line 877: benutils.column_changed(l_new_pac.SEGMENT8

873: --
874: if l_column = 'SEGMENT8' then
875: l_changed := (benutils.column_changed(l_old_pac.SEGMENT8
876: ,l_new_pac.SEGMENT8,l_new_val) AND
877: benutils.column_changed(l_new_pac.SEGMENT8
878: ,l_old_pac.SEGMENT8,l_old_val) AND
879: (l_changed));
880: end if;
881: --

Line 883: l_changed := (benutils.column_changed(l_old_pac.SEGMENT9

879: (l_changed));
880: end if;
881: --
882: if l_column = 'SEGMENT9' then
883: l_changed := (benutils.column_changed(l_old_pac.SEGMENT9
884: ,l_new_pac.SEGMENT9,l_new_val) AND
885: benutils.column_changed(l_new_pac.SEGMENT9
886: ,l_old_pac.SEGMENT9,l_old_val) AND
887: (l_changed));

Line 885: benutils.column_changed(l_new_pac.SEGMENT9

881: --
882: if l_column = 'SEGMENT9' then
883: l_changed := (benutils.column_changed(l_old_pac.SEGMENT9
884: ,l_new_pac.SEGMENT9,l_new_val) AND
885: benutils.column_changed(l_new_pac.SEGMENT9
886: ,l_old_pac.SEGMENT9,l_old_val) AND
887: (l_changed));
888: end if;
889: --

Line 891: l_changed := (benutils.column_changed(l_old_pac.SEGMENT10

887: (l_changed));
888: end if;
889: --
890: if l_column = 'SEGMENT10' then
891: l_changed := (benutils.column_changed(l_old_pac.SEGMENT10
892: ,l_new_pac.SEGMENT10,l_new_val) AND
893: benutils.column_changed(l_new_pac.SEGMENT10
894: ,l_old_pac.SEGMENT10,l_old_val) AND
895: (l_changed));

Line 893: benutils.column_changed(l_new_pac.SEGMENT10

889: --
890: if l_column = 'SEGMENT10' then
891: l_changed := (benutils.column_changed(l_old_pac.SEGMENT10
892: ,l_new_pac.SEGMENT10,l_new_val) AND
893: benutils.column_changed(l_new_pac.SEGMENT10
894: ,l_old_pac.SEGMENT10,l_old_val) AND
895: (l_changed));
896: end if;
897: --

Line 899: l_changed := (benutils.column_changed(l_old_pac.SEGMENT11

895: (l_changed));
896: end if;
897: --
898: if l_column = 'SEGMENT11' then
899: l_changed := (benutils.column_changed(l_old_pac.SEGMENT11
900: ,l_new_pac.SEGMENT11,l_new_val) AND
901: benutils.column_changed(l_new_pac.SEGMENT11
902: ,l_old_pac.SEGMENT11,l_old_val) AND
903: (l_changed));

Line 901: benutils.column_changed(l_new_pac.SEGMENT11

897: --
898: if l_column = 'SEGMENT11' then
899: l_changed := (benutils.column_changed(l_old_pac.SEGMENT11
900: ,l_new_pac.SEGMENT11,l_new_val) AND
901: benutils.column_changed(l_new_pac.SEGMENT11
902: ,l_old_pac.SEGMENT11,l_old_val) AND
903: (l_changed));
904: end if;
905: --

Line 907: l_changed := (benutils.column_changed(l_old_pac.SEGMENT12

903: (l_changed));
904: end if;
905: --
906: if l_column = 'SEGMENT12' then
907: l_changed := (benutils.column_changed(l_old_pac.SEGMENT12
908: ,l_new_pac.SEGMENT12,l_new_val) AND
909: benutils.column_changed(l_new_pac.SEGMENT12
910: ,l_old_pac.SEGMENT12,l_old_val) AND
911: (l_changed));

Line 909: benutils.column_changed(l_new_pac.SEGMENT12

905: --
906: if l_column = 'SEGMENT12' then
907: l_changed := (benutils.column_changed(l_old_pac.SEGMENT12
908: ,l_new_pac.SEGMENT12,l_new_val) AND
909: benutils.column_changed(l_new_pac.SEGMENT12
910: ,l_old_pac.SEGMENT12,l_old_val) AND
911: (l_changed));
912: end if;
913: --

Line 915: l_changed := (benutils.column_changed(l_old_pac.SEGMENT13

911: (l_changed));
912: end if;
913: --
914: if l_column = 'SEGMENT13' then
915: l_changed := (benutils.column_changed(l_old_pac.SEGMENT13
916: ,l_new_pac.SEGMENT13,l_new_val) AND
917: benutils.column_changed(l_new_pac.SEGMENT13
918: ,l_old_pac.SEGMENT13,l_old_val) AND
919: (l_changed));

Line 917: benutils.column_changed(l_new_pac.SEGMENT13

913: --
914: if l_column = 'SEGMENT13' then
915: l_changed := (benutils.column_changed(l_old_pac.SEGMENT13
916: ,l_new_pac.SEGMENT13,l_new_val) AND
917: benutils.column_changed(l_new_pac.SEGMENT13
918: ,l_old_pac.SEGMENT13,l_old_val) AND
919: (l_changed));
920: end if;
921: --

Line 923: l_changed := (benutils.column_changed(l_old_pac.SEGMENT14

919: (l_changed));
920: end if;
921: --
922: if l_column = 'SEGMENT14' then
923: l_changed := (benutils.column_changed(l_old_pac.SEGMENT14
924: ,l_new_pac.SEGMENT14,l_new_val) AND
925: benutils.column_changed(l_new_pac.SEGMENT14
926: ,l_old_pac.SEGMENT14,l_old_val) AND
927: (l_changed));

Line 925: benutils.column_changed(l_new_pac.SEGMENT14

921: --
922: if l_column = 'SEGMENT14' then
923: l_changed := (benutils.column_changed(l_old_pac.SEGMENT14
924: ,l_new_pac.SEGMENT14,l_new_val) AND
925: benutils.column_changed(l_new_pac.SEGMENT14
926: ,l_old_pac.SEGMENT14,l_old_val) AND
927: (l_changed));
928: end if;
929: --

Line 931: l_changed := (benutils.column_changed(l_old_pac.SEGMENT15

927: (l_changed));
928: end if;
929: --
930: if l_column = 'SEGMENT15' then
931: l_changed := (benutils.column_changed(l_old_pac.SEGMENT15
932: ,l_new_pac.SEGMENT15,l_new_val) AND
933: benutils.column_changed(l_new_pac.SEGMENT15
934: ,l_old_pac.SEGMENT15,l_old_val) AND
935: (l_changed));

Line 933: benutils.column_changed(l_new_pac.SEGMENT15

929: --
930: if l_column = 'SEGMENT15' then
931: l_changed := (benutils.column_changed(l_old_pac.SEGMENT15
932: ,l_new_pac.SEGMENT15,l_new_val) AND
933: benutils.column_changed(l_new_pac.SEGMENT15
934: ,l_old_pac.SEGMENT15,l_old_val) AND
935: (l_changed));
936: end if;
937: --

Line 939: l_changed := (benutils.column_changed(l_old_pac.SEGMENT16

935: (l_changed));
936: end if;
937: --
938: if l_column = 'SEGMENT16' then
939: l_changed := (benutils.column_changed(l_old_pac.SEGMENT16
940: ,l_new_pac.SEGMENT16,l_new_val) AND
941: benutils.column_changed(l_new_pac.SEGMENT16
942: ,l_old_pac.SEGMENT16,l_old_val) AND
943: (l_changed));

Line 941: benutils.column_changed(l_new_pac.SEGMENT16

937: --
938: if l_column = 'SEGMENT16' then
939: l_changed := (benutils.column_changed(l_old_pac.SEGMENT16
940: ,l_new_pac.SEGMENT16,l_new_val) AND
941: benutils.column_changed(l_new_pac.SEGMENT16
942: ,l_old_pac.SEGMENT16,l_old_val) AND
943: (l_changed));
944: end if;
945: --

Line 947: l_changed := (benutils.column_changed(l_old_pac.SEGMENT17

943: (l_changed));
944: end if;
945: --
946: if l_column = 'SEGMENT17' then
947: l_changed := (benutils.column_changed(l_old_pac.SEGMENT17
948: ,l_new_pac.SEGMENT17,l_new_val) AND
949: benutils.column_changed(l_new_pac.SEGMENT17
950: ,l_old_pac.SEGMENT17,l_old_val) AND
951: (l_changed));

Line 949: benutils.column_changed(l_new_pac.SEGMENT17

945: --
946: if l_column = 'SEGMENT17' then
947: l_changed := (benutils.column_changed(l_old_pac.SEGMENT17
948: ,l_new_pac.SEGMENT17,l_new_val) AND
949: benutils.column_changed(l_new_pac.SEGMENT17
950: ,l_old_pac.SEGMENT17,l_old_val) AND
951: (l_changed));
952: end if;
953: --

Line 955: l_changed := (benutils.column_changed(l_old_pac.SEGMENT18

951: (l_changed));
952: end if;
953: --
954: if l_column = 'SEGMENT18' then
955: l_changed := (benutils.column_changed(l_old_pac.SEGMENT18
956: ,l_new_pac.SEGMENT18,l_new_val) AND
957: benutils.column_changed(l_new_pac.SEGMENT18
958: ,l_old_pac.SEGMENT18,l_old_val) AND
959: (l_changed));

Line 957: benutils.column_changed(l_new_pac.SEGMENT18

953: --
954: if l_column = 'SEGMENT18' then
955: l_changed := (benutils.column_changed(l_old_pac.SEGMENT18
956: ,l_new_pac.SEGMENT18,l_new_val) AND
957: benutils.column_changed(l_new_pac.SEGMENT18
958: ,l_old_pac.SEGMENT18,l_old_val) AND
959: (l_changed));
960: end if;
961: --

Line 963: l_changed := (benutils.column_changed(l_old_pac.SEGMENT19

959: (l_changed));
960: end if;
961: --
962: if l_column = 'SEGMENT19' then
963: l_changed := (benutils.column_changed(l_old_pac.SEGMENT19
964: ,l_new_pac.SEGMENT19,l_new_val) AND
965: benutils.column_changed(l_new_pac.SEGMENT19
966: ,l_old_pac.SEGMENT19,l_old_val) AND
967: (l_changed));

Line 965: benutils.column_changed(l_new_pac.SEGMENT19

961: --
962: if l_column = 'SEGMENT19' then
963: l_changed := (benutils.column_changed(l_old_pac.SEGMENT19
964: ,l_new_pac.SEGMENT19,l_new_val) AND
965: benutils.column_changed(l_new_pac.SEGMENT19
966: ,l_old_pac.SEGMENT19,l_old_val) AND
967: (l_changed));
968: end if;
969: --

Line 971: l_changed := (benutils.column_changed(l_old_pac.SEGMENT20

967: (l_changed));
968: end if;
969: --
970: if l_column = 'SEGMENT20' then
971: l_changed := (benutils.column_changed(l_old_pac.SEGMENT20
972: ,l_new_pac.SEGMENT20,l_new_val) AND
973: benutils.column_changed(l_new_pac.SEGMENT20
974: ,l_old_pac.SEGMENT20,l_old_val) AND
975: (l_changed));

Line 973: benutils.column_changed(l_new_pac.SEGMENT20

969: --
970: if l_column = 'SEGMENT20' then
971: l_changed := (benutils.column_changed(l_old_pac.SEGMENT20
972: ,l_new_pac.SEGMENT20,l_new_val) AND
973: benutils.column_changed(l_new_pac.SEGMENT20
974: ,l_old_pac.SEGMENT20,l_old_val) AND
975: (l_changed));
976: end if;
977: --

Line 979: l_changed := (benutils.column_changed(l_old_pac.SEGMENT21

975: (l_changed));
976: end if;
977: --
978: if l_column = 'SEGMENT21' then
979: l_changed := (benutils.column_changed(l_old_pac.SEGMENT21
980: ,l_new_pac.SEGMENT21,l_new_val) AND
981: benutils.column_changed(l_new_pac.SEGMENT21
982: ,l_old_pac.SEGMENT21,l_old_val) AND
983: (l_changed));

Line 981: benutils.column_changed(l_new_pac.SEGMENT21

977: --
978: if l_column = 'SEGMENT21' then
979: l_changed := (benutils.column_changed(l_old_pac.SEGMENT21
980: ,l_new_pac.SEGMENT21,l_new_val) AND
981: benutils.column_changed(l_new_pac.SEGMENT21
982: ,l_old_pac.SEGMENT21,l_old_val) AND
983: (l_changed));
984: end if;
985: --

Line 987: l_changed := (benutils.column_changed(l_old_pac.SEGMENT22

983: (l_changed));
984: end if;
985: --
986: if l_column = 'SEGMENT22' then
987: l_changed := (benutils.column_changed(l_old_pac.SEGMENT22
988: ,l_new_pac.SEGMENT22,l_new_val) AND
989: benutils.column_changed(l_new_pac.SEGMENT22
990: ,l_old_pac.SEGMENT22,l_old_val) AND
991: (l_changed));

Line 989: benutils.column_changed(l_new_pac.SEGMENT22

985: --
986: if l_column = 'SEGMENT22' then
987: l_changed := (benutils.column_changed(l_old_pac.SEGMENT22
988: ,l_new_pac.SEGMENT22,l_new_val) AND
989: benutils.column_changed(l_new_pac.SEGMENT22
990: ,l_old_pac.SEGMENT22,l_old_val) AND
991: (l_changed));
992: end if;
993: --

Line 995: l_changed := (benutils.column_changed(l_old_pac.SEGMENT23

991: (l_changed));
992: end if;
993: --
994: if l_column = 'SEGMENT23' then
995: l_changed := (benutils.column_changed(l_old_pac.SEGMENT23
996: ,l_new_pac.SEGMENT23,l_new_val) AND
997: benutils.column_changed(l_new_pac.SEGMENT23
998: ,l_old_pac.SEGMENT23,l_old_val) AND
999: (l_changed));

Line 997: benutils.column_changed(l_new_pac.SEGMENT23

993: --
994: if l_column = 'SEGMENT23' then
995: l_changed := (benutils.column_changed(l_old_pac.SEGMENT23
996: ,l_new_pac.SEGMENT23,l_new_val) AND
997: benutils.column_changed(l_new_pac.SEGMENT23
998: ,l_old_pac.SEGMENT23,l_old_val) AND
999: (l_changed));
1000: end if;
1001: --

Line 1003: l_changed := (benutils.column_changed(l_old_pac.SEGMENT24

999: (l_changed));
1000: end if;
1001: --
1002: if l_column = 'SEGMENT24' then
1003: l_changed := (benutils.column_changed(l_old_pac.SEGMENT24
1004: ,l_new_pac.SEGMENT24,l_new_val) AND
1005: benutils.column_changed(l_new_pac.SEGMENT24
1006: ,l_old_pac.SEGMENT24,l_old_val) AND
1007: (l_changed));

Line 1005: benutils.column_changed(l_new_pac.SEGMENT24

1001: --
1002: if l_column = 'SEGMENT24' then
1003: l_changed := (benutils.column_changed(l_old_pac.SEGMENT24
1004: ,l_new_pac.SEGMENT24,l_new_val) AND
1005: benutils.column_changed(l_new_pac.SEGMENT24
1006: ,l_old_pac.SEGMENT24,l_old_val) AND
1007: (l_changed));
1008: end if;
1009: --

Line 1011: l_changed := (benutils.column_changed(l_old_pac.SEGMENT25

1007: (l_changed));
1008: end if;
1009: --
1010: if l_column = 'SEGMENT25' then
1011: l_changed := (benutils.column_changed(l_old_pac.SEGMENT25
1012: ,l_new_pac.SEGMENT25,l_new_val) AND
1013: benutils.column_changed(l_new_pac.SEGMENT25
1014: ,l_old_pac.SEGMENT25,l_old_val) AND
1015: (l_changed));

Line 1013: benutils.column_changed(l_new_pac.SEGMENT25

1009: --
1010: if l_column = 'SEGMENT25' then
1011: l_changed := (benutils.column_changed(l_old_pac.SEGMENT25
1012: ,l_new_pac.SEGMENT25,l_new_val) AND
1013: benutils.column_changed(l_new_pac.SEGMENT25
1014: ,l_old_pac.SEGMENT25,l_old_val) AND
1015: (l_changed));
1016: end if;
1017: --

Line 1019: l_changed := (benutils.column_changed(l_old_pac.SEGMENT26

1015: (l_changed));
1016: end if;
1017: --
1018: if l_column = 'SEGMENT26' then
1019: l_changed := (benutils.column_changed(l_old_pac.SEGMENT26
1020: ,l_new_pac.SEGMENT26,l_new_val) AND
1021: benutils.column_changed(l_new_pac.SEGMENT26
1022: ,l_old_pac.SEGMENT26,l_old_val) AND
1023: (l_changed));

Line 1021: benutils.column_changed(l_new_pac.SEGMENT26

1017: --
1018: if l_column = 'SEGMENT26' then
1019: l_changed := (benutils.column_changed(l_old_pac.SEGMENT26
1020: ,l_new_pac.SEGMENT26,l_new_val) AND
1021: benutils.column_changed(l_new_pac.SEGMENT26
1022: ,l_old_pac.SEGMENT26,l_old_val) AND
1023: (l_changed));
1024: end if;
1025: --

Line 1027: l_changed := (benutils.column_changed(l_old_pac.SEGMENT27

1023: (l_changed));
1024: end if;
1025: --
1026: if l_column = 'SEGMENT27' then
1027: l_changed := (benutils.column_changed(l_old_pac.SEGMENT27
1028: ,l_new_pac.SEGMENT27,l_new_val) AND
1029: benutils.column_changed(l_new_pac.SEGMENT27
1030: ,l_old_pac.SEGMENT27,l_old_val) AND
1031: (l_changed));

Line 1029: benutils.column_changed(l_new_pac.SEGMENT27

1025: --
1026: if l_column = 'SEGMENT27' then
1027: l_changed := (benutils.column_changed(l_old_pac.SEGMENT27
1028: ,l_new_pac.SEGMENT27,l_new_val) AND
1029: benutils.column_changed(l_new_pac.SEGMENT27
1030: ,l_old_pac.SEGMENT27,l_old_val) AND
1031: (l_changed));
1032: end if;
1033: --

Line 1035: l_changed := (benutils.column_changed(l_old_pac.SEGMENT28

1031: (l_changed));
1032: end if;
1033: --
1034: if l_column = 'SEGMENT28' then
1035: l_changed := (benutils.column_changed(l_old_pac.SEGMENT28
1036: ,l_new_pac.SEGMENT28,l_new_val) AND
1037: benutils.column_changed(l_new_pac.SEGMENT28
1038: ,l_old_pac.SEGMENT28,l_old_val) AND
1039: (l_changed));

Line 1037: benutils.column_changed(l_new_pac.SEGMENT28

1033: --
1034: if l_column = 'SEGMENT28' then
1035: l_changed := (benutils.column_changed(l_old_pac.SEGMENT28
1036: ,l_new_pac.SEGMENT28,l_new_val) AND
1037: benutils.column_changed(l_new_pac.SEGMENT28
1038: ,l_old_pac.SEGMENT28,l_old_val) AND
1039: (l_changed));
1040: end if;
1041: --

Line 1043: l_changed := (benutils.column_changed(l_old_pac.SEGMENT29

1039: (l_changed));
1040: end if;
1041: --
1042: if l_column = 'SEGMENT29' then
1043: l_changed := (benutils.column_changed(l_old_pac.SEGMENT29
1044: ,l_new_pac.SEGMENT29,l_new_val) AND
1045: benutils.column_changed(l_new_pac.SEGMENT29
1046: ,l_old_pac.SEGMENT29,l_old_val) AND
1047: (l_changed));

Line 1045: benutils.column_changed(l_new_pac.SEGMENT29

1041: --
1042: if l_column = 'SEGMENT29' then
1043: l_changed := (benutils.column_changed(l_old_pac.SEGMENT29
1044: ,l_new_pac.SEGMENT29,l_new_val) AND
1045: benutils.column_changed(l_new_pac.SEGMENT29
1046: ,l_old_pac.SEGMENT29,l_old_val) AND
1047: (l_changed));
1048: end if;
1049: --

Line 1051: l_changed := (benutils.column_changed(l_old_pac.SEGMENT30

1047: (l_changed));
1048: end if;
1049: --
1050: if l_column = 'SEGMENT30' then
1051: l_changed := (benutils.column_changed(l_old_pac.SEGMENT30
1052: ,l_new_pac.SEGMENT30,l_new_val) AND
1053: benutils.column_changed(l_new_pac.SEGMENT30
1054: ,l_old_pac.SEGMENT30,l_old_val) AND
1055: (l_changed));

Line 1053: benutils.column_changed(l_new_pac.SEGMENT30

1049: --
1050: if l_column = 'SEGMENT30' then
1051: l_changed := (benutils.column_changed(l_old_pac.SEGMENT30
1052: ,l_new_pac.SEGMENT30,l_new_val) AND
1053: benutils.column_changed(l_new_pac.SEGMENT30
1054: ,l_old_pac.SEGMENT30,l_old_val) AND
1055: (l_changed));
1056: end if;
1057: