APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on DUAL

Line 597: from dual;

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;
600: end if;
601:

Line 629: FROm dual;

625: /* CLOSE C_FREE_PLAN;
626:
627: SELECT msc_plans_s.nextval
628: INTO l_plan_id
629: FROm dual;
630:
631: --
632: -- now add a new partition to all the partitioned tables
633: --

Line 820: FROM DUAL;

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

Line 1204: FROm dual;

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:
1207: --
1208: -- break if partition creation fails

Line 1345: FROM DUAL;

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);
1348:
1349: --

Line 1578: FROm dual;

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

Line 1652: FROM DUAL;

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