APPS.HZ_GEOCODE_PKG dependencies on SDO_GEOMETRY

Line 387: p_geometry IN mdsys.sdo_geometry,

383: --
384: PROCEDURE set_matching_geometry (
385: p_loc_array IN OUT NOCOPY loc_array,
386: p_location_id IN NUMBER,
387: p_geometry IN mdsys.sdo_geometry,
388: p_geometry_status_code IN VARCHAR2,
389: x_return_status IN OUT NOCOPY VARCHAR2,
390: x_msg_count IN OUT NOCOPY NUMBER,
391: x_msg_data IN OUT NOCOPY VARCHAR2

Line 1006: RETURN MDSYS.SDO_GEOMETRY

1002: p_zdp NUMBER DEFAULT NULL,
1003: p_info_array mdsys.SDO_ELEM_INFO_ARRAY DEFAULT NULL,
1004: p_ordi_array MDSYS.SDO_ORDINATE_ARRAY DEFAULT NULL,
1005: p_provider VARCHAR2 DEFAULT 'ELOCATION')
1006: RETURN MDSYS.SDO_GEOMETRY
1007: IS
1008: l_geo MDSYS.SDO_GEOMETRY;
1009: l_sdo_pt MDSYS.SDO_POINT_TYPE;
1010: BEGIN

Line 1008: l_geo MDSYS.SDO_GEOMETRY;

1004: p_ordi_array MDSYS.SDO_ORDINATE_ARRAY DEFAULT NULL,
1005: p_provider VARCHAR2 DEFAULT 'ELOCATION')
1006: RETURN MDSYS.SDO_GEOMETRY
1007: IS
1008: l_geo MDSYS.SDO_GEOMETRY;
1009: l_sdo_pt MDSYS.SDO_POINT_TYPE;
1010: BEGIN
1011: -- p_sdo_gtype = 2001; --
1012: -- p_sdo_srid = 8307; --

Line 1016: l_geo := MDSYS.SDO_GEOMETRY(p_sdo_gtype,

1012: -- p_sdo_srid = 8307; --
1013: l_sdo_pt := MDSYS.SDO_POINT_TYPE(p_xlo,
1014: p_yla,
1015: p_zdp);
1016: l_geo := MDSYS.SDO_GEOMETRY(p_sdo_gtype,
1017: p_sdo_srid,
1018: l_sdo_pt,
1019: p_info_array,
1020: p_ordi_array);

Line 1079: x_geo IN OUT NOCOPY mdsys.sdo_geometry,

1075:
1076: PROCEDURE parse_one_response (
1077: p_str IN VARCHAR2,
1078: x_loc_id IN OUT NOCOPY NUMBER,
1079: x_geo IN OUT NOCOPY mdsys.sdo_geometry,
1080: x_geo_status IN OUT NOCOPY VARCHAR2,
1081: x_return_status IN OUT NOCOPY VARCHAR2,
1082: x_msg_count IN OUT NOCOPY NUMBER,
1083: x_msg_data IN OUT NOCOPY VARCHAR2

Line 1379: l_geometry mdsys.sdo_geometry;

1375: j NUMBER;
1376: l_return_status VARCHAR2(20);
1377: l_msg_count NUMBER;
1378: l_msg_data VARCHAR2(2000);
1379: l_geometry mdsys.sdo_geometry;
1380: l_geometry_status_code VARCHAR2(30);
1381: l_location_id NUMBER;
1382: l_debug_prefix VARCHAR2(30) := '';
1383: BEGIN