1 PACKAGE CSF_SPATIAL_GEO_TOOLS AUTHID CURRENT_USER AS
2 /* $Header: CSFPGEOWS.pls 120.2 2011/02/24 08:51:23 sseshaiy noship $*/
3
4 CSF_LF_LATITUDE_NOT_SET_ERROR EXCEPTION;
5 CSF_LF_LONGITUDE_NOT_SET_ERROR EXCEPTION;
6 CSF_LF_VERSION_ERROR EXCEPTION;
7
8 /**
9 * This API is for reverse geo coding. It converts the inputs passed as
10 * latitude and longitude to its corresponding address.
11 *
12 * @param p_api_version API Version (1.0)
13 * @param p_init_msg_list Initialize Message List
14 * @param p_latitude Latitude
15 * @param p_longitude Longitude
16 * @param p_dataset p_dataset
17 * @param p_country Country of the address
18 * @param p_state State of the address
19 * @param p_county County of the address
20 * @param p_city City of the address
21 * @param p_roadname Street of the address
22 * @param p_postalcode Postal code of the address
23 * @param p_bnum Building Number of the address
24 * @param p_dist Distance from given lat and lng
25 * @param p_accuracy_lvl Accuracy level of address
26 * @param x_msg_count Number of Messages in the Stack.
27 * @param x_msg_data Stack of Error Messages.
28 * @param x_return_status Return Status of the Procedure.
29 */
30 PROCEDURE CSF_LF_ReverseGeoCoding
31 ( p_api_version IN NUMBER
32 , p_init_msg_list IN VARCHAR2 default fnd_api.g_false
33 , p_latitude IN NUMBER
34 , p_longitude IN NUMBER
35 , p_dataset IN VARCHAR2
36 , p_country OUT NOCOPY VARCHAR2
37 , p_state OUT NOCOPY VARCHAR2
38 , p_county OUT NOCOPY VARCHAR2
39 , p_city OUT NOCOPY VARCHAR2
40 , p_roadname OUT NOCOPY VARCHAR2
41 , p_postalcode OUT NOCOPY VARCHAR2
42 , p_bnum OUT NOCOPY VARCHAR2
43 , p_dist OUT NOCOPY VARCHAR2
44 , p_accuracy_lvl OUT NOCOPY VARCHAR2
45 , x_msg_count OUT NOCOPY NUMBER
46 , x_msg_data OUT NOCOPY VARCHAR2
47 , x_return_status OUT NOCOPY VARCHAR2
48 );
49 END CSF_SPATIAL_GEO_TOOLS ;