1286: LOOP
1287: Tabla := BSC_METADATA_OPTIMIZER_PKG.gTables(l_index1);
1288: -- bug 4581847, should call this for production tables also
1289: If isBasicTable(Tabla.Name) Then
1290: BSC_UPDATE.Configure_Periodicity_Calc_VB(tabla.name);
1291: BSC_MO_HELPER_PKG.CHeckError('BSC_UPDATE.Configure_Periodicity_Calc_VB');
1292: End If;
1293: EXIT WHEN l_index1 = BSC_METADATA_OPTIMIZER_PKG.gTables.last;
1294: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gTables.next(l_index1);
1287: Tabla := BSC_METADATA_OPTIMIZER_PKG.gTables(l_index1);
1288: -- bug 4581847, should call this for production tables also
1289: If isBasicTable(Tabla.Name) Then
1290: BSC_UPDATE.Configure_Periodicity_Calc_VB(tabla.name);
1291: BSC_MO_HELPER_PKG.CHeckError('BSC_UPDATE.Configure_Periodicity_Calc_VB');
1292: End If;
1293: EXIT WHEN l_index1 = BSC_METADATA_OPTIMIZER_PKG.gTables.last;
1294: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gTables.next(l_index1);
1295: END LOOP;
1297:
1298: --BSC-MV Note: Now that all the Loader metadata is configured, We need to configure
1299: --the Profit calculation in the base tables. It is going to call a Loader API
1300: --to do it. The same API is re-used in upgrade.
1301: BSC_UPDATE.Configure_Profit_Calc_VB;
1302: BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE.Configure_Profit_Calc_VB');
1303: End If;
1304:
1305: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1298: --BSC-MV Note: Now that all the Loader metadata is configured, We need to configure
1299: --the Profit calculation in the base tables. It is going to call a Loader API
1300: --to do it. The same API is re-used in upgrade.
1301: BSC_UPDATE.Configure_Profit_Calc_VB;
1302: BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE.Configure_Profit_Calc_VB');
1303: End If;
1304:
1305: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1306: BSC_MO_HELPER_PKG.writeTmp('Completed Loader Configuration '||bsc_mo_helper_pkg.get_time);