APPS.FII_INDEX_UTIL dependencies on DBA_INDEXES

Line 44: rec2 dba_indexes%rowtype;

40:
41: parallel_var number:=0;
42:
43: rec fii_indexes%rowtype;
44: rec2 dba_indexes%rowtype;
45: rec3 dba_ind_columns%rowtype;
46:
47: cursor c1 is select * from fii_indexes where table_name = g_tab_name;
48:

Line 49: cursor c2 is select * from dba_indexes where table_name = g_tab_name

45: rec3 dba_ind_columns%rowtype;
46:
47: cursor c1 is select * from fii_indexes where table_name = g_tab_name;
48:
49: cursor c2 is select * from dba_indexes where table_name = g_tab_name
50: and TABLE_OWNER = g_owner;
51:
52: cursor c3 (ind_name varchar2) is select * from dba_ind_columns
53: where index_name = ind_name

Line 75: /* select count(*) into l_index_exists from dba_indexes

71: FII_UTIL.put_line(g_debug_msg);
72: END IF;
73:
74: -- bug 4177221: added filter for SNAP$ indexes
75: /* select count(*) into l_index_exists from dba_indexes
76: where table_name = g_tab_name
77: and TABLE_OWNER = g_owner
78: and index_name not like 'I_SNAP$_FII_%'
79: and index_name not like 'U_SNAP$_FII_%';*/

Line 83: select 1 into l_index_exists from dba_indexes

79: and index_name not like 'U_SNAP$_FII_%';*/
80:
81: --Changed above query for Performance bug 4992919
82: begin
83: select 1 into l_index_exists from dba_indexes
84: where table_name = g_tab_name
85: and TABLE_OWNER = g_owner
86: and index_name not like 'I_SNAP$_FII_%'
87: and index_name not like 'U_SNAP$_FII_%'

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

126: -- store index names in table fii_indexes
127: g_debug_msg := 'First, delete from fii_indexes for ' || g_tab_name;
128: delete from fii_indexes where table_name = g_tab_name;
129:
130: g_debug_msg := 'Then, insert into fii_indexes for ' || g_tab_name || ' from dba_indexes';
131: insert into fii_indexes (
132: TABLE_NAME, INDEX_NAME, CREATE_STMT,
133: CREATION_DATE, CREATED_BY,
134: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN

Line 137: from dba_indexes

133: CREATION_DATE, CREATED_BY,
134: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
135: )
136: select g_tab_name, index_name, null, sysdate, -1, sysdate, -1, -1
137: from dba_indexes
138: where table_name = g_tab_name
139: and TABLE_OWNER = g_owner;
140:
141: -- form "create index" statements

Line 262: rec2 dba_indexes%rowtype;

258: var5 varchar2(2000) := NULL;
259:
260: l_counter number:=0;
261: Errbuf VARCHAR2(200);
262: rec2 dba_indexes%rowtype;
263:
264: cursor c1A is select distinct create_stmt from fii_indexes
265: where table_name = g_tab_name;
266: cursor c1B is select index_name from fii_indexes

Line 268: cursor c2 is select * from dba_indexes where table_name = g_tab_name

264: cursor c1A is select distinct create_stmt from fii_indexes
265: where table_name = g_tab_name;
266: cursor c1B is select index_name from fii_indexes
267: where table_name = g_tab_name;
268: cursor c2 is select * from dba_indexes where table_name = g_tab_name
269: and TABLE_OWNER = g_owner;
270:
271: begin
272: