[Home] [Help]
1: Package body ecx_Conditions as
2: -- $Header: ECXCONDB.pls 120.3 2006/05/24 16:07:11 susaha ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
17: valtype in pls_integer
18: ) return boolean
19: is
20:
21: i_method_name varchar2(2000) := 'ecx_conditions.check_type_condition';
22: i_rnum number;
23: i_lnum number;
24: i_rdate date;
25: i_ldate date;
575: ) return boolean
576: is
577:
578:
579: i_method_name varchar2(2000) := 'ecx_conditions.check_condition';
580:
581: i_condition boolean :=false;
582: i_condition1 boolean :=false;
583: i_condition2 boolean :=false;
705: )
706: return number
707: is
708:
709: i_method_name varchar2(2000) := 'ecx_conditions.math_functions';
710:
711: divide_by_zero exception;
712: pragma exception_init(divide_by_zero,-1476);
713: begin
806: )
807: is
808:
809:
810: i_method_name varchar2(2000) := 'ecx_conditions.getLengthForString';
811:
812: begin
813: if (l_procedureEnabled) then
814: ecx_debug.push(i_method_name);
844: i_occurrence in pls_integer,
845: i_position OUT NOCOPY pls_integer
846: )
847: is
848: i_method_name varchar2(2000) := 'ecx_conditions.getPositionInString';
849: begin
850: if (l_procedureEnabled) then
851: ecx_debug.push(i_method_name);
852: end if;
879: i_length in pls_integer,
880: i_substr OUT NOCOPY varchar2
881: )
882: is
883: i_method_name varchar2(2000) := 'ecx_conditions.getSubString';
884: begin
885: if (l_procedureEnabled) then
886: ecx_debug.push(i_method_name);
887: end if;
907: end getSubString;
908:
909: procedure test
910: is
911: i_method_name varchar2(2000) := 'ecx_conditions.test';
912: i number;
913: y boolean;
914: i_date1 varchar2(200) := '20010101';
915: i_date2 varchar2(200) := '20010102';
926: if(l_statementEnabled) then
927: ecx_debug.log(l_statement,'testing conditions ',i_method_name);
928: ecx_debug.log(l_statement,'String conditions ',i_method_name);
929: end if;
930: y := ecx_conditions.check_condition(null,'0','veshaal',1,'veshaal',1,null,null,1,null,1);
931: if(l_statementEnabled) then
932: ecx_debug.log(l_statement,'y',y,i_method_name);
933: end if;
934: y := ecx_conditions.check_condition(null,'1','veshaal',1,'1veshaal',1,null,null,1,null,1);
930: y := ecx_conditions.check_condition(null,'0','veshaal',1,'veshaal',1,null,null,1,null,1);
931: if(l_statementEnabled) then
932: ecx_debug.log(l_statement,'y',y,i_method_name);
933: end if;
934: y := ecx_conditions.check_condition(null,'1','veshaal',1,'1veshaal',1,null,null,1,null,1);
935: if(l_statementEnabled) then
936: ecx_debug.log(l_statement,'y',y,i_method_name);
937: end if;
938: y := ecx_conditions.check_condition(null,'6','3',1,'4',1,null,null,1,null,1);
934: y := ecx_conditions.check_condition(null,'1','veshaal',1,'1veshaal',1,null,null,1,null,1);
935: if(l_statementEnabled) then
936: ecx_debug.log(l_statement,'y',y,i_method_name);
937: end if;
938: y := ecx_conditions.check_condition(null,'6','3',1,'4',1,null,null,1,null,1);
939: if(l_statementEnabled) then
940: ecx_debug.log(l_statement,'y',y,i_method_name);
941: end if;
942: y := ecx_conditions.check_condition(null,'7','3',1,'4',1,null,null,1,null,1);
938: y := ecx_conditions.check_condition(null,'6','3',1,'4',1,null,null,1,null,1);
939: if(l_statementEnabled) then
940: ecx_debug.log(l_statement,'y',y,i_method_name);
941: end if;
942: y := ecx_conditions.check_condition(null,'7','3',1,'4',1,null,null,1,null,1);
943: if(l_statementEnabled) then
944: ecx_debug.log(l_statement,'y',y,i_method_name);
945: end if;
946:
946:
947: if(l_statementEnabled) then
948: ecx_debug.log(l_statement,'Number conditions ',i_method_name);
949: end if;
950: y := ecx_conditions.check_condition(null,'0','-10.555',2,'-10.555',2,null,null,2,null,2);
951: if(l_statementEnabled) then
952: ecx_debug.log(l_statement,'y',y,i_method_name);
953: end if;
954: y := ecx_conditions.check_condition(null,'1','-10.555',2,'-10.555',2,null,null,2,null,2);
950: y := ecx_conditions.check_condition(null,'0','-10.555',2,'-10.555',2,null,null,2,null,2);
951: if(l_statementEnabled) then
952: ecx_debug.log(l_statement,'y',y,i_method_name);
953: end if;
954: y := ecx_conditions.check_condition(null,'1','-10.555',2,'-10.555',2,null,null,2,null,2);
955: if(l_statementEnabled) then
956: ecx_debug.log(l_statement,'y',y,i_method_name);
957: end if;
958: y := ecx_conditions.check_condition(null,'2','-10.555',2,'-10.555',2,null,null,2,null,2);
954: y := ecx_conditions.check_condition(null,'1','-10.555',2,'-10.555',2,null,null,2,null,2);
955: if(l_statementEnabled) then
956: ecx_debug.log(l_statement,'y',y,i_method_name);
957: end if;
958: y := ecx_conditions.check_condition(null,'2','-10.555',2,'-10.555',2,null,null,2,null,2);
959: if(l_statementEnabled) then
960: ecx_debug.log(l_statement,'y',y,i_method_name);
961: end if;
962: y := ecx_conditions.check_condition(null,'3','-.002',2,'-.001',2,null,null,2,null,2);
958: y := ecx_conditions.check_condition(null,'2','-10.555',2,'-10.555',2,null,null,2,null,2);
959: if(l_statementEnabled) then
960: ecx_debug.log(l_statement,'y',y,i_method_name);
961: end if;
962: y := ecx_conditions.check_condition(null,'3','-.002',2,'-.001',2,null,null,2,null,2);
963: if(l_statementEnabled) then
964: ecx_debug.log(l_statement,'y',y,i_method_name);
965: end if;
966: y := ecx_conditions.check_condition(null,'4','-100',2,'-120',2,null,null,2,null,2);
962: y := ecx_conditions.check_condition(null,'3','-.002',2,'-.001',2,null,null,2,null,2);
963: if(l_statementEnabled) then
964: ecx_debug.log(l_statement,'y',y,i_method_name);
965: end if;
966: y := ecx_conditions.check_condition(null,'4','-100',2,'-120',2,null,null,2,null,2);
967: if(l_statementEnabled) then
968: ecx_debug.log(l_statement,'y',y,i_method_name);
969: end if;
970: y := ecx_conditions.check_condition(null,'5','-100',2,'-110.5',2,null,null,2,null,2);
966: y := ecx_conditions.check_condition(null,'4','-100',2,'-120',2,null,null,2,null,2);
967: if(l_statementEnabled) then
968: ecx_debug.log(l_statement,'y',y,i_method_name);
969: end if;
970: y := ecx_conditions.check_condition(null,'5','-100',2,'-110.5',2,null,null,2,null,2);
971: if(l_statementEnabled) then
972: ecx_debug.log(l_statement,'y',y,i_method_name);
973: end if;
974: y := ecx_conditions.check_condition(null,'6','3',2,'4',2,null,null,2,null,2);
970: y := ecx_conditions.check_condition(null,'5','-100',2,'-110.5',2,null,null,2,null,2);
971: if(l_statementEnabled) then
972: ecx_debug.log(l_statement,'y',y,i_method_name);
973: end if;
974: y := ecx_conditions.check_condition(null,'6','3',2,'4',2,null,null,2,null,2);
975: if(l_statementEnabled) then
976: ecx_debug.log(l_statement,'y',y,i_method_name);
977: end if;
978: y := ecx_conditions.check_condition(null,'7','3',2,'4',2,null,null,2,null,2);
974: y := ecx_conditions.check_condition(null,'6','3',2,'4',2,null,null,2,null,2);
975: if(l_statementEnabled) then
976: ecx_debug.log(l_statement,'y',y,i_method_name);
977: end if;
978: y := ecx_conditions.check_condition(null,'7','3',2,'4',2,null,null,2,null,2);
979: if(l_statementEnabled) then
980: ecx_debug.log(l_statement,'y',y,i_method_name);
981: end if;
982:
982:
983: if(l_statementEnabled) then
984: ecx_debug.log(l_statement,'Date conditions ',i_method_name);
985: end if;
986: y := ecx_conditions.check_condition(null,'0',i_date1,12,i_date2,12,null,null,12,null,12);
987: if(l_statementEnabled) then
988: ecx_debug.log(l_statement,'y',y,i_method_name);
989: end if;
990: y := ecx_conditions.check_condition(null,'1',i_date1,12,i_date2,12,null,null,12,null,12);
986: y := ecx_conditions.check_condition(null,'0',i_date1,12,i_date2,12,null,null,12,null,12);
987: if(l_statementEnabled) then
988: ecx_debug.log(l_statement,'y',y,i_method_name);
989: end if;
990: y := ecx_conditions.check_condition(null,'1',i_date1,12,i_date2,12,null,null,12,null,12);
991: if(l_statementEnabled) then
992: ecx_debug.log(l_statement,'y',y,i_method_name);
993: end if;
994: y := ecx_conditions.check_condition(null,'2',i_date1,12,i_date2,12,null,null,12,null,12);
990: y := ecx_conditions.check_condition(null,'1',i_date1,12,i_date2,12,null,null,12,null,12);
991: if(l_statementEnabled) then
992: ecx_debug.log(l_statement,'y',y,i_method_name);
993: end if;
994: y := ecx_conditions.check_condition(null,'2',i_date1,12,i_date2,12,null,null,12,null,12);
995: if(l_statementEnabled) then
996: ecx_debug.log(l_statement,'y',y,i_method_name);
997: end if;
998: y := ecx_conditions.check_condition(null,'3',i_date1,12,i_date2,12,null,null,12,null,12);
994: y := ecx_conditions.check_condition(null,'2',i_date1,12,i_date2,12,null,null,12,null,12);
995: if(l_statementEnabled) then
996: ecx_debug.log(l_statement,'y',y,i_method_name);
997: end if;
998: y := ecx_conditions.check_condition(null,'3',i_date1,12,i_date2,12,null,null,12,null,12);
999: if(l_statementEnabled) then
1000: ecx_debug.log(l_statement,'y',y,i_method_name);
1001: end if;
1002: y := ecx_conditions.check_condition(null,'4',i_date1,12,i_date2,12,null,null,12,null,12);
998: y := ecx_conditions.check_condition(null,'3',i_date1,12,i_date2,12,null,null,12,null,12);
999: if(l_statementEnabled) then
1000: ecx_debug.log(l_statement,'y',y,i_method_name);
1001: end if;
1002: y := ecx_conditions.check_condition(null,'4',i_date1,12,i_date2,12,null,null,12,null,12);
1003: if(l_statementEnabled) then
1004: ecx_debug.log(l_statement,'y',y,i_method_name);
1005: end if;
1006: y := ecx_conditions.check_condition(null,'5',i_date1,12,i_date2,12,null,null,12,null,12);
1002: y := ecx_conditions.check_condition(null,'4',i_date1,12,i_date2,12,null,null,12,null,12);
1003: if(l_statementEnabled) then
1004: ecx_debug.log(l_statement,'y',y,i_method_name);
1005: end if;
1006: y := ecx_conditions.check_condition(null,'5',i_date1,12,i_date2,12,null,null,12,null,12);
1007: if(l_statementEnabled) then
1008: ecx_debug.log(l_statement,'y',y,i_method_name);
1009: end if;
1010: y := ecx_conditions.check_condition(null,'6',i_date1,12,i_date2,12,null,null,12,null,12);
1006: y := ecx_conditions.check_condition(null,'5',i_date1,12,i_date2,12,null,null,12,null,12);
1007: if(l_statementEnabled) then
1008: ecx_debug.log(l_statement,'y',y,i_method_name);
1009: end if;
1010: y := ecx_conditions.check_condition(null,'6',i_date1,12,i_date2,12,null,null,12,null,12);
1011: if(l_statementEnabled) then
1012: ecx_debug.log(l_statement,'y',y,i_method_name);
1013: end if;
1014: y := ecx_conditions.check_condition(null,'7',i_date1,12,i_date2,12,null,null,12,null,12);
1010: y := ecx_conditions.check_condition(null,'6',i_date1,12,i_date2,12,null,null,12,null,12);
1011: if(l_statementEnabled) then
1012: ecx_debug.log(l_statement,'y',y,i_method_name);
1013: end if;
1014: y := ecx_conditions.check_condition(null,'7',i_date1,12,i_date2,12,null,null,12,null,12);
1015: if(l_statementEnabled) then
1016: ecx_debug.log(l_statement,'y',y,i_method_name);
1017: end if;
1018:
1018:
1019: if(l_statementEnabled) then
1020: ecx_debug.log(l_statement,'testing length procedure',i_method_name);
1021: end if;
1022: ecx_conditions.getlengthforString('htihgoitrhogirtoigtroighoirhgoitirgoitrh',i);
1023: if(l_statementEnabled) then
1024: ecx_debug.log(l_statement,'i',i,i_method_name);
1025: end if;
1026:
1023: if(l_statementEnabled) then
1024: ecx_debug.log(l_statement,'i',i,i_method_name);
1025: end if;
1026:
1027: ecx_conditions.getlengthforString(null,i);
1028: if(l_statementEnabled) then
1029: ecx_debug.log(l_statement,'i',i,i_method_name);
1030: end if;
1031:
1031:
1032: if(l_statementEnabled) then
1033: ecx_debug.log(l_statement,'testing instrb procedure',i_method_name);
1034: end if;
1035: ecx_conditions.getpositioninString('htihgoitrhogirtoigtroighoirhgoitirgoitrh','hg',1,1,i);
1036: if(l_statementEnabled) then
1037: ecx_debug.log(l_statement,'i',i,i_method_name);
1038: end if;
1039: ecx_conditions.getpositioninString('htihgoitrhogirtoigtroighoirhgoitirgoitrh','hg',1,2,i);
1035: ecx_conditions.getpositioninString('htihgoitrhogirtoigtroighoirhgoitirgoitrh','hg',1,1,i);
1036: if(l_statementEnabled) then
1037: ecx_debug.log(l_statement,'i',i,i_method_name);
1038: end if;
1039: ecx_conditions.getpositioninString('htihgoitrhogirtoigtroighoirhgoitirgoitrh','hg',1,2,i);
1040: if(l_statementEnabled) then
1041: ecx_debug.log(l_statement,'i',i,i_method_name);
1042: end if;
1043: ecx_conditions.getpositioninString('htihgoitrhogirtoigtroighoirhgoitirgoitrh',null,1,2,i);
1039: ecx_conditions.getpositioninString('htihgoitrhogirtoigtroighoirhgoitirgoitrh','hg',1,2,i);
1040: if(l_statementEnabled) then
1041: ecx_debug.log(l_statement,'i',i,i_method_name);
1042: end if;
1043: ecx_conditions.getpositioninString('htihgoitrhogirtoigtroighoirhgoitirgoitrh',null,1,2,i);
1044: if(l_statementEnabled) then
1045: ecx_debug.log(l_statement,'i',i,i_method_name);
1046: end if;
1047:
1047:
1048: if(l_statementEnabled) then
1049: ecx_debug.log(l_statement,'testing substrb procedure',i_method_name);
1050: end if;
1051: ecx_conditions.getsubstring('htihgoitrhogirtoigtroighoirhgoitirgoitrh',1,20,i_date1);
1052: if(l_statementEnabled) then
1053: ecx_debug.log(l_statement,'i_date1',i_date1,i_method_name);
1054: end if;
1055: ecx_conditions.getsubstring('htihgoitrhogirtoigtroighoirhgoitirgoitrh',1,null,i_date1);
1051: ecx_conditions.getsubstring('htihgoitrhogirtoigtroighoirhgoitirgoitrh',1,20,i_date1);
1052: if(l_statementEnabled) then
1053: ecx_debug.log(l_statement,'i_date1',i_date1,i_method_name);
1054: end if;
1055: ecx_conditions.getsubstring('htihgoitrhogirtoigtroighoirhgoitirgoitrh',1,null,i_date1);
1056: if(l_statementEnabled) then
1057: ecx_debug.log(l_statement,'i_date1',i_date1,i_method_name);
1058: end if;
1059: ecx_conditions.getsubstring('htihgoitrhogirtoigtroighoirhgoitirgoitrh',null,null,i_date1);
1055: ecx_conditions.getsubstring('htihgoitrhogirtoigtroighoirhgoitirgoitrh',1,null,i_date1);
1056: if(l_statementEnabled) then
1057: ecx_debug.log(l_statement,'i_date1',i_date1,i_method_name);
1058: end if;
1059: ecx_conditions.getsubstring('htihgoitrhogirtoigtroighoirhgoitirgoitrh',null,null,i_date1);
1060: if(l_statementEnabled) then
1061: ecx_debug.log(l_statement,'i_date1',i_date1,i_method_name);
1062: end if;
1063:
1063:
1064: if(l_statementEnabled) then
1065: ecx_debug.log(l_statement,'testing math functions',i_method_name);
1066: end if;
1067: i := ecx_conditions.math_functions('+',1,null);
1068: if(l_statementEnabled) then
1069: ecx_debug.log(l_statement,'i',i,i_method_name);
1070: end if;
1071: i := ecx_conditions.math_functions('-',1,2);
1067: i := ecx_conditions.math_functions('+',1,null);
1068: if(l_statementEnabled) then
1069: ecx_debug.log(l_statement,'i',i,i_method_name);
1070: end if;
1071: i := ecx_conditions.math_functions('-',1,2);
1072: if(l_statementEnabled) then
1073: ecx_debug.log(l_statement,'i',i,i_method_name);
1074: end if;
1075: i := ecx_conditions.math_functions('*',1,2);
1071: i := ecx_conditions.math_functions('-',1,2);
1072: if(l_statementEnabled) then
1073: ecx_debug.log(l_statement,'i',i,i_method_name);
1074: end if;
1075: i := ecx_conditions.math_functions('*',1,2);
1076: if(l_statementEnabled) then
1077: ecx_debug.log(l_statement,'i',i,i_method_name);
1078: end if;
1079: i := ecx_conditions.math_functions('/',1,0);
1075: i := ecx_conditions.math_functions('*',1,2);
1076: if(l_statementEnabled) then
1077: ecx_debug.log(l_statement,'i',i,i_method_name);
1078: end if;
1079: i := ecx_conditions.math_functions('/',1,0);
1080: if(l_statementEnabled) then
1081: ecx_debug.log(l_statement,'i',i,i_method_name);
1082: end if;
1083: i := ecx_conditions.math_functions('6',1,2);
1079: i := ecx_conditions.math_functions('/',1,0);
1080: if(l_statementEnabled) then
1081: ecx_debug.log(l_statement,'i',i,i_method_name);
1082: end if;
1083: i := ecx_conditions.math_functions('6',1,2);
1084: if(l_statementEnabled) then
1085: ecx_debug.log(l_statement,'i',i,i_method_name);
1086: end if;
1087:
1096: ecx_debug.print_log;
1097: ecx_debug.disable_debug;
1098: end test;
1099:
1100: end ecx_conditions;