[Home] [Help]
PACKAGE: APPS.CSF_LF_PUB
Source
1 PACKAGE CSF_LF_PUB AS
2 /*$Header: CSFPLFS.pls 120.4.12010000.6 2008/09/23 10:05:06 rajukum ship $*/
3
4 CITY_NOT_RESOLVED CONSTANT NUMBER := 223601;
5 COUNTRY_NOT_RESOLVED CONSTANT NUMBER := 223602;
6 STATE_NOT_FOUND CONSTANT NUMBER := 223603;
7 MISSING_CITY_NAME CONSTANT NUMBER := 223604;
8 RESOLVING_CITY_BEFORE_COUNTRY CONSTANT NUMBER := 223605;
9 CITY_NOT_FOUND CONSTANT NUMBER := 223606;
10 POSTAL_CODE_NOT_RESOLVED_YET CONSTANT NUMBER := 233607;
11 MISSING_COUNTRY_NAME CONSTANT NUMBER := 223608;
12 COUNTRY_NAME_AMBIGUITY CONSTANT NUMBER := 223609;
13 COUNTRY_NAME_NOT_FOUND CONSTANT NUMBER := 223610;
14 ROAD_AND_POI_MISSING CONSTANT NUMBER := 223611;
15 MISSING_POSTAL_CODE CONSTANT NUMBER := 223612;
16 RESOLVING_POST_BEFORE_COUNTRY CONSTANT NUMBER := 223613;
17 POSTAL_CODE_AMBIGUITY CONSTANT NUMBER := 223614;
18 POSTAL_CODE_NOT_FOUND CONSTANT NUMBER := 223615;
19 MISSING_ROAD_NAME CONSTANT NUMBER := 223616;
20 RESOLVING_ROAD_BEFORE_CITY CONSTANT NUMBER := 223617;
21 MISSING_STATE_NAME CONSTANT NUMBER := 223618;
22 STATE_NAME_NOT_FOUND CONSTANT NUMBER := 223619;
23 MISSING_COMPONENT_NAME CONSTANT NUMBER := 223620;
24 STATE_NAME_AMBIGUITY CONSTANT NUMBER := 223621;
25 CITY_AND_POSTAL_MISSING CONSTANT NUMBER := 223622;
26 CITY_AND_POSTAL_NOT_RESOLVED CONSTANT NUMBER := 223623;
27 NO_LOCUS_ROAD_NOT_RESOLVED CONSTANT NUMBER := 223624;
28 CANNOT_COMPUTE_ROAD_CENTROID CONSTANT NUMBER := 223625;
29 CANNOT_COMPUTE_CITY_CENTROID CONSTANT NUMBER := 223626;
30 CANNOT_COMPUTE_POSTAL_CENTROID CONSTANT NUMBER := 223627;
31 /*Added for lf enhancement of forced accuracy*/
32 REQUIRED_ACCURACY_EXCEPTION CONSTANT NUMBER := 223629;
33
34 CSF_LF_LOCUS_NOT_SET_ERROR EXCEPTION;
35 CSF_LF_POINT_NOT_SET_ERROR EXCEPTION;
36 CSF_LF_VERSION_ERROR EXCEPTION;
37 CSF_LF_COUNTRY_NOT_SET_ERROR EXCEPTION;
38 CSF_LF_STATE_NOT_SET_ERROR EXCEPTION; /*only for USA database */
39 CSF_LF_CITY_NOT_SET_ERROR EXCEPTION;
40 CSF_LF_ROAD_NOT_SET_ERROR EXCEPTION;
41 /*Added for lf enhancement of forced accuracy*/
42 CSF_LF_REQ_ACCURACY_NOT_GOT EXCEPTION;
43
44 TYPE csf_lf_address IS RECORD (
45 country VARCHAR2 (60),
46 state VARCHAR2 (60),
47 county VARCHAR2 (60),
48 province VARCHAR2 (60),
49 city VARCHAR2 (60),
50 postalcode VARCHAR2 (60),
51 road VARCHAR2 (240),
52 buildingnum VARCHAR2 (50),
53 alternate VARCHAR2 (50),
54 poi VARCHAR2 (50)
55 );
56
57 TYPE csf_lf_result IS RECORD (
58 record_type NUMBER,
59 locus MDSYS.SDO_GEOMETRY,
60 segment_id NUMBER,
61 segment_side NUMBER (1, 0),
62 percentage NUMBER (15, 0),
63 accuracy_factor NUMBER,
64 country VARCHAR2 (60),
65 state VARCHAR2 (60),
66 county VARCHAR2 (60),
67 province VARCHAR2 (60),
68 city VARCHAR2 (60),
69 postalcode VARCHAR2 (60),
70 road VARCHAR2 (240),
71 buildingnum VARCHAR2 (50),
72 alternate VARCHAR2 (50),
73 poi VARCHAR2 (50)
74 );
75
76 TYPE CSF_LF_RESULTARRAY IS TABLE OF CSF_LF_RESULT;
77
78 PROCEDURE CSF_LF_ResolveAddress
79 ( p_api_version IN NUMBER
80 , p_init_msg_list IN VARCHAR2 default fnd_api.g_false
81 , x_return_status OUT NOCOPY VARCHAR2
82 , x_msg_count OUT NOCOPY NUMBER
83 , x_msg_data OUT NOCOPY VARCHAR2
84 , p_country IN VARCHAR2
85 , p_state IN VARCHAR2 default NULL
86 , p_county IN VARCHAR2 DEFAULT NULL
87 , p_province IN VARCHAR2 DEFAULT NULL
88 , p_city IN VARCHAR2
89 , p_postalCode IN VARCHAR2 default NULL
90 , p_roadname IN VARCHAR2
91 , p_buildingnum IN VARCHAR2 default NULL
92 , p_alternate IN VARCHAR2 default NULL
93 , x_resultsArray OUT NOCOPY CSF_LF_RESULTARRAY
94 );
95
96 PROCEDURE CSF_LocustoGeometry
97 ( p_api_version IN NUMBER
98 , p_init_msg_list IN VARCHAR2 default fnd_api.g_false
99 , x_return_status OUT NOCOPY VARCHAR2
100 , x_msg_count OUT NOCOPY NUMBER
101 , x_msg_data OUT NOCOPY VARCHAR2
102 , p_locus IN MDSYS.SDO_GEOMETRY
103 , x_point OUT NOCOPY MDSYS.SDO_GEOMETRY
104 );
105
106 PROCEDURE CSF_GeometrytoLocus
107 ( p_api_version IN NUMBER
108 , p_init_msg_list IN VARCHAR2 default fnd_api.g_false
109 , x_return_status OUT NOCOPY VARCHAR2
110 , x_msg_count OUT NOCOPY NUMBER
111 , x_msg_data OUT NOCOPY VARCHAR2
112 , p_point IN MDSYS.SDO_GEOMETRY
113 , x_locus OUT NOCOPY MDSYS.SDO_GEOMETRY
114 );
115
116 PROCEDURE CSF_LocustoTimeZone
117 ( p_api_version IN NUMBER
118 , p_init_msg_list IN VARCHAR2 default fnd_api.g_false
119 , x_return_status OUT NOCOPY VARCHAR2
120 , x_msg_count OUT NOCOPY NUMBER
121 , x_msg_data OUT NOCOPY VARCHAR2
122 , p_locus IN MDSYS.SDO_GEOMETRY
123 , x_timezone OUT NOCOPY NUMBER
124 );
125
126 END CSF_LF_PUB;