[Home] [Help]
PACKAGE: APPS.IRC_LOCATION_UTILITY
Source
1 package IRC_LOCATION_UTILITY AUTHID CURRENT_USER as
2 /* $Header: irlocutl.pkh 120.0.12010000.1 2008/07/28 12:48:04 appldev ship $ */
3 type t_address_line is table of varchar2(250) index by binary_integer;
4 type t_address_id is table of number index by binary_integer;
5 --
6 -- -------------------------------------------------------------------------
7 -- |---------------------------< address2geometry >------------------------|
8 -- -------------------------------------------------------------------------
9 --
10 FUNCTION address2geometry
11 (name varchar2 default null
12 ,street varchar2 default null
13 ,city varchar2 default null
14 ,state varchar2 default null
15 ,zip_code varchar2 default null)
16 RETURN MDSYS.SDO_GEOMETRY;
17 -- -------------------------------------------------------------------------
18 -- |---------------------------< address2geometry >------------------------|
19 -- -------------------------------------------------------------------------
20 --
21 function address2geometry
22 (name varchar2 default null
23 ,street varchar2 default null
24 ,intersecting_street varchar2 default null
25 ,builtup_area varchar2 default null
26 ,order8_area varchar2 default null
27 ,order2_area varchar2 default null
28 ,order1_area varchar2 default null
29 ,country varchar2 default null
30 ,postal_code varchar2 default null
31 ,postal_addon_code varchar2 default null)
32 return MDSYS.SDO_GEOMETRY;
33 -- -------------------------------------------------------------------------
34 -- |---------------------------< address2geometry >------------------------|
35 -- -------------------------------------------------------------------------
36 --
37 function address2geometry
38 (address_line1 varchar2
39 ,address_line2 varchar2 default null
40 ,address_line3 varchar2 default null
41 ,address_line4 varchar2 default null
42 ,address_line5 varchar2 default null
43 ,address_line6 varchar2 default null
44 ,address_line7 varchar2 default null
45 ,address_line8 varchar2 default null
46 ,address_line9 varchar2 default null
47 ,country varchar2 default null)
48 return MDSYS.SDO_GEOMETRY;
49 -- -------------------------------------------------------------------------
50 -- |-------------------------< bulk_address2geometry >---------------------|
51 -- -------------------------------------------------------------------------
52 --
53 procedure bulk_address2geometry
54 (address_id in t_address_id
55 ,address_line1 in t_address_line
56 ,address_line2 in t_address_line
57 ,address_line3 in t_address_line
58 ,address_line4 in t_address_line
59 ,address_line5 in t_address_line
60 ,address_line6 in t_address_line
61 ,address_line7 in t_address_line
62 ,address_line8 in t_address_line
63 ,address_line9 in t_address_line
64 ,country in t_address_line
65 ,latitude out nocopy t_address_id
66 ,longitude out nocopy t_address_id
67 ,success out nocopy number
68 ,failure out nocopy number
69 );
70 -- -------------------------------------------------------------------------
71 -- |---------------------------< address2full >------------------------|
72 -- -------------------------------------------------------------------------
73 --
74 procedure address2full
75 (address_line1 in varchar2
76 ,address_line2 in varchar2 default null
77 ,address_line3 in varchar2 default null
78 ,address_line4 in varchar2 default null
79 ,address_line5 in varchar2 default null
80 ,address_line6 in varchar2 default null
81 ,address_line7 in varchar2 default null
82 ,address_line8 in varchar2 default null
83 ,address_line9 in varchar2 default null
84 ,country in varchar2 default null
85 ,name out nocopy varchar2
86 ,house_number out nocopy varchar2
87 ,street out nocopy varchar2
88 ,builtup_area out nocopy varchar2
89 ,order1_area out nocopy varchar2
90 ,order2_area out nocopy varchar2
91 ,order8_area out nocopy varchar2
92 ,country_name out nocopy varchar2
93 ,postal_code out nocopy varchar2
94 ,geometry out nocopy MDSYS.SDO_GEOMETRY
95 );
96 -- -------------------------------------------------------------------------
97 -- |---------------------------< sdo_distance >----------------------------|
98 -- -------------------------------------------------------------------------
99 -- wrapper for sdo_geom.sdo_distance function
100 --
101 function sdo_distance
102 (geom1 in MDSYS.SDO_GEOMETRY
103 ,geom2 in MDSYS.SDO_GEOMETRY
104 ,tolerance in number) return number;
105 -- -------------------------------------------------------------------------
106 -- |---------------------------< sdo_miles >----------------------------|
107 -- -------------------------------------------------------------------------
108 -- wrapper for sdo_geom.sdo_distance function, returning miles
109 --
110 function sdo_miles
111 (geom1 in MDSYS.SDO_GEOMETRY
112 ,geom2 in MDSYS.SDO_GEOMETRY
113 ,tolerance in number) return number;
114 end irc_location_utility;