APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on DUAL

Line 548: from dual;

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;
551: end if;
552:

Line 580: FROm dual;

576: /* CLOSE C_FREE_PLAN;
577:
578: SELECT msc_plans_s.nextval
579: INTO l_plan_id
580: FROm dual;
581:
582: --
583: -- now add a new partition to all the partitioned tables
584: --

Line 771: FROM DUAL;

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);
774:
775: if x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1154: FROm dual;

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:
1157: --
1158: -- break if partition creation fails

Line 1295: FROM DUAL;

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);
1298:
1299: --

Line 1524: FROm dual;

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:
1527: --
1528: -- now add a new partition to all the partitioned tables

Line 1598: FROM DUAL;

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);
1601:
1602: if x_return_status = FND_API.G_RET_STS_ERROR THEN