APPS.CSF_LOCUS_PUB dependencies on CSF_TDS_ROUTE_CACHE

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

604:
605: /**
606: * Computes the Geometry of the Route given as the Segment IDs
607: * Table and then saves the Geometry of the Route in
608: * CSF_TDS_ROUTE_CACHE to be used in future computations.
609: */
610: PROCEDURE compute_and_save_route(
611: p_api_version IN NUMBER
612: , p_init_msg_list IN VARCHAR2

Line 651: INSERT INTO CSF_TDS_ROUTE_CACHE (

647:
648: l_from_segment_id := p_segment_id_tbl(p_segment_id_tbl.FIRST);
649: l_to_segment_id := p_segment_id_tbl(p_segment_id_tbl.LAST);
650:
651: INSERT INTO CSF_TDS_ROUTE_CACHE (
652: ROUTE_CACHE_ID
653: , SEGMENT_FROM
654: , SIDE_FROM
655: , SPOT_FROM

Line 666: CSF_TDS_ROUTE_CACHE_S1.NEXTVAL

662: , DATETIME
663: , HITCOUNT
664: )
665: VALUES (
666: CSF_TDS_ROUTE_CACHE_S1.NEXTVAL
667: , l_from_segment_id
668: , p_start_side
669: , p_start_offset
670: , l_to_segment_id