[Home] [Help]
652:
653: /*
654: * This procedure, given the export integration data profile name, pushes the
655: * forecast data along with forecast accuracy and demand priority from the
656: * export view to table MSD_DP_SCN_ENTRIES_DENORM. The member codes are
657: * transformed to the corresponding source identifiers. The 'Organization'
658: * level member is used to find out the source instance to which the record
659: * belongs.
660: * The internal names of the series will be used to get the semantic of the
1119: ' -1, ' ||
1120: ' 1) = 1 ';
1121: END IF;
1122:
1123: x_insert_clause := 'INSERT INTO MSD_DP_SCN_ENTRIES_DENORM ( ' ||
1124: ' DEMAND_PLAN_ID, ' ||
1125: ' SCENARIO_ID, ' ||
1126: ' DEMAND_ID, ' ||
1127: ' BUCKET_TYPE, ' ||
1148:
1149: x_large_sql := x_insert_clause || x_select_clause || x_from_clause || x_where_clause;
1150:
1151: /* Delete all data in the denorm for the export data profile */
1152: DELETE FROM MSD_DP_SCN_ENTRIES_DENORM
1153: WHERE demand_plan_id = x_demand_plan_id
1154: AND scenario_id = x_scenario_id;
1155:
1156: /* Insert forecast data into denorm table */
1178:
1179: msd_dem_collect_history_data.analyze_table (
1180: x_errbuf,
1181: x_retcode,
1182: 'MSD_DP_SCN_ENTRIES_DENORM');
1183:
1184: x_small_sql := ' BEGIN ' || x_schema || '.dl_log_status(''' || VS_MSG_UPLOAD_FCST || ''' , ''' ||
1185: VS_MSG_LOADED || ' ' || p_export_data_profile || ''' , ''' || VS_MSG_SUCCEEDED || ''' ); END;';
1186: