eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

MDSYS.SDO_CS dependencies on SDO_GEOMETRY

Line 7: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,

3: TYPE EPSG_IDS
4: IS TABLE OF NUMBER;
5: */
6: -- for TRANSFORM operator: trusted callout interface
7: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
8: dim IN mdsys.sdo_dim_array,
9: to_srid IN NUMBER)
10: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
11: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);

Line 10: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

6: -- for TRANSFORM operator: trusted callout interface
7: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
8: dim IN mdsys.sdo_dim_array,
9: to_srid IN NUMBER)
10: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
11: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
12:
13: FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,
14: dim IN mdsys.sdo_dim_array,

Line 13: FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,

9: to_srid IN NUMBER)
10: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
11: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
12:
13: FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,
14: dim IN mdsys.sdo_dim_array,
15: to_srid IN NUMBER)
16: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
17: PRAGMA restrict_references(transform_orig_with_arcs, wnds, rnps, wnps);

Line 16: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

12:
13: FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,
14: dim IN mdsys.sdo_dim_array,
15: to_srid IN NUMBER)
16: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
17: PRAGMA restrict_references(transform_orig_with_arcs, wnds, rnps, wnps);
18:
19: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
20: tolerance IN number,

Line 19: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,

15: to_srid IN NUMBER)
16: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
17: PRAGMA restrict_references(transform_orig_with_arcs, wnds, rnps, wnps);
18:
19: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
20: tolerance IN number,
21: to_srid IN NUMBER)
22: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
23: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);

Line 22: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

18:
19: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
20: tolerance IN number,
21: to_srid IN NUMBER)
22: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
23: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
24:
25: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
26: to_srid IN NUMBER)

Line 25: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,

21: to_srid IN NUMBER)
22: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
23: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
24:
25: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
26: to_srid IN NUMBER)
27: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
28: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
29:

Line 27: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

23: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
24:
25: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
26: to_srid IN NUMBER)
27: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
28: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
29:
30: FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,
31: to_srid IN NUMBER)

Line 30: FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,

26: to_srid IN NUMBER)
27: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
28: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
29:
30: FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,
31: to_srid IN NUMBER)
32: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
33: PRAGMA restrict_references(transform_orig_with_arcs, wnds, rnps, wnps);
34:

Line 32: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

28: PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
29:
30: FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,
31: to_srid IN NUMBER)
32: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
33: PRAGMA restrict_references(transform_orig_with_arcs, wnds, rnps, wnps);
34:
35: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
36: dim IN mdsys.sdo_dim_array,

Line 35: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,

31: to_srid IN NUMBER)
32: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
33: PRAGMA restrict_references(transform_orig_with_arcs, wnds, rnps, wnps);
34:
35: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
36: dim IN mdsys.sdo_dim_array,
37: to_srname IN VARCHAR2)
38: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
39: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);

Line 38: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

34:
35: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
36: dim IN mdsys.sdo_dim_array,
37: to_srname IN VARCHAR2)
38: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
39: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
40:
41: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
42: tolerance IN number,

Line 41: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,

37: to_srname IN VARCHAR2)
38: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
39: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
40:
41: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
42: tolerance IN number,
43: to_srname IN VARCHAR2)
44: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
45: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);

Line 44: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

40:
41: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
42: tolerance IN number,
43: to_srname IN VARCHAR2)
44: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
45: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
46:
47: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
48: to_srname IN VARCHAR2)

Line 47: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,

43: to_srname IN VARCHAR2)
44: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
45: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
46:
47: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
48: to_srname IN VARCHAR2)
49: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
50: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
51:

Line 49: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

45: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
46:
47: FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
48: to_srname IN VARCHAR2)
49: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
50: -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
51:
52: PROCEDURE transform_layer( table_in IN VARCHAR2,
53: column_in IN VARCHAR2,

Line 62: FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,

58: column_in IN VARCHAR2,
59: table_out IN VARCHAR2,
60: to_srid IN NUMBER );
61:
62: FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,
63: to_srid IN NUMBER)
64: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
65: PRAGMA restrict_references(viewport_transform, wnds, rnps, wnps);
66: -- FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,

Line 64: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

60: to_srid IN NUMBER );
61:
62: FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,
63: to_srid IN NUMBER)
64: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
65: PRAGMA restrict_references(viewport_transform, wnds, rnps, wnps);
66: -- FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,
67: -- to_srname IN VARCHAR2)
68: -- RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

Line 66: -- FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,

62: FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,
63: to_srid IN NUMBER)
64: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
65: PRAGMA restrict_references(viewport_transform, wnds, rnps, wnps);
66: -- FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,
67: -- to_srname IN VARCHAR2)
68: -- RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
69: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
70: FUNCTION validate_wkt(srid in NUMBER)

Line 68: -- RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

64: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
65: PRAGMA restrict_references(viewport_transform, wnds, rnps, wnps);
66: -- FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,
67: -- to_srname IN VARCHAR2)
68: -- RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
69: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
70: FUNCTION validate_wkt(srid in NUMBER)
71: RETURN varchar2;
72: PRAGMA restrict_references(validate_wkt, wnds, rnps, wnps);

Line 196: mbr SDO_GEOMETRY)

192: num_steps OUT NUMBER);
193: PRAGMA restrict_references(internal_get_densification_res, wnds, rnps, wnps);
194:
195: FUNCTION internal_densify_prior_to_tfm(
196: mbr SDO_GEOMETRY)
197: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
198: PRAGMA restrict_references(internal_densify_prior_to_tfm, wnds, rnps, wnps);
199:
200: ------------------------------------------------------------------------------

Line 197: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

193: PRAGMA restrict_references(internal_get_densification_res, wnds, rnps, wnps);
194:
195: FUNCTION internal_densify_prior_to_tfm(
196: mbr SDO_GEOMETRY)
197: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
198: PRAGMA restrict_references(internal_densify_prior_to_tfm, wnds, rnps, wnps);
199:
200: ------------------------------------------------------------------------------
201:

Line 203: geom IN MDSYS.SDO_GEOMETRY,

199:
200: ------------------------------------------------------------------------------
201:
202: FUNCTION transform(
203: geom IN MDSYS.SDO_GEOMETRY,
204: dim IN MDSYS.SDO_DIM_ARRAY,
205: to_srid IN NUMBER)
206: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
207: PRAGMA restrict_references(transform, wnds, rnps, wnps);

Line 206: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

202: FUNCTION transform(
203: geom IN MDSYS.SDO_GEOMETRY,
204: dim IN MDSYS.SDO_DIM_ARRAY,
205: to_srid IN NUMBER)
206: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
207: PRAGMA restrict_references(transform, wnds, rnps, wnps);
208:
209: FUNCTION transform(
210: geom IN MDSYS.SDO_GEOMETRY,

Line 210: geom IN MDSYS.SDO_GEOMETRY,

206: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
207: PRAGMA restrict_references(transform, wnds, rnps, wnps);
208:
209: FUNCTION transform(
210: geom IN MDSYS.SDO_GEOMETRY,
211: tolerance IN NUMBER,
212: to_srid IN NUMBER)
213: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
214: PRAGMA restrict_references(transform, wnds, rnps, wnps);

Line 213: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

209: FUNCTION transform(
210: geom IN MDSYS.SDO_GEOMETRY,
211: tolerance IN NUMBER,
212: to_srid IN NUMBER)
213: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
214: PRAGMA restrict_references(transform, wnds, rnps, wnps);
215:
216: FUNCTION transform(
217: geom IN MDSYS.SDO_GEOMETRY,

Line 217: geom IN MDSYS.SDO_GEOMETRY,

213: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
214: PRAGMA restrict_references(transform, wnds, rnps, wnps);
215:
216: FUNCTION transform(
217: geom IN MDSYS.SDO_GEOMETRY,
218: to_srid IN NUMBER)
219: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
220: PRAGMA restrict_references(transform, wnds, rnps, wnps);
221:

Line 219: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

215:
216: FUNCTION transform(
217: geom IN MDSYS.SDO_GEOMETRY,
218: to_srid IN NUMBER)
219: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
220: PRAGMA restrict_references(transform, wnds, rnps, wnps);
221:
222: FUNCTION transform_with_arcs(
223: geom IN MDSYS.SDO_GEOMETRY,

Line 223: geom IN MDSYS.SDO_GEOMETRY,

219: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
220: PRAGMA restrict_references(transform, wnds, rnps, wnps);
221:
222: FUNCTION transform_with_arcs(
223: geom IN MDSYS.SDO_GEOMETRY,
224: to_srid IN NUMBER)
225: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
226: PRAGMA restrict_references(transform_with_arcs, wnds, rnps, wnps);
227:

Line 225: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

221:
222: FUNCTION transform_with_arcs(
223: geom IN MDSYS.SDO_GEOMETRY,
224: to_srid IN NUMBER)
225: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
226: PRAGMA restrict_references(transform_with_arcs, wnds, rnps, wnps);
227:
228: FUNCTION transform_using_plan(
229: geom IN MDSYS.SDO_GEOMETRY,

Line 229: geom IN MDSYS.SDO_GEOMETRY,

225: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
226: PRAGMA restrict_references(transform_with_arcs, wnds, rnps, wnps);
227:
228: FUNCTION transform_using_plan(
229: geom IN MDSYS.SDO_GEOMETRY,
230: use_plan IN TFM_PLAN)
231: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
232:
233: FUNCTION transform(

Line 231: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

227:
228: FUNCTION transform_using_plan(
229: geom IN MDSYS.SDO_GEOMETRY,
230: use_plan IN TFM_PLAN)
231: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
232:
233: FUNCTION transform(
234: geom IN MDSYS.SDO_GEOMETRY,
235: use_plan IN TFM_PLAN)

Line 234: geom IN MDSYS.SDO_GEOMETRY,

230: use_plan IN TFM_PLAN)
231: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
232:
233: FUNCTION transform(
234: geom IN MDSYS.SDO_GEOMETRY,
235: use_plan IN TFM_PLAN)
236: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
237:
238: FUNCTION transform_orig_using_rules(

Line 236: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

232:
233: FUNCTION transform(
234: geom IN MDSYS.SDO_GEOMETRY,
235: use_plan IN TFM_PLAN)
236: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
237:
238: FUNCTION transform_orig_using_rules(
239: geom IN mdsys.sdo_geometry,
240: dim IN mdsys.sdo_dim_array,

Line 239: geom IN mdsys.sdo_geometry,

235: use_plan IN TFM_PLAN)
236: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
237:
238: FUNCTION transform_orig_using_rules(
239: geom IN mdsys.sdo_geometry,
240: dim IN mdsys.sdo_dim_array,
241: use_case IN VARCHAR2,
242: tfmChain IN VARCHAR2,
243: to_srid IN NUMBER)

Line 244: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

240: dim IN mdsys.sdo_dim_array,
241: use_case IN VARCHAR2,
242: tfmChain IN VARCHAR2,
243: to_srid IN NUMBER)
244: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
245: PRAGMA restrict_references(transform_orig_using_rules, wnds, rnps, wnps);
246:
247: FUNCTION transform_orig_using_rules(
248: geom IN MDSYS.SDO_GEOMETRY,

Line 248: geom IN MDSYS.SDO_GEOMETRY,

244: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
245: PRAGMA restrict_references(transform_orig_using_rules, wnds, rnps, wnps);
246:
247: FUNCTION transform_orig_using_rules(
248: geom IN MDSYS.SDO_GEOMETRY,
249: use_case IN VARCHAR2,
250: tfmChain IN VARCHAR2,
251: to_srid IN NUMBER)
252: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 252: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

248: geom IN MDSYS.SDO_GEOMETRY,
249: use_case IN VARCHAR2,
250: tfmChain IN VARCHAR2,
251: to_srid IN NUMBER)
252: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
253: PRAGMA restrict_references(transform_orig_using_rules, wnds, rnps, wnps);
254:
255: FUNCTION transform_using_case_name(
256: geom IN MDSYS.SDO_GEOMETRY,

Line 256: geom IN MDSYS.SDO_GEOMETRY,

252: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
253: PRAGMA restrict_references(transform_orig_using_rules, wnds, rnps, wnps);
254:
255: FUNCTION transform_using_case_name(
256: geom IN MDSYS.SDO_GEOMETRY,
257: use_case IN VARCHAR2,
258: to_srid IN NUMBER)
259: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
260: PRAGMA restrict_references(transform_using_case_name, wnds, rnps, wnps);

Line 259: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

255: FUNCTION transform_using_case_name(
256: geom IN MDSYS.SDO_GEOMETRY,
257: use_case IN VARCHAR2,
258: to_srid IN NUMBER)
259: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
260: PRAGMA restrict_references(transform_using_case_name, wnds, rnps, wnps);
261:
262: FUNCTION transform(
263: geom IN MDSYS.SDO_GEOMETRY,

Line 263: geom IN MDSYS.SDO_GEOMETRY,

259: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
260: PRAGMA restrict_references(transform_using_case_name, wnds, rnps, wnps);
261:
262: FUNCTION transform(
263: geom IN MDSYS.SDO_GEOMETRY,
264: use_case IN VARCHAR2,
265: to_srid IN NUMBER)
266: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
267: PRAGMA restrict_references(transform, wnds, rnps, wnps);

Line 266: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

262: FUNCTION transform(
263: geom IN MDSYS.SDO_GEOMETRY,
264: use_case IN VARCHAR2,
265: to_srid IN NUMBER)
266: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
267: PRAGMA restrict_references(transform, wnds, rnps, wnps);
268:
269: FUNCTION transform(
270: geom IN MDSYS.SDO_GEOMETRY,

Line 270: geom IN MDSYS.SDO_GEOMETRY,

266: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
267: PRAGMA restrict_references(transform, wnds, rnps, wnps);
268:
269: FUNCTION transform(
270: geom IN MDSYS.SDO_GEOMETRY,
271: dim IN MDSYS.SDO_DIM_ARRAY,
272: to_srname IN VARCHAR2)
273: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
274: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);

Line 273: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

269: FUNCTION transform(
270: geom IN MDSYS.SDO_GEOMETRY,
271: dim IN MDSYS.SDO_DIM_ARRAY,
272: to_srname IN VARCHAR2)
273: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
274: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
275:
276: FUNCTION transform(
277: geom IN MDSYS.SDO_GEOMETRY,

Line 277: geom IN MDSYS.SDO_GEOMETRY,

273: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
274: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
275:
276: FUNCTION transform(
277: geom IN MDSYS.SDO_GEOMETRY,
278: tolerance IN NUMBER,
279: to_srname IN VARCHAR2)
280: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
281: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);

Line 280: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

276: FUNCTION transform(
277: geom IN MDSYS.SDO_GEOMETRY,
278: tolerance IN NUMBER,
279: to_srname IN VARCHAR2)
280: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
281: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
282:
283: FUNCTION transform(
284: geom IN MDSYS.SDO_GEOMETRY,

Line 284: geom IN MDSYS.SDO_GEOMETRY,

280: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
281: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
282:
283: FUNCTION transform(
284: geom IN MDSYS.SDO_GEOMETRY,
285: to_srname IN VARCHAR2)
286: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
287: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
288:

Line 286: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

282:
283: FUNCTION transform(
284: geom IN MDSYS.SDO_GEOMETRY,
285: to_srname IN VARCHAR2)
286: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
287: -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
288:
289: ------------------------------------------------------------------------------
290:

Line 322: return sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

318: ntv2_file_id in number);
319:
320: function determine_nadcon_coverage(
321: coord_op_id number)
322: return sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
323:
324: FUNCTION find_geog_crs(
325: reference_srid IN NUMBER,
326: is_legacy IN VARCHAR2,

Line 374: geom SDO_GEOMETRY,

370:
371: ------------------------------------------------------------------------------
372:
373: FUNCTION to_USNG(
374: geom SDO_GEOMETRY,
375: accuracyInMeters NUMBER,
376: datum VARCHAR2 DEFAULT 'NAD83')
377: RETURN
378: VARCHAR2;

Line 384: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

380: FUNCTION from_USNG(
381: usng VARCHAR2,
382: srid NUMBER,
383: datum VARCHAR2 DEFAULT 'NAD83')
384: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
385:
386: ------------------------------------------------------------------------------
387:
388: PROCEDURE update_wkts_for_all_epsg_crs;

Line 483: geom2d in mdsys.sdo_geometry,

479: inv_flattening OUT NUMBER,
480: params OUT MDSYS.epsg_params);
481:
482: function make_3d(
483: geom2d in mdsys.sdo_geometry,
484: height in number default 0,
485: target_srid in number default null)
486: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
487:

Line 486: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

482: function make_3d(
483: geom2d in mdsys.sdo_geometry,
484: height in number default 0,
485: target_srid in number default null)
486: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
487:
488: function make_2d(
489: geom3d in mdsys.sdo_geometry,
490: target_srid in number default null)

Line 489: geom3d in mdsys.sdo_geometry,

485: target_srid in number default null)
486: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
487:
488: function make_2d(
489: geom3d in mdsys.sdo_geometry,
490: target_srid in number default null)
491: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
492:
493: function convert_2d_to_3d(

Line 491: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

487:
488: function make_2d(
489: geom3d in mdsys.sdo_geometry,
490: target_srid in number default null)
491: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
492:
493: function convert_2d_to_3d(
494: geom2d mdsys.sdo_geometry,
495: height number default 0,

Line 494: geom2d mdsys.sdo_geometry,

490: target_srid in number default null)
491: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
492:
493: function convert_2d_to_3d(
494: geom2d mdsys.sdo_geometry,
495: height number default 0,
496: vert_id number default 9903,
497: ellipsoidal varchar2 default 'TRUE',
498: uom_id number default 9001)

Line 499: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

495: height number default 0,
496: vert_id number default 9903,
497: ellipsoidal varchar2 default 'TRUE',
498: uom_id number default 9001)
499: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
500:
501: function convert_3d_srid_to_2d(
502: srid3d number)
503: return number DETERMINISTIC PARALLEL_ENABLE;

Line 515: geom IN MDSYS.SDO_GEOMETRY,

511:
512: ------------------------------------------------
513:
514: FUNCTION transform_across_dims(
515: geom IN MDSYS.SDO_GEOMETRY,
516: to_srid IN NUMBER)
517: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
518: PRAGMA restrict_references(transform_across_dims, wnds, rnps, wnps);
519:

Line 517: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

513:
514: FUNCTION transform_across_dims(
515: geom IN MDSYS.SDO_GEOMETRY,
516: to_srid IN NUMBER)
517: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
518: PRAGMA restrict_references(transform_across_dims, wnds, rnps, wnps);
519:
520: FUNCTION transform_across_dims_wa(
521: geom IN MDSYS.SDO_GEOMETRY,

Line 521: geom IN MDSYS.SDO_GEOMETRY,

517: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
518: PRAGMA restrict_references(transform_across_dims, wnds, rnps, wnps);
519:
520: FUNCTION transform_across_dims_wa(
521: geom IN MDSYS.SDO_GEOMETRY,
522: to_srid IN NUMBER)
523: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
524: PRAGMA restrict_references(transform_across_dims_wa, wnds, rnps, wnps);
525:

Line 523: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

519:
520: FUNCTION transform_across_dims_wa(
521: geom IN MDSYS.SDO_GEOMETRY,
522: to_srid IN NUMBER)
523: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
524: PRAGMA restrict_references(transform_across_dims_wa, wnds, rnps, wnps);
525:
526: PROCEDURE transform_layer_across_dims(
527: table_in IN VARCHAR2,

Line 548: geom1 mdsys.sdo_geometry,

544:
545: ------------------------------------------------
546:
547: function reformat_gtype(
548: geom1 mdsys.sdo_geometry,
549: srid2 number)
550: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
551:
552: PROCEDURE register_SrsNameSpace ( SrsNameSpace IN varchar2,

Line 550: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

546:
547: function reformat_gtype(
548: geom1 mdsys.sdo_geometry,
549: srid2 number)
550: return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
551:
552: PROCEDURE register_SrsNameSpace ( SrsNameSpace IN varchar2,
553: SrsName IN varchar2, sdo_srid in number);
554: FUNCTION get_SRID_for_NameSpace( SrsNameSpace IN varchar2,

Line 663: RETURN sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

659: lon_min VARCHAR2,
660: lon_sec VARCHAR2,
661: lon_dir CHAR,
662: srid NUMBER default 8307)
663: RETURN sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
664:
665: procedure decimal_degrees_to_dms(
666: dec_deg in number,
667: coord_deg out integer,