[Home] [Help]
588: --
589: -- check if plans are sharing partitions
590: --
591:
592: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
593:
594: if (share_partition = 'Y') then
595: SELECT MSC_PLANS_S.nextval
596: INTO l_plan_id
1124: --
1125: -- check if plans are sharing partitions
1126: -- if yes then just create one partition and return
1127: --
1128: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
1129: -- dbms_output.put_line('share_partition := '||share_partition);
1130: if (share_partition = 'Y') then
1131: create_partition_pvt(PMAXVALUE,MAXVALUE,x_return_status,errbuf);
1132: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1401: lv_msc_schema VARCHAR2(30);
1402: is_partitioned VARCHAR2(10);
1403: v_snap_exist number;
1404: -- v_tree_exist number;
1405: v_analyze_plan_scope NUMBER := NVL(FND_PROFILE.VALUE('MSC_ANALYZE_PARTITION_SCOPE'),1);
1406:
1407:
1408: Cursor msc_schema IS
1409: SELECT a.oracle_username
1473:
1474: FOR i in 1..g_partition_count LOOP
1475:
1476:
1477: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
1478: if (share_partition= 'Y') then
1479: l_partition_name := partitioned_tables(i) || '_'
1480: || to_char(PMAXVALUE);
1481: else
1556: --
1557: -- check if plans are sharing partitions
1558: -- if yes then just create one partition and return
1559: --
1560: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
1561:
1562: -- dbms_output.put_line('share partitions :='||share_partition);
1563: if (share_partition = 'Y' and plan_partition_count > 0) then
1564: create_partition_pvt(PMAXVALUE,MAXVALUE,x_return_status,errbuf);