APPS.QA_CHAR_INDEXES_PKG dependencies on DBMS_SQL

Line 164: x_function OUT NOCOPY dbms_sql.varchar2s,

160: FUNCTION construct_decode_function(
161: p_char_id NUMBER,
162: p_alias VARCHAR2,
163: x_most_common OUT NOCOPY VARCHAR2,
164: x_function OUT NOCOPY dbms_sql.varchar2s,
165: p_process_num_decode IN BOOLEAN DEFAULT FALSE)
166: RETURN INTEGER IS
167:
168: --

Line 182: -- procedure in qltvcreb and utilized the same dbms_sql.varchar2s

178: --
179: -- Return 0 if successful; a negative error code otherwise.
180: --
181: -- Note: this function was modeled after the global_view
182: -- procedure in qltvcreb and utilized the same dbms_sql.varchar2s
183: -- array. It can potentially handle more than 32K, but the
184: -- current scope is to handle decode function of 32K or less
185: -- to make other PL/SQL manipulation of this function string
186: -- more manageable. Expansion to > 32K is non-trivial because

Line 360: p_function dbms_sql.varchar2s,

356: END construct_decode_function;
357:
358:
359: FUNCTION varchar2s_to_varchar2(
360: p_function dbms_sql.varchar2s,
361: x_ddl OUT NOCOPY VARCHAR2)
362: RETURN INTEGER IS
363: --
364: -- A helper function to convert the decode function string from

Line 365: -- dbms_sql.varchar2 format to a simple string. Return 0 if

361: x_ddl OUT NOCOPY VARCHAR2)
362: RETURN INTEGER IS
363: --
364: -- A helper function to convert the decode function string from
365: -- dbms_sql.varchar2 format to a simple string. Return 0 if
366: -- successful; -1 if not.
367: --
368: l_ddl VARCHAR2(32767);
369: BEGIN

Line 393: l_function dbms_sql.varchar2s;

389: FUNCTION get_case_function(p_char_id IN VARCHAR2, p_alias in VARCHAR2, x_case_func OUT NOCOPY VARCHAR2)
390: RETURN INTEGER AS
391: l_case_func VARCHAR2(32767);
392:
393: l_function dbms_sql.varchar2s;
394: l_status INTEGER;
395: l_alias_dot VARCHAR2(50);
396: l_most_common VARCHAR2(30);
397: l_rowid VARCHAR2(50);

Line 449: l_function dbms_sql.varchar2s;

445: -- Create the softcoded index.
446: -- Return 0 if successful, a negative error code if not.
447: --
448: l_ddl VARCHAR2(32767); -- current scope supports 32k only
449: l_function dbms_sql.varchar2s;
450: l_status INTEGER;
451: l_alias_dot VARCHAR2(50);
452: l_most_common VARCHAR2(30);
453: l_rowid VARCHAR2(50);

Line 973: l_function dbms_sql.varchar2s;

969: p_alias VARCHAR2 DEFAULT NULL)
970: RETURN VARCHAR2 IS
971:
972: l_most_common VARCHAR2(30);
973: l_function dbms_sql.varchar2s;
974: l_predicate VARCHAR2(32767);
975: l_status NUMBER;
976:
977: BEGIN