APPS.CSF_LOCUS_PUB dependencies on JTF_VARCHAR2_TABLE_2000

Line 655: RETURN jtf_varchar2_table_2000 IS

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:
657: TYPE geometry_tbl_type IS TABLE OF MDSYS.SDO_GEOMETRY;
658: l_geometry_tbl geometry_tbl_type;
659: l_geometry_str_tbl jtf_varchar2_table_2000;

Line 659: l_geometry_str_tbl jtf_varchar2_table_2000;

655: RETURN jtf_varchar2_table_2000 IS
656:
657: TYPE geometry_tbl_type IS TABLE OF MDSYS.SDO_GEOMETRY;
658: l_geometry_tbl geometry_tbl_type;
659: l_geometry_str_tbl jtf_varchar2_table_2000;
660: j PLS_INTEGER;
661:
662: CURSOR c_geometry IS
663: SELECT /*+ cardinality(l, 1) */

Line 678: l_geometry_str_tbl := jtf_varchar2_table_2000();

674: OPEN c_geometry;
675: FETCH c_geometry BULK COLLECT INTO l_geometry_tbl;
676: CLOSE c_geometry;
677:
678: l_geometry_str_tbl := jtf_varchar2_table_2000();
679:
680: FOR i IN 1..l_geometry_tbl.COUNT LOOP
681: l_geometry_str_tbl.extend(1);
682: IF l_geometry_tbl(i) IS NULL OR l_geometry_tbl(i).sdo_ordinates IS NULL THEN

Line 733: l_geometry_tbl jtf_varchar2_table_2000;

729: ) IS
730: l_api_version CONSTANT NUMBER := 1.0;
731: l_api_name CONSTANT VARCHAR2(30) := 'COMPUTE_AND_SAVE_ROUTE';
732:
733: l_geometry_tbl jtf_varchar2_table_2000;
734: i PLS_INTEGER;
735: l_route clob;
736:
737: l_from_segment_id NUMBER;