[Home] [Help]
PACKAGE: APPS.AMS_GEO_AREAS_PVT
Source
1 PACKAGE AMS_Geo_Areas_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvgeos.pls 115.11 2002/11/22 23:37:15 dbiswas ship $ */
3
4 TYPE geo_area_rec_type IS RECORD
5 (
6 ACTIVITY_GEO_AREA_ID NUMBER,
7 LAST_UPDATE_DATE DATE,
8 LAST_UPDATED_BY NUMBER,
9 CREATION_DATE DATE,
10 CREATED_BY NUMBER,
11 LAST_UPDATE_LOGIN NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 ACT_GEO_AREA_USED_BY_ID NUMBER,
14 ARC_ACT_GEO_AREA_USED_BY VARCHAR2(4),
15 ATTRIBUTE_CATEGORY VARCHAR2(30),
16 ATTRIBUTE1 VARCHAR2(150),
17 ATTRIBUTE2 VARCHAR2(150),
18 ATTRIBUTE3 VARCHAR2(150),
19 ATTRIBUTE4 VARCHAR2(150),
20 ATTRIBUTE5 VARCHAR2(150),
21 ATTRIBUTE6 VARCHAR2(150),
22 ATTRIBUTE7 VARCHAR2(150),
23 ATTRIBUTE8 VARCHAR2(150),
24 ATTRIBUTE9 VARCHAR2(150),
25 ATTRIBUTE10 VARCHAR2(150),
26 ATTRIBUTE11 VARCHAR2(150),
27 ATTRIBUTE12 VARCHAR2(150),
28 ATTRIBUTE13 VARCHAR2(150),
29 ATTRIBUTE14 VARCHAR2(150),
30 ATTRIBUTE15 VARCHAR2(150),
31 GEO_AREA_TYPE_CODE VARCHAR2(30),
32 GEO_HIERARCHY_ID NUMBER
33 );
34
35
36 /****************************************************************************/
37 -- Procedure
38 -- create_geo_area
39 -- Purpose
40 -- create a row in AMS_ACT_GEO_AREAS
41 -- Parameters
42 -- IN:
43 -- p_api_version IN NUMBER
44 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
45 -- p_commit IN VARCHAR2 := FND_API.g_false
46 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
47 --
48 -- p_geo_area_rec IN geo_area_rec_type
49 --
50 -- OUT:
51 -- x_return_status OUT VARCHAR2
52 -- x_msg_count OUT NUMBER
53 -- x_msg_data OUT VARCHAR2
54 --
55 -- x_geo_area_id OUT NUMBER
56 ------------------------------------------------------------------------------
57 PROCEDURE create_geo_area
58 (
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
61 p_commit IN VARCHAR2 := FND_API.g_false,
62 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
63
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67
68 p_geo_area_rec IN geo_area_rec_type,
69 x_geo_area_id OUT NOCOPY NUMBER
70 );
71
72 /****************************************************************************/
73 -- Procedure
74 -- update_geo_area
75 -- Purpose
76 -- update a row in AMS_ACT_GEO_AREAS
77 -- Parameters
78 -- IN:
79 -- p_api_version IN NUMBER
80 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
81 -- p_commit IN VARCHAR2 := FND_API.g_false
82 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
83 --
84 -- p_geo_area_rec IN geo_area_rec_type
85 --
86 -- OUT:
87 -- x_return_status OUT VARCHAR2
88 -- x_msg_count OUT NUMBER
89 -- x_msg_data OUT VARCHAR2
90 ------------------------------------------------------------------------------
91 PROCEDURE update_geo_area
92 (
93 p_api_version IN NUMBER,
94 P_init_msg_list IN VARCHAR2 := FND_API.g_false,
95 p_commit IN VARCHAR2 := FND_API.g_false,
96 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
97
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101
102 p_geo_area_rec IN geo_area_rec_type
103 );
104
105 /****************************************************************************/
106 -- Procedure
107 -- delete_geo_area
108 -- Purpose
109 -- delete a row from AMS_ACT_GEO_AREAS
110 -- Parameters
111 -- IN:
112 -- p_api_version IN NUMBER
113 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
114 -- p_commit IN VARCHAR2 := FND_API.g_false
115 --
116 -- p_geo_area_id IN NUMBER
117 -- p_object_version IN NUMBER
118 --
119 -- OUT:
120 -- x_return_status OUT VARCHAR2
121 -- x_msg_count OUT NUMBER
122 -- x_msg_data OUT VARCHAR2
123 ------------------------------------------------------------------------------
124 PROCEDURE delete_geo_area
125 (
126 p_api_version IN NUMBER,
127 P_init_msg_list IN VARCHAR2 := FND_API.g_false,
128 p_commit IN VARCHAR2 := FND_API.g_false,
129
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133
134 p_geo_area_id IN NUMBER,
135 p_object_version IN NUMBER
136 );
137
138 /****************************************************************************/
139 -- Procedure
140 -- lock_geo_area
141 -- Purpose
142 -- lock a row form AMS_ACT_GEO_AREAS
143 -- Parameters
144 -- IN:
145 -- p_api_version IN NUMBER
146 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
147 --
148 -- p_geo_area_id IN NUMBER
149 -- p_object_version IN NUMBER
150 --
151 -- OUT:
152 -- x_return_status OUT VARCHAR2
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2
155 ------------------------------------------------------------------------------
156 PROCEDURE lock_geo_area
157 (
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
160
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164
165 p_geo_area_id IN NUMBER,
166 p_object_version IN NUMBER
167 );
168
169 /***************************************************************************/
170 -- Procedure
171 -- validate_geo_area
172 -- Purpose
173 -- validate a record before inserting or updating AMS_ACT_GEO_AREAS
174 -- Parameters
175 -- IN:
176 -- p_api_version IN NUMBER
177 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
178 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
179 --
180 -- p_geo_area_rec IN geo_area_rec_type
181 --
182 -- OUT:
183 -- x_return_status OUT VARCHAR2
184 -- x_msg_count OUT NUMBER
185 -- x_msg_data OUT VARCHAR2
186 ------------------------------------------------------------------------------
187 PROCEDURE validate_geo_area
188 (
189 p_api_version IN NUMBER,
190 P_init_msg_list IN VARCHAR2 := FND_API.g_false,
191 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
192
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196
197 p_geo_area_rec IN geo_area_rec_type
198 );
199
200 /****************************************************************************/
201 -- Procedure
202 -- check_items
203 -- Purpose
204 -- item_level validate
205 -- Parameters
206 -- IN:
207 -- p_validation_mode IN VARCHAR2
208 -- p_geo_area_rec IN geo_area_rec_type
209 -- OUT:
210 -- x_return_status OUT VARCHAR2
211 ------------------------------------------------------------------------------
212 PROCEDURE check_items
213 (
214 p_validation_mode IN VARCHAR2,
215 x_return_status OUT NOCOPY VARCHAR2,
216 p_geo_area_rec IN geo_area_rec_type
217 );
218
219 /****************************************************************************/
220 -- Procedure
221 -- check_geo_area_req_items
222 -- Purpose
223 -- check if required items are miss
224 -- Parameters
225 -- IN:
226 -- p_validation_mode IN VARCHAR2
227 -- p_geo_area_rec IN geo_area_rec_type
228 -- OUT:
229 -- x_return_status OUT VARCHAR2
230 ------------------------------------------------------------------------------
231 PROCEDURE check_geo_area_req_items
232 (
233 p_validation_mode IN VARCHAR2,
234 p_geo_area_rec IN geo_area_rec_type,
235 x_return_status OUT NOCOPY VARCHAR2
236 );
237
238 /****************************************************************************/
239 -- Procedure
240 -- check_geo_area_uk_items
241 -- Purpose
242 -- check unique keys
243 -- Parameters
244 -- IN:
245 -- p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
246 -- p_geo_area_rec IN geo_area_rec_type
247 -- OUT:
248 -- x_return_status OUT VARCHAR2
249 ------------------------------------------------------------------------------
250 PROCEDURE check_geo_area_uk_items
251 (
252 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
253 p_geo_area_rec IN geo_area_rec_type,
254 x_return_status OUT NOCOPY VARCHAR2
255 );
256
257 /****************************************************************************/
258 -- Procedure
259 -- check_geo_area_fk_items
260 -- Purpose
261 -- check foreign key items
262 -- Parameters
263 -- IN:
264 -- p_geo_area_rec IN geo_area_rec_type
265 -- OUT:
266 -- x_return_status OUT VARCHAR2
267 ------------------------------------------------------------------------------
268 PROCEDURE check_geo_area_fk_items
269 (
270 p_geo_area_rec IN geo_area_rec_type,
271 x_return_status OUT NOCOPY VARCHAR2
272 );
273
274 /****************************************************************************/
275 -- Procedure
276 -- complete_geo_area_rec
277 -- Purpose
278 -- replace "g_miss" or NULL values with current database values
279 -- Parameters
280 -- IN:
281 -- p_geo_area_rec IN geo_area_rec_type
282 -- OUT:
283 -- x_complete_rec OUT geo_area_rec_type
284 ------------------------------------------------------------------------------
285 PROCEDURE complete_geo_area_rec
286 (
287 p_geo_area_rec IN geo_area_rec_type,
288 x_complete_rec OUT NOCOPY geo_area_rec_type
289 );
290
291 /****************************************************************************/
292 -- Procedure
293 -- init_rec
294 --
295 -- HISTORY
296 -- 12/19/1999 julou Created.
297 ------------------------------------------------------------------------------
298 PROCEDURE init_rec
299 (
300 x_geo_area_rec OUT NOCOPY geo_area_rec_type
301 );
302
303 END AMS_Geo_Areas_PVT;