APPS.OKI_DBI_MV_UTIL_PVT dependencies on AD_MV

Line 56: l_data_tablespace := ad_mv.g_mv_data_tablespace;

52: END IF ;
53:
54: IF p_data_tablespace IS NULL THEN
55:
56: l_data_tablespace := ad_mv.g_mv_data_tablespace;
57: l_index_tablespace := ad_mv.g_mv_index_tablespace;
58:
59: END IF ;
60:

Line 57: l_index_tablespace := ad_mv.g_mv_index_tablespace;

53:
54: IF p_data_tablespace IS NULL THEN
55:
56: l_data_tablespace := ad_mv.g_mv_data_tablespace;
57: l_index_tablespace := ad_mv.g_mv_index_tablespace;
58:
59: END IF ;
60:
61:

Line 153: l_data_tablespace := ad_mv.g_mv_data_tablespace;

149: ) ';
150: END IF;
151:
152:
153: l_data_tablespace := ad_mv.g_mv_data_tablespace;
154: l_index_tablespace := ad_mv.g_mv_index_tablespace;
155:
156: l_sql :=
157: ' CREATE MATERIALIZED VIEW ' || p_mv_name ||

Line 154: l_index_tablespace := ad_mv.g_mv_index_tablespace;

150: END IF;
151:
152:
153: l_data_tablespace := ad_mv.g_mv_data_tablespace;
154: l_index_tablespace := ad_mv.g_mv_index_tablespace;
155:
156: l_sql :=
157: ' CREATE MATERIALIZED VIEW ' || p_mv_name ||
158: ' TABLESPACE ' || l_data_tablespace ||

Line 171: ad_mv.create_mv(p_mv_name, l_sql);

167: l_enable_qrewrite || ' QUERY REWRITE ' ||
168: ' AS ' ||
169: p_mv_sql ;
170:
171: ad_mv.create_mv(p_mv_name, l_sql);
172:
173: EXCEPTION
174: WHEN mv_exists THEN
175: NULL ;

Line 223: l_data_tablespace := ad_mv.g_mv_data_tablespace;

219: ELSIF (p_partition_type = 'G') THEN
220: l_partition_clause := ' GLOBAL ' ;
221: END IF ;
222:
223: l_data_tablespace := ad_mv.g_mv_data_tablespace;
224: l_index_tablespace := ad_mv.g_mv_index_tablespace;
225:
226: EXECUTE IMMEDIATE
227: ' CREATE ' || l_unique || l_index_type || ' index ' || p_ind_name||

Line 224: l_index_tablespace := ad_mv.g_mv_index_tablespace;

220: l_partition_clause := ' GLOBAL ' ;
221: END IF ;
222:
223: l_data_tablespace := ad_mv.g_mv_data_tablespace;
224: l_index_tablespace := ad_mv.g_mv_index_tablespace;
225:
226: EXECUTE IMMEDIATE
227: ' CREATE ' || l_unique || l_index_type || ' index ' || p_ind_name||
228: ' ON ' || p_mv_name || '(' || p_ind_col_list || ' ) ' ||