[Home] [Help]
118: m_min_tim_lvl_id,
119: use_org_specific_bom_flag,
120: stripe_sr_level_pk,
121: stripe_stream_name
122: FROM msd_demand_plans
123: WHERE demand_plan_id = p_demand_plan_id;
124:
125: --
126: -- check TIM and PRD dimensions are there
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
329: and nvl(mlv.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
330: and mlv.level_id = mdsol.level_id
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
344: and nvl(mlv.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
345: and mlv.level_id = mdsol.level_id
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
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
536: planning_server_view_name_ds),
537: planning_server_view_name_ds),
538: planning_server_view_name
539: FROM msd_cs_definitions_vl,
540: msd_demand_plans mdp
541: WHERE cs_definition_id = p_cs_def_id
542: and mdp.demand_plan_id = p_demand_plan_id;
543:
544: CURSOR param_cs_wgt (p_cs_def_id NUMBER) IS
895:
896: /* Bug# 4345323 Get the plan type of the plan */
897: SELECT plan_type
898: INTO l_plan_type
899: FROM msd_demand_plans
900: WHERE demand_plan_id = p_demand_plan_id;
901:
902: /* Bug# 4345323 Call validate_liability_plan if plan type is LIABILITY*/
903: IF nvl(l_plan_type,'DP') = 'LIABILITY' THEN
2519: debug_out( 'Entering update_plan ' || to_char(sysdate, 'hh24:mi:ss'));
2520: end if;
2521:
2522: if nvl(p_ret_code, '1') <> '0' and nvl(p_ret_code, '2') <> '1' then
2523: update msd_demand_plans
2524: set valid_flag = '1'
2525: where demand_plan_id = p_demand_plan_id;
2526: else
2527: --
2524: set valid_flag = '1'
2525: where demand_plan_id = p_demand_plan_id;
2526: else
2527: --
2528: update msd_demand_plans
2529: set valid_flag = '0'
2530: where demand_plan_id = p_demand_plan_id;
2531: end if;
2532: --
3157: Procedure Lock_Row(p_demand_plan_id in number) Is
3158: Counter NUMBER;
3159: CURSOR C IS
3160: SELECT demand_plan_name
3161: FROM msd_demand_plans
3162: WHERE demand_plan_id = p_demand_plan_id
3163: FOR UPDATE of demand_plan_name NOWAIT;
3164: Recinfo C%ROWTYPE;
3165: BEGIN
3264:
3265: cursor is_plan_lob (p_demand_plan_id number)
3266: is
3267: select stripe_level_id,build_stripe_stream_name
3268: from msd_demand_plans
3269: where demand_plan_id = p_demand_plan_id;
3270:
3271: cursor invalid_internal_orgs (p_demand_plan_id number)
3272: is