APPS.BIL_BI_OPTY_MV_REFRESH_PKG dependencies on BIL_BI_INDEX_MGMT

Line 123: DELETE FROM BIL_BI_INDEX_MGMT WHERE table_name = p_obj_name;

119:
120: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('starting the before loop');
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)

Line 127: INSERT INTO BIL_BI_INDEX_MGMT (table_name,index_name,ddl_stmnt)

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;
130:
131: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG(' dropped this index :'||i.index_name);

Line 139: FOR i in (SELECT table_name,index_name,ddl_stmnt FROM BIL_BI_INDEX_MGMT WHERE table_name = p_obj_name)

135: P_DB_VERSION <= 9) THEN
136:
137: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('starting the after loop');
138:
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;

Line 160: DELETE FROM BIL_BI_INDEX_MGMT WHERE table_name = p_obj_name AND index_name = i.index_name;

156: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('recreated the index:'||i.index_name);
157: END IF;
158:
159: -- Delete the entry from bim_all_indexes table for the index in context
160: DELETE FROM BIL_BI_INDEX_MGMT WHERE table_name = p_obj_name AND index_name = i.index_name;
161:
162: COMMIT;
163:
164: l_idx_present := 1;