APPS.CSF_LOCUS_PUB SQL Statements

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

Line: 559

         SELECT SDO_GEOM.SDO_MBR(default_display_center)
          FROM csf_sdm_ctry_profiles
         WHERE country_profile_id = p_country_id;

Line: 595

     sql_stmt_str := 'SELECT default_display_center
                        FROM csf_sdm_ctry_profiles'||l_data_set_name ||'
                       WHERE country_profile_id = '|| p_country_id;

Line: 630

     sql_stmt_str := 'SELECT default_display_center
                        FROM csf_sdm_ctry_profiles'||l_data_set_name ||'
                       WHERE country_profile_id = '|| p_country_id;

Line: 663

      SELECT /*+ cardinality(l, 1) */
             roadsegment_geometry
        FROM csf_lf_roadsegments
           , TABLE (CAST (p_segment_id_tbl AS jtf_number_table )) l
       WHERE roadsegment_id = l.COLUMN_VALUE;

Line: 755

    INSERT INTO CSF_TDS_ROUTE_CACHE (
        ROUTE_CACHE_ID
      , SEGMENT_FROM
      , SIDE_FROM
      , SPOT_FROM
      , SEGMENT_TO
      , SIDE_TO
      , SPOT_TO
      , RESULTTIME
      , RESULTDISTANCE
      , ROUTE
      , DATETIME
      , HITCOUNT
      )
      VALUES (
        CSF_TDS_ROUTE_CACHE_S1.NEXTVAL
      , l_from_segment_id
      , p_start_side
      , p_start_offset
      , l_to_segment_id
      , p_end_side
      , p_end_offset
      , p_travel_time
      , p_travel_distance
      , empty_clob
      , SYSDATE
      , 1
      )
      RETURNING route INTO l_route;

Line: 819

   * in HZ_LOCATIONS will be updated with the Geometry containing the
   * Latitude and Longitude as given by the corresponding PLSQL Tables.
   */
  PROCEDURE compute_and_save_locuses(
    p_api_version      IN            NUMBER
  , p_init_msg_list    IN            VARCHAR2           DEFAULT NULL
  , p_commit           IN            VARCHAR2           DEFAULT NULL
  , x_return_status    OUT NOCOPY    VARCHAR2
  , x_msg_count        OUT NOCOPY    NUMBER
  , x_msg_data         OUT NOCOPY    VARCHAR2
  , p_srid             IN            NUMBER
  , p_location_id_tbl  IN            jtf_number_table
  , p_latitude_tbl     IN            jtf_number_table
  , p_longitude_tbl    IN            jtf_number_table
  ) IS
    l_api_version       CONSTANT NUMBER        := 1.0;

Line: 856

      UPDATE hz_locations
         SET geometry = mdsys.sdo_geometry(
                          2001
                        , l_srid
                        , mdsys.sdo_point_type( p_longitude_tbl(i), p_latitude_tbl(i), 0)
                        , mdsys.sdo_elem_info_array(1,1,1)
                        , mdsys.sdo_ordinate_array( p_longitude_tbl(i), p_latitude_tbl(i) )
                        )
       WHERE location_id = p_location_id_tbl(i);

Line: 951

    SELECT REPLACE(l_locus_string, ',', '.') INTO l_locus_string FROM dual;

Line: 1031

    select spatial_dataset into l_tbl_sufx from CSF_SPATIAL_CTRY_MAPPINGS where spatial_country_name = p_country or spatial_country_code = p_country;

Line: 1033

    l_sql_stmt := 'SELECT /*+ INDEX(r CSF_LF_RDSEGS_N2) */ ROADSEGMENT_ID, SDO_NN_DISTANCE(1) dist
                   FROM csf_lf_roadsegments' || l_tbl_sufx || '  r
                   WHERE SDO_NN(r.ROADSEGMENT_GEOMETRY, SDO_GEOMETRY(2002,8307,null,SDO_ELEM_INFO_ARRAY(1,2,1),
                   SDO_ORDINATE_ARRAY(:1, :2, :3, :4)), ''sdo_num_res=1'', 1) = ''TRUE''  ORDER BY dist';