APPS.OKI_DBI_SCM_RSG_API_PVT dependencies on OKI_DBI_INDEXES

Line 119: FROM oki_dbi_indexes

115: l_rows NUMBER := 0;
116:
117: CURSOR c_oki_idx IS
118: SELECT *
119: FROM oki_dbi_indexes
120: WHERE table_name = p_table_name;
121:
122: CURSOR c_idx IS
123: SELECT index_name

Line 140: FROM oki_dbi_indexes

136: AND OWNER = p_owner;
137:
138: SELECT count(1)
139: INTO l_rows
140: FROM oki_dbi_indexes
141: WHERE table_name = p_table_name;
142:
143: IF (l_index_exists = 0) THEN
144: -- index do not exist , so no action

Line 154: -- Update oki_dbi_indexes with latest index information

150: END IF; -- (l_rows = 0) THEN
151: ELSE
152:
153: -- If all_indexes has index details
154: -- Update oki_dbi_indexes with latest index information
155: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Inserting Index definitions into oki_dbi_indexes - '
156: || FND_DATE.Date_To_DisplayDt(sysdate));
157: MERGE INTO OKI_DBI_INDEXES b
158: USING ( select table_name, index_name from all_indexes

Line 155: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Inserting Index definitions into oki_dbi_indexes - '

151: ELSE
152:
153: -- If all_indexes has index details
154: -- Update oki_dbi_indexes with latest index information
155: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Inserting Index definitions into oki_dbi_indexes - '
156: || FND_DATE.Date_To_DisplayDt(sysdate));
157: MERGE INTO OKI_DBI_INDEXES b
158: USING ( select table_name, index_name from all_indexes
159: where table_name = p_table_name AND OWNER = p_owner ) s

Line 157: MERGE INTO OKI_DBI_INDEXES b

153: -- If all_indexes has index details
154: -- Update oki_dbi_indexes with latest index information
155: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Inserting Index definitions into oki_dbi_indexes - '
156: || FND_DATE.Date_To_DisplayDt(sysdate));
157: MERGE INTO OKI_DBI_INDEXES b
158: USING ( select table_name, index_name from all_indexes
159: where table_name = p_table_name AND OWNER = p_owner ) s
160: ON (b.index_name = s.index_name AND b.table_name = s.table_name)
161: WHEN MATCHED THEN

Line 185: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('FINISHED: Inserting Index definitions into oki_dbi_indexes for - '|| p_table_name

181: -1,
182: -1);
183:
184: COMMIT;
185: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('FINISHED: Inserting Index definitions into oki_dbi_indexes for - '|| p_table_name
186: || ', ' || FND_DATE.Date_To_DisplayDt(sysdate));
187:
188: -- Once all indexes are stored in oki_dbi_indexes
189: -- drop all the existing indexes of MV from the DB

Line 188: -- Once all indexes are stored in oki_dbi_indexes

184: COMMIT;
185: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('FINISHED: Inserting Index definitions into oki_dbi_indexes for - '|| p_table_name
186: || ', ' || FND_DATE.Date_To_DisplayDt(sysdate));
187:
188: -- Once all indexes are stored in oki_dbi_indexes
189: -- drop all the existing indexes of MV from the DB
190: FOR i IN c_idx LOOP
191: EXECUTE IMMEDIATE 'DROP INDEX ' || i.index_name;
192: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Dropped index: '|| i.index_name);

Line 220: FROM oki_dbi_indexes

216:
217: CURSOR c_oki_idx IS
218: SELECT index_name,
219: create_stmt
220: FROM oki_dbi_indexes
221: WHERE table_name = p_table_name;
222:
223: CURSOR c_idx IS
224: SELECT index_name

Line 249: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Starting to create index '||i.index_name||' from oki_dbi_indexes at: '|| FND_DATE.Date_To_DisplayDt(sysdate));

245: ELSIF(INSTR(l_mod_create_stmt,'PARALLEL') <= 0) THEN
246: l_mod_create_stmt := l_mod_create_stmt || ' PARALLEL';
247: END IF;
248:
249: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Starting to create index '||i.index_name||' from oki_dbi_indexes at: '|| FND_DATE.Date_To_DisplayDt(sysdate));
250: EXECUTE IMMEDIATE l_mod_create_stmt;
251: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log(' Created index '||i.index_name||' at: '|| FND_DATE.Date_To_DisplayDt(sysdate));
252: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('');
253:

Line 259: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Cleaning the table oki_dbi_indexes for indexes of '||p_table_name);

255:
256: END LOOP;
257:
258: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Indexes created at '||FND_DATE.Date_To_DisplayDt(sysdate));
259: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Cleaning the table oki_dbi_indexes for indexes of '||p_table_name);
260:
261: DELETE FROM oki_dbi_indexes
262: WHERE table_name = p_table_name;
263: COMMIT;

Line 261: DELETE FROM oki_dbi_indexes

257:
258: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Indexes created at '||FND_DATE.Date_To_DisplayDt(sysdate));
259: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Cleaning the table oki_dbi_indexes for indexes of '||p_table_name);
260:
261: DELETE FROM oki_dbi_indexes
262: WHERE table_name = p_table_name;
263: COMMIT;
264: -- raise_application_error(-20101, 'After Create index - Check Fail after clean up');
265: