eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MO_HELPER_PKG dependencies on BSC_BIA_WRAPPER

Line 5621: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);

5617: LOOP
5618: FETCH cv INTO mv_name;
5619: EXIT WHEN cv%NOTFOUND;
5620: writeTmp('Drop mv '||mv_name, 1, true);
5621: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5622: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5623: END LOOP;
5624: CLOSE cv;
5625: --BSC-MV Note: Drop all MV used for targets for those KPIs

Line 5622: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

5618: FETCH cv INTO mv_name;
5619: EXIT WHEN cv%NOTFOUND;
5620: writeTmp('Drop mv '||mv_name, 1, true);
5621: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5622: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5623: END LOOP;
5624: CLOSE cv;
5625: --BSC-MV Note: Drop all MV used for targets for those KPIs
5626: l_stmt := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME

Line 5626: l_stmt := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME

5622: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5623: END LOOP;
5624: CLOSE cv;
5625: --BSC-MV Note: Drop all MV used for targets for those KPIs
5626: l_stmt := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME
5627: FROM BSC_DB_TABLES_RELS WHERE TABLE_NAME IN (
5628: SELECT TABLE_NAME
5629: FROM '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||'
5630: WHERE (' || strWhereInIndics || ') AND TABLE_NAME IS NOT NULL ) AND RELATION_TYPE = 1';

Line 5636: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);

5632: OPEN cv FOR l_stmt;
5633: LOOP
5634: FETCH cv INTO mv_name;
5635: EXIT WHEN cv%NOTFOUND;
5636: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5637: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5638: END LOOP;
5639: Close cv;
5640: --BSC-MV Note: Drop all tables created for projections

Line 5637: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

5633: LOOP
5634: FETCH cv INTO mv_name;
5635: EXIT WHEN cv%NOTFOUND;
5636: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5637: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5638: END LOOP;
5639: Close cv;
5640: --BSC-MV Note: Drop all tables created for projections
5641: l_stmt := 'SELECT DISTINCT PROJECTION_DATA FROM BSC_KPI_DATA_TABLES WHERE ('|| strWhereInIndics || ')

Line 5696: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);

5692: OPEN cv FOR l_stmt;
5693: LOOP
5694: FETCH cv INTO mv_name;
5695: EXIT WHEN cv%NOTFOUND;
5696: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5697: IF (bsc_metadata_optimizer_pkg.g_log) then
5698: writeTmp('Dropping summary mv '||mv_name, fnd_log.level_statement, false);
5699: END IF;
5700: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

Line 5700: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

5696: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5697: IF (bsc_metadata_optimizer_pkg.g_log) then
5698: writeTmp('Dropping summary mv '||mv_name, fnd_log.level_statement, false);
5699: END IF;
5700: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5701: END LOOP;
5702: CLOSE cv;
5703:
5704: --BSC-MV Note: Drop all MV used for targets for those KPIs

Line 5705: l_stmt := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME

5701: END LOOP;
5702: CLOSE cv;
5703:
5704: --BSC-MV Note: Drop all MV used for targets for those KPIs
5705: l_stmt := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME
5706: FROM BSC_DB_TABLES_RELS WHERE TABLE_NAME IN (
5707: SELECT TABLE_NAME FROM BSC_KPI_DATA_TABLES WHERE ('|| strWhereInIndics4 || ')';
5708: If BSC_METADATA_OPTIMIZER_PKG.garrIndics.count > 0 Then
5709: l_stmt := l_stmt || ' AND (' || strWhereNotInIndics || ')';

Line 5717: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);

5713: OPEN cv FOR l_stmt;
5714: LOOP
5715: FETCH cv INTO mv_name;
5716: EXIT WHEN cv%NOTFOUND;
5717: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5718: writeTmp('Dropping mv '||mv_name, fnd_log.level_statement, false);
5719: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5720: END LOOP;
5721: Close cv;

Line 5719: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

5715: FETCH cv INTO mv_name;
5716: EXIT WHEN cv%NOTFOUND;
5717: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5718: writeTmp('Dropping mv '||mv_name, fnd_log.level_statement, false);
5719: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5720: END LOOP;
5721: Close cv;
5722: END IF;
5723: --BSC-MV Note: Do NOT drop tables created for projections. For non-structural

Line 7315: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar(i.calendar_id, l_error_message) THEN

7311: null;
7312: ELSE
7313: writeTmp('Attempting to refresh Calendar id '||i.calendar_id ||
7314: ' changed, calling load reporting calendar for this:'||get_time);
7315: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar(i.calendar_id, l_error_message) THEN
7316: writeTmp('Error Loading reporting calendar :'||l_error_message, FND_LOG.LEVEL_UNEXPECTED, true);
7317: BSC_MO_HELPER_PKG.TerminateWithMsg(l_error_message);
7318: raise BSC_METADATA_OPTIMIZER_PKG.optimizer_exception;
7319: END IF;