DBA Data[Home] [Help]

APPS.MSC_POST_PRO dependencies on MSC_PLANS

Line 751: from msc_plans newp

747: ),
748: -- IO Perf:3693983: Don't Launch ATP Post Plan Processes for IO Plans
749: newp.plan_type
750: into l_new_plan_id, l_new_cp_plan_id, l_optimized_plan, l_plan_type
751: from msc_plans newp
752: where newp.plan_id = p_plan_id;
753:
754: EXCEPTION
755: WHEN NO_DATA_FOUND THEN

Line 918: from msc_plans

914: )
915: )
916: )
917: into l_old_plan_id, l_old_optimized_plan
918: from msc_plans
919: where copy_plan_id = p_plan_id;
920: EXCEPTION
921: when NO_DATA_FOUND then
922: l_plan_to_use := p_plan_id;

Line 1142: from msc_plans

1138:
1139: -- Bug 2516506 - select plan name also
1140: SELECT NVL(SUMMARY_FLAG,1), COMPILE_DESIGNATOR, trunc(plan_start_date)
1141: into l_summary_flag, l_plan_name, l_plan_start_date
1142: from msc_plans
1143: where plan_id = l_plan_to_use;
1144:
1145: -- for summary enhancement
1146: IF NVL(l_summary_flag,1) NOT IN (G_SF_SUMMARY_NOT_RUN, G_SF_PREALLOC_COMPLETED, G_SF_ATPPEG_COMPLETED, G_SF_SUMMARY_COMPLETED) THEN

Line 1197: update msc_plans

1193: END IF;
1194: END LOOP;
1195:
1196: BEGIN
1197: update msc_plans
1198: set summary_flag = G_SF_FULL_SUMMARY_RUNNING -- for summary enhancement: ATP is up hereafter
1199: where plan_id = l_plan_to_use;
1200: commit;
1201: EXCEPTION

Line 1256: update msc_plans

1252:
1253: -- refresh number should be updated before gather stats as gathering stats causes implicit commit
1254: BEGIN
1255: msc_util.msc_log ('LOAD_PLAN_SD: ' || 'updating summary flag and refresh number');
1256: update msc_plans
1257: set summary_flag = G_SF_SUMMARY_COMPLETED, -- For summary enhancement
1258: latest_refresh_number = (SELECT apps_lrn
1259: FROM MSC_PLAN_REFRESHES
1260: WHERE plan_id = l_plan_to_use)

Line 1275: update msc_plans

1271: WHEN OTHERS THEN
1272: ROLLBACK;
1273:
1274: IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
1275: update msc_plans
1276: set summary_flag = G_SF_PREALLOC_COMPLETED
1277: where plan_id = l_plan_to_use;
1278: ELSE
1279: update msc_plans

Line 1279: update msc_plans

1275: update msc_plans
1276: set summary_flag = G_SF_PREALLOC_COMPLETED
1277: where plan_id = l_plan_to_use;
1278: ELSE
1279: update msc_plans
1280: set summary_flag = G_SF_SUMMARY_NOT_RUN
1281: where plan_id = l_plan_to_use;
1282: END IF;
1283: commit;

Line 1316: update msc_plans

1312: WHEN OTHERS THEN
1313: -- For summary enhancement - No need to reset summary_flag here
1314: /*
1315: BEGIN
1316: update msc_plans
1317: set summary_flag = 1
1318: where plan_id = l_plan_to_use;
1319: commit;
1320: END;

Line 1388: from msc_plans

1384: -- ATP4drp obtain plan_type info.
1385: plan_type
1386: into l_summary_flag, l_plan_completion_date, l_last_refresh_number, l_plan_start_date, l_plan_type
1387: -- End ATP4drp
1388: from msc_plans
1389: where plan_id = p_plan_id;
1390: EXCEPTION
1391: WHEN NO_DATA_FOUND THEN
1392: msc_util.msc_log('Unable to find plan data');

Line 1472: update msc_plans

1468: -- End ATP4drp
1469:
1470:
1471: BEGIN
1472: update msc_plans
1473: set summary_flag = G_SF_NET_SUMMARY_RUNNING
1474: where plan_id = p_plan_id;
1475: commit;
1476: EXCEPTION

Line 1514: update msc_plans

1510: IF l_new_refresh_number = l_last_refresh_number THEN
1511: -- No change since last summary
1512: msc_util.msc_log('Load_Net_Plan: ' || 'No change since last summary');
1513: msc_util.msc_log('Load_Net_Plan: ' || 'updating summary flag and refresh number');
1514: update msc_plans
1515: set summary_flag = G_SF_SUMMARY_COMPLETED,
1516: latest_refresh_number = l_new_refresh_number
1517: where plan_id = p_plan_id;
1518: RETCODE := G_SUCCESS;

Line 1555: update msc_plans

1551: l_new_refresh_number);
1552:
1553: BEGIN
1554: msc_util.msc_log ('Load_Net_Plan: ' || 'updating summary flag and refresh number');
1555: update msc_plans
1556: set summary_flag = G_SF_SUMMARY_COMPLETED, -- For summary enhancement
1557: latest_refresh_number = l_new_refresh_number
1558: where plan_id = p_plan_id;
1559: END;

Line 1580: update msc_plans

1576:
1577: -- For summary enhancement - Need to rollback incomplete changes
1578: ROLLBACK;
1579:
1580: update msc_plans
1581: set summary_flag = G_SF_SUMMARY_COMPLETED
1582: where plan_id = p_plan_id;
1583: commit;
1584: END Load_Net_Plan;

Line 1785: msc_plans plans

1781: )
1782: ), 0)
1783: INTO l_use_bor, l_optimized_plan, l_constraint_plan
1784: FROM msc_designators desig,
1785: msc_plans plans
1786: WHERE plans.plan_id = p_plan_id
1787: AND desig.designator = plans.compile_designator
1788: AND desig.sr_instance_id = plans.sr_instance_id
1789: AND desig.organization_id = plans.organization_id;

Line 3439: FROM msc_plans

3435: l_table_name varchar2(30);
3436:
3437: CURSOR C_PLAN IS
3438: SELECT plan_id
3439: FROM msc_plans
3440: WHERE plan_id > p_plan_id
3441: AND NVL(SUMMARY_FLAG, 0) <> 0
3442: ORDER BY plan_id;
3443:

Line 3485: FROM msc_plans

3481: END;
3482: ELSE
3483: SELECT NVL(summary_flag, 0)
3484: INTO l_summary_flag
3485: FROM msc_plans
3486: WHERE plan_id = p_plan_id;
3487: END IF;
3488:
3489: msc_util.msc_log('summary_flag for plan : '|| p_plan_id || ' : '|| l_summary_flag);

Line 3857: --bug 2389523: use msc_plan_partitions instead of msc_plans

3853: --- select plan_ids
3854: BEGIN
3855: select plan_id
3856: bulk collect into plan_ids
3857: --bug 2389523: use msc_plan_partitions instead of msc_plans
3858: --from msc_plans
3859: from msc_plan_partitions
3860: order by plan_id;
3861:

Line 3858: --from msc_plans

3854: BEGIN
3855: select plan_id
3856: bulk collect into plan_ids
3857: --bug 2389523: use msc_plan_partitions instead of msc_plans
3858: --from msc_plans
3859: from msc_plan_partitions
3860: order by plan_id;
3861:
3862: END;

Line 4187: FROM msc_plans

4183: -- SELECT NVL(summary_flag,1)
4184: -- INTO l_summary_flag
4185: SELECT NVL(summary_flag,1), compile_designator
4186: INTO l_summary_flag, l_plan_name
4187: FROM msc_plans
4188: WHERE plan_id = p_plan_id;
4189:
4190: IF NVL(l_summary_flag,1) = 2 THEN
4191: msc_util.msc_log('Another session is running post-plan allocation program for this plan');

Line 4248: update msc_plans

4244: END IF;
4245: END LOOP;
4246:
4247: BEGIN
4248: update msc_plans
4249: set summary_flag = 2
4250: where plan_id = p_plan_id;
4251: commit;
4252: EXCEPTION

Line 6222: update msc_plans

6218: );
6219: msc_util.msc_log('inserted reservation rows in msc_alloc_demands :' || SQL%ROWCOUNT);
6220:
6221: BEGIN
6222: update msc_plans
6223: set summary_flag = 3
6224: where plan_id = p_plan_id;
6225: END;
6226:

Line 6239: update msc_plans

6235: msc_util.msc_log(sqlerrm);
6236: ERRBUF := sqlerrm;
6237:
6238: BEGIN
6239: update msc_plans
6240: set summary_flag = 1
6241: where plan_id = p_plan_id;
6242: commit;
6243: END;

Line 6316: FROM msc_plans plans,

6312:
6313: -- Bug 3491498, check if plan is ATPable. Moved up to check it prior to refresh MSC_ATP_PLAN_SN
6314: SELECT count(*)
6315: INTO l_count
6316: FROM msc_plans plans,
6317: msc_designators desig
6318: WHERE desig.inventory_atp_flag = 1
6319: AND plans.plan_id = p_plan_id
6320: AND plans.compile_designator = desig.designator

Line 6349: FROM msc_plans plans,

6345: -- Bug 3491498, moved prior to call to refresh MSC_ATP_PLAN_SN
6346: /*
6347: SELECT count(*)
6348: INTO l_count
6349: FROM msc_plans plans,
6350: msc_designators desig
6351: WHERE desig.inventory_atp_flag = 1
6352: AND plans.plan_id = p_plan_id
6353: AND plans.compile_designator = desig.designator

Line 6367: from msc_plans

6363: -- 24x7 ATP
6364: BEGIN
6365: select nvl (copy_plan_id, -1)
6366: into l_copy_plan_id
6367: from msc_plans
6368: where plan_id = p_plan_id
6369: -- IO Perf:3693983: Don't Launch ATP Post Plan Processes for IO Plans
6370: AND plan_type <> 4;
6371: EXCEPTION

Line 6383: UPDATE msc_plans

6379: msc_util.msc_log ('Plan determined to be a 24x7 plan');
6380: end if;
6381:
6382: IF l_count = 0 THEN
6383: UPDATE msc_plans
6384: SET summary_flag = 1
6385: WHERE plan_id = p_plan_id;
6386:
6387: COMMIT;

Line 6394: UPDATE msc_plans

6390:
6391: BEGIN
6392: msc_util.msc_log('before launching concurrent program');
6393: -- Bug 3292949
6394: UPDATE msc_plans
6395: SET summary_flag = 1
6396: WHERE plan_id = p_plan_id;
6397: msc_util.msc_log('Reset summary flag back to default:1 before conc prg launch');
6398: -- End Bug 3292949

Line 6409: UPDATE msc_plans /* for 24x7 ATP */

6405: p_plan_id,
6406: 2); -- Bug 3478888 Pass calling module as 2 as
6407: -- ATP Post Plan Processing is called from planning
6408:
6409: UPDATE msc_plans /* for 24x7 ATP */
6410: SET request_id = l_request_id
6411: WHERE plan_id = p_plan_id;
6412:
6413: COMMIT;

Line 7754: FROM msc_plans p,

7750: l_instance_id,
7751: l_org_id,
7752: l_cutoff_date,
7753: l_calendar_code
7754: FROM msc_plans p,
7755: msc_trading_partners tp
7756: WHERE p.plan_id = p_plan_id
7757: AND p.organization_id = tp.sr_tp_id
7758: AND p.sr_instance_id = tp.sr_instance_id

Line 8903: FROM msc_plans plans,

8899: msc_util.msc_log('Begin procedure atp_snapshot_hook');
8900:
8901: SELECT count(*)
8902: INTO l_count
8903: FROM msc_plans plans,
8904: msc_designators desig
8905: WHERE plans.plan_id = p_plan_id
8906: AND plans.plan_type <> 4
8907: AND plans.compile_designator = desig.designator