APPS.IRC_LOCATION_UTILITY dependencies on SDO_GEOMETRY

Line 377: return MDSYS.SDO_GEOMETRY

373: -- -------------------------------------------------------------------------
374: --
375: function process_return_xml
376: (xml_response varchar2)
377: return MDSYS.SDO_GEOMETRY
378: as
379: address_doc xmldom.DOMDocument;
380: match_nodes xmlDom.DOMNodeList;
381: match_node xmlDom.DOMNode;

Line 404: RETURN MDSYS.SDO_GEOMETRY(2001

400: end if;
401: xmldom.freeDocument(address_doc);
402: hr_utility.set_location(l_proc, 40);
403: if (l_longitude is not null and l_latitude is not null) then
404: RETURN MDSYS.SDO_GEOMETRY(2001
405: ,8307
406: ,MDSYS.SDO_POINT_TYPE
407: (l_longitude
408: ,l_latitude

Line 438: RETURN MDSYS.SDO_GEOMETRY

434: ,street varchar2 default null
435: ,city varchar2 default null
436: ,state varchar2 default null
437: ,zip_code varchar2 default null)
438: RETURN MDSYS.SDO_GEOMETRY
439: AS
440: xml_response VARCHAR2(32767);
441: l_proc varchar2(72) := g_package||'address2geometry';
442: BEGIN

Line 469: return MDSYS.SDO_GEOMETRY

465: ,order1_area varchar2 default null
466: ,country varchar2 default null
467: ,postal_code varchar2 default null
468: ,postal_addon_code varchar2 default null)
469: return MDSYS.SDO_GEOMETRY
470: AS
471: i number;
472: xml_response VARCHAR2(32767);
473: l_proc varchar2(72) := g_package||'address2geometry';

Line 511: return MDSYS.SDO_GEOMETRY

507: ,address_line7 varchar2 default null
508: ,address_line8 varchar2 default null
509: ,address_line9 varchar2 default null
510: ,country varchar2 default null)
511: return MDSYS.SDO_GEOMETRY
512: AS
513: i number;
514: xml_response VARCHAR2(32767);
515: l_proc varchar2(72) := g_package||'address2geometry';

Line 727: ,geometry out nocopy MDSYS.SDO_GEOMETRY

723: ,order2_area out nocopy varchar2
724: ,order8_area out nocopy varchar2
725: ,country_name out nocopy varchar2
726: ,postal_code out nocopy varchar2
727: ,geometry out nocopy MDSYS.SDO_GEOMETRY
728: )
729: AS
730: i number;
731: xml_response VARCHAR2(32767);

Line 781: geometry :=MDSYS.SDO_GEOMETRY(2001

777: xslprocessor.valueOf(address_node,'@postal_code',postal_code);
778: xslprocessor.valueOf(match_node,'@longitude',l_longitude);
779: xslprocessor.valueOf(match_node,'@latitude',l_latitude);
780: if (l_longitude is not null and l_latitude is not null) then
781: geometry :=MDSYS.SDO_GEOMETRY(2001
782: ,8307
783: ,MDSYS.SDO_POINT_TYPE
784: (l_longitude
785: ,l_latitude

Line 807: (geom1 in MDSYS.SDO_GEOMETRY

803: -- -------------------------------------------------------------------------
804: -- wrapper for sdo_geom.sdo_distance function
805: --
806: function sdo_distance
807: (geom1 in MDSYS.SDO_GEOMETRY
808: ,geom2 in MDSYS.SDO_GEOMETRY
809: ,tolerance in number) return number
810: as
811: l_retval number;

Line 808: ,geom2 in MDSYS.SDO_GEOMETRY

804: -- wrapper for sdo_geom.sdo_distance function
805: --
806: function sdo_distance
807: (geom1 in MDSYS.SDO_GEOMETRY
808: ,geom2 in MDSYS.SDO_GEOMETRY
809: ,tolerance in number) return number
810: as
811: l_retval number;
812: begin

Line 828: (geom1 in MDSYS.SDO_GEOMETRY

824: -- -------------------------------------------------------------------------
825: -- wrapper for sdo_geom.sdo_distance function
826: --
827: function sdo_miles
828: (geom1 in MDSYS.SDO_GEOMETRY
829: ,geom2 in MDSYS.SDO_GEOMETRY
830: ,tolerance in number) return number
831: as
832: begin

Line 829: ,geom2 in MDSYS.SDO_GEOMETRY

825: -- wrapper for sdo_geom.sdo_distance function
826: --
827: function sdo_miles
828: (geom1 in MDSYS.SDO_GEOMETRY
829: ,geom2 in MDSYS.SDO_GEOMETRY
830: ,tolerance in number) return number
831: as
832: begin
833: if geom1 is null or geom2 is null then