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 2689: c1 := dbms_sql.open_cursor;

2685: FETCH ASSIGNED_COLUMN
2686: INTO y_column, y_datatype, y_deciprec;
2687: CLOSE ASSIGNED_COLUMN;
2688:
2689: c1 := dbms_sql.open_cursor;
2690: dbms_sql.parse(c1, final_stmt, dbms_sql.native);
2691:
2692: --go through the token_vals array and do the bindings
2693: k := token_vals.FIRST;

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

2686: INTO y_column, y_datatype, y_deciprec;
2687: CLOSE ASSIGNED_COLUMN;
2688:
2689: c1 := dbms_sql.open_cursor;
2690: dbms_sql.parse(c1, final_stmt, dbms_sql.native);
2691:
2692: --go through the token_vals array and do the bindings
2693: k := token_vals.FIRST;
2694: WHILE (k IS NOT NULL) LOOP

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

2691:
2692: --go through the token_vals array and do the bindings
2693: k := token_vals.FIRST;
2694: WHILE (k IS NOT NULL) LOOP
2695: dbms_sql.bind_variable(c1, ':' || to_char(k), token_vals(k));
2696: k := token_vals.NEXT(k);
2697: END LOOP;
2698:
2699: -- Bug 5150287. SHKALYAN 02-Mar-2006.

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

2702: -- element the action would fire but the value would not be copied to
2703: -- the target element in Collection Import.
2704: -- Also increased the width of return_value_char from 1500 to 2000.
2705: IF y_datatype in (1,4) THEN
2706: dbms_sql.define_column(c1, 1, return_value_char, 2000);
2707: ELSIF y_datatype = 2 THEN
2708: dbms_sql.define_column(c1, 1, return_value_num);
2709:
2710: ELSIF y_datatype = 3 THEN

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

2704: -- Also increased the width of return_value_char from 1500 to 2000.
2705: IF y_datatype in (1,4) THEN
2706: dbms_sql.define_column(c1, 1, return_value_char, 2000);
2707: ELSIF y_datatype = 2 THEN
2708: dbms_sql.define_column(c1, 1, return_value_num);
2709:
2710: ELSIF y_datatype = 3 THEN
2711: -- Bug 3213920. rponnusa Tue Oct 28 23:19:18 PST 2003
2712: -- define the column as date type

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

2709:
2710: ELSIF y_datatype = 3 THEN
2711: -- Bug 3213920. rponnusa Tue Oct 28 23:19:18 PST 2003
2712: -- define the column as date type
2713: dbms_sql.define_column(c1, 1, return_value_date);
2714:
2715: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
2716:
2717: ELSIF y_datatype = 6 THEN -- datetime

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

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

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

2723: END IF;
2724:
2725: END IF;
2726:
2727: ignore := dbms_sql.execute(c1);
2728:
2729: --
2730: -- Bug 2976810
2731: -- although this piece of SQL was not in the original plan, update it to use EXECUTE IMMEDIATE

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

2737:
2738: --set the default bind variable name
2739: bind_var_name := ':CHAR_VALUE';
2740:
2741: IF dbms_sql.fetch_rows(c1)>0 THEN
2742:
2743: --get the column's value into return_value_char|num and add a properly wrapped bind variable for it
2744:
2745: -- Bug 5150287. SHKALYAN 02-Mar-2006.

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

2746: -- Included y_datatype=4 also in the following loop for the same
2747: -- reason mentioned few lines above.
2748: IF y_datatype in (1,4) THEN
2749:
2750: dbms_sql.column_value(c1, 1, return_value_char);
2751:
2752: --
2753: -- Bug 4751249
2754: -- Made a call to the new procedure added that will get the

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

2759: GET_DERIVED_VALUE(y_column, return_value_char);
2760:
2761: ELSIF y_datatype = 2 THEN
2762:
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 || ')';

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

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

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

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

Line 2803: dbms_sql.close_cursor(c1);

2799: return_value_char := NULL;
2800:
2801: END IF; -- IF fetch_rows
2802:
2803: dbms_sql.close_cursor(c1);
2804:
2805: --add the bind variable name and additional where clause params to the update statement
2806: update_stmt := update_stmt || bind_var_name || ' WHERE plan_id = :PLAN_ID AND '||
2807: 'collection_id = :COLL_ID AND '||