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.JTFB_AK_REGION_ITEMS_PKG

Source


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