[Home] [Help]
420:
421:
422: -- set the supply plan name to supply plan name for formula parameters
423:
424: update msd_dp_formula_parameters
425:
426: set supply_plan_name = p_supply_plan_name
427:
428: where demand_plan_id = p_new_dp_id
1023: and stream_type='CALCULATED';
1024:
1025: cursor c2(p_parameter_id number) is
1026: select parameter_sequence,parameter_type,parameter_component,parameter_value,supply_plan_name
1027: from msd_dp_formula_parameters
1028: where demand_plan_id=p_demand_plan_id
1029: and formula_id=p_parameter_id
1030: order by parameter_sequence;
1031:
1788: cursor c2(p_formula_id in number) is
1789:
1790: select where_used, parameter_sequence, parameter_type, parameter_component, parameter_value, supply_plan_name
1791:
1792: from msd_dp_formula_parameters
1793:
1794: where demand_plan_id = p_new_dp_id
1795:
1796: and formula_id = p_formula_id
2350: cursor c1 is
2351:
2352: select distinct formula_id
2353:
2354: from msd_dp_formula_parameters
2355:
2356: where demand_plan_id = p_new_dp_id
2357:
2358: and mandatory_flag = 'Y'
2958:
2959:
2960: -- disable formula_parameters
2961:
2962: update msd_dp_formula_parameters
2963:
2964: set enabled_flag = 'N'
2965:
2966: where demand_plan_id = p_demand_plan_id
3050:
3051:
3052: -- disable formula parameters
3053:
3054: update msd_dp_formula_parameters
3055:
3056: set enabled_flag = 'N'
3057:
3058: where demand_plan_id = p_demand_plan_id
3138: close c1;
3139:
3140:
3141:
3142: update msd_dp_formula_parameters
3143:
3144: set enabled_flag = 'N'
3145:
3146: where demand_plan_id = p_demand_plan_id
3436:
3437:
3438: -- disable formula parameters
3439:
3440: update msd_dp_formula_parameters
3441:
3442: set enabled_flag = 'N'
3443:
3444: where demand_plan_id = p_demand_plan_id
3532:
3533:
3534: -- enable formula paraneters
3535:
3536: update msd_dp_formula_parameters
3537:
3538: set enabled_flag = 'Y'
3539:
3540: where demand_plan_id = p_Demand_plan_id
3604:
3605:
3606: -- enable formula parameters
3607:
3608: update msd_dp_formula_parameters
3609:
3610: set enabled_flag = 'Y'
3611:
3612: where demand_plan_id = p_Demand_plan_id
3690: close c1;
3691:
3692:
3693:
3694: update msd_dp_formula_parameters
3695:
3696: set enabled_flag = 'Y'
3697:
3698: where demand_plan_id = p_demand_plan_id
4888:
4889:
4890: -- disable the formula parameters
4891:
4892: update msd_dp_formula_parameters
4893:
4894: set enabled_flag = 'N'
4895:
4896: where demand_plan_id = p_demand_plan_id
4922:
4923:
4924: -- change the formula parameters
4925:
4926: update msd_dp_formula_parameters
4927:
4928: set parameter_value = p_stream_type
4929:
4930: where demand_plan_id = p_demand_plan_id
4960:
4961:
4962: -- enable the formula parameters
4963:
4964: update msd_dp_formula_parameters
4965:
4966: set enabled_flag = 'Y'
4967:
4968: where demand_plan_id = p_demand_plan_id
6027: and supply_plan_name = p_old_supply_plan_name; -- Bug 4729854
6028:
6029:
6030:
6031: update msd_dp_formula_parameters
6032:
6033: set supply_plan_name = p_supply_plan_name -- Bug 4729854
6034:
6035: where demand_plan_id = p_new_dp_id
6051: and supply_plan_name = p_old_supply_plan_name; -- Bug 4729854
6052:
6053: /*-----Added for the bug 4605807----*/
6054:
6055: delete from msd_dp_formula_parameters
6056:
6057: where demand_plan_id = p_new_dp_id
6058:
6059: and supply_plan_name = p_old_supply_plan_name; -- Bug 4729854
6199: ,SYSDATE);
6200:
6201:
6202:
6203: insert into msd_dp_formula_parameters
6204:
6205: (
6206:
6207: demand_plan_id
6287: ,NULL
6288:
6289: ,SYSDATE
6290:
6291: from msd_dp_formula_parameters
6292:
6293: where demand_plan_id =
6294:
6295: (select demand_plan_id
6312:
6313:
6314: if p_plan_type='EOL' then
6315:
6316: insert into msd_dp_formula_parameters
6317:
6318: (
6319:
6320: demand_plan_id
6400: ,NULL
6401:
6402: ,SYSDATE
6403:
6404: from msd_dp_formula_parameters mdfp,
6405: msd_dp_parameters mdp,
6406: msd_dp_parameters mdp1
6407:
6408: where mdfp.demand_plan_id =