APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on MSC_APPS_INSTANCES

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

492: --
493:
494: --
495: -- Called by Create Plan UI. This procedure will identify if ther
496: -- is a free partition available in MSC_APPS_INSTANCES. If yes then
497: -- it returns the plan_id. Otherwise it create a new partition by
498: -- performing DDL on all the partitioned tables. It store the new
499: -- plan_id in MSC_PLAN_PARTITIONS, marks it as being used and returns it
500: -- to the calling UI

Line 769: SELECT msc_apps_instances_s.nextval

765: x_msg_data := fnd_message.get;
766: return -1;
767:
768: /*
769: SELECT msc_apps_instances_s.nextval
770: INTO l_inst_id
771: FROM DUAL;
772:
773: create_inst_partitions_pvt( l_inst_id,x_return_status,x_msg_data);

Line 1247: FROM MSC_apps_instances

1243: PROCEDURE create_exist_inst_partitions( errbuf OUT NOCOPY VARCHAR2,
1244: retcode OUT NOCOPY NUMBER) IS
1245: CURSOR C_INSTANCE IS
1246: SELECT instance_id
1247: FROM MSC_apps_instances
1248: ORDER BY instance_id;
1249:
1250: l_instance_id NUMBER;
1251: x_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;

Line 1293: SELECT msc_apps_instances_s.nextval

1289: -- instance partition as default
1290: --
1291: if (instance_exists = FALSE) then
1292:
1293: SELECT msc_apps_instances_s.nextval
1294: INTO l_instance_id
1295: FROM DUAL;
1296:
1297: create_inst_partitions_pvt(l_instance_id,x_return_status,errbuf);

Line 1596: SELECT msc_apps_instances_s.nextval

1592:
1593: end if;
1594:
1595: FOR i in 1..inst_partition_count LOOP
1596: SELECT msc_apps_instances_s.nextval
1597: INTO l_inst_id
1598: FROM DUAL;
1599:
1600: create_inst_partitions_pvt( l_inst_id,x_return_status,errbuf);