APPS.RRS_SITE_UTILS dependencies on SDO_UTIL

Line 137: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,

133: --Bug 4903895 - Start Code
134: /*
135: CURSOR primary_tag_cursor IS
136: select
137: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,
138: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
139: rgta.trade_area_number_code
140: from
141: rrs_trade_area_groups_b rtag,

Line 157: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,

153: order by
154: rgta.trade_area_number_code desc;
155: CURSOR other_tag_cursor IS
156: select
157: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,
158: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
159: rgta.trade_area_number_code
160: from
161: rrs_trade_area_groups_b rtag,

Line 178: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,

174: rgta.trade_area_number_code desc;
175: */
176: CURSOR primary_tag_cursor IS
177: select
178: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,
179: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
180: rgta.trade_area_number_code
181: from
182: rrs_trade_area_groups_b rtag,

Line 201: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,

197: order by
198: rgta.trade_area_number_code desc;
199: CURSOR other_tag_cursor IS
200: select
201: SDO_UTIL.CIRCLE_POLYGON(l.GEOMETRY.SDO_POINT.X , l.GEOMETRY.SDO_POINT.Y ,
202: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
203: rgta.trade_area_number_code
204: from
205: rrs_trade_area_groups_b rtag,