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.

APPS.CSF_LOCUS_PUB dependencies on SDO_GEOMETRY

Line 13: , p_locus IN MDSYS.SDO_GEOMETRY

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

Line 14: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY

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

Line 41: MDSYS.SDO_GEOMETRY(

37: x_segid := p_locus.sdo_ordinates(p_locus.sdo_elem_info(4) + 2);
38: x_offset := p_locus.sdo_ordinates(p_locus.sdo_elem_info(4) + 3);
39: x_direction := p_locus.sdo_ordinates(p_locus.sdo_elem_info(4) + 4);
40: x_geom :=
41: MDSYS.SDO_GEOMETRY(
42: 2001
43: , NULL
44: , MDSYS.sdo_point_type(p_locus.sdo_ordinates(1), p_locus.sdo_ordinates(2), NULL)
45: , MDSYS.sdo_elem_info_array(1, 1, 1)

Line 56: , p_geom IN MDSYS.SDO_GEOMETRY

52: p_api_version IN NUMBER
53: , x_return_status OUT NOCOPY VARCHAR2
54: , x_msg_count OUT NOCOPY NUMBER
55: , x_msg_data OUT NOCOPY VARCHAR2
56: , p_geom IN MDSYS.SDO_GEOMETRY
57: , p_segid IN NUMBER
58: , p_offset IN NUMBER
59: , p_direction IN NUMBER
60: --added for LF enhancement of forced accuracy

Line 62: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY

58: , p_offset IN NUMBER
59: , p_direction IN NUMBER
60: --added for LF enhancement of forced accuracy
61: ,p_accuracyFactor IN NUMBER
62: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY
63: ) AS
64: l_ordinates MDSYS.sdo_ordinate_array;
65: i NUMBER;
66: l_api_name CONSTANT VARCHAR2(30) := 'WRITE_LOCUS';

Line 88: MDSYS.SDO_GEOMETRY(

84: END IF;
85: END IF;
86:
87: x_locus :=
88: MDSYS.SDO_GEOMETRY(
89: 2001
90: , NULL
91: , NULL
92: , MDSYS.sdo_elem_info_array(1, 1, 1, l_ordinates.COUNT + 1, 0, 5)

Line 109: , p_locus IN MDSYS.SDO_GEOMETRY

105: p_api_version IN NUMBER
106: , x_return_status OUT NOCOPY VARCHAR2
107: , x_msg_count OUT NOCOPY NUMBER
108: , x_msg_data OUT NOCOPY VARCHAR2
109: , p_locus IN MDSYS.SDO_GEOMETRY
110: , x_result OUT NOCOPY VARCHAR2
111: ) AS
112: l_api_name CONSTANT VARCHAR2(30) := 'VERIFY_LOCUS';
113: BEGIN

Line 159: , p_geom IN MDSYS.SDO_GEOMETRY

155: p_api_version IN NUMBER
156: , x_return_status OUT NOCOPY VARCHAR2
157: , x_msg_count OUT NOCOPY NUMBER
158: , x_msg_data OUT NOCOPY VARCHAR2
159: , p_geom IN MDSYS.SDO_GEOMETRY
160: )
161: RETURN NUMBER IS
162: RESULT VARCHAR2(6);
163: BEGIN

Line 187: , p_geom IN MDSYS.SDO_GEOMETRY

183: p_api_version IN NUMBER
184: , x_return_status OUT NOCOPY VARCHAR2
185: , x_msg_count OUT NOCOPY NUMBER
186: , x_msg_data OUT NOCOPY VARCHAR2
187: , p_geom IN MDSYS.SDO_GEOMETRY
188: )
189: RETURN NUMBER IS
190: RESULT VARCHAR2(6);
191: BEGIN

Line 213: , p_geom IN MDSYS.SDO_GEOMETRY

209: p_api_version IN NUMBER
210: , x_return_status OUT NOCOPY VARCHAR2
211: , x_msg_count OUT NOCOPY NUMBER
212: , x_msg_data OUT NOCOPY VARCHAR2
213: , p_geom IN MDSYS.SDO_GEOMETRY
214: )
215: RETURN NUMBER IS
216: RESULT VARCHAR2(6);
217: BEGIN

Line 239: , p_geom IN MDSYS.SDO_GEOMETRY

235: p_api_version IN NUMBER
236: , x_return_status OUT NOCOPY VARCHAR2
237: , x_msg_count OUT NOCOPY NUMBER
238: , x_msg_data OUT NOCOPY VARCHAR2
239: , p_geom IN MDSYS.SDO_GEOMETRY
240: )
241: RETURN NUMBER IS
242: RESULT VARCHAR2(6);
243: BEGIN

Line 265: , p_geom IN MDSYS.SDO_GEOMETRY

261: p_api_version IN NUMBER
262: , x_return_status OUT NOCOPY VARCHAR2
263: , x_msg_count OUT NOCOPY NUMBER
264: , x_msg_data OUT NOCOPY VARCHAR2
265: , p_geom IN MDSYS.SDO_GEOMETRY
266: )
267: RETURN NUMBER IS
268: RESULT VARCHAR2(6);
269: BEGIN

Line 287: p_geom in mdsys.sdo_geometry,

283: END IF;
284: END;
285:
286: FUNCTION get_locus_srid ( p_api_version in number,
287: p_geom in mdsys.sdo_geometry,
288: x_msg_count out nocopy number,
289: x_msg_data out nocopy varchar2,
290: x_return_status out nocopy varchar2) return NUMBER is
291: result VARCHAR2(6);

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

303: return -9999;
304: end if;
305: END;
306:
307: FUNCTION should_call_lf(p_geom IN MDSYS.SDO_GEOMETRY)
308: RETURN VARCHAR2 AS
309: BEGIN
310: IF p_geom IS NULL THEN
311: RETURN fnd_api.g_true;

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

313: RETURN fnd_api.g_false;
314: END IF;
315: END should_call_lf;
316:
317: FUNCTION get_locus_segmentid(p_geom IN MDSYS.SDO_GEOMETRY)
318: RETURN NUMBER AS
319: l_return_status VARCHAR2(1);
320: l_msg_count NUMBER;
321: l_msg_data VARCHAR2(1000);

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

328: , x_return_status => l_return_status
329: );
330: END;
331:
332: FUNCTION get_locus_side(p_geom IN MDSYS.SDO_GEOMETRY)
333: RETURN NUMBER AS
334: l_return_status VARCHAR2(1);
335: l_msg_count NUMBER;
336: l_msg_data VARCHAR2(1000);

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

343: , x_return_status => l_return_status
344: );
345: END;
346:
347: FUNCTION get_locus_spot(p_geom IN MDSYS.SDO_GEOMETRY)
348: RETURN NUMBER AS
349: l_return_status VARCHAR2(1);
350: l_msg_count NUMBER;
351: l_msg_data VARCHAR2(1000);

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

358: , x_return_status => l_return_status
359: );
360: END;
361:
362: FUNCTION get_locus_lat(p_geom IN MDSYS.SDO_GEOMETRY)
363: RETURN NUMBER AS
364: l_return_status VARCHAR2(1);
365: l_msg_count NUMBER;
366: l_msg_data VARCHAR2(1000);

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

373: , x_return_status => l_return_status
374: );
375: END;
376:
377: FUNCTION get_locus_lon(p_geom IN MDSYS.SDO_GEOMETRY)
378: RETURN NUMBER AS
379: l_return_status VARCHAR2(1);
380: l_msg_count NUMBER;
381: l_msg_data VARCHAR2(1000);

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

389: );
390: END;
391:
392:
393: FUNCTION get_locus_srid(p_geom IN MDSYS.SDO_GEOMETRY)
394: RETURN NUMBER AS
395: l_return_status VARCHAR2(1);
396: l_msg_count NUMBER;
397: l_msg_data VARCHAR2(1000);

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

411: RETURN l_srid;
412: END;
413:
414:
415: FUNCTION get_geometry (p_geometry MDSYS.SDO_GEOMETRY, p_item VARCHAR2, p_index NUMBER DEFAULT NULL)
416: RETURN NUMBER
417: AS
418: -- Bug 1633731
419: -- This function is called with p_item = 'SDO_POINT' and p_index = 1 (X)

Line 490: l_geom MDSYS.SDO_GEOMETRY;

486:
487: /* FUNCTION get_serv_area_coordinates (p_country_id NUMBER, p_index NUMBER)
488: RETURN NUMBER
489: AS
490: l_geom MDSYS.SDO_GEOMETRY;
491: l_coord NUMBER := NULL;
492:
493: CURSOR c1
494: IS

Line 513: l_geom MDSYS.SDO_GEOMETRY;

509:
510: FUNCTION get_serv_area_coordinates (p_country_id NUMBER, p_index NUMBER)
511: RETURN NUMBER
512: AS
513: l_geom MDSYS.SDO_GEOMETRY;
514: l_coord NUMBER := NULL;
515: TYPE REF_DISPLAY IS REF CURSOR;
516: c1 REF_DISPLAY;
517: sql_stmt_str VARCHAR2(2000);

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

549: , p_sampling_level VARCHAR2 DEFAULT NULL
550: )
551: RETURN jtf_varchar2_table_2000 IS
552:
553: TYPE geometry_tbl_type IS TABLE OF MDSYS.SDO_GEOMETRY;
554: l_geometry_tbl geometry_tbl_type;
555: l_geometry_str_tbl jtf_varchar2_table_2000;
556: j PLS_INTEGER;
557:

Line 753: SET geometry = mdsys.sdo_geometry(

749: l_srid := NVL(p_srid, 8307);
750:
751: FORALL i IN 1..p_location_id_tbl.COUNT
752: UPDATE hz_locations
753: SET geometry = mdsys.sdo_geometry(
754: 2001
755: , l_srid
756: , mdsys.sdo_point_type( p_longitude_tbl(i), p_latitude_tbl(i), 0)
757: , mdsys.sdo_elem_info_array(1,1,1)

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

776: * Returns the Given Geometry in String Representation with each attribute
777: * separated by @. The sequence of the attributes are Longitude, Latitude,
778: * Segment Id, Offset and Side.
779: */
780: FUNCTION get_locus_string(p_geom IN MDSYS.SDO_GEOMETRY, p_soft_validation VARCHAR2)
781: RETURN VARCHAR2 AS
782: l_return_status VARCHAR2(1);
783: l_msg_count NUMBER;
784: l_msg_data VARCHAR2(1000);

Line 787: l_geometry mdsys.sdo_geometry;

783: l_msg_count NUMBER;
784: l_msg_data VARCHAR2(1000);
785:
786: l_result VARCHAR2(6);
787: l_geometry mdsys.sdo_geometry;
788: l_locus_string VARCHAR2(200);
789: BEGIN
790: IF (p_soft_validation = fnd_api.g_true) THEN
791: IF p_geom IS NULL