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 548: p_segment_id_tbl jtf_number_table

544: * @param p_segment_id_tbl Table of Segment IDs
545: * @param p_sampling_level Whats the Sampling Rate to be used on the Geometry
546: */
547: FUNCTION get_geometry_tbl(
548: p_segment_id_tbl jtf_number_table
549: , p_sampling_level VARCHAR2 DEFAULT NULL
550: )
551: RETURN jtf_varchar2_table_2000 IS
552:

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

558: CURSOR c_geometry IS
559: SELECT /*+ cardinality(l, 1) */
560: roadsegment_geometry
561: FROM csf_lf_roadsegments
562: , TABLE (CAST (p_segment_id_tbl AS jtf_number_table )) l
563: WHERE roadsegment_id = l.COLUMN_VALUE;
564:
565: FUNCTION get_coord(p_tbl_index NUMBER, p_coord_index NUMBER) RETURN NUMBER IS
566: BEGIN

Line 617: , p_segment_id_tbl IN jtf_number_table

613: , p_commit IN VARCHAR2
614: , x_return_status OUT NOCOPY VARCHAR2
615: , x_msg_count OUT NOCOPY NUMBER
616: , x_msg_data OUT NOCOPY VARCHAR2
617: , p_segment_id_tbl IN jtf_number_table
618: , p_start_side IN NUMBER
619: , p_start_offset IN NUMBER
620: , p_end_side IN NUMBER
621: , p_end_offset IN NUMBER

Line 726: , p_location_id_tbl IN jtf_number_table

722: , x_return_status OUT NOCOPY VARCHAR2
723: , x_msg_count OUT NOCOPY NUMBER
724: , x_msg_data OUT NOCOPY VARCHAR2
725: , p_srid IN NUMBER
726: , p_location_id_tbl IN jtf_number_table
727: , p_latitude_tbl IN jtf_number_table
728: , p_longitude_tbl IN jtf_number_table
729: ) IS
730: l_api_version CONSTANT NUMBER := 1.0;

Line 727: , p_latitude_tbl IN jtf_number_table

723: , x_msg_count OUT NOCOPY NUMBER
724: , x_msg_data OUT NOCOPY VARCHAR2
725: , p_srid IN NUMBER
726: , p_location_id_tbl IN jtf_number_table
727: , p_latitude_tbl IN jtf_number_table
728: , p_longitude_tbl IN jtf_number_table
729: ) IS
730: l_api_version CONSTANT NUMBER := 1.0;
731: l_api_name CONSTANT VARCHAR2(30) := 'COMPUTE_AND_SAVE_LOCUSES';

Line 728: , p_longitude_tbl IN jtf_number_table

724: , x_msg_data OUT NOCOPY VARCHAR2
725: , p_srid IN NUMBER
726: , p_location_id_tbl IN jtf_number_table
727: , p_latitude_tbl IN jtf_number_table
728: , p_longitude_tbl IN jtf_number_table
729: ) IS
730: l_api_version CONSTANT NUMBER := 1.0;
731: l_api_name CONSTANT VARCHAR2(30) := 'COMPUTE_AND_SAVE_LOCUSES';
732: