APPS.BIM_DBI_SCM_RSG_API_PVT dependencies on BIM_ALL_INDEXES

Line 14: FROM bim_all_indexes

10: AND index_name = nvl(p_ind_name,index_name) ;
11:
12: CURSOR c_val_indexes (p_obj_name VARCHAR2,p_ind_name VARCHAR2)IS
13: SELECT index_name , column_name
14: FROM bim_all_indexes
15: WHERE table_name = p_obj_name
16: AND index_name = nvl(p_ind_name,index_name) ;
17:
18: l_ind_val VARCHAR2(30);

Line 24: -- Delete the entry from bim_all_indexes if the earlier entry for index was not deleted.

20: BEGIN -- Manage_bim_Index
21:
22: IF (p_mode = 'BEFORE') THEN
23:
24: -- Delete the entry from bim_all_indexes if the earlier entry for index was not deleted.
25: FOR i in c_obj_indexes (p_obj_name,null) LOOP
26: FOR j in c_val_indexes (p_obj_name,i.index_name) LOOP
27: -- Delete the entry from bim_all_indexes table for the index in context
28: execute immediate ('DELETE FROM bim_all_indexes where table_name = '||''''||p_obj_name||''''||' and index_name = '||''''||j.index_name||'''');

Line 27: -- Delete the entry from bim_all_indexes table for the index in context

23:
24: -- Delete the entry from bim_all_indexes if the earlier entry for index was not deleted.
25: FOR i in c_obj_indexes (p_obj_name,null) LOOP
26: FOR j in c_val_indexes (p_obj_name,i.index_name) LOOP
27: -- Delete the entry from bim_all_indexes table for the index in context
28: execute immediate ('DELETE FROM bim_all_indexes where table_name = '||''''||p_obj_name||''''||' and index_name = '||''''||j.index_name||'''');
29: END LOOP;
30: END LOOP;
31:

Line 28: execute immediate ('DELETE FROM bim_all_indexes where table_name = '||''''||p_obj_name||''''||' and index_name = '||''''||j.index_name||'''');

24: -- Delete the entry from bim_all_indexes if the earlier entry for index was not deleted.
25: FOR i in c_obj_indexes (p_obj_name,null) LOOP
26: FOR j in c_val_indexes (p_obj_name,i.index_name) LOOP
27: -- Delete the entry from bim_all_indexes table for the index in context
28: execute immediate ('DELETE FROM bim_all_indexes where table_name = '||''''||p_obj_name||''''||' and index_name = '||''''||j.index_name||'''');
29: END LOOP;
30: END LOOP;
31:
32:

Line 34: INSERT INTO bim_all_indexes (INDEX_NAME,TABLE_NAME,COLUMN_NAME)

30: END LOOP;
31:
32:
33: FOR i in c_obj_indexes(p_obj_name,null) LOOP
34: INSERT INTO bim_all_indexes (INDEX_NAME,TABLE_NAME,COLUMN_NAME)
35: VALUES (i.index_name,p_obj_name,REPLACE(DBMS_METADATA.GET_DDL('INDEX',i.index_name),'COMPUTE STATISTICS',NULL)||' NOLOGGING PARALLEL'); -- Log the index ddl syntax
36: execute immediate ('drop index '||i.index_name); -- drop the index
37: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('MetaData Information Recorded and Index Dropped for Index :'||i.index_name);
38: END LOOP;

Line 60: -- Delete the entry from bim_all_indexes table for the index in context

56: execute immediate ('ALTER INDEX '||i.index_name||' LOGGING NOPARALLEL');
57: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Index '||i.index_name||' created on '||p_obj_name);
58: END IF;
59:
60: -- Delete the entry from bim_all_indexes table for the index in context
61: execute immediate ('DELETE FROM bim_all_indexes where table_name = '||''''||p_obj_name||''''||' and index_name = '||''''||i.index_name||'''');
62: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('MetaData Information Deleted for Index -'||i.index_name);
63:
64: END LOOP;

Line 61: execute immediate ('DELETE FROM bim_all_indexes where table_name = '||''''||p_obj_name||''''||' and index_name = '||''''||i.index_name||'''');

57: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Index '||i.index_name||' created on '||p_obj_name);
58: END IF;
59:
60: -- Delete the entry from bim_all_indexes table for the index in context
61: execute immediate ('DELETE FROM bim_all_indexes where table_name = '||''''||p_obj_name||''''||' and index_name = '||''''||i.index_name||'''');
62: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('MetaData Information Deleted for Index -'||i.index_name);
63:
64: END LOOP;
65: