APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on FND_PROFILE

Line 709: IF NVL(FND_PROFILE.Value('MSC_COLL_ERR_DEBUG' ), MSC_UTIL.G_LVL_STATUS) >= MSC_UTIL.G_LVL_DEV THEN

705: IS
706: BEGIN
707:
708: IF NOT v_is_initialized THEN RETURN FALSE; END IF;
709: IF NVL(FND_PROFILE.Value('MSC_COLL_ERR_DEBUG' ), MSC_UTIL.G_LVL_STATUS) >= MSC_UTIL.G_LVL_DEV THEN
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, '<> - Dropping temp tables is skipped as the Debug profile is set to DEV');
711: RETURN FALSE;
712: END IF;
713: FOR i IN 1..v_partTblList.COUNT LOOP

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

1872: /* creatIndexOnTempraryTable; */
1873:
1874: /* this profile option will determine the number of parallel threads to be used in creating the index in parallel*/
1875:
1876: SELECT to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS'))
1877: INTO lv_deg_parallel
1878: FROM dual;
1879:
1880: msc_manage_plan_partitions.get_partition_name

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

2327: BEGIN
2328:
2329: lv_schema:=msc_util.get_schema_name(724);
2330:
2331: -- row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2332: --
2333: -- Generate List of Instances passed --
2334: lv_inst_str := ',';
2335: FOR inst IN (select instance_id from MSC_INST_PARTITIONS )