[Home] [Help]
4500: EDW_FLAG FROM BSC_KPIS_VL ';
4501:
4502: IF BSC_METADATA_OPTIMIZER_PKG.gGAA_RUN_MODE = 0 THEN
4503: l_stmt := l_stmt || ' where short_name is null OR
4504: (short_name is not null and BSC_DBGEN_UTILS.Get_Objective_Type(short_name) = ''OBJECTIVE'')';
4505: -- NOTE NOTE NOTE
4506: -- Change MODE to modified as ALL doesnt make sense anymore
4507: -- as ALL should now exclude KPIs created using report designer
4508: DELETE FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID;
4509: INSERT INTO BSC_TMP_OPT_UI_KPIS (INDICATOR, PROTOTYPE_FLAG, PROCESS_ID)
4510: SELECT INDICATOR, PROTOTYPE_FLAG, BSC_METADATA_OPTIMIZER_PKG.g_processID
4511: FROM BSC_KPIS_VL
4512: where short_name is null OR
4513: (short_name is not null and BSC_DBGEN_UTILS.Get_Objective_Type(short_name) = 'OBJECTIVE');
4514: l_objectives_count := SQL%ROWCOUNT;
4515: commit;
4516: SELECT COUNT(1) INTO l_total_count FROM BSC_KPIS_VL;
4517: IF (l_objectives_count <> l_total_count) THEN -- there are autogenerated reports, dont process them
5731: IF substr(BSC_METADATA_OPTIMIZER_PKG.garrTables(i), 1, 6)= 'BSC_B_' THEN
5732: IF is_base_table(BSC_METADATA_OPTIMIZER_PKG.garrTables(i)) THEN
5733: backup_b_table(BSC_METADATA_OPTIMIZER_PKG.garrTables(i));
5734: BSC_METADATA_OPTIMIZER_PKG.gBackedUpBTables(BSC_METADATA_OPTIMIZER_PKG.gBackedUpBTables.count):= BSC_METADATA_OPTIMIZER_PKG.garrTables(i);
5735: IF BSC_DBGEN_UTILS.get_objective_type_for_b_table(BSC_METADATA_OPTIMIZER_PKG.garrTables(i))='AW' THEN
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);
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
6084: writeTmp('Drop unused columns for tables ');
6085: IF all_columns_used(l_arr_source_table, l_arr_table_name, l_unused_columns)=false THEN
6086: for j in l_unused_columns.first..l_unused_columns.last loop
6087: drop_column(l_arr_table_name(j), l_unused_columns(j));
6088: IF bsc_dbgen_utils.get_table_type(l_arr_table_name(j)) = 'B' THEN -- drop mv log column
6089: BEGIN
6090: l_mvlog_name := bsc_dbgen_utils.get_mvlog_for_table(l_arr_table_name(j));
6091: IF (l_mvlog_name IS NOT NULL) THEN
6092: drop_column(l_mvlog_name, l_unused_columns(j));
6086: for j in l_unused_columns.first..l_unused_columns.last loop
6087: drop_column(l_arr_table_name(j), l_unused_columns(j));
6088: IF bsc_dbgen_utils.get_table_type(l_arr_table_name(j)) = 'B' THEN -- drop mv log column
6089: BEGIN
6090: l_mvlog_name := bsc_dbgen_utils.get_mvlog_for_table(l_arr_table_name(j));
6091: IF (l_mvlog_name IS NOT NULL) THEN
6092: drop_column(l_mvlog_name, l_unused_columns(j));
6093: END IF;
6094: EXCEPTION WHEN OTHERS THEN
6464: --fnd_file.put_line(FND_FILE.LOG, g_stack(i));
6465: IF length(l_msg) <=256 THEN
6466: fnd_file.put_line(FND_FILE.LOG, l_msg);
6467: ELSE
6468: l_varchar2_table := bsc_dbgen_utils.get_char_chunks(l_msg, 256);
6469: FOR j in l_varchar2_table.first..l_varchar2_table.last LOOP
6470: fnd_file.put_line(FND_FILE.LOG, l_varchar2_table(j));
6471: END LOOP;
6472: END IF;
6554: END IF;
6555: IF (length(l_msg) <=256) THEN
6556: fnd_file.put_line(FND_FILE.LOG, bsc_metadata_optimizer_pkg.gIndent||l_msg);
6557: ELSE
6558: l_varchar2_table := bsc_dbgen_utils.get_char_chunks(l_msg, 256);
6559: FOR i IN l_varchar2_table.first..l_varchar2_table.last LOOP
6560: fnd_file.put_line(FND_FILE.LOG, bsc_metadata_optimizer_pkg.gIndent||l_varchar2_table(i));
6561: END LOOP;
6562: END IF;