1 PACKAGE BODY EGO_ITEM_USERATTRS_PUB AS
2 /* $Header: EGOPIUAB.pls 120.1.12020000.2 2012/07/13 01:34:56 mshirkol ship $ */
3
4 ------------------------------------
5 -- Global Variables and Constants --
6 ------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_ITEM_USERATTRS_PUB';
9 G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
10 G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
11
12 ----------------------------------------------------------------------
13 PROCEDURE ADD_LANGUAGE
14 IS
15 l_rec_count NUMBER;
16 p_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
17
18
19 CURSOR get_installed_languages is
20 select LANGUAGE_CODE
21 from FND_LANGUAGES
22 where INSTALLED_FLAG = 'I';
23
24
25 BEGIN
26 /* Solving Perf. Bug 4191046 */
27 /* The following delete and update statements are commented out */
28 /* as a quick workaround to fix the time-consuming table handler issue */
29 /*
30 delete from EGO_MTL_SY_ITEMS_EXT_TL T
31 where not exists
32 (select NULL
33 from EGO_MTL_SY_ITEMS_EXT_B B
34 where B.EXTENSION_ID = T.EXTENSION_ID
35 );
36
37 update EGO_MTL_SY_ITEMS_EXT_TL T set (
38 TL_EXT_ATTR1,
39 TL_EXT_ATTR2,
40 TL_EXT_ATTR3,
41 TL_EXT_ATTR4,
42 TL_EXT_ATTR5,
43 TL_EXT_ATTR6,
44 TL_EXT_ATTR7,
45 TL_EXT_ATTR8,
46 TL_EXT_ATTR9,
47 TL_EXT_ATTR10,
48 TL_EXT_ATTR11,
49 TL_EXT_ATTR12,
50 TL_EXT_ATTR13,
51 TL_EXT_ATTR14,
52 TL_EXT_ATTR15,
53 TL_EXT_ATTR16,
54 TL_EXT_ATTR17,
55 TL_EXT_ATTR18,
56 TL_EXT_ATTR19,
57 TL_EXT_ATTR20,
58 TL_EXT_ATTR21,
59 TL_EXT_ATTR22,
60 TL_EXT_ATTR23,
61 TL_EXT_ATTR24,
62 TL_EXT_ATTR25,
63 TL_EXT_ATTR26,
64 TL_EXT_ATTR27,
65 TL_EXT_ATTR28,
66 TL_EXT_ATTR29,
67 TL_EXT_ATTR30,
68 TL_EXT_ATTR31,
69 TL_EXT_ATTR32,
70 TL_EXT_ATTR33,
71 TL_EXT_ATTR34,
72 TL_EXT_ATTR35,
73 TL_EXT_ATTR36,
74 TL_EXT_ATTR37,
75 TL_EXT_ATTR38,
76 TL_EXT_ATTR39,
77 TL_EXT_ATTR40
78 ) =
79 (select
80 B.TL_EXT_ATTR1,
81 B.TL_EXT_ATTR2,
82 B.TL_EXT_ATTR3,
83 B.TL_EXT_ATTR4,
84 B.TL_EXT_ATTR5,
85 B.TL_EXT_ATTR6,
86 B.TL_EXT_ATTR7,
87 B.TL_EXT_ATTR8,
88 B.TL_EXT_ATTR9,
89 B.TL_EXT_ATTR10,
90 B.TL_EXT_ATTR11,
91 B.TL_EXT_ATTR12,
92 B.TL_EXT_ATTR13,
93 B.TL_EXT_ATTR14,
94 B.TL_EXT_ATTR15,
95 B.TL_EXT_ATTR16,
96 B.TL_EXT_ATTR17,
97 B.TL_EXT_ATTR18,
98 B.TL_EXT_ATTR19,
99 B.TL_EXT_ATTR20,
100 B.TL_EXT_ATTR21,
101 B.TL_EXT_ATTR22,
102 B.TL_EXT_ATTR23,
103 B.TL_EXT_ATTR24,
104 B.TL_EXT_ATTR25,
105 B.TL_EXT_ATTR26,
106 B.TL_EXT_ATTR27,
107 B.TL_EXT_ATTR28,
108 B.TL_EXT_ATTR29,
109 B.TL_EXT_ATTR30,
110 B.TL_EXT_ATTR31,
111 B.TL_EXT_ATTR32,
112 B.TL_EXT_ATTR33,
113 B.TL_EXT_ATTR34,
114 B.TL_EXT_ATTR35,
115 B.TL_EXT_ATTR36,
116 B.TL_EXT_ATTR37,
117 B.TL_EXT_ATTR38,
118 B.TL_EXT_ATTR39,
119 B.TL_EXT_ATTR40
120 from EGO_MTL_SY_ITEMS_EXT_TL B
121 where B.EXTENSION_ID = T.EXTENSION_ID
122 and B.LANGUAGE = T.SOURCE_LANG)
123 where (
124 T.EXTENSION_ID,
125 T.LANGUAGE
126 ) in (select
127 SUBT.EXTENSION_ID,
128 SUBT.LANGUAGE
129 from EGO_MTL_SY_ITEMS_EXT_TL SUBB, EGO_MTL_SY_ITEMS_EXT_TL SUBT
130 where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
131 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
132 and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
133 or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)
134 or (SUBB.TL_EXT_ATTR1 is not null and SUBT.TL_EXT_ATTR1 is null)
135 or SUBB.TL_EXT_ATTR2 <> SUBT.TL_EXT_ATTR2
136 or (SUBB.TL_EXT_ATTR2 is null and SUBT.TL_EXT_ATTR2 is not null)
137 or (SUBB.TL_EXT_ATTR2 is not null and SUBT.TL_EXT_ATTR2 is null)
138 or SUBB.TL_EXT_ATTR3 <> SUBT.TL_EXT_ATTR3
139 or (SUBB.TL_EXT_ATTR3 is null and SUBT.TL_EXT_ATTR3 is not null)
140 or (SUBB.TL_EXT_ATTR3 is not null and SUBT.TL_EXT_ATTR3 is null)
141 or SUBB.TL_EXT_ATTR4 <> SUBT.TL_EXT_ATTR4
142 or (SUBB.TL_EXT_ATTR4 is null and SUBT.TL_EXT_ATTR4 is not null)
143 or (SUBB.TL_EXT_ATTR4 is not null and SUBT.TL_EXT_ATTR4 is null)
144 or SUBB.TL_EXT_ATTR5 <> SUBT.TL_EXT_ATTR5
145 or (SUBB.TL_EXT_ATTR5 is null and SUBT.TL_EXT_ATTR5 is not null)
146 or (SUBB.TL_EXT_ATTR5 is not null and SUBT.TL_EXT_ATTR5 is null)
147 or SUBB.TL_EXT_ATTR6 <> SUBT.TL_EXT_ATTR6
148 or (SUBB.TL_EXT_ATTR6 is null and SUBT.TL_EXT_ATTR6 is not null)
149 or (SUBB.TL_EXT_ATTR6 is not null and SUBT.TL_EXT_ATTR6 is null)
150 or SUBB.TL_EXT_ATTR7 <> SUBT.TL_EXT_ATTR7
151 or (SUBB.TL_EXT_ATTR7 is null and SUBT.TL_EXT_ATTR7 is not null)
152 or (SUBB.TL_EXT_ATTR7 is not null and SUBT.TL_EXT_ATTR7 is null)
153 or SUBB.TL_EXT_ATTR8 <> SUBT.TL_EXT_ATTR8
154 or (SUBB.TL_EXT_ATTR8 is null and SUBT.TL_EXT_ATTR8 is not null)
155 or (SUBB.TL_EXT_ATTR8 is not null and SUBT.TL_EXT_ATTR8 is null)
156 or SUBB.TL_EXT_ATTR9 <> SUBT.TL_EXT_ATTR9
157 or (SUBB.TL_EXT_ATTR9 is null and SUBT.TL_EXT_ATTR9 is not null)
158 or (SUBB.TL_EXT_ATTR9 is not null and SUBT.TL_EXT_ATTR9 is null)
159 or SUBB.TL_EXT_ATTR10 <> SUBT.TL_EXT_ATTR10
160 or (SUBB.TL_EXT_ATTR10 is null and SUBT.TL_EXT_ATTR10 is not null)
161 or (SUBB.TL_EXT_ATTR10 is not null and SUBT.TL_EXT_ATTR10 is null)
162 or SUBB.TL_EXT_ATTR11 <> SUBT.TL_EXT_ATTR11
163 or (SUBB.TL_EXT_ATTR11 is null and SUBT.TL_EXT_ATTR11 is not null)
164 or (SUBB.TL_EXT_ATTR11 is not null and SUBT.TL_EXT_ATTR11 is null)
165 or SUBB.TL_EXT_ATTR12 <> SUBT.TL_EXT_ATTR12
166 or (SUBB.TL_EXT_ATTR12 is null and SUBT.TL_EXT_ATTR12 is not null)
167 or (SUBB.TL_EXT_ATTR12 is not null and SUBT.TL_EXT_ATTR12 is null)
168 or SUBB.TL_EXT_ATTR13 <> SUBT.TL_EXT_ATTR13
169 or (SUBB.TL_EXT_ATTR13 is null and SUBT.TL_EXT_ATTR13 is not null)
170 or (SUBB.TL_EXT_ATTR13 is not null and SUBT.TL_EXT_ATTR13 is null)
171 or SUBB.TL_EXT_ATTR14 <> SUBT.TL_EXT_ATTR14
172 or (SUBB.TL_EXT_ATTR14 is null and SUBT.TL_EXT_ATTR14 is not null)
173 or (SUBB.TL_EXT_ATTR14 is not null and SUBT.TL_EXT_ATTR14 is null)
174 or SUBB.TL_EXT_ATTR15 <> SUBT.TL_EXT_ATTR15
175 or (SUBB.TL_EXT_ATTR15 is null and SUBT.TL_EXT_ATTR15 is not null)
176 or (SUBB.TL_EXT_ATTR15 is not null and SUBT.TL_EXT_ATTR15 is null)
177 or SUBB.TL_EXT_ATTR16 <> SUBT.TL_EXT_ATTR16
178 or (SUBB.TL_EXT_ATTR16 is null and SUBT.TL_EXT_ATTR16 is not null)
179 or (SUBB.TL_EXT_ATTR16 is not null and SUBT.TL_EXT_ATTR16 is null)
180 or SUBB.TL_EXT_ATTR17 <> SUBT.TL_EXT_ATTR17
181 or (SUBB.TL_EXT_ATTR17 is null and SUBT.TL_EXT_ATTR17 is not null)
182 or (SUBB.TL_EXT_ATTR17 is not null and SUBT.TL_EXT_ATTR17 is null)
183 or SUBB.TL_EXT_ATTR18 <> SUBT.TL_EXT_ATTR18
184 or (SUBB.TL_EXT_ATTR18 is null and SUBT.TL_EXT_ATTR18 is not null)
185 or (SUBB.TL_EXT_ATTR18 is not null and SUBT.TL_EXT_ATTR18 is null)
186 or SUBB.TL_EXT_ATTR19 <> SUBT.TL_EXT_ATTR19
187 or (SUBB.TL_EXT_ATTR19 is null and SUBT.TL_EXT_ATTR19 is not null)
188 or (SUBB.TL_EXT_ATTR19 is not null and SUBT.TL_EXT_ATTR19 is null)
189 or SUBB.TL_EXT_ATTR20 <> SUBT.TL_EXT_ATTR20
190 or (SUBB.TL_EXT_ATTR20 is null and SUBT.TL_EXT_ATTR20 is not null)
191 or (SUBB.TL_EXT_ATTR20 is not null and SUBT.TL_EXT_ATTR20 is null)
192 or SUBB.TL_EXT_ATTR21 <> SUBT.TL_EXT_ATTR21
193 or (SUBB.TL_EXT_ATTR21 is null and SUBT.TL_EXT_ATTR21 is not null)
194 or (SUBB.TL_EXT_ATTR21 is not null and SUBT.TL_EXT_ATTR21 is null)
195 or SUBB.TL_EXT_ATTR22 <> SUBT.TL_EXT_ATTR22
196 or (SUBB.TL_EXT_ATTR22 is null and SUBT.TL_EXT_ATTR22 is not null)
197 or (SUBB.TL_EXT_ATTR22 is not null and SUBT.TL_EXT_ATTR22 is null)
198 or SUBB.TL_EXT_ATTR23 <> SUBT.TL_EXT_ATTR23
199 or (SUBB.TL_EXT_ATTR23 is null and SUBT.TL_EXT_ATTR23 is not null)
200 or (SUBB.TL_EXT_ATTR23 is not null and SUBT.TL_EXT_ATTR23 is null)
201 or SUBB.TL_EXT_ATTR24 <> SUBT.TL_EXT_ATTR24
202 or (SUBB.TL_EXT_ATTR24 is null and SUBT.TL_EXT_ATTR24 is not null)
203 or (SUBB.TL_EXT_ATTR24 is not null and SUBT.TL_EXT_ATTR24 is null)
204 or SUBB.TL_EXT_ATTR25 <> SUBT.TL_EXT_ATTR25
205 or (SUBB.TL_EXT_ATTR25 is null and SUBT.TL_EXT_ATTR25 is not null)
206 or (SUBB.TL_EXT_ATTR25 is not null and SUBT.TL_EXT_ATTR25 is null)
207 or SUBB.TL_EXT_ATTR26 <> SUBT.TL_EXT_ATTR26
208 or (SUBB.TL_EXT_ATTR26 is null and SUBT.TL_EXT_ATTR26 is not null)
209 or (SUBB.TL_EXT_ATTR26 is not null and SUBT.TL_EXT_ATTR26 is null)
210 or SUBB.TL_EXT_ATTR27 <> SUBT.TL_EXT_ATTR27
211 or (SUBB.TL_EXT_ATTR27 is null and SUBT.TL_EXT_ATTR27 is not null)
212 or (SUBB.TL_EXT_ATTR27 is not null and SUBT.TL_EXT_ATTR27 is null)
213 or SUBB.TL_EXT_ATTR28 <> SUBT.TL_EXT_ATTR28
214 or (SUBB.TL_EXT_ATTR28 is null and SUBT.TL_EXT_ATTR28 is not null)
215 or (SUBB.TL_EXT_ATTR28 is not null and SUBT.TL_EXT_ATTR28 is null)
216 or SUBB.TL_EXT_ATTR29 <> SUBT.TL_EXT_ATTR29
217 or (SUBB.TL_EXT_ATTR29 is null and SUBT.TL_EXT_ATTR29 is not null)
218 or (SUBB.TL_EXT_ATTR29 is not null and SUBT.TL_EXT_ATTR29 is null)
219 or SUBB.TL_EXT_ATTR30 <> SUBT.TL_EXT_ATTR30
220 or (SUBB.TL_EXT_ATTR30 is null and SUBT.TL_EXT_ATTR30 is not null)
221 or (SUBB.TL_EXT_ATTR30 is not null and SUBT.TL_EXT_ATTR30 is null)
222 or SUBB.TL_EXT_ATTR31 <> SUBT.TL_EXT_ATTR31
223 or (SUBB.TL_EXT_ATTR31 is null and SUBT.TL_EXT_ATTR31 is not null)
224 or (SUBB.TL_EXT_ATTR31 is not null and SUBT.TL_EXT_ATTR31 is null)
225 or SUBB.TL_EXT_ATTR32 <> SUBT.TL_EXT_ATTR32
226 or (SUBB.TL_EXT_ATTR32 is null and SUBT.TL_EXT_ATTR32 is not null)
227 or (SUBB.TL_EXT_ATTR32 is not null and SUBT.TL_EXT_ATTR32 is null)
228 or SUBB.TL_EXT_ATTR33 <> SUBT.TL_EXT_ATTR33
229 or (SUBB.TL_EXT_ATTR33 is null and SUBT.TL_EXT_ATTR33 is not null)
230 or (SUBB.TL_EXT_ATTR33 is not null and SUBT.TL_EXT_ATTR33 is null)
231 or SUBB.TL_EXT_ATTR34 <> SUBT.TL_EXT_ATTR34
232 or (SUBB.TL_EXT_ATTR34 is null and SUBT.TL_EXT_ATTR34 is not null)
233 or (SUBB.TL_EXT_ATTR34 is not null and SUBT.TL_EXT_ATTR34 is null)
234 or SUBB.TL_EXT_ATTR35 <> SUBT.TL_EXT_ATTR35
235 or (SUBB.TL_EXT_ATTR35 is null and SUBT.TL_EXT_ATTR35 is not null)
236 or (SUBB.TL_EXT_ATTR35 is not null and SUBT.TL_EXT_ATTR35 is null)
237 or SUBB.TL_EXT_ATTR36 <> SUBT.TL_EXT_ATTR36
238 or (SUBB.TL_EXT_ATTR36 is null and SUBT.TL_EXT_ATTR36 is not null)
239 or (SUBB.TL_EXT_ATTR36 is not null and SUBT.TL_EXT_ATTR36 is null)
240 or SUBB.TL_EXT_ATTR37 <> SUBT.TL_EXT_ATTR37
241 or (SUBB.TL_EXT_ATTR37 is null and SUBT.TL_EXT_ATTR37 is not null)
242 or (SUBB.TL_EXT_ATTR37 is not null and SUBT.TL_EXT_ATTR37 is null)
243 or SUBB.TL_EXT_ATTR38 <> SUBT.TL_EXT_ATTR38
244 or (SUBB.TL_EXT_ATTR38 is null and SUBT.TL_EXT_ATTR38 is not null)
245 or (SUBB.TL_EXT_ATTR38 is not null and SUBT.TL_EXT_ATTR38 is null)
246 or SUBB.TL_EXT_ATTR39 <> SUBT.TL_EXT_ATTR39
247 or (SUBB.TL_EXT_ATTR39 is null and SUBT.TL_EXT_ATTR39 is not null)
248 or (SUBB.TL_EXT_ATTR39 is not null and SUBT.TL_EXT_ATTR39 is null)
249 or SUBB.TL_EXT_ATTR40 <> SUBT.TL_EXT_ATTR40
250 or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
251 or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
252 ));
253 */
254
255
256
257 OPEN get_installed_languages;
258
259 LOOP
260 FETCH get_installed_languages INTO p_language;
261 EXIT WHEN get_installed_languages%NOTFOUND;
262
263
264 SELECT Count(1) into l_rec_count FROM ego_mtl_sy_items_ext_tl where language = p_language;
265
266 IF (l_rec_count = 0) THEN
267
268 insert into EGO_MTL_SY_ITEMS_EXT_TL (
269 TL_EXT_ATTR23,
270 TL_EXT_ATTR24,
271 TL_EXT_ATTR25,
272 TL_EXT_ATTR26,
273 TL_EXT_ATTR27,
274 TL_EXT_ATTR28,
275 TL_EXT_ATTR29,
276 TL_EXT_ATTR30,
277 TL_EXT_ATTR31,
278 TL_EXT_ATTR32,
279 TL_EXT_ATTR33,
280 TL_EXT_ATTR34,
281 TL_EXT_ATTR35,
282 TL_EXT_ATTR36,
283 TL_EXT_ATTR37,
284 TL_EXT_ATTR38,
285 TL_EXT_ATTR39,
286 TL_EXT_ATTR40,
287 EXTENSION_ID,
288 ORGANIZATION_ID,
289 INVENTORY_ITEM_ID,
290 REVISION_ID,
291 ITEM_CATALOG_GROUP_ID,
292 ATTR_GROUP_ID,
293 DATA_LEVEL_ID,
294 CREATED_BY,
295 CREATION_DATE,
296 LAST_UPDATED_BY,
297 LAST_UPDATE_DATE,
298 LAST_UPDATE_LOGIN,
299 TL_EXT_ATTR1,
300 TL_EXT_ATTR2,
301 TL_EXT_ATTR3,
302 TL_EXT_ATTR4,
303 TL_EXT_ATTR5,
304 TL_EXT_ATTR6,
305 TL_EXT_ATTR7,
306 TL_EXT_ATTR8,
307 TL_EXT_ATTR9,
308 TL_EXT_ATTR10,
309 TL_EXT_ATTR11,
310 TL_EXT_ATTR12,
311 TL_EXT_ATTR13,
312 TL_EXT_ATTR14,
313 TL_EXT_ATTR15,
314 TL_EXT_ATTR16,
315 TL_EXT_ATTR17,
316 TL_EXT_ATTR18,
317 TL_EXT_ATTR19,
318 TL_EXT_ATTR20,
319 TL_EXT_ATTR21,
320 TL_EXT_ATTR22,
321 LANGUAGE,
322 SOURCE_LANG
323 ) SELECT /*+ parallel(B) */
324 B.TL_EXT_ATTR23,
325 B.TL_EXT_ATTR24,
326 B.TL_EXT_ATTR25,
327 B.TL_EXT_ATTR26,
328 B.TL_EXT_ATTR27,
329 B.TL_EXT_ATTR28,
330 B.TL_EXT_ATTR29,
331 B.TL_EXT_ATTR30,
332 B.TL_EXT_ATTR31,
333 B.TL_EXT_ATTR32,
334 B.TL_EXT_ATTR33,
335 B.TL_EXT_ATTR34,
336 B.TL_EXT_ATTR35,
337 B.TL_EXT_ATTR36,
338 B.TL_EXT_ATTR37,
339 B.TL_EXT_ATTR38,
340 B.TL_EXT_ATTR39,
341 B.TL_EXT_ATTR40,
342 B.EXTENSION_ID,
343 B.ORGANIZATION_ID,
344 B.INVENTORY_ITEM_ID,
345 B.REVISION_ID,
346 B.ITEM_CATALOG_GROUP_ID,
347 B.ATTR_GROUP_ID,
348 B.DATA_LEVEL_ID,
349 B.CREATED_BY,
350 B.CREATION_DATE,
351 B.LAST_UPDATED_BY,
352 B.LAST_UPDATE_DATE,
353 B.LAST_UPDATE_LOGIN,
354 B.TL_EXT_ATTR1,
355 B.TL_EXT_ATTR2,
356 B.TL_EXT_ATTR3,
357 B.TL_EXT_ATTR4,
358 B.TL_EXT_ATTR5,
359 B.TL_EXT_ATTR6,
360 B.TL_EXT_ATTR7,
361 B.TL_EXT_ATTR8,
362 B.TL_EXT_ATTR9,
363 B.TL_EXT_ATTR10,
364 B.TL_EXT_ATTR11,
365 B.TL_EXT_ATTR12,
366 B.TL_EXT_ATTR13,
367 B.TL_EXT_ATTR14,
368 B.TL_EXT_ATTR15,
369 B.TL_EXT_ATTR16,
370 B.TL_EXT_ATTR17,
371 B.TL_EXT_ATTR18,
372 B.TL_EXT_ATTR19,
373 B.TL_EXT_ATTR20,
374 B.TL_EXT_ATTR21,
375 B.TL_EXT_ATTR22,
376 p_language,
377 B.SOURCE_LANG
378 from EGO_MTL_SY_ITEMS_EXT_TL B
379 where B.LANGUAGE = userenv('LANG');
380
381 ELSIF (l_rec_count > 0) THEN
382
383 insert into EGO_MTL_SY_ITEMS_EXT_TL (
384 TL_EXT_ATTR23,
385 TL_EXT_ATTR24,
386 TL_EXT_ATTR25,
387 TL_EXT_ATTR26,
388 TL_EXT_ATTR27,
389 TL_EXT_ATTR28,
390 TL_EXT_ATTR29,
391 TL_EXT_ATTR30,
392 TL_EXT_ATTR31,
393 TL_EXT_ATTR32,
394 TL_EXT_ATTR33,
395 TL_EXT_ATTR34,
396 TL_EXT_ATTR35,
397 TL_EXT_ATTR36,
398 TL_EXT_ATTR37,
399 TL_EXT_ATTR38,
400 TL_EXT_ATTR39,
401 TL_EXT_ATTR40,
402 EXTENSION_ID,
403 ORGANIZATION_ID,
404 INVENTORY_ITEM_ID,
405 REVISION_ID,
406 ITEM_CATALOG_GROUP_ID,
407 ATTR_GROUP_ID,
408 DATA_LEVEL_ID,
409 CREATED_BY,
410 CREATION_DATE,
411 LAST_UPDATED_BY,
412 LAST_UPDATE_DATE,
413 LAST_UPDATE_LOGIN,
414 TL_EXT_ATTR1,
415 TL_EXT_ATTR2,
416 TL_EXT_ATTR3,
417 TL_EXT_ATTR4,
418 TL_EXT_ATTR5,
419 TL_EXT_ATTR6,
420 TL_EXT_ATTR7,
421 TL_EXT_ATTR8,
422 TL_EXT_ATTR9,
423 TL_EXT_ATTR10,
424 TL_EXT_ATTR11,
425 TL_EXT_ATTR12,
426 TL_EXT_ATTR13,
427 TL_EXT_ATTR14,
428 TL_EXT_ATTR15,
429 TL_EXT_ATTR16,
430 TL_EXT_ATTR17,
431 TL_EXT_ATTR18,
432 TL_EXT_ATTR19,
433 TL_EXT_ATTR20,
434 TL_EXT_ATTR21,
435 TL_EXT_ATTR22,
436 LANGUAGE,
437 SOURCE_LANG
438 ) SELECT /*+ parallel(B) */
439 B.TL_EXT_ATTR23,
440 B.TL_EXT_ATTR24,
441 B.TL_EXT_ATTR25,
442 B.TL_EXT_ATTR26,
443 B.TL_EXT_ATTR27,
444 B.TL_EXT_ATTR28,
445 B.TL_EXT_ATTR29,
446 B.TL_EXT_ATTR30,
447 B.TL_EXT_ATTR31,
448 B.TL_EXT_ATTR32,
452 B.TL_EXT_ATTR36,
449 B.TL_EXT_ATTR33,
450 B.TL_EXT_ATTR34,
451 B.TL_EXT_ATTR35,
453 B.TL_EXT_ATTR37,
454 B.TL_EXT_ATTR38,
455 B.TL_EXT_ATTR39,
456 B.TL_EXT_ATTR40,
457 B.EXTENSION_ID,
458 B.ORGANIZATION_ID,
459 B.INVENTORY_ITEM_ID,
460 B.REVISION_ID,
461 B.ITEM_CATALOG_GROUP_ID,
462 B.ATTR_GROUP_ID,
463 B.DATA_LEVEL_ID,
464 B.CREATED_BY,
465 B.CREATION_DATE,
466 B.LAST_UPDATED_BY,
467 B.LAST_UPDATE_DATE,
468 B.LAST_UPDATE_LOGIN,
469 B.TL_EXT_ATTR1,
470 B.TL_EXT_ATTR2,
471 B.TL_EXT_ATTR3,
472 B.TL_EXT_ATTR4,
473 B.TL_EXT_ATTR5,
474 B.TL_EXT_ATTR6,
475 B.TL_EXT_ATTR7,
476 B.TL_EXT_ATTR8,
477 B.TL_EXT_ATTR9,
478 B.TL_EXT_ATTR10,
479 B.TL_EXT_ATTR11,
480 B.TL_EXT_ATTR12,
481 B.TL_EXT_ATTR13,
482 B.TL_EXT_ATTR14,
483 B.TL_EXT_ATTR15,
484 B.TL_EXT_ATTR16,
485 B.TL_EXT_ATTR17,
486 B.TL_EXT_ATTR18,
487 B.TL_EXT_ATTR19,
488 B.TL_EXT_ATTR20,
489 B.TL_EXT_ATTR21,
490 B.TL_EXT_ATTR22,
491 p_language,
492 B.SOURCE_LANG
493 from EGO_MTL_SY_ITEMS_EXT_TL B
494 where B.LANGUAGE = userenv('LANG')
495 and not exists
496 (select NULL
497 from EGO_MTL_SY_ITEMS_EXT_TL T
498 where T.EXTENSION_ID = B.EXTENSION_ID
499 and T.LANGUAGE = p_language);
500
501 END IF;
502 END LOOP;
503
504 CLOSE get_installed_languages;
505
506
507 END ADD_LANGUAGE;
508
509
510 ----------------------------------------------------------------------
511
512 END EGO_ITEM_USERATTRS_PUB;
513