APPS.BIS_BIA_RSG_INDEX_MGMT dependencies on ALL_INDEXES

Line 129: l_schema all_indexes.owner%type;

125: l_stmt varchar2(32767);
126: TYPE curType IS REF CURSOR ;
127: c_all_index_details curType;
128: l_index_name bis_obj_indexes.index_name%type;
129: l_schema all_indexes.owner%type;
130: l_ddl clob;
131: begin
132: -- added to remove GSCC warning File.Sql.35
133: l_mv_index_handle := null;

Line 150: '(select index_name , OWNER from all_indexes where table_name = :1 and owner = :2)';

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
154: fetch c_all_index_details into l_index_name, l_schema, l_ddl;

Line 266: WRITELOG('All indexes for the MV '||l_mv_name||' already existed in the system');

262: If(count_created =0 and count_exists =0) then
263: WRITELOG('No Index has been created, As there is no index associated for');
264: WRITELOG(' given MV '|| l_mv_name);
265: else If (count_exists >0 and count_created =0) then
266: WRITELOG('All indexes for the MV '||l_mv_name||' already existed in the system');
267: WRITELOG('so no indexes were recreated');
268: end if;
269: end if;
270: WRITELOG('************************************');