APPS.BIS_BIA_RSG_INDEX_MGMT dependencies on AD_DBMS_METADATA

Line 147: --l_mv_index_handle := sys.ad_dbms_metadata.get_dependent_ddl('INDEX',p_mv_name, p_mv_schema);

143: setTimer(l_time);
144:
145: WRITELOG('Capturing MV Index for ' || form_triplet(p_mv_name, p_mv_schema, null));
146: -- bug#4704403
147: --l_mv_index_handle := sys.ad_dbms_metadata.get_dependent_ddl('INDEX',p_mv_name, p_mv_schema);
148:
149: l_stmt := 'SELECT INDEX_NAME, OWNER, TO_CHAR(sys.ad_dbms_metadata.GET_DDL(''INDEX'',INDEX_NAME,OWNER)) FROM '||
150: '(select index_name , OWNER from all_indexes where table_name = :1 and owner = :2)';
151:

Line 149: l_stmt := 'SELECT INDEX_NAME, OWNER, TO_CHAR(sys.ad_dbms_metadata.GET_DDL(''INDEX'',INDEX_NAME,OWNER)) FROM '||

145: WRITELOG('Capturing MV Index for ' || form_triplet(p_mv_name, p_mv_schema, null));
146: -- bug#4704403
147: --l_mv_index_handle := sys.ad_dbms_metadata.get_dependent_ddl('INDEX',p_mv_name, p_mv_schema);
148:
149: l_stmt := 'SELECT INDEX_NAME, OWNER, TO_CHAR(sys.ad_dbms_metadata.GET_DDL(''INDEX'',INDEX_NAME,OWNER)) FROM '||
150: '(select index_name , OWNER from all_indexes where table_name = :1 and owner = :2)';
151:
152: open c_all_index_details for l_stmt using p_mv_name, p_mv_schema;
153: loop

Line 248: temp_index_ddl:= to_char(sys.ad_dbms_metadata.get_ddl('INDEX',l_index_name));

244: if l_index_ddl is not null /*and l_index_ddl <> ''*/ then
245: BEGIN
246: logTime( 'Checking for existence of ' || l_index_name, l_time);
247: -- bug#4704403
248: temp_index_ddl:= to_char(sys.ad_dbms_metadata.get_ddl('INDEX',l_index_name));
249: logTime( 'Index exists ' || l_index_name, l_time);
250: count_exists := count_exists + 1; -- bug 4284095
251: EXCEPTION WHEN OTHERS THEN --Index doesnt exists already . We can recreate now without ORA error.
252: logTime( 'index does not exist, recreating index ' || l_index_name, l_time);