1 PACKAGE HZ_GNR_MAP10000 AS
2
3 /*=======================================================================+
4 | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | NAME HZ_GNR_MAP10000
8 |
9 | DESCRIPTION
10 | This package body is generated by TCA for geoName referencing.
11 |
12 | HISTORY
13 | 11/06/2008 03:21:22 Generated.
14 |
15 *=======================================================================*/
16
17 FUNCTION get_usage_API(
18 P_USAGE_CODE VARCHAR2) RETURN VARCHAR2;
19
20 PROCEDURE validateGeo(
21 P_LOCATION_ID IN NUMBER,
22 P_COUNTRY IN VARCHAR2,
23 P_STATE IN VARCHAR2,
24 P_PROVINCE IN VARCHAR2,
25 P_COUNTY IN VARCHAR2,
26 P_CITY IN VARCHAR2,
27 P_POSTAL_CODE IN VARCHAR2,
28 P_POSTAL_PLUS4_CODE IN VARCHAR2,
29 P_ATTRIBUTE1 IN VARCHAR2,
30 P_ATTRIBUTE2 IN VARCHAR2,
31 P_ATTRIBUTE3 IN VARCHAR2,
32 P_ATTRIBUTE4 IN VARCHAR2,
33 P_ATTRIBUTE5 IN VARCHAR2,
34 P_ATTRIBUTE6 IN VARCHAR2,
35 P_ATTRIBUTE7 IN VARCHAR2,
36 P_ATTRIBUTE8 IN VARCHAR2,
37 P_ATTRIBUTE9 IN VARCHAR2,
38 P_ATTRIBUTE10 IN VARCHAR2,
39 P_LOCK_FLAG IN VARCHAR2 DEFAULT FND_API.G_TRUE,
40 X_CALL_MAP IN OUT NOCOPY VARCHAR2,
41 P_CALLED_FROM IN VARCHAR2,
42 P_ADDR_VAL_LEVEL IN VARCHAR2,
43 X_ADDR_WARN_MSG OUT NOCOPY VARCHAR2,
44 X_ADDR_VAL_STATUS OUT NOCOPY VARCHAR2,
45 X_STATUS OUT NOCOPY VARCHAR2);
46
47 PROCEDURE validateTax(
48 P_LOCATION_ID IN NUMBER,
49 P_COUNTRY IN VARCHAR2,
50 P_STATE IN VARCHAR2,
51 P_PROVINCE IN VARCHAR2,
52 P_COUNTY IN VARCHAR2,
53 P_CITY IN VARCHAR2,
54 P_POSTAL_CODE IN VARCHAR2,
55 P_POSTAL_PLUS4_CODE IN VARCHAR2,
56 P_ATTRIBUTE1 IN VARCHAR2,
57 P_ATTRIBUTE2 IN VARCHAR2,
58 P_ATTRIBUTE3 IN VARCHAR2,
59 P_ATTRIBUTE4 IN VARCHAR2,
60 P_ATTRIBUTE5 IN VARCHAR2,
61 P_ATTRIBUTE6 IN VARCHAR2,
62 P_ATTRIBUTE7 IN VARCHAR2,
63 P_ATTRIBUTE8 IN VARCHAR2,
64 P_ATTRIBUTE9 IN VARCHAR2,
65 P_ATTRIBUTE10 IN VARCHAR2,
66 P_LOCK_FLAG IN VARCHAR2 DEFAULT FND_API.G_TRUE,
67 X_CALL_MAP IN OUT NOCOPY VARCHAR2,
68 P_CALLED_FROM IN VARCHAR2,
69 P_ADDR_VAL_LEVEL IN VARCHAR2,
70 X_ADDR_WARN_MSG OUT NOCOPY VARCHAR2,
71 X_ADDR_VAL_STATUS OUT NOCOPY VARCHAR2,
72 X_STATUS OUT NOCOPY VARCHAR2);
73
74 END HZ_GNR_MAP10000;