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.QLTTRAWB dependencies on QLTDATE

Line 250: qa_core_pkg.dsql_add_text(' qltdate.any_to_number(QRI.' || COL_NAME || ') ');

246: ' AND ');
247:
248:
249: IF x_datatype = 2 THEN
250: qa_core_pkg.dsql_add_text(' qltdate.any_to_number(QRI.' || COL_NAME || ') ');
251:
252: ELSIF x_datatype = 3 THEN
253: qa_core_pkg.dsql_add_text(' qltdate.any_to_date(QRI.' || COL_NAME || ') ');
254:

Line 253: qa_core_pkg.dsql_add_text(' qltdate.any_to_date(QRI.' || COL_NAME || ') ');

249: IF x_datatype = 2 THEN
250: qa_core_pkg.dsql_add_text(' qltdate.any_to_number(QRI.' || COL_NAME || ') ');
251:
252: ELSIF x_datatype = 3 THEN
253: qa_core_pkg.dsql_add_text(' qltdate.any_to_date(QRI.' || COL_NAME || ') ');
254:
255: ELSIF x_datatype = 6 THEN
256: qa_core_pkg.dsql_add_text(' qltdate.any_to_datetime(QRI.' || COL_NAME || ') ');
257:

Line 256: qa_core_pkg.dsql_add_text(' qltdate.any_to_datetime(QRI.' || COL_NAME || ') ');

252: ELSIF x_datatype = 3 THEN
253: qa_core_pkg.dsql_add_text(' qltdate.any_to_date(QRI.' || COL_NAME || ') ');
254:
255: ELSIF x_datatype = 6 THEN
256: qa_core_pkg.dsql_add_text(' qltdate.any_to_datetime(QRI.' || COL_NAME || ') ');
257:
258: ELSE
259: qa_core_pkg.dsql_add_text(' QRI.' || COL_NAME || ' ');
260: END IF;

Line 276: LV1 := 'qltdate.canon_to_number(' || LV1 || ')';

272: LV1 := 'QC.' || TEMP;
273: LV2 := 'QSC.' || TEMP;
274:
275: IF (X_DATATYPE = 2) THEN
276: LV1 := 'qltdate.canon_to_number(' || LV1 || ')';
277: LV2 := 'qltdate.canon_to_number(' || LV2 || ')';
278:
279: ELSIF (X_DATATYPE IN (3, 6)) THEN
280: LV1 := 'qltdate.canon_to_date(' || LV1 || ')';

Line 277: LV2 := 'qltdate.canon_to_number(' || LV2 || ')';

273: LV2 := 'QSC.' || TEMP;
274:
275: IF (X_DATATYPE = 2) THEN
276: LV1 := 'qltdate.canon_to_number(' || LV1 || ')';
277: LV2 := 'qltdate.canon_to_number(' || LV2 || ')';
278:
279: ELSIF (X_DATATYPE IN (3, 6)) THEN
280: LV1 := 'qltdate.canon_to_date(' || LV1 || ')';
281: LV2 := 'qltdate.canon_to_date(' || LV2 || ')';

Line 280: LV1 := 'qltdate.canon_to_date(' || LV1 || ')';

276: LV1 := 'qltdate.canon_to_number(' || LV1 || ')';
277: LV2 := 'qltdate.canon_to_number(' || LV2 || ')';
278:
279: ELSIF (X_DATATYPE IN (3, 6)) THEN
280: LV1 := 'qltdate.canon_to_date(' || LV1 || ')';
281: LV2 := 'qltdate.canon_to_date(' || LV2 || ')';
282:
283: END IF;
284:

Line 281: LV2 := 'qltdate.canon_to_date(' || LV2 || ')';

277: LV2 := 'qltdate.canon_to_number(' || LV2 || ')';
278:
279: ELSIF (X_DATATYPE IN (3, 6)) THEN
280: LV1 := 'qltdate.canon_to_date(' || LV1 || ')';
281: LV2 := 'qltdate.canon_to_date(' || LV2 || ')';
282:
283: END IF;
284:
285: qa_core_pkg.dsql_add_text(' ' || OP || ' DECODE(QSC.CHAR_ID, NULL, ' ||

Line 294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));

290:
291: qa_core_pkg.dsql_add_text(' ' || OP || ' DECODE(QSC.CHAR_ID, NULL, ');
292:
293: IF (X_DATATYPE = 2) THEN
294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
295: qa_core_pkg.dsql_add_text(' ,');
296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
297: qa_core_pkg.dsql_add_text(' )');
298:

Line 296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));

292:
293: IF (X_DATATYPE = 2) THEN
294: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
295: qa_core_pkg.dsql_add_text(' ,');
296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
297: qa_core_pkg.dsql_add_text(' )');
298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));

Line 300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));

296: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_LV_OTHER_VALUE));
297: qa_core_pkg.dsql_add_text(' )');
298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
301: qa_core_pkg.dsql_add_text(' ,');
302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
303: qa_core_pkg.dsql_add_text(' )');
304:

Line 302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));

298:
299: ELSIF (X_DATATYPE IN (3, 6)) THEN
300: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
301: qa_core_pkg.dsql_add_text(' ,');
302: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_LV_OTHER_VALUE));
303: qa_core_pkg.dsql_add_text(' )');
304:
305: ELSE
306: qa_core_pkg.dsql_add_bind(X_LV_OTHER_VALUE);

Line 326: HV1 := 'qltdate.canon_to_number(' || HV1 || ')';

322: HV1 := 'QC.' || TEMP;
323: HV2 := 'QSC.' || TEMP;
324:
325: IF (X_DATATYPE = 2) THEN
326: HV1 := 'qltdate.canon_to_number(' || HV1 || ')';
327: HV2 := 'qltdate.canon_to_number(' || HV2 || ')';
328:
329: ELSIF (X_DATATYPE IN (3, 6)) THEN
330: HV1 := 'qltdate.canon_to_date(' || HV1 || ')';

Line 327: HV2 := 'qltdate.canon_to_number(' || HV2 || ')';

323: HV2 := 'QSC.' || TEMP;
324:
325: IF (X_DATATYPE = 2) THEN
326: HV1 := 'qltdate.canon_to_number(' || HV1 || ')';
327: HV2 := 'qltdate.canon_to_number(' || HV2 || ')';
328:
329: ELSIF (X_DATATYPE IN (3, 6)) THEN
330: HV1 := 'qltdate.canon_to_date(' || HV1 || ')';
331: HV2 := 'qltdate.canon_to_date(' || HV2 || ')';

Line 330: HV1 := 'qltdate.canon_to_date(' || HV1 || ')';

326: HV1 := 'qltdate.canon_to_number(' || HV1 || ')';
327: HV2 := 'qltdate.canon_to_number(' || HV2 || ')';
328:
329: ELSIF (X_DATATYPE IN (3, 6)) THEN
330: HV1 := 'qltdate.canon_to_date(' || HV1 || ')';
331: HV2 := 'qltdate.canon_to_date(' || HV2 || ')';
332:
333: END IF;
334:

Line 331: HV2 := 'qltdate.canon_to_date(' || HV2 || ')';

327: HV2 := 'qltdate.canon_to_number(' || HV2 || ')';
328:
329: ELSIF (X_DATATYPE IN (3, 6)) THEN
330: HV1 := 'qltdate.canon_to_date(' || HV1 || ')';
331: HV2 := 'qltdate.canon_to_date(' || HV2 || ')';
332:
333: END IF;
334:
335: qa_core_pkg.dsql_add_text(' AND ' || ' DECODE(QSC.CHAR_ID, NULL, ' ||

Line 344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));

340:
341: qa_core_pkg.dsql_add_text(' AND ' || ' DECODE(QSC.CHAR_ID, NULL, ');
342:
343: IF (X_DATATYPE = 2) THEN
344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
345: qa_core_pkg.dsql_add_text(' ,');
346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
347: qa_core_pkg.dsql_add_text(' )');
348:

Line 346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));

342:
343: IF (X_DATATYPE = 2) THEN
344: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
345: qa_core_pkg.dsql_add_text(' ,');
346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
347: qa_core_pkg.dsql_add_text(' )');
348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));

Line 350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));

346: qa_core_pkg.dsql_add_bind(qltdate.canon_to_number(X_HV_OTHER_VALUE));
347: qa_core_pkg.dsql_add_text(' )');
348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
351: qa_core_pkg.dsql_add_text(' ,');
352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
353: qa_core_pkg.dsql_add_text(' )');
354:

Line 352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));

348:
349: ELSIF (X_DATATYPE IN (3, 6)) THEN
350: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
351: qa_core_pkg.dsql_add_text(' ,');
352: qa_core_pkg.dsql_add_bind(qltdate.canon_to_date(X_HV_OTHER_VALUE));
353: qa_core_pkg.dsql_add_text(' )');
354:
355: ELSE
356: qa_core_pkg.dsql_add_bind(X_HV_OTHER_VALUE);

Line 1376: 'qltdate.number_to_canon(round(qltdate.any_to_number(' ||

1372: -- If it is not hardcoded, then convert number to a Number first.
1373: -- Then convert it back to canonical format.
1374: --
1375: SQL_STATEMENT := SQL_STATEMENT ||
1376: 'qltdate.number_to_canon(round(qltdate.any_to_number(' ||
1377: COL_NAME || '), ' || to_char(nvl(X_DECIMAL_PRECISION, 240)) ||
1378: ')) ';
1379: END IF;
1380:

Line 1386: 'qltdate.any_to_canon(' || COL_NAME || ') ';

1382: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
1383:
1384: ELSIF (X_DATATYPE IN (3,6)) THEN
1385: SQL_STATEMENT := SQL_STATEMENT ||
1386: 'qltdate.any_to_canon(' || COL_NAME || ') ';
1387: END IF;
1388:
1389: SQL_STATEMENT := SQL_STATEMENT ||
1390: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||

Line 3460: sql_statement := sql_statement || '(qltdate.any_to_number(QRI.' ||

3456: 'QSC.LOWER_REASONABLE_LIMIT) IS NULL) ' ||
3457: 'OR ';
3458:
3459: IF X_DATATYPE = 2 THEN
3460: sql_statement := sql_statement || '(qltdate.any_to_number(QRI.' ||
3461: COL_NAME || ') >= ';
3462:
3463:
3464: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.

Line 3468: sql_statement := sql_statement || '(qltdate.any_to_datetime(QRI.' ||

3464: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.
3465: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
3466:
3467: ELSIF x_datatype = 6 THEN
3468: sql_statement := sql_statement || '(qltdate.any_to_datetime(QRI.' ||
3469: COL_NAME || ') >= ';
3470:
3471: ELSIF x_datatype = 3 THEN
3472: sql_statement := sql_statement || '(qltdate.any_to_date(QRI.' ||

Line 3472: sql_statement := sql_statement || '(qltdate.any_to_date(QRI.' ||

3468: sql_statement := sql_statement || '(qltdate.any_to_datetime(QRI.' ||
3469: COL_NAME || ') >= ';
3470:
3471: ELSIF x_datatype = 3 THEN
3472: sql_statement := sql_statement || '(qltdate.any_to_date(QRI.' ||
3473: COL_NAME || ') >= ';
3474:
3475: ELSE
3476: sql_statement := sql_statement || '(QRI.' || COL_NAME || ' >= ';

Line 3482: TEMP := 'qltdate.any_to_number(' || TEMP || ')';

3478:
3479: TEMP := 'DECODE(QSC.CHAR_ID, NULL, QC.LOWER_REASONABLE_LIMIT, ' ||
3480: 'QSC.LOWER_REASONABLE_LIMIT)';
3481: IF (X_DATATYPE = 2) THEN
3482: TEMP := 'qltdate.any_to_number(' || TEMP || ')';
3483: ELSIF (X_DATATYPE = 3) THEN
3484: TEMP := 'qltdate.any_to_date(' || TEMP || ')';
3485:
3486: -- For Timezone Compliance bug 3179845.

Line 3484: TEMP := 'qltdate.any_to_date(' || TEMP || ')';

3480: 'QSC.LOWER_REASONABLE_LIMIT)';
3481: IF (X_DATATYPE = 2) THEN
3482: TEMP := 'qltdate.any_to_number(' || TEMP || ')';
3483: ELSIF (X_DATATYPE = 3) THEN
3484: TEMP := 'qltdate.any_to_date(' || TEMP || ')';
3485:
3486: -- For Timezone Compliance bug 3179845.
3487: -- Convert the datetime elements to real dates.
3488: -- kabalakr Mon Oct 27 04:33:49 PST 2003.

Line 3491: TEMP := 'qltdate.canon_to_date(' || TEMP || ')';

3487: -- Convert the datetime elements to real dates.
3488: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
3489:
3490: ELSIF (X_DATATYPE = 6) THEN
3491: TEMP := 'qltdate.canon_to_date(' || TEMP || ')';
3492: END IF;
3493:
3494:
3495: SQL_STATEMENT := SQL_STATEMENT || TEMP || ')) ' ||

Line 3503: sql_statement := sql_statement || '(qltdate.any_to_number(QRI.' ||

3499: 'QSC.UPPER_REASONABLE_LIMIT) IS NULL) ' ||
3500: 'OR ';
3501:
3502: IF X_DATATYPE = 2 THEN
3503: sql_statement := sql_statement || '(qltdate.any_to_number(QRI.' ||
3504: COL_NAME || ') <= ';
3505:
3506: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.
3507: -- kabalakr Mon Oct 27 04:33:49 PST 2003.

Line 3510: sql_statement := sql_statement || '(qltdate.any_to_datetime(QRI.' ||

3506: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.
3507: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
3508:
3509: ELSIF x_datatype = 6 THEN
3510: sql_statement := sql_statement || '(qltdate.any_to_datetime(QRI.' ||
3511: COL_NAME || ') <= ';
3512:
3513: ELSIF x_datatype = 3 THEN
3514: sql_statement := sql_statement || '(qltdate.any_to_date(QRI.' ||

Line 3514: sql_statement := sql_statement || '(qltdate.any_to_date(QRI.' ||

3510: sql_statement := sql_statement || '(qltdate.any_to_datetime(QRI.' ||
3511: COL_NAME || ') <= ';
3512:
3513: ELSIF x_datatype = 3 THEN
3514: sql_statement := sql_statement || '(qltdate.any_to_date(QRI.' ||
3515: COL_NAME || ') <= ';
3516:
3517: ELSE
3518: sql_statement := sql_statement || '(QRI.' || COL_NAME || ' <= ';

Line 3524: TEMP := 'qltdate.any_to_number(' || TEMP || ')';

3520:
3521: TEMP := 'DECODE(QSC.CHAR_ID, NULL, QC.UPPER_REASONABLE_LIMIT, ' ||
3522: 'QSC.UPPER_REASONABLE_LIMIT)';
3523: IF (X_DATATYPE = 2) THEN
3524: TEMP := 'qltdate.any_to_number(' || TEMP || ')';
3525: ELSIF (X_DATATYPE = 3) THEN
3526: TEMP := 'qltdate.any_to_date(' || TEMP || ')';
3527:
3528: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.

Line 3526: TEMP := 'qltdate.any_to_date(' || TEMP || ')';

3522: 'QSC.UPPER_REASONABLE_LIMIT)';
3523: IF (X_DATATYPE = 2) THEN
3524: TEMP := 'qltdate.any_to_number(' || TEMP || ')';
3525: ELSIF (X_DATATYPE = 3) THEN
3526: TEMP := 'qltdate.any_to_date(' || TEMP || ')';
3527:
3528: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.
3529: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
3530:

Line 3532: TEMP := 'qltdate.canon_to_date(' || TEMP || ')';

3528: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.
3529: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
3530:
3531: ELSIF (X_DATATYPE = 6) THEN
3532: TEMP := 'qltdate.canon_to_date(' || TEMP || ')';
3533: END IF;
3534:
3535:
3536: SQL_STATEMENT := SQL_STATEMENT || TEMP || ')))) ' ||

Line 4274: || ' = qltdate.any_to_date(QI.' || CONDITIONS_TABLE(I) ||')';

4270: -- Bug 3860762.suramasw.
4271:
4272: /*
4273: SELECT_STMT := SELECT_STMT || ' AND V.' || CONDITIONS_TABLE(I)
4274: || ' = qltdate.any_to_date(QI.' || CONDITIONS_TABLE(I) ||')';
4275: */
4276:
4277: /*
4278: SELECT_STMT := SELECT_STMT || ' AND V.' || CONDITIONS_TABLE(I)

Line 4279: || ' = qltdate.any_to_date(QI.' ||

4275: */
4276:
4277: /*
4278: SELECT_STMT := SELECT_STMT || ' AND V.' || CONDITIONS_TABLE(I)
4279: || ' = qltdate.any_to_date(QI.' ||
4280: NVL(DEVELOPER_TABLE(I),CONDITIONS_TABLE(I)) ||')';
4281: */
4282:
4283: -- Bug 4254876. Above construction (3860762) is still incorrect.

Line 4288: || ' = qltdate.any_to_date(QI.' || DEVELOPER_TABLE(I) ||')';

4284: -- Now use a cleverly constructed developer_table.
4285: -- bso.
4286:
4287: SELECT_STMT := SELECT_STMT || ' AND V.' || CONDITIONS_TABLE(I)
4288: || ' = qltdate.any_to_date(QI.' || DEVELOPER_TABLE(I) ||')';
4289:
4290: -- END IF;
4291:
4292: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.

Line 4301: || ' = qltdate.any_to_datetime(QI.' || CONDITIONS_TABLE(I) ||')';

4297: /*
4298: -- Bug 3860762.suramasw.
4299:
4300: SELECT_STMT := SELECT_STMT || ' AND V.' || CONDITIONS_TABLE(I)
4301: || ' = qltdate.any_to_datetime(QI.' || CONDITIONS_TABLE(I) ||')';
4302: */
4303:
4304: /*
4305: SELECT_STMT := SELECT_STMT || ' AND V.' || CONDITIONS_TABLE(I)

Line 4306: || ' = qltdate.any_to_datetime(QI.' ||

4302: */
4303:
4304: /*
4305: SELECT_STMT := SELECT_STMT || ' AND V.' || CONDITIONS_TABLE(I)
4306: || ' = qltdate.any_to_datetime(QI.' ||
4307: NVL(DEVELOPER_TABLE(I),CONDITIONS_TABLE(I)) ||')';
4308: */
4309:
4310: -- Bug 4254876. Above construction (3860762) is still incorrect.

Line 4315: || ' = qltdate.any_to_datetime(QI.' || DEVELOPER_TABLE(I) ||')';

4311: -- Now use a cleverly constructed developer_table.
4312: -- bso.
4313:
4314: SELECT_STMT := SELECT_STMT || ' AND V.' || CONDITIONS_TABLE(I)
4315: || ' = qltdate.any_to_datetime(QI.' || DEVELOPER_TABLE(I) ||')';
4316:
4317: ELSE
4318:
4319:

Line 4581: ',qltdate.date_to_canon(' || VALUE_STRING || ')';

4577: UPDATE_STMT := UPDATE_STMT||' NVL(QRI.'||RESULT_COLUMN_NAME(I)||
4578: ',' || VALUE_STRING;
4579: ELSIF DATATYPE_TABLE(I) = 3 THEN
4580: UPDATE_STMT := UPDATE_STMT||' NVL(QRI.'||RESULT_COLUMN_NAME(I)||
4581: ',qltdate.date_to_canon(' || VALUE_STRING || ')';
4582:
4583: -- For Timezone Compliance bug 3179845. Convert the datetime elements to real dates.
4584: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
4585:

Line 4588: ',qltdate.date_to_canon_dt(' || VALUE_STRING || ')';

4584: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
4585:
4586: ELSIF DATATYPE_TABLE(I) = 6 THEN
4587: UPDATE_STMT := UPDATE_STMT||' NVL(QRI.'||RESULT_COLUMN_NAME(I)||
4588: ',qltdate.date_to_canon_dt(' || VALUE_STRING || ')';
4589: END IF;
4590:
4591: -- Bug 3755745.Update of result was erroring out if the plan has sequence elements.
4592: -- We were updating QA_RESULTS_INTERFACE wih values from QA_RESULTS for corresponding