eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 6230: update msc_plans

6226: );
6227: msc_util.msc_log('inserted reservation rows in msc_alloc_demands :' || SQL%ROWCOUNT);
6228:
6229: BEGIN
6230: update msc_plans
6231: set summary_flag = 3
6232: where plan_id = p_plan_id;
6233: END;
6234:

Line 6247: update msc_plans

6243: msc_util.msc_log(sqlerrm);
6244: ERRBUF := sqlerrm;
6245:
6246: BEGIN
6247: update msc_plans
6248: set summary_flag = 1
6249: where plan_id = p_plan_id;
6250: commit;
6251: END;

Line 6325: FROM msc_plans plans,

6321:
6322: -- Bug 3491498, check if plan is ATPable. Moved up to check it prior to refresh MSC_ATP_PLAN_SN
6323: SELECT count(*)
6324: INTO l_count
6325: FROM msc_plans plans,
6326: msc_designators desig
6327: WHERE desig.inventory_atp_flag = 1
6328: AND plans.plan_id = p_plan_id
6329: AND plans.compile_designator = desig.designator

Line 6358: FROM msc_plans plans,

6354: -- Bug 3491498, moved prior to call to refresh MSC_ATP_PLAN_SN
6355: /*
6356: SELECT count(*)
6357: INTO l_count
6358: FROM msc_plans plans,
6359: msc_designators desig
6360: WHERE desig.inventory_atp_flag = 1
6361: AND plans.plan_id = p_plan_id
6362: AND plans.compile_designator = desig.designator

Line 6376: from msc_plans

6372: -- 24x7 ATP
6373: BEGIN
6374: select nvl (copy_plan_id, -1)
6375: into l_copy_plan_id
6376: from msc_plans
6377: where plan_id = p_plan_id
6378: -- IO Perf:3693983: Don't Launch ATP Post Plan Processes for IO Plans
6379: AND plan_type <> 4;
6380: EXCEPTION

Line 6391: FROM msc_plans plans,

6387: IF l_copy_plan_id > 0 THEN
6388:
6389: SELECT count(*)
6390: INTO l_count1
6391: FROM msc_plans plans,
6392: msc_designators desig
6393: WHERE desig.inventory_atp_flag = 1
6394: AND plans.plan_id = l_copy_plan_id
6395: AND plans.compile_designator = desig.designator

Line 6412: UPDATE msc_plans

6408: msc_util.msc_log ('Plan determined to be a 24x7 plan');
6409: end if;
6410:
6411: IF l_count = 0 THEN
6412: UPDATE msc_plans
6413: SET summary_flag = 1
6414: WHERE plan_id = p_plan_id;
6415:
6416: COMMIT;

Line 6423: UPDATE msc_plans

6419:
6420: BEGIN
6421: msc_util.msc_log('before launching concurrent program');
6422: -- Bug 3292949
6423: UPDATE msc_plans
6424: SET summary_flag = 1
6425: WHERE plan_id = p_plan_id;
6426: msc_util.msc_log('Reset summary flag back to default:1 before conc prg launch');
6427: -- End Bug 3292949

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

6434: p_plan_id,
6435: 2); -- Bug 3478888 Pass calling module as 2 as
6436: -- ATP Post Plan Processing is called from planning
6437:
6438: UPDATE msc_plans /* for 24x7 ATP */
6439: SET request_id = l_request_id
6440: WHERE plan_id = p_plan_id;
6441:
6442: COMMIT;

Line 7783: FROM msc_plans p,

7779: l_instance_id,
7780: l_org_id,
7781: l_cutoff_date,
7782: l_calendar_code
7783: FROM msc_plans p,
7784: msc_trading_partners tp
7785: WHERE p.plan_id = p_plan_id
7786: AND p.organization_id = tp.sr_tp_id
7787: AND p.sr_instance_id = tp.sr_instance_id

Line 8941: FROM msc_plans plans,

8937: msc_util.msc_log('Begin procedure atp_snapshot_hook');
8938:
8939: SELECT count(*)
8940: INTO l_count
8941: FROM msc_plans plans,
8942: msc_designators desig
8943: WHERE plans.plan_id = p_plan_id
8944: AND plans.plan_type <> 4
8945: AND plans.compile_designator = desig.designator