1 PACKAGE hz_geocode_pkg AUTHID CURRENT_USER AS
2 /*$Header: ARHGEOCS.pls 115.8 2002/12/20 22:59:32 rrangan noship $*/
3
4 g_max_rows NUMBER := 20;
5
6 TYPE loc_array IS VARRAY(20) OF hz_location_v2pub.location_rec_type;
7 TYPE array_t IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
8
9 --------------------------------------------
10 -- declaration of global variables and types
11 --------------------------------------------
12 g_pkg_name CONSTANT VARCHAR2(30) := 'HZ_GEOCODE_PKG';
13 g_debug_count NUMBER := 0;
14 g_debug BOOLEAN := FALSE;
15 g_good CONSTANT VARCHAR2(30) := 'GOOD';
16 g_dirty CONSTANT VARCHAR2(30) := 'DIRTY';
17 g_error CONSTANT VARCHAR2(30) := 'ERROR';
18 g_multimatch CONSTANT VARCHAR2(30) := 'MULTIMATCH';
19 g_noexactmatch CONSTANT VARCHAR2(30) := 'NOEXACTMATCH';
20 g_processing CONSTANT VARCHAR2(30) := 'PROCESSING';
21
22 -------------------------------------------------------
23 -- RETURN Y if nls_numeric_character = '.,' US standard
24 -- N otherwise
25 -------------------------------------------------------
26 FUNCTION is_nls_num_char_pt_com RETURN VARCHAR2;
27
28 --
29 -- PUBLIC FUNCTION
30 -- remove_whitespace
31 --
32 -- DESCRIPTION
33 -- Remove whitespace from a string
34 --
35 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
36 --
37 -- MODIFICATION HISTORY
38 --
39 -- 02-28-2002 Joe del Callar Created.
40 --
41 FUNCTION remove_whitespace (p_str IN VARCHAR2) RETURN VARCHAR2;
42
43 --
44 -- PUBLIC FUNCTION
45 -- in_bypass_list
46 --
47 -- DESCRIPTION
48 -- Returns 'Y' if the argument p_url_target is in p_exclusion_list, 'N'
49 -- otherwise. Used to determine whether or not to use a proxy. This
50 -- functionality can only be used with fixed-length character set
51 -- exclusion lists and targets, which is okay since these are URLs.
52 --
53 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
54 --
55 -- ARGUMENTS
56 -- IN:
57 -- p_target_url
58 -- p_exclusion_list
59 --
60 -- NOTES
61 --
62 -- MODIFICATION HISTORY
63 --
64 -- 03-27-2002 J. del Callar Created.
65 --
66 FUNCTION in_bypass_list (
67 p_url_target IN VARCHAR2,
68 p_exclusion_list IN VARCHAR2
69 ) RETURN BOOLEAN;
70
71 --
72 -- PUBLIC PROCEDURE
73 -- get_spatial_coords
74 --
75 -- DESCRIPTION
76 -- Build the xml request for n locations
77 -- Post the Xml request
78 -- Split the Response into individual responses
79 -- Parse and update hz_locations with the responses
80 -- If error Then x_return_status = E
81 --
82 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
83 --
84 -- ARGUMENTS
85 -- IN:
86 -- p_name
87 -- p_http_ad
88 -- p_proxy
89 -- p_port
90 -- p_retry
91 -- p_init_msg_list
92 -- IN/OUT:
93 -- p_loc_array
94 -- OUT:
95 -- x_return_status Return status after the call. The status can
96 -- be FND_API.G_RET_STS_SUCCESS (success),
97 -- FND_API.G_RET_STS_ERROR (error),
98 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
99 -- x_msg_count Number of messages in message stack.
100 -- x_msg_data Message text if x_msg_count is 1.
101 --
102 -- NOTES
103 --
104 -- MODIFICATION HISTORY
105 --
106 -- 01-09-2002 Herve Yu Created.
107 -- 01-28-2002 Joe del Callar Modified to return the geometry in the
108 -- loc_array structure in order to facilitate
109 -- integration with HR.
110 --
111
112 PROCEDURE get_spatial_coords (
113 p_loc_array IN OUT NOCOPY loc_array,
114 p_name IN VARCHAR2 DEFAULT NULL,
115 p_http_ad IN VARCHAR2,
116 p_proxy IN VARCHAR2 DEFAULT NULL,
117 p_port IN NUMBER DEFAULT NULL,
118 p_retry IN NUMBER DEFAULT 3,
119 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125 END hz_geocode_pkg;