APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSD_DP_SCENARIO_OUTPUT_LEVELS

Line 287: -- purge output levels in msd_dp_scenario_output_levels

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:
291: -- ScenarioId Scenario id.

Line 288: -- insert new output levels in msd_dp_scenario_output_levels

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:
291: -- ScenarioId Scenario id.
292: --

Line 303: DELETE FROM msd_dp_scenario_output_levels

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
304: WHERE
305: demand_plan_id = g_DummyDemandPlanId AND
306: scenario_id = ScenarioId;
307: END;

Line 316: -- Desc: insert output levels in msd_dp_scenario_output_levels

312:
313: END PurgeAllFcstData;
314:
315: -- =============================================================
316: -- Desc: insert output levels in msd_dp_scenario_output_levels
317: --
318: -- Input:
319: -- ScenarioId Scenario id.
320: -- ItemOutputLevel Item output level, either ITEM or PRODUCT_FAMILY.

Line 347: INSERT INTO msd_dp_scenario_output_levels

343: l_OutputLevels := MscNumberArr();
344: MakeOutputLevelSet(l_OutputLevels, ItemOutputLevel, OrganizationOutputLevel, CustomerOutputLevel, DemandClassOutputLevel);
345: FOR I IN l_OutputLevels.first..l_OutputLevels.last
346: LOOP
347: INSERT INTO msd_dp_scenario_output_levels
348: (
349: demand_plan_id, scenario_id, level_id,
350: last_update_date, last_updated_by, creation_date, created_by
351: )

Line 366: -- those outpul levels in msd_dp_scenario_output_levels

362: END InsertOutputLevels;
363:
364: -- =============================================================
365: -- Desc: check consistency of output level parameters against
366: -- those outpul levels in msd_dp_scenario_output_levels
367: --
368: -- Input:
369: -- ItemOutputLevel Item output level, either ITEM or PRODUCT_FAMILY.
370: -- OrganizationOutputLevel

Line 400: SELECT count(*) INTO l_Count FROM msd_dp_scenario_output_levels

396: MakeOutputLevelSet(l_OutputLevels, ItemOutputLevel, OrganizationOutputLevel, CustomerOutputLevel, DemandClassOutputLevel);
397:
398: BEGIN
399: -- check number of output levels
400: SELECT count(*) INTO l_Count FROM msd_dp_scenario_output_levels
401: WHERE demand_plan_id = g_DummyDemandPlanId AND scenario_id = ScenarioId;
402: IF l_Count <> 0 THEN -- Don't need to check if this is a new scenario
403: IF l_Count <> l_OutputLevels.COUNT THEN
404: RETURN 'INCONSIST_OUTPUT_LEVELS';

Line 410: FROM msd_dp_scenario_output_levels

406: FOR I IN l_OutputLevels.first..l_OutputLevels.last
407: LOOP
408: BEGIN
409: SELECT 1 INTO l_Count
410: FROM msd_dp_scenario_output_levels
411: WHERE
412: demand_plan_id = g_DummyDemandPlanId AND
413: scenario_id = ScenarioId AND
414: level_id = l_OutputLevels(I);

Line 2401: -- and msd_dp_scenario_output_levels for l_ScenarioId, if it is there.

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);
2405: ELSE

Line 2415: -- those outpul levels in msd_dp_scenario_output_levels

2411: CreateNewScenario(l_ScenarioId, ScenarioName);
2412: InsertOutputLevels(l_ScenarioId, ItemOutputLevel, OrganizationOutputLevel, CustomerOutputLevel, DemandClassOutputLevel);
2413: ELSE
2414: -- check consistency of output level parameters against
2415: -- those outpul levels in msd_dp_scenario_output_levels
2416: l_string := ValidateOutputLevels(l_ScenarioId, ItemOutputLevel, OrganizationOutputLevel, CustomerOutputLevel, DemandClassOutputLevel);
2417: IF (l_String <> 'OK') THEN
2418: Status := l_String;
2419: RETURN;