DBA Data[Home] [Help]

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on FND_PROFILE

Line 543: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

539: --
540: -- check if plans are sharing partitions
541: --
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

Line 1078: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

1074: --
1075: -- check if plans are sharing partitions
1076: -- if yes then just create one partition and return
1077: --
1078: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
1079: -- dbms_output.put_line('share_partition := '||share_partition);
1080: if (share_partition = 'Y') then
1081: create_partition_pvt(PMAXVALUE,MAXVALUE,x_return_status,errbuf);
1082: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

Line 1355: v_analyze_plan_scope NUMBER := NVL(FND_PROFILE.VALUE('MSC_ANALYZE_PARTITION_SCOPE'),1);

1351: lv_msc_schema VARCHAR2(30);
1352: is_partitioned VARCHAR2(10);
1353: v_snap_exist number;
1354: -- v_tree_exist number;
1355: v_analyze_plan_scope NUMBER := NVL(FND_PROFILE.VALUE('MSC_ANALYZE_PARTITION_SCOPE'),1);
1356:
1357:
1358: Cursor msc_schema IS
1359: SELECT a.oracle_username

Line 1427: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

1423:
1424: FOR i in 1..g_partition_count LOOP
1425:
1426:
1427: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
1428: if (share_partition= 'Y') then
1429: l_partition_name := partitioned_tables(i) || '_'
1430: || to_char(PMAXVALUE);
1431: else

Line 1506: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

1502: --
1503: -- check if plans are sharing partitions
1504: -- if yes then just create one partition and return
1505: --
1506: share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
1507:
1508: -- dbms_output.put_line('share partitions :='||share_partition);
1509: if (share_partition = 'Y' and plan_partition_count > 0) then
1510: create_partition_pvt(PMAXVALUE,MAXVALUE,x_return_status,errbuf);