APPS.CSF_LOCUS_PUB dependencies on SDO_ORDINATE_ARRAY

Line 80: l_ordinates MDSYS.sdo_ordinate_array;

76: , p_direction IN NUMBER
77: , p_accuracyFactor IN NUMBER
78: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY
79: ) AS
80: l_ordinates MDSYS.sdo_ordinate_array;
81: i NUMBER;
82: l_api_name CONSTANT VARCHAR2(30) := 'WRITE_LOCUS';
83: BEGIN
84: IF (p_geom.sdo_gtype <> 2001)

Line 95: l_ordinates := MDSYS.sdo_ordinate_array(p_geom.sdo_point.x, p_geom.sdo_point.y);

91:
92: IF (p_geom.sdo_point IS NULL) THEN
93: l_ordinates := p_geom.sdo_ordinates;
94: ELSE
95: l_ordinates := MDSYS.sdo_ordinate_array(p_geom.sdo_point.x, p_geom.sdo_point.y);
96:
97: IF (p_geom.sdo_point.z IS NOT NULL) THEN
98: l_ordinates.EXTEND;
99: l_ordinates(3) := p_geom.sdo_point.z;

Line 862: , mdsys.sdo_ordinate_array( p_longitude_tbl(i), p_latitude_tbl(i) )

858: 2001
859: , l_srid
860: , mdsys.sdo_point_type( p_longitude_tbl(i), p_latitude_tbl(i), 0)
861: , mdsys.sdo_elem_info_array(1,1,1)
862: , mdsys.sdo_ordinate_array( p_longitude_tbl(i), p_latitude_tbl(i) )
863: )
864: WHERE location_id = p_location_id_tbl(i);
865:
866: IF fnd_api.to_boolean(p_commit) THEN

Line 1036: SDO_ORDINATE_ARRAY(:1, :2, :3, :4)), ''sdo_num_res=1'', 1) = ''TRUE'' ORDER BY dist';

1032:
1033: l_sql_stmt := 'SELECT /*+ INDEX(r CSF_LF_RDSEGS_N2) */ ROADSEGMENT_ID, SDO_NN_DISTANCE(1) dist
1034: FROM csf_lf_roadsegments' || l_tbl_sufx || ' r
1035: WHERE SDO_NN(r.ROADSEGMENT_GEOMETRY, SDO_GEOMETRY(2002,8307,null,SDO_ELEM_INFO_ARRAY(1,2,1),
1036: SDO_ORDINATE_ARRAY(:1, :2, :3, :4)), ''sdo_num_res=1'', 1) = ''TRUE'' ORDER BY dist';
1037:
1038: OPEN cursor_rdseg for l_sql_stmt USING p_longitude,p_latitude,p_longitude,p_latitude;
1039: LOOP
1040: FETCH cursor_rdseg INTO l_roadsegmentid, l_dist; -- fetch data into local variables