APPS.HZ_GEOCODE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 446

      SELECT al.lookup_code
      FROM   ar_lookups al
      WHERE  al.lookup_type = 'HZ_SPATIAL_VALID_COUNTRIES'
             AND al.lookup_code = p_country_code;

Line: 486

      SELECT vp.value
      FROM   v$parameter vp
      WHERE  LOWER(vp.name) = 'nls_numeric_characters';

Line: 1336

                                   ') for '||x_loc_id||', update not possible.',
	                           p_prefix=>'ERROR',
			           p_msg_level=>fnd_log.level_error);

Line: 1956

       "unexpected error occured" mesg from update_geometry() method.
     */

      IF LTRIM(RTRIM(l_err_resp)) IS NOT NULL THEN
       fnd_message.set_name('AR','HZ_MALFORMED_SPATIAL_RESPONSE');