APPS.QLTCOMPB dependencies on QLTDATE

Line 184: RETURN(compare(qltdate.canon_to_number(value1),operator,

180: -- ||''' '||value2||' and '||value3||' ('||to_char(datatype)||')');
181: IF datatype = 1 THEN -- character
182: RETURN(compare(value1,operator,value2,value3));
183: ELSIF datatype = 2 THEN -- number
184: RETURN(compare(qltdate.canon_to_number(value1),operator,
185: qltdate.canon_to_number(value2),
186: qltdate.canon_to_number(value3)));
187: ELSIF datatype = 3 THEN -- date
188: RETURN(compare(qltdate.any_to_date(value1),operator,

Line 185: qltdate.canon_to_number(value2),

181: IF datatype = 1 THEN -- character
182: RETURN(compare(value1,operator,value2,value3));
183: ELSIF datatype = 2 THEN -- number
184: RETURN(compare(qltdate.canon_to_number(value1),operator,
185: qltdate.canon_to_number(value2),
186: qltdate.canon_to_number(value3)));
187: ELSIF datatype = 3 THEN -- date
188: RETURN(compare(qltdate.any_to_date(value1),operator,
189: qltdate.any_to_date(value2),

Line 186: qltdate.canon_to_number(value3)));

182: RETURN(compare(value1,operator,value2,value3));
183: ELSIF datatype = 2 THEN -- number
184: RETURN(compare(qltdate.canon_to_number(value1),operator,
185: qltdate.canon_to_number(value2),
186: qltdate.canon_to_number(value3)));
187: ELSIF datatype = 3 THEN -- date
188: RETURN(compare(qltdate.any_to_date(value1),operator,
189: qltdate.any_to_date(value2),
190: qltdate.any_to_date(value3)));

Line 188: RETURN(compare(qltdate.any_to_date(value1),operator,

184: RETURN(compare(qltdate.canon_to_number(value1),operator,
185: qltdate.canon_to_number(value2),
186: qltdate.canon_to_number(value3)));
187: ELSIF datatype = 3 THEN -- date
188: RETURN(compare(qltdate.any_to_date(value1),operator,
189: qltdate.any_to_date(value2),
190: qltdate.any_to_date(value3)));
191:
192: -- Bug2336153. Added the below code to support Sequence Datatype.

Line 189: qltdate.any_to_date(value2),

185: qltdate.canon_to_number(value2),
186: qltdate.canon_to_number(value3)));
187: ELSIF datatype = 3 THEN -- date
188: RETURN(compare(qltdate.any_to_date(value1),operator,
189: qltdate.any_to_date(value2),
190: qltdate.any_to_date(value3)));
191:
192: -- Bug2336153. Added the below code to support Sequence Datatype.
193:

Line 190: qltdate.any_to_date(value3)));

186: qltdate.canon_to_number(value3)));
187: ELSIF datatype = 3 THEN -- date
188: RETURN(compare(qltdate.any_to_date(value1),operator,
189: qltdate.any_to_date(value2),
190: qltdate.any_to_date(value3)));
191:
192: -- Bug2336153. Added the below code to support Sequence Datatype.
193:
194: ELSIF datatype = 5 THEN

Line 201: RETURN(compare(qltdate.any_to_datetime(value1),operator,

197: -- Bug 3179845. Timezone Project. rponnusa
198: -- added datetime datatype
199:
200: ELSIF datatype = 6 THEN -- datetime
201: RETURN(compare(qltdate.any_to_datetime(value1),operator,
202: qltdate.any_to_datetime(value2),
203: qltdate.any_to_datetime(value3)));
204:
205:

Line 202: qltdate.any_to_datetime(value2),

198: -- added datetime datatype
199:
200: ELSIF datatype = 6 THEN -- datetime
201: RETURN(compare(qltdate.any_to_datetime(value1),operator,
202: qltdate.any_to_datetime(value2),
203: qltdate.any_to_datetime(value3)));
204:
205:
206: END IF;

Line 203: qltdate.any_to_datetime(value3)));

199:
200: ELSIF datatype = 6 THEN -- datetime
201: RETURN(compare(qltdate.any_to_datetime(value1),operator,
202: qltdate.any_to_datetime(value2),
203: qltdate.any_to_datetime(value3)));
204:
205:
206: END IF;
207: END; -- compare