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

Line 1282: X_TRANSACTION_DATE := qltdate.any_to_date(result_value);

1278: EXIT WHEN MY_RESULTS_COLUMN%NOTFOUND;
1279:
1280: result_value := QLTNINRB.NAME_IN(RC.Q_COLUMN);
1281: IF RC.DEV_NAME = 'TRANSACTION_DATE' THEN
1282: X_TRANSACTION_DATE := qltdate.any_to_date(result_value);
1283: ELSIF RC.DEV_NAME = 'QUANTITY' THEN
1284: X_QUANTITY := result_value;
1285: ELSIF RC.DEV_NAME = 'QUALITY_CODE' THEN
1286: X_QUALITY_CODE := result_value;

Line 2420: ACTUAL_OUTPUT := QLTDATE.any_to_user(ACTUAL_OUTPUT);

2416: -- hmakam
2417:
2418: IF NOT(prec.char_id = 51) THEN
2419: IF(qa_chars_api.datatype(prec.char_id) = 3) THEN
2420: ACTUAL_OUTPUT := QLTDATE.any_to_user(ACTUAL_OUTPUT);
2421: ELSIF(qa_chars_api.datatype(prec.char_id) = 6) THEN
2422: ACTUAL_OUTPUT := QLTDATE.any_to_user_dt(ACTUAL_OUTPUT);
2423: END IF;
2424: END IF;

Line 2422: ACTUAL_OUTPUT := QLTDATE.any_to_user_dt(ACTUAL_OUTPUT);

2418: IF NOT(prec.char_id = 51) THEN
2419: IF(qa_chars_api.datatype(prec.char_id) = 3) THEN
2420: ACTUAL_OUTPUT := QLTDATE.any_to_user(ACTUAL_OUTPUT);
2421: ELSIF(qa_chars_api.datatype(prec.char_id) = 6) THEN
2422: ACTUAL_OUTPUT := QLTDATE.any_to_user_dt(ACTUAL_OUTPUT);
2423: END IF;
2424: END IF;
2425:
2426:

Line 2781: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';

2777: -- to the target element (or) would error out in Collection Import.
2778: if y_datatype in (1,4) then
2779: bind_var_name := bind_var_name;
2780: elsif y_datatype = 2 then
2781: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';
2782: elsif y_datatype = 3 then
2783: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2784:
2785: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003

Line 2783: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';

2779: bind_var_name := bind_var_name;
2780: elsif y_datatype = 2 then
2781: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';
2782: elsif y_datatype = 3 then
2783: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2784:
2785: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
2786: elsif y_datatype = 6 then
2787: -- Bug 3211247. rponnusa Tue Oct 28 23:19:18 PST 2003

Line 2790: bind_var_name := 'qltdate.canon_to_date(' || bind_var_name || ')';

2786: elsif y_datatype = 6 then
2787: -- Bug 3211247. rponnusa Tue Oct 28 23:19:18 PST 2003
2788: /*
2789: IF y_column LIKE 'CHARACTER%' THEN
2790: bind_var_name := 'qltdate.canon_to_date(' || bind_var_name || ')';
2791: ELSE
2792: bind_var_name := bind_var_name;
2793: END IF;
2794: */

Line 2795: bind_var_name := 'qltdate.any_to_datetime(' || bind_var_name || ')';

2791: ELSE
2792: bind_var_name := bind_var_name;
2793: END IF;
2794: */
2795: bind_var_name := 'qltdate.any_to_datetime(' || bind_var_name || ')';
2796: end if;
2797:
2798: --add the token value to the token value array and append the bind variable string to the statement
2799: token_vals(k) := token_column_value;

Line 2851: bind_var_name := 'qltdate.date_to_canon_dt(' || bind_var_name || ')';

2847: dbms_sql.define_column(c1, 1, return_value_date);
2848: -- Bug 3211247. rponnusa Tue Oct 28 23:19:18 PST 2003
2849: -- convert to canon mask for softcoded elements.
2850: IF y_column LIKE 'CHARACTER%' THEN
2851: bind_var_name := 'qltdate.date_to_canon_dt(' || bind_var_name || ')';
2852: END IF;
2853:
2854: END IF;
2855:

Line 2896: bind_var_name := 'qltdate.number_to_canon(' || bind_var_name || ')';

2892: dbms_sql.column_value(c1, 1, return_value_num);
2893: return_value_num := round(return_value_num, nvl(y_deciprec, 0));
2894:
2895: IF y_column LIKE 'CHARACTER%' THEN
2896: bind_var_name := 'qltdate.number_to_canon(' || bind_var_name || ')';
2897: END IF;
2898:
2899: ELSIF y_datatype = 3 THEN
2900:

Line 2907: bind_var_name := 'qltdate.date_to_canon(' || bind_var_name || ')';

2903:
2904: dbms_sql.column_value(c1, 1, return_value_date);
2905:
2906: IF y_column LIKE 'CHARACTER%' THEN
2907: bind_var_name := 'qltdate.date_to_canon(' || bind_var_name || ')';
2908: END IF;
2909:
2910: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
2911: ELSIF y_datatype = 6 THEN -- datetime

Line 2916: bind_var_name := 'qltdate.date_to_canon_dt(' || bind_var_name || ')';

2912:
2913: dbms_sql.column_value(c1, 1, return_value_date);
2914:
2915: IF y_column LIKE 'CHARACTER%' THEN
2916: bind_var_name := 'qltdate.date_to_canon_dt(' || bind_var_name || ')';
2917: END IF;
2918:
2919: END IF; -- IF y_datatype
2920: ELSE

Line 2976: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));

2972: qltninrb.set_value(y_column,to_char(return_value_num));
2973: END IF;
2974: IF y_datatype = 6 and return_value_date is not null then
2975: IF y_column LIKE 'CHARACTER%' THEN
2976: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));
2977: ELSE
2978: qltninrb.set_value(y_column,to_char(return_value_date));
2979: END IF;
2980: END IF;

Line 2983: qltninrb.set_value(y_column,qltdate.date_to_canon(return_value_date));

2979: END IF;
2980: END IF;
2981: IF y_datatype = 3 AND return_value_date IS NOT NULL THEN
2982: IF y_column LIKE 'CHARACTER%' THEN
2983: qltninrb.set_value(y_column,qltdate.date_to_canon(return_value_date));
2984: ELSE
2985: qltninrb.set_value(y_column,to_char(return_value_date));
2986: END IF;
2987: END IF;