APPS.QLTVCREB dependencies on DBMS_SQL

Line 14: -- string limit). Now, the DBMS_SQL.Varchar2s type is used for storing

10: --
11: -- The following set functions is an effort to extend the capability
12: -- of the global_view procedure, so it can handle view definitions
13: -- longer than 32K, the previous hard limit (because of PL/SQL varchar2
14: -- string limit). Now, the DBMS_SQL.Varchar2s type is used for storing
15: -- the view definition. This is a table and is the data type used by
16: -- AD_DDL.DO_ARRAY_DDL.
17: --
18: -- April 22, 1998. bso

Line 31: PROCEDURE table_print(A in DBMS_SQL.varchar2s) IS

27: g_industry VARCHAR2(10);
28: g_schema VARCHAR2(30);
29:
30: /*
31: PROCEDURE table_print(A in DBMS_SQL.varchar2s) IS
32: -- Debug procedure, not used in production.
33: -- bso
34: i binary_integer;
35: BEGIN

Line 53: PROCEDURE create_clause(s in out NOCOPY DBMS_SQL.varchar2s, f in DBMS_SQL.varchar2s,

49: -- ntungare
50: --
51: TYPE grants_tab_typ IS TABLE OF VARCHAR2(32767) INDEX BY binary_integer;
52:
53: PROCEDURE create_clause(s in out NOCOPY DBMS_SQL.varchar2s, f in DBMS_SQL.varchar2s,
54: keyword varchar2) IS
55: --
56: -- Add to s the content of f to make f the FROM or WHERE clause of s.
57: -- This procedure replaces the QLTSTORB.Create_From/Where_Clause procedures

Line 60: -- s is the sql string in dbms_sql.varchar2s

56: -- Add to s the content of f to make f the FROM or WHERE clause of s.
57: -- This procedure replaces the QLTSTORB.Create_From/Where_Clause procedures
58: -- because that one does not allow a clause that's > 32k.
59: --
60: -- s is the sql string in dbms_sql.varchar2s
61: -- f is the list of from or where clauses
62: -- keyword is either 'FROM' or 'WHERE'
63: --
64: -- bso

Line 87: cmd in integer, statement in DBMS_SQL.varchar2s, name in varchar2) IS

83: END;
84:
85:
86: PROCEDURE exec_ddl_table(schema in varchar2, shortname in varchar2,
87: cmd in integer, statement in DBMS_SQL.varchar2s, name in varchar2) IS
88: -- Execute a data definition statement by using the AD_DDL.DO_ARRAY_DDL
89: -- function. See Bug 574078. Release 10.7 requires this patch to work.
90: -- bso
91:

Line 172: FUNCTION contains(a dbms_sql.number_table, x NUMBER) RETURN NUMBER IS

168: NULL;
169: END drop_view;
170:
171:
172: FUNCTION contains(a dbms_sql.number_table, x NUMBER) RETURN NUMBER IS
173: BEGIN
174: FOR i IN a.first .. a.last LOOP
175: IF a(i) = x THEN
176: RETURN i;

Line 193: v_sql_table dbms_sql.varchar2s;

189:
190: --
191: -- Used to construct the final dynamic sql.
192: --
193: v_sql_table dbms_sql.varchar2s;
194: v_from_table dbms_sql.varchar2s;
195: v_where_table dbms_sql.varchar2s;
196:
197:

Line 194: v_from_table dbms_sql.varchar2s;

190: --
191: -- Used to construct the final dynamic sql.
192: --
193: v_sql_table dbms_sql.varchar2s;
194: v_from_table dbms_sql.varchar2s;
195: v_where_table dbms_sql.varchar2s;
196:
197:
198: --

Line 195: v_where_table dbms_sql.varchar2s;

191: -- Used to construct the final dynamic sql.
192: --
193: v_sql_table dbms_sql.varchar2s;
194: v_from_table dbms_sql.varchar2s;
195: v_where_table dbms_sql.varchar2s;
196:
197:
198: --
199: -- Maximum no. of columns allowed in a view.

Line 243: -- element_ids dbms_sql.number_table;

239: -- ORDER BY qc.hardcoded_column, qc.name;
240: --
241: -- The elements to be included in the final view.
242: --
243: -- element_ids dbms_sql.number_table;
244: -- element_names dbms_sql.varchar2s;
245: -- element_hardcoded_columns dbms_sql.varchar2s;
246: -- element_datatypes dbms_sql.number_table;
247: --

Line 244: -- element_names dbms_sql.varchar2s;

240: --
241: -- The elements to be included in the final view.
242: --
243: -- element_ids dbms_sql.number_table;
244: -- element_names dbms_sql.varchar2s;
245: -- element_hardcoded_columns dbms_sql.varchar2s;
246: -- element_datatypes dbms_sql.number_table;
247: --
248: l_element_id NUMBER;

Line 245: -- element_hardcoded_columns dbms_sql.varchar2s;

241: -- The elements to be included in the final view.
242: --
243: -- element_ids dbms_sql.number_table;
244: -- element_names dbms_sql.varchar2s;
245: -- element_hardcoded_columns dbms_sql.varchar2s;
246: -- element_datatypes dbms_sql.number_table;
247: --
248: l_element_id NUMBER;
249: l_element_name qa_chars.name%TYPE;

Line 246: -- element_datatypes dbms_sql.number_table;

242: --
243: -- element_ids dbms_sql.number_table;
244: -- element_names dbms_sql.varchar2s;
245: -- element_hardcoded_columns dbms_sql.varchar2s;
246: -- element_datatypes dbms_sql.number_table;
247: --
248: l_element_id NUMBER;
249: l_element_name qa_chars.name%TYPE;
250: l_element_hardcoded_column qa_chars.hardcoded_column%TYPE;