APPS.CSF_TDS_PUB dependencies on FND_PROFILE

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

133: BEGIN
134: status := 1;
135: msg := 'SUCCESS';
136:
137: SELECT NVL( TO_NUMBER(fnd_profile.value('CSR_MAX_TRAVEL_DIST_FOR_ESTIMATION')) ,100)
138: ,NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
139: INTO threshhold, multiDataSetProfileValue
140: FROM dual;
141:

Line 138: ,NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')

134: status := 1;
135: msg := 'SUCCESS';
136:
137: SELECT NVL( TO_NUMBER(fnd_profile.value('CSR_MAX_TRAVEL_DIST_FOR_ESTIMATION')) ,100)
138: ,NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
139: INTO threshhold, multiDataSetProfileValue
140: FROM dual;
141:
142: IF UPPER(multiDataSetProfileValue)= 'NONE'

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

387:
388:
389: BEGIN
390:
391: SELECT NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
392: INTO multiDataSetProfileValue
393: FROM dual;
394:
395: IF UPPER(multiDataSetProfileValue) = 'NONE'

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

453: END IF;
454:
455: --
456: -- get date format
457: l_fmt := fnd_profile.VALUE ('ICX_DATE_FORMAT_MASK');
458:
459: IF l_fmt IS NULL
460: THEN
461: l_fmt := 'dd-MON-yyyy';