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.QA_VALIDATION_API dependencies on DBMS_SQL

Line 10: g_message_map dbms_sql.varchar2s;

6: --
7: -- Mapping between an internal validation error message code
8: -- and the AOL message name.
9: --
10: g_message_map dbms_sql.varchar2s;
11:
12: g_restrict_subinv_code NUMBER;
13: g_restrict_locators_code NUMBER;
14: g_location_control_code NUMBER;

Line 2574: -- modified to use dbms_sql and bind variables to remove our dependence on

2570: --
2571: -- Bug 2976810
2572: -- this function performs the sql text/formula associated with an
2573: -- 'Assign a value to a collection element' plan action. This function has been
2574: -- modified to use dbms_sql and bind variables to remove our dependence on
2575: -- an exemption. This function was also expanded to do some of the data formatting
2576: -- done by import(qltdactb.do_assignment).
2577: -- ilawler Tue May 27 13:34:49 2003
2578: --

Line 2737: c1 := dbms_sql.open_cursor;

2733: IF assignment_type = 'F' THEN
2734: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';
2735: END IF;
2736:
2737: c1 := dbms_sql.open_cursor;
2738: dbms_sql.parse(c1, final_stmt, dbms_sql.native);
2739:
2740: --go through the token_vals array and do the bindings
2741: k := token_vals.FIRST;

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

2734: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';
2735: END IF;
2736:
2737: c1 := dbms_sql.open_cursor;
2738: dbms_sql.parse(c1, final_stmt, dbms_sql.native);
2739:
2740: --go through the token_vals array and do the bindings
2741: k := token_vals.FIRST;
2742: WHILE (k IS NOT NULL) LOOP

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

2739:
2740: --go through the token_vals array and do the bindings
2741: k := token_vals.FIRST;
2742: WHILE (k IS NOT NULL) LOOP
2743: dbms_sql.bind_variable(c1, ':' || to_char(k), token_vals(k));
2744: k := token_vals.NEXT(k);
2745: END LOOP;
2746:
2747: --

Line 2754: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_org_id, g_org_id);

2750: -- validate_row
2751: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2752: --
2753: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_org_id, 1)<> 0 THEN
2754: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_org_id, g_org_id);
2755: END IF;
2756:
2757: --
2758: -- Bug 4635316

Line 2764: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_user_id, g_user_id);

2760: -- validate_row
2761: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2762: --
2763: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_user_id, 1) <> 0 THEN
2764: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_user_id, g_user_id);
2765: END IF;
2766:
2767: --set up the type of the output we expect
2768:

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

2772: -- element the action would fire but the value would not be copied to
2773: -- the target element in SSQR. Also increased the width of
2774: -- return_value_char from 1500 to 2000.
2775: IF assigned_datatype in (1,4) THEN
2776: dbms_sql.define_column(c1, 1, return_value_char, 2000);
2777: ELSIF assigned_datatype = 2 THEN
2778: dbms_sql.define_column(c1, 1, return_value_num);
2779: ELSIF assigned_datatype = 3 THEN
2780: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003

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

2774: -- return_value_char from 1500 to 2000.
2775: IF assigned_datatype in (1,4) THEN
2776: dbms_sql.define_column(c1, 1, return_value_char, 2000);
2777: ELSIF assigned_datatype = 2 THEN
2778: dbms_sql.define_column(c1, 1, return_value_num);
2779: ELSIF assigned_datatype = 3 THEN
2780: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2781:
2782: -- Assign value from Date element to Date element fail if

Line 2784: -- dbms_sql.define_column(c1, 1, return_value_char, 1500);

2780: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2781:
2782: -- Assign value from Date element to Date element fail if
2783: -- col defined as char type. To fix this get the value as Date type
2784: -- dbms_sql.define_column(c1, 1, return_value_char, 1500);
2785: dbms_sql.define_column(c1, 1, return_value_date);
2786:
2787: ELSIF assigned_datatype = 6 THEN -- datetime
2788: dbms_sql.define_column(c1, 1, return_value_date);

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

2781:
2782: -- Assign value from Date element to Date element fail if
2783: -- col defined as char type. To fix this get the value as Date type
2784: -- dbms_sql.define_column(c1, 1, return_value_char, 1500);
2785: dbms_sql.define_column(c1, 1, return_value_date);
2786:
2787: ELSIF assigned_datatype = 6 THEN -- datetime
2788: dbms_sql.define_column(c1, 1, return_value_date);
2789: END IF;

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

2784: -- dbms_sql.define_column(c1, 1, return_value_char, 1500);
2785: dbms_sql.define_column(c1, 1, return_value_date);
2786:
2787: ELSIF assigned_datatype = 6 THEN -- datetime
2788: dbms_sql.define_column(c1, 1, return_value_date);
2789: END IF;
2790:
2791: --execute the cursor and fetch the value into return_value_char
2792: ignore := dbms_sql.execute(c1);

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

2788: dbms_sql.define_column(c1, 1, return_value_date);
2789: END IF;
2790:
2791: --execute the cursor and fetch the value into return_value_char
2792: ignore := dbms_sql.execute(c1);
2793:
2794: IF dbms_sql.fetch_rows(c1)>0 THEN
2795:
2796: -- Bug 5150287. SHKALYAN 02-Mar-2006.

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

2790:
2791: --execute the cursor and fetch the value into return_value_char
2792: ignore := dbms_sql.execute(c1);
2793:
2794: IF dbms_sql.fetch_rows(c1)>0 THEN
2795:
2796: -- Bug 5150287. SHKALYAN 02-Mar-2006.
2797: -- Included assigned_datatype=4 also in the following loop for the
2798: -- same reason mentioned few lines above.

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

2797: -- Included assigned_datatype=4 also in the following loop for the
2798: -- same reason mentioned few lines above.
2799: IF assigned_datatype in (1,4) THEN
2800:
2801: dbms_sql.column_value(c1, 1, return_value_char);
2802:
2803: ELSIF assigned_datatype = 2 THEN
2804:
2805: dbms_sql.column_value(c1, 1, return_value_num);

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

2801: dbms_sql.column_value(c1, 1, return_value_char);
2802:
2803: ELSIF assigned_datatype = 2 THEN
2804:
2805: dbms_sql.column_value(c1, 1, return_value_num);
2806: return_value_char := to_char(round(return_value_num, nvl(assigned_precision, 0)));
2807:
2808: ELSIF assigned_datatype = 3 THEN
2809: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003

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

2807:
2808: ELSIF assigned_datatype = 3 THEN
2809: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2810:
2811: -- dbms_sql.column_value(c1, 1, return_value_char);
2812: dbms_sql.column_value(c1, 1, return_value_date);
2813: return_value_char := qltdate.date_to_canon(return_value_date);
2814:
2815: ELSIF assigned_datatype = 6 THEN -- datetime

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

2808: ELSIF assigned_datatype = 3 THEN
2809: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2810:
2811: -- dbms_sql.column_value(c1, 1, return_value_char);
2812: dbms_sql.column_value(c1, 1, return_value_date);
2813: return_value_char := qltdate.date_to_canon(return_value_date);
2814:
2815: ELSIF assigned_datatype = 6 THEN -- datetime
2816:

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

2813: return_value_char := qltdate.date_to_canon(return_value_date);
2814:
2815: ELSIF assigned_datatype = 6 THEN -- datetime
2816:
2817: dbms_sql.column_value(c1, 1, return_value_date);
2818: return_value_char := qltdate.date_to_canon_dt(return_value_date);
2819:
2820: END IF;
2821: ELSE

Line 2825: dbms_sql.close_cursor(c1);

2821: ELSE
2822: --if we didn't get anything then just give back a null
2823: return_value_char := NULL;
2824: END IF;
2825: dbms_sql.close_cursor(c1);
2826:
2827: RETURN return_value_char;
2828:
2829: EXCEPTION WHEN OTHERS THEN