eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_INDEX_UTIL dependencies on FII_INDEXES

Line 43: rec fii_indexes%rowtype;

39: l_unique varchar2(100) := NULL;
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;

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

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:
49: cursor c2 is select * from dba_indexes where table_name = g_tab_name
50: and TABLE_OWNER = g_owner;
51:

Line 94: -- select count(*) into l_rows from fii_indexes where table_name = g_tab_name;

90: when others then
91: l_index_exists := 0;
92: end;
93:
94: -- select count(*) into l_rows from fii_indexes where table_name = g_tab_name;
95: --Changed above query for Performance bug 4992919
96: begin
97: select 1 into l_rows from fii_indexes where table_name = g_tab_name and rownum = 1;
98: exception

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

93:
94: -- select count(*) into l_rows from fii_indexes where table_name = g_tab_name;
95: --Changed above query for Performance bug 4992919
96: begin
97: select 1 into l_rows from fii_indexes where table_name = g_tab_name and rownum = 1;
98: exception
99: when others then
100: l_rows := 0;
101: end;

Line 126: -- store index names in table fii_indexes

122: FII_UTIL.put_line('');
123: FII_UTIL.put_line(g_debug_msg);
124: END IF;
125:
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';

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

123: FII_UTIL.put_line(g_debug_msg);
124: END IF;
125:
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 (

Line 128: delete from fii_indexes where table_name = g_tab_name;

124: END IF;
125:
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,

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 131: insert into 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
135: )

Line 164: -- update fii_indexes to store the "create index" statements

160: end if;
161: end loop;
162: close c3;
163:
164: -- update fii_indexes to store the "create index" statements
165: g_debug_msg := 'update fii_indexes to store the create index statements';
166:
167: if (rec2.uniqueness = 'UNIQUE') then
168: l_unique := ' unique ';

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

161: end loop;
162: close c3;
163:
164: -- update fii_indexes to store the "create index" statements
165: g_debug_msg := 'update fii_indexes to store the create index statements';
166:
167: if (rec2.uniqueness = 'UNIQUE') then
168: l_unique := ' unique ';
169: else

Line 187: update fii_indexes

183: storage ( INITIAL '|| rec2.initial_extent||' NEXT '||l_next_extent||') tablespace '
184: ||rec2.tablespace_name||' parallel '||parallel_var||' nologging ';
185: end if;
186:
187: update fii_indexes
188: set create_stmt=var3
189: where table_name = g_tab_name
190: and index_name=rec2.index_name;
191:

Line 193: g_debug_msg := 'Index definition saved in fii_indexes';

189: where table_name = g_tab_name
190: and index_name=rec2.index_name;
191:
192: IF l_debug_flag = 'Y' THEN
193: g_debug_msg := 'Index definition saved in fii_indexes';
194: FII_UTIL.put_line('');
195: FII_UTIL.put_line(g_debug_msg);
196: END IF;
197:

Line 205: -- 'U_SNAP$_FII_%' from FII_INDEXES

201:
202: commit;
203:
204: --bug 3152517: delete system-generated index like 'I_SNAP$_FII_%' and
205: -- 'U_SNAP$_FII_%' from FII_INDEXES
206: g_debug_msg := 'delete scripts for system-generated index I_SNAP$_FII_% from FII_INDEXES';
207:
208: delete from FII_INDEXES
209: where table_name = g_tab_name

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

202: commit;
203:
204: --bug 3152517: delete system-generated index like 'I_SNAP$_FII_%' and
205: -- 'U_SNAP$_FII_%' from FII_INDEXES
206: g_debug_msg := 'delete scripts for system-generated index I_SNAP$_FII_% from FII_INDEXES';
207:
208: delete from FII_INDEXES
209: where table_name = g_tab_name
210: and (index_name like 'I_SNAP$_FII_%' OR

Line 208: delete from FII_INDEXES

204: --bug 3152517: delete system-generated index like 'I_SNAP$_FII_%' and
205: -- 'U_SNAP$_FII_%' from FII_INDEXES
206: g_debug_msg := 'delete scripts for system-generated index I_SNAP$_FII_% from FII_INDEXES';
207:
208: delete from FII_INDEXES
209: where table_name = g_tab_name
210: and (index_name like 'I_SNAP$_FII_%' OR
211: index_name like 'U_SNAP$_FII_%');
212:

Line 221: -- drop other indexes in FII_INDEXES

217:
218: --bug 3162509: should commit after the above delete
219: commit;
220:
221: -- drop other indexes in FII_INDEXES
222: open c1;
223: loop
224: fetch c1 into rec;
225: exit when c1%notfound;

Line 264: cursor c1A is select distinct create_stmt from fii_indexes

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
267: where table_name = g_tab_name;
268: cursor c2 is select * from dba_indexes where table_name = g_tab_name

Line 266: cursor c1B is select index_name from fii_indexes

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
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:

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

273: -- create indexes
274:
275: set_table_name(p_table_name, p_owner);
276: begin
277: select 1 into l_rows from fii_indexes where table_name = g_tab_name and rownum = 1;
278: exception
279: when others then
280: l_rows := 0;
281: end;

Line 293: g_debug_msg := 'Create indexes using statements from fii_indexes...';

289: FII_UTIL.put_line(g_debug_msg);
290: END IF;
291: END IF;
292:
293: g_debug_msg := 'Create indexes using statements from fii_indexes...';
294: for r1a in c1A loop
295: var5:=r1a.create_stmt;
296: execute immediate var5;
297: end loop;