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_MANAGE_PLAN_PARTITIONS dependencies on MSC_PLANS

Line 595: SELECT MSC_PLANS_S.nextval

591:
592: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
593:
594: if (share_partition = 'Y') then
595: SELECT MSC_PLANS_S.nextval
596: INTO l_plan_id
597: from dual;
598:
599: return l_plan_id;

Line 627: SELECT msc_plans_s.nextval

623: -- No free plans available. So create one.
624: --
625: /* CLOSE C_FREE_PLAN;
626:
627: SELECT msc_plans_s.nextval
628: INTO l_plan_id
629: FROm dual;
630:
631: --

Line 1111: FROM MSC_PLANS

1107: PROCEDURE create_exist_plan_partitions( errbuf OUT NOCOPY VARCHAR2,
1108: retcode OUT NOCOPY NUMBER) IS
1109: CURSOR C_PLAN IS
1110: SELECT plan_id, compile_designator
1111: FROM MSC_PLANS
1112: WHERE plan_id <> -1
1113: ORDER BY plan_id;
1114:
1115:

Line 1202: SELECT msc_plans_s.nextval

1198: --
1199: if (plan_exists = FALSE) then
1200: FOR i in 1..5 LOOP
1201:
1202: SELECT msc_plans_s.nextval
1203: INTO l_plan_id
1204: FROm dual;
1205: create_partition_pvt(l_plan_id,MAXVALUE,x_return_status,errbuf);
1206:

Line 1256: FROM MSC_PLANS

1252: PROCEDURE drop_exist_plan_partitions( errbuf OUT NOCOPY VARCHAR2,
1253: retcode OUT NOCOPY NUMBER) IS
1254: CURSOR C_PLAN IS
1255: SELECT plan_id
1256: FROM MSC_PLANS
1257: WHERE plan_id <> -1;
1258:
1259: l_plan_id NUMBER;
1260: x_return_status VARCHAR2(10);

Line 1576: SELECT msc_plans_s.nextval

1572: else
1573:
1574: FOR i in 1..plan_partition_count LOOP
1575:
1576: SELECT msc_plans_s.nextval
1577: INTO l_plan_id
1578: FROm dual;
1579:
1580: