APPS.IBC_IMT_PUB dependencies on ALL_INDEXES

Line 22: -- Function : Package that performs an iMT Optimize on all indexes across

18: -- Start of comments
19: -- API name : Optimize_IBC_IMT_Indexes
20: -- Type : Public
21: -- Pre-reqs : None
22: -- Function : Package that performs an iMT Optimize on all indexes across
23: -- all IBC iMT-indexed columns in a time-distributed fashion.
24: -- Parameters :
25: --
26: -- IN : p_optimize_level IN VARCHAR2 Optional

Line 36: -- divided equally amongst all indexes within the IBC

32: --
33: -- : p_runtime IN NUMBER Optional
34: -- Integer that indicates the total run-time (in seconds) of
35: -- this optimization function call. This time will be
36: -- divided equally amongst all indexes within the IBC
37: -- subsystem. A null value implies execution until
38: -- completion of the task.
39: --
40: -- Default is ctx_ddl.maxtime_unlimited.

Line 65: SELECT index_name FROM all_indexes

61: curs INTEGER;
62: ROWS INTEGER;
63:
64: CURSOR c_index_name IS
65: SELECT index_name FROM all_indexes
66: WHERE index_name = 'IBC_ATTRIBUTE_BUNDLES_CTX'
67: AND owner = l_user_name;
68:
69: --

Line 129: -- Function : Package that performs an IMT Sync on all indexes across

125: -- Start of comments
126: -- API name : SYNC_IBC_IMT_INDEXES
127: -- Type : Public
128: -- Pre-reqs : None
129: -- Function : Package that performs an IMT Sync on all indexes across
130: -- all IBC IMT-indexed columns.
131: --
132: -- Parameters : None.
133: --

Line 156: SELECT index_name FROM all_indexes

152: curs INTEGER;
153: ROWS INTEGER;
154:
155: CURSOR c_index_name IS
156: SELECT index_name FROM all_indexes
157: WHERE index_name = 'IBC_ATTRIBUTE_BUNDLES_CTX'
158: AND owner = l_owner_name;
159:
160: BEGIN