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 2309: -- Function : Create a MDSYS.SDO_GEOMETRY Object from a longitude and latitude.

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

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

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

Line 2326: x_geometry OUT NOCOPY MDSYS.SDO_GEOMETRY,

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

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

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