APPS.POA_MV_UTILS_PKG dependencies on AD_MV

Line 39: l_data_tablespace := ad_mv.g_mv_data_tablespace;

35: end if;
36: if(p_column_list is not null) then l_column_list := '('||p_column_list||')'; end if;
37:
38: if p_data_tablespace is null then
39: l_data_tablespace := ad_mv.g_mv_data_tablespace;
40: l_index_tablespace := ad_mv.g_mv_index_tablespace;
41: end if;
42:
43: EXECUTE IMMEDIATE

Line 40: l_index_tablespace := ad_mv.g_mv_index_tablespace;

36: if(p_column_list is not null) then l_column_list := '('||p_column_list||')'; end if;
37:
38: if p_data_tablespace is null then
39: l_data_tablespace := ad_mv.g_mv_data_tablespace;
40: l_index_tablespace := ad_mv.g_mv_index_tablespace;
41: end if;
42:
43: EXECUTE IMMEDIATE
44: ' create materialized view log on '||p_base_table||

Line 108: l_data_tablespace := ad_mv.g_mv_data_tablespace;

104: PARTITION day VALUES (14) PCTFREE 10 PCTUSED 80 '||l_storage||'
105: ) ';
106: end if;
107:
108: l_data_tablespace := ad_mv.g_mv_data_tablespace;
109: l_index_tablespace := ad_mv.g_mv_index_tablespace;
110:
111: /*
112: l_query := 'create materialized view '||p_mv_name|| '

Line 109: l_index_tablespace := ad_mv.g_mv_index_tablespace;

105: ) ';
106: end if;
107:
108: l_data_tablespace := ad_mv.g_mv_data_tablespace;
109: l_index_tablespace := ad_mv.g_mv_index_tablespace;
110:
111: /*
112: l_query := 'create materialized view '||p_mv_name|| '
113: TABLESPACE '||l_data_tablespace||'

Line 142: ad_mv.create_mv(p_mv_name, l_query);

138: l_enable_qrewrite||' QUERY REWRITE '||
139: ' as '||
140: p_mv_sql;
141:
142: ad_mv.create_mv(p_mv_name, l_query);
143:
144: exception
145: when MV_EXISTS then null;
146: end create_MV;

Line 182: l_data_tablespace := ad_mv.g_mv_data_tablespace;

178: end if;
179:
180: l_storage := 'storage(INITIAL 4K NEXT '||p_next_extent||' MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0)';
181:
182: l_data_tablespace := ad_mv.g_mv_data_tablespace;
183: l_index_tablespace := ad_mv.g_mv_index_tablespace;
184:
185:
186: l_query :=

Line 183: l_index_tablespace := ad_mv.g_mv_index_tablespace;

179:
180: l_storage := 'storage(INITIAL 4K NEXT '||p_next_extent||' MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0)';
181:
182: l_data_tablespace := ad_mv.g_mv_data_tablespace;
183: l_index_tablespace := ad_mv.g_mv_index_tablespace;
184:
185:
186: l_query :=
187: ' create materialized view '||p_mv_name||

Line 201: ad_mv.create_mv(p_mv_name, l_query);

197: l_enable_qrewrite||' QUERY REWRITE '||
198: ' as '||
199: p_mv_sql;
200:
201: ad_mv.create_mv(p_mv_name, l_query);
202:
203: exception
204: when MV_EXISTS then null;
205: end create_part_MV;

Line 233: l_data_tablespace := ad_mv.g_mv_data_tablespace;

229: elsif(p_partition_type = 'G') then
230: l_partition_clause := ' GLOBAL ';
231: end if;
232:
233: l_data_tablespace := ad_mv.g_mv_data_tablespace;
234: l_index_tablespace := ad_mv.g_mv_index_tablespace;
235:
236: execute immediate
237: ' create '||l_unique||l_index_type||' index '||p_ind_name||' ON '||p_mv_name ||'('||p_ind_col_list||') '||

Line 234: l_index_tablespace := ad_mv.g_mv_index_tablespace;

230: l_partition_clause := ' GLOBAL ';
231: end if;
232:
233: l_data_tablespace := ad_mv.g_mv_data_tablespace;
234: l_index_tablespace := ad_mv.g_mv_index_tablespace;
235:
236: execute immediate
237: ' create '||l_unique||l_index_type||' index '||p_ind_name||' ON '||p_mv_name ||'('||p_ind_col_list||') '||
238: ' tablespace '||l_index_tablespace||l_partition_clause||