APPS.CSF_LOCUS_PUB SQL Statements

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

Line: 495

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

Line: 526

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

Line: 559

      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: 651

    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: 715

   * 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: 752

      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);