APPS.CSFW_SPATIAL_PUB dependencies on SDO_GEOMETRY

Line 5: FUNCTION GET_AERIAL_DISTANCE( p_start_point MDSYS.SDO_GEOMETRY,

1: PACKAGE BODY CSFW_SPATIAL_PUB as
2: /*$Header: csfwsplb.pls 120.0 2005/05/24 17:43:49 appldev noship $*/
3:
4: /*
5: FUNCTION GET_AERIAL_DISTANCE( p_start_point MDSYS.SDO_GEOMETRY,
6: p_end_point MDSYS.SDO_GEOMETRY,
7: p_unit_of_measure varchar2 )
8: This function would find oput the distance between 2 points(MSDSYS.SDO_GEOMETRY)
9: In 8i, the distance computation assumes the coordinate system is NULL. So we would

Line 6: p_end_point MDSYS.SDO_GEOMETRY,

2: /*$Header: csfwsplb.pls 120.0 2005/05/24 17:43:49 appldev noship $*/
3:
4: /*
5: FUNCTION GET_AERIAL_DISTANCE( p_start_point MDSYS.SDO_GEOMETRY,
6: p_end_point MDSYS.SDO_GEOMETRY,
7: p_unit_of_measure varchar2 )
8: This function would find oput the distance between 2 points(MSDSYS.SDO_GEOMETRY)
9: In 8i, the distance computation assumes the coordinate system is NULL. So we would
10: convert the geometries to a projected coordinate system(Cartesian) and then do distance computation.

Line 8: This function would find oput the distance between 2 points(MSDSYS.SDO_GEOMETRY)

4: /*
5: FUNCTION GET_AERIAL_DISTANCE( p_start_point MDSYS.SDO_GEOMETRY,
6: p_end_point MDSYS.SDO_GEOMETRY,
7: p_unit_of_measure varchar2 )
8: This function would find oput the distance between 2 points(MSDSYS.SDO_GEOMETRY)
9: In 8i, the distance computation assumes the coordinate system is NULL. So we would
10: convert the geometries to a projected coordinate system(Cartesian) and then do distance computation.
11: in that case this function would find out the longitude and latituide of the to and from points
12: and then calls

Line 21: FUNCTION GET_AERIAL_DISTANCE(p_start_point MDSYS.SDO_GEOMETRY,

17: p_unit_of_measure varchar2 )
18:
19: */
20:
21: FUNCTION GET_AERIAL_DISTANCE(p_start_point MDSYS.SDO_GEOMETRY,
22: p_end_point MDSYS.SDO_GEOMETRY,
23: p_unit_of_measure varchar2 )
24: RETURN number IS
25: x_distance NUMBER;

Line 22: p_end_point MDSYS.SDO_GEOMETRY,

18:
19: */
20:
21: FUNCTION GET_AERIAL_DISTANCE(p_start_point MDSYS.SDO_GEOMETRY,
22: p_end_point MDSYS.SDO_GEOMETRY,
23: p_unit_of_measure varchar2 )
24: RETURN number IS
25: x_distance NUMBER;
26: l_start_logitude number;

Line 116: FUNCTION CHECK_GEOMETRY_POINT( p_point MDSYS.SDO_GEOMETRY)

112: END GET_AERIAL_DISTANCE;
113:
114:
115:
116: FUNCTION CHECK_GEOMETRY_POINT( p_point MDSYS.SDO_GEOMETRY)
117: RETURN VARCHAR is
118:
119: l_longitude NUMBER;
120: l_latitude NUMBER;