APPS.MSD_COPY_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS

Line 12: from msd_dp_parameters

8: return varchar2
9: is
10: cursor par_type is
11: select parameter_type
12: from msd_dp_parameters
13: where demand_plan_id=p_demand_plan_id
14: and to_char(parameter_id)=rtrim(p_parameter_id);
15:
16: l_par_type varchar2(300) := null;

Line 86: from msd_dp_parameters

82: where demand_plan_id=x_demand_plan_id;
83:
84: cursor replace_equation(p_demand_plan_id number) is
85: select parameter_type,equation,post_calculation
86: from msd_dp_parameters
87: where demand_plan_id=p_demand_plan_id;
88:
89: cursor replace_associate_param is
90: select scenario_id,associate_parameter

Line 362: INSERT INTO msd_dp_parameters

358:
359:
360: lv_status_id := 30;
361:
362: INSERT INTO msd_dp_parameters
363: (DEMAND_PLAN_ID,
364: PARAMETER_ID,
365: PARAMETER_TYPE,
366: PARAMETER_NAME,

Line 402: ,msd_dp_parameters_s.nextval

398: CALCULATED_ORDER,
399: POST_CALCULATION)
400: SELECT
401: x_demand_plan_id
402: ,msd_dp_parameters_s.nextval
403: ,par.PARAMETER_TYPE
404: ,par.PARAMETER_NAME
405: ,par.START_DATE
406: ,par.END_DATE

Line 439: msd_dp_parameters par

435: ,par.equation
436: ,par.calculated_order
437: ,par.post_calculation
438: FROM
439: msd_dp_parameters par
440: WHERE
441: DEMAND_PLAN_ID = p_source_demand_plan_id
442: and nvl(par.stream_type,'ABCD') not in ('ARCHIVED','ARCHIVED_TIM')
443: and (nvl(supply_plan_flag,'N') = 'N'

Line 461: update msd_dp_parameters set equation = rep_rec.equation, post_calculation=rep_rec.post_calculation where demand_plan_id=x_demand_plan_id and parameter_type=rep_rec.parameter_type;

457: close get_template_id;
458:
459: for rep_rec in replace_equation(l_template_id)
460: loop
461: update msd_dp_parameters set equation = rep_rec.equation, post_calculation=rep_rec.post_calculation where demand_plan_id=x_demand_plan_id and parameter_type=rep_rec.parameter_type;
462:
463: end loop;
464: end if;
465:

Line 470: UPDATE msd_dp_parameters mdp

466: /* Once Parameters are re-created. Update new Parameters with Allocation/Aggregation
467: * Stream Id's to simulate Source Plan but point to Destination Plan.
468: */
469:
470: UPDATE msd_dp_parameters mdp
471: SET
472: mdp.allo_agg_basis_stream_id =
473: (
474: select mdp1.parameter_id

Line 476: msd_dp_parameters mdp1,

472: mdp.allo_agg_basis_stream_id =
473: (
474: select mdp1.parameter_id
475: from
476: msd_dp_parameters mdp1,
477: (
478: select parameter_id,parameter_type, parameter_name
479: from
480: msd_dp_parameters

Line 480: msd_dp_parameters

476: msd_dp_parameters mdp1,
477: (
478: select parameter_id,parameter_type, parameter_name
479: from
480: msd_dp_parameters
481: ) mdp2
482: where
483: mdp2.parameter_id = mdp.allo_agg_basis_stream_id
484: and

Line 918: select msd_dp_parameters_s.nextval into x_new_formula_id

914:
915: for lv_cur_formula_rec in cur_formula LOOP
916:
917:
918: select msd_dp_parameters_s.nextval into x_new_formula_id
919: from dual;
920:
921:
922: INSERT INTO msd_dp_formulas

Line 1139: msd_dp_parameters mdp,

1135:
1136: ,SYSDATE
1137:
1138: from msd_dp_formula_parameters mdfp,
1139: msd_dp_parameters mdp,
1140: msd_dp_parameters mdp1
1141:
1142: where mdfp.demand_plan_id in
1143:

Line 1140: msd_dp_parameters mdp1

1136: ,SYSDATE
1137:
1138: from msd_dp_formula_parameters mdfp,
1139: msd_dp_parameters mdp,
1140: msd_dp_parameters mdp1
1141:
1142: where mdfp.demand_plan_id in
1143:
1144: (select demand_plan_id

Line 1248: msd_dp_parameters mdp,

1244:
1245: ,SYSDATE
1246:
1247: from msd_dp_formula_parameters mdfp,
1248: msd_dp_parameters mdp,
1249: msd_dp_parameters mdp1
1250:
1251: where mdfp.demand_plan_id = p_source_demand_plan_id
1252: and mdp.demand_plan_id=mdfp.demand_plan_id

Line 1249: msd_dp_parameters mdp1

1245: ,SYSDATE
1246:
1247: from msd_dp_formula_parameters mdfp,
1248: msd_dp_parameters mdp,
1249: msd_dp_parameters mdp1
1250:
1251: where mdfp.demand_plan_id = p_source_demand_plan_id
1252: and mdp.demand_plan_id=mdfp.demand_plan_id
1253: and mdp.parameter_id=mdfp.formula_id