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

4: g_ret_locus_invalid_locus CONSTANT NUMBER := -1;
5: g_ret_locus_invalid_geometry CONSTANT NUMBER := -2;
6:
7: /**
8: * The API reads the locus and returns the Geometry (SDO_GEOMETRY),
9: * Segment ID, Offset and Side of the Road.
10: *
11: * The API has a PRAGMA Restriction to avoid reading the database or
12: * modifying it.

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

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

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

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

Line 29: , p_locus IN MDSYS.SDO_GEOMETRY

25: p_api_version IN NUMBER
26: , x_return_status OUT NOCOPY VARCHAR2
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , p_locus IN MDSYS.SDO_GEOMETRY
30: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY
31: , x_segid OUT NOCOPY NUMBER
32: , x_offset OUT NOCOPY NUMBER
33: , x_direction OUT NOCOPY NUMBER

Line 30: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY

26: , x_return_status OUT NOCOPY VARCHAR2
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , p_locus IN MDSYS.SDO_GEOMETRY
30: , x_geom OUT NOCOPY MDSYS.SDO_GEOMETRY
31: , x_segid OUT NOCOPY NUMBER
32: , x_offset OUT NOCOPY NUMBER
33: , x_direction OUT NOCOPY NUMBER
34: );

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

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

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

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

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

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

Line 60: , p_geom IN MDSYS.SDO_GEOMETRY

56: p_api_version IN NUMBER
57: , x_return_status OUT NOCOPY VARCHAR2
58: , x_msg_count OUT NOCOPY NUMBER
59: , x_msg_data OUT NOCOPY VARCHAR2
60: , p_geom IN MDSYS.SDO_GEOMETRY
61: , p_segid IN NUMBER
62: , p_offset IN NUMBER
63: , p_direction IN NUMBER
64: --added for LF enhancement of forced accuracy

Line 66: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY

62: , p_offset IN NUMBER
63: , p_direction IN NUMBER
64: --added for LF enhancement of forced accuracy
65: ,p_accuracyFactor IN NUMBER
66: , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY
67: );
68:
69: PRAGMA RESTRICT_REFERENCES(write_locus, RNDS, WNDS, WNPS);
70:

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

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

Line 89: , p_locus IN MDSYS.SDO_GEOMETRY

85: p_api_version IN NUMBER
86: , x_return_status OUT NOCOPY VARCHAR2
87: , x_msg_count OUT NOCOPY NUMBER
88: , x_msg_data OUT NOCOPY VARCHAR2
89: , p_locus IN MDSYS.SDO_GEOMETRY
90: , x_result OUT NOCOPY VARCHAR2
91: );
92:
93: PRAGMA RESTRICT_REFERENCES(verify_locus, RNDS, WNDS, RNDS, WNPS);

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

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

Line 110: , p_geom IN MDSYS.SDO_GEOMETRY

106: p_api_version IN NUMBER
107: , x_return_status OUT NOCOPY VARCHAR2
108: , x_msg_count OUT NOCOPY NUMBER
109: , x_msg_data OUT NOCOPY VARCHAR2
110: , p_geom IN MDSYS.SDO_GEOMETRY
111: )
112: RETURN NUMBER;
113:
114: /**

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

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

Line 122: FUNCTION get_locus_segmentid(p_geom MDSYS.SDO_GEOMETRY)

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

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

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

Line 140: , p_geom IN MDSYS.SDO_GEOMETRY

136: p_api_version IN NUMBER
137: , x_return_status OUT NOCOPY VARCHAR2
138: , x_msg_count OUT NOCOPY NUMBER
139: , x_msg_data OUT NOCOPY VARCHAR2
140: , p_geom IN MDSYS.SDO_GEOMETRY
141: )
142: RETURN NUMBER;
143:
144: /**

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

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

Line 152: FUNCTION get_locus_spot(p_geom MDSYS.SDO_GEOMETRY)

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

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

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

Line 170: , p_geom IN MDSYS.SDO_GEOMETRY

166: p_api_version IN NUMBER
167: , x_return_status OUT NOCOPY VARCHAR2
168: , x_msg_count OUT NOCOPY NUMBER
169: , x_msg_data OUT NOCOPY VARCHAR2
170: , p_geom IN MDSYS.SDO_GEOMETRY
171: )
172: RETURN NUMBER;
173:
174: /**

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

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

Line 182: FUNCTION get_locus_side(p_geom MDSYS.SDO_GEOMETRY)

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

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

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

Line 200: , p_geom IN MDSYS.SDO_GEOMETRY

196: p_api_version IN NUMBER
197: , x_return_status OUT NOCOPY VARCHAR2
198: , x_msg_count OUT NOCOPY NUMBER
199: , x_msg_data OUT NOCOPY VARCHAR2
200: , p_geom IN MDSYS.SDO_GEOMETRY
201: )
202: RETURN NUMBER;
203:
204: /**

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

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

Line 212: FUNCTION get_locus_lat(p_geom MDSYS.SDO_GEOMETRY)

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

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

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

Line 230: , p_geom IN MDSYS.SDO_GEOMETRY

226: p_api_version IN NUMBER
227: , x_return_status OUT NOCOPY VARCHAR2
228: , x_msg_count OUT NOCOPY NUMBER
229: , x_msg_data OUT NOCOPY VARCHAR2
230: , p_geom IN MDSYS.SDO_GEOMETRY
231: )
232: RETURN NUMBER;
233:
234: /**

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

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

Line 242: FUNCTION get_locus_lon(p_geom MDSYS.SDO_GEOMETRY)

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

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

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

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

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

Line 274: p_geometry MDSYS.SDO_GEOMETRY

270: * first two elements of the SDO_ORDINATES array.
271: */
272:
273: FUNCTION get_geometry(
274: p_geometry MDSYS.SDO_GEOMETRY
275: , p_item VARCHAR2
276: , p_index NUMBER DEFAULT NULL
277: )
278: RETURN NUMBER;

Line 384: p_geom IN MDSYS.SDO_GEOMETRY

380: * @param p_soft_validation To enable Soft Validation or not (T / N)
381: * @return @ separated geometry attributes.
382: */
383: FUNCTION get_locus_string(
384: p_geom IN MDSYS.SDO_GEOMETRY
385: , p_soft_validation IN VARCHAR2 DEFAULT NULL
386: )
387: RETURN VARCHAR2;
388: