APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_LEVELS

Line 324: from msd_levels mlv,

320: -- get output levels w/Org Specific BOM
321: --
322: CURSOR get_output_levels_org( p_demand_plan_id NUMBER, p_scenario_id NUMBER) IS
323: select count( distinct decode(mlv.level_id, 3, 1, mlv.level_id))
324: from msd_levels mlv,
325: msd_dp_scenario_output_levels mdsol,
326: msd_demand_plans mdp
327: where mdsol.demand_plan_id = p_demand_plan_id
328: and mdsol.demand_plan_id = mdp.demand_plan_id

Line 339: from msd_levels mlv,

335: -- get output levels w/out Org Specific BOM
336: --
337: CURSOR get_output_levels( p_demand_plan_id NUMBER, p_scenario_id NUMBER) IS
338: select count( distinct decode(mlv.level_id, 3, 1, mlv.level_id))
339: from msd_levels mlv,
340: msd_dp_scenario_output_levels mdsol,
341: msd_demand_plans mdp
342: where mdsol.demand_plan_id = p_demand_plan_id
343: and mdsol.demand_plan_id = mdp.demand_plan_id

Line 356: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp

352: CURSOR get_inv_output_levels ( p_demand_plan_id IN NUMBER) IS
353: SELECT scen.scenario_name,
354: ml.level_name,
355: ml.dimension_code
356: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp
357: WHERE a.demand_plan_id = p_demand_plan_id
358: and a.demand_plan_id = mdp.demand_plan_id
359: and nvl(ml.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
360: AND a.level_id = ml.level_id

Line 384: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp

380: -- get duplicate dimensions in output parameters.
381: --
382: CURSOR get_dup_dim_output_levels ( p_demand_plan_id IN NUMBER) IS
383: SELECT scen.scenario_name,ml.dimension_code, count(*)
384: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp
385: WHERE a.level_id = ml.level_id
386: and a.demand_plan_id = mdp.demand_plan_id
387: and nvl(ml.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
388: AND a.scenario_id = scen.scenario_id

Line 2885: lv_level_id1 msd_levels.level_id%TYPE := 0;

2881: --
2882: -- check composite group has the same level
2883: --
2884: Procedure chk_composite_group_level (p_demand_plan_id in number) is
2885: lv_level_id1 msd_levels.level_id%TYPE := 0;
2886: lv_level_id2 msd_levels.level_id%TYPE := 0;
2887: lv_date_column_name msd_cs_defn_column_dtls.planning_view_column_name%TYPE;
2888: lv_previous_stream msd_cs_definitions.name%TYPE := '##'; --Previous stream verified
2889: lv_level_differ Number :=2; --1-Yes and 2-No

Line 2886: lv_level_id2 msd_levels.level_id%TYPE := 0;

2882: -- check composite group has the same level
2883: --
2884: Procedure chk_composite_group_level (p_demand_plan_id in number) is
2885: lv_level_id1 msd_levels.level_id%TYPE := 0;
2886: lv_level_id2 msd_levels.level_id%TYPE := 0;
2887: lv_date_column_name msd_cs_defn_column_dtls.planning_view_column_name%TYPE;
2888: lv_previous_stream msd_cs_definitions.name%TYPE := '##'; --Previous stream verified
2889: lv_level_differ Number :=2; --1-Yes and 2-No
2890:

Line 3004: lv_level_id msd_levels.level_id%TYPE;

3000: p_call_source in Number,
3001: p_input_demand_plan_id in Number,
3002: p_input_scenario_id in Number)
3003: return Number is
3004: lv_level_id msd_levels.level_id%TYPE;
3005: lv_sql_stmt Varchar2(2000);
3006: lv_start_date Varchar2(100);
3007: lv_end_date Varchar2(100);
3008: lv_name VARCHAR2(300);--Designator Column Name in Fact Table.