APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DEMAND_PLANS

Line 304: from msd_demand_plans

300: cursor c1 is
301:
302: select demand_plan_id
303:
304: from msd_demand_plans
305:
306: where plan_type = p_plan_type
307:
308: and template_flag = 'Y'

Line 366: update msd_demand_plans

362:
363:
364: -- Update the Liability Specific Columns
365:
366: update msd_demand_plans
367:
368: set plan_start_date = p_plan_start_date,
369:
370: plan_end_date = p_plan_end_date,

Line 532: from msd_demand_plans

528: is
529:
530: cursor get_template_id is
531: select template_id
532: from msd_demand_plans
533: where demand_plan_id=p_demand_plan_id;
534:
535: l_template_id varchar2(100);
536:

Line 645: from msd_demand_plans

641: cursor c1 is
642:
643: select template_id
644:
645: from msd_demand_plans
646:
647: where demand_plan_id = p_demand_plan_id;
648:
649:

Line 811: from msd_demand_plans

807: cursor c1 is
808:
809: select template_id
810:
811: from msd_demand_plans
812:
813: where demand_plan_id = p_demand_plan_id;
814:
815:

Line 943: update msd_demand_plans

939:
940:
941: -- Update the template_flag and default_template columns as copy plan sets these to 'Y'
942:
943: update msd_demand_plans
944:
945: set template_flag = 'N',
946:
947: default_template = 'N'

Line 1098: from msd_demand_plans

1094: is
1095:
1096: cursor c1 is
1097: select plan_type
1098: from msd_demand_plans
1099: where demand_plan_id=p_demand_plan_id;
1100:
1101: p_plan_type varchar2(10);
1102:

Line 1151: from msd_demand_plans

1147: cursor c1 is
1148:
1149: select plan_type
1150:
1151: from msd_demand_plans
1152:
1153: where demand_plan_id = p_new_dp_id;
1154:
1155:

Line 1286: from msd_demand_plans

1282: cursor c1 is
1283:
1284: select plan_type
1285:
1286: from msd_demand_plans
1287:
1288: where demand_plan_id = p_new_dp_id;
1289:
1290:

Line 1386: from msd_demand_plans

1382: cursor c1 is
1383:
1384: select liab_plan_name, plan_type, organization_id, sr_instance_id
1385:
1386: from msd_demand_plans
1387:
1388: where demand_plan_id = p_new_dp_id;
1389:
1390:

Line 1502: update msd_demand_plans

1498:
1499:
1500: -- set min time level for manufacturing calendar to Manufacturing Week
1501:
1502: update msd_demand_plans
1503:
1504: set m_min_tim_lvl_id = 1
1505:
1506: where demand_plan_id = p_new_dp_id;

Line 2180: from msd_demand_plans

2176: cursor c1 is
2177:
2178: select demand_plan_name
2179:
2180: from msd_demand_plans
2181:
2182: where demand_plan_id = p_new_dp_id;
2183:
2184:

Line 2213: from msd_demand_plans

2209:
2210:
2211: cursor get_plan_type is
2212: select plan_type
2213: from msd_demand_plans
2214: where demand_plan_id=p_new_dp_id;
2215:
2216: p_plan_type varchar2(10);
2217:

Line 2242: update msd_demand_plans set liab_plan_id=l_liab_plan_id where demand_plan_id=p_new_dp_id;

2238: close c1;
2239:
2240: if p_plan_type='EOL' then
2241: select max(supply_plan_id) into l_liab_plan_id from msd_dp_supply_plans where demand_plan_name = l_demand_plan_name;
2242: update msd_demand_plans set liab_plan_id=l_liab_plan_id where demand_plan_id=p_new_dp_id;
2243: end if;
2244:
2245: -- for each suuply plan selected in Template window
2246:

Line 2408: from msd_demand_plans

2404: cursor c1 is
2405:
2406: select plan_type
2407:
2408: from msd_demand_plans
2409:
2410: where demand_plan_id = p_new_dp_id;
2411:
2412:

Line 5021: from msd_demand_plans

5017:
5018:
5019: cursor get_plan_type is
5020: select plan_type
5021: from msd_demand_plans
5022: where demand_plan_id=p_new_dp_id;
5023:
5024: p_plan_type varchar2(10);
5025:

Line 5036: from msd_demand_plans

5032: cursor c1 is
5033:
5034: select template_id
5035:
5036: from msd_demand_plans
5037:
5038: where demand_plan_id=p_new_dp_id;
5039:
5040:

Line 5051: update msd_demand_plans

5047: close get_plan_type;
5048:
5049: if p_plan_type='EOL' then
5050: add_ascp_scenario_for_eol(p_new_dp_id, p_supply_plan_id, p_supply_plan_name);
5051: update msd_demand_plans
5052: set liab_plan_id=p_supply_plan_id
5053: where demand_plan_id=p_new_dp_id;
5054: end if;
5055:

Line 5143: from msd_demand_plans

5139: and demand_plan_id =
5140:
5141: (select demand_plan_id
5142:
5143: from msd_demand_plans
5144:
5145: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
5146:
5147: and template_flag = 'Y'

Line 5145: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)

5141: (select demand_plan_id
5142:
5143: from msd_demand_plans
5144:
5145: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
5146:
5147: and template_flag = 'Y'
5148:
5149: and default_template = 'Y'

Line 5437: (select nvl(plan_type,'DP') plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id) p_type

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
5440:
5441: and demand_plan_id = c2_cur.demand_plan_id);

Line 5886: (select nvl(plan_type,'DP') plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id) p_type

5882: ,price_list_name
5883:
5884: from msd_dp_parameters,
5885:
5886: (select nvl(plan_type,'DP') plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id) p_type
5887:
5888: where supply_plan_flag = 'Y'
5889:
5890: and nvl(stream_type,'ABCD') not in ('ARCHIVED','ARCHIVED_TIM')

Line 5896: from msd_demand_plans

5892: and demand_plan_id =
5893:
5894: (select demand_plan_id
5895:
5896: from msd_demand_plans
5897:
5898: where plan_type = p_type.plan_type
5899:
5900: and template_flag = 'Y'

Line 5984: from msd_demand_plans

5980: where demand_plan_id =
5981:
5982: (select demand_plan_id
5983:
5984: from msd_demand_plans
5985:
5986: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
5987:
5988: and template_flag = 'Y'

Line 5986: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)

5982: (select demand_plan_id
5983:
5984: from msd_demand_plans
5985:
5986: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
5987:
5988: and template_flag = 'Y'
5989:
5990: and default_template = 'Y'

Line 5999: from msd_demand_plans

5995:
5996:
5997: cursor plan_type is
5998: select plan_type
5999: from msd_demand_plans
6000: where demand_plan_id=p_new_dp_id;
6001:
6002: p_plan_type varchar2(10);
6003:

Line 6297: from msd_demand_plans

6293: where demand_plan_id =
6294:
6295: (select demand_plan_id
6296:
6297: from msd_demand_plans
6298:
6299: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6300:
6301: and template_flag = 'Y'

Line 6299: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)

6295: (select demand_plan_id
6296:
6297: from msd_demand_plans
6298:
6299: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6300:
6301: and template_flag = 'Y'
6302:
6303: and default_template = 'Y'

Line 6412: from msd_demand_plans

6408: where mdfp.demand_plan_id =
6409:
6410: (select demand_plan_id
6411:
6412: from msd_demand_plans
6413:
6414: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6415:
6416: and template_flag = 'Y'

Line 6414: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)

6410: (select demand_plan_id
6411:
6412: from msd_demand_plans
6413:
6414: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6415:
6416: and template_flag = 'Y'
6417:
6418: and default_template = 'Y')

Line 6496: from msd_demand_plans

6492: and demand_plan_id =
6493:
6494: (select demand_plan_id
6495:
6496: from msd_demand_plans
6497:
6498: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6499:
6500: and template_flag = 'Y'

Line 6498: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)

6494: (select demand_plan_id
6495:
6496: from msd_demand_plans
6497:
6498: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6499:
6500: and template_flag = 'Y'
6501:
6502: and default_template = 'Y');

Line 6844: from msd_demand_plans

6840: and demand_plan_id =
6841:
6842: (select demand_plan_id
6843:
6844: from msd_demand_plans
6845:
6846: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6847:
6848: and template_flag = 'Y'

Line 6846: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)

6842: (select demand_plan_id
6843:
6844: from msd_demand_plans
6845:
6846: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6847:
6848: and template_flag = 'Y'
6849:
6850: and default_template = 'Y'

Line 6984: from msd_demand_plans

6980: and demand_plan_id =
6981:
6982: (select demand_plan_id
6983:
6984: from msd_demand_plans
6985:
6986: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6987:
6988: and template_flag = 'Y'

Line 6986: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)

6982: (select demand_plan_id
6983:
6984: from msd_demand_plans
6985:
6986: where plan_type = (select plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id)
6987:
6988: and template_flag = 'Y'
6989:
6990: and default_template = 'Y'

Line 7792: from msd_demand_plans

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
7793: where plan_type = 'EOL'
7794: and template_flag = 'Y'
7795: and default_template = 'Y'
7796: );