eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_LOCUS_PUB dependencies on JTF_NUMBER_TABLE

Line 652: p_segment_id_tbl jtf_number_table

648: * @param p_segment_id_tbl Table of Segment IDs
649: * @param p_sampling_level Whats the Sampling Rate to be used on the Geometry
650: */
651: FUNCTION get_geometry_tbl(
652: p_segment_id_tbl jtf_number_table
653: , p_sampling_level VARCHAR2 DEFAULT NULL
654: )
655: RETURN jtf_varchar2_table_2000 IS
656:

Line 666: , TABLE (CAST (p_segment_id_tbl AS jtf_number_table )) l

662: CURSOR c_geometry IS
663: SELECT /*+ cardinality(l, 1) */
664: roadsegment_geometry
665: FROM csf_lf_roadsegments
666: , TABLE (CAST (p_segment_id_tbl AS jtf_number_table )) l
667: WHERE roadsegment_id = l.COLUMN_VALUE;
668:
669: FUNCTION get_coord(p_tbl_index NUMBER, p_coord_index NUMBER) RETURN NUMBER IS
670: BEGIN

Line 721: , p_segment_id_tbl IN jtf_number_table

717: , p_commit IN VARCHAR2
718: , x_return_status OUT NOCOPY VARCHAR2
719: , x_msg_count OUT NOCOPY NUMBER
720: , x_msg_data OUT NOCOPY VARCHAR2
721: , p_segment_id_tbl IN jtf_number_table
722: , p_start_side IN NUMBER
723: , p_start_offset IN NUMBER
724: , p_end_side IN NUMBER
725: , p_end_offset IN NUMBER

Line 830: , p_location_id_tbl IN jtf_number_table

826: , x_return_status OUT NOCOPY VARCHAR2
827: , x_msg_count OUT NOCOPY NUMBER
828: , x_msg_data OUT NOCOPY VARCHAR2
829: , p_srid IN NUMBER
830: , p_location_id_tbl IN jtf_number_table
831: , p_latitude_tbl IN jtf_number_table
832: , p_longitude_tbl IN jtf_number_table
833: ) IS
834: l_api_version CONSTANT NUMBER := 1.0;

Line 831: , p_latitude_tbl IN jtf_number_table

827: , x_msg_count OUT NOCOPY NUMBER
828: , x_msg_data OUT NOCOPY VARCHAR2
829: , p_srid IN NUMBER
830: , p_location_id_tbl IN jtf_number_table
831: , p_latitude_tbl IN jtf_number_table
832: , p_longitude_tbl IN jtf_number_table
833: ) IS
834: l_api_version CONSTANT NUMBER := 1.0;
835: l_api_name CONSTANT VARCHAR2(30) := 'COMPUTE_AND_SAVE_LOCUSES';

Line 832: , p_longitude_tbl IN jtf_number_table

828: , x_msg_data OUT NOCOPY VARCHAR2
829: , p_srid IN NUMBER
830: , p_location_id_tbl IN jtf_number_table
831: , p_latitude_tbl IN jtf_number_table
832: , p_longitude_tbl IN jtf_number_table
833: ) IS
834: l_api_version CONSTANT NUMBER := 1.0;
835: l_api_name CONSTANT VARCHAR2(30) := 'COMPUTE_AND_SAVE_LOCUSES';
836: