DBA Data[Home] [Help]

PACKAGE: APPS.AK_REGION_GRP

Source


1 package AK_REGION_GRP as
2 /* $Header: akdgregs.pls 120.2 2005/09/15 22:26:41 tshort ship $ */
3 
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6 
7 G_PKG_NAME      CONSTANT    VARCHAR2(30) := 'AK_REGION_GRP';
8 
9 /* Procedure specs */
10 
11 --=======================================================
12 --  Procedure   CREATE_ITEM
13 --
14 --  Usage       Group API for creating a region item
15 --
16 --  Desc        Calls the private API to creates a region item
17 --              using the given info
18 --
19 --  Results     The API returns the standard p_return_status parameter
20 --              indicating one of the standard return statuses :
21 --                  * Unexpected error
22 --                  * Error
23 --                  * Success
24 --  Parameters  Region Item columns
25 --
26 --  Version     Initial version number  =   1.0
27 --  History     Current version number  =   1.0
28 --=======================================================
29 procedure CREATE_ITEM (
30 p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
31 p_api_version_number       IN      NUMBER,
32 p_init_msg_tbl             IN      BOOLEAN := FALSE,
33 p_msg_count                OUT NOCOPY     NUMBER,
34 p_msg_data                 OUT NOCOPY     VARCHAR2,
35 p_return_status            OUT NOCOPY     VARCHAR2,
36 p_region_application_id    IN      NUMBER,
37 p_region_code              IN      VARCHAR2,
38 p_attribute_application_id IN      NUMBER,
39 p_attribute_code           IN      VARCHAR2,
40 p_display_sequence         IN      NUMBER,
41 p_node_display_flag        IN      VARCHAR2,
42 p_node_query_flag          IN      VARCHAR2,
43 p_attribute_label_length   IN      NUMBER,
44 p_display_value_length     IN      NUMBER,
45 p_bold                     IN      VARCHAR2,
46 p_italic                   IN      VARCHAR2,
47 p_vertical_alignment       IN      VARCHAR2,
48 p_horizontal_alignment     IN      VARCHAR2,
49 p_item_style               IN      VARCHAR2,
50 p_object_attribute_flag    IN      VARCHAR2,
51 p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_update_flag              IN      VARCHAR2,
53 p_required_flag            IN      VARCHAR2,
54 p_security_code            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
55 p_default_value_varchar2   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
56 p_default_value_number     IN      NUMBER := FND_API.G_MISS_NUM,
57 p_default_value_date       IN      DATE := FND_API.G_MISS_DATE,
58 p_lov_region_application_id IN     NUMBER := FND_API.G_MISS_NUM,
59 p_lov_region_code          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
60 p_lov_foreign_key_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
61 p_lov_attribute_application_id IN  NUMBER := FND_API.G_MISS_NUM,
62 p_lov_attribute_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_lov_default_flag         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
64 p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
66 p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
67 p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
68 p_order_sequence           IN      NUMBER := FND_API.G_MISS_NUM,
69 p_order_direction          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
70 p_display_height		 IN	 NUMBER := FND_API.G_MISS_NUM,
71 p_submit			 IN	 VARCHAR2,
72 p_encrypt			 IN	 VARCHAR2,
73 p_css_class_name		 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
74 p_view_usage_name		 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
75 p_view_attribute_name		 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
76 p_nested_region_appl_id	 IN	 NUMBER := FND_API.G_MISS_NUM,
77 p_nested_region_code		 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
78 p_url				 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_poplist_viewobject		 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
80 p_poplist_display_attr	 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
81 p_poplist_value_attr		 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
82 p_image_file_name		 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
83 p_item_name			 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
84 p_css_label_class_name	 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_menu_name			 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_flexfield_name		 IN	 VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_flexfield_application_id     IN	 NUMBER   := FND_API.G_MISS_NUM,
88 p_tabular_function_code        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_tip_type                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
90 p_tip_message_name             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_tip_message_application_id   IN      NUMBER   := FND_API.G_MISS_NUM,
92 p_flex_segment_list 			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_entity_id					 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_anchor					 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
95 p_poplist_view_usage_name  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
96 p_user_customizable	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_sortby_view_attribute_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
98 p_admin_customizable		IN	VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_invoke_function_name	IN      VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_expansion 			IN      NUMBER   := FND_API.G_MISS_NUM,
101 p_als_max_length		IN      NUMBER   := FND_API.G_MISS_NUM,
102 p_initial_sort_sequence	IN	VARCHAR2 := FND_API.G_MISS_CHAR,
103 p_customization_application_id  IN	NUMBER   := FND_API.G_MISS_NUM,
104 p_customization_code		IN	VARCHAR2 := FND_API.G_MISS_CHAR,
105 p_attribute_label_long	 IN      VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_attribute_label_short    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_description				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR
108 );
109 
110 --=======================================================
111 --  Procedure   CREATE_REGION
112 --
113 --  Usage       Group API for creating a region
114 --
115 --  Desc        Calls the private API to create a region
116 --              using the given info
117 --
118 --  Results     The API returns the standard p_return_status parameter
119 --              indicating one of the standard return statuses :
120 --                  * Unexpected error
121 --                  * Error
122 --                  * Success
123 --  Parameters  Region columns
124 --
125 
126 --  Version     Initial version number  =   1.0
127 --  History     Current version number  =   1.0
128 --=======================================================
129 procedure CREATE_REGION (
130 p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
131 p_api_version_number       IN      NUMBER,
132 p_init_msg_tbl             IN      BOOLEAN := FALSE,
133 p_msg_count                OUT NOCOPY     NUMBER,
134 p_msg_data                 OUT NOCOPY     VARCHAR2,
135 p_return_status            OUT NOCOPY     VARCHAR2,
136 p_region_application_id    IN      NUMBER,
137 p_region_code              IN      VARCHAR2,
138 p_database_object_name     IN      VARCHAR2,
139 p_region_style             IN      VARCHAR2,
140 p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_num_columns              IN      NUMBER := FND_API.G_MISS_NUM,
142 p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_appmodule_object_type	 IN    VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_num_rows_display		 IN    NUMBER := FND_API.G_MISS_NUM,
148 p_region_object_type		 IN    VARCHAR2 := FND_API.G_MISS_CHAR,
149 p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
150 p_isform_flag				 IN		 VARCHAR2,
151 p_help_target			IN	VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_style_sheet_filename	 IN	VARCHAR2 := FND_API.G_MISS_CHAR,
153 p_version                  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
154 p_applicationmodule_usage_name IN  VARCHAR2 := FND_API.G_MISS_CHAR,
155 p_add_indexed_children     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_stateful_flag	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_function_name            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
158 p_children_view_usage_name IN      VARCHAR2 := FND_API.G_MISS_CHAR,
159 p_search_panel	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
160 p_advanced_search_panel    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
161 p_customize_panel	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
162 p_default_search_panel     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
163 p_results_based_search     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
164 p_display_graph_table	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
165 p_disable_header	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
166 p_standalone		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
167 p_auto_customization_criteria IN   VARCHAR2 := FND_API.G_MISS_CHAR,
168 p_name                     IN      VARCHAR2,
169 p_description              IN      VARCHAR2 := FND_API.G_MISS_CHAR
170 );
171 
172 --=======================================================
173 --  Procedure   DELETE_ITEM
174 --
175 --  Usage       Group API for deleting a region item
176 --
177 --  Desc        Calls the private API to delete a region item
178 --              with the given key value.
179 --
180 --  Results     The API returns the standard p_return_status parameter
181 --              indicating one of the standard return statuses :
182 --                  * Unexpected error
183 --                  * Error
184 --                  * Success
185 --  Parameters  p_region_application_id : IN required
186 --              p_region_code : IN required
187 --              p_attribute_application_id : IN required
188 --              p_attribute_code : IN required
189 --                  Key value of the region item to be deleted
190 --              p_delete_cascade : IN required
191 --                  If p_delete_cascade flag is 'Y', also delete all
192 --                  rows in other tables that references this record.
193 --                  Otherwise, this record will not be deleted if there
194 --                  are any other rows referencing it.
195 --
196 --  Version     Initial version number  =   1.0
197 --  History     Current version number  =   1.0
198 --=======================================================
199 procedure DELETE_ITEM (
200 p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
201 p_api_version_number       IN      NUMBER,
202 p_init_msg_tbl             IN      BOOLEAN := FALSE,
203 p_msg_count                OUT NOCOPY     NUMBER,
204 p_msg_data                 OUT NOCOPY     VARCHAR2,
205 p_return_status            OUT NOCOPY     VARCHAR2,
206 p_region_application_id    IN      NUMBER,
207 p_region_code              IN      VARCHAR2,
208 p_attribute_application_id IN      NUMBER,
209 p_attribute_code           IN      VARCHAR2,
210 p_delete_cascade           IN      VARCHAR2 := 'N'
211 );
212 
213 --=======================================================
214 --  Procedure   DELETE_REGION
215 --
216 --  Usage       Group API for deleting a region
217 --
218 --  Desc        Calls the private API to delete a region
219 --              with the given key value.
220 --
221 --  Results     The API returns the standard p_return_status parameter
222 --              indicating one of the standard return statuses :
223 --                  * Unexpected error
224 --                  * Error
225 --                  * Success
226 --  Parameters  p_region_application_id : IN required
227 --              p_region_code : IN required
228 --                  Key value of the region to be deleted
229 --              p_delete_cascade : IN required
230 --                  If p_delete_cascade flag is 'Y', also delete all
231 --                  rows in other tables that references this record.
232 --                  Otherwise, this record will not be deleted if there
233 --                  are any other rows referencing it.
234 --
235 --  Version     Initial version number  =   1.0
236 --  History     Current version number  =   1.0
237 --=======================================================
238 procedure DELETE_REGION (
239 p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
240 p_api_version_number       IN      NUMBER,
241 p_init_msg_tbl             IN      BOOLEAN := FALSE,
242 p_msg_count                OUT NOCOPY     NUMBER,
243 p_msg_data                 OUT NOCOPY     VARCHAR2,
244 p_return_status            OUT NOCOPY     VARCHAR2,
245 p_region_application_id    IN      NUMBER,
246 p_region_code              IN      VARCHAR2,
247 p_delete_cascade           IN      VARCHAR2 := 'N'
248 );
249 
250 
251 --=======================================================
252 --  Procedure   DOWNLOAD_REGION
253 --
254 --  Usage       Group API for downloading regions
255 --
256 --  Desc        This API first write out standard loader
257 --              file header for regions to a flat file.
258 --              Then it calls the private API to extract the
259 --              regions selected by application ID or by
260 --              key values from the database to the output file.
261 --              If a region is selected for writing to the loader
262 --              file, all its children records (including region
263 --              items) will also be written.
264 --
265 --  Results     The API returns the standard p_return_status parameter
266 --              indicating one of the standard return statuses :
267 --                  * Unexpected error
268 --                  * Error
269 --                  * Success
270 --  Parameters
271 --              p_nls_language : IN optional
272 --                  NLS language for database. If none if given,
273 --                  the current NLS language will be used.
274 --
275 --              One of the following three parameters must be given:
276 --
277 --              p_application_id : IN optional
278 --                  If given, all regions for this application ID
279 --                  will be written to the output file.
280 --              p_application_short_name : IN optional
281 --                  If given, all regions for this application short
282 --                  name will be written to the output file.
283 --                  Application short name will be ignored if an
284 --                  application ID is given.
285 --              p_oregion_pk_tbl : IN optional
286 --                  If given, only regions whose key values are
287 --                  included in this table will be written to the
288 --                  output file.
289 --
290 --
291 --  Version     Initial version number  =   1.0
292 --  History     Current version number  =   1.0
293 --=======================================================
294 procedure DOWNLOAD_REGION (
295 p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
296 p_api_version_number       IN      NUMBER,
297 p_init_msg_tbl             IN      BOOLEAN := FALSE,
298 p_msg_count                OUT NOCOPY     NUMBER,
299 p_msg_data                 OUT NOCOPY     VARCHAR2,
300 p_return_status            OUT NOCOPY     VARCHAR2,
301 p_nls_language             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
302 p_application_id           IN      NUMBER := FND_API.G_MISS_NUM,
303 p_application_short_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
304 p_region_pk_tbl            IN      AK_REGION_PUB.Region_PK_Tbl_Type
305 := AK_REGION_PUB.G_MISS_REGION_PK_TBL
306 );
307 
308 --=======================================================
309 --  Procedure   UPDATE_ITEM
310 --
311 --  Usage       Group API for updating a region item
312 --
313 --  Desc        This API calls the private API to update
314 --              a region item using the given info
315 --
316 --  Results     The API returns the standard p_return_status parameter
317 --              indicating one of the standard return statuses :
318 --                  * Unexpected error
319 --                  * Error
320 --                  * Success
321 --  Parameters  Region item columns
322 --
323 --  Version     Initial version number  =   1.0
324 --  History     Current version number  =   1.0
325 --=======================================================
326 procedure UPDATE_ITEM (
327 p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
328 p_api_version_number       IN      NUMBER,
329 p_init_msg_tbl             IN      BOOLEAN := FALSE,
330 p_msg_count                OUT NOCOPY     NUMBER,
331 p_msg_data                 OUT NOCOPY     VARCHAR2,
332 p_return_status            OUT NOCOPY     VARCHAR2,
333 p_region_application_id    IN      NUMBER,
337 p_display_sequence         IN      NUMBER := FND_API.G_MISS_NUM,
334 p_region_code              IN      VARCHAR2,
335 p_attribute_application_id IN      NUMBER,
336 p_attribute_code           IN      VARCHAR2,
338 p_node_display_flag        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
339 p_node_query_flag          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
340 p_attribute_label_length   IN      NUMBER := FND_API.G_MISS_NUM,
341 p_display_value_length     IN      NUMBER := FND_API.G_MISS_NUM,
342 p_bold                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
343 p_italic                   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
344 p_vertical_alignment       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
345 p_horizontal_alignment     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
346 p_item_style               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
347 p_object_attribute_flag    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
348 p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
349 p_update_flag              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
350 p_required_flag            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
351 p_security_code            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
352 p_default_value_varchar2   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
353 p_default_value_number     IN      NUMBER := FND_API.G_MISS_NUM,
354 p_default_value_date       IN      DATE := FND_API.G_MISS_DATE,
355 p_lov_region_application_id IN     NUMBER := FND_API.G_MISS_NUM,
356 p_lov_region_code          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
357 p_lov_foreign_key_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
358 p_lov_attribute_application_id IN  NUMBER := FND_API.G_MISS_NUM,
359 p_lov_attribute_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
360 p_lov_default_flag         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
361 p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
362 p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
363 p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
364 p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
365 p_order_sequence           IN      NUMBER := FND_API.G_MISS_NUM,
366 p_order_direction          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
367 p_display_height			 IN		 NUMBER := FND_API.G_MISS_NUM,
368 p_submit					 IN		 VARCHAR2,
369 p_encrypt					 IN		 VARCHAR2,
370 p_css_class_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
371 p_view_usage_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
372 p_view_attribute_name		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
373 p_nested_region_appl_id	 IN		 NUMBER := FND_API.G_MISS_NUM,
374 p_nested_region_code		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
375 p_url						 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
376 p_poplist_viewobject		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
377 p_poplist_display_attr	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
378 p_poplist_value_attr		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
379 p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
380 p_item_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
381 p_css_label_class_name	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
382 p_menu_name		     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
383 p_flexfield_name	     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
384 p_flexfield_application_id IN	     NUMBER   := FND_API.G_MISS_NUM,
385 p_tabular_function_code    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
386 p_tip_type                 IN      VARCHAR2 := FND_API.G_MISS_CHAR,
387 p_tip_message_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
388 p_tip_message_application_id   IN      NUMBER   := FND_API.G_MISS_NUM,
389 p_flex_segment_list			 IN      VARCHAR2 := FND_API.G_MISS_CHAR,
390 p_entity_id					 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
391 p_anchor					 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
392 p_poplist_view_usage_name  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
393 p_user_customizable	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
394 p_sortby_view_attribute_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
395 p_admin_customizable		IN	VARCHAR2 := FND_API.G_MISS_CHAR,
396 p_invoke_function_name	IN      VARCHAR2 := FND_API.G_MISS_CHAR,
397 p_expansion			IN      NUMBER   := FND_API.G_MISS_NUM,
398 p_als_max_length		IN      NUMBER   := FND_API.G_MISS_NUM,
399 p_initial_sort_sequence	IN	VARCHAR2 := FND_API.G_MISS_CHAR,
400 p_customization_application_id  IN	NUMBER   := FND_API.G_MISS_NUM,
401 p_customization_code		IN	VARCHAR2 := FND_API.G_MISS_CHAR,
402 p_attribute_label_long     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
403 p_attribute_label_short    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
404 p_description				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR
405 );
406 
407 --=======================================================
408 --  Procedure   UPDATE_REGION
409 --
410 --  Usage       Group API for updating a region
411 --
412 --  Desc        This API calls the private API to update
413 --              a region using the given info
414 --
415 --  Results     The API returns the standard p_return_status parameter
416 --              indicating one of the standard return statuses :
417 --                  * Unexpected error
418 --                  * Error
419 --                  * Success
420 --  Parameters  Region columns
421 --
422 --  Version     Initial version number  =   1.0
423 --  History     Current version number  =   1.0
424 --=======================================================
425 procedure UPDATE_REGION (
426 p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
427 p_api_version_number       IN      NUMBER,
428 p_init_msg_tbl             IN      BOOLEAN := FALSE,
429 p_msg_count                OUT NOCOPY     NUMBER,
430 p_msg_data                 OUT NOCOPY     VARCHAR2,
431 p_return_status            OUT NOCOPY     VARCHAR2,
432 p_region_application_id    IN      NUMBER,
433 p_region_code              IN      VARCHAR2,
434 p_database_object_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
435 p_region_style             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
436 p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
437 p_num_columns              IN      NUMBER := FND_API.G_MISS_NUM,
438 p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
439 p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
440 p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
441 p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
442 p_appmodule_object_type	 IN    VARCHAR2 := FND_API.G_MISS_CHAR,
443 p_num_rows_display		 IN    NUMBER := FND_API.G_MISS_NUM,
444 p_region_object_type		 IN    VARCHAR2 := FND_API.G_MISS_CHAR,
445 p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
446 p_isform_flag				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
447 p_help_target			IN	VARCHAR2 := FND_API.G_MISS_CHAR,
448 p_style_sheet_filename        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
449 p_version                  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
450 p_applicationmodule_usage_name IN  VARCHAR2 := FND_API.G_MISS_CHAR,
451 p_add_indexed_children     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
452 p_stateful_flag	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
453 p_function_name	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
454 p_children_view_usage_name IN      VARCHAR2 := FND_API.G_MISS_CHAR,
455 p_search_panel	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
456 p_advanced_search_panel    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
457 p_customize_panel	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
458 p_default_search_panel     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
459 p_results_based_search     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
460 p_display_graph_table	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
461 p_disable_header	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
462 p_standalone		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
463 p_auto_customization_criteria IN   VARCHAR2 := FND_API.G_MISS_CHAR,
464 p_name                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
465 p_description              IN      VARCHAR2 := FND_API.G_MISS_CHAR
466 );
467 
468 end AK_REGION_GRP;