APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on MSC_APPS_INSTANCES

Line 545: -- is a free partition available in MSC_APPS_INSTANCES. If yes then

541: --
542:
543: --
544: -- Called by Create Plan UI. This procedure will identify if ther
545: -- is a free partition available in MSC_APPS_INSTANCES. If yes then
546: -- it returns the plan_id. Otherwise it create a new partition by
547: -- performing DDL on all the partitioned tables. It store the new
548: -- plan_id in MSC_PLAN_PARTITIONS, marks it as being used and returns it
549: -- to the calling UI

Line 818: SELECT msc_apps_instances_s.nextval

814: x_msg_data := fnd_message.get;
815: return -1;
816:
817: /*
818: SELECT msc_apps_instances_s.nextval
819: INTO l_inst_id
820: FROM DUAL;
821:
822: create_inst_partitions_pvt( l_inst_id,x_return_status,x_msg_data);

Line 1297: FROM MSC_apps_instances

1293: PROCEDURE create_exist_inst_partitions( errbuf OUT NOCOPY VARCHAR2,
1294: retcode OUT NOCOPY NUMBER) IS
1295: CURSOR C_INSTANCE IS
1296: SELECT instance_id
1297: FROM MSC_apps_instances
1298: ORDER BY instance_id;
1299:
1300: l_instance_id NUMBER;
1301: x_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;

Line 1343: SELECT msc_apps_instances_s.nextval

1339: -- instance partition as default
1340: --
1341: if (instance_exists = FALSE) then
1342:
1343: SELECT msc_apps_instances_s.nextval
1344: INTO l_instance_id
1345: FROM DUAL;
1346:
1347: create_inst_partitions_pvt(l_instance_id,x_return_status,errbuf);

Line 1650: SELECT msc_apps_instances_s.nextval

1646:
1647: end if;
1648:
1649: FOR i in 1..inst_partition_count LOOP
1650: SELECT msc_apps_instances_s.nextval
1651: INTO l_inst_id
1652: FROM DUAL;
1653:
1654: create_inst_partitions_pvt( l_inst_id,x_return_status,errbuf);