APPS.CSF_LOCUS_PUB dependencies on JTF_VARCHAR2_TABLE_2000

Line 551: RETURN jtf_varchar2_table_2000 IS

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:
553: TYPE geometry_tbl_type IS TABLE OF MDSYS.SDO_GEOMETRY;
554: l_geometry_tbl geometry_tbl_type;
555: l_geometry_str_tbl jtf_varchar2_table_2000;

Line 555: l_geometry_str_tbl jtf_varchar2_table_2000;

551: RETURN jtf_varchar2_table_2000 IS
552:
553: TYPE geometry_tbl_type IS TABLE OF MDSYS.SDO_GEOMETRY;
554: l_geometry_tbl geometry_tbl_type;
555: l_geometry_str_tbl jtf_varchar2_table_2000;
556: j PLS_INTEGER;
557:
558: CURSOR c_geometry IS
559: SELECT /*+ cardinality(l, 1) */

Line 574: l_geometry_str_tbl := jtf_varchar2_table_2000();

570: OPEN c_geometry;
571: FETCH c_geometry BULK COLLECT INTO l_geometry_tbl;
572: CLOSE c_geometry;
573:
574: l_geometry_str_tbl := jtf_varchar2_table_2000();
575:
576: FOR i IN 1..l_geometry_tbl.COUNT LOOP
577: l_geometry_str_tbl.extend(1);
578: IF l_geometry_tbl(i) IS NULL OR l_geometry_tbl(i).sdo_ordinates IS NULL THEN

Line 629: l_geometry_tbl jtf_varchar2_table_2000;

625: ) IS
626: l_api_version CONSTANT NUMBER := 1.0;
627: l_api_name CONSTANT VARCHAR2(30) := 'COMPUTE_AND_SAVE_ROUTE';
628:
629: l_geometry_tbl jtf_varchar2_table_2000;
630: i PLS_INTEGER;
631: l_route clob;
632:
633: l_from_segment_id NUMBER;