[Home] [Help]
114: m_min_tim_lvl_id,
115: use_org_specific_bom_flag,
116: stripe_sr_level_pk,
117: stripe_stream_name
118: FROM msd_demand_plans
119: WHERE demand_plan_id = p_demand_plan_id;
120:
121: --
122: -- check TIM and PRD dimensions are there
318: CURSOR get_output_levels_org( p_demand_plan_id NUMBER, p_scenario_id NUMBER) IS
319: select count( distinct decode(mlv.level_id, 3, 1, mlv.level_id))
320: from msd_levels mlv,
321: msd_dp_scenario_output_levels mdsol,
322: msd_demand_plans mdp
323: where mdsol.demand_plan_id = p_demand_plan_id
324: and mdsol.demand_plan_id = mdp.demand_plan_id
325: and nvl(mlv.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
326: and mlv.level_id = mdsol.level_id
333: CURSOR get_output_levels( p_demand_plan_id NUMBER, p_scenario_id NUMBER) IS
334: select count( distinct decode(mlv.level_id, 3, 1, mlv.level_id))
335: from msd_levels mlv,
336: msd_dp_scenario_output_levels mdsol,
337: msd_demand_plans mdp
338: where mdsol.demand_plan_id = p_demand_plan_id
339: and mdsol.demand_plan_id = mdp.demand_plan_id
340: and nvl(mlv.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
341: and mlv.level_id = mdsol.level_id
348: CURSOR get_inv_output_levels ( p_demand_plan_id IN NUMBER) IS
349: SELECT scen.scenario_name,
350: ml.level_name,
351: ml.dimension_code
352: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp
353: WHERE a.demand_plan_id = p_demand_plan_id
354: and a.demand_plan_id = mdp.demand_plan_id
355: and nvl(ml.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
356: AND a.level_id = ml.level_id
376: -- get duplicate dimensions in output parameters.
377: --
378: CURSOR get_dup_dim_output_levels ( p_demand_plan_id IN NUMBER) IS
379: SELECT scen.scenario_name,ml.dimension_code, count(*)
380: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp
381: WHERE a.level_id = ml.level_id
382: and a.demand_plan_id = mdp.demand_plan_id
383: and nvl(ml.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
384: AND a.scenario_id = scen.scenario_id
531: planning_server_view_name_ds),
532: planning_server_view_name_ds),
533: planning_server_view_name
534: FROM msd_cs_definitions_vl,
535: msd_demand_plans mdp
536: WHERE cs_definition_id = p_cs_def_id
537: and mdp.demand_plan_id = p_demand_plan_id;
538:
539: CURSOR param_cs_wgt (p_cs_def_id NUMBER) IS
890:
891: /* Bug# 4345323 Get the plan type of the plan */
892: SELECT plan_type
893: INTO l_plan_type
894: FROM msd_demand_plans
895: WHERE demand_plan_id = p_demand_plan_id;
896:
897: /* Bug# 4345323 Call validate_liability_plan if plan type is LIABILITY*/
898: IF nvl(l_plan_type,'DP') = 'LIABILITY' THEN
2386: debug_out( 'Entering update_plan ' || to_char(sysdate, 'hh24:mi:ss'));
2387: end if;
2388:
2389: if nvl(p_ret_code, '1') <> '0' and nvl(p_ret_code, '2') <> '1' then
2390: update msd_demand_plans
2391: set valid_flag = '1'
2392: where demand_plan_id = p_demand_plan_id;
2393: else
2394: --
2391: set valid_flag = '1'
2392: where demand_plan_id = p_demand_plan_id;
2393: else
2394: --
2395: update msd_demand_plans
2396: set valid_flag = '0'
2397: where demand_plan_id = p_demand_plan_id;
2398: end if;
2399: --
3024: Procedure Lock_Row(p_demand_plan_id in number) Is
3025: Counter NUMBER;
3026: CURSOR C IS
3027: SELECT demand_plan_name
3028: FROM msd_demand_plans
3029: WHERE demand_plan_id = p_demand_plan_id
3030: FOR UPDATE of demand_plan_name NOWAIT;
3031: Recinfo C%ROWTYPE;
3032: BEGIN
3131:
3132: cursor is_plan_lob (p_demand_plan_id number)
3133: is
3134: select stripe_level_id,build_stripe_stream_name
3135: from msd_demand_plans
3136: where demand_plan_id = p_demand_plan_id;
3137:
3138: cursor invalid_internal_orgs (p_demand_plan_id number)
3139: is