eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.AK_REGION_ITEMS_PKG

Source


1 package body AK_REGION_ITEMS_PKG as
2 /* $Header: AKDRGITB.pls 120.3 2006/01/25 15:31:51 tshort ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_REGION_APPLICATION_ID in NUMBER,
6 X_REGION_CODE in VARCHAR2,
7 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
8 X_ATTRIBUTE_CODE in VARCHAR2,
9 X_DISPLAY_SEQUENCE in NUMBER,
10 X_NODE_DISPLAY_FLAG in VARCHAR2,
11 X_NODE_QUERY_FLAG in VARCHAR2,
12 X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
13 X_BOLD in VARCHAR2,
14 X_ITALIC in VARCHAR2,
15 X_VERTICAL_ALIGNMENT in VARCHAR2,
16 X_HORIZONTAL_ALIGNMENT in VARCHAR2,
17 X_ITEM_STYLE in VARCHAR2,
18 X_OBJECT_ATTRIBUTE_FLAG in VARCHAR2,
19 X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
20 X_DESCRIPTION in VARCHAR2,
21 X_SECURITY_CODE in VARCHAR2,
22 X_UPDATE_FLAG in VARCHAR2,
23 X_REQUIRED_FLAG in VARCHAR2,
24 X_DISPLAY_VALUE_LENGTH in NUMBER,
25 X_LOV_REGION_APPLICATION_ID in NUMBER,
26 X_LOV_REGION_CODE in VARCHAR2,
27 X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
28 X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
29 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
30 X_LOV_DEFAULT_FLAG in VARCHAR2,
31 X_REGION_DEFAULTING_API_PKG in VARCHAR2,
32 X_REGION_DEFAULTING_API_PROC in VARCHAR2,
33 X_REGION_VALIDATION_API_PKG in VARCHAR2,
34 X_REGION_VALIDATION_API_PROC in VARCHAR2,
35 X_ORDER_SEQUENCE in NUMBER,
36 X_ORDER_DIRECTION in VARCHAR2,
37 X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
38 X_DEFAULT_VALUE_NUMBER in NUMBER,
39 X_DEFAULT_VALUE_DATE in DATE,
40 X_ITEM_NAME IN VARCHAR2,
41 X_DISPLAY_HEIGHT IN NUMBER,
42 X_SUBMIT IN VARCHAR2,
43 X_ENCRYPT IN VARCHAR2,
44 X_VIEW_USAGE_NAME IN VARCHAR2,
45 X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
46 X_CSS_CLASS_NAME IN VARCHAR2,
47 X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
48 X_URL IN VARCHAR2,
49 X_POPLIST_VIEWOBJECT IN VARCHAR2,
50 X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
51 X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
52 X_IMAGE_FILE_NAME IN VARCHAR2,
53 X_NESTED_REGION_CODE IN VARCHAR2,
54 X_NESTED_REGION_APPL_ID IN NUMBER,
55 X_MENU_NAME IN VARCHAR2,
56 X_FLEXFIELD_NAME IN VARCHAR2,
57 X_FLEXFIELD_APPLICATION_ID IN NUMBER,
58 X_TABULAR_FUNCTION_CODE IN VARCHAR2,
59 X_TIP_TYPE IN VARCHAR2,
60 X_TIP_MESSAGE_NAME IN VARCHAR2,
61 X_TIP_MESSAGE_APPLICATION_ID IN NUMBER,
62 X_FLEX_SEGMENT_LIST IN VARCHAR2,
63 X_ENTITY_ID IN VARCHAR2,
64 X_ANCHOR IN VARCHAR2,
65 X_POPLIST_VIEW_USAGE_NAME IN VARCHAR2,
66 X_USER_CUSTOMIZABLE IN VARCHAR2 := NULL,
67 X_ADMIN_CUSTOMIZABLE IN VARCHAR2 := 'Y',
68 X_INVOKE_FUNCTION_NAME IN VARCHAR2 := NULL,
69 X_ATTRIBUTE_LABEL_SHORT IN VARCHAR2 := NULL,
70 X_EXPANSION IN NUMBER := NULL,
71 X_ALS_MAX_LENGTH IN NUMBER := NULL,
72 X_SORTBY_VIEW_ATTRIBUTE_NAME IN VARCHAR2 := NULL,
73 X_ICX_CUSTOM_CALL IN VARCHAR2 :=NULL,
74 X_INITIAL_SORT_SEQUENCE IN VARCHAR2 := NULL,
75 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER := NULL,
76 X_CUSTOMIZATION_CODE IN VARCHAR2 := NULL,
77 X_CREATION_DATE in DATE,
78 X_CREATED_BY in NUMBER,
79 X_LAST_UPDATE_DATE in DATE,
80 X_LAST_UPDATED_BY in NUMBER,
81 X_LAST_UPDATE_LOGIN in NUMBER,
82 X_ATTRIBUTE_CATEGORY in VARCHAR2,
83 X_ATTRIBUTE1 in VARCHAR2,
84 X_ATTRIBUTE2 in VARCHAR2,
85 X_ATTRIBUTE3 in VARCHAR2,
86 X_ATTRIBUTE4 in VARCHAR2,
87 X_ATTRIBUTE5 in VARCHAR2,
88 X_ATTRIBUTE6 in VARCHAR2,
89 X_ATTRIBUTE7 in VARCHAR2,
90 X_ATTRIBUTE8 in VARCHAR2,
91 X_ATTRIBUTE9 in VARCHAR2,
92 X_ATTRIBUTE10 in VARCHAR2,
93 X_ATTRIBUTE11 in VARCHAR2,
94 X_ATTRIBUTE12 in VARCHAR2,
95 X_ATTRIBUTE13 in VARCHAR2,
96 X_ATTRIBUTE14 in VARCHAR2,
97 X_ATTRIBUTE15 in VARCHAR2
98 ) is
99 cursor C is select ROWID from AK_REGION_ITEMS
100 where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
101 and REGION_CODE = X_REGION_CODE
102 and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
103 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
104 begin
105 insert into AK_REGION_ITEMS (
106 REGION_APPLICATION_ID,
107 REGION_CODE,
108 ATTRIBUTE_APPLICATION_ID,
109 ATTRIBUTE_CODE,
110 DISPLAY_SEQUENCE,
111 NODE_DISPLAY_FLAG,
112 NODE_QUERY_FLAG,
113 ATTRIBUTE_LABEL_LENGTH,
114 BOLD,
115 ITALIC,
116 VERTICAL_ALIGNMENT,
117 HORIZONTAL_ALIGNMENT,
118 ITEM_STYLE,
119 OBJECT_ATTRIBUTE_FLAG,
120 SECURITY_CODE,
121 UPDATE_FLAG,
122 REQUIRED_FLAG,
123 DISPLAY_VALUE_LENGTH,
124 LOV_REGION_APPLICATION_ID,
125 LOV_REGION_CODE,
126 LOV_FOREIGN_KEY_NAME,
127 LOV_ATTRIBUTE_APPLICATION_ID,
128 LOV_ATTRIBUTE_CODE,
129 LOV_DEFAULT_FLAG,
130 REGION_DEFAULTING_API_PKG,
131 REGION_DEFAULTING_API_PROC,
132 REGION_VALIDATION_API_PKG,
133 REGION_VALIDATION_API_PROC,
134 ORDER_SEQUENCE,
135 ORDER_DIRECTION,
136 DEFAULT_VALUE_VARCHAR2,
137 DEFAULT_VALUE_NUMBER,
138 DEFAULT_VALUE_DATE,
139 DISPLAY_HEIGHT,
140 SUBMIT,
141 ENCRYPT,
142 VIEW_USAGE_NAME,
143 VIEW_ATTRIBUTE_NAME,
144 CSS_CLASS_NAME,
145 CSS_LABEL_CLASS_NAME,
146 URL,
147 POPLIST_VIEWOBJECT,
148 POPLIST_DISPLAY_ATTRIBUTE,
149 POPLIST_VALUE_ATTRIBUTE,
150 IMAGE_FILE_NAME,
151 NESTED_REGION_CODE,
152 NESTED_REGION_APPLICATION_ID,
153 ITEM_NAME,
154 MENU_NAME,
155 FLEXFIELD_NAME,
156 FLEXFIELD_APPLICATION_ID,
157 TABULAR_FUNCTION_CODE,
158 TIP_TYPE,
159 TIP_MESSAGE_NAME,
160 TIP_MESSAGE_APPLICATION_ID,
161 FLEX_SEGMENT_LIST,
162 ENTITY_ID,
163 ANCHOR,
164 POPLIST_VIEW_USAGE_NAME,
165 USER_CUSTOMIZABLE,
166 ADMIN_CUSTOMIZABLE,
167 INVOKE_FUNCTION_NAME,
168 EXPANSION,
169 ALS_MAX_LENGTH,
170 SORTBY_VIEW_ATTRIBUTE_NAME,
171 ICX_CUSTOM_CALL,
172 INITIAL_SORT_SEQUENCE,
173 CUSTOMIZATION_APPLICATION_ID,
174 CUSTOMIZATION_CODE,
175 CREATION_DATE,
176 CREATED_BY,
177 LAST_UPDATE_DATE,
178 LAST_UPDATED_BY,
179 LAST_UPDATE_LOGIN,
180 ATTRIBUTE_CATEGORY,
181 ATTRIBUTE1,
182 ATTRIBUTE2,
183 ATTRIBUTE3,
184 ATTRIBUTE4,
185 ATTRIBUTE5,
186 ATTRIBUTE6,
187 ATTRIBUTE7,
188 ATTRIBUTE8,
189 ATTRIBUTE9,
190 ATTRIBUTE10,
191 ATTRIBUTE11,
192 ATTRIBUTE12,
193 ATTRIBUTE13,
194 ATTRIBUTE14,
195 ATTRIBUTE15
196 ) values (
197 X_REGION_APPLICATION_ID,
198 X_REGION_CODE,
199 X_ATTRIBUTE_APPLICATION_ID,
200 X_ATTRIBUTE_CODE,
201 X_DISPLAY_SEQUENCE,
202 X_NODE_DISPLAY_FLAG,
203 X_NODE_QUERY_FLAG,
204 X_ATTRIBUTE_LABEL_LENGTH,
205 X_BOLD,
206 X_ITALIC,
207 X_VERTICAL_ALIGNMENT,
208 X_HORIZONTAL_ALIGNMENT,
209 X_ITEM_STYLE,
210 X_OBJECT_ATTRIBUTE_FLAG,
211 X_SECURITY_CODE,
212 X_UPDATE_FLAG,
213 X_REQUIRED_FLAG,
214 X_DISPLAY_VALUE_LENGTH,
215 X_LOV_REGION_APPLICATION_ID,
216 X_LOV_REGION_CODE,
217 X_LOV_FOREIGN_KEY_NAME,
218 X_LOV_ATTRIBUTE_APPLICATION_ID,
219 X_LOV_ATTRIBUTE_CODE,
220 X_LOV_DEFAULT_FLAG,
221 X_REGION_DEFAULTING_API_PKG,
222 X_REGION_DEFAULTING_API_PROC,
223 X_REGION_VALIDATION_API_PKG,
224 X_REGION_VALIDATION_API_PROC,
225 X_ORDER_SEQUENCE,
226 X_ORDER_DIRECTION,
227 X_DEFAULT_VALUE_VARCHAR2,
228 X_DEFAULT_VALUE_NUMBER,
229 X_DEFAULT_VALUE_DATE,
230 X_DISPLAY_HEIGHT,
231 X_SUBMIT,
232 X_ENCRYPT,
233 X_VIEW_USAGE_NAME,
234 X_VIEW_ATTRIBUTE_NAME,
235 X_CSS_CLASS_NAME,
236 X_CSS_LABEL_CLASS_NAME,
237 X_URL,
238 X_POPLIST_VIEWOBJECT,
239 X_POPLIST_DISPLAY_ATTRIBUTE,
240 X_POPLIST_VALUE_ATTRIBUTE,
241 X_IMAGE_FILE_NAME,
242 X_NESTED_REGION_CODE,
243 X_NESTED_REGION_APPL_ID,
244 X_ITEM_NAME,
245 X_MENU_NAME,
246 X_FLEXFIELD_NAME,
247 X_FLEXFIELD_APPLICATION_ID,
248 X_TABULAR_FUNCTION_CODE,
249 X_TIP_TYPE,
250 X_TIP_MESSAGE_NAME,
251 X_TIP_MESSAGE_APPLICATION_ID,
252 X_FLEX_SEGMENT_LIST,
253 X_ENTITY_ID,
254 X_ANCHOR,
255 X_POPLIST_VIEW_USAGE_NAME,
256 X_USER_CUSTOMIZABLE,
257 X_ADMIN_CUSTOMIZABLE,
258 X_INVOKE_FUNCTION_NAME,
259 X_EXPANSION,
260 X_ALS_MAX_LENGTH,
261 X_SORTBY_VIEW_ATTRIBUTE_NAME,
262 X_ICX_CUSTOM_CALL,
263 X_INITIAL_SORT_SEQUENCE,
264 X_CUSTOMIZATION_APPLICATION_ID,
265 X_CUSTOMIZATION_CODE,
266 X_CREATION_DATE,
267 X_CREATED_BY,
268 X_LAST_UPDATE_DATE,
269 X_LAST_UPDATED_BY,
270 X_LAST_UPDATE_LOGIN,
271 X_ATTRIBUTE_CATEGORY,
272 X_ATTRIBUTE1,
273 X_ATTRIBUTE2,
274 X_ATTRIBUTE3,
275 X_ATTRIBUTE4,
276 X_ATTRIBUTE5,
277 X_ATTRIBUTE6,
278 X_ATTRIBUTE7,
279 X_ATTRIBUTE8,
280 X_ATTRIBUTE9,
281 X_ATTRIBUTE10,
282 X_ATTRIBUTE11,
283 X_ATTRIBUTE12,
284 X_ATTRIBUTE13,
285 X_ATTRIBUTE14,
286 X_ATTRIBUTE15
287 );
288 
289 open c;
290 fetch c into X_ROWID;
291 if (c%notfound) then
292 close c;
293 raise no_data_found;
294 end if;
295 close c;
296 
297 insert into AK_REGION_ITEMS_TL (
298 REGION_APPLICATION_ID,
299 REGION_CODE,
300 ATTRIBUTE_APPLICATION_ID,
301 ATTRIBUTE_CODE,
302 LANGUAGE,
303 ATTRIBUTE_LABEL_LONG,
304 ATTRIBUTE_LABEL_SHORT,
305 DESCRIPTION,
306 SOURCE_LANG,
307 CREATED_BY,
308 CREATION_DATE,
309 LAST_UPDATED_BY,
310 LAST_UPDATE_DATE,
311 LAST_UPDATE_LOGIN
312 ) select
313 X_REGION_APPLICATION_ID,
314 X_REGION_CODE,
315 X_ATTRIBUTE_APPLICATION_ID,
316 X_ATTRIBUTE_CODE,
317 L.LANGUAGE_CODE,
318 X_ATTRIBUTE_LABEL_LONG,
319 X_ATTRIBUTE_LABEL_SHORT,
320 X_DESCRIPTION,
321 userenv('LANG'),
322 X_CREATED_BY,
323 X_CREATION_DATE,
324 X_LAST_UPDATED_BY,
325 X_LAST_UPDATE_DATE,
326 X_LAST_UPDATE_LOGIN
327 from FND_LANGUAGES L
328 where L.INSTALLED_FLAG in ('I', 'B')
329 and not exists
330 (select NULL
331 from AK_REGION_ITEMS_TL T
332 where T.REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
333 and T.REGION_CODE = X_REGION_CODE
334 and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
335 and T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
336 and T.LANGUAGE = L.LANGUAGE_CODE);
337 end INSERT_ROW;
338 
339 procedure LOCK_ROW (
340 X_REGION_APPLICATION_ID in NUMBER,
341 X_REGION_CODE in VARCHAR2,
342 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
343 X_ATTRIBUTE_CODE in VARCHAR2,
344 X_OBJECT_ATTRIBUTE_FLAG in VARCHAR2,
345 X_ATTRIBUTE_CATEGORY in VARCHAR2,
346 X_ATTRIBUTE1 in VARCHAR2,
347 X_ATTRIBUTE2 in VARCHAR2,
348 X_ATTRIBUTE3 in VARCHAR2,
349 X_ATTRIBUTE4 in VARCHAR2,
350 X_ATTRIBUTE5 in VARCHAR2,
351 X_ATTRIBUTE6 in VARCHAR2,
352 X_ATTRIBUTE7 in VARCHAR2,
353 X_ATTRIBUTE8 in VARCHAR2,
354 X_ATTRIBUTE9 in VARCHAR2,
355 X_ATTRIBUTE10 in VARCHAR2,
356 X_ATTRIBUTE11 in VARCHAR2,
357 X_ATTRIBUTE12 in VARCHAR2,
358 X_ATTRIBUTE13 in VARCHAR2,
359 X_ATTRIBUTE14 in VARCHAR2,
360 X_ATTRIBUTE15 in VARCHAR2,
361 X_DISPLAY_SEQUENCE in NUMBER,
362 X_NODE_DISPLAY_FLAG in VARCHAR2,
363 X_NODE_QUERY_FLAG in VARCHAR2,
364 X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
365 X_BOLD in VARCHAR2,
366 X_ITALIC in VARCHAR2,
367 X_VERTICAL_ALIGNMENT in VARCHAR2,
368 X_HORIZONTAL_ALIGNMENT in VARCHAR2,
369 X_ITEM_STYLE in VARCHAR2,
370 X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
371 X_DESCRIPTION IN VARCHAR2,
372 X_SECURITY_CODE in VARCHAR2,
373 X_UPDATE_FLAG in VARCHAR2,
374 X_REQUIRED_FLAG in VARCHAR2,
375 X_DISPLAY_VALUE_LENGTH in NUMBER,
376 X_LOV_REGION_APPLICATION_ID in NUMBER,
377 X_LOV_REGION_CODE in VARCHAR2,
378 X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
379 X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
380 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
381 X_LOV_DEFAULT_FLAG in VARCHAR2,
382 X_REGION_DEFAULTING_API_PKG in VARCHAR2,
383 X_REGION_DEFAULTING_API_PROC in VARCHAR2,
384 X_REGION_VALIDATION_API_PKG in VARCHAR2,
385 X_REGION_VALIDATION_API_PROC in VARCHAR2,
386 X_ORDER_SEQUENCE in NUMBER,
387 X_ORDER_DIRECTION in VARCHAR2,
388 X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
389 X_DEFAULT_VALUE_NUMBER in NUMBER,
390 X_DEFAULT_VALUE_DATE in DATE,
391 X_ITEM_NAME in VARCHAR2,
392 X_DISPLAY_HEIGHT IN NUMBER,
393 X_SUBMIT IN VARCHAR2,
394 X_ENCRYPT IN VARCHAR2,
395 X_VIEW_USAGE_NAME IN VARCHAR2,
396 X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
397 X_CSS_CLASS_NAME IN VARCHAR2,
398 X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
399 X_URL IN VARCHAR2,
400 X_POPLIST_VIEWOBJECT IN VARCHAR2,
401 X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
402 X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
403 X_IMAGE_FILE_NAME IN VARCHAR2,
404 X_NESTED_REGION_CODE IN VARCHAR2,
405 X_NESTED_REGION_APPL_ID IN NUMBER,
406 X_MENU_NAME IN VARCHAR2,
407 X_FLEXFIELD_NAME IN VARCHAR2,
408 X_FLEXFIELD_APPLICATION_ID NUMBER,
409 X_TABULAR_FUNCTION_CODE IN VARCHAR2,
410 X_TIP_TYPE IN VARCHAR2,
411 X_TIP_MESSAGE_NAME VARCHAR2,
412 X_TIP_MESSAGE_APPLICATION_ID NUMBER,
413 X_FLEX_SEGMENT_LIST VARCHAR2,
414 X_ENTITY_ID VARCHAR2,
415 X_ANCHOR VARCHAR2,
416 X_POPLIST_VIEW_USAGE_NAME VARCHAR2,
417 X_USER_CUSTOMIZABLE VARCHAR2,
418 X_ADMIN_CUSTOMIZABLE VARCHAR2,
419 X_INVOKE_FUNCTION_NAME VARCHAR2,
420 X_ATTRIBUTE_LABEL_SHORT VARCHAR2,
421 X_EXPANSION NUMBER,
422 X_ALS_MAX_LENGTH NUMBER,
423 X_SORTBY_VIEW_ATTRIBUTE_NAME VARCHAR2,
424 X_ICX_CUSTOM_CALL VARCHAR2,
425 X_INITIAL_SORT_SEQUENCE VARCHAR2
426 ) is
427 cursor c is select
428 OBJECT_ATTRIBUTE_FLAG,
429 ATTRIBUTE_CATEGORY,
430 ATTRIBUTE1,
431 ATTRIBUTE2,
432 ATTRIBUTE3,
433 ATTRIBUTE4,
434 ATTRIBUTE5,
435 ATTRIBUTE6,
436 ATTRIBUTE7,
437 ATTRIBUTE8,
438 ATTRIBUTE9,
439 ATTRIBUTE10,
440 ATTRIBUTE11,
441 ATTRIBUTE12,
442 ATTRIBUTE13,
443 ATTRIBUTE14,
444 ATTRIBUTE15,
445 DISPLAY_SEQUENCE,
446 NODE_DISPLAY_FLAG,
447 NODE_QUERY_FLAG,
448 ATTRIBUTE_LABEL_LENGTH,
449 BOLD,
450 ITALIC,
451 VERTICAL_ALIGNMENT,
452 HORIZONTAL_ALIGNMENT,
453 SECURITY_CODE,
454 UPDATE_FLAG,
455 REQUIRED_FLAG,
456 DISPLAY_VALUE_LENGTH,
457 LOV_REGION_APPLICATION_ID,
458 LOV_REGION_CODE,
459 LOV_FOREIGN_KEY_NAME,
460 LOV_ATTRIBUTE_APPLICATION_ID,
461 LOV_ATTRIBUTE_CODE,
462 LOV_DEFAULT_FLAG,
463 REGION_DEFAULTING_API_PKG,
464 REGION_DEFAULTING_API_PROC,
465 REGION_VALIDATION_API_PKG,
466 REGION_VALIDATION_API_PROC,
467 ORDER_SEQUENCE,
468 ORDER_DIRECTION,
469 DEFAULT_VALUE_VARCHAR2,
470 DEFAULT_VALUE_NUMBER,
471 DEFAULT_VALUE_DATE,
472 ITEM_STYLE,
473 DISPLAY_HEIGHT,
474 SUBMIT,
475 ENCRYPT,
476 VIEW_USAGE_NAME,
477 VIEW_ATTRIBUTE_NAME,
478 CSS_CLASS_NAME,
479 CSS_LABEL_CLASS_NAME,
480 URL,
481 POPLIST_VIEWOBJECT,
482 POPLIST_DISPLAY_ATTRIBUTE,
483 POPLIST_VALUE_ATTRIBUTE,
484 IMAGE_FILE_NAME,
485 NESTED_REGION_CODE,
486 NESTED_REGION_APPLICATION_ID,
487 ITEM_NAME,
488 MENU_NAME,
489 FLEXFIELD_NAME,
490 FLEXFIELD_APPLICATION_ID,
491 TABULAR_FUNCTION_CODE,
492 TIP_TYPE,
493 TIP_MESSAGE_NAME,
494 TIP_MESSAGE_APPLICATION_ID,
495 FLEX_SEGMENT_LIST,
496 ENTITY_ID,
497 ANCHOR,
498 POPLIST_VIEW_USAGE_NAME,
499 USER_CUSTOMIZABLE,
500 ADMIN_CUSTOMIZABLE,
501 INVOKE_FUNCTION_NAME,
502 EXPANSION,
503 ALS_MAX_LENGTH,
507 from AK_REGION_ITEMS
504 SORTBY_VIEW_ATTRIBUTE_NAME,
505 ICX_CUSTOM_CALL,
506 INITIAL_SORT_SEQUENCE
508 where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
509 and REGION_CODE = X_REGION_CODE
510 and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
511 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
512 for update of REGION_APPLICATION_ID nowait;
513 recinfo c%rowtype;
514 
515 cursor c1 is select
516 ATTRIBUTE_LABEL_LONG,
517 ATTRIBUTE_LABEL_SHORT,
518 DESCRIPTION
519 from AK_REGION_ITEMS_TL
520 where REGION_CODE = X_REGION_CODE
521 and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
522 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
523 and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
524 and LANGUAGE = userenv('LANG')
525 for update of REGION_CODE nowait;
526 tlinfo c1%rowtype;
527 
528 begin
529 open c;
530 fetch c into recinfo;
531 if (c%notfound) then
532 close c;
533 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
534 app_exception.raise_exception;
535 end if;
536 close c;
537 if ( (recinfo.OBJECT_ATTRIBUTE_FLAG = X_OBJECT_ATTRIBUTE_FLAG)
538 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
539 OR ((recinfo.ATTRIBUTE_CATEGORY is null)
540 AND (X_ATTRIBUTE_CATEGORY is null)))
541 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
542 OR ((recinfo.ATTRIBUTE1 is null)
543 AND (X_ATTRIBUTE1 is null)))
544 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
545 OR ((recinfo.ATTRIBUTE2 is null)
546 AND (X_ATTRIBUTE2 is null)))
547 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
548 OR ((recinfo.ATTRIBUTE3 is null)
549 AND (X_ATTRIBUTE3 is null)))
550 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
551 OR ((recinfo.ATTRIBUTE4 is null)
552 AND (X_ATTRIBUTE4 is null)))
553 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
554 OR ((recinfo.ATTRIBUTE5 is null)
555 AND (X_ATTRIBUTE5 is null)))
556 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
557 OR ((recinfo.ATTRIBUTE6 is null)
558 AND (X_ATTRIBUTE6 is null)))
559 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
560 OR ((recinfo.ATTRIBUTE7 is null)
561 AND (X_ATTRIBUTE7 is null)))
562 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
563 OR ((recinfo.ATTRIBUTE8 is null)
564 AND (X_ATTRIBUTE8 is null)))
565 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
566 OR ((recinfo.ATTRIBUTE9 is null)
567 AND (X_ATTRIBUTE9 is null)))
568 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
569 OR ((recinfo.ATTRIBUTE10 is null)
570 AND (X_ATTRIBUTE10 is null)))
571 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
572 OR ((recinfo.ATTRIBUTE11 is null)
573 AND (X_ATTRIBUTE11 is null)))
574 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
575 OR ((recinfo.ATTRIBUTE12 is null)
576 AND (X_ATTRIBUTE12 is null)))
577 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
578 OR ((recinfo.ATTRIBUTE13 is null)
579 AND (X_ATTRIBUTE13 is null)))
580 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
581 OR ((recinfo.ATTRIBUTE14 is null)
582 AND (X_ATTRIBUTE14 is null)))
583 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
584 OR ((recinfo.ATTRIBUTE15 is null)
585 AND (X_ATTRIBUTE15 is null)))
586 AND (recinfo.DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE)
587 AND (recinfo.NODE_DISPLAY_FLAG = X_NODE_DISPLAY_FLAG)
588 AND (recinfo.NODE_QUERY_FLAG = X_NODE_QUERY_FLAG)
589 AND (recinfo.ATTRIBUTE_LABEL_LENGTH = X_ATTRIBUTE_LABEL_LENGTH)
590 AND (recinfo.BOLD = X_BOLD)
591 AND (recinfo.ITALIC = X_ITALIC)
592 AND (recinfo.VERTICAL_ALIGNMENT = X_VERTICAL_ALIGNMENT)
593 AND (recinfo.HORIZONTAL_ALIGNMENT = X_HORIZONTAL_ALIGNMENT)
594 and ((recinfo.SECURITY_CODE = x_SECURITY_CODE)
595 or ((recinfo.SECURITY_CODE is null)
596 and (x_SECURITY_CODE is null)))
597 AND (recinfo.UPDATE_FLAG = X_UPDATE_FLAG)
598 AND (recinfo.REQUIRED_FLAG = X_REQUIRED_FLAG)
599 AND (recinfo.DISPLAY_VALUE_LENGTH = X_DISPLAY_VALUE_LENGTH)
600 and ((recinfo.LOV_REGION_APPLICATION_ID = x_LOV_REGION_APPLICATION_ID)
601 or ((recinfo.LOV_REGION_APPLICATION_ID is null)
602 and (x_LOV_REGION_APPLICATION_ID is null)))
603 and ((recinfo.LOV_REGION_CODE = x_LOV_REGION_CODE)
604 or ((recinfo.LOV_REGION_CODE is null)
605 and (x_LOV_REGION_CODE is null)))
606 and ((recinfo.LOV_FOREIGN_KEY_NAME = x_LOV_FOREIGN_KEY_NAME)
607 or ((recinfo.LOV_FOREIGN_KEY_NAME is null)
608 and (x_LOV_FOREIGN_KEY_NAME is null)))
609 and ((recinfo.LOV_ATTRIBUTE_APPLICATION_ID = x_LOV_ATTRIBUTE_APPLICATION_ID)
610 or ((recinfo.LOV_ATTRIBUTE_APPLICATION_ID is null)
611 and (x_LOV_ATTRIBUTE_APPLICATION_ID is null)))
612 and ((recinfo.LOV_ATTRIBUTE_CODE = x_LOV_ATTRIBUTE_CODE)
613 or ((recinfo.LOV_ATTRIBUTE_CODE is null)
614 and (x_LOV_ATTRIBUTE_CODE is null)))
615 and ((recinfo.LOV_DEFAULT_FLAG = x_LOV_DEFAULT_FLAG)
616 or ((recinfo.LOV_DEFAULT_FLAG is null)
617 and (x_LOV_DEFAULT_FLAG is null)))
618 and ((recinfo.REGION_DEFAULTING_API_PKG = x_REGION_DEFAULTING_API_PKG)
619 or ((recinfo.REGION_DEFAULTING_API_PKG is null)
620 and (x_REGION_DEFAULTING_API_PKG is null)))
621 and ((recinfo.REGION_DEFAULTING_API_PROC = x_REGION_DEFAULTING_API_PROC)
622 or ((recinfo.REGION_DEFAULTING_API_PROC is null)
623 and (x_REGION_DEFAULTING_API_PROC is null)))
624 and ((recinfo.REGION_VALIDATION_API_PKG = x_REGION_VALIDATION_API_PKG)
625 or ((recinfo.REGION_VALIDATION_API_PKG is null)
626 and (x_REGION_VALIDATION_API_PKG is null)))
627 and ((recinfo.REGION_VALIDATION_API_PROC = x_REGION_VALIDATION_API_PROC)
628 or ((recinfo.REGION_VALIDATION_API_PROC is null)
629 and (x_REGION_VALIDATION_API_PROC is null)))
630 and ((recinfo.ORDER_SEQUENCE = x_ORDER_SEQUENCE)
631 or ((recinfo.ORDER_SEQUENCE is null)
635 and (x_ORDER_DIRECTION is null)))
632 and (x_ORDER_SEQUENCE is null)))
633 and ((recinfo.ORDER_DIRECTION = x_ORDER_DIRECTION)
634 or ((recinfo.ORDER_DIRECTION is null)
636 and ((recinfo.DEFAULT_VALUE_VARCHAR2 = x_DEFAULT_VALUE_VARCHAR2)
637 or ((recinfo.DEFAULT_VALUE_VARCHAR2 is null)
638 and (x_DEFAULT_VALUE_VARCHAR2 is null)))
639 and ((recinfo.DEFAULT_VALUE_NUMBER = x_DEFAULT_VALUE_NUMBER)
640 or ((recinfo.DEFAULT_VALUE_NUMBER is null)
641 and (x_DEFAULT_VALUE_NUMBER is null)))
642 and ((recinfo.DEFAULT_VALUE_DATE = x_DEFAULT_VALUE_DATE)
643 or ((recinfo.DEFAULT_VALUE_DATE is null)
644 and (x_DEFAULT_VALUE_DATE is null)))
645 AND (recinfo.ITEM_STYLE = X_ITEM_STYLE)
646 and ((recinfo.DISPLAY_HEIGHT = X_DISPLAY_HEIGHT)
647 or ((recinfo.DISPLAY_HEIGHT is null)
648 and (X_DISPLAY_HEIGHT is null)))
649 and ((recinfo.SUBMIT = X_SUBMIT)
650 or ((recinfo.SUBMIT is null)
651 and (X_SUBMIT is null)))
652 and ((recinfo.ENCRYPT = X_ENCRYPT)
653 or ((recinfo.ENCRYPT is null)
654 and (X_ENCRYPT is null)))
655 and ((recinfo.VIEW_USAGE_NAME = X_VIEW_USAGE_NAME)
656 or ((recinfo.VIEW_USAGE_NAME is null)
657 and (X_VIEW_USAGE_NAME is null)))
658 and ((recinfo.VIEW_ATTRIBUTE_NAME = X_VIEW_ATTRIBUTE_NAME)
659 or ((recinfo.VIEW_ATTRIBUTE_NAME is null)
660 and (X_VIEW_ATTRIBUTE_NAME is null)))
661 and ((recinfo.CSS_CLASS_NAME = X_CSS_CLASS_NAME)
662 or ((recinfo.CSS_CLASS_NAME is null)
663 and (X_CSS_CLASS_NAME is null)))
664 and ((recinfo.CSS_LABEL_CLASS_NAME = X_CSS_LABEL_CLASS_NAME)
665 or ((recinfo.CSS_LABEL_CLASS_NAME is null)
666 and (X_CSS_LABEL_CLASS_NAME is null)))
667 and ((recinfo.URL = X_URL)
668 or ((recinfo.URL is null)
669 and (X_URL is null)))
670 and ((recinfo.POPLIST_VIEWOBJECT = X_POPLIST_VIEWOBJECT)
671 or ((recinfo.POPLIST_VIEWOBJECT is null)
672 and (X_POPLIST_VIEWOBJECT is null)))
673 and ((recinfo.POPLIST_DISPLAY_ATTRIBUTE = X_POPLIST_DISPLAY_ATTRIBUTE)
674 or ((recinfo.POPLIST_DISPLAY_ATTRIBUTE is null)
675 and (X_POPLIST_DISPLAY_ATTRIBUTE is null)))
676 and ((recinfo.POPLIST_VALUE_ATTRIBUTE = X_POPLIST_VALUE_ATTRIBUTE)
677 or ((recinfo.POPLIST_VALUE_ATTRIBUTE is null)
678 and (X_POPLIST_VALUE_ATTRIBUTE is null)))
679 and ((recinfo.IMAGE_FILE_NAME = X_IMAGE_FILE_NAME)
680 or ((recinfo.IMAGE_FILE_NAME is null)
681 and (X_IMAGE_FILE_NAME is null)))
682 and ((recinfo.NESTED_REGION_APPLICATION_ID = X_NESTED_REGION_APPL_ID)
683 or ((recinfo.NESTED_REGION_APPLICATION_ID is null)
684 and (X_NESTED_REGION_APPL_ID is null)))
685 and ((recinfo.NESTED_REGION_CODE = X_NESTED_REGION_CODE)
686 or ((recinfo.NESTED_REGION_CODE is null)
687 and (X_NESTED_REGION_CODE is null)))
688 and ((recinfo.ITEM_NAME = X_ITEM_NAME)
689 or ((recinfo.ITEM_NAME is null)
690 and (X_ITEM_NAME is null)))
691 and ((recinfo.MENU_NAME = X_MENU_NAME)
692 or ((recinfo.MENU_NAME is null)
693 and (X_MENU_NAME is null)))
694 and ((recinfo.FLEXFIELD_NAME = X_FLEXFIELD_NAME)
695 or ((recinfo.FLEXFIELD_NAME is null)
696 and (X_FLEXFIELD_NAME is null)))
697 and ((recinfo.FLEXFIELD_APPLICATION_ID = X_FLEXFIELD_APPLICATION_ID)
698 or ((recinfo.FLEXFIELD_APPLICATION_ID is null)
699 and (X_FLEXFIELD_APPLICATION_ID is null)))
700 and ((recinfo.TABULAR_FUNCTION_CODE = X_TABULAR_FUNCTION_CODE)
701 or ((recinfo.TABULAR_FUNCTION_CODE is null)
702 and (X_TABULAR_FUNCTION_CODE is null)))
703 and ((recinfo.TIP_TYPE = X_TIP_TYPE)
704 or ((recinfo.TIP_TYPE is null)
705 and (X_TIP_TYPE is null)))
706 and ((recinfo.TIP_MESSAGE_NAME = X_TIP_MESSAGE_NAME)
707 or ((recinfo.TIP_MESSAGE_NAME is null)
708 and (X_TIP_MESSAGE_NAME is null)))
709 and ((recinfo.TIP_MESSAGE_APPLICATION_ID = X_TIP_MESSAGE_APPLICATION_ID)
710 or ((recinfo.TIP_MESSAGE_APPLICATION_ID is null)
711 and (X_TIP_MESSAGE_APPLICATION_ID is null)))
712 and ((recinfo.FLEX_SEGMENT_LIST = X_FLEX_SEGMENT_LIST)
713 or ((recinfo.FLEX_SEGMENT_LIST is null)
714 and (X_FLEX_SEGMENT_LIST is null)))
715 and ((recinfo.ENTITY_ID = X_ENTITY_ID)
716 or ((recinfo.ENTITY_ID is null)
717 and (X_ENTITY_ID is null)))
718 and ((recinfo.ANCHOR = X_ANCHOR)
719 or ((recinfo.ANCHOR is null)
720 and (X_ANCHOR is null)))
721 and ((recinfo.POPLIST_VIEW_USAGE_NAME = X_POPLIST_VIEW_USAGE_NAME)
722 or ((recinfo.POPLIST_VIEW_USAGE_NAME is null)
723 and (X_POPLIST_VIEW_USAGE_NAME is null)))
724 and ((recinfo.USER_CUSTOMIZABLE = X_USER_CUSTOMIZABLE)
725 or ((recinfo.USER_CUSTOMIZABLE is null)
726 and (X_USER_CUSTOMIZABLE is null)))
727 and ((recinfo.ADMIN_CUSTOMIZABLE = X_ADMIN_CUSTOMIZABLE)
728 or ((recinfo.ADMIN_CUSTOMIZABLE is null)
729 and (X_ADMIN_CUSTOMIZABLE is null)))
730 and ((recinfo.INVOKE_FUNCTION_NAME = X_INVOKE_FUNCTION_NAME)
731 or ((recinfo.INVOKE_FUNCTION_NAME is null)
732 and (X_INVOKE_FUNCTION_NAME is null)))
733 and ((recinfo.EXPANSION = X_EXPANSION)
734 or ((recinfo.EXPANSION is null)
735 and (X_EXPANSION is null)))
736 and ((recinfo.ALS_MAX_LENGTH = X_ALS_MAX_LENGTH)
737 or ((recinfo.ALS_MAX_LENGTH is null)
738 and (X_ALS_MAX_LENGTH is null)))
739 and ((recinfo.SORTBY_VIEW_ATTRIBUTE_NAME = X_SORTBY_VIEW_ATTRIBUTE_NAME)
740 or ((recinfo.SORTBY_VIEW_ATTRIBUTE_NAME is null)
741 and (X_SORTBY_VIEW_ATTRIBUTE_NAME is null)))
742 and ((recinfo.ICX_CUSTOM_CALL = X_ICX_CUSTOM_CALL)
743 or ((recinfo.ICX_CUSTOM_CALL is null)
744 and (X_ICX_CUSTOM_CALL is null)))
745 and ((recinfo.INITIAL_SORT_SEQUENCE= X_INITIAL_SORT_SEQUENCE)
746 or ((recinfo.INITIAL_SORT_SEQUENCE is null)
750 else
747 and (X_INITIAL_SORT_SEQUENCE is null)))
748 ) then
749 null;
751 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
752 app_exception.raise_exception;
753 end if;
754 
755 open c1;
756 fetch c1 into tlinfo;
757 if (c1%notfound) then
758 close c1;
759 return;
760 end if;
761 close c1;
762 
763 if ((tlinfo.attribute_label_long = X_attribute_label_long)
764 OR ((tlinfo.attribute_label_long is null)
765 AND (X_attribute_label_long is null)))
766 and ((tlinfo.attribute_label_short = X_attribute_label_short)
767 OR ((tlinfo.attribute_label_short is null)
768 AND (X_attribute_label_short is null)))
769 and ((tlinfo.description = X_description)
770 OR ((tlinfo.description is null)
771 AND (X_description is null))) then
772 null;
773 else
774 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
775 app_exception.raise_exception;
776 end if;
777 return;
778 end LOCK_ROW;
779 
780 procedure UPDATE_ROW (
781 X_REGION_APPLICATION_ID in NUMBER,
782 X_REGION_CODE in VARCHAR2,
783 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
784 X_ATTRIBUTE_CODE in VARCHAR2,
785 X_DISPLAY_SEQUENCE in NUMBER,
786 X_NODE_DISPLAY_FLAG in VARCHAR2,
787 X_NODE_QUERY_FLAG in VARCHAR2,
788 X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
789 X_BOLD in VARCHAR2,
790 X_ITALIC in VARCHAR2,
791 X_VERTICAL_ALIGNMENT in VARCHAR2,
792 X_HORIZONTAL_ALIGNMENT in VARCHAR2,
793 X_ITEM_STYLE in VARCHAR2,
794 X_OBJECT_ATTRIBUTE_FLAG in VARCHAR2,
795 X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
796 X_DESCRIPTION IN VARCHAR2,
797 X_SECURITY_CODE in VARCHAR2,
798 X_UPDATE_FLAG in VARCHAR2,
799 X_REQUIRED_FLAG in VARCHAR2,
800 X_DISPLAY_VALUE_LENGTH in NUMBER,
801 X_LOV_REGION_APPLICATION_ID in NUMBER,
802 X_LOV_REGION_CODE in VARCHAR2,
803 X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
804 X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
805 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
806 X_LOV_DEFAULT_FLAG in VARCHAR2,
807 X_REGION_DEFAULTING_API_PKG in VARCHAR2,
808 X_REGION_DEFAULTING_API_PROC in VARCHAR2,
809 X_REGION_VALIDATION_API_PKG in VARCHAR2,
810 X_REGION_VALIDATION_API_PROC in VARCHAR2,
811 X_ORDER_SEQUENCE in NUMBER,
812 X_ORDER_DIRECTION in VARCHAR2,
813 X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
814 X_DEFAULT_VALUE_NUMBER in NUMBER,
815 X_DEFAULT_VALUE_DATE in DATE,
816 X_ITEM_NAME in VARCHAR2,
817 X_DISPLAY_HEIGHT IN NUMBER,
818 X_SUBMIT IN VARCHAR2,
819 X_ENCRYPT IN VARCHAR2,
820 X_VIEW_USAGE_NAME IN VARCHAR2,
821 X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
822 X_CSS_CLASS_NAME IN VARCHAR2,
823 X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
824 X_URL IN VARCHAR2,
825 X_POPLIST_VIEWOBJECT IN VARCHAR2,
826 X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
827 X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
828 X_IMAGE_FILE_NAME IN VARCHAR2,
829 X_NESTED_REGION_CODE IN VARCHAR2,
830 X_NESTED_REGION_APPL_ID IN NUMBER,
831 X_MENU_NAME IN VARCHAR2,
832 X_FLEXFIELD_NAME IN VARCHAR2,
833 X_FLEXFIELD_APPLICATION_ID NUMBER,
834 X_TABULAR_FUNCTION_CODE IN VARCHAR2,
835 X_TIP_TYPE IN VARCHAR2,
836 X_TIP_MESSAGE_NAME VARCHAR2,
837 X_TIP_MESSAGE_APPLICATION_ID NUMBER,
838 X_FLEX_SEGMENT_LIST VARCHAR2,
839 X_ENTITY_ID VARCHAR2,
840 X_ANCHOR VARCHAR2,
841 X_POPLIST_VIEW_USAGE_NAME VARCHAR2,
842 X_USER_CUSTOMIZABLE VARCHAR2 := NULL,
843 X_ADMIN_CUSTOMIZABLE VARCHAR2 := 'Y',
844 X_INVOKE_FUNCTION_NAME VARCHAR2 := NULL,
845 X_ATTRIBUTE_LABEL_SHORT VARCHAR2 := NULL,
846 X_EXPANSION NUMBER := NULL,
847 X_ALS_MAX_LENGTH NUMBER := NULL,
848 X_SORTBY_VIEW_ATTRIBUTE_NAME VARCHAR2 := NULL,
849 X_ICX_CUSTOM_CALL VARCHAR2 := NULL,
850 X_INITIAL_SORT_SEQUENCE VARCHAR2 := NULL,
851 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER := NULL,
852 X_CUSTOMIZATION_CODE IN VARCHAR2 := NULL,
853 X_LAST_UPDATE_DATE in DATE,
854 X_LAST_UPDATED_BY in NUMBER,
855 X_LAST_UPDATE_LOGIN in NUMBER,
856 X_ATTRIBUTE_CATEGORY in VARCHAR2,
857 X_ATTRIBUTE1 in VARCHAR2,
858 X_ATTRIBUTE2 in VARCHAR2,
859 X_ATTRIBUTE3 in VARCHAR2,
860 X_ATTRIBUTE4 in VARCHAR2,
861 X_ATTRIBUTE5 in VARCHAR2,
862 X_ATTRIBUTE6 in VARCHAR2,
863 X_ATTRIBUTE7 in VARCHAR2,
864 X_ATTRIBUTE8 in VARCHAR2,
865 X_ATTRIBUTE9 in VARCHAR2,
866 X_ATTRIBUTE10 in VARCHAR2,
867 X_ATTRIBUTE11 in VARCHAR2,
868 X_ATTRIBUTE12 in VARCHAR2,
869 X_ATTRIBUTE13 in VARCHAR2,
870 X_ATTRIBUTE14 in VARCHAR2,
871 X_ATTRIBUTE15 in VARCHAR2
872 ) is
873 begin
874 update AK_REGION_ITEMS set
875 REGION_APPLICATION_ID = X_REGION_APPLICATION_ID,
876 REGION_CODE = X_REGION_CODE,
877 ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
878 ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
879 DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
880 NODE_DISPLAY_FLAG = X_NODE_DISPLAY_FLAG,
881 NODE_QUERY_FLAG = X_NODE_QUERY_FLAG,
882 ATTRIBUTE_LABEL_LENGTH = X_ATTRIBUTE_LABEL_LENGTH,
883 BOLD = X_BOLD,
884 ITALIC = X_ITALIC,
885 VERTICAL_ALIGNMENT = X_VERTICAL_ALIGNMENT,
886 HORIZONTAL_ALIGNMENT = X_HORIZONTAL_ALIGNMENT,
887 ITEM_STYLE = X_ITEM_STYLE,
888 SECURITY_CODE = X_SECURITY_CODE,
889 UPDATE_FLAG = X_UPDATE_FLAG,
890 REQUIRED_FLAG = X_REQUIRED_FLAG,
891 DISPLAY_VALUE_LENGTH = X_DISPLAY_VALUE_LENGTH,
892 LOV_REGION_APPLICATION_ID = X_LOV_REGION_APPLICATION_ID,
896 LOV_ATTRIBUTE_CODE = X_LOV_ATTRIBUTE_CODE,
893 LOV_REGION_CODE = X_LOV_REGION_CODE,
894 LOV_FOREIGN_KEY_NAME = X_LOV_FOREIGN_KEY_NAME,
895 LOV_ATTRIBUTE_APPLICATION_ID = X_LOV_ATTRIBUTE_APPLICATION_ID,
897 LOV_DEFAULT_FLAG = X_LOV_DEFAULT_FLAG,
898 REGION_DEFAULTING_API_PKG = X_REGION_DEFAULTING_API_PKG,
899 REGION_DEFAULTING_API_PROC = X_REGION_DEFAULTING_API_PROC,
900 REGION_VALIDATION_API_PKG = X_REGION_VALIDATION_API_PKG,
901 REGION_VALIDATION_API_PROC = X_REGION_VALIDATION_API_PROC,
902 ORDER_SEQUENCE = X_ORDER_SEQUENCE,
903 ORDER_DIRECTION = X_ORDER_DIRECTION,
904 DEFAULT_VALUE_VARCHAR2 = X_DEFAULT_VALUE_VARCHAR2,
905 DEFAULT_VALUE_NUMBER = X_DEFAULT_VALUE_NUMBER,
906 DEFAULT_VALUE_DATE = X_DEFAULT_VALUE_DATE,
907 OBJECT_ATTRIBUTE_FLAG = X_OBJECT_ATTRIBUTE_FLAG,
908 DISPLAY_HEIGHT = X_DISPLAY_HEIGHT,
909 SUBMIT = X_SUBMIT,
910 ENCRYPT = X_ENCRYPT,
911 VIEW_USAGE_NAME = X_VIEW_USAGE_NAME,
912 VIEW_ATTRIBUTE_NAME = X_VIEW_ATTRIBUTE_NAME,
913 CSS_CLASS_NAME = X_CSS_CLASS_NAME,
914 CSS_LABEL_CLASS_NAME = X_CSS_LABEL_CLASS_NAME,
915 URL = X_URL,
916 POPLIST_VIEWOBJECT = X_POPLIST_VIEWOBJECT,
917 POPLIST_DISPLAY_ATTRIBUTE = X_POPLIST_DISPLAY_ATTRIBUTE,
918 POPLIST_VALUE_ATTRIBUTE = X_POPLIST_VALUE_ATTRIBUTE,
919 IMAGE_FILE_NAME = X_IMAGE_FILE_NAME,
920 NESTED_REGION_APPLICATION_ID = X_NESTED_REGION_APPL_ID,
921 NESTED_REGION_CODE = X_NESTED_REGION_CODE,
922 ITEM_NAME = X_ITEM_NAME,
923 MENU_NAME = X_MENU_NAME,
924 FLEXFIELD_NAME = X_FLEXFIELD_NAME,
925 FLEXFIELD_APPLICATION_ID = X_FLEXFIELD_APPLICATION_ID,
926 TABULAR_FUNCTION_CODE = X_TABULAR_FUNCTION_CODE,
927 TIP_TYPE = X_TIP_TYPE,
928 TIP_MESSAGE_NAME = X_TIP_MESSAGE_NAME,
929 TIP_MESSAGE_APPLICATION_ID = X_TIP_MESSAGE_APPLICATION_ID,
930 FLEX_SEGMENT_LIST = X_FLEX_SEGMENT_LIST,
931 ENTITY_ID = X_ENTITY_ID,
932 ANCHOR = X_ANCHOR,
933 POPLIST_VIEW_USAGE_NAME = X_POPLIST_VIEW_USAGE_NAME,
934 USER_CUSTOMIZABLE = X_USER_CUSTOMIZABLE,
935 ADMIN_CUSTOMIZABLE = X_ADMIN_CUSTOMIZABLE,
936 INVOKE_FUNCTION_NAME = X_INVOKE_FUNCTION_NAME,
937 EXPANSION = X_EXPANSION,
938 ALS_MAX_LENGTH = X_ALS_MAX_LENGTH,
939 SORTBY_VIEW_ATTRIBUTE_NAME = X_SORTBY_VIEW_ATTRIBUTE_NAME,
940 ICX_CUSTOM_CALL = X_ICX_CUSTOM_CALL,
941 INITIAL_SORT_SEQUENCE = X_INITIAL_SORT_SEQUENCE,
942 CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID,
943 CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE,
944 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
945 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
946 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
947 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
948 ATTRIBUTE1 = X_ATTRIBUTE1,
949 ATTRIBUTE2 = X_ATTRIBUTE2,
950 ATTRIBUTE3 = X_ATTRIBUTE3,
951 ATTRIBUTE4 = X_ATTRIBUTE4,
952 ATTRIBUTE5 = X_ATTRIBUTE5,
953 ATTRIBUTE6 = X_ATTRIBUTE6,
954 ATTRIBUTE7 = X_ATTRIBUTE7,
955 ATTRIBUTE8 = X_ATTRIBUTE8,
956 ATTRIBUTE9 = X_ATTRIBUTE9,
957 ATTRIBUTE10 = X_ATTRIBUTE10,
958 ATTRIBUTE11 = X_ATTRIBUTE11,
959 ATTRIBUTE12 = X_ATTRIBUTE12,
960 ATTRIBUTE13 = X_ATTRIBUTE13,
961 ATTRIBUTE14 = X_ATTRIBUTE14,
962 ATTRIBUTE15 = X_ATTRIBUTE15
963 where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
964 and REGION_CODE = X_REGION_CODE
965 and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
966 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
967 if (sql%notfound) then
968 raise no_data_found;
969 end if;
970 
971 update AK_REGION_ITEMS_TL set
972 ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
973 ATTRIBUTE_LABEL_SHORT = X_ATTRIBUTE_LABEL_SHORT,
974 DESCRIPTION = X_DESCRIPTION,
975 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
976 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
977 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
978 SOURCE_LANG = userenv('LANG')
979 where REGION_CODE = X_REGION_CODE
980 and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
981 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
982 and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
983 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
984 if (sql%notfound) then
985 raise no_data_found;
986 end if;
987 end UPDATE_ROW;
988 
989 procedure DELETE_ROW (
990 X_REGION_APPLICATION_ID in NUMBER,
991 X_REGION_CODE in VARCHAR2,
992 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
993 X_ATTRIBUTE_CODE in VARCHAR2
994 ) is
995 begin
996 delete from AK_REGION_ITEMS
997 where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
998 and REGION_CODE = X_REGION_CODE
999 and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
1000 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
1001 
1002 if (sql%notfound) then
1003 raise no_data_found;
1004 end if;
1005 
1006 delete from AK_REGION_ITEMS_TL
1007 where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1008 and REGION_CODE = X_REGION_CODE
1009 and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
1010 and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
1011 if (sql%notfound) then
1012 raise no_data_found;
1013 end if;
1014 end DELETE_ROW;
1015 
1016 procedure ADD_LANGUAGE
1017 is
1018 begin
1019 
1020 /* Mar/19/03 requested by Ric Ginsberg */
1021 /* The following delete and update statements are commented out */
1022 /* as a quick workaround to fix the time-consuming table handler issue */
1026 where not exists
1023 /* Eventually we'll need to turn them into a separate fix_language procedure */
1024 /*
1025 delete from AK_REGION_ITEMS_TL T
1027 (select NULL
1028 from AK_REGION_ITEMS B
1029 where B.REGION_CODE = T.REGION_CODE
1030 and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
1031 and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
1032 and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
1033 );
1034 
1035 update AK_REGION_ITEMS_TL T set (
1036 ATTRIBUTE_LABEL_LONG,
1037 ATTRIBUTE_LABEL_SHORT,
1038 DESCRIPTION
1039 ) = (select
1040 B.ATTRIBUTE_LABEL_LONG,
1041 B.ATTRIBUTE_LABEL_SHORT,
1042 B.DESCRIPTION
1043 from AK_REGION_ITEMS_TL B
1044 where B.REGION_CODE = T.REGION_CODE
1045 and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
1046 and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
1047 and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
1048 and B.LANGUAGE = T.SOURCE_LANG)
1049 where (
1050 T.REGION_CODE,
1051 T.REGION_APPLICATION_ID,
1052 T.ATTRIBUTE_CODE,
1053 T.ATTRIBUTE_APPLICATION_ID,
1054 T.LANGUAGE
1055 ) in (select
1056 SUBT.REGION_CODE,
1057 SUBT.REGION_APPLICATION_ID,
1058 SUBT.ATTRIBUTE_CODE,
1059 SUBT.ATTRIBUTE_APPLICATION_ID,
1060 SUBT.LANGUAGE
1061 from AK_REGION_ITEMS_TL SUBB, AK_REGION_ITEMS_TL SUBT
1062 where SUBB.REGION_CODE = SUBT.REGION_CODE
1063 and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
1064 and SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
1065 and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID
1066 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1067 and (SUBB.ATTRIBUTE_LABEL_LONG <> SUBT.ATTRIBUTE_LABEL_LONG
1068 or (SUBB.ATTRIBUTE_LABEL_LONG is null and SUBT.ATTRIBUTE_LABEL_LONG is not null)
1069 or (SUBB.ATTRIBUTE_LABEL_LONG is not null and SUBT.ATTRIBUTE_LABEL_LONG is null)
1070 or SUBB.ATTRIBUTE_LABEL_SHORT <> SUBT.ATTRIBUTE_LABEL_SHORT
1071 or (SUBB.ATTRIBUTE_LABEL_SHORT is null and SUBT.ATTRIBUTE_LABEL_SHORT is not null)
1072 or (SUBB.ATTRIBUTE_LABEL_SHORT is not null and SUBT.ATTRIBUTE_LABEL_SHORT is null)
1073 ));
1074 */
1075 
1076 insert /*+ append parallel(tt) */ into AK_REGION_ITEMS_TL tt (
1077 REGION_APPLICATION_ID,
1078 REGION_CODE,
1079 ATTRIBUTE_APPLICATION_ID,
1080 ATTRIBUTE_CODE,
1081 ATTRIBUTE_LABEL_LONG,
1082 ATTRIBUTE_LABEL_SHORT,
1083 CREATED_BY,
1084 CREATION_DATE,
1085 LAST_UPDATED_BY,
1086 LAST_UPDATE_DATE,
1087 LAST_UPDATE_LOGIN,
1088 LANGUAGE,
1089 SOURCE_LANG
1090 ) select /*+ parallel(v) parallel(t) use_nl(t) */  v.*
1091 from ( SELECT /*+ no_merge ordered parellel(b) */
1092 B.REGION_APPLICATION_ID,
1093 B.REGION_CODE,
1094 B.ATTRIBUTE_APPLICATION_ID,
1095 B.ATTRIBUTE_CODE,
1096 B.ATTRIBUTE_LABEL_LONG,
1097 B.ATTRIBUTE_LABEL_SHORT,
1098 B.CREATED_BY,
1099 B.CREATION_DATE,
1100 B.LAST_UPDATED_BY,
1101 B.LAST_UPDATE_DATE,
1102 B.LAST_UPDATE_LOGIN,
1103 L.LANGUAGE_CODE,
1104 B.SOURCE_LANG
1105 from AK_REGION_ITEMS_TL B, FND_LANGUAGES L
1106 where L.INSTALLED_FLAG in ('I', 'B')
1107 and B.LANGUAGE = userenv('LANG')
1108 ) v, ak_region_items_tl t
1109 where T.REGION_CODE(+) = v.REGION_CODE
1110 and T.REGION_APPLICATION_ID(+) = v.REGION_APPLICATION_ID
1111 and T.ATTRIBUTE_CODE(+) = v.ATTRIBUTE_CODE
1112 and T.ATTRIBUTE_APPLICATION_ID(+) = v.ATTRIBUTE_APPLICATION_ID
1113 and T.LANGUAGE(+) = v.LANGUAGE_CODE
1114 and T.REGION_CODE is NULL
1115 and T.REGION_APPLICATION_ID is NULL
1116 and T.ATTRIBUTE_CODE is NULL
1117 and T.ATTRIBUTE_APPLICATION_ID is NULL;
1118 
1119 end ADD_LANGUAGE;
1120 
1121 end AK_REGION_ITEMS_PKG;