DBA Data[Home] [Help]

APPS.CSF_LOCUS_PUB dependencies on SDO_ORDINATE_ARRAY

Line 64: l_ordinates MDSYS.sdo_ordinate_array;

60: --added for LF enhancement of forced accuracy
61: ,p_accuracyFactor IN NUMBER
62: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY
63: ) AS
64: l_ordinates MDSYS.sdo_ordinate_array;
65: i NUMBER;
66: l_api_name CONSTANT VARCHAR2(30) := 'WRITE_LOCUS';
67: BEGIN
68: IF (p_geom.sdo_gtype <> 2001)

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

75:
76: IF (p_geom.sdo_point IS NULL) THEN
77: l_ordinates := p_geom.sdo_ordinates;
78: ELSE
79: l_ordinates := MDSYS.sdo_ordinate_array(p_geom.sdo_point.x, p_geom.sdo_point.y);
80:
81: IF (p_geom.sdo_point.z IS NOT NULL) THEN
82: l_ordinates.EXTEND;
83: l_ordinates(3) := p_geom.sdo_point.z;

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

754: 2001
755: , l_srid
756: , mdsys.sdo_point_type( p_longitude_tbl(i), p_latitude_tbl(i), 0)
757: , mdsys.sdo_elem_info_array(1,1,1)
758: , mdsys.sdo_ordinate_array( p_longitude_tbl(i), p_latitude_tbl(i) )
759: )
760: WHERE location_id = p_location_id_tbl(i);
761:
762: IF fnd_api.to_boolean(p_commit) THEN