DBA Data[Home] [Help]

APPS.WSH_LOCATIONS_PKG dependencies on SDO_GEOMETRY

Line 78: --TYPE Geometry_Tbl_Type IS TABLE OF MDSYS.SDO_GEOMETRY index by BINARY_INTEGER;

74: TYPE ID_Tbl_Type IS TABLE OF NUMBER index by BINARY_INTEGER;
75: TYPE Address_Tbl_Type IS TABLE OF VARCHAR2(2000) index by BINARY_INTEGER;
76: TYPE LocationCode_Tbl_Type IS TABLE OF VARCHAR2(1000) index by BINARY_INTEGER;
77: TYPE Date_Tbl_Type IS TABLE OF DATE index by BINARY_INTEGER;
78: --TYPE Geometry_Tbl_Type IS TABLE OF MDSYS.SDO_GEOMETRY index by BINARY_INTEGER;
79:
80: PROCEDURE get_site_number(pLocationIdTbl IN ID_Tbl_Type,
81: pLocationCodeTbl IN OUT NOCOPY LocationCode_Tbl_Type,
82: pUILocationCodeTbl IN OUT NOCOPY LocationCode_Tbl_Type);

Line 98: x_geometry OUT NOCOPY MDSYS.SDO_GEOMETRY,

94: x_return_status OUT NOCOPY VARCHAR2);
95:
96: PROCEDURE Create_Geometry (p_longitude IN NUMBER,
97: p_latitude IN NUMBER,
98: x_geometry OUT NOCOPY MDSYS.SDO_GEOMETRY,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_error_msg OUT NOCOPY VARCHAR2 );
101:
102: