APPS.BIS_BIA_RSG_LOG_MGMNT dependencies on AD_DBMS_METADATA

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

289: l_ddl CLOB;
290: l_count NUMBER;
291: begin
292: l_count := 0;
293: l_stmt := 'SELECT INDEX_NAME, OWNER, TO_CHAR(sys.ad_dbms_metadata.GET_DDL(''INDEX'',INDEX_NAME,OWNER)) FROM '||
294: '(select index_name , OWNER from all_indexes where table_name = :1 and owner = :2)';
295:
296: open c_mv_log_index for l_stmt USING p_mv_log_name, p_mv_log_schema;
297: loop

Line 331: :snapshot_log_sql_handle := sys.ad_dbms_metadata.get_dependent_ddl(

327: l_time date;
328: l_length number := 0;
329: --bug#4704403
330: l_stmt varchar2(1000) := 'BEGIN
331: :snapshot_log_sql_handle := sys.ad_dbms_metadata.get_dependent_ddl(
332: ''MATERIALIZED_VIEW_LOG'',
333: :p_base_object_name,
334: :p_base_object_schema
335: ); END;

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

545: fetch c_mv_log_index into l_index_name, l_index_ddl;
546: exit when c_mv_log_index%NOTFOUND;
547: IF (l_index_ddl IS NOT NULL) THEN
548: BEGIN
549: temp_index_ddl:= to_char(sys.ad_dbms_metadata.get_ddl('INDEX',l_index_name));
550: EXCEPTION WHEN OTHERS THEN --Index doesnt exists already . We can recreate now without ORA error.
551: execute immediate l_index_ddl;
552: l_count := l_count + 1;
553: WRITELOG('Recreated Index ' || l_index_name || ' on MVLog ' || form_triplet(p_mv_log_name, P_mv_log_schema, 'MVLog') );