APPS.IRC_LOCATION_UTILITY dependencies on SDO_GEOMETRY

Line 16: RETURN MDSYS.SDO_GEOMETRY;

12: ,street varchar2 default null
13: ,city varchar2 default null
14: ,state varchar2 default null
15: ,zip_code varchar2 default null)
16: RETURN MDSYS.SDO_GEOMETRY;
17: -- -------------------------------------------------------------------------
18: -- |---------------------------< address2geometry >------------------------|
19: -- -------------------------------------------------------------------------
20: --

Line 32: return MDSYS.SDO_GEOMETRY;

28: ,order1_area varchar2 default null
29: ,country varchar2 default null
30: ,postal_code varchar2 default null
31: ,postal_addon_code varchar2 default null)
32: return MDSYS.SDO_GEOMETRY;
33: -- -------------------------------------------------------------------------
34: -- |---------------------------< address2geometry >------------------------|
35: -- -------------------------------------------------------------------------
36: --

Line 48: return MDSYS.SDO_GEOMETRY;

44: ,address_line7 varchar2 default null
45: ,address_line8 varchar2 default null
46: ,address_line9 varchar2 default null
47: ,country varchar2 default null)
48: return MDSYS.SDO_GEOMETRY;
49: -- -------------------------------------------------------------------------
50: -- |-------------------------< bulk_address2geometry >---------------------|
51: -- -------------------------------------------------------------------------
52: --

Line 94: ,geometry out nocopy MDSYS.SDO_GEOMETRY

90: ,order2_area out nocopy varchar2
91: ,order8_area out nocopy varchar2
92: ,country_name out nocopy varchar2
93: ,postal_code out nocopy varchar2
94: ,geometry out nocopy MDSYS.SDO_GEOMETRY
95: );
96: -- -------------------------------------------------------------------------
97: -- |---------------------------< sdo_distance >----------------------------|
98: -- -------------------------------------------------------------------------

Line 102: (geom1 in MDSYS.SDO_GEOMETRY

98: -- -------------------------------------------------------------------------
99: -- wrapper for sdo_geom.sdo_distance function
100: --
101: function sdo_distance
102: (geom1 in MDSYS.SDO_GEOMETRY
103: ,geom2 in MDSYS.SDO_GEOMETRY
104: ,tolerance in number) return number;
105: -- -------------------------------------------------------------------------
106: -- |---------------------------< sdo_miles >----------------------------|

Line 103: ,geom2 in MDSYS.SDO_GEOMETRY

99: -- wrapper for sdo_geom.sdo_distance function
100: --
101: function sdo_distance
102: (geom1 in MDSYS.SDO_GEOMETRY
103: ,geom2 in MDSYS.SDO_GEOMETRY
104: ,tolerance in number) return number;
105: -- -------------------------------------------------------------------------
106: -- |---------------------------< sdo_miles >----------------------------|
107: -- -------------------------------------------------------------------------

Line 111: (geom1 in MDSYS.SDO_GEOMETRY

107: -- -------------------------------------------------------------------------
108: -- wrapper for sdo_geom.sdo_distance function, returning miles
109: --
110: function sdo_miles
111: (geom1 in MDSYS.SDO_GEOMETRY
112: ,geom2 in MDSYS.SDO_GEOMETRY
113: ,tolerance in number) return number;
114: end irc_location_utility;

Line 112: ,geom2 in MDSYS.SDO_GEOMETRY

108: -- wrapper for sdo_geom.sdo_distance function, returning miles
109: --
110: function sdo_miles
111: (geom1 in MDSYS.SDO_GEOMETRY
112: ,geom2 in MDSYS.SDO_GEOMETRY
113: ,tolerance in number) return number;
114: end irc_location_utility;