APPS.CSF_LF_PUB dependencies on FND_PROFILE

Line 168: l_requiredAccuracy := NVL(fnd_profile.value('CSF_LOC_ACC_LEVELS'),''+0);

164: --l_result_int := RESOLVEADDRESS(p_country, p_state, p_city, p_postalCode, p_roadName, p_buildingnum, p_alternate);
165: --l_result_int := RESOLVEADDRESS(p_country, p_state, p_city, p_postalCode, p_roadName, '_', p_alternate);
166:
167: -- added for LF enhancement of forced accuracy
168: l_requiredAccuracy := NVL(fnd_profile.value('CSF_LOC_ACC_LEVELS'),''+0);
169:
170: /** Bug 7570463 **/
171: open ctry_hr_to_spatial;
172: fetch ctry_hr_to_spatial into l_country;

Line 270: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

266: --
267: l_numResults := l_result_int.count();
268: x_resultsArray := CSF_LF_RESULTARRAY();
269:
270: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
271: IF (l_data_set_name = 'NONE' OR l_data_set_name IS NULL ) THEN
272: l_data_set_name := '';
273: END IF;
274:

Line 409: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

405: /* select roadsegment_geometry into segmentGeometry
406: from csf_lf_roadsegments
407: where roadSegment_id = x_segid; */
408:
409: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
410: IF (l_data_set_name = 'NONE' OR l_data_set_name IS NULL ) THEN
411: l_data_set_name := '';
412: END IF;
413:

Line 554: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

550: /* select time_zone into x_timezone
551: from csf_lf_roadsegments
552: where roadsegment_id = p_locus.sdo_ordinates(6); */
553:
554: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
555: IF (l_data_set_name = 'NONE' OR l_data_set_name IS NULL ) THEN
556: l_data_set_name := '';
557: END IF;
558: sql_stmt_str := 'SELECT time_zone into x_timezone