[Home] [Help]
PACKAGE: APPS.HZ_GEOGRAPHY_VALIDATE_PVT
Source
1 PACKAGE HZ_GEOGRAPHY_VALIDATE_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHGEOVS.pls 115.0 2003/02/01 02:38:13 rnalluri noship $ */
3
4
5 --------------------------------------
6 -- Type declarations
7 --------------------------------------
8
9 TYPE ZONE_RELATION_REC_TYPE IS RECORD(
10 geography_id NUMBER,
11 included_geography_id NUMBER,
12 start_date DATE,
13 end_date DATE
14 );
15 --------------------------------------
16 -- public procedures and functions
17 --------------------------------------
18
19 /**
20 * PROCEDURE validate_master_relation
21 *
22 * DESCRIPTION
23 * Validate the relationship record.
24 *
25 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
26 *
27 * ARGUMENTS
28 * IN:
29 * p_master_relation_rec Master relationship record
30 * p_create_update_flag Flag that indicates 'C' for create
31 * and 'U' for update
32 *
33 * IN/OUT:
34 * x_return_status Return status.
35 *
36 * NOTES
37 *
38 *
39 * MODIFICATION HISTORY
40 *
41 * 11-22-2002 Rekha Nalluri o Created.
42 *
43 */
44
45 PROCEDURE validate_master_relation (
46 p_master_relation_rec IN HZ_GEOGRAPHY_PUB.master_relation_rec_type,
47 p_create_update_flag IN VARCHAR2,
48 x_return_status IN OUT NOCOPY VARCHAR2
49 );
50
51
52 /**
53 * PROCEDURE validate_structure
54 *
55 * DESCRIPTION
56 * Validates whether geography_type and parent_geography_type are as per the structure defined
57 * for that country
58 *
59 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
60 *
61 * ARGUMENTS
62 * IN:
63 * p_start_date start date
64 * p_end_date end date
65 *
66 * IN/OUT:
67 * x_return_status Return status.
68 *
69 * NOTES
70 *
71 *
72 * MODIFICATION HISTORY
73 *
74 * 11-22-2002 Rekha Nalluri o Created.
75 *
76 */
77
78 PROCEDURE validate_structure(
79 p_geography_type IN VARCHAR2,
80 p_parent_geography_type IN VARCHAR2,
81 p_country_code IN VARCHAR2,
82 x_return_status IN OUT NOCOPY VARCHAR2
83 );
84
85
86 /**
87 * PROCEDURE get_geography_type
88 *
89 * DESCRIPTION
90 * Gets the geography type based on the geography_id passed.
91 *
92 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
93 *
94 * ARGUMENTS
95 * IN:
96 * p_geography_id Geography ID
97 * x_geography_type Geography Type
98 *
99 *
100 * NOTES
101 *
102 *
103 * MODIFICATION HISTORY
104 *
105 * 11-22-2002 Rekha Nalluri o Created.
106 *
107 */
108 FUNCTION get_geography_type(
109 p_geography_id IN NUMBER,
110 x_return_status IN OUT NOCOPY VARCHAR2
111 )RETURN VARCHAR2;
112
113
114 /**
115 * PROCEDURE validate_geo_identifier
116 *
117 * DESCRIPTION
118 * Validate the geography identifier record.
119 *
120 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
121 *
122 * ARGUMENTS
123 * IN:
124 * p_geo_identifier_rec Geography Identifier record
125 * p_create_update_flag Flag that indicates 'C' for create
126 * and 'U' for update
127 *
128 * IN/OUT:
129 * x_return_status Return status.
130 *
131 * NOTES
132 *
133 *
134 * MODIFICATION HISTORY
135 *
136 * 12-03-2002 Rekha Nalluri o Created.
137 *
138 */
139
140 PROCEDURE validate_geo_identifier (
141 p_geo_identifier_rec IN HZ_GEOGRAPHY_PUB.geo_identifier_rec_type,
142 p_create_update_flag IN VARCHAR2,
143 x_return_status IN OUT NOCOPY VARCHAR2
144 );
145
146 /**
147 * PROCEDURE validate_master_geography
148 *
149 * DESCRIPTION
150 * Validate the master geography record.
151 *
152 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
153 *
154 * ARGUMENTS
155 * IN:
156 * p_master_geography_rec Master Geography record
157 * p_create_update_flag Flag that indicates 'C' for create
158 * and 'U' for update
159 *
160 * IN/OUT:
161 * x_return_status Return status.
162 *
163 * NOTES
164 *
165 *
166 * MODIFICATION HISTORY
167 *
168 * 12-09-2002 Rekha Nalluri o Created.
169 *
170 */
171
172 PROCEDURE validate_master_geography (
173 p_master_geography_rec IN HZ_GEOGRAPHY_PUB.master_geography_rec_type,
174 p_create_update_flag IN VARCHAR2,
175 x_return_status IN OUT NOCOPY VARCHAR2
176 );
177
178 /**
179 * PROCEDURE validate_geography_range
180 *
181 * DESCRIPTION
182 * Validates the geography range record.
183 *
184 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
185 *
186 * ARGUMENTS
187 * IN:
188 * p_geography_range_rec Geography range record
189 * p_create_update_flag Flag that indicates 'C' for create
190 * and 'U' for update
191 *
192 * IN/OUT:
193 * x_return_status Return status.
194 *
195 * NOTES
196 *
197 *
198 * MODIFICATION HISTORY
199 *
200 * 01-20-2003 Rekha Nalluri o Created.
201 *
202 */
203
204 PROCEDURE validate_geography_range (
205 p_geography_range_rec IN HZ_GEOGRAPHY_PUB.geography_range_rec_type,
206 p_create_update_flag IN VARCHAR2,
207 x_return_status IN OUT NOCOPY VARCHAR2
208 );
209
210 /**
211 * PROCEDURE validate_zone_relation
212 *
213 * DESCRIPTION
214 * Validates the zone relation record.
215 *
216 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
217 *
218 * ARGUMENTS
219 * IN:i
220 * p_geography_id Geography id
221 * p_zone_relation_tbl Zone relation table of records
222 * p_create_update_flag Flag that indicates 'C' for create
223 * and 'U' for update
224 *
225 * IN/OUT:
226 * x_return_status Return status.
227 *
228 * NOTES
229 *
230 *
231 * MODIFICATION HISTORY
232 *
233 * 01-24-2003 Rekha Nalluri o Created.
234 *
235 */
236
237 PROCEDURE validate_zone_relation (
238 p_zone_relation_rec IN ZONE_RELATION_REC_TYPE,
239 p_create_update_flag IN VARCHAR2,
240 x_return_status IN OUT NOCOPY VARCHAR2
241 );
242
243 END HZ_GEOGRAPHY_VALIDATE_PVT;