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: * The API reads the locus and returns the Geometry (SDO_GEOMETRY),

9: CSF_LF_VERSION_ERROR EXCEPTION;
10:
11:
12: /**
13: * The API reads the locus and returns the Geometry (SDO_GEOMETRY),
14: * Segment ID, Offset and Side of the Road.
15: *
16: * The API has a PRAGMA Restriction to avoid reading the database or
17: * modifying it.

Line 23: * @param p_locus Locus Object (SDO_GEOMETRY)

19: * @param p_api_version API Version (1.0)
20: * @param x_return_status Return Status of the Procedure.
21: * @param x_msg_count Number of Messages in the Stack.
22: * @param x_msg_data Stack of Error Messages.
23: * @param p_locus Locus Object (SDO_GEOMETRY)
24: * @param x_geom Geometry of the Locus (SDO_GEOMETRY)
25: * @param x_segid Segment ID of the road pointed to by Locus
26: * @param x_offset Offset of the Address in the road pointed to by Locus (0 .. 1)
27: * @param x_direction Direction of the road pointed to by Locus

Line 24: * @param x_geom Geometry of the Locus (SDO_GEOMETRY)

20: * @param x_return_status Return Status of the Procedure.
21: * @param x_msg_count Number of Messages in the Stack.
22: * @param x_msg_data Stack of Error Messages.
23: * @param p_locus Locus Object (SDO_GEOMETRY)
24: * @param x_geom Geometry of the Locus (SDO_GEOMETRY)
25: * @param x_segid Segment ID of the road pointed to by Locus
26: * @param x_offset Offset of the Address in the road pointed to by Locus (0 .. 1)
27: * @param x_direction Direction of the road pointed to by Locus
28: */

Line 34: , p_locus IN MDSYS.SDO_GEOMETRY

30: p_api_version IN NUMBER
31: , x_return_status OUT NOCOPY VARCHAR2
32: , x_msg_count OUT NOCOPY NUMBER
33: , x_msg_data OUT NOCOPY VARCHAR2
34: , p_locus IN MDSYS.SDO_GEOMETRY
35: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY
36: , x_segid OUT NOCOPY NUMBER
37: , x_offset OUT NOCOPY NUMBER
38: , x_direction OUT NOCOPY NUMBER

Line 35: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY

31: , x_return_status OUT NOCOPY VARCHAR2
32: , x_msg_count OUT NOCOPY NUMBER
33: , x_msg_data OUT NOCOPY VARCHAR2
34: , p_locus IN MDSYS.SDO_GEOMETRY
35: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY
36: , x_segid OUT NOCOPY NUMBER
37: , x_offset OUT NOCOPY NUMBER
38: , x_direction OUT NOCOPY NUMBER
39: );

Line 44: * The API returns the locus given the Geometry (SDO_GEOMETRY),

40:
41: PRAGMA RESTRICT_REFERENCES(read_locus, RNDS, WNDS, WNPS);
42:
43: /**
44: * The API returns the locus given the Geometry (SDO_GEOMETRY),
45: * Segment ID, Offset and Side of the Road.
46: *
47: * The API has a PRAGMA Restriction to avoid reading the database or
48: * modifying it.

Line 54: * @param p_geom Road Geometry (SDO_GEOMETRY)

50: * @param p_api_version API Version (1.0)
51: * @param x_return_status Return Status of the Procedure.
52: * @param x_msg_count Number of Messages in the Stack.
53: * @param x_msg_data Stack of Error Messages.
54: * @param p_geom Road Geometry (SDO_GEOMETRY)
55: * @param p_segid Segment ID of the road
56: * @param p_offset Offset of the Address in the road (0 .. 1)
57: * @param p_direction Direction of the road
58: * @param x_locus Locus Object (SDO_GEOMETRY)

Line 58: * @param x_locus Locus Object (SDO_GEOMETRY)

54: * @param p_geom Road Geometry (SDO_GEOMETRY)
55: * @param p_segid Segment ID of the road
56: * @param p_offset Offset of the Address in the road (0 .. 1)
57: * @param p_direction Direction of the road
58: * @param x_locus Locus Object (SDO_GEOMETRY)
59: */
60: PROCEDURE write_locus(
61: p_api_version IN NUMBER
62: , x_return_status OUT NOCOPY VARCHAR2

Line 65: , p_geom IN MDSYS.SDO_GEOMETRY

61: p_api_version IN NUMBER
62: , x_return_status OUT NOCOPY VARCHAR2
63: , x_msg_count OUT NOCOPY NUMBER
64: , x_msg_data OUT NOCOPY VARCHAR2
65: , p_geom IN MDSYS.SDO_GEOMETRY
66: , p_segid IN NUMBER
67: , p_offset IN NUMBER
68: , p_direction IN NUMBER
69: --added for LF enhancement of forced accuracy

Line 71: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY

67: , p_offset IN NUMBER
68: , p_direction IN NUMBER
69: --added for LF enhancement of forced accuracy
70: ,p_accuracyFactor IN NUMBER
71: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY
72: );
73:
74: PRAGMA RESTRICT_REFERENCES(write_locus, RNDS, WNDS, WNPS);
75:

Line 86: * @param p_locus Locus to be verified (SDO_GEOMETRY)

82: * @param p_api_version API Version (1.0)
83: * @param x_return_status Return Status of the Procedure.
84: * @param x_msg_count Number of Messages in the Stack.
85: * @param x_msg_data Stack of Error Messages.
86: * @param p_locus Locus to be verified (SDO_GEOMETRY)
87: * @param x_result Status indicating validity of Locus.
88: */
89: PROCEDURE verify_locus(
90: p_api_version IN NUMBER

Line 94: , p_locus IN MDSYS.SDO_GEOMETRY

90: p_api_version IN NUMBER
91: , x_return_status OUT NOCOPY VARCHAR2
92: , x_msg_count OUT NOCOPY NUMBER
93: , x_msg_data OUT NOCOPY VARCHAR2
94: , p_locus IN MDSYS.SDO_GEOMETRY
95: , x_result OUT NOCOPY VARCHAR2
96: );
97:
98: PRAGMA RESTRICT_REFERENCES(verify_locus, RNDS, WNDS, RNDS, WNPS);

Line 108: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

104: * @param p_api_version API Version (1.0)
105: * @param x_return_status Return Status of the Procedure.
106: * @param x_msg_count Number of Messages in the Stack.
107: * @param x_msg_data Stack of Error Messages.
108: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
109: */
110: FUNCTION get_locus_segmentid(
111: p_api_version IN NUMBER
112: , x_return_status OUT NOCOPY VARCHAR2

Line 115: , p_geom IN MDSYS.SDO_GEOMETRY

111: p_api_version IN NUMBER
112: , x_return_status OUT NOCOPY VARCHAR2
113: , x_msg_count OUT NOCOPY NUMBER
114: , x_msg_data OUT NOCOPY VARCHAR2
115: , p_geom IN MDSYS.SDO_GEOMETRY
116: )
117: RETURN NUMBER;
118:
119: /**

Line 125: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

121: * Locus / Geometry of the Road or -9999 in case of invalid Locus.
122: *
123: * This function can be used in SQL's where output variables cant be bound.
124: *
125: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
126: */
127: FUNCTION get_locus_segmentid(p_geom MDSYS.SDO_GEOMETRY)
128: RETURN NUMBER;
129:

Line 127: FUNCTION get_locus_segmentid(p_geom MDSYS.SDO_GEOMETRY)

123: * This function can be used in SQL's where output variables cant be bound.
124: *
125: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
126: */
127: FUNCTION get_locus_segmentid(p_geom MDSYS.SDO_GEOMETRY)
128: RETURN NUMBER;
129:
130: /**
131: * Utility Function to get the Offset / Spot of the Road from the given

Line 138: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

134: * @param p_api_version API Version (1.0)
135: * @param x_return_status Return Status of the Procedure.
136: * @param x_msg_count Number of Messages in the Stack.
137: * @param x_msg_data Stack of Error Messages.
138: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
139: */
140: FUNCTION get_locus_spot(
141: p_api_version IN NUMBER
142: , x_return_status OUT NOCOPY VARCHAR2

Line 145: , p_geom IN MDSYS.SDO_GEOMETRY

141: p_api_version IN NUMBER
142: , x_return_status OUT NOCOPY VARCHAR2
143: , x_msg_count OUT NOCOPY NUMBER
144: , x_msg_data OUT NOCOPY VARCHAR2
145: , p_geom IN MDSYS.SDO_GEOMETRY
146: )
147: RETURN NUMBER;
148:
149: /**

Line 155: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

151: * Locus / Geometry of the Road or -9999 in case of invalid Locus.
152: *
153: * This function can be used in SQL's where output variables cant be bound.
154: *
155: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
156: */
157: FUNCTION get_locus_spot(p_geom MDSYS.SDO_GEOMETRY)
158: RETURN NUMBER;
159:

Line 157: FUNCTION get_locus_spot(p_geom MDSYS.SDO_GEOMETRY)

153: * This function can be used in SQL's where output variables cant be bound.
154: *
155: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
156: */
157: FUNCTION get_locus_spot(p_geom MDSYS.SDO_GEOMETRY)
158: RETURN NUMBER;
159:
160: /**
161: * Utility Function to get the Side of the Road from the given

Line 168: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

164: * @param p_api_version API Version (1.0)
165: * @param x_return_status Return Status of the Procedure.
166: * @param x_msg_count Number of Messages in the Stack.
167: * @param x_msg_data Stack of Error Messages.
168: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
169: */
170: FUNCTION get_locus_side(
171: p_api_version IN NUMBER
172: , x_return_status OUT NOCOPY VARCHAR2

Line 175: , p_geom IN MDSYS.SDO_GEOMETRY

171: p_api_version IN NUMBER
172: , x_return_status OUT NOCOPY VARCHAR2
173: , x_msg_count OUT NOCOPY NUMBER
174: , x_msg_data OUT NOCOPY VARCHAR2
175: , p_geom IN MDSYS.SDO_GEOMETRY
176: )
177: RETURN NUMBER;
178:
179: /**

Line 185: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

181: * Locus / Geometry of the Road or -9999 in case of invalid Locus.
182: *
183: * This function can be used in SQL's where output variables cant be bound.
184: *
185: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
186: */
187: FUNCTION get_locus_side(p_geom MDSYS.SDO_GEOMETRY)
188: RETURN NUMBER;
189:

Line 187: FUNCTION get_locus_side(p_geom MDSYS.SDO_GEOMETRY)

183: * This function can be used in SQL's where output variables cant be bound.
184: *
185: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
186: */
187: FUNCTION get_locus_side(p_geom MDSYS.SDO_GEOMETRY)
188: RETURN NUMBER;
189:
190: /**
191: * Utility Function to get the Latitude of the Road from the given

Line 198: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

194: * @param p_api_version API Version (1.0)
195: * @param x_return_status Return Status of the Procedure.
196: * @param x_msg_count Number of Messages in the Stack.
197: * @param x_msg_data Stack of Error Messages.
198: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
199: */
200: FUNCTION get_locus_lat(
201: p_api_version IN NUMBER
202: , x_return_status OUT NOCOPY VARCHAR2

Line 205: , p_geom IN MDSYS.SDO_GEOMETRY

201: p_api_version IN NUMBER
202: , x_return_status OUT NOCOPY VARCHAR2
203: , x_msg_count OUT NOCOPY NUMBER
204: , x_msg_data OUT NOCOPY VARCHAR2
205: , p_geom IN MDSYS.SDO_GEOMETRY
206: )
207: RETURN NUMBER;
208:
209: /**

Line 215: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

211: * Locus / Geometry of the Road or -9999 in case of invalid Locus.
212: *
213: * This function can be used in SQL's where output variables cant be bound.
214: *
215: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
216: */
217: FUNCTION get_locus_lat(p_geom MDSYS.SDO_GEOMETRY)
218: RETURN NUMBER;
219:

Line 217: FUNCTION get_locus_lat(p_geom MDSYS.SDO_GEOMETRY)

213: * This function can be used in SQL's where output variables cant be bound.
214: *
215: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
216: */
217: FUNCTION get_locus_lat(p_geom MDSYS.SDO_GEOMETRY)
218: RETURN NUMBER;
219:
220: /**
221: * Utility Function to get the Longitude of the Road from the given

Line 228: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

224: * @param p_api_version API Version (1.0)
225: * @param x_return_status Return Status of the Procedure.
226: * @param x_msg_count Number of Messages in the Stack.
227: * @param x_msg_data Stack of Error Messages.
228: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
229: */
230: FUNCTION get_locus_lon(
231: p_api_version IN NUMBER
232: , x_return_status OUT NOCOPY VARCHAR2

Line 235: , p_geom IN MDSYS.SDO_GEOMETRY

231: p_api_version IN NUMBER
232: , x_return_status OUT NOCOPY VARCHAR2
233: , x_msg_count OUT NOCOPY NUMBER
234: , x_msg_data OUT NOCOPY VARCHAR2
235: , p_geom IN MDSYS.SDO_GEOMETRY
236: )
237: RETURN NUMBER;
238:
239: /**

Line 245: * @param p_geom Geometry of the Road (SDO_GEOMETRY)

241: * Locus / Geometry of the Road or -9999 in case of invalid Locus.
242: *
243: * This function can be used in SQL's where output variables cant be bound.
244: *
245: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
246: */
247: FUNCTION get_locus_lon(p_geom MDSYS.SDO_GEOMETRY)
248: RETURN NUMBER;
249:

Line 247: FUNCTION get_locus_lon(p_geom MDSYS.SDO_GEOMETRY)

243: * This function can be used in SQL's where output variables cant be bound.
244: *
245: * @param p_geom Geometry of the Road (SDO_GEOMETRY)
246: */
247: FUNCTION get_locus_lon(p_geom MDSYS.SDO_GEOMETRY)
248: RETURN NUMBER;
249:
250: /**
251: * Function name : GET_LOCUS_SRID

Line 257: Function get_locus_srid (p_geom IN MDSYS.SDO_GEOMETRY)

253: * the locus; if invalid locus returns -9999
254: * @param p_geom : input point geometry object
255: *
256: */
257: Function get_locus_srid (p_geom IN MDSYS.SDO_GEOMETRY)
258: return NUMBER;
259:
260: /**
261: * Checks whether the Geometry is proper or not and inturn indicates

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

262: * whether to call Location Finder or not.
263: *
264: * @returns FND_API.G_TRUE/G_FALSE
265: */
266: FUNCTION should_call_lf(p_geom IN MDSYS.SDO_GEOMETRY)
267: RETURN VARCHAR2;
268:
269: /** This function is called with p_item = 'SDO_POINT' and p_index = 1 (X)
270: * or p_index = 2 (Y) to determine the coordinates of a point location

Line 279: p_geometry MDSYS.SDO_GEOMETRY

275: * first two elements of the SDO_ORDINATES array.
276: */
277:
278: FUNCTION get_geometry(
279: p_geometry MDSYS.SDO_GEOMETRY
280: , p_item VARCHAR2
281: , p_index NUMBER DEFAULT NULL
282: )
283: RETURN NUMBER;

Line 399: p_geom IN MDSYS.SDO_GEOMETRY

395: * @param p_soft_validation To enable Soft Validation or not (T / N)
396: * @return @ separated geometry attributes.
397: */
398: FUNCTION get_locus_string(
399: p_geom IN MDSYS.SDO_GEOMETRY
400: , p_soft_validation IN VARCHAR2 DEFAULT NULL
401: )
402: RETURN VARCHAR2;
403:

Line 427: p_geometry IN MDSYS.SDO_GEOMETRY

423:
424: )
425: RETURN NUMBER;
426: FUNCTION is_manual_geometry (
427: p_geometry IN MDSYS.SDO_GEOMETRY
428: )
429: RETURN BOOLEAN;
430:
431: END csf_locus_pub;