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_LRS dependencies on SDO_DIM_ARRAY

Line 14: dim_array IN MDSYS.SDO_DIM_ARRAY,

10: -- define an LRS geometric segment, all measures will be automatically populated
11: --
12:
13: PROCEDURE define_geom_segment(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
14: dim_array IN MDSYS.SDO_DIM_ARRAY,
15: start_measure IN NUMBER ,
16: end_measure IN NUMBER );
17:
18:

Line 20: dim_array IN MDSYS.SDO_DIM_ARRAY);

16: end_measure IN NUMBER );
17:
18:
19: PROCEDURE define_geom_segment(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
20: dim_array IN MDSYS.SDO_DIM_ARRAY);
21:
22:
23:
24:

Line 39: dim_array IN MDSYS.SDO_DIM_ARRAY,

35:
36:
37:
38: PROCEDURE define_geom_segment_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
39: dim_array IN MDSYS.SDO_DIM_ARRAY,
40: start_measure IN NUMBER ,
41: end_measure IN NUMBER );
42:
43: PROCEDURE define_geom_segment_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,

Line 44: dim_array IN MDSYS.SDO_DIM_ARRAY);

40: start_measure IN NUMBER ,
41: end_measure IN NUMBER );
42:
43: PROCEDURE define_geom_segment_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
44: dim_array IN MDSYS.SDO_DIM_ARRAY);
45:
46:
47: PROCEDURE define_geom_segment_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
48: start_measure IN NUMBER ,

Line 65: dim_array IN MDSYS.SDO_DIM_ARRAY,

61: -- create a new geometric segment by clipping the given geometric segment
62: --
63:
64: FUNCTION clip_geom_segment(geom_segment IN MDSYS.SDO_GEOMETRY,
65: dim_array IN MDSYS.SDO_DIM_ARRAY,
66: start_measure IN NUMBER,
67: end_measure IN NUMBER)
68: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
69:

Line 81: dim_array IN MDSYS.SDO_DIM_ARRAY,

77:
78:
79:
80: FUNCTION clip_geom_segment_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
81: dim_array IN MDSYS.SDO_DIM_ARRAY,
82: start_measure IN NUMBER,
83: end_measure IN NUMBER)
84: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
85:

Line 101: dim_array IN MDSYS.SDO_DIM_ARRAY,

97: --
98:
99:
100: PROCEDURE split_geom_segment(geom_segment IN MDSYS.SDO_GEOMETRY,
101: dim_array IN MDSYS.SDO_DIM_ARRAY,
102: split_measure IN NUMBER,
103: segment_1 OUT MDSYS.SDO_GEOMETRY,
104: segment_2 OUT MDSYS.SDO_GEOMETRY);
105:

Line 116: dim_array IN MDSYS.SDO_DIM_ARRAY,

112:
113:
114:
115: PROCEDURE split_geom_segment_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
116: dim_array IN MDSYS.SDO_DIM_ARRAY,
117: split_measure IN NUMBER,
118: segment_1 OUT MDSYS.SDO_GEOMETRY,
119: segment_2 OUT MDSYS.SDO_GEOMETRY);
120:

Line 135: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,

131: -- concatenate two geometric segments into one
132: --
133:
134: FUNCTION concatenate_geom_segments(geom_segment_1 IN MDSYS.SDO_GEOMETRY,
135: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
136: geom_segment_2 IN MDSYS.SDO_GEOMETRY,
137: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
138:
139: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 137: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)

133:
134: FUNCTION concatenate_geom_segments(geom_segment_1 IN MDSYS.SDO_GEOMETRY,
135: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
136: geom_segment_2 IN MDSYS.SDO_GEOMETRY,
137: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
138:
139: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
140:
141:

Line 152: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,

148:
149:
150:
151: FUNCTION concatenate_geom_segments_3d(geom_segment_1 IN MDSYS.SDO_GEOMETRY,
152: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
153: geom_segment_2 IN MDSYS.SDO_GEOMETRY,
154: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
155:
156: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 154: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)

150:
151: FUNCTION concatenate_geom_segments_3d(geom_segment_1 IN MDSYS.SDO_GEOMETRY,
152: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
153: geom_segment_2 IN MDSYS.SDO_GEOMETRY,
154: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
155:
156: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
157:
158:

Line 174: dim_array IN MDSYS.SDO_DIM_ARRAY,

170: -- general segment scaling function
171: --
172:
173: FUNCTION scale_geom_segment(geom_segment IN MDSYS.SDO_GEOMETRY,
174: dim_array IN MDSYS.SDO_DIM_ARRAY,
175: start_measure IN NUMBER,
176: end_measure IN NUMBER,
177: shift_measure IN NUMBER)
178: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 202: dim_array IN MDSYS.SDO_DIM_ARRAY)

198: -- check if the given geometric segment is valid
199: --
200:
201: FUNCTION valid_geom_segment(geom_segment IN MDSYS.SDO_GEOMETRY,
202: dim_array IN MDSYS.SDO_DIM_ARRAY)
203: RETURN VARCHAR2 PARALLEL_ENABLE;
204:
205:
206: FUNCTION valid_geom_segment(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 212: dim_array IN MDSYS.SDO_DIM_ARRAY)

208:
209:
210:
211: FUNCTION valid_geom_segment_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
212: dim_array IN MDSYS.SDO_DIM_ARRAY)
213: RETURN VARCHAR2 PARALLEL_ENABLE;
214:
215:
216: FUNCTION valid_geom_segment_3d(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 228: dim_array IN MDSYS.SDO_DIM_ARRAY)

224: -- the geom segment must be valid, (type, length, and no of dim, etc)
225: --
226:
227: FUNCTION is_geom_segment_defined(geom_segment IN MDSYS.SDO_GEOMETRY,
228: dim_array IN MDSYS.SDO_DIM_ARRAY)
229: RETURN VARCHAR2 PARALLEL_ENABLE;
230:
231:
232: FUNCTION is_geom_segment_defined(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 238: dim_array IN MDSYS.SDO_DIM_ARRAY)

234:
235:
236:
237: FUNCTION is_geom_segment_defined_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
238: dim_array IN MDSYS.SDO_DIM_ARRAY)
239: RETURN VARCHAR2 PARALLEL_ENABLE;
240:
241: FUNCTION is_geom_segment_defined_3d(geom_segment IN MDSYS.SDO_GEOMETRY)
242: RETURN VARCHAR2 PARALLEL_ENABLE;

Line 252: dim_array IN MDSYS.SDO_DIM_ARRAY)

248: --
249:
250:
251: FUNCTION valid_lrs_pt(point IN MDSYS.SDO_GEOMETRY,
252: dim_array IN MDSYS.SDO_DIM_ARRAY)
253: RETURN VARCHAR2 PARALLEL_ENABLE;
254:
255:
256: FUNCTION valid_lrs_pt(point IN MDSYS.SDO_GEOMETRY)

Line 262: dim_array IN MDSYS.SDO_DIM_ARRAY)

258:
259:
260:
261: FUNCTION valid_lrs_pt_3d(point IN MDSYS.SDO_GEOMETRY,
262: dim_array IN MDSYS.SDO_DIM_ARRAY)
263: RETURN VARCHAR2 PARALLEL_ENABLE;
264:
265:
266: FUNCTION valid_lrs_pt_3d(point IN MDSYS.SDO_GEOMETRY)

Line 279: dim_array IN MDSYS.SDO_DIM_ARRAY,

275: --
276:
277:
278: FUNCTION valid_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
279: dim_array IN MDSYS.SDO_DIM_ARRAY,
280: measure IN NUMBER)
281: RETURN VARCHAR2 PARALLEL_ENABLE;
282:
283:

Line 291: dim_array IN MDSYS.SDO_DIM_ARRAY,

287:
288:
289:
290: FUNCTION valid_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
291: dim_array IN MDSYS.SDO_DIM_ARRAY,
292: measure IN NUMBER)
293: RETURN VARCHAR2 PARALLEL_ENABLE;
294:
295:

Line 310: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,

306: -- check if two given geometric segments are connected
307: --
308:
309: FUNCTION connected_geom_segments(geom_segment_1 IN MDSYS.SDO_GEOMETRY,
310: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
311: geom_segment_2 IN MDSYS.SDO_GEOMETRY,
312: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
313:
314: RETURN VARCHAR2 PARALLEL_ENABLE;

Line 312: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)

308:
309: FUNCTION connected_geom_segments(geom_segment_1 IN MDSYS.SDO_GEOMETRY,
310: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
311: geom_segment_2 IN MDSYS.SDO_GEOMETRY,
312: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
313:
314: RETURN VARCHAR2 PARALLEL_ENABLE;
315:
316:

Line 327: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,

323:
324:
325:
326: FUNCTION connected_geom_segments_3d(geom_segment_1 IN MDSYS.SDO_GEOMETRY,
327: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
328: geom_segment_2 IN MDSYS.SDO_GEOMETRY,
329: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
330:
331: RETURN VARCHAR2 PARALLEL_ENABLE;

Line 329: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)

325:
326: FUNCTION connected_geom_segments_3d(geom_segment_1 IN MDSYS.SDO_GEOMETRY,
327: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
328: geom_segment_2 IN MDSYS.SDO_GEOMETRY,
329: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
330:
331: RETURN VARCHAR2 PARALLEL_ENABLE;
332:
333:

Line 348: dim_array IN MDSYS.SDO_DIM_ARRAY)

344: -- return the length of the given geometric segment
345: --
346:
347: FUNCTION geom_segment_length(geom_segment IN MDSYS.SDO_GEOMETRY,
348: dim_array IN MDSYS.SDO_DIM_ARRAY)
349: RETURN NUMBER PARALLEL_ENABLE;
350:
351:
352: FUNCTION geom_segment_length(geom_segment IN MDSYS.SDO_GEOMETRY,

Line 360: dim_array IN MDSYS.SDO_DIM_ARRAY)

356:
357:
358:
359: FUNCTION geom_segment_length_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
360: dim_array IN MDSYS.SDO_DIM_ARRAY)
361:
362: RETURN NUMBER PARALLEL_ENABLE;
363:
364:

Line 379: dim_array IN MDSYS.SDO_DIM_ARRAY)

375: -- return the start point of the geometric segment
376: --
377:
378: FUNCTION geom_segment_start_pt(geom_segment IN MDSYS.SDO_GEOMETRY,
379: dim_array IN MDSYS.SDO_DIM_ARRAY)
380: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
381:
382:
383: FUNCTION geom_segment_start_pt(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 388: dim_array IN MDSYS.SDO_DIM_ARRAY)

384: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
385:
386:
387: FUNCTION geom_segment_start_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
388: dim_array IN MDSYS.SDO_DIM_ARRAY)
389: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
390:
391:
392: FUNCTION geom_segment_start_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 403: dim_array IN MDSYS.SDO_DIM_ARRAY)

399: --
400:
401:
402: FUNCTION geom_segment_start_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
403: dim_array IN MDSYS.SDO_DIM_ARRAY)
404: RETURN NUMBER PARALLEL_ENABLE;
405:
406:
407: FUNCTION geom_segment_start_measure(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 413: dim_array IN MDSYS.SDO_DIM_ARRAY)

409:
410:
411:
412: FUNCTION geom_segment_start_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
413: dim_array IN MDSYS.SDO_DIM_ARRAY)
414: RETURN NUMBER PARALLEL_ENABLE;
415:
416:
417: FUNCTION geom_segment_start_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 427: dim_array IN MDSYS.SDO_DIM_ARRAY)

423: -- return the end point of the geometric segment
424: --
425:
426: FUNCTION geom_segment_end_pt(geom_segment IN MDSYS.SDO_GEOMETRY,
427: dim_array IN MDSYS.SDO_DIM_ARRAY)
428: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
429:
430:
431: FUNCTION geom_segment_end_pt(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 437: dim_array IN MDSYS.SDO_DIM_ARRAY)

433:
434:
435:
436: FUNCTION geom_segment_end_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
437: dim_array IN MDSYS.SDO_DIM_ARRAY)
438: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
439:
440:
441: FUNCTION geom_segment_end_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 451: dim_array IN MDSYS.SDO_DIM_ARRAY)

447: -- return the end point of the geometric segment
448: --
449:
450: FUNCTION geom_segment_end_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
451: dim_array IN MDSYS.SDO_DIM_ARRAY)
452: RETURN NUMBER PARALLEL_ENABLE;
453:
454:
455: FUNCTION geom_segment_end_measure(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 462: dim_array IN MDSYS.SDO_DIM_ARRAY)

458:
459:
460:
461: FUNCTION geom_segment_end_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
462: dim_array IN MDSYS.SDO_DIM_ARRAY)
463: RETURN NUMBER PARALLEL_ENABLE;
464:
465:
466: FUNCTION geom_segment_end_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 478: dim_array IN MDSYS.SDO_DIM_ARRAY)

474: -- return the measure of a LSR point
475: --
476:
477: FUNCTION get_measure(point IN MDSYS.SDO_GEOMETRY,
478: dim_array IN MDSYS.SDO_DIM_ARRAY)
479: RETURN NUMBER PARALLEL_ENABLE;
480:
481:
482: FUNCTION get_measure(point IN MDSYS.SDO_GEOMETRY)

Line 488: dim_array IN MDSYS.SDO_DIM_ARRAY)

484:
485:
486:
487: FUNCTION get_measure_3d(point IN MDSYS.SDO_GEOMETRY,
488: dim_array IN MDSYS.SDO_DIM_ARRAY)
489: RETURN NUMBER PARALLEL_ENABLE;
490:
491:
492:

Line 503: dim_array IN MDSYS.SDO_DIM_ARRAY,

499: -- locate the point w.r.t a given geometric segment
500: --
501:
502: FUNCTION locate_pt(geom_segment IN MDSYS.SDO_GEOMETRY,
503: dim_array IN MDSYS.SDO_DIM_ARRAY,
504: measure IN NUMBER,
505: offset IN NUMBER DEFAULT 0)
506: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
507:

Line 519: dim_array IN MDSYS.SDO_DIM_ARRAY,

515:
516:
517:
518: FUNCTION locate_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
519: dim_array IN MDSYS.SDO_DIM_ARRAY,
520: measure IN NUMBER)
521:
522: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
523:

Line 539: dim_array IN MDSYS.SDO_DIM_ARRAY,

535: -- return the projection point of a given point w.r.t. to a given geometric segment
536: --
537:
538: FUNCTION project_pt(geom_segment IN MDSYS.SDO_GEOMETRY,
539: dim_array IN MDSYS.SDO_DIM_ARRAY,
540: point IN MDSYS.SDO_GEOMETRY,
541: point_dim_array IN MDSYS.SDO_DIM_ARRAY )
542:
543: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 541: point_dim_array IN MDSYS.SDO_DIM_ARRAY )

537:
538: FUNCTION project_pt(geom_segment IN MDSYS.SDO_GEOMETRY,
539: dim_array IN MDSYS.SDO_DIM_ARRAY,
540: point IN MDSYS.SDO_GEOMETRY,
541: point_dim_array IN MDSYS.SDO_DIM_ARRAY )
542:
543: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
544:
545:

Line 548: dim_array IN MDSYS.SDO_DIM_ARRAY,

544:
545:
546:
547: FUNCTION project_pt(geom_segment IN MDSYS.SDO_GEOMETRY,
548: dim_array IN MDSYS.SDO_DIM_ARRAY,
549: point IN MDSYS.SDO_GEOMETRY)
550:
551:
552: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 557: dim_array IN MDSYS.SDO_DIM_ARRAY,

553:
554:
555:
556: FUNCTION project_pt(geom_segment IN MDSYS.SDO_GEOMETRY,
557: dim_array IN MDSYS.SDO_DIM_ARRAY,
558: point IN MDSYS.SDO_GEOMETRY,
559: point_dim_array IN MDSYS.SDO_DIM_ARRAY,
560: offset OUT NUMBER)
561:

Line 559: point_dim_array IN MDSYS.SDO_DIM_ARRAY,

555:
556: FUNCTION project_pt(geom_segment IN MDSYS.SDO_GEOMETRY,
557: dim_array IN MDSYS.SDO_DIM_ARRAY,
558: point IN MDSYS.SDO_GEOMETRY,
559: point_dim_array IN MDSYS.SDO_DIM_ARRAY,
560: offset OUT NUMBER)
561:
562: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
563:

Line 589: dim_array IN MDSYS.SDO_DIM_ARRAY,

585:
586:
587:
588: FUNCTION project_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
589: dim_array IN MDSYS.SDO_DIM_ARRAY,
590: point IN MDSYS.SDO_GEOMETRY,
591: point_dim_array IN MDSYS.SDO_DIM_ARRAY )
592:
593: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 591: point_dim_array IN MDSYS.SDO_DIM_ARRAY )

587:
588: FUNCTION project_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
589: dim_array IN MDSYS.SDO_DIM_ARRAY,
590: point IN MDSYS.SDO_GEOMETRY,
591: point_dim_array IN MDSYS.SDO_DIM_ARRAY )
592:
593: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
594:
595:

Line 597: dim_array IN MDSYS.SDO_DIM_ARRAY,

593: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
594:
595:
596: FUNCTION project_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
597: dim_array IN MDSYS.SDO_DIM_ARRAY,
598: point IN MDSYS.SDO_GEOMETRY)
599:
600:
601: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 606: dim_array IN MDSYS.SDO_DIM_ARRAY,

602:
603:
604:
605: FUNCTION project_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
606: dim_array IN MDSYS.SDO_DIM_ARRAY,
607: point IN MDSYS.SDO_GEOMETRY,
608: point_dim_array IN MDSYS.SDO_DIM_ARRAY,
609: offset OUT NUMBER)
610:

Line 608: point_dim_array IN MDSYS.SDO_DIM_ARRAY,

604:
605: FUNCTION project_pt_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
606: dim_array IN MDSYS.SDO_DIM_ARRAY,
607: point IN MDSYS.SDO_GEOMETRY,
608: point_dim_array IN MDSYS.SDO_DIM_ARRAY,
609: offset OUT NUMBER)
610:
611: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
612:

Line 646: dim_array IN MDSYS.SDO_DIM_ARRAY)

642: -- return geom segment measure range
643: --
644:
645: FUNCTION measure_range(geom_segment IN MDSYS.SDO_GEOMETRY,
646: dim_array IN MDSYS.SDO_DIM_ARRAY)
647: RETURN NUMBER PARALLEL_ENABLE;
648:
649:
650: FUNCTION measure_range(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 657: dim_array IN MDSYS.SDO_DIM_ARRAY)

653:
654:
655:
656: FUNCTION measure_range_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
657: dim_array IN MDSYS.SDO_DIM_ARRAY)
658: RETURN NUMBER PARALLEL_ENABLE;
659:
660:
661: FUNCTION measure_range_3d(geom_segment IN MDSYS.SDO_GEOMETRY)

Line 673: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,

669: --
670: -- Convert standard dim info to lrs diminfo by adding an additional measure informaiotn
671: --
672:
673: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,
674: dim_name IN VARCHAR2,
675: dim_pos IN INTEGER,
676: lower_bound IN NUMBER DEFAULT NULL,
677: upper_bound IN NUMBER DEFAULT NULL,

Line 680: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;

676: lower_bound IN NUMBER DEFAULT NULL,
677: upper_bound IN NUMBER DEFAULT NULL,
678: tolerance IN NUMBER DEFAULT NULL)
679:
680: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
681:
682:
683:
684: --

Line 688: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,

684: --
685: -- Convert standard dim info to lrs diminfo by adding an additional measure informaiotn
686: --
687:
688: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,
689: dim_name IN VARCHAR2,
690: lower_bound IN NUMBER DEFAULT NULL,
691: upper_bound IN NUMBER DEFAULT NULL,
692: tolerance IN NUMBER DEFAULT NULL)

Line 694: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;

690: lower_bound IN NUMBER DEFAULT NULL,
691: upper_bound IN NUMBER DEFAULT NULL,
692: tolerance IN NUMBER DEFAULT NULL)
693:
694: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
695:
696:
697:
698: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,

Line 698: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,

694: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
695:
696:
697:
698: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,
699: lower_bound IN NUMBER DEFAULT NULL,
700: upper_bound IN NUMBER DEFAULT NULL,
701: tolerance IN NUMBER DEFAULT NULL)
702:

Line 703: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;

699: lower_bound IN NUMBER DEFAULT NULL,
700: upper_bound IN NUMBER DEFAULT NULL,
701: tolerance IN NUMBER DEFAULT NULL)
702:
703: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
704:
705:
706:
707:

Line 709: FUNCTION convert_to_lrs_dim_array_3d(dim_array IN MDSYS.SDO_DIM_ARRAY,

705:
706:
707:
708:
709: FUNCTION convert_to_lrs_dim_array_3d(dim_array IN MDSYS.SDO_DIM_ARRAY,
710: dim_name IN VARCHAR2,
711: lower_bound IN NUMBER DEFAULT NULL,
712: upper_bound IN NUMBER DEFAULT NULL,
713: tolerance IN NUMBER DEFAULT NULL)

Line 715: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;

711: lower_bound IN NUMBER DEFAULT NULL,
712: upper_bound IN NUMBER DEFAULT NULL,
713: tolerance IN NUMBER DEFAULT NULL)
714:
715: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
716:
717:
718:
719:

Line 720: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY)

716:
717:
718:
719:
720: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY)
721: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
722:
723:
724: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,

Line 721: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;

717:
718:
719:
720: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY)
721: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
722:
723:
724: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,
725: m_pos IN INTEGER)

Line 724: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,

720: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY)
721: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
722:
723:
724: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,
725: m_pos IN INTEGER)
726: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
727:
728:

Line 726: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;

722:
723:
724: FUNCTION convert_to_std_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,
725: m_pos IN INTEGER)
726: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
727:
728:
729:
730: FUNCTION convert_to_std_dim_array_3d(dim_array IN MDSYS.SDO_DIM_ARRAY)

Line 730: FUNCTION convert_to_std_dim_array_3d(dim_array IN MDSYS.SDO_DIM_ARRAY)

726: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
727:
728:
729:
730: FUNCTION convert_to_std_dim_array_3d(dim_array IN MDSYS.SDO_DIM_ARRAY)
731: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
732:
733:
734:

Line 731: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;

727:
728:
729:
730: FUNCTION convert_to_std_dim_array_3d(dim_array IN MDSYS.SDO_DIM_ARRAY)
731: RETURN MDSYS.SDO_DIM_ARRAY PARALLEL_ENABLE;
732:
733:
734:
735:

Line 742: dim_array IN MDSYS.SDO_DIM_ARRAY,

738: -- Convert standard linestring geometry to an LRS geom segment
739: --
740:
741: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
742: dim_array IN MDSYS.SDO_DIM_ARRAY,
743: m_pos IN INTEGER,
744: start_measure IN NUMBER ,
745: end_measure IN NUMBER )
746: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 750: dim_array IN MDSYS.SDO_DIM_ARRAY,

746: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
747:
748:
749: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
750: dim_array IN MDSYS.SDO_DIM_ARRAY,
751: m_pos IN INTEGER DEFAULT NULL)
752:
753: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
754:

Line 758: dim_array IN MDSYS.SDO_DIM_ARRAY,

754:
755:
756:
757: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
758: dim_array IN MDSYS.SDO_DIM_ARRAY,
759: start_measure IN NUMBER ,
760: end_measure IN NUMBER )
761: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
762:

Line 795: dim_array IN MDSYS.SDO_DIM_ARRAY,

791:
792:
793:
794: FUNCTION convert_to_lrs_geom_3d(standard_geom IN MDSYS.SDO_GEOMETRY,
795: dim_array IN MDSYS.SDO_DIM_ARRAY,
796: start_measure IN NUMBER DEFAULT NULL,
797: end_measure IN NUMBER DEFAULT NULL)
798: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
799:

Line 814: dim_array IN MDSYS.SDO_DIM_ARRAY)

810: -- Convert an LRS geometry to a standard linestring geometry
811: --
812:
813: FUNCTION convert_to_std_geom(lrs_geom IN MDSYS.SDO_GEOMETRY,
814: dim_array IN MDSYS.SDO_DIM_ARRAY)
815:
816: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
817:
818:

Line 827: dim_array IN MDSYS.SDO_DIM_ARRAY)

823:
824:
825:
826: FUNCTION convert_to_std_geom_3d(lrs_geom IN MDSYS.SDO_GEOMETRY,
827: dim_array IN MDSYS.SDO_DIM_ARRAY)
828: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
829:
830:
831: FUNCTION convert_to_std_geom_3d(lrs_geom IN MDSYS.SDO_GEOMETRY)

Line 900: dim_array IN MDSYS.SDO_DIM_ARRAY,

896: -- return a new geom_segment by translateing the original geom_segment
897: --
898:
899: FUNCTION translate_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
900: dim_array IN MDSYS.SDO_DIM_ARRAY,
901: translate_m IN NUMBER)
902:
903: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
904:

Line 914: dim_array IN MDSYS.SDO_DIM_ARRAY,

910:
911:
912:
913: FUNCTION translate_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
914: dim_array IN MDSYS.SDO_DIM_ARRAY,
915: translate_m IN NUMBER)
916:
917: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
918:

Line 934: dim_array IN MDSYS.SDO_DIM_ARRAY)

930: -- return a new geom_segment by reversing the original geom segment
931: --
932:
933: FUNCTION reverse_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
934: dim_array IN MDSYS.SDO_DIM_ARRAY)
935:
936: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
937:
938:

Line 946: dim_array IN MDSYS.SDO_DIM_ARRAY)

942:
943:
944:
945: FUNCTION reverse_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
946: dim_array IN MDSYS.SDO_DIM_ARRAY)
947:
948: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
949:
950:

Line 963: dim_array IN MDSYS.SDO_DIM_ARRAY,

959: -- first project the pt onto the LRS segment then get the measure of the projection pt
960: --
961:
962: FUNCTION find_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
963: dim_array IN MDSYS.SDO_DIM_ARRAY,
964: point IN MDSYS.SDO_GEOMETRY,
965: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)
966:
967: RETURN NUMBER PARALLEL_ENABLE;

Line 965: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)

961:
962: FUNCTION find_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
963: dim_array IN MDSYS.SDO_DIM_ARRAY,
964: point IN MDSYS.SDO_GEOMETRY,
965: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)
966:
967: RETURN NUMBER PARALLEL_ENABLE;
968:
969:

Line 981: dim_array IN MDSYS.SDO_DIM_ARRAY,

977:
978:
979:
980: FUNCTION find_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
981: dim_array IN MDSYS.SDO_DIM_ARRAY,
982: point IN MDSYS.SDO_GEOMETRY,
983: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)
984:
985: RETURN NUMBER PARALLEL_ENABLE;

Line 983: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)

979:
980: FUNCTION find_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
981: dim_array IN MDSYS.SDO_DIM_ARRAY,
982: point IN MDSYS.SDO_GEOMETRY,
983: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)
984:
985: RETURN NUMBER PARALLEL_ENABLE;
986:
987:

Line 995: dim_array IN MDSYS.SDO_DIM_ARRAY,

991:
992: RETURN NUMBER PARALLEL_ENABLE;
993:
994: FUNCTION find_offset(geom_segment IN MDSYS.SDO_GEOMETRY,
995: dim_array IN MDSYS.SDO_DIM_ARRAY,
996: point IN MDSYS.SDO_GEOMETRY,
997: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)
998:
999: RETURN NUMBER PARALLEL_ENABLE;

Line 997: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)

993:
994: FUNCTION find_offset(geom_segment IN MDSYS.SDO_GEOMETRY,
995: dim_array IN MDSYS.SDO_DIM_ARRAY,
996: point IN MDSYS.SDO_GEOMETRY,
997: point_dim_array IN MDSYS.SDO_DIM_ARRAY DEFAULT NULL)
998:
999: RETURN NUMBER PARALLEL_ENABLE;
1000:
1001:

Line 1020: dim_array IN MDSYS.SDO_DIM_ARRAY,

1016: --
1017:
1018:
1019: FUNCTION dynamic_segment(geom_segment IN MDSYS.SDO_GEOMETRY,
1020: dim_array IN MDSYS.SDO_DIM_ARRAY,
1021: start_measure IN NUMBER,
1022: end_measure IN NUMBER )
1023:
1024: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1036: dim_array IN MDSYS.SDO_DIM_ARRAY,

1032: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1033:
1034:
1035: FUNCTION dynamic_segment_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
1036: dim_array IN MDSYS.SDO_DIM_ARRAY,
1037: start_measure IN NUMBER,
1038: end_measure IN NUMBER )
1039:
1040: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1059: dim_array IN MDSYS.SDO_DIM_ARRAY,

1055: --
1056:
1057:
1058: FUNCTION measure_to_percentage(geom_segment IN MDSYS.SDO_GEOMETRY,
1059: dim_array IN MDSYS.SDO_DIM_ARRAY,
1060: measure IN NUMBER)
1061:
1062: RETURN NUMBER PARALLEL_ENABLE;
1063:

Line 1078: dim_array IN MDSYS.SDO_DIM_ARRAY,

1074: -- LRS 817 convert a percentage (0%~100%) to a measure w.r.t. given geom segment
1075: --
1076:
1077: FUNCTION percentage_to_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
1078: dim_array IN MDSYS.SDO_DIM_ARRAY,
1079: percentage IN NUMBER)
1080:
1081: RETURN NUMBER PARALLEL_ENABLE;
1082:

Line 1096: dim_array IN MDSYS.SDO_DIM_ARRAY);

1092: --
1093: -- reset the measure values to NULL
1094: --
1095: PROCEDURE reset_measure(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1096: dim_array IN MDSYS.SDO_DIM_ARRAY);
1097:
1098:
1099: PROCEDURE reset_measure(geom_segment IN OUT MDSYS.SDO_GEOMETRY);
1100:

Line 1110: dim_array IN MDSYS.SDO_DIM_ARRAY,

1106: -- if exist.
1107: --
1108:
1109: PROCEDURE redefine_geom_segment(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1110: dim_array IN MDSYS.SDO_DIM_ARRAY,
1111: start_measure IN NUMBER ,
1112: end_measure IN NUMBER );
1113:
1114:

Line 1116: dim_array IN MDSYS.SDO_DIM_ARRAY);

1112: end_measure IN NUMBER );
1113:
1114:
1115: PROCEDURE redefine_geom_segment(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1116: dim_array IN MDSYS.SDO_DIM_ARRAY);
1117:
1118:
1119:
1120:

Line 1135: dim_array IN MDSYS.SDO_DIM_ARRAY,

1131:
1132:
1133:
1134: PROCEDURE redefine_geom_segment_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1135: dim_array IN MDSYS.SDO_DIM_ARRAY,
1136: start_measure IN NUMBER ,
1137: end_measure IN NUMBER );
1138:
1139:

Line 1141: dim_array IN MDSYS.SDO_DIM_ARRAY);

1137: end_measure IN NUMBER );
1138:
1139:
1140: PROCEDURE redefine_geom_segment_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1141: dim_array IN MDSYS.SDO_DIM_ARRAY);
1142:
1143:
1144:
1145: PROCEDURE redefine_geom_segment_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,

Line 1168: dim_array IN MDSYS.SDO_DIM_ARRAY,

1164: -- set the measure value of the closest point (using snap_to_pt) in the given geometry
1165: --
1166:
1167: FUNCTION set_pt_measure(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1168: dim_array IN MDSYS.SDO_DIM_ARRAY,
1169: point IN MDSYS.SDO_GEOMETRY,
1170: pt_dim_array IN MDSYS.SDO_DIM_ARRAY,
1171: measure IN NUMBER )
1172: RETURN VARCHAR2 PARALLEL_ENABLE;

Line 1170: pt_dim_array IN MDSYS.SDO_DIM_ARRAY,

1166:
1167: FUNCTION set_pt_measure(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1168: dim_array IN MDSYS.SDO_DIM_ARRAY,
1169: point IN MDSYS.SDO_GEOMETRY,
1170: pt_dim_array IN MDSYS.SDO_DIM_ARRAY,
1171: measure IN NUMBER )
1172: RETURN VARCHAR2 PARALLEL_ENABLE;
1173:
1174:

Line 1176: dim_array IN MDSYS.SDO_DIM_ARRAY,

1172: RETURN VARCHAR2 PARALLEL_ENABLE;
1173:
1174:
1175: FUNCTION set_pt_measure(point IN OUT MDSYS.SDO_GEOMETRY,
1176: dim_array IN MDSYS.SDO_DIM_ARRAY,
1177: measure IN NUMBER )
1178: RETURN VARCHAR2 PARALLEL_ENABLE;
1179:
1180:

Line 1196: dim_array IN MDSYS.SDO_DIM_ARRAY,

1192:
1193:
1194:
1195: FUNCTION set_pt_measure_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1196: dim_array IN MDSYS.SDO_DIM_ARRAY,
1197: point IN MDSYS.SDO_GEOMETRY,
1198: pt_dim_array IN MDSYS.SDO_DIM_ARRAY,
1199: measure IN NUMBER )
1200: RETURN VARCHAR2 PARALLEL_ENABLE;

Line 1198: pt_dim_array IN MDSYS.SDO_DIM_ARRAY,

1194:
1195: FUNCTION set_pt_measure_3d(geom_segment IN OUT MDSYS.SDO_GEOMETRY,
1196: dim_array IN MDSYS.SDO_DIM_ARRAY,
1197: point IN MDSYS.SDO_GEOMETRY,
1198: pt_dim_array IN MDSYS.SDO_DIM_ARRAY,
1199: measure IN NUMBER )
1200: RETURN VARCHAR2 PARALLEL_ENABLE;
1201:
1202:

Line 1215: dim_array IN MDSYS.SDO_DIM_ARRAY)

1211: -- reverse the direction of the geometry (shape pt order )
1212: --
1213:
1214: FUNCTION reverse_geometry(geom IN MDSYS.SDO_GEOMETRY,
1215: dim_array IN MDSYS.SDO_DIM_ARRAY)
1216:
1217: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1218:
1219:

Line 1234: dim_array IN MDSYS.SDO_DIM_ARRAY,

1230:
1231: -- for geodetic offset, consider arc_tolerance
1232:
1233: FUNCTION offset_geom_segment(geom_segment IN MDSYS.SDO_GEOMETRY,
1234: dim_array IN MDSYS.SDO_DIM_ARRAY,
1235: start_measure IN NUMBER,
1236: end_measure IN NUMBER,
1237: offset IN NUMBER,
1238: unit IN VARCHAR2)

Line 1260: dim_array IN MDSYS.SDO_DIM_ARRAY,

1256:
1257:
1258:
1259: FUNCTION offset_geom_segment(geom_segment IN MDSYS.SDO_GEOMETRY,
1260: dim_array IN MDSYS.SDO_DIM_ARRAY,
1261: start_measure IN NUMBER,
1262: end_measure IN NUMBER,
1263: offset IN NUMBER)
1264:

Line 1291: dim_array IN MDSYS.SDO_DIM_ARRAY)

1287:
1288:
1289:
1290: FUNCTION is_measure_increasing(geom_segment IN MDSYS.SDO_GEOMETRY,
1291: dim_array IN MDSYS.SDO_DIM_ARRAY)
1292:
1293:
1294: RETURN VARCHAR2 PARALLEL_ENABLE;
1295:

Line 1304: dim_array IN MDSYS.SDO_DIM_ARRAY)

1300: RETURN VARCHAR2 PARALLEL_ENABLE;
1301:
1302:
1303: FUNCTION is_measure_increasing_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
1304: dim_array IN MDSYS.SDO_DIM_ARRAY)
1305:
1306:
1307: RETURN VARCHAR2 PARALLEL_ENABLE;
1308:

Line 1319: dim_array IN MDSYS.SDO_DIM_ARRAY)

1315:
1316:
1317:
1318: FUNCTION is_measure_decreasing(geom_segment IN MDSYS.SDO_GEOMETRY,
1319: dim_array IN MDSYS.SDO_DIM_ARRAY)
1320:
1321:
1322: RETURN VARCHAR2 PARALLEL_ENABLE;
1323:

Line 1331: dim_array IN MDSYS.SDO_DIM_ARRAY)

1327: RETURN VARCHAR2 PARALLEL_ENABLE;
1328:
1329:
1330: FUNCTION is_measure_decreasing_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
1331: dim_array IN MDSYS.SDO_DIM_ARRAY)
1332:
1333:
1334: RETURN VARCHAR2 PARALLEL_ENABLE;
1335:

Line 1344: dim_array IN MDSYS.SDO_DIM_ARRAY)

1340:
1341:
1342:
1343: FUNCTION validate_lrs_geometry(geom_segment IN MDSYS.SDO_GEOMETRY,
1344: dim_array IN MDSYS.SDO_DIM_ARRAY)
1345:
1346: RETURN VARCHAR2 PARALLEL_ENABLE;
1347:
1348:

Line 1354: dim_array IN MDSYS.SDO_DIM_ARRAY)

1350: RETURN VARCHAR2 PARALLEL_ENABLE;
1351:
1352:
1353: FUNCTION validate_lrs_geometry_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
1354: dim_array IN MDSYS.SDO_DIM_ARRAY)
1355:
1356: RETURN VARCHAR2 PARALLEL_ENABLE;
1357:
1358:

Line 1373: dim_array IN MDSYS.SDO_DIM_ARRAY,

1369: -- get previous shape point based on the given measure
1370: --
1371:
1372: FUNCTION get_prev_shape_pt (geom_segment IN MDSYS.SDO_GEOMETRY,
1373: dim_array IN MDSYS.SDO_DIM_ARRAY,
1374: measure IN NUMBER)
1375:
1376: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1377:

Line 1388: dim_array IN MDSYS.SDO_DIM_ARRAY,

1384:
1385:
1386:
1387: FUNCTION get_prev_shape_pt_3d (geom_segment IN MDSYS.SDO_GEOMETRY,
1388: dim_array IN MDSYS.SDO_DIM_ARRAY,
1389: measure IN NUMBER)
1390:
1391: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1392:

Line 1408: dim_array IN MDSYS.SDO_DIM_ARRAY,

1404: --
1405:
1406:
1407: FUNCTION get_prev_shape_pt (geom_segment IN MDSYS.SDO_GEOMETRY,
1408: dim_array IN MDSYS.SDO_DIM_ARRAY,
1409: point IN MDSYS.SDO_GEOMETRY)
1410:
1411: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1412:

Line 1423: dim_array IN MDSYS.SDO_DIM_ARRAY,

1419:
1420:
1421:
1422: FUNCTION get_prev_shape_pt_3d (geom_segment IN MDSYS.SDO_GEOMETRY,
1423: dim_array IN MDSYS.SDO_DIM_ARRAY,
1424: point IN MDSYS.SDO_GEOMETRY)
1425:
1426: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1427:

Line 1444: dim_array IN MDSYS.SDO_DIM_ARRAY,

1440: --
1441:
1442:
1443: FUNCTION get_next_shape_pt (geom_segment IN MDSYS.SDO_GEOMETRY,
1444: dim_array IN MDSYS.SDO_DIM_ARRAY,
1445: measure IN NUMBER)
1446:
1447: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1448:

Line 1458: dim_array IN MDSYS.SDO_DIM_ARRAY,

1454:
1455:
1456:
1457: FUNCTION get_next_shape_pt_3d (geom_segment IN MDSYS.SDO_GEOMETRY,
1458: dim_array IN MDSYS.SDO_DIM_ARRAY,
1459: measure IN NUMBER)
1460:
1461: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1462:

Line 1478: dim_array IN MDSYS.SDO_DIM_ARRAY,

1474: --
1475:
1476:
1477: FUNCTION get_next_shape_pt (geom_segment IN MDSYS.SDO_GEOMETRY,
1478: dim_array IN MDSYS.SDO_DIM_ARRAY,
1479: point IN MDSYS.SDO_GEOMETRY)
1480:
1481: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1482:

Line 1493: dim_array IN MDSYS.SDO_DIM_ARRAY,

1489:
1490:
1491:
1492: FUNCTION get_next_shape_pt_3d (geom_segment IN MDSYS.SDO_GEOMETRY,
1493: dim_array IN MDSYS.SDO_DIM_ARRAY,
1494: point IN MDSYS.SDO_GEOMETRY)
1495:
1496: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1497:

Line 1514: dim_array IN MDSYS.SDO_DIM_ARRAY,

1510: --
1511:
1512:
1513: FUNCTION get_prev_shape_pt_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
1514: dim_array IN MDSYS.SDO_DIM_ARRAY,
1515: measure IN NUMBER)
1516:
1517: RETURN NUMBER PARALLEL_ENABLE;
1518:

Line 1530: dim_array IN MDSYS.SDO_DIM_ARRAY,

1526:
1527:
1528:
1529: FUNCTION get_prev_shape_pt_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
1530: dim_array IN MDSYS.SDO_DIM_ARRAY,
1531: measure IN NUMBER)
1532:
1533: RETURN NUMBER PARALLEL_ENABLE;
1534:

Line 1551: dim_array IN MDSYS.SDO_DIM_ARRAY,

1547: --
1548:
1549:
1550: FUNCTION get_prev_shape_pt_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
1551: dim_array IN MDSYS.SDO_DIM_ARRAY,
1552: point IN MDSYS.SDO_GEOMETRY)
1553:
1554: RETURN NUMBER PARALLEL_ENABLE;
1555:

Line 1568: dim_array IN MDSYS.SDO_DIM_ARRAY,

1564:
1565:
1566:
1567: FUNCTION get_prev_shape_pt_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
1568: dim_array IN MDSYS.SDO_DIM_ARRAY,
1569: point IN MDSYS.SDO_GEOMETRY)
1570:
1571: RETURN NUMBER PARALLEL_ENABLE;
1572:

Line 1590: dim_array IN MDSYS.SDO_DIM_ARRAY,

1586: --
1587:
1588:
1589: FUNCTION get_next_shape_pt_measure (geom_segment IN MDSYS.SDO_GEOMETRY,
1590: dim_array IN MDSYS.SDO_DIM_ARRAY,
1591: measure IN NUMBER)
1592:
1593: RETURN NUMBER PARALLEL_ENABLE;
1594:

Line 1603: dim_array IN MDSYS.SDO_DIM_ARRAY,

1599: RETURN NUMBER PARALLEL_ENABLE;
1600:
1601:
1602: FUNCTION get_next_shape_pt_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
1603: dim_array IN MDSYS.SDO_DIM_ARRAY,
1604: point IN MDSYS.SDO_GEOMETRY)
1605:
1606: RETURN NUMBER PARALLEL_ENABLE;
1607:

Line 1618: dim_array IN MDSYS.SDO_DIM_ARRAY,

1614:
1615:
1616:
1617: FUNCTION get_next_shape_pt_measure_3d (geom_segment IN MDSYS.SDO_GEOMETRY,
1618: dim_array IN MDSYS.SDO_DIM_ARRAY,
1619: measure IN NUMBER)
1620:
1621: RETURN NUMBER PARALLEL_ENABLE;
1622:

Line 1632: dim_array IN MDSYS.SDO_DIM_ARRAY,

1628:
1629:
1630:
1631: FUNCTION get_next_shape_pt_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
1632: dim_array IN MDSYS.SDO_DIM_ARRAY,
1633: point IN MDSYS.SDO_GEOMETRY)
1634:
1635: RETURN NUMBER PARALLEL_ENABLE;
1636:

Line 1646: dim_array IN MDSYS.SDO_DIM_ARRAY,

1642: RETURN NUMBER;
1643:
1644:
1645: FUNCTION is_shape_pt_measure(geom_segment IN MDSYS.SDO_GEOMETRY,
1646: dim_array IN MDSYS.SDO_DIM_ARRAY,
1647: measure IN NUMBER)
1648:
1649: RETURN VARCHAR2 PARALLEL_ENABLE;
1650:

Line 1659: dim_array IN MDSYS.SDO_DIM_ARRAY,

1655: RETURN VARCHAR2 PARALLEL_ENABLE;
1656:
1657:
1658: FUNCTION is_shape_pt_measure_3d(geom_segment IN MDSYS.SDO_GEOMETRY,
1659: dim_array IN MDSYS.SDO_DIM_ARRAY,
1660: measure IN NUMBER)
1661:
1662: RETURN VARCHAR2 PARALLEL_ENABLE;
1663:

Line 1676: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,

1672: -- intersection for LRS geometries
1673: --
1674:
1675: FUNCTION lrs_intersection( geom_1 IN MDSYS.SDO_GEOMETRY,
1676: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
1677: geom_2 IN MDSYS.SDO_GEOMETRY,
1678: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
1679:
1680: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1678: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)

1674:
1675: FUNCTION lrs_intersection( geom_1 IN MDSYS.SDO_GEOMETRY,
1676: dim_array_1 IN MDSYS.SDO_DIM_ARRAY,
1677: geom_2 IN MDSYS.SDO_GEOMETRY,
1678: dim_array_2 IN MDSYS.SDO_DIM_ARRAY)
1679:
1680: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1681:
1682: