APPS.HZ_GEOCODE_PKG dependencies on SDO_GEOMETRY

Line 393: p_geometry IN mdsys.sdo_geometry,

389: --
390: PROCEDURE set_matching_geometry (
391: p_loc_array IN OUT NOCOPY loc_array,
392: p_location_id IN NUMBER,
393: p_geometry IN mdsys.sdo_geometry,
394: p_geometry_status_code IN VARCHAR2,
395: p_geometry_accuracy IN NUMBER,
396: x_return_status IN OUT NOCOPY VARCHAR2,
397: x_msg_count IN OUT NOCOPY NUMBER,

Line 1031: RETURN MDSYS.SDO_GEOMETRY

1027: p_zdp NUMBER DEFAULT NULL,
1028: p_info_array mdsys.SDO_ELEM_INFO_ARRAY DEFAULT NULL,
1029: p_ordi_array MDSYS.SDO_ORDINATE_ARRAY DEFAULT NULL,
1030: p_provider VARCHAR2 DEFAULT 'ELOCATION')
1031: RETURN MDSYS.SDO_GEOMETRY
1032: IS
1033: l_geo MDSYS.SDO_GEOMETRY;
1034: l_sdo_pt MDSYS.SDO_POINT_TYPE;
1035: BEGIN

Line 1033: l_geo MDSYS.SDO_GEOMETRY;

1029: p_ordi_array MDSYS.SDO_ORDINATE_ARRAY DEFAULT NULL,
1030: p_provider VARCHAR2 DEFAULT 'ELOCATION')
1031: RETURN MDSYS.SDO_GEOMETRY
1032: IS
1033: l_geo MDSYS.SDO_GEOMETRY;
1034: l_sdo_pt MDSYS.SDO_POINT_TYPE;
1035: BEGIN
1036: -- p_sdo_gtype = 2001; --
1037: -- p_sdo_srid = 8307; --

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

1037: -- p_sdo_srid = 8307; --
1038: l_sdo_pt := MDSYS.SDO_POINT_TYPE(p_xlo,
1039: p_yla,
1040: p_zdp);
1041: l_geo := MDSYS.SDO_GEOMETRY(p_sdo_gtype,
1042: p_sdo_srid,
1043: l_sdo_pt,
1044: p_info_array,
1045: p_ordi_array);

Line 1106: x_geo IN OUT NOCOPY mdsys.sdo_geometry,

1102:
1103: PROCEDURE parse_one_response (
1104: p_str IN VARCHAR2,
1105: x_loc_id IN OUT NOCOPY NUMBER,
1106: x_geo IN OUT NOCOPY mdsys.sdo_geometry,
1107: x_geo_status IN OUT NOCOPY VARCHAR2,
1108: x_geometry_accuracy IN OUT NOCOPY NUMBER,
1109: x_return_status IN OUT NOCOPY VARCHAR2,
1110: x_msg_count IN OUT NOCOPY NUMBER,

Line 1426: l_geometry mdsys.sdo_geometry;

1422: j NUMBER;
1423: l_return_status VARCHAR2(20);
1424: l_msg_count NUMBER;
1425: l_msg_data VARCHAR2(2000);
1426: l_geometry mdsys.sdo_geometry;
1427: l_geometry_status_code VARCHAR2(30);
1428: l_location_id NUMBER;
1429: l_debug_prefix VARCHAR2(30) := '';
1430: l_geometry_accuracy NUMBER;