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_X_NETTING_PKG dependencies on MSC_PLAN_ORG_STATUS

Line 175: -- Make sure the the exeption group is exist in msc_plan_org_status

171:
172: BEGIN
173:
174: -------------------------------------------------------------------
175: -- Make sure the the exeption group is exist in msc_plan_org_status
176: -- for the first run. Use this table for set the refresh number
177: -- for each run by exception group. Status column will be
178: -- populated with refresh number
179: -------------------------------------------------------------------

Line 239: from msc_plan_org_status

235: IF (p_changed_order in (to_char(1), 'Y')) THEN
236:
237: select status
238: into l_changed_order_refnum
239: from msc_plan_org_status
240: where plan_id = G_PLAN_ID
241: and organization_id = G_GROUP8
242: and sr_instance_id = G_SR_INSTANCE_ID;
243: --dbms_output.put_line('Max refresh_number : ' || l_changed_order_refnum);

Line 304: update msc_plan_org_status

300: a_date4,
301: a_date5,
302: a_exception_basis);
303:
304: update msc_plan_org_status
305: set status = l_max_refresh_number,
306: status_date = sysdate
307: where plan_id = G_PLAN_ID
308: and organization_id = G_GROUP8

Line 322: from msc_plan_org_status

318: IF (p_late_order in (to_char(1), 'Y')) THEN
319:
320: select status
321: into l_late_order_refnum
322: from msc_plan_org_status
323: where plan_id = G_PLAN_ID
324: and organization_id = G_GROUP1
325: and sr_instance_id = G_SR_INSTANCE_ID;
326:

Line 389: update msc_plan_org_status

385: a_date5,
386: a_exception_basis);
387:
388:
389: update msc_plan_org_status
390: set status = l_max_refresh_number,
391: status_date = sysdate
392: where plan_id = G_PLAN_ID
393: and organization_id = G_GROUP1

Line 401: from msc_plan_org_status

397: IF (p_material_shortage in (to_char(1), 'Y')) THEN
398:
399: select status
400: into l_material_shortage_refnum
401: from msc_plan_org_status
402: where plan_id = G_PLAN_ID
403: and organization_id = G_GROUP2
404: and sr_instance_id = G_SR_INSTANCE_ID;
405: --dbms_output.put_line('Max refresh_number : ' || l_material_shortage_refnum);

Line 469: update msc_plan_org_status

465: a_date4,
466: a_date5,
467: a_exception_basis);
468:
469: update msc_plan_org_status
470: set status = l_max_refresh_number,
471: status_date = sysdate
472: where plan_id = G_PLAN_ID
473: and organization_id = G_GROUP2

Line 482: from msc_plan_org_status

478: IF (p_response_required in (to_char(1), 'Y')) THEN
479:
480: select status
481: into l_response_required_refnum
482: from msc_plan_org_status
483: where plan_id = G_PLAN_ID
484: and organization_id = G_GROUP3
485: and sr_instance_id = G_SR_INSTANCE_ID;
486: --dbms_output.put_line('Max refresh_number : ' || l_response_required_refnum);

Line 534: update msc_plan_org_status

530: a_date4,
531: a_date5,
532: a_exception_basis);
533:
534: update msc_plan_org_status
535: set status = l_max_refresh_number,
536: status_date = sysdate
537: where plan_id = G_PLAN_ID
538: and organization_id = G_GROUP3

Line 547: from msc_plan_org_status

543: IF (p_forecast_mismatch in (to_char(1), 'Y')) THEN
544:
545: select status
546: into l_forecast_mismatch_refnum
547: from msc_plan_org_status
548: where plan_id = G_PLAN_ID
549: and organization_id = G_GROUP5
550: and sr_instance_id = G_SR_INSTANCE_ID;
551: --dbms_output.put_line('Max refresh_number : ' || l_forecast_mismatch_refnum);

Line 614: update msc_plan_org_status

610: a_date5,
611: a_exception_basis);
612:
613:
614: update msc_plan_org_status
615: set status = l_max_refresh_number,
616: status_date = sysdate
617: where plan_id = G_PLAN_ID
618: and organization_id = G_GROUP5

Line 626: from msc_plan_org_status

622: END IF;
623: IF (p_early_order in (to_char(1), 'Y')) THEN
624: select status
625: into l_early_order_refnum
626: from msc_plan_org_status
627: where plan_id = G_PLAN_ID
628: and organization_id = G_GROUP6
629: and sr_instance_id = G_SR_INSTANCE_ID;
630: --dbms_output.put_line('Max refresh_number : ' || l_early_order_refnum);

Line 691: update msc_plan_org_status

687: a_date4,
688: a_date5,
689: a_exception_basis);
690:
691: update msc_plan_org_status
692: set status = l_max_refresh_number,
693: status_date = sysdate
694: where plan_id = G_PLAN_ID
695: and organization_id = G_GROUP6

Line 704: from msc_plan_org_status

700:
701:
702: select status
703: into l_material_excess_refnum
704: from msc_plan_org_status
705: where plan_id = G_PLAN_ID
706: and organization_id = G_GROUP7
707: and sr_instance_id = G_SR_INSTANCE_ID;
708: --dbms_output.put_line('Max refresh_number : ' || l_material_excess_refnum);

Line 777: update msc_plan_org_status

773: a_date4,
774: a_date5,
775: a_exception_basis);
776:
777: update msc_plan_org_status
778: set status = l_max_refresh_number,
779: status_date = sysdate
780: where plan_id = G_PLAN_ID
781: and organization_id = G_GROUP7

Line 789: from msc_plan_org_status

785: IF (p_forecast_accuracy in (to_char(1), 'Y')) THEN
786:
787: select status
788: into l_forecast_accuracy_refnum
789: from msc_plan_org_status
790: where plan_id = G_PLAN_ID
791: and organization_id = G_GROUP9
792: and sr_instance_id = G_SR_INSTANCE_ID;
793: --dbms_output.put_line('Max refresh_number : ' || l_forecast_accuracy_refnum);

Line 841: update msc_plan_org_status

837: a_date4,
838: a_date5,
839: a_exception_basis);
840:
841: update msc_plan_org_status
842: set status = l_max_refresh_number,
843: status_date = sysdate
844: where plan_id = G_PLAN_ID
845: and organization_id = G_GROUP9

Line 853: from msc_plan_org_status

849: IF (p_performance in (to_char(1), 'Y')) THEN
850:
851: select status
852: into l_performance_refnum
853: from msc_plan_org_status
854: where plan_id = G_PLAN_ID
855: and organization_id = G_GROUP10
856: and sr_instance_id = G_SR_INSTANCE_ID;
857: --dbms_output.put_line('Max refresh_number : ' || l_performance_refnum);

Line 905: update msc_plan_org_status

901: a_date4,
902: a_date5,
903: a_exception_basis);
904:
905: update msc_plan_org_status
906: set status = l_max_refresh_number,
907: status_date = sysdate
908: where plan_id = G_PLAN_ID
909: and organization_id = G_GROUP10

Line 1180: from msc_plan_org_status

1176: IF (p_potential_late_order in (to_char(1), 'Y')) THEN
1177:
1178: select status
1179: into l_potential_late_order_refnum
1180: from msc_plan_org_status
1181: where plan_id = G_PLAN_ID
1182: and organization_id = G_GROUP4
1183: and sr_instance_id = G_SR_INSTANCE_ID;
1184: --dbms_output.put_line('Max refresh_number : ' || l_potential_late_order_refnum);

Line 1244: update msc_plan_org_status

1240: a_date4,
1241: a_date5,
1242: a_exception_basis);
1243:
1244: update msc_plan_org_status
1245: set status = p_max_refresh_number,
1246: status_date = sysdate
1247: where plan_id = G_PLAN_ID
1248: and organization_id = G_GROUP4

Line 1335: from msc_plan_org_status

1331:
1332: select 1 into l_ret_flag
1333: from dual
1334: where exists ( select 1
1335: from msc_plan_org_status
1336: where plan_id = G_PLAN_ID
1337: and sr_instance_id = G_SR_INSTANCE_ID
1338: and organization_id = p_org_id
1339: );

Line 1362: from msc_plan_org_status

1358: BEGIN
1359:
1360: select count(*)
1361: into l_count
1362: from msc_plan_org_status
1363: where plan_id = -1
1364: and organization_id in (G_GROUP1,G_GROUP2,G_GROUP3,
1365: G_GROUP4,G_GROUP5,G_GROUP6,
1366: G_GROUP7,G_GROUP8,G_GROUP9,G_GROUP10);

Line 1372: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1368: IF (l_count <> 10) THEN
1369:
1370: IF ( does_exception_org_exist (G_GROUP1) <> 1) THEN
1371: --dbms_output.put_line('Inserting... ' || G_GROUP1);
1372: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1373: values (G_PLAN_ID, G_GROUP1, G_SR_INSTANCE_ID, 0, sysdate);
1374: END IF;
1375: IF ( does_exception_org_exist (G_GROUP2) <> 1) THEN
1376: --dbms_output.put_line('Inserting... ' || G_GROUP2);

Line 1377: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1373: values (G_PLAN_ID, G_GROUP1, G_SR_INSTANCE_ID, 0, sysdate);
1374: END IF;
1375: IF ( does_exception_org_exist (G_GROUP2) <> 1) THEN
1376: --dbms_output.put_line('Inserting... ' || G_GROUP2);
1377: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1378: values (G_PLAN_ID, G_GROUP2, G_SR_INSTANCE_ID, 0, sysdate);
1379: END IF;
1380: IF ( does_exception_org_exist (G_GROUP3) <> 1) THEN
1381: --dbms_output.put_line('Inserting... ' || G_GROUP3);

Line 1382: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1378: values (G_PLAN_ID, G_GROUP2, G_SR_INSTANCE_ID, 0, sysdate);
1379: END IF;
1380: IF ( does_exception_org_exist (G_GROUP3) <> 1) THEN
1381: --dbms_output.put_line('Inserting... ' || G_GROUP3);
1382: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1383: values (G_PLAN_ID, G_GROUP3, G_SR_INSTANCE_ID, 0, sysdate);
1384: END IF;
1385: IF ( does_exception_org_exist (G_GROUP4) <> 1) THEN
1386: --dbms_output.put_line('Inserting... ' || G_GROUP4);

Line 1387: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1383: values (G_PLAN_ID, G_GROUP3, G_SR_INSTANCE_ID, 0, sysdate);
1384: END IF;
1385: IF ( does_exception_org_exist (G_GROUP4) <> 1) THEN
1386: --dbms_output.put_line('Inserting... ' || G_GROUP4);
1387: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1388: values (G_PLAN_ID, G_GROUP4, G_SR_INSTANCE_ID, 0, sysdate);
1389: END IF;
1390: IF ( does_exception_org_exist (G_GROUP5) <> 1) THEN
1391: --dbms_output.put_line('Inserting... ' || G_GROUP5);

Line 1392: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1388: values (G_PLAN_ID, G_GROUP4, G_SR_INSTANCE_ID, 0, sysdate);
1389: END IF;
1390: IF ( does_exception_org_exist (G_GROUP5) <> 1) THEN
1391: --dbms_output.put_line('Inserting... ' || G_GROUP5);
1392: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1393: values (G_PLAN_ID, G_GROUP5, G_SR_INSTANCE_ID, 0, sysdate);
1394: END IF;
1395: IF ( does_exception_org_exist (G_GROUP6) <> 1) THEN
1396: --dbms_output.put_line('Inserting... ' || G_GROUP6);

Line 1397: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1393: values (G_PLAN_ID, G_GROUP5, G_SR_INSTANCE_ID, 0, sysdate);
1394: END IF;
1395: IF ( does_exception_org_exist (G_GROUP6) <> 1) THEN
1396: --dbms_output.put_line('Inserting... ' || G_GROUP6);
1397: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1398: values (G_PLAN_ID, G_GROUP6, G_SR_INSTANCE_ID, 0, sysdate);
1399: END IF;
1400: IF ( does_exception_org_exist (G_GROUP7) <> 1) THEN
1401: --dbms_output.put_line('Inserting... ' || G_GROUP7);

Line 1402: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1398: values (G_PLAN_ID, G_GROUP6, G_SR_INSTANCE_ID, 0, sysdate);
1399: END IF;
1400: IF ( does_exception_org_exist (G_GROUP7) <> 1) THEN
1401: --dbms_output.put_line('Inserting... ' || G_GROUP7);
1402: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1403: values (G_PLAN_ID, G_GROUP7, G_SR_INSTANCE_ID, 0, sysdate);
1404: END IF;
1405: IF ( does_exception_org_exist (G_GROUP8) <> 1) THEN
1406: --dbms_output.put_line('Inserting... ' || G_GROUP8);

Line 1407: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1403: values (G_PLAN_ID, G_GROUP7, G_SR_INSTANCE_ID, 0, sysdate);
1404: END IF;
1405: IF ( does_exception_org_exist (G_GROUP8) <> 1) THEN
1406: --dbms_output.put_line('Inserting... ' || G_GROUP8);
1407: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1408: values (G_PLAN_ID, G_GROUP8, G_SR_INSTANCE_ID, 0, sysdate);
1409: END IF;
1410: IF ( does_exception_org_exist (G_GROUP9) <> 1) THEN
1411: --dbms_output.put_line('Inserting... ' || G_GROUP9);

Line 1412: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1408: values (G_PLAN_ID, G_GROUP8, G_SR_INSTANCE_ID, 0, sysdate);
1409: END IF;
1410: IF ( does_exception_org_exist (G_GROUP9) <> 1) THEN
1411: --dbms_output.put_line('Inserting... ' || G_GROUP9);
1412: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1413: values (G_PLAN_ID, G_GROUP9, G_SR_INSTANCE_ID, 0, sysdate);
1414: END IF;
1415: IF ( does_exception_org_exist (G_GROUP10) <> 1) THEN
1416: --dbms_output.put_line('Inserting... ' || G_GROUP10);

Line 1417: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)

1413: values (G_PLAN_ID, G_GROUP9, G_SR_INSTANCE_ID, 0, sysdate);
1414: END IF;
1415: IF ( does_exception_org_exist (G_GROUP10) <> 1) THEN
1416: --dbms_output.put_line('Inserting... ' || G_GROUP10);
1417: insert into msc_plan_org_status(plan_id, organization_id, sr_instance_id,status, status_date)
1418: values (G_PLAN_ID, G_GROUP10, G_SR_INSTANCE_ID, 0, sysdate);
1419: END IF;
1420:
1421: END IF;