APPS.BIL_BI_OPTY_MV_REFRESH_PKG dependencies on DBMS_METADATA

Line 128: VALUES (P_OBJ_NAME,i.INDEX_NAME,DBMS_METADATA.GET_DDL('INDEX',i.index_name));

124:
125: FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)
126: LOOP
127: INSERT INTO BIL_BI_INDEX_MGMT (table_name,index_name,ddl_stmnt)
128: VALUES (P_OBJ_NAME,i.INDEX_NAME,DBMS_METADATA.GET_DDL('INDEX',i.index_name));
129: EXECUTE IMMEDIATE 'DROP INDEX '||i.index_name;
130:
131: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG(' dropped this index :'||i.index_name);
132: