APPS.WSH_LOCATIONS_PKG dependencies on SDO_GEOMETRY

Line 268: l_geometry MDSYS.SDO_GEOMETRY;

264: k NUMBER;
265: l_location_id NUMBER;
266: l_latitude NUMBER;
267: l_longitude NUMBER;
268: l_geometry MDSYS.SDO_GEOMETRY;
269: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_GEOMETRIES';
270:
271: BEGIN
272:

Line 399: l_geometry MDSYS.SDO_GEOMETRY;

395: l_previous_rows NUMBER;
396: l_current_rows NUMBER;
397: l_remaining_rows NUMBER;
398:
399: l_geometry MDSYS.SDO_GEOMETRY;
400: l_start_date DATE;
401: l_end_date DATE;
402: -- Cursor Declarations
403:

Line 2312: -- Function : Create a MDSYS.SDO_GEOMETRY Object from a longitude and latitude.

2308: -- Start of comments
2309: -- API name : Create_Geometry
2310: -- Type : Public
2311: -- Pre-reqs : None.
2312: -- Function : Create a MDSYS.SDO_GEOMETRY Object from a longitude and latitude.
2313: --
2314: -- Parameters :
2315: -- p_longitude IN NUMBER The Longitude.
2316: -- p_latitude IN NUMBER The Latitude.

Line 2318: -- x_geometry OUT MDSYS.SDO_GEOMETRY The geometry object created.

2314: -- Parameters :
2315: -- p_longitude IN NUMBER The Longitude.
2316: -- p_latitude IN NUMBER The Latitude.
2317: --
2318: -- x_geometry OUT MDSYS.SDO_GEOMETRY The geometry object created.
2319: -- x_status OUT VARCHAR2
2320: -- x_error_msg OUT VARCHAR2
2321: --
2322: -- Version : 1.0

Line 2329: x_geometry OUT NOCOPY MDSYS.SDO_GEOMETRY,

2325: -- End of comments
2326: -----------------------------------------------------------------------------------
2327: PROCEDURE Create_Geometry (p_longitude IN NUMBER,
2328: p_latitude IN NUMBER,
2329: x_geometry OUT NOCOPY MDSYS.SDO_GEOMETRY,
2330: x_return_status OUT NOCOPY VARCHAR2,
2331: x_error_msg OUT NOCOPY VARCHAR2 ) IS
2332:
2333: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_GEOMETRY';

Line 2347: x_geometry := MDSYS.SDO_GEOMETRY(2001, --SDO_GTYPE: Geometry type.

2343: END IF;
2344:
2345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2346:
2347: x_geometry := MDSYS.SDO_GEOMETRY(2001, --SDO_GTYPE: Geometry type.
2348: -- 2 indicates two-dimensional, 1 indicates a single point
2349: 8307, --SDO_SRID: 8307 is SRID for 'Long/Lat (WGS 84)' coordinate system
2350: MDSYS.SDO_POINT_TYPE(p_longitude, p_latitude, NULL),
2351: NULL, -- SDO_ELEM_INFO: Not needed if point_type