APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_SCENARIOS

Line 931: from msd_dp_scenarios_cs_v

927: cursor c1 is
928:
929: select scenario_id, scenario_name, description
930:
931: from msd_dp_scenarios_cs_v
932:
933: where demand_plan_id = p_new_dp_id;
934:
935:

Line 963: update msd_dp_scenarios

959: fnd_message.set_name('MSD',c1_cur.scenario_name);
960:
961:
962:
963: update msd_dp_scenarios
964:
965: set scenario_name = fnd_message.get
966:
967: where demand_plan_id = p_new_dp_id

Line 977: update msd_dp_scenarios

973: fnd_message.set_name('MSD',c1_cur.description);
974:
975:
976:
977: update msd_dp_scenarios
978:
979: set description = fnd_message.get
980:
981: where demand_plan_id = p_new_dp_id

Line 991: update msd_dp_scenarios_tl

987: fnd_message.set_name('MSD',c1_cur.description);
988:
989:
990:
991: update msd_dp_scenarios_tl
992:
993: set description = fnd_message.get
994:
995: where demand_plan_id = p_new_dp_id

Line 1226: from msd_dp_scenarios

1222: and parameter_type=p_parameter_type;
1223:
1224: cursor c2 is
1225: select scenario_id
1226: from msd_dp_scenarios
1227: where demand_plan_id=p_new_dp_id;
1228:
1229: cursor c3(p_scenario_id number) is
1230: select associate_parameter

Line 1231: from msd_dp_scenarios

1227: where demand_plan_id=p_new_dp_id;
1228:
1229: cursor c3(p_scenario_id number) is
1230: select associate_parameter
1231: from msd_dp_scenarios
1232: where demand_plan_id=p_new_dp_id
1233: and scenario_id=p_scenario_id;
1234:
1235:

Line 1254: update msd_dp_scenarios

1250: open c1(p_associate_parameter);
1251: fetch c1 into p_parameter_id;
1252: close c1;
1253:
1254: update msd_dp_scenarios
1255: set associate_parameter=p_parameter_id
1256: where demand_plan_id=p_new_dp_id
1257: and scenario_id=c2_rec.scenario_id;
1258:

Line 1338: update msd_dp_scenarios

1334: -- set the history start and end dates of scenarios to month start date of 18 months backwards and current month end date respectively
1335:
1336: -- set the horizon start and end dates of scenarios to month start date of next month and end date of 19 months forwards respectively
1337:
1338: update msd_dp_scenarios
1339:
1340: set history_start_date = msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'),
1341:
1342: history_end_date = msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'),

Line 1554: from msd_dp_scenarios

1550: cursor c3 is
1551:
1552: select scenario_id, price_list_name
1553:
1554: from msd_dp_scenarios
1555:
1556: where demand_plan_id = p_new_dp_id
1557:
1558: and price_list_name is not null;

Line 1606: update msd_dp_scenarios

1602:
1603:
1604: -- replace message with text
1605:
1606: update msd_dp_scenarios
1607:
1608: set price_list_name = fnd_message.get_string('MSD',c3_cur.price_list_name)
1609:
1610: where demand_plan_id = p_new_dp_id

Line 3110: from msd_dp_scenarios

3106: cursor c1 is
3107:
3108: select supply_plan_name, forecast_based_on, parameter_name
3109:
3110: from msd_dp_scenarios
3111:
3112: where demand_plan_id = p_demand_plan_id
3113:
3114: and scenario_id = p_scenario_id;

Line 3248: from msd_dp_scenarios

3244: cursor c1 is
3245:
3246: select enable_nonseed_flag
3247:
3248: from msd_dp_scenarios
3249:
3250: where demand_plan_id = p_demand_plan_id
3251:
3252: and scenario_id = p_scenario_id;

Line 3664: from msd_dp_scenarios

3660: cursor c1 is
3661:
3662: select supply_plan_name, forecast_based_on, parameter_name
3663:
3664: from msd_dp_scenarios
3665:
3666: where demand_plan_id = p_demand_plan_id
3667:
3668: and scenario_name = p_scenario_name;

Line 4130: from msd_dp_scenarios

4126: cursor c1 is
4127:
4128: select enable_nonseed_flag
4129:
4130: from msd_dp_scenarios
4131:
4132: where demand_plan_id = p_demand_plan_id
4133:
4134: and scenario_id = p_scenario_id;

Line 4440: from msd_dp_scenarios

4436: cursor c1 is
4437:
4438: select enable_nonseed_flag
4439:
4440: from msd_dp_scenarios
4441:
4442: where demand_plan_id = p_demand_plan_id
4443:
4444: and scenario_id = p_scenario_id;

Line 4830: from msd_dp_scenarios

4826: cursor c1 is
4827:
4828: select enable_nonseed_flag
4829:
4830: from msd_dp_scenarios
4831:
4832: where demand_plan_id = p_demand_plan_id
4833:
4834: and scenario_id = p_scenario_id;

Line 5123: msd_dp_scenarios

5119: cursor c1 is
5120:
5121: select count(*) from
5122:
5123: msd_dp_scenarios
5124:
5125: where demand_plan_id = p_new_dp_id
5126:
5127: and supply_plan_flag = 'Y';

Line 5135: from msd_dp_scenarios

5131: cursor c2 is
5132:
5133: select scenario_name, description, demand_plan_id, scenario_id
5134:
5135: from msd_dp_scenarios
5136:
5137: where supply_plan_flag = 'Y'
5138:
5139: and demand_plan_id =

Line 5215: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;

5211: end if;
5212:
5213:
5214:
5215: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
5216:
5217:
5218:
5219: insert into msd_dp_scenarios

Line 5219: insert into msd_dp_scenarios

5215: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
5216:
5217:
5218:
5219: insert into msd_dp_scenarios
5220:
5221: (demand_plan_id
5222:
5223: ,scenario_id

Line 5435: from msd_dp_scenarios,

5431: ,associate_parameter
5432:
5433: ,sc_type
5434:
5435: from msd_dp_scenarios,
5436:
5437: (select nvl(plan_type,'DP') plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id) p_type
5438:
5439: where scenario_id = c2_cur.scenario_id

Line 5447: insert into msd_dp_scenarios_tl

5443:
5444:
5445:
5446:
5447: insert into msd_dp_scenarios_tl
5448:
5449: ( demand_plan_id
5450:
5451: ,scenario_id

Line 7298: from msd_dp_scenarios

7294: cursor c2 is
7295:
7296: select scenario_id
7297:
7298: from msd_dp_scenarios
7299:
7300: where demand_plan_id = p_demand_plan_id
7301:
7302: and forecast_based_on = p_parameter_type

Line 7781: msd_dp_scenarios

7777: is
7778:
7779: cursor c1 is
7780: select count(*) from
7781: msd_dp_scenarios
7782: where demand_plan_id = p_new_dp_id
7783: and supply_plan_flag = 'Y'
7784: and associate_parameter is not null;
7785:

Line 7788: from msd_dp_scenarios

7784: and associate_parameter is not null;
7785:
7786: cursor c2 is
7787: select scenario_name, description, demand_plan_id, scenario_id
7788: from msd_dp_scenarios
7789: where supply_plan_flag = 'Y'
7790: and demand_plan_id =
7791: (select demand_plan_id
7792: from msd_demand_plans

Line 7812: update msd_dp_scenarios set supply_plan_name=p_supply_plan_name, supply_plan_id=p_supply_plan_id

7808: fetch c1 into l_count;
7809: close c1;
7810:
7811: if l_count > 0 then
7812: update msd_dp_scenarios set supply_plan_name=p_supply_plan_name, supply_plan_id=p_supply_plan_id
7813: where demand_plan_id=p_new_dp_id
7814: and supply_plan_flag='Y'
7815: and associate_parameter is not null
7816: and supply_plan_id<>p_supply_plan_id;

Line 7820: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;

7816: and supply_plan_id<>p_supply_plan_id;
7817: else
7818: for c2_rec in c2
7819: loop
7820: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
7821: fnd_message.set_name('MSD',c2_rec.scenario_name);
7822: l_name := fnd_message.get;
7823: fnd_message.set_name('MSD',c2_rec.description);
7824: l_description := fnd_message.get;

Line 7826: insert into msd_dp_scenarios

7822: l_name := fnd_message.get;
7823: fnd_message.set_name('MSD',c2_rec.description);
7824: l_description := fnd_message.get;
7825:
7826: insert into msd_dp_scenarios
7827: ( demand_plan_id
7828: ,scenario_id
7829: ,scenario_name
7830: ,description

Line 7932: from msd_dp_scenarios

7928: ,p_supply_plan_name -- Bug 4729854
7929: ,dmd_priority_scenario_id -- Bug 4710963
7930: ,associate_parameter
7931: ,sc_type
7932: from msd_dp_scenarios
7933: where scenario_id = c2_rec.scenario_id
7934: and demand_plan_id = c2_rec.demand_plan_id);
7935:
7936: insert into msd_dp_scenarios_tl

Line 7936: insert into msd_dp_scenarios_tl

7932: from msd_dp_scenarios
7933: where scenario_id = c2_rec.scenario_id
7934: and demand_plan_id = c2_rec.demand_plan_id);
7935:
7936: insert into msd_dp_scenarios_tl
7937: ( demand_plan_id
7938: ,scenario_id
7939: ,description
7940: ,language