APPS.FII_INDEX_UTIL SQL Statements

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

Line: 47

cursor c1 is select * from fii_indexes where table_name = g_tab_name;

Line: 49

cursor c2 is select * from dba_indexes where table_name  = g_tab_name
                                         and TABLE_OWNER = g_owner;

Line: 52

cursor c3 (ind_name varchar2) is select * from dba_ind_columns
                                  where index_name  = ind_name
                                     and INDEX_OWNER = g_owner
				    ORDER BY column_position;

Line: 75

   /*  select count(*) into l_index_exists from dba_indexes
      where table_name  = g_tab_name
        and TABLE_OWNER = g_owner
		and index_name not like 'I_SNAP$_FII_%'
		and index_name not like 'U_SNAP$_FII_%';*/

Line: 83

		 select 1 into l_index_exists from dba_indexes
     where table_name  = g_tab_name
     and TABLE_OWNER = g_owner
		 and index_name not like 'I_SNAP$_FII_%'
		 and index_name not like 'U_SNAP$_FII_%'
		 and rownum = 1;

Line: 97

		 select 1 into l_rows from fii_indexes where table_name = g_tab_name and rownum = 1;

Line: 127

       g_debug_msg := 'First, delete from fii_indexes for ' || g_tab_name;

Line: 128

        delete from fii_indexes where table_name = g_tab_name;

Line: 130

       g_debug_msg := 'Then, insert into fii_indexes for ' || g_tab_name || ' from dba_indexes';

Line: 131

        insert into fii_indexes (
		TABLE_NAME, INDEX_NAME, CREATE_STMT,
		CREATION_DATE, CREATED_BY,
		LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
	)
        select g_tab_name, index_name, null, sysdate, -1, sysdate, -1, -1
          from dba_indexes
         where table_name  = g_tab_name
           and TABLE_OWNER = g_owner;

Line: 165

         g_debug_msg := 'update fii_indexes to store the create index statements';

Line: 187

             update fii_indexes
                set create_stmt=var3
              where table_name = g_tab_name
                and index_name=rec2.index_name;

Line: 206

     g_debug_msg := 'delete scripts for system-generated index I_SNAP$_FII_% from FII_INDEXES';

Line: 208

     delete from FII_INDEXES
      where table_name = g_tab_name
        and (index_name like 'I_SNAP$_FII_%' OR
             index_name like 'U_SNAP$_FII_%');

Line: 264

  cursor c1A is select distinct create_stmt from fii_indexes
                where table_name = g_tab_name;

Line: 266

  cursor c1B is select index_name from fii_indexes
                where table_name = g_tab_name;

Line: 268

  cursor c2 is select * from dba_indexes where table_name  = g_tab_name
                                           and TABLE_OWNER = g_owner;

Line: 277

        select 1 into l_rows from fii_indexes where table_name = g_tab_name and rownum = 1;