PACKAGE: APPS.CSI_GIS_INSTANCE_LOC_UTL_PKG

Source

1 PACKAGE CSI_GIS_INSTANCE_LOC_UTL_PKG AUTHID CURRENT_USER AS
2 /* $Header: csigilus.pls 120.0.12010000.4 2008/12/26 10:37:59 jgootyag noship $ */
3 PROCEDURE VALIDATE_INSTANCE_NUMBER
4 (
5   p_instance_id             IN           NUMBER
6  ,p_asset_context           IN           VARCHAR2
7  ,x_instance_number         OUT  NOCOPY  VARCHAR2
8  ,x_create_update           OUT  NOCOPY  VARCHAR2
9  ,x_return_status           OUT  NOCOPY  VARCHAR2
10  ,x_msg_count		        OUT  NOCOPY  NUMBER
11  ,x_msg_data	            OUT  NOCOPY  VARCHAR2
12  );
13 
14 PROCEDURE CONVERT_DMS_OR_DM_TO_DD
15 (
16   p_value            IN           VARCHAR2
17  ,p_mode             IN           VARCHAR2
18  ,p_geocode_format   IN           VARCHAR2
19  ,p_instance_number  IN           VARCHAR2
20  ,x_value          OUT  NOCOPY  NUMBER
21  ,x_return_status  OUT  NOCOPY  VARCHAR2
22  ,x_msg_count	   OUT  NOCOPY  NUMBER
23  ,x_msg_data	   OUT  NOCOPY  VARCHAR2
24  );
25 
26 PROCEDURE Calculate_DD
27 (
28   p_value          IN           VARCHAR2
29  ,p_geocode_format IN           VARCHAR2
30  ,p_mode           IN           VARCHAR2
31  ,p_instance_number  IN           VARCHAR2
32  ,x_value          OUT  NOCOPY  NUMBER
33  ,x_return_status  OUT  NOCOPY  VARCHAR2
34  ,x_msg_count	   OUT  NOCOPY  NUMBER
35  ,x_msg_data	   OUT  NOCOPY  VARCHAR2
36 ) ;
37 
38 PROCEDURE VALIDATE_LATITUDE_LONGITUDE
39 (
40   p_latitude        IN           VARCHAR2
41  ,p_longitude       IN           VARCHAR2
42  ,p_geocode_format  IN           VARCHAR2
43  ,p_instance_number  IN           VARCHAR2
44  ,x_return_status   OUT  NOCOPY  VARCHAR2
45  ,x_msg_count	    OUT  NOCOPY  NUMBER
46  ,x_msg_data	    OUT  NOCOPY  VARCHAR2
47  );
48 
49 FUNCTION GET_DEGREES_FROM_DD
50 ( p_value IN NUMBER)
51 RETURN VARCHAR2 ;
52 
53 FUNCTION GET_MINUTES_FROM_DD
54 ( p_value IN NUMBER)
55 RETURN VARCHAR2;
56 
57 FUNCTION GET_SECONDS_FROM_DD
58 ( p_value IN NUMBER)
59 RETURN VARCHAR2;
60 
61 FUNCTION GET_DIRECTION_FROM_DD
62 (p_mode  IN VARCHAR2
63 ,p_value IN NUMBER)
64 RETURN VARCHAR2;
65 
66 END CSI_GIS_INSTANCE_LOC_UTL_PKG;