52: RETURN(value1 BETWEEN value2 AND value3);
53: ELSIF operator = 10 THEN
54: RETURN(value1 < value2 OR value1 > value3);
55: ELSE
56: APP_EXCEPTION.INVALID_ARGUMENT('q_res.compare',
57: 'operator', TO_CHAR(operator));
58: END IF;
59: END compare;
60:
86: RETURN(value1 BETWEEN value2 AND value3);
87: ELSIF operator = 10 THEN
88: RETURN(value1 < value2 OR value1 > value3);
89: ELSE
90: APP_EXCEPTION.INVALID_ARGUMENT('q_res.compare',
91: 'operator', TO_CHAR(operator));
92: END IF;
93: END compare;
94:
120: RETURN(value1 BETWEEN value2 AND value3);
121: ELSIF operator = 10 THEN
122: RETURN(value1 < value2 OR value1 > value3);
123: ELSE
124: APP_EXCEPTION.INVALID_ARGUMENT('q_res.compare',
125: 'operator', TO_CHAR(operator));
126: END IF;
127: END compare;
128:
157: RETURN(value1 BETWEEN value2 AND value3);
158: ELSIF operator = 10 THEN
159: RETURN(value1 < value2 OR value1 > value3);
160: ELSE
161: APP_EXCEPTION.INVALID_ARGUMENT('q_res.compare',
162: 'operator', TO_CHAR(operator));
163: END IF;
164: RETURN NULL;
165: END compare_seq;