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.MSC_WS_APS_DATA_SERVICES dependencies on MSD_DP_SCN_ENTRIES_DENORM

Line 286: -- Desc: Purge forecast data in msd_dp_scn_entries_denorm

282: END IF;
283: END MakeOutputLevelSet;
284:
285: -- =============================================================
286: -- Desc: Purge forecast data in msd_dp_scn_entries_denorm
287: -- purge output levels in msd_dp_scenario_output_levels
288: -- insert new output levels in msd_dp_scenario_output_levels
289: --
290: -- Input:

Line 299: DELETE FROM msd_dp_scn_entries_denorm

295: PROCEDURE PurgeAllFcstData(ScenarioId IN NUMBER) AS
296: BEGIN
297: BEGIN
298: -- purge all forecast
299: DELETE FROM msd_dp_scn_entries_denorm
300: WHERE scenario_id = ScenarioId;
301:
302: -- purge all output levels
303: DELETE FROM msd_dp_scenario_output_levels

Line 935: FROM msd_dp_scn_entries_denorm

931: BEGIN
932: IF g_DemandId = 0 THEN
933: BEGIN
934: SELECT count(*) INTO l_Count
935: FROM msd_dp_scn_entries_denorm
936: WHERE scenario_id = ScenarioId;
937:
938: IF l_Count = 0 THEN
939: g_DemandId := 1000;

Line 942: FROM msd_dp_scn_entries_denorm

938: IF l_Count = 0 THEN
939: g_DemandId := 1000;
940: ELSE
941: SELECT MAX(demand_id) INTO l_Count
942: FROM msd_dp_scn_entries_denorm
943: WHERE
944: demand_plan_id = g_DummyDemandPlanId AND
945: scenario_id = ScenarioId;
946: g_DemandId := l_Count + 1;

Line 960: -- Desc: Insert demand forecast into msd_dp_scn_entries_denorm table.

956:
957: END GenerateDemandId;
958:
959: -- =============================================================
960: -- Desc: Insert demand forecast into msd_dp_scn_entries_denorm table.
961: --
962: -- Input:
963: -- ScenarioId Scenario id.
964: -- ForecastData the demand forecast.

Line 982: INSERT INTO msd_dp_scn_entries_denorm

978: -- generate an unique demand id
979: GenerateDemandId(ScenarioId);
980:
981: -- insert data
982: INSERT INTO msd_dp_scn_entries_denorm
983: (
984: demand_plan_id, scenario_id, demand_id, bucket_type, start_time, end_time, quantity,
985: sr_organization_id, sr_instance_id, sr_inventory_item_id, error_type, forecast_error,
986: inventory_item_id, sr_ship_to_loc_id, sr_customer_id, sr_zone_id, priority,

Line 1138: -- forecast into msd_dp_scn_entries_denorm table.

1134: RETURN 'INVALID_UNIT_PRICE';
1135: END IF;
1136:
1137: -- All parametera pass the validation, insert the new demand
1138: -- forecast into msd_dp_scn_entries_denorm table.
1139: InsertForecast(ScenarioId, ForecastData, l_OrgId, l_SrItemId);
1140:
1141: RETURN 'OK';
1142:

Line 1494: 'FROM msd_dp_scn_entries_denorm ' ||

1490: 'nvl(priority, -23453), ' ||
1491: 'nvl(ascp_uom_code, ''''), ' ||
1492: 'demand_class, ' ||
1493: 'nvl(unit_price, -23453) ' ||
1494: 'FROM msd_dp_scn_entries_denorm ' ||
1495: 'WHERE ' ||
1496: WhereClause;
1497:
1498:

Line 2272: -- Desc: Upload demand forecasts into msd_dp_scn_entries_denorm table.

2268: --
2269: -- =============================================================
2270:
2271: -- =============================================================
2272: -- Desc: Upload demand forecasts into msd_dp_scn_entries_denorm table.
2273: --
2274: -- Input:
2275: -- UserName User name.
2276: -- RespName Responsibility name.

Line 2291: -- msd_dp_scn_entries_denorm for 5555555 + senario_id before

2287: -- DemandClassOutputLevel
2288: -- Demand class output level, either Y or N.
2289: -- PurgeAllFlag Allowed input is Y or N.
2290: -- If this parameter is set to Y, this operation will delete
2291: -- msd_dp_scn_entries_denorm for 5555555 + senario_id before
2292: -- any upload data is inserted/updated.
2293: -- ForecastTbl List of forecasts to be uploaded to msd_dp_scn_entries_denorm.
2294: -- BucketType Type of time bucket, allowed value is 1(Day), 2(Week), 3(Month).
2295: -- StartDate Start date of the bucket, ignore the time part.

Line 2293: -- ForecastTbl List of forecasts to be uploaded to msd_dp_scn_entries_denorm.

2289: -- PurgeAllFlag Allowed input is Y or N.
2290: -- If this parameter is set to Y, this operation will delete
2291: -- msd_dp_scn_entries_denorm for 5555555 + senario_id before
2292: -- any upload data is inserted/updated.
2293: -- ForecastTbl List of forecasts to be uploaded to msd_dp_scn_entries_denorm.
2294: -- BucketType Type of time bucket, allowed value is 1(Day), 2(Week), 3(Month).
2295: -- StartDate Start date of the bucket, ignore the time part.
2296: -- EndDate End Start date of the bucket, ignore the time part.
2297: -- Quantity Quantity.

Line 2400: -- if PurgeAllFlag is set, purge all rows in msd_dp_scn_entries_denorm

2396: RETURN;
2397: END IF;
2398: END IF;
2399:
2400: -- if PurgeAllFlag is set, purge all rows in msd_dp_scn_entries_denorm
2401: -- and msd_dp_scenario_output_levels for l_ScenarioId, if it is there.
2402: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN
2403: IF l_IsNewScenario THEN
2404: CreateNewScenario(l_ScenarioId, ScenarioName);

Line 2489: -- Desc: Download demand forecast from msd_dp_scn_entries_denorm table.

2485: END UPLOAD_FORECAST;
2486:
2487:
2488: -- =============================================================
2489: -- Desc: Download demand forecast from msd_dp_scn_entries_denorm table.
2490: --
2491: -- Input:
2492: -- UserName User name.
2493: -- RespName Responsibility name.