244: ,status => l_status
245: ,industry => l_industry
246: ,oracle_schema => l_schema) THEN
247: l_stmt_num := 20;
248: oki_dbi_scm_rsg_api_pvt.drop_index(p_table_name => 'opi_dbi_wms_tasks_stg'
249: ,p_owner => l_schema
250: ,p_retcode => retcode);
251: --
252: l_stmt_num := 30;
249: ,p_owner => l_schema
250: ,p_retcode => retcode);
251: --
252: l_stmt_num := 30;
253: oki_dbi_scm_rsg_api_pvt.drop_index(p_table_name => 'opi_dbi_wms_op_stg'
254: ,p_owner => l_schema
255: ,p_retcode => retcode);
256: --
257: l_stmt_num := 40;
254: ,p_owner => l_schema
255: ,p_retcode => retcode);
256: --
257: l_stmt_num := 40;
258: oki_dbi_scm_rsg_api_pvt.drop_index(p_table_name => 'opi_dbi_wms_ex_stg'
259: ,p_owner => l_schema
260: ,p_retcode => retcode);
261: --
262: bis_collection_utilities.put_line('Dropped the Indexes on Staging Tables');
296: ,status => l_status
297: ,industry => l_industry
298: ,oracle_schema => l_schema) THEN
299: l_stmt_num := 20;
300: oki_dbi_scm_rsg_api_pvt.create_index(p_table_name=>'opi_dbi_wms_tasks_stg'
301: ,p_owner =>l_schema
302: ,p_retcode =>retcode);
303: --
304: l_stmt_num := 30;
301: ,p_owner =>l_schema
302: ,p_retcode =>retcode);
303: --
304: l_stmt_num := 30;
305: oki_dbi_scm_rsg_api_pvt.create_index(p_table_name=>'opi_dbi_wms_op_stg'
306: ,p_owner =>l_schema
307: ,p_retcode =>retcode);
308: --
309: l_stmt_num := 40;
306: ,p_owner =>l_schema
307: ,p_retcode =>retcode);
308: --
309: l_stmt_num := 40;
310: oki_dbi_scm_rsg_api_pvt.create_index(p_table_name=>'opi_dbi_wms_ex_stg'
311: ,p_owner =>l_schema
312: ,p_retcode =>retcode);
313: --
314: l_stmt_num := 50;