DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on FND_PROFILE

Line 1605: SELECT to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS'))

1601: /* creatIndexOnTempraryTable; */
1602:
1603: /* this profile option will determine the number of parallel threads to be used in creating the index in parallel*/
1604:
1605: SELECT to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS'))
1606: INTO lv_deg_parallel
1607: FROM dual;
1608:
1609: msc_manage_plan_partitions.get_partition_name

Line 2059: -- row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));

2055: BEGIN
2056:
2057: lv_schema:=msc_util.get_schema_name(724);
2058:
2059: -- row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2060: --
2061: -- Generate List of Instances passed --
2062: lv_inst_str := ',';
2063: FOR inst IN (select instance_id from MSC_INST_PARTITIONS )