505: --BSC-MV Note: Drop reporting key global temporary tables
506: If g_BSC_MV Then
507: bsc_mo_helper_pkg.writeTmp('Drop reporting key global temporary tables', FND_LOG.LEVEL_STATEMENT, true);
508: logProgress('MISC', 'Drop reporting key global temporary tables');
509: BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB(NULL);
510: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB');
511: writetableCounts;
512: End If;
513: --BSC-MV Note: Create the MVs for the Kpis.
506: If g_BSC_MV Then
507: bsc_mo_helper_pkg.writeTmp('Drop reporting key global temporary tables', FND_LOG.LEVEL_STATEMENT, true);
508: logProgress('MISC', 'Drop reporting key global temporary tables');
509: BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB(NULL);
510: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB');
511: writetableCounts;
512: End If;
513: --BSC-MV Note: Create the MVs for the Kpis.
514: --Only for APPS systems.
552: bsc_mo_helper_pkg.writeTmp('Calling Create MV for Indicator '||Indic.code||', Time is '||
553: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, false);
554: logProgress('MV', 'Creating MV for '||Indic.code);
555: If Indic.Action_Flag = 0 And g_Sum_Level_Change = 2 Then
556: BSC_BIA_WRAPPER.Implement_Bsc_MV_VB(indic.code, advSumLevel, TRUE);
557: Else
558: BSC_BIA_WRAPPER.Implement_Bsc_MV_VB(indic.code, advSumLevel, FALSE);
559: End If;
560: logProgress('MISC', 'Compl creating MV for '||Indic.code||', checking error');
554: logProgress('MV', 'Creating MV for '||Indic.code);
555: If Indic.Action_Flag = 0 And g_Sum_Level_Change = 2 Then
556: BSC_BIA_WRAPPER.Implement_Bsc_MV_VB(indic.code, advSumLevel, TRUE);
557: Else
558: BSC_BIA_WRAPPER.Implement_Bsc_MV_VB(indic.code, advSumLevel, FALSE);
559: End If;
560: logProgress('MISC', 'Compl creating MV for '||Indic.code||', checking error');
561: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Implement_Bsc_MV_VB');
562: End If;
557: Else
558: BSC_BIA_WRAPPER.Implement_Bsc_MV_VB(indic.code, advSumLevel, FALSE);
559: End If;
560: logProgress('MISC', 'Compl creating MV for '||Indic.code||', checking error');
561: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Implement_Bsc_MV_VB');
562: End If;
563: END IF; -- totally shared
564: EXIT WHEN l_count = gIndicators.last;
565: l_count := gIndicators.next(l_count);