APPS.BIL_BI_OPTY_MV_REFRESH_PKG SQL Statements

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

Line: 38

       select version into db_version from v$instance;

Line: 123

        DELETE FROM BIL_BI_INDEX_MGMT WHERE table_name = p_obj_name;

Line: 125

      FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)
      LOOP
        INSERT INTO BIL_BI_INDEX_MGMT (table_name,index_name,ddl_stmnt)
        VALUES (P_OBJ_NAME,i.INDEX_NAME,DBMS_METADATA.GET_DDL('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)
      LOOP
        -- Check for existance of the index
        SELECT count(*) INTO l_idx_present
        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;

Line: 205

         FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)
	 LOOP
	  EXECUTE IMMEDIATE 'ALTER INDEX '||i.index_name|| ' parallel';

Line: 213

  	 FOR i IN (SELECT index_name FROM user_indexes WHERE table_name=P_OBJ_NAME)
	 LOOP
	  EXECUTE IMMEDIATE 'ALTER INDEX '||i.index_name|| ' noparallel';