APPS.BIL_BI_OPTY_MV_REFRESH_PKG dependencies on USER_INDEXES

Line 125: FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)

121:
122: -- Delete the entry from table for the index in context
123: DELETE FROM BIL_BI_INDEX_MGMT WHERE table_name = p_obj_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;

Line 143: FROM user_indexes WHERE table_name=p_obj_name AND index_name=i.index_name;

139: FOR i in (SELECT table_name,index_name,ddl_stmnt FROM BIL_BI_INDEX_MGMT WHERE table_name = p_obj_name)
140: LOOP
141: -- Check for existance of the index
142: SELECT count(*) INTO l_idx_present
143: FROM user_indexes WHERE table_name=p_obj_name AND index_name=i.index_name;
144: -- Create index if is not existing in the DB
145:
146: IF l_idx_present <> 1 THEN
147: L_DYNAMIC_STMNT := REPLACE(REPLACE(replace(replace(replace(i.ddl_stmnt,'NOPARALLEL',' '),

Line 205: FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)

201: IF P_DB_VERSION > 9 THEN
202: EXECUTE IMMEDIATE 'alter session set "_idxrb_rowincr"=1000';
203: END IF;
204:
205: FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)
206: LOOP
207: EXECUTE IMMEDIATE 'ALTER INDEX '||i.index_name|| ' parallel';
208: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG(' altered index ' || i.index_name || ' parallel');
209: END LOOP;

Line 213: FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)

209: END LOOP;
210:
211:
212: ELSIF (P_MODE = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_AFTER) THEN
213: FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)
214: LOOP
215: EXECUTE IMMEDIATE 'ALTER INDEX '||i.index_name|| ' noparallel';
216: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG(' altered index ' || i.index_name || ' noparallel');
217: END LOOP;