[Home] [Help]
2182: and MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
2183: THEN
2184:
2185: /*We will not pass the type of refresh here, it'll be determined in
2186: * package: MSC_CL_AHL_ODS_LOAD itself */
2187: MSC_CL_EAM_ODS_LOAD.LOAD_EAM_FORECASTS;
2188: END IF;
2189:
2190: /*Call to procedure in MSCLAHLB.pls */
2195: and MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)
2196: THEN
2197:
2198: /*We will not pass the type of refresh here, it'll be determined in
2199: * package: MSC_CL_AHL_ODS_LOAD itself */
2200: /* MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECASTS(MSC_CL_COLLECTION.v_instance_id,
2201: MSC_CL_COLLECTION.v_current_user,
2202: MSC_CL_COLLECTION.v_last_collection_id);
2203: */
2196: THEN
2197:
2198: /*We will not pass the type of refresh here, it'll be determined in
2199: * package: MSC_CL_AHL_ODS_LOAD itself */
2200: /* MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECASTS(MSC_CL_COLLECTION.v_instance_id,
2201: MSC_CL_COLLECTION.v_current_user,
2202: MSC_CL_COLLECTION.v_last_collection_id);
2203: */
2204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'In MSCLSUPB.pls before call to LOAD_CMRO_FORECAST_SUPPLIES');
2201: MSC_CL_COLLECTION.v_current_user,
2202: MSC_CL_COLLECTION.v_last_collection_id);
2203: */
2204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'In MSCLSUPB.pls before call to LOAD_CMRO_FORECAST_SUPPLIES');
2205: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_SUPPLIES;
2206: /* MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS;
2207: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR; */
2208:
2209: END IF;
2202: MSC_CL_COLLECTION.v_last_collection_id);
2203: */
2204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'In MSCLSUPB.pls before call to LOAD_CMRO_FORECAST_SUPPLIES');
2205: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_SUPPLIES;
2206: /* MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS;
2207: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR; */
2208:
2209: END IF;
2210:
2203: */
2204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'In MSCLSUPB.pls before call to LOAD_CMRO_FORECAST_SUPPLIES');
2205: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_SUPPLIES;
2206: /* MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS;
2207: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR; */
2208:
2209: END IF;
2210:
2211: IF(MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y'
2210:
2211: IF(MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y'
2212: and MSC_CL_COLLECTION.v_coll_prec.osp_supply = MSC_UTIL.SYS_YES)
2213: THEN
2214: MSC_CL_AHL_ODS_LOAD.LOAD_OSP_SUPPLY;
2215: END IF;
2216:
2217: -- agmcont
2218: if MSC_CL_COLLECTION.v_is_cont_refresh then return; end if;
3313: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
3314: 'In MSCLSUPB.pls before call to
3315: LOAD_CMRO_FORECAST_SUPPLIES');
3316:
3317: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_SUPPLIES;
3318: END IF;
3319:
3320: --agmcont:
3321: else
4055: and MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
4056: THEN
4057:
4058: /*We will not pass the type of refresh here, it'll be determined in
4059: * package: MSC_CL_AHL_ODS_LOAD itself */
4060: MSC_CL_EAM_ODS_LOAD.LOAD_EAM_FORECASTS;
4061: END IF;
4062:
4063: IF(MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y'
4062:
4063: IF(MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y'
4064: and MSC_CL_COLLECTION.v_coll_prec.osp_supply = MSC_UTIL.SYS_YES)
4065: THEN
4066: MSC_CL_AHL_ODS_LOAD.LOAD_OSP_SUPPLY;
4067: END IF;
4068:
4069: END LOAD_STAGING_SUPPLY;
4070: