APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on MSC_PLANS

Line 546: SELECT MSC_PLANS_S.nextval

542:
543: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
544:
545: if (share_partition = 'Y') then
546: SELECT MSC_PLANS_S.nextval
547: INTO l_plan_id
548: from dual;
549:
550: return l_plan_id;

Line 578: SELECT msc_plans_s.nextval

574: -- No free plans available. So create one.
575: --
576: /* CLOSE C_FREE_PLAN;
577:
578: SELECT msc_plans_s.nextval
579: INTO l_plan_id
580: FROm dual;
581:
582: --

Line 1061: FROM MSC_PLANS

1057: PROCEDURE create_exist_plan_partitions( errbuf OUT NOCOPY VARCHAR2,
1058: retcode OUT NOCOPY NUMBER) IS
1059: CURSOR C_PLAN IS
1060: SELECT plan_id, compile_designator
1061: FROM MSC_PLANS
1062: WHERE plan_id <> -1
1063: ORDER BY plan_id;
1064:
1065:

Line 1152: SELECT msc_plans_s.nextval

1148: --
1149: if (plan_exists = FALSE) then
1150: FOR i in 1..5 LOOP
1151:
1152: SELECT msc_plans_s.nextval
1153: INTO l_plan_id
1154: FROm dual;
1155: create_partition_pvt(l_plan_id,MAXVALUE,x_return_status,errbuf);
1156:

Line 1206: FROM MSC_PLANS

1202: PROCEDURE drop_exist_plan_partitions( errbuf OUT NOCOPY VARCHAR2,
1203: retcode OUT NOCOPY NUMBER) IS
1204: CURSOR C_PLAN IS
1205: SELECT plan_id
1206: FROM MSC_PLANS
1207: WHERE plan_id <> -1;
1208:
1209: l_plan_id NUMBER;
1210: x_return_status VARCHAR2(10);

Line 1522: SELECT msc_plans_s.nextval

1518: else
1519:
1520: FOR i in 1..plan_partition_count LOOP
1521:
1522: SELECT msc_plans_s.nextval
1523: INTO l_plan_id
1524: FROm dual;
1525:
1526: