APPS.CSF_LF_GEOPVT dependencies on FND_PROFILE

Line 64: WHERE ACCURACY >= fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');

60: PROCEDURE delete_valid_geo_batch_address
61: IS
62: BEGIN
63: DELETE FROM csf_geo_batch_address
64: WHERE ACCURACY >= fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
65: commit;
66: END;
67:
68: PROCEDURE move_invalid_to_geo_batch(

Line 187: l_accuracy_lvl VARCHAR2(10) := NVL(fnd_profile.value('CSF_LOC_ACC_LEVELS'),''+0);

183: l_countryid VARCHAR2(40);
184: l_name VARCHAR2(100);
185: l_prevname VARCHAR2(100);
186: l_roadsegmentid VARCHAR2(40);
187: l_accuracy_lvl VARCHAR2(10) := NVL(fnd_profile.value('CSF_LOC_ACC_LEVELS'),''+0);
188: l_profile VARCHAR2(10);
189: l_acc_dist VARCHAR2(40);
190: l_sql_stmt VARCHAR2(2000);
191: l_dyn_tbl_name VARCHAR2(10) := NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'');

Line 191: l_dyn_tbl_name VARCHAR2(10) := NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'');

187: l_accuracy_lvl VARCHAR2(10) := NVL(fnd_profile.value('CSF_LOC_ACC_LEVELS'),''+0);
188: l_profile VARCHAR2(10);
189: l_acc_dist VARCHAR2(40);
190: l_sql_stmt VARCHAR2(2000);
191: l_dyn_tbl_name VARCHAR2(10) := NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'');
192:
193: TYPE ref_cursor_type IS REF CURSOR;
194:
195: --Cursor to find out the nearest geometry with in specified range from poi table