APPS.BIM_DBI_SCM_RSG_API_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

    SELECT index_name
    FROM   user_indexes
    WHERE  table_name = p_obj_name
    AND    index_name = nvl(p_ind_name,index_name) ;

Line: 13

    SELECT index_name , column_name
    FROM   bim_all_indexes
    WHERE  table_name = p_obj_name
    AND    index_name = nvl(p_ind_name,index_name) ;

Line: 28

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

Line: 34

       INSERT INTO bim_all_indexes (INDEX_NAME,TABLE_NAME,COLUMN_NAME)
         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

Line: 61

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

Line: 62

         BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('MetaData Information Deleted for Index -'||i.index_name);

Line: 87

 SELECT substr(version,1,1) ver
 FROM   v$instance;