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.

[Home] [Help]

APPS.CSF_LOCUS_PUB dependencies on SDO_GEOMETRY

Line 14: , p_locus IN MDSYS.SDO_GEOMETRY

10: p_api_version IN NUMBER
11: , x_return_status OUT NOCOPY VARCHAR2
12: , x_msg_count OUT NOCOPY NUMBER
13: , x_msg_data OUT NOCOPY VARCHAR2
14: , p_locus IN MDSYS.SDO_GEOMETRY
15: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY
16: , x_segid OUT NOCOPY NUMBER
17: , x_offset OUT NOCOPY NUMBER
18: , x_direction OUT NOCOPY NUMBER

Line 15: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY

11: , x_return_status OUT NOCOPY VARCHAR2
12: , x_msg_count OUT NOCOPY NUMBER
13: , x_msg_data OUT NOCOPY VARCHAR2
14: , p_locus IN MDSYS.SDO_GEOMETRY
15: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY
16: , x_segid OUT NOCOPY NUMBER
17: , x_offset OUT NOCOPY NUMBER
18: , x_direction OUT NOCOPY NUMBER
19: ) AS

Line 34: MDSYS.SDO_GEOMETRY(

30: x_segid := p_locus.sdo_ordinates(p_locus.sdo_elem_info(4) + 2);
31: x_offset := p_locus.sdo_ordinates(p_locus.sdo_elem_info(4) + 3);
32: x_direction := p_locus.sdo_ordinates(p_locus.sdo_elem_info(4) + 4);
33: x_geom :=
34: MDSYS.SDO_GEOMETRY(
35: 2001
36: , NULL
37: , MDSYS.sdo_point_type(p_locus.sdo_ordinates(1), p_locus.sdo_ordinates(2), NULL)
38: , MDSYS.sdo_elem_info_array(1, 1, 1)

Line 52: MDSYS.SDO_GEOMETRY(

48: x_segid := 9999;
49: x_offset := 9;
50: x_direction := 9;
51: x_geom :=
52: MDSYS.SDO_GEOMETRY(
53: 2001
54: , NULL
55: , MDSYS.sdo_point_type(p_locus.sdo_point.x, p_locus.sdo_point.y, NULL)
56: , MDSYS.sdo_elem_info_array(1, 1, 1)

Line 73: , p_geom IN MDSYS.SDO_GEOMETRY

69: p_api_version IN NUMBER
70: , x_return_status OUT NOCOPY VARCHAR2
71: , x_msg_count OUT NOCOPY NUMBER
72: , x_msg_data OUT NOCOPY VARCHAR2
73: , p_geom IN MDSYS.SDO_GEOMETRY
74: , p_segid IN NUMBER
75: , p_offset IN NUMBER
76: , p_direction IN NUMBER
77: , p_accuracyFactor IN NUMBER

Line 78: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY

74: , p_segid IN NUMBER
75: , p_offset IN NUMBER
76: , p_direction IN NUMBER
77: , p_accuracyFactor IN NUMBER
78: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY
79: ) AS
80: l_ordinates MDSYS.sdo_ordinate_array;
81: i NUMBER;
82: l_api_name CONSTANT VARCHAR2(30) := 'WRITE_LOCUS';

Line 104: MDSYS.SDO_GEOMETRY(

100: END IF;
101: END IF;
102:
103: x_locus :=
104: MDSYS.SDO_GEOMETRY(
105: 2001
106: , NULL
107: , NULL
108: , MDSYS.sdo_elem_info_array(1, 1, 1, l_ordinates.COUNT + 1, 0, 5)

Line 125: , p_locus IN MDSYS.SDO_GEOMETRY

121: p_api_version IN NUMBER
122: , x_return_status OUT NOCOPY VARCHAR2
123: , x_msg_count OUT NOCOPY NUMBER
124: , x_msg_data OUT NOCOPY VARCHAR2
125: , p_locus IN MDSYS.SDO_GEOMETRY
126: , x_result OUT NOCOPY VARCHAR2
127: , x_geo_type OUT NOCOPY VARCHAR2
128: ) AS
129: l_api_name CONSTANT VARCHAR2(30) := 'VERIFY_LOCUS';

Line 167: , p_locus IN MDSYS.SDO_GEOMETRY

163: p_api_version IN NUMBER
164: , x_return_status OUT NOCOPY VARCHAR2
165: , x_msg_count OUT NOCOPY NUMBER
166: , x_msg_data OUT NOCOPY VARCHAR2
167: , p_locus IN MDSYS.SDO_GEOMETRY
168: , x_result OUT NOCOPY VARCHAR2
169: ) AS
170: l_geo_type VARCHAR2(6);
171: BEGIN

Line 190: , p_geom IN MDSYS.SDO_GEOMETRY

186: p_api_version IN NUMBER
187: , x_return_status OUT NOCOPY VARCHAR2
188: , x_msg_count OUT NOCOPY NUMBER
189: , x_msg_data OUT NOCOPY VARCHAR2
190: , p_geom IN MDSYS.SDO_GEOMETRY
191: )
192: RETURN NUMBER IS
193: RESULT VARCHAR2(6);
194: GEO_TYPE VARCHAR2(6);

Line 224: , p_geom IN MDSYS.SDO_GEOMETRY

220: p_api_version IN NUMBER
221: , x_return_status OUT NOCOPY VARCHAR2
222: , x_msg_count OUT NOCOPY NUMBER
223: , x_msg_data OUT NOCOPY VARCHAR2
224: , p_geom IN MDSYS.SDO_GEOMETRY
225: )
226: RETURN NUMBER IS
227: RESULT VARCHAR2(6);
228: GEO_TYPE VARCHAR2(6);

Line 256: , p_geom IN MDSYS.SDO_GEOMETRY

252: p_api_version IN NUMBER
253: , x_return_status OUT NOCOPY VARCHAR2
254: , x_msg_count OUT NOCOPY NUMBER
255: , x_msg_data OUT NOCOPY VARCHAR2
256: , p_geom IN MDSYS.SDO_GEOMETRY
257: )
258: RETURN NUMBER IS
259: RESULT VARCHAR2(6);
260: GEO_TYPE VARCHAR2(6);

Line 288: , p_geom IN MDSYS.SDO_GEOMETRY

284: p_api_version IN NUMBER
285: , x_return_status OUT NOCOPY VARCHAR2
286: , x_msg_count OUT NOCOPY NUMBER
287: , x_msg_data OUT NOCOPY VARCHAR2
288: , p_geom IN MDSYS.SDO_GEOMETRY
289: )
290: RETURN NUMBER IS
291: RESULT VARCHAR2(6);
292: GEO_TYPE VARCHAR2(6);

Line 320: , p_geom IN MDSYS.SDO_GEOMETRY

316: p_api_version IN NUMBER
317: , x_return_status OUT NOCOPY VARCHAR2
318: , x_msg_count OUT NOCOPY NUMBER
319: , x_msg_data OUT NOCOPY VARCHAR2
320: , p_geom IN MDSYS.SDO_GEOMETRY
321: )
322: RETURN NUMBER IS
323: RESULT VARCHAR2(6);
324: GEO_TYPE VARCHAR2(6);

Line 348: p_geom in mdsys.sdo_geometry,

344: END IF;
345: END;
346:
347: FUNCTION get_locus_srid ( p_api_version in number,
348: p_geom in mdsys.sdo_geometry,
349: x_msg_count out nocopy number,
350: x_msg_data out nocopy varchar2,
351: x_return_status out nocopy varchar2) return NUMBER is
352: result VARCHAR2(6);

Line 371: FUNCTION should_call_lf(p_geom IN MDSYS.SDO_GEOMETRY)

367: return -9999;
368: end if;
369: END;
370:
371: FUNCTION should_call_lf(p_geom IN MDSYS.SDO_GEOMETRY)
372: RETURN VARCHAR2 AS
373: BEGIN
374: IF p_geom IS NULL THEN
375: RETURN fnd_api.g_true;

Line 381: FUNCTION get_locus_segmentid(p_geom IN MDSYS.SDO_GEOMETRY)

377: RETURN fnd_api.g_false;
378: END IF;
379: END should_call_lf;
380:
381: FUNCTION get_locus_segmentid(p_geom IN MDSYS.SDO_GEOMETRY)
382: RETURN NUMBER AS
383: l_return_status VARCHAR2(1);
384: l_msg_count NUMBER;
385: l_msg_data VARCHAR2(1000);

Line 396: FUNCTION get_locus_side(p_geom IN MDSYS.SDO_GEOMETRY)

392: , x_return_status => l_return_status
393: );
394: END;
395:
396: FUNCTION get_locus_side(p_geom IN MDSYS.SDO_GEOMETRY)
397: RETURN NUMBER AS
398: l_return_status VARCHAR2(1);
399: l_msg_count NUMBER;
400: l_msg_data VARCHAR2(1000);

Line 411: FUNCTION get_locus_spot(p_geom IN MDSYS.SDO_GEOMETRY)

407: , x_return_status => l_return_status
408: );
409: END;
410:
411: FUNCTION get_locus_spot(p_geom IN MDSYS.SDO_GEOMETRY)
412: RETURN NUMBER AS
413: l_return_status VARCHAR2(1);
414: l_msg_count NUMBER;
415: l_msg_data VARCHAR2(1000);

Line 426: FUNCTION get_locus_lat(p_geom IN MDSYS.SDO_GEOMETRY)

422: , x_return_status => l_return_status
423: );
424: END;
425:
426: FUNCTION get_locus_lat(p_geom IN MDSYS.SDO_GEOMETRY)
427: RETURN NUMBER AS
428: l_return_status VARCHAR2(1);
429: l_msg_count NUMBER;
430: l_msg_data VARCHAR2(1000);

Line 441: FUNCTION get_locus_lon(p_geom IN MDSYS.SDO_GEOMETRY)

437: , x_return_status => l_return_status
438: );
439: END;
440:
441: FUNCTION get_locus_lon(p_geom IN MDSYS.SDO_GEOMETRY)
442: RETURN NUMBER AS
443: l_return_status VARCHAR2(1);
444: l_msg_count NUMBER;
445: l_msg_data VARCHAR2(1000);

Line 457: FUNCTION get_locus_srid(p_geom IN MDSYS.SDO_GEOMETRY)

453: );
454: END;
455:
456:
457: FUNCTION get_locus_srid(p_geom IN MDSYS.SDO_GEOMETRY)
458: RETURN NUMBER AS
459: l_return_status VARCHAR2(1);
460: l_msg_count NUMBER;
461: l_msg_data VARCHAR2(1000);

Line 479: FUNCTION get_geometry (p_geometry MDSYS.SDO_GEOMETRY, p_item VARCHAR2, p_index NUMBER DEFAULT NULL)

475: RETURN l_srid;
476: END;
477:
478:
479: FUNCTION get_geometry (p_geometry MDSYS.SDO_GEOMETRY, p_item VARCHAR2, p_index NUMBER DEFAULT NULL)
480: RETURN NUMBER
481: AS
482: -- Bug 1633731
483: -- This function is called with p_item = 'SDO_POINT' and p_index = 1 (X)

Line 554: l_geom MDSYS.SDO_GEOMETRY;

550:
551: /* FUNCTION get_serv_area_coordinates (p_country_id NUMBER, p_index NUMBER)
552: RETURN NUMBER
553: AS
554: l_geom MDSYS.SDO_GEOMETRY;
555: l_coord NUMBER := NULL;
556:
557: CURSOR c1
558: IS

Line 577: l_geom MDSYS.SDO_GEOMETRY;

573:
574: FUNCTION get_serv_area_coordinates (p_country_id NUMBER, p_index NUMBER)
575: RETURN NUMBER
576: AS
577: l_geom MDSYS.SDO_GEOMETRY;
578: l_coord NUMBER := NULL;
579: TYPE REF_DISPLAY IS REF CURSOR;
580: c1 REF_DISPLAY;
581: sql_stmt_str VARCHAR2(2000);

Line 612: l_geom MDSYS.SDO_GEOMETRY;

608:
609: FUNCTION get_serv_area_coordinates (p_country_id NUMBER,p_dataset VARCHAR2, p_index NUMBER)
610: RETURN NUMBER
611: AS
612: l_geom MDSYS.SDO_GEOMETRY;
613: l_coord NUMBER := NULL;
614: TYPE REF_DISPLAY IS REF CURSOR;
615: c1 REF_DISPLAY;
616: sql_stmt_str VARCHAR2(2000);

Line 657: TYPE geometry_tbl_type IS TABLE OF MDSYS.SDO_GEOMETRY;

653: , p_sampling_level VARCHAR2 DEFAULT NULL
654: )
655: RETURN jtf_varchar2_table_2000 IS
656:
657: TYPE geometry_tbl_type IS TABLE OF MDSYS.SDO_GEOMETRY;
658: l_geometry_tbl geometry_tbl_type;
659: l_geometry_str_tbl jtf_varchar2_table_2000;
660: j PLS_INTEGER;
661:

Line 857: SET geometry = mdsys.sdo_geometry(

853: l_srid := NVL(p_srid, 8307);
854:
855: FORALL i IN 1..p_location_id_tbl.COUNT
856: UPDATE hz_locations
857: SET geometry = mdsys.sdo_geometry(
858: 2001
859: , l_srid
860: , mdsys.sdo_point_type( p_longitude_tbl(i), p_latitude_tbl(i), 0)
861: , mdsys.sdo_elem_info_array(1,1,1)

Line 884: FUNCTION get_locus_string(p_geom IN MDSYS.SDO_GEOMETRY, p_soft_validation VARCHAR2)

880: * Returns the Given Geometry in String Representation with each attribute
881: * separated by @. The sequence of the attributes are Longitude, Latitude,
882: * Segment Id, Offset and Side.
883: */
884: FUNCTION get_locus_string(p_geom IN MDSYS.SDO_GEOMETRY, p_soft_validation VARCHAR2)
885: RETURN VARCHAR2 AS
886: l_return_status VARCHAR2(1);
887: l_msg_count NUMBER;
888: l_msg_data VARCHAR2(1000);

Line 891: l_geometry mdsys.sdo_geometry;

887: l_msg_count NUMBER;
888: l_msg_data VARCHAR2(1000);
889:
890: l_result VARCHAR2(6);
891: l_geometry mdsys.sdo_geometry;
892: l_locus_string VARCHAR2(200);
893: l_geo_type VARCHAR2(6);
894: BEGIN
895: IF (p_soft_validation = fnd_api.g_true) THEN

Line 1035: WHERE SDO_NN(r.ROADSEGMENT_GEOMETRY, SDO_GEOMETRY(2002,8307,null,SDO_ELEM_INFO_ARRAY(1,2,1),

1031: select spatial_dataset into l_tbl_sufx from CSF_SPATIAL_CTRY_MAPPINGS where spatial_country_name = p_country or spatial_country_code = p_country;
1032:
1033: l_sql_stmt := 'SELECT /*+ INDEX(r CSF_LF_RDSEGS_N2) */ ROADSEGMENT_ID, SDO_NN_DISTANCE(1) dist
1034: FROM csf_lf_roadsegments' || l_tbl_sufx || ' r
1035: WHERE SDO_NN(r.ROADSEGMENT_GEOMETRY, SDO_GEOMETRY(2002,8307,null,SDO_ELEM_INFO_ARRAY(1,2,1),
1036: SDO_ORDINATE_ARRAY(:1, :2, :3, :4)), ''sdo_num_res=1'', 1) = ''TRUE'' ORDER BY dist';
1037:
1038: OPEN cursor_rdseg for l_sql_stmt USING p_longitude,p_latitude,p_longitude,p_latitude;
1039: LOOP

Line 1057: FUNCTION is_manual_geometry(p_geometry IN MDSYS.SDO_GEOMETRY)

1053: RETURN x_segment_id;
1054:
1055: END;
1056:
1057: FUNCTION is_manual_geometry(p_geometry IN MDSYS.SDO_GEOMETRY)
1058: RETURN BOOLEAN IS
1059: l_segment_id NUMBER := csf_locus_pub.get_locus_segmentid(p_geometry);
1060: l_locus_lat NUMBER := csf_locus_pub.get_locus_lat(p_geometry);
1061: l_locus_lon NUMBER := csf_locus_pub.get_locus_lon(p_geometry);