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;