APPS.CSF_TDS_PUB SQL Statements

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

Line: 32

route_cache_qry := 'SELECT  distinct  FROM_SEGMENT_ID
                    FROM csf_tds_route_cache'||multiDataSetProfileValue ||'
                    WHERE CONFIG = '||l_config_string||'  AND
                    FROM_SEGMENT_ID = '||l_from_segment_id||'  AND
                    FROM_SEGMENT_SIDE = '|| l_from_side ||' AND
                    FROM_SEGMENT_POSITION = '|| l_from_spot ||' AND
                    TO_SEGMENT_ID = '||l_to_segment_id||' AND
                    TO_SEGMENT_SIDE  = '||l_to_side || ' AND
                    TO_SEGMENT_POSITION  = '||l_to_spot;

Line: 64

   SELECT where_clause
   FROM csf_dc_queries_b
   WHERE query_id = qid;

Line: 137

   SELECT NVL( TO_NUMBER(fnd_profile.value('CSR_MAX_TRAVEL_DIST_FOR_ESTIMATION')) ,100)
   ,NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
   INTO threshhold, multiDataSetProfileValue
   FROM dual;

Line: 160

    res_qry_stmt := ' SELECT DISTINCT  csf_locus_pub.get_locus_segmentid(geometry) AS  segment_id,
    csf_locus_pub.get_locus_spot(geometry) AS  spot,
    csf_locus_pub.get_locus_side(geometry) AS  side,
    csf_locus_pub.get_locus_lat(geometry) AS  lat,
    csf_locus_pub.get_locus_lon(geometry) AS  lon,
    csf_locus_pub.get_locus_srid(geometry) AS  srid,
    tile_id
   FROM hz_locations loc,
    csf_tds_segments'||multiDataSetProfileValue ||' seg,
    jtf_terr_rsc_all rsc,
    jtf_terr_usgs_all usg,
    jtf_rs_resource_extns extn,
    hz_party_sites site,
    per_all_people_f ppl
   WHERE  usg.source_id = -1002
    AND rsc.terr_id = usg.terr_id
    AND rsc.resource_id = extn.resource_id
    AND extn.source_id = ppl.person_id
    AND ppl.party_id  = site.party_id
    AND site.location_id = loc.location_id
    AND csf_locus_pub.get_locus_segmentid(geometry) = seg.SEGMENT_ID
    AND geometry IS NOT NULL
    AND loc.location_id > 0';

Line: 185

   task_qry_stmt := 'SELECT  DISTINCT  csf_locus_pub.get_locus_segmentid(geometry) AS   segment_id,
                csf_locus_pub.get_locus_spot(geometry) AS spot,
                csf_locus_pub.get_locus_side(geometry) AS side,
                csf_locus_pub.get_locus_lat(geometry) AS LAT,
                csf_locus_pub.get_locus_lon(geometry) AS LON,
                csf_locus_pub.GET_LOCUS_SRID(geometry) AS SRID,
                tile_id
                FROM hz_locations a,csf_tds_segments'||multiDataSetProfileValue ||'  seg
                WHERE  geometry is not null
                AND  a.location_id > 0
                AND  csf_locus_pub.get_locus_segmentid(geometry) = seg.SEGMENT_ID
                AND a.location_id IN (SELECT location_id
                FROM csf_ct_tasks WHERE ' || wClause || '   )';

Line: 227

                  INSERT INTO csf_tds_route_to_be_calculated
                 (SEGMENT_ID_FROM, SIDE_FROM, SPOT_FROM, SRID_FROM,
                  LATITUDE_FROM, LONGITUDE_FROM, SEGMENT_ID_TO, SIDE_TO,
                  SPOT_TO, SRID_TO, LATITUDE_TO, LONGITUDE_TO, USER_ID,
                  FROM_TILE_ID,  TO_TILE_ID)
                  VALUES (l_segment_id_inner, -- SEGMENT_ID_FROM
                  l_side_inner, --SIDE_FROM
                  l_spot_inner, --SPOT_FROM
                  l_SRID_inner, --SRID_FROM
                  l_lat_inner,  --LATITUDE_FROM
                  l_lon_inner,  --LONGITUDE_FROM
                  l_segment_id, --SEGMENT_ID_TO
                  l_side, -- SIDE_TO
                  l_spot, -- SPOT_TO
                  l_SRID, --SRID_TO
                  l_lat, --LATITUDE_TO
                  l_lon, -- LONGITUDE_TO
                  user_id,  -- USER_ID
                  l_tile_id_inner, -- FROM_SEGMENT_TILE_ID
                  l_tile_id -- TO_SEGMENT_TILE_ID
                  );

Line: 285

              INSERT INTO csf_tds_route_to_be_calculated
               (SEGMENT_ID_FROM, SIDE_FROM, SPOT_FROM, SRID_FROM,
                LATITUDE_FROM, LONGITUDE_FROM, SEGMENT_ID_TO, SIDE_TO,
                SPOT_TO, SRID_TO, LATITUDE_TO, LONGITUDE_TO, USER_ID,
                FROM_TILE_ID,  TO_TILE_ID)
                VALUES (l_segment_id, -- SEGMENT_ID_FROM
                l_side, --SIDE_FROM
                l_spot, --SPOT_FROM
                l_SRID, --SRID_FROM
                l_lat,  --LATITUDE_FROM
                l_lon,  --LONGITUDE_FROM
                l_segment_id_inner, --SEGMENT_ID_TO
                l_side_inner, -- SIDE_TO
                l_spot_inner, -- SPOT_TO
                l_SRID_inner, --SRID_TO
                l_lat_inner, --LATITUDE_TO
                l_lon_inner, -- LONGITUDE_TO
                user_id,  -- USER_ID
                l_tile_id, -- FROM_SEGMENT_TILE_ID
                l_tile_id_inner -- TO_SEGMENT_TILE_ID
                );

Line: 391

      SELECT NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
      INTO multiDataSetProfileValue
      FROM dual;

Line: 476

       l_del_qry := 'DELETE FROM CSF_TDS_ROUTE_CACHE'||multiDataSetProfileValue
      ||'  WHERE HITCOUNT = 0
           AND CREATION_DATE >= :1
           AND CREATION_DATE <= :2';