APPS.QLTVCREB dependencies on AD_DDL

Line 16: -- AD_DDL.DO_ARRAY_DDL.

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
19: --
20:

Line 88: -- Execute a data definition statement by using the AD_DDL.DO_ARRAY_DDL

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:
92: --

Line 96: -- string. Thus, we have been calling ad_ddl.build_statement a

92: --
93: -- Bug 3756235
94: -- This is a performance fix. A global view usually has tens of
95: -- thousands of "statements" because each statement(i) is a short
96: -- string. Thus, we have been calling ad_ddl.build_statement a
97: -- lot. The no. of calls can be reduced 10-fold if we concat the
98: -- shorter strings into a long one before invoking the API.
99: --
100: -- 255 is the current max size of build_statement's input param.

Line 129: AD_DDL.build_statement(s, n);

125: -- vvs BUG 4129987 Wed Mar 2 04:48:07 PST 2005
126: --
127: IF nvl(lengthb(s), 0) + nvl(lengthb(statement(i)), 0) + 1 > max_size THEN
128: n := n + 1;
129: AD_DDL.build_statement(s, n);
130: s := '';
131: END IF;
132:
133: s := s || statement(i) || ' ';

Line 142: AD_DDL.build_statement(s, n);

138: -- we will always have a final "s" to process here.
139: -- bso Sat Jul 24 16:17:15 PDT 2004
140: --
141: n := n + 1;
142: AD_DDL.build_statement(s, n);
143:
144: AD_DDL.do_array_ddl(schema, shortname, cmd, 1, n, name);
145: END;
146:

Line 144: AD_DDL.do_array_ddl(schema, shortname, cmd, 1, n, name);

140: --
141: n := n + 1;
142: AD_DDL.build_statement(s, n);
143:
144: AD_DDL.do_array_ddl(schema, shortname, cmd, 1, n, name);
145: END;
146:
147:
148: FUNCTION trans(name VARCHAR2) RETURN VARCHAR2 IS

Line 165: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.drop_view,

161:
162:
163: PROCEDURE drop_view(x VARCHAR2) IS
164: BEGIN
165: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.drop_view,
166: 'DROP VIEW "' || upper(x) || '"', x);
167: EXCEPTION WHEN OTHERS THEN
168: NULL;
169: END drop_view;

Line 607: -- Find apps schema info. To be used in ad_ddl calls.

603: create_clause(v_sql_table, v_from_table, 'FROM');
604: create_clause(v_sql_table, v_where_table, 'WHERE');
605:
606: --
607: -- Find apps schema info. To be used in ad_ddl calls.
608: --
609: exec_ddl_table(g_schema, 'QA', AD_DDL.create_view, v_sql_table, x_view_name);
610:
611: END global_view;

Line 609: exec_ddl_table(g_schema, 'QA', AD_DDL.create_view, v_sql_table, x_view_name);

605:
606: --
607: -- Find apps schema info. To be used in ad_ddl calls.
608: --
609: exec_ddl_table(g_schema, 'QA', AD_DDL.create_view, v_sql_table, x_view_name);
610:
611: END global_view;
612:
613: --

Line 953: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, v_final,

949: -- Building the final query for the deref view
950: --
951: v_deref_view_final := v_deref_view_create || v_select || v_from || v_deref_view_where;
952:
953: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, v_final,
954: x_view_name);
955:
956: --
957: -- bug 6350575

Line 961: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, v_deref_view_final,

957: -- bug 6350575
958: -- 12.1 QWB Usability Improvements
959: -- Creating the deref view
960: --
961: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, v_deref_view_final,
962: v_deref_view_name);
963:
964: --
965: -- bug 6350575

Line 1099: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, v_select,

1095: END LOOP;
1096:
1097: v_select := v_select || ' FROM QA_RESULTS_INTERFACE';
1098:
1099: ad_ddl.do_ddl(g_schema, 'QA', ad_ddl.create_view, v_select,
1100: x_view_name);
1101:
1102: --
1103: -- bug 7409976