APPS.BIM_UTL_PKG dependencies on ALL_INDEXES

Line 121: the index name and other information into bim_all_indexes. */

117: fnd_file.put_line(fnd_file.log,fnd_message.get);
118: END LOG_HISTORY;
119:
120: /* This procedure will drop the indexes of table p_table_name, and put
121: the index name and other information into bim_all_indexes. */
122: PROCEDURE DROP_INDEX
123: ( p_table_name IN VARCHAR2
124: )
125: IS

Line 180: FROM all_ind_columns b, all_indexes a

176: SELECT a.owner,a.index_name,b.table_name,a.uniqueness,b.column_name,
177: b.column_position,a.pct_free,a.ini_trans,a.max_trans,
178: a.initial_extent,a.next_extent,a.min_extents,a.max_extents,
179: a.pct_increase
180: FROM all_ind_columns b, all_indexes a
181: WHERE a.index_name = b.index_name
182: AND a.owner = l_schema
183: AND a.owner = b.index_owner
184: AND b.table_name =upper(p_name)

Line 189: FROM bim_all_indexes

185: ORDER BY a.index_name,b.column_position;
186:
187: CURSOR index_count(p_name VARCHAR2) IS
188: SELECT count(*)
189: FROM bim_all_indexes
190: WHERE table_name =upper(p_name);
191:
192: BEGIN
193:

Line 199: /* Check whether there is already entried in bim_all_indexes. */

195: OPEN get_ts_name;
196: FETCH get_ts_name INTO l_def_tablespace, l_index_tablespace, l_oracle_username;
197: CLOSE get_ts_name;
198:
199: /* Check whether there is already entried in bim_all_indexes. */
200: OPEN index_count(p_table_name);
201: FETCH index_count into l_count;
202: CLOSE index_count;
203:

Line 204: /* Only if there is no entries in table bim_all_indexes, otherwise it means

200: OPEN index_count(p_table_name);
201: FETCH index_count into l_count;
202: CLOSE index_count;
203:
204: /* Only if there is no entries in table bim_all_indexes, otherwise it means
205: that the indexes are already dropped. */
206: IF l_count = 0 THEN
207:
208: /* Retrieve and store INDEX parameters. Then drop the indexes */

Line 238: /* Insert the indexes parameters into bim_all_indexes. */

234: ams_utility_pvt.write_conc_log('error dropping index:'||sqlerrm(sqlcode));
235: END;
236: END LOOP;
237: --dbms_output.put_line('I:'||i);
238: /* Insert the indexes parameters into bim_all_indexes. */
239:
240: j:=1;
241: WHILE(j 242: -- dbms_output.put_line('index name:'||l_index_name(j));

Line 253: INSERT into bim_all_indexes (

249: IF (l_uniqueness(j) ='UNIQUE' ) THEN
250: is_unique := l_uniqueness(j);
251: ELSE is_unique:='';
252: END IF;
253: INSERT into bim_all_indexes (
254: owner
255: ,index_name
256: ,table_name
257: ,column_name

Line 323: FROM bim_all_indexes

319: ,next_extent
320: ,min_extents
321: ,max_extents
322: ,pct_increase
323: FROM bim_all_indexes
324: WHERE table_name =UPPER(p_name);
325:
326: CURSOR index_count(p_name VARCHAR2) IS
327: SELECT count(*)

Line 328: FROM bim_all_indexes

324: WHERE table_name =UPPER(p_name);
325:
326: CURSOR index_count(p_name VARCHAR2) IS
327: SELECT count(*)
328: FROM bim_all_indexes
329: WHERE table_name =upper(p_name);
330: BEGIN
331: OPEN index_count(p_table_name);
332: FETCH index_count into l_count;

Line 367: DELETE bim_all_indexes where table_name =UPPER(p_table_name);

363: ams_utility_pvt.write_conc_log('error create index'||sqlerrm(sqlcode));
364: --dbms_output.put_line('error updateing minimum balance'||sqlerrm(sqlcode));
365: END;
366: END LOOP;
367: DELETE bim_all_indexes where table_name =UPPER(p_table_name);
368: END IF;
369: END CREATE_INDEX;
370:
371: END BIM_UTL_PKG;