1 PACKAGE CSF_LF_GEOPVT AUTHID CURRENT_USER AS
2 /* $Header: CSFVGEOS.pls 120.7 2011/02/10 07:38:44 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_ResolveGEOAddress (
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
50 PROCEDURE CSF_LF_ResolveAddress
51 ( p_api_version IN NUMBER
52 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
53 , x_return_status OUT NOCOPY VARCHAR2
54 , x_msg_count OUT NOCOPY NUMBER
55 , x_msg_data OUT NOCOPY VARCHAR2
56 , p_country IN VARCHAR2
57 , p_state IN VARCHAR2 default NULL
58 , p_county IN VARCHAR2 DEFAULT NULL
59 , p_province IN VARCHAR2 DEFAULT NULL
60 , p_city IN VARCHAR2
61 , p_postalCode IN VARCHAR2 default NULL
62 , p_roadname IN VARCHAR2
63 , p_buildingnum IN VARCHAR2 default NULL
64 , p_alternate IN VARCHAR2 default NULL
65 , p_accu_fac OUT NOCOPY NUMBER
66 , p_segment_id OUT NOCOPY NUMBER
67 , p_offset OUT NOCOPY NUMBER
68 , p_side OUT NOCOPY NUMBER
69 , p_lon OUT NOCOPY NUMBER
70 , p_lat OUT NOCOPY NUMBER
71 , p_srid OUT NOCOPY NUMBER
72 );
73
74
75 PROCEDURE delete_valid_geo_batch_address;
76
77 PROCEDURE move_invalid_to_geo_batch(
78 p_task_rec csf_task_address_pvt.task_rec_type
79 );
80
81 PROCEDURE resolve_address(
82 p_api_version IN NUMBER
83 , x_return_status OUT NOCOPY VARCHAR2
84 , x_msg_count OUT NOCOPY NUMBER
85 , x_msg_data OUT NOCOPY VARCHAR2
86 , p_location_id IN NUMBER
87 , p_address1 IN VARCHAR2
88 , p_address2 IN VARCHAR2
89 , p_address3 IN VARCHAR2
90 , p_address4 IN VARCHAR2
91 , p_city IN VARCHAR2
92 , p_postalcode IN VARCHAR2
93 , p_county IN VARCHAR2
94 , p_state IN VARCHAR2
95 , p_province IN VARCHAR2
96 , p_country IN VARCHAR2
97 , p_accu_fac OUT NOCOPY NUMBER
98 , p_segment_id OUT NOCOPY NUMBER
99 , p_offset OUT NOCOPY NUMBER
100 , p_side OUT NOCOPY NUMBER
101 , p_lon OUT NOCOPY NUMBER
102 , p_lat OUT NOCOPY NUMBER
103 );
104
105 END CSF_LF_GEOPVT;