APPS.QLTDACTB dependencies on QLTDATE

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

1239: EXIT WHEN MY_RESULTS_COLUMN%NOTFOUND;
1240:
1241: result_value := QLTNINRB.NAME_IN(RC.Q_COLUMN);
1242: IF RC.DEV_NAME = 'TRANSACTION_DATE' THEN
1243: X_TRANSACTION_DATE := qltdate.any_to_date(result_value);
1244: ELSIF RC.DEV_NAME = 'QUANTITY' THEN
1245: X_QUANTITY := result_value;
1246: ELSIF RC.DEV_NAME = 'QUALITY_CODE' THEN
1247: X_QUALITY_CODE := result_value;

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

2648: -- to the target element (or) would error out in Collection Import.
2649: if y_datatype in (1,4) then
2650: bind_var_name := bind_var_name;
2651: elsif y_datatype = 2 then
2652: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';
2653: elsif y_datatype = 3 then
2654: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2655:
2656: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003

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

2650: bind_var_name := bind_var_name;
2651: elsif y_datatype = 2 then
2652: bind_var_name:= 'nvl(qltdate.canon_to_number(' || bind_var_name || '), 0)';
2653: elsif y_datatype = 3 then
2654: bind_var_name := 'qltdate.any_to_date(' || bind_var_name || ')';
2655:
2656: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
2657: elsif y_datatype = 6 then
2658: -- Bug 3211247. rponnusa Tue Oct 28 23:19:18 PST 2003

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

2657: elsif y_datatype = 6 then
2658: -- Bug 3211247. rponnusa Tue Oct 28 23:19:18 PST 2003
2659: /*
2660: IF y_column LIKE 'CHARACTER%' THEN
2661: bind_var_name := 'qltdate.canon_to_date(' || bind_var_name || ')';
2662: ELSE
2663: bind_var_name := bind_var_name;
2664: END IF;
2665: */

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

2662: ELSE
2663: bind_var_name := bind_var_name;
2664: END IF;
2665: */
2666: bind_var_name := 'qltdate.any_to_datetime(' || bind_var_name || ')';
2667: end if;
2668:
2669: --add the token value to the token value array and append the bind variable string to the statement
2670: token_vals(k) := token_column_value;

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

2718: dbms_sql.define_column(c1, 1, return_value_date);
2719: -- Bug 3211247. rponnusa Tue Oct 28 23:19:18 PST 2003
2720: -- convert to canon mask for softcoded elements.
2721: IF y_column LIKE 'CHARACTER%' THEN
2722: bind_var_name := 'qltdate.date_to_canon_dt(' || bind_var_name || ')';
2723: END IF;
2724:
2725: END IF;
2726:

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

2763: dbms_sql.column_value(c1, 1, return_value_num);
2764: return_value_num := round(return_value_num, nvl(y_deciprec, 0));
2765:
2766: IF y_column LIKE 'CHARACTER%' THEN
2767: bind_var_name := 'qltdate.number_to_canon(' || bind_var_name || ')';
2768: END IF;
2769:
2770: ELSIF y_datatype = 3 THEN
2771:

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

2774:
2775: dbms_sql.column_value(c1, 1, return_value_date);
2776:
2777: IF y_column LIKE 'CHARACTER%' THEN
2778: bind_var_name := 'qltdate.date_to_canon(' || bind_var_name || ')';
2779: END IF;
2780:
2781: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
2782: ELSIF y_datatype = 6 THEN -- datetime

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

2783:
2784: dbms_sql.column_value(c1, 1, return_value_date);
2785:
2786: IF y_column LIKE 'CHARACTER%' THEN
2787: bind_var_name := 'qltdate.date_to_canon_dt(' || bind_var_name || ')';
2788: END IF;
2789:
2790: END IF; -- IF y_datatype
2791: ELSE

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

2843: qltninrb.set_value(y_column,to_char(return_value_num));
2844: END IF;
2845: IF y_datatype = 6 and return_value_date is not null then
2846: IF y_column LIKE 'CHARACTER%' THEN
2847: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));
2848: ELSE
2849: qltninrb.set_value(y_column,to_char(return_value_date));
2850: END IF;
2851: END IF;

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

2850: END IF;
2851: END IF;
2852: IF y_datatype = 3 AND return_value_date IS NOT NULL THEN
2853: IF y_column LIKE 'CHARACTER%' THEN
2854: qltninrb.set_value(y_column,qltdate.date_to_canon(return_value_date));
2855: ELSE
2856: qltninrb.set_value(y_column,to_char(return_value_date));
2857: END IF;
2858: END IF;