DBA Data[Home] [Help]

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on MSC_PLANS_S

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 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 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: