[Home] [Help]
188: and stream_type='ARCHIVED';
189:
190: cursor c4(p_demand_plan_id number, p_scenario_id number) is
191: select max(revision)
192: from msd_dp_scenario_revisions
193: where demand_plan_id=p_demand_plan_id
194: and scenario_id=p_scenario_id;
195:
196: cursor c5(p_parameter_type varchar2,p_parameter_name varchar2) is
302: FROM
303: msd_dp_parameters par,
304: msd_dp_parameters par1,
305: msd_dp_scenarios mds,
306: msd_dp_scenario_revisions mdsr
307: WHERE
308: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)
309: and par.stream_type in ('ARCHIVED')
310: and mds.demand_plan_id=mdsr.demand_plan_id(+)
313: and par.archived_for_parameter=par1.parameter_type
314: and par1.parameter_id=to_number(mds.associate_parameter)
315: and mds.sc_type= 'ARCHIVED'
316: and mds.scenario_id=mdsr.scenario_id(+)
317: and nvl(mdsr.revision,-1)=(select nvl(max(revision),-1) from msd_dp_scenario_revisions where demand_plan_id=p_demand_plan_id
318: and scenario_id=mdsr.scenario_id);
319:
320: INSERT INTO msd_dp_parameters
321: (DEMAND_PLAN_ID,
389: ,par.STREAM_TYPE
390: FROM
391: msd_dp_parameters par,
392: msd_dp_parameters par1,
393: msd_dp_scenario_revisions mdsr,
394: msd_dp_scenarios mds
395: WHERE
396: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)
397: and par.stream_type in ('ARCHIVED_TIM')
504: FROM
505: msd_dp_parameters par,
506: msd_dp_parameters par1,
507: (select mds1.demand_plan_id,mds1.scenario_id,nvl(max(mdsr1.revision),-1) revision
508: from msd_dp_scenario_revisions mdsr1, msd_dp_scenarios mds1
509: where mdsr1.scenario_id(+)=mds1.scenario_id
510: and mdsr1.demand_plan_id(+)=mds1.demand_plan_id
511: group by mds1.demand_plan_id,mds1.scenario_id) mdsr,
512: msd_dp_scenarios mds,