APPS.CSF_LOCUS_PUB dependencies on CSF_TDS_ROUTE_CACHE

Line 712: * CSF_TDS_ROUTE_CACHE to be used in future computations.

708:
709: /**
710: * Computes the Geometry of the Route given as the Segment IDs
711: * Table and then saves the Geometry of the Route in
712: * CSF_TDS_ROUTE_CACHE to be used in future computations.
713: */
714: PROCEDURE compute_and_save_route(
715: p_api_version IN NUMBER
716: , p_init_msg_list IN VARCHAR2

Line 755: INSERT INTO CSF_TDS_ROUTE_CACHE (

751:
752: l_from_segment_id := p_segment_id_tbl(p_segment_id_tbl.FIRST);
753: l_to_segment_id := p_segment_id_tbl(p_segment_id_tbl.LAST);
754:
755: INSERT INTO CSF_TDS_ROUTE_CACHE (
756: ROUTE_CACHE_ID
757: , SEGMENT_FROM
758: , SIDE_FROM
759: , SPOT_FROM

Line 770: CSF_TDS_ROUTE_CACHE_S1.NEXTVAL

766: , DATETIME
767: , HITCOUNT
768: )
769: VALUES (
770: CSF_TDS_ROUTE_CACHE_S1.NEXTVAL
771: , l_from_segment_id
772: , p_start_side
773: , p_start_offset
774: , l_to_segment_id