APPS.CSF_LOCUS_PUB dependencies on CSF_LOCUS_PUB

Line 1: PACKAGE BODY csf_locus_pub AS

1: PACKAGE BODY csf_locus_pub AS
2: /* $Header: CSFPLCSB.pls 120.22.12020000.2 2012/07/23 05:10:33 srguntur ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_LOCUS_PUB';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_LOCUS_PUB';

1: PACKAGE BODY csf_locus_pub AS
2: /* $Header: CSFPLCSB.pls 120.22.12020000.2 2012/07/23 05:10:33 srguntur ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_LOCUS_PUB';
5:
6: -- message count must always equal ZERO or ONE.
7: -- cannot use messgage list because of pragma
8:

Line 487: -- valid locus (see package CSF_LOCUS_PUB). For performance reasons this

483: -- This function is called with p_item = 'SDO_POINT' and p_index = 1 (X)
484: -- or p_index = 2 (Y) to determine the coordinates of a point location
485: -- such as a customer, resource or task.
486: -- If the SDO_POINT item is null it is assumed that the geometry is a
487: -- valid locus (see package CSF_LOCUS_PUB). For performance reasons this
488: -- will not be checked. The X and Y values can then be obtained from the
489: -- first two elements of the SDO_ORDINATES array.
490: BEGIN
491: IF p_geometry IS NULL

Line 1059: l_segment_id NUMBER := csf_locus_pub.get_locus_segmentid(p_geometry);

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);
1062: BEGIN
1063: IF p_geometry IS NOT NULL THEN

Line 1060: l_locus_lat NUMBER := csf_locus_pub.get_locus_lat(p_geometry);

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);
1062: BEGIN
1063: IF p_geometry IS NOT NULL THEN
1064: IF l_segment_id = 1 AND l_locus_lat <> -9999 AND l_locus_lon <> -9999

Line 1061: l_locus_lon NUMBER := csf_locus_pub.get_locus_lon(p_geometry);

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);
1062: BEGIN
1063: IF p_geometry IS NOT NULL THEN
1064: IF l_segment_id = 1 AND l_locus_lat <> -9999 AND l_locus_lon <> -9999
1065: THEN

Line 1072: END csf_locus_pub;

1068: END IF;
1069: RETURN FALSE;
1070: END is_manual_geometry;
1071:
1072: END csf_locus_pub;