APPS.CSF_TDS_PUB dependencies on FND_PROFILE

Line 144: -- SELECT NVL( TO_NUMBER(fnd_profile.value('CSR_MAX_TRAVEL_DIST_FOR_ESTIMATION')) ,100)

140: BEGIN
141: status := 1;
142: msg := 'SUCCESS';
143:
144: -- SELECT NVL( TO_NUMBER(fnd_profile.value('CSR_MAX_TRAVEL_DIST_FOR_ESTIMATION')) ,100)
145: -- ,NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
146: -- INTO threshhold, multiDataSetProfileValue
147: -- FROM dual;
148: -- Commented for bug 8289413

Line 145: -- ,NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')

141: status := 1;
142: msg := 'SUCCESS';
143:
144: -- SELECT NVL( TO_NUMBER(fnd_profile.value('CSR_MAX_TRAVEL_DIST_FOR_ESTIMATION')) ,100)
145: -- ,NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
146: -- INTO threshhold, multiDataSetProfileValue
147: -- FROM dual;
148: -- Commented for bug 8289413
149:

Line 151: ,NVL(fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED'),'N')

147: -- FROM dual;
148: -- Commented for bug 8289413
149:
150: SELECT NVL( TO_NUMBER(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxDistToSkipActual')) ,100)
151: ,NVL(fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED'),'N')
152: INTO threshhold, multiDataSetProfileEnabled
153: FROM dual;
154:
155: IF UPPER(multiDataSetProfileEnabled) = 'N' OR multiDataSetProfileEnabled IS NULL

Line 419: SELECT NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')

415:
416:
417: BEGIN
418:
419: SELECT NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
420: INTO multiDataSetProfileValue
421: FROM dual;
422:
423: IF UPPER(multiDataSetProfileValue) = 'NONE'

Line 485: l_fmt := fnd_profile.VALUE ('ICX_DATE_FORMAT_MASK');

481: END IF;
482:
483: --
484: -- get date format
485: l_fmt := fnd_profile.VALUE ('ICX_DATE_FORMAT_MASK');
486:
487: IF l_fmt IS NULL
488: THEN
489: l_fmt := 'dd-MON-yyyy';