1 PACKAGE HZ_GNR_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHGNRCS.pls 120.7.12000000.2 2007/04/18 00:49:21 nsinghai ship $ */
3
4 -- Public variable to keep track of purpose for which HZ_GNR_UTIL_PKG is called
5 -- Value set in HZ_GNR_PKG pkg but checked in HZ_GNR_UTIL_PKG pkg
6 G_API_PURPOSE VARCHAR2(30);
7
8 PROCEDURE create_geo_name_ref (
9 errbuf OUT NOCOPY VARCHAR2,
10 retcode OUT NOCOPY VARCHAR2,
11 p_location_table_name IN VARCHAR2,
12 p_run_type IN VARCHAR2,
13 p_usage_code IN VARCHAR2,
14 p_country_code IN VARCHAR2,
15 p_from_location_id IN VARCHAR2,
16 p_to_location_id IN VARCHAR2,
17 p_start_date IN VARCHAR2,
18 p_end_date IN VARCHAR2
19 );
20
21 PROCEDURE process_gnr_worker (
22 errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY VARCHAR2,
24 p_worker_number IN VARCHAR2,
25 p_location_table_name IN VARCHAR2,
26 p_run_type IN VARCHAR2,
27 p_usage_code IN VARCHAR2,
28 p_country_code IN VARCHAR2,
29 p_from_location_id IN VARCHAR2,
30 p_to_location_id IN VARCHAR2,
31 p_start_date IN VARCHAR2,
32 p_end_date IN VARCHAR2,
33 p_num_workers IN VARCHAR2
34 );
35 /**
36 * PROCEDURE srchGeo
37 *
38 * DESCRIPTION
39 * This private procedure is used to wrap the calls for all the
40 * map specific procedure. This will call the various search
41 * procedures depending on the component level in the hierarchy
42 * for given location id and location table combination.
43 *
44 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
45 *
46 * ARGUMENTS
47 * IN:
48 *
49 * p_locId Location Identifier
50 * p_locTbl Location Table
51 *
52 * OUT:
53 * x_status indicates if the srchGeo was sucessfull or not.
54 *
55 * NOTES
56 *
57 *
58 * MODIFICATION HISTORY
59 *
60 *
61 */
62
63 PROCEDURE srchGeo(
64 p_locId IN NUMBER,
65 p_locTbl IN VARCHAR2,
66 p_usage_code IN VARCHAR2,
67 x_status OUT NOCOPY VARCHAR2
68 );
69 PROCEDURE delete_gnr(
70 p_locId IN NUMBER,
71 p_locTbl IN VARCHAR2,
72 x_status OUT NOCOPY VARCHAR2
73 );
74
75 PROCEDURE validateLoc(
76 P_LOCATION_ID IN NUMBER,
77 P_USAGE_CODE IN VARCHAR2,
78 P_ADDRESS_STYLE IN VARCHAR2,
79 P_COUNTRY IN VARCHAR2,
80 P_STATE IN VARCHAR2,
81 P_PROVINCE IN VARCHAR2,
82 P_COUNTY IN VARCHAR2,
83 P_CITY IN VARCHAR2,
84 P_POSTAL_CODE IN VARCHAR2,
85 P_POSTAL_PLUS4_CODE IN VARCHAR2,
86 P_ATTRIBUTE1 IN VARCHAR2,
87 P_ATTRIBUTE2 IN VARCHAR2,
88 P_ATTRIBUTE3 IN VARCHAR2,
89 P_ATTRIBUTE4 IN VARCHAR2,
90 P_ATTRIBUTE5 IN VARCHAR2,
91 P_ATTRIBUTE6 IN VARCHAR2,
92 P_ATTRIBUTE7 IN VARCHAR2,
93 P_ATTRIBUTE8 IN VARCHAR2,
94 P_ATTRIBUTE9 IN VARCHAR2,
95 P_ATTRIBUTE10 IN VARCHAR2,
96 P_CALLED_FROM IN VARCHAR2 DEFAULT 'VALIDATE',
97 P_LOCK_FLAG IN VARCHAR2 DEFAULT FND_API.G_TRUE,
98 X_ADDR_VAL_LEVEL OUT NOCOPY VARCHAR2,
99 X_ADDR_WARN_MSG OUT NOCOPY VARCHAR2,
100 X_ADDR_VAL_STATUS OUT NOCOPY VARCHAR2,
101 X_STATUS OUT NOCOPY VARCHAR2);
102
103 PROCEDURE validateHrLoc(
104 P_LOCATION_ID IN NUMBER,
105 X_STATUS OUT NOCOPY VARCHAR2);
106 END;