[Home] [Help]
4670: END IF; -- mode <>0
4671: BSC_METADATA_OPTIMIZER_PKG.logProgress('INIT', ' # of indicators to process = '||BSC_METADATA_OPTIMIZER_PKG.gIndicators.count);
4672: writeTmp(' # of indicators to process = '||BSC_METADATA_OPTIMIZER_PKG.gIndicators.count,FND_LOG.LEVEL_STATEMENT, true);
4673:
4674: -- populate the variables in bsc_dbgen_metadata_reader as it needs to consider the
4675: -- objectives in the current run as also production
4676: writeTmp('Checking if AW objectives exists and marking them');
4677: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;
4678: loop
4685: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_counter);
4686: end loop;
4687:
4688: if (l_aw_kpi_list.count>0) then
4689: bsc_dbgen_metadata_reader.mark_facts_in_process(l_aw_kpi_list);
4690: end if;
4691:
4692: writeTmp( 'Completed InitIndicators, system time is '||get_time, FND_LOG.LEVEL_STATEMENT, true);
4693: write_this(BSC_METADATA_OPTIMIZER_PKG.gIndicators, FND_LOG.LEVEL_STATEMENT, false);
5736: bsc_aw_load.drop_bt_change_vector(BSC_METADATA_OPTIMIZER_PKG.garrTables(i));
5737: END IF;
5738: -- drop B_PRJ table if it exists
5739: writeTmp('Table Type=B, child_table='||l_child_table);
5740: l_child_table:= BSC_DBGEN_METADATA_READER.get_table_properties(BSC_METADATA_OPTIMIZER_PKG.garrTables(i),
5741: BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE) ;
5742: if (l_child_table is not null) then
5743: DropTable(l_child_table);
5744: end if;
5745: END IF;
5746: END IF;
5747: -- drop i_rowid table if it exists
5748: IF (bsc_dbgen_utils.get_table_type(bsc_metadata_optimizer_pkg.garrTables(i))='I') THEN
5749: l_child_table := BSC_DBGEN_METADATA_READER.get_table_properties(BSC_METADATA_OPTIMIZER_PKG.garrTables(i),
5750: BSC_DBGEN_STD_METADATA.BSC_I_ROWID_TABLE) ;
5751: writeTmp('Table Type=I, child_table='||l_child_table);
5752: if (l_child_table is not null) then
5753: DropTable(l_child_table);