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 DBMS_SQL

Line 2818: c1 := dbms_sql.open_cursor;

2814: FETCH ASSIGNED_COLUMN
2815: INTO y_column, y_datatype, y_deciprec;
2816: CLOSE ASSIGNED_COLUMN;
2817:
2818: c1 := dbms_sql.open_cursor;
2819: dbms_sql.parse(c1, final_stmt, dbms_sql.native);
2820:
2821: --go through the token_vals array and do the bindings
2822: k := token_vals.FIRST;

Line 2819: dbms_sql.parse(c1, final_stmt, dbms_sql.native);

2815: INTO y_column, y_datatype, y_deciprec;
2816: CLOSE ASSIGNED_COLUMN;
2817:
2818: c1 := dbms_sql.open_cursor;
2819: dbms_sql.parse(c1, final_stmt, dbms_sql.native);
2820:
2821: --go through the token_vals array and do the bindings
2822: k := token_vals.FIRST;
2823: WHILE (k IS NOT NULL) LOOP

Line 2824: dbms_sql.bind_variable(c1, ':' || to_char(k), token_vals(k));

2820:
2821: --go through the token_vals array and do the bindings
2822: k := token_vals.FIRST;
2823: WHILE (k IS NOT NULL) LOOP
2824: dbms_sql.bind_variable(c1, ':' || to_char(k), token_vals(k));
2825: k := token_vals.NEXT(k);
2826: END LOOP;
2827:
2828: -- Bug 5150287. SHKALYAN 02-Mar-2006.

Line 2835: dbms_sql.define_column(c1, 1, return_value_char, 2000);

2831: -- element the action would fire but the value would not be copied to
2832: -- the target element in Collection Import.
2833: -- Also increased the width of return_value_char from 1500 to 2000.
2834: IF y_datatype in (1,4) THEN
2835: dbms_sql.define_column(c1, 1, return_value_char, 2000);
2836: ELSIF y_datatype = 2 THEN
2837: dbms_sql.define_column(c1, 1, return_value_num);
2838:
2839: ELSIF y_datatype = 3 THEN

Line 2837: dbms_sql.define_column(c1, 1, return_value_num);

2833: -- Also increased the width of return_value_char from 1500 to 2000.
2834: IF y_datatype in (1,4) THEN
2835: dbms_sql.define_column(c1, 1, return_value_char, 2000);
2836: ELSIF y_datatype = 2 THEN
2837: dbms_sql.define_column(c1, 1, return_value_num);
2838:
2839: ELSIF y_datatype = 3 THEN
2840: -- Bug 3213920. rponnusa Tue Oct 28 23:19:18 PST 2003
2841: -- define the column as date type

Line 2842: dbms_sql.define_column(c1, 1, return_value_date);

2838:
2839: ELSIF y_datatype = 3 THEN
2840: -- Bug 3213920. rponnusa Tue Oct 28 23:19:18 PST 2003
2841: -- define the column as date type
2842: dbms_sql.define_column(c1, 1, return_value_date);
2843:
2844: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
2845:
2846: ELSIF y_datatype = 6 THEN -- datetime

Line 2847: dbms_sql.define_column(c1, 1, return_value_date);

2843:
2844: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
2845:
2846: ELSIF y_datatype = 6 THEN -- datetime
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 || ')';

Line 2856: ignore := dbms_sql.execute(c1);

2852: END IF;
2853:
2854: END IF;
2855:
2856: ignore := dbms_sql.execute(c1);
2857:
2858: --
2859: -- Bug 2976810
2860: -- although this piece of SQL was not in the original plan, update it to use EXECUTE IMMEDIATE

Line 2870: IF dbms_sql.fetch_rows(c1)>0 THEN

2866:
2867: --set the default bind variable name
2868: bind_var_name := ':CHAR_VALUE';
2869:
2870: IF dbms_sql.fetch_rows(c1)>0 THEN
2871:
2872: --get the column's value into return_value_char|num and add a properly wrapped bind variable for it
2873:
2874: -- Bug 5150287. SHKALYAN 02-Mar-2006.

Line 2879: dbms_sql.column_value(c1, 1, return_value_char);

2875: -- Included y_datatype=4 also in the following loop for the same
2876: -- reason mentioned few lines above.
2877: IF y_datatype in (1,4) THEN
2878:
2879: dbms_sql.column_value(c1, 1, return_value_char);
2880:
2881: --
2882: -- Bug 4751249
2883: -- Made a call to the new procedure added that will get the

Line 2892: dbms_sql.column_value(c1, 1, return_value_num);

2888: GET_DERIVED_VALUE(y_column, return_value_char);
2889:
2890: ELSIF y_datatype = 2 THEN
2891:
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 || ')';

Line 2904: dbms_sql.column_value(c1, 1, return_value_date);

2900:
2901: -- Bug 3213920. rponnusa Tue Oct 28 23:19:18 PST 2003
2902: -- fetch the col value as Date type
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;

Line 2913: dbms_sql.column_value(c1, 1, return_value_date);

2909:
2910: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
2911: ELSIF y_datatype = 6 THEN -- datetime
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;

Line 2932: dbms_sql.close_cursor(c1);

2928: return_value_char := NULL;
2929:
2930: END IF; -- IF fetch_rows
2931:
2932: dbms_sql.close_cursor(c1);
2933:
2934: --add the bind variable name and additional where clause params to the update statement
2935: update_stmt := update_stmt || bind_var_name || ' WHERE plan_id = :PLAN_ID AND '||
2936: 'collection_id = :COLL_ID AND '||