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 2507: -- modified to use dbms_sql and bind variables to remove our dependence on

2503: --
2504: -- Bug 2976810
2505: -- this function performs the sql text/formula associated with an
2506: -- 'Assign a value to a collection element' plan action. This function has been
2507: -- modified to use dbms_sql and bind variables to remove our dependence on
2508: -- an exemption. This function was also expanded to do some of the data formatting
2509: -- done by import(qltdactb.do_assignment).
2510: -- ilawler Tue May 27 13:34:49 2003
2511: --

Line 2670: c1 := dbms_sql.open_cursor;

2666: IF assignment_type = 'F' THEN
2667: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';
2668: END IF;
2669:
2670: c1 := dbms_sql.open_cursor;
2671: dbms_sql.parse(c1, final_stmt, dbms_sql.native);
2672:
2673: --go through the token_vals array and do the bindings
2674: k := token_vals.FIRST;

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

2667: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';
2668: END IF;
2669:
2670: c1 := dbms_sql.open_cursor;
2671: dbms_sql.parse(c1, final_stmt, dbms_sql.native);
2672:
2673: --go through the token_vals array and do the bindings
2674: k := token_vals.FIRST;
2675: WHILE (k IS NOT NULL) LOOP

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

2672:
2673: --go through the token_vals array and do the bindings
2674: k := token_vals.FIRST;
2675: WHILE (k IS NOT NULL) LOOP
2676: dbms_sql.bind_variable(c1, ':' || to_char(k), token_vals(k));
2677: k := token_vals.NEXT(k);
2678: END LOOP;
2679:
2680: --

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

2683: -- validate_row
2684: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2685: --
2686: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_org_id, 1)<> 0 THEN
2687: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_org_id, g_org_id);
2688: END IF;
2689:
2690: --
2691: -- Bug 4635316

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

2693: -- validate_row
2694: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2695: --
2696: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_user_id, 1) <> 0 THEN
2697: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_user_id, g_user_id);
2698: END IF;
2699:
2700: --set up the type of the output we expect
2701:

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

2705: -- element the action would fire but the value would not be copied to
2706: -- the target element in SSQR. Also increased the width of
2707: -- return_value_char from 1500 to 2000.
2708: IF assigned_datatype in (1,4) THEN
2709: dbms_sql.define_column(c1, 1, return_value_char, 2000);
2710: ELSIF assigned_datatype = 2 THEN
2711: dbms_sql.define_column(c1, 1, return_value_num);
2712: ELSIF assigned_datatype = 3 THEN
2713: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003

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

2707: -- return_value_char from 1500 to 2000.
2708: IF assigned_datatype in (1,4) THEN
2709: dbms_sql.define_column(c1, 1, return_value_char, 2000);
2710: ELSIF assigned_datatype = 2 THEN
2711: dbms_sql.define_column(c1, 1, return_value_num);
2712: ELSIF assigned_datatype = 3 THEN
2713: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2714:
2715: -- Assign value from Date element to Date element fail if

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

2713: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2714:
2715: -- Assign value from Date element to Date element fail if
2716: -- col defined as char type. To fix this get the value as Date type
2717: -- dbms_sql.define_column(c1, 1, return_value_char, 1500);
2718: dbms_sql.define_column(c1, 1, return_value_date);
2719:
2720: ELSIF assigned_datatype = 6 THEN -- datetime
2721: dbms_sql.define_column(c1, 1, return_value_date);

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

2714:
2715: -- Assign value from Date element to Date element fail if
2716: -- col defined as char type. To fix this get the value as Date type
2717: -- dbms_sql.define_column(c1, 1, return_value_char, 1500);
2718: dbms_sql.define_column(c1, 1, return_value_date);
2719:
2720: ELSIF assigned_datatype = 6 THEN -- datetime
2721: dbms_sql.define_column(c1, 1, return_value_date);
2722: END IF;

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

2717: -- dbms_sql.define_column(c1, 1, return_value_char, 1500);
2718: dbms_sql.define_column(c1, 1, return_value_date);
2719:
2720: ELSIF assigned_datatype = 6 THEN -- datetime
2721: dbms_sql.define_column(c1, 1, return_value_date);
2722: END IF;
2723:
2724: --execute the cursor and fetch the value into return_value_char
2725: ignore := dbms_sql.execute(c1);

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

2721: dbms_sql.define_column(c1, 1, return_value_date);
2722: END IF;
2723:
2724: --execute the cursor and fetch the value into return_value_char
2725: ignore := dbms_sql.execute(c1);
2726:
2727: IF dbms_sql.fetch_rows(c1)>0 THEN
2728:
2729: -- Bug 5150287. SHKALYAN 02-Mar-2006.

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

2723:
2724: --execute the cursor and fetch the value into return_value_char
2725: ignore := dbms_sql.execute(c1);
2726:
2727: IF dbms_sql.fetch_rows(c1)>0 THEN
2728:
2729: -- Bug 5150287. SHKALYAN 02-Mar-2006.
2730: -- Included assigned_datatype=4 also in the following loop for the
2731: -- same reason mentioned few lines above.

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

2730: -- Included assigned_datatype=4 also in the following loop for the
2731: -- same reason mentioned few lines above.
2732: IF assigned_datatype in (1,4) THEN
2733:
2734: dbms_sql.column_value(c1, 1, return_value_char);
2735:
2736: ELSIF assigned_datatype = 2 THEN
2737:
2738: dbms_sql.column_value(c1, 1, return_value_num);

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

2734: dbms_sql.column_value(c1, 1, return_value_char);
2735:
2736: ELSIF assigned_datatype = 2 THEN
2737:
2738: dbms_sql.column_value(c1, 1, return_value_num);
2739: return_value_char := to_char(round(return_value_num, nvl(assigned_precision, 0)));
2740:
2741: ELSIF assigned_datatype = 3 THEN
2742: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003

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

2740:
2741: ELSIF assigned_datatype = 3 THEN
2742: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2743:
2744: -- dbms_sql.column_value(c1, 1, return_value_char);
2745: dbms_sql.column_value(c1, 1, return_value_date);
2746: return_value_char := qltdate.date_to_canon(return_value_date);
2747:
2748: ELSIF assigned_datatype = 6 THEN -- datetime

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

2741: ELSIF assigned_datatype = 3 THEN
2742: -- Bug 3179845. Timezone Project. rponnusa Thu Oct 30 00:47:31 PST 2003
2743:
2744: -- dbms_sql.column_value(c1, 1, return_value_char);
2745: dbms_sql.column_value(c1, 1, return_value_date);
2746: return_value_char := qltdate.date_to_canon(return_value_date);
2747:
2748: ELSIF assigned_datatype = 6 THEN -- datetime
2749:

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

2746: return_value_char := qltdate.date_to_canon(return_value_date);
2747:
2748: ELSIF assigned_datatype = 6 THEN -- datetime
2749:
2750: dbms_sql.column_value(c1, 1, return_value_date);
2751: return_value_char := qltdate.date_to_canon_dt(return_value_date);
2752:
2753: END IF;
2754: ELSE

Line 2758: dbms_sql.close_cursor(c1);

2754: ELSE
2755: --if we didn't get anything then just give back a null
2756: return_value_char := NULL;
2757: END IF;
2758: dbms_sql.close_cursor(c1);
2759:
2760: RETURN return_value_char;
2761:
2762: EXCEPTION WHEN OTHERS THEN