1 package body MTH_ITEMS_EXT_PKG as
2 /* $Header: mthuitlb.pls 120.0.12010000.3 2009/08/21 09:50:52 sdonthu ship $ */
3 /*
4 ===========We do not need these procedures for this release==========
5
6 procedure INSERT_ROW (
7 X_ROWID in out nocopy VARCHAR2,
8 X_EXTENSION_ID in NUMBER,
9 X_ATTR_GROUP_ID in NUMBER,
10 X_ITEM_PK_KEY in NUMBER,
11 X_C_EXT_ATTR1 in VARCHAR2,
12 X_C_EXT_ATTR2 in VARCHAR2,
13 X_C_EXT_ATTR3 in VARCHAR2,
14 X_C_EXT_ATTR4 in VARCHAR2,
15 X_C_EXT_ATTR5 in VARCHAR2,
16 X_C_EXT_ATTR6 in VARCHAR2,
17 X_C_EXT_ATTR7 in VARCHAR2,
18 X_C_EXT_ATTR8 in VARCHAR2,
19 X_C_EXT_ATTR9 in VARCHAR2,
20 X_C_EXT_ATTR10 in VARCHAR2,
21 X_C_EXT_ATTR11 in VARCHAR2,
22 X_C_EXT_ATTR12 in VARCHAR2,
23 X_C_EXT_ATTR13 in VARCHAR2,
24 X_C_EXT_ATTR14 in VARCHAR2,
25 X_C_EXT_ATTR15 in VARCHAR2,
26 X_C_EXT_ATTR16 in VARCHAR2,
27 X_C_EXT_ATTR17 in VARCHAR2,
28 X_C_EXT_ATTR18 in VARCHAR2,
29 X_C_EXT_ATTR19 in VARCHAR2,
30 X_C_EXT_ATTR20 in VARCHAR2,
31 X_C_EXT_ATTR21 in VARCHAR2,
32 X_C_EXT_ATTR22 in VARCHAR2,
33 X_C_EXT_ATTR23 in VARCHAR2,
34 X_C_EXT_ATTR24 in VARCHAR2,
35 X_C_EXT_ATTR25 in VARCHAR2,
36 X_C_EXT_ATTR26 in VARCHAR2,
37 X_C_EXT_ATTR27 in VARCHAR2,
38 X_C_EXT_ATTR28 in VARCHAR2,
39 X_C_EXT_ATTR29 in VARCHAR2,
40 X_C_EXT_ATTR30 in VARCHAR2,
41 X_N_EXT_ATTR1 in NUMBER,
42 X_N_EXT_ATTR2 in NUMBER,
43 X_N_EXT_ATTR3 in NUMBER,
44 X_N_EXT_ATTR4 in NUMBER,
45 X_N_EXT_ATTR5 in NUMBER,
46 X_N_EXT_ATTR6 in NUMBER,
47 X_N_EXT_ATTR7 in NUMBER,
48 X_N_EXT_ATTR8 in NUMBER,
49 X_N_EXT_ATTR9 in NUMBER,
50 X_N_EXT_ATTR10 in NUMBER,
51 X_N_EXT_ATTR11 in NUMBER,
52 X_N_EXT_ATTR12 in NUMBER,
53 X_N_EXT_ATTR13 in NUMBER,
54 X_N_EXT_ATTR14 in NUMBER,
55 X_N_EXT_ATTR15 in NUMBER,
56 X_N_EXT_ATTR16 in NUMBER,
57 X_N_EXT_ATTR17 in NUMBER,
58 X_N_EXT_ATTR18 in NUMBER,
59 X_N_EXT_ATTR19 in NUMBER,
60 X_N_EXT_ATTR20 in NUMBER,
61 X_D_EXT_ATTR1 in DATE,
62 X_D_EXT_ATTR2 in DATE,
63 X_D_EXT_ATTR3 in DATE,
64 X_D_EXT_ATTR4 in DATE,
65 X_D_EXT_ATTR5 in DATE,
66 X_D_EXT_ATTR6 in DATE,
67 X_D_EXT_ATTR7 in DATE,
68 X_D_EXT_ATTR8 in DATE,
69 X_D_EXT_ATTR9 in DATE,
70 X_D_EXT_ATTR10 in DATE,
71 X_D_EXT_ATTR11 in DATE,
72 X_D_EXT_ATTR12 in DATE,
73 X_D_EXT_ATTR13 in DATE,
74 X_D_EXT_ATTR14 in DATE,
75 X_D_EXT_ATTR15 in DATE,
76 X_D_EXT_ATTR16 in DATE,
77 X_D_EXT_ATTR17 in DATE,
78 X_D_EXT_ATTR18 in DATE,
79 X_D_EXT_ATTR19 in DATE,
80 X_D_EXT_ATTR20 in DATE,
81 X_TL_EXT_ATTR1 in VARCHAR2,
82 X_TL_EXT_ATTR2 in VARCHAR2,
83 X_TL_EXT_ATTR3 in VARCHAR2,
84 X_TL_EXT_ATTR4 in VARCHAR2,
85 X_TL_EXT_ATTR5 in VARCHAR2,
86 X_TL_EXT_ATTR6 in VARCHAR2,
87 X_TL_EXT_ATTR7 in VARCHAR2,
88 X_TL_EXT_ATTR8 in VARCHAR2,
89 X_TL_EXT_ATTR9 in VARCHAR2,
90 X_TL_EXT_ATTR10 in VARCHAR2,
91 X_TL_EXT_ATTR11 in VARCHAR2,
92 X_TL_EXT_ATTR12 in VARCHAR2,
93 X_TL_EXT_ATTR13 in VARCHAR2,
94 X_TL_EXT_ATTR14 in VARCHAR2,
95 X_TL_EXT_ATTR15 in VARCHAR2,
96 X_TL_EXT_ATTR16 in VARCHAR2,
97 X_TL_EXT_ATTR17 in VARCHAR2,
98 X_TL_EXT_ATTR18 in VARCHAR2,
99 X_TL_EXT_ATTR19 in VARCHAR2,
100 X_TL_EXT_ATTR20 in VARCHAR2,
101 X_TL_EXT_ATTR21 in VARCHAR2,
102 X_TL_EXT_ATTR22 in VARCHAR2,
103 X_TL_EXT_ATTR23 in VARCHAR2,
104 X_TL_EXT_ATTR24 in VARCHAR2,
105 X_TL_EXT_ATTR25 in VARCHAR2,
106 X_TL_EXT_ATTR26 in VARCHAR2,
107 X_TL_EXT_ATTR27 in VARCHAR2,
108 X_TL_EXT_ATTR28 in VARCHAR2,
109 X_TL_EXT_ATTR29 in VARCHAR2,
110 X_TL_EXT_ATTR30 in VARCHAR2,
111 X_CREATION_DATE in DATE,
112 X_CREATED_BY in NUMBER,
113 X_LAST_UPDATE_DATE in DATE,
114 X_LAST_UPDATED_BY in NUMBER,
115 X_LAST_UPDATE_LOGIN in NUMBER
116 ) is
117 cursor C is select ROWID from MTH_ITEMS_EXT_B
118 where EXTENSION_ID = X_EXTENSION_ID
119 ;
120 begin
121 insert into MTH_ITEMS_EXT_B (
122 EXTENSION_ID,
123 ATTR_GROUP_ID,
124 ITEM_PK_KEY,
125 C_EXT_ATTR1,
126 C_EXT_ATTR2,
127 C_EXT_ATTR3,
128 C_EXT_ATTR4,
129 C_EXT_ATTR5,
130 C_EXT_ATTR6,
131 C_EXT_ATTR7,
132 C_EXT_ATTR8,
133 C_EXT_ATTR9,
134 C_EXT_ATTR10,
135 C_EXT_ATTR11,
136 C_EXT_ATTR12,
137 C_EXT_ATTR13,
138 C_EXT_ATTR14,
139 C_EXT_ATTR15,
140 C_EXT_ATTR16,
141 C_EXT_ATTR17,
142 C_EXT_ATTR18,
143 C_EXT_ATTR19,
144 C_EXT_ATTR20,
145 C_EXT_ATTR21,
146 C_EXT_ATTR22,
147 C_EXT_ATTR23,
148 C_EXT_ATTR24,
149 C_EXT_ATTR25,
150 C_EXT_ATTR26,
151 C_EXT_ATTR27,
152 C_EXT_ATTR28,
153 C_EXT_ATTR29,
154 C_EXT_ATTR30,
155 N_EXT_ATTR1,
156 N_EXT_ATTR2,
157 N_EXT_ATTR3,
158 N_EXT_ATTR4,
159 N_EXT_ATTR5,
160 N_EXT_ATTR6,
161 N_EXT_ATTR7,
162 N_EXT_ATTR8,
163 N_EXT_ATTR9,
164 N_EXT_ATTR10,
165 N_EXT_ATTR11,
166 N_EXT_ATTR12,
167 N_EXT_ATTR13,
168 N_EXT_ATTR14,
169 N_EXT_ATTR15,
170 N_EXT_ATTR16,
171 N_EXT_ATTR17,
172 N_EXT_ATTR18,
173 N_EXT_ATTR19,
174 N_EXT_ATTR20,
175 D_EXT_ATTR1,
176 D_EXT_ATTR2,
177 D_EXT_ATTR3,
178 D_EXT_ATTR4,
179 D_EXT_ATTR5,
180 D_EXT_ATTR6,
181 D_EXT_ATTR7,
182 D_EXT_ATTR8,
183 D_EXT_ATTR9,
184 D_EXT_ATTR10,
185 D_EXT_ATTR11,
186 D_EXT_ATTR12,
187 D_EXT_ATTR13,
188 D_EXT_ATTR14,
189 D_EXT_ATTR15,
190 D_EXT_ATTR16,
191 D_EXT_ATTR17,
192 D_EXT_ATTR18,
193 D_EXT_ATTR19,
194 D_EXT_ATTR20,
195 CREATION_DATE,
196 CREATED_BY,
197 LAST_UPDATE_DATE,
198 LAST_UPDATED_BY,
199 LAST_UPDATE_LOGIN
200 ) values (
201 X_EXTENSION_ID,
202 X_ATTR_GROUP_ID,
203 X_ITEM_PK_KEY,
204 X_C_EXT_ATTR1,
205 X_C_EXT_ATTR2,
206 X_C_EXT_ATTR3,
207 X_C_EXT_ATTR4,
208 X_C_EXT_ATTR5,
209 X_C_EXT_ATTR6,
210 X_C_EXT_ATTR7,
211 X_C_EXT_ATTR8,
212 X_C_EXT_ATTR9,
213 X_C_EXT_ATTR10,
214 X_C_EXT_ATTR11,
215 X_C_EXT_ATTR12,
216 X_C_EXT_ATTR13,
217 X_C_EXT_ATTR14,
218 X_C_EXT_ATTR15,
219 X_C_EXT_ATTR16,
220 X_C_EXT_ATTR17,
221 X_C_EXT_ATTR18,
222 X_C_EXT_ATTR19,
223 X_C_EXT_ATTR20,
224 X_C_EXT_ATTR21,
225 X_C_EXT_ATTR22,
226 X_C_EXT_ATTR23,
227 X_C_EXT_ATTR24,
228 X_C_EXT_ATTR25,
229 X_C_EXT_ATTR26,
230 X_C_EXT_ATTR27,
231 X_C_EXT_ATTR28,
232 X_C_EXT_ATTR29,
233 X_C_EXT_ATTR30,
234 X_N_EXT_ATTR1,
235 X_N_EXT_ATTR2,
236 X_N_EXT_ATTR3,
237 X_N_EXT_ATTR4,
238 X_N_EXT_ATTR5,
239 X_N_EXT_ATTR6,
240 X_N_EXT_ATTR7,
241 X_N_EXT_ATTR8,
242 X_N_EXT_ATTR9,
243 X_N_EXT_ATTR10,
244 X_N_EXT_ATTR11,
245 X_N_EXT_ATTR12,
246 X_N_EXT_ATTR13,
247 X_N_EXT_ATTR14,
248 X_N_EXT_ATTR15,
249 X_N_EXT_ATTR16,
250 X_N_EXT_ATTR17,
251 X_N_EXT_ATTR18,
252 X_N_EXT_ATTR19,
253 X_N_EXT_ATTR20,
254 X_D_EXT_ATTR1,
255 X_D_EXT_ATTR2,
256 X_D_EXT_ATTR3,
257 X_D_EXT_ATTR4,
258 X_D_EXT_ATTR5,
259 X_D_EXT_ATTR6,
260 X_D_EXT_ATTR7,
261 X_D_EXT_ATTR8,
262 X_D_EXT_ATTR9,
263 X_D_EXT_ATTR10,
264 X_D_EXT_ATTR11,
265 X_D_EXT_ATTR12,
266 X_D_EXT_ATTR13,
267 X_D_EXT_ATTR14,
268 X_D_EXT_ATTR15,
269 X_D_EXT_ATTR16,
270 X_D_EXT_ATTR17,
271 X_D_EXT_ATTR18,
272 X_D_EXT_ATTR19,
273 X_D_EXT_ATTR20,
274 X_CREATION_DATE,
275 X_CREATED_BY,
276 X_LAST_UPDATE_DATE,
277 X_LAST_UPDATED_BY,
278 X_LAST_UPDATE_LOGIN
279 );
280
281 insert into MTH_ITEMS_EXT_TL (
282 EXTENSION_ID,
283 ATTR_GROUP_ID,
284 ITEM_PK_KEY,
285 TL_EXT_ATTR1,
286 TL_EXT_ATTR2,
287 TL_EXT_ATTR3,
288 TL_EXT_ATTR4,
289 TL_EXT_ATTR5,
290 TL_EXT_ATTR6,
291 TL_EXT_ATTR7,
292 TL_EXT_ATTR8,
293 TL_EXT_ATTR9,
294 TL_EXT_ATTR10,
295 TL_EXT_ATTR11,
296 TL_EXT_ATTR12,
297 TL_EXT_ATTR13,
298 TL_EXT_ATTR14,
299 TL_EXT_ATTR15,
300 TL_EXT_ATTR16,
301 TL_EXT_ATTR17,
302 TL_EXT_ATTR18,
303 TL_EXT_ATTR19,
304 TL_EXT_ATTR20,
305 TL_EXT_ATTR21,
306 TL_EXT_ATTR22,
307 TL_EXT_ATTR23,
308 TL_EXT_ATTR24,
309 TL_EXT_ATTR25,
310 TL_EXT_ATTR26,
311 TL_EXT_ATTR27,
312 TL_EXT_ATTR28,
313 TL_EXT_ATTR29,
314 TL_EXT_ATTR30,
315 LAST_UPDATE_DATE,
316 LAST_UPDATED_BY,
317 LAST_UPDATE_LOGIN,
318 CREATED_BY,
319 CREATION_DATE,
320 LANGUAGE,
321 SOURCE_LANG
322 ) select
323 X_EXTENSION_ID,
324 X_ATTR_GROUP_ID,
325 X_ITEM_PK_KEY,
326 X_TL_EXT_ATTR1,
327 X_TL_EXT_ATTR2,
328 X_TL_EXT_ATTR3,
329 X_TL_EXT_ATTR4,
330 X_TL_EXT_ATTR5,
331 X_TL_EXT_ATTR6,
332 X_TL_EXT_ATTR7,
333 X_TL_EXT_ATTR8,
334 X_TL_EXT_ATTR9,
335 X_TL_EXT_ATTR10,
336 X_TL_EXT_ATTR11,
337 X_TL_EXT_ATTR12,
338 X_TL_EXT_ATTR13,
339 X_TL_EXT_ATTR14,
340 X_TL_EXT_ATTR15,
341 X_TL_EXT_ATTR16,
342 X_TL_EXT_ATTR17,
343 X_TL_EXT_ATTR18,
344 X_TL_EXT_ATTR19,
345 X_TL_EXT_ATTR20,
346 X_TL_EXT_ATTR21,
347 X_TL_EXT_ATTR22,
348 X_TL_EXT_ATTR23,
349 X_TL_EXT_ATTR24,
350 X_TL_EXT_ATTR25,
351 X_TL_EXT_ATTR26,
352 X_TL_EXT_ATTR27,
353 X_TL_EXT_ATTR28,
354 X_TL_EXT_ATTR29,
355 X_TL_EXT_ATTR30,
356 X_LAST_UPDATE_DATE,
357 X_LAST_UPDATED_BY,
358 X_LAST_UPDATE_LOGIN,
359 X_CREATED_BY,
360 X_CREATION_DATE,
361 L.LANGUAGE_CODE,
362 userenv('LANG')
363 from FND_LANGUAGES L
364 where L.INSTALLED_FLAG in ('I', 'B')
365 and not exists
366 (select NULL
367 from MTH_ITEMS_EXT_TL T
368 where T.EXTENSION_ID = X_EXTENSION_ID
369 and T.LANGUAGE = L.LANGUAGE_CODE);
370
371 open c;
372 fetch c into X_ROWID;
373 if (c%notfound) then
374 close c;
375 raise no_data_found;
376 end if;
377 close c;
378
379 end INSERT_ROW;
380
381 procedure LOCK_ROW (
382 X_EXTENSION_ID in NUMBER,
383 X_ATTR_GROUP_ID in NUMBER,
384 X_ITEM_PK_KEY in NUMBER,
385 X_C_EXT_ATTR1 in VARCHAR2,
386 X_C_EXT_ATTR2 in VARCHAR2,
387 X_C_EXT_ATTR3 in VARCHAR2,
388 X_C_EXT_ATTR4 in VARCHAR2,
389 X_C_EXT_ATTR5 in VARCHAR2,
390 X_C_EXT_ATTR6 in VARCHAR2,
391 X_C_EXT_ATTR7 in VARCHAR2,
392 X_C_EXT_ATTR8 in VARCHAR2,
393 X_C_EXT_ATTR9 in VARCHAR2,
394 X_C_EXT_ATTR10 in VARCHAR2,
395 X_C_EXT_ATTR11 in VARCHAR2,
396 X_C_EXT_ATTR12 in VARCHAR2,
397 X_C_EXT_ATTR13 in VARCHAR2,
398 X_C_EXT_ATTR14 in VARCHAR2,
399 X_C_EXT_ATTR15 in VARCHAR2,
400 X_C_EXT_ATTR16 in VARCHAR2,
401 X_C_EXT_ATTR17 in VARCHAR2,
402 X_C_EXT_ATTR18 in VARCHAR2,
403 X_C_EXT_ATTR19 in VARCHAR2,
404 X_C_EXT_ATTR20 in VARCHAR2,
405 X_C_EXT_ATTR21 in VARCHAR2,
406 X_C_EXT_ATTR22 in VARCHAR2,
407 X_C_EXT_ATTR23 in VARCHAR2,
408 X_C_EXT_ATTR24 in VARCHAR2,
409 X_C_EXT_ATTR25 in VARCHAR2,
410 X_C_EXT_ATTR26 in VARCHAR2,
411 X_C_EXT_ATTR27 in VARCHAR2,
412 X_C_EXT_ATTR28 in VARCHAR2,
413 X_C_EXT_ATTR29 in VARCHAR2,
414 X_C_EXT_ATTR30 in VARCHAR2,
415 X_N_EXT_ATTR1 in NUMBER,
416 X_N_EXT_ATTR2 in NUMBER,
417 X_N_EXT_ATTR3 in NUMBER,
418 X_N_EXT_ATTR4 in NUMBER,
419 X_N_EXT_ATTR5 in NUMBER,
420 X_N_EXT_ATTR6 in NUMBER,
421 X_N_EXT_ATTR7 in NUMBER,
422 X_N_EXT_ATTR8 in NUMBER,
423 X_N_EXT_ATTR9 in NUMBER,
424 X_N_EXT_ATTR10 in NUMBER,
425 X_N_EXT_ATTR11 in NUMBER,
426 X_N_EXT_ATTR12 in NUMBER,
427 X_N_EXT_ATTR13 in NUMBER,
428 X_N_EXT_ATTR14 in NUMBER,
429 X_N_EXT_ATTR15 in NUMBER,
430 X_N_EXT_ATTR16 in NUMBER,
431 X_N_EXT_ATTR17 in NUMBER,
432 X_N_EXT_ATTR18 in NUMBER,
433 X_N_EXT_ATTR19 in NUMBER,
434 X_N_EXT_ATTR20 in NUMBER,
435 X_D_EXT_ATTR1 in DATE,
436 X_D_EXT_ATTR2 in DATE,
437 X_D_EXT_ATTR3 in DATE,
438 X_D_EXT_ATTR4 in DATE,
439 X_D_EXT_ATTR5 in DATE,
440 X_D_EXT_ATTR6 in DATE,
441 X_D_EXT_ATTR7 in DATE,
442 X_D_EXT_ATTR8 in DATE,
443 X_D_EXT_ATTR9 in DATE,
444 X_D_EXT_ATTR10 in DATE,
445 X_D_EXT_ATTR11 in DATE,
446 X_D_EXT_ATTR12 in DATE,
447 X_D_EXT_ATTR13 in DATE,
448 X_D_EXT_ATTR14 in DATE,
449 X_D_EXT_ATTR15 in DATE,
450 X_D_EXT_ATTR16 in DATE,
451 X_D_EXT_ATTR17 in DATE,
452 X_D_EXT_ATTR18 in DATE,
453 X_D_EXT_ATTR19 in DATE,
454 X_D_EXT_ATTR20 in DATE,
455 X_TL_EXT_ATTR1 in VARCHAR2,
456 X_TL_EXT_ATTR2 in VARCHAR2,
457 X_TL_EXT_ATTR3 in VARCHAR2,
458 X_TL_EXT_ATTR4 in VARCHAR2,
459 X_TL_EXT_ATTR5 in VARCHAR2,
460 X_TL_EXT_ATTR6 in VARCHAR2,
461 X_TL_EXT_ATTR7 in VARCHAR2,
462 X_TL_EXT_ATTR8 in VARCHAR2,
463 X_TL_EXT_ATTR9 in VARCHAR2,
464 X_TL_EXT_ATTR10 in VARCHAR2,
465 X_TL_EXT_ATTR11 in VARCHAR2,
466 X_TL_EXT_ATTR12 in VARCHAR2,
467 X_TL_EXT_ATTR13 in VARCHAR2,
468 X_TL_EXT_ATTR14 in VARCHAR2,
469 X_TL_EXT_ATTR15 in VARCHAR2,
470 X_TL_EXT_ATTR16 in VARCHAR2,
471 X_TL_EXT_ATTR17 in VARCHAR2,
472 X_TL_EXT_ATTR18 in VARCHAR2,
473 X_TL_EXT_ATTR19 in VARCHAR2,
474 X_TL_EXT_ATTR20 in VARCHAR2,
475 X_TL_EXT_ATTR21 in VARCHAR2,
476 X_TL_EXT_ATTR22 in VARCHAR2,
477 X_TL_EXT_ATTR23 in VARCHAR2,
478 X_TL_EXT_ATTR24 in VARCHAR2,
479 X_TL_EXT_ATTR25 in VARCHAR2,
480 X_TL_EXT_ATTR26 in VARCHAR2,
481 X_TL_EXT_ATTR27 in VARCHAR2,
482 X_TL_EXT_ATTR28 in VARCHAR2,
483 X_TL_EXT_ATTR29 in VARCHAR2,
484 X_TL_EXT_ATTR30 in VARCHAR2
485 ) is
486 cursor c is select
487 ATTR_GROUP_ID,
488 ITEM_PK_KEY,
489 C_EXT_ATTR1,
490 C_EXT_ATTR2,
491 C_EXT_ATTR3,
492 C_EXT_ATTR4,
493 C_EXT_ATTR5,
494 C_EXT_ATTR6,
495 C_EXT_ATTR7,
496 C_EXT_ATTR8,
497 C_EXT_ATTR9,
498 C_EXT_ATTR10,
499 C_EXT_ATTR11,
500 C_EXT_ATTR12,
501 C_EXT_ATTR13,
502 C_EXT_ATTR14,
503 C_EXT_ATTR15,
504 C_EXT_ATTR16,
505 C_EXT_ATTR17,
506 C_EXT_ATTR18,
507 C_EXT_ATTR19,
508 C_EXT_ATTR20,
509 C_EXT_ATTR21,
510 C_EXT_ATTR22,
511 C_EXT_ATTR23,
512 C_EXT_ATTR24,
513 C_EXT_ATTR25,
514 C_EXT_ATTR26,
515 C_EXT_ATTR27,
516 C_EXT_ATTR28,
517 C_EXT_ATTR29,
518 C_EXT_ATTR30,
519 N_EXT_ATTR1,
520 N_EXT_ATTR2,
521 N_EXT_ATTR3,
522 N_EXT_ATTR4,
523 N_EXT_ATTR5,
524 N_EXT_ATTR6,
525 N_EXT_ATTR7,
526 N_EXT_ATTR8,
527 N_EXT_ATTR9,
528 N_EXT_ATTR10,
529 N_EXT_ATTR11,
530 N_EXT_ATTR12,
531 N_EXT_ATTR13,
532 N_EXT_ATTR14,
533 N_EXT_ATTR15,
534 N_EXT_ATTR16,
535 N_EXT_ATTR17,
536 N_EXT_ATTR18,
537 N_EXT_ATTR19,
538 N_EXT_ATTR20,
539 D_EXT_ATTR1,
540 D_EXT_ATTR2,
541 D_EXT_ATTR3,
542 D_EXT_ATTR4,
543 D_EXT_ATTR5,
544 D_EXT_ATTR6,
545 D_EXT_ATTR7,
546 D_EXT_ATTR8,
547 D_EXT_ATTR9,
548 D_EXT_ATTR10,
549 D_EXT_ATTR11,
550 D_EXT_ATTR12,
551 D_EXT_ATTR13,
552 D_EXT_ATTR14,
553 D_EXT_ATTR15,
554 D_EXT_ATTR16,
555 D_EXT_ATTR17,
556 D_EXT_ATTR18,
557 D_EXT_ATTR19,
558 D_EXT_ATTR20
559 from MTH_ITEMS_EXT_B
560 where EXTENSION_ID = X_EXTENSION_ID
561 for update of EXTENSION_ID nowait;
562 recinfo c%rowtype;
563
564 cursor c1 is select
565 TL_EXT_ATTR1,
566 TL_EXT_ATTR2,
567 TL_EXT_ATTR3,
568 TL_EXT_ATTR4,
569 TL_EXT_ATTR5,
570 TL_EXT_ATTR6,
571 TL_EXT_ATTR7,
572 TL_EXT_ATTR8,
573 TL_EXT_ATTR9,
574 TL_EXT_ATTR10,
575 TL_EXT_ATTR11,
579 TL_EXT_ATTR15,
576 TL_EXT_ATTR12,
577 TL_EXT_ATTR13,
578 TL_EXT_ATTR14,
580 TL_EXT_ATTR16,
581 TL_EXT_ATTR17,
582 TL_EXT_ATTR18,
583 TL_EXT_ATTR19,
584 TL_EXT_ATTR20,
585 TL_EXT_ATTR21,
586 TL_EXT_ATTR22,
587 TL_EXT_ATTR23,
588 TL_EXT_ATTR24,
589 TL_EXT_ATTR25,
590 TL_EXT_ATTR26,
591 TL_EXT_ATTR27,
592 TL_EXT_ATTR28,
593 TL_EXT_ATTR29,
594 TL_EXT_ATTR30,
595 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
596 from MTH_ITEMS_EXT_TL
597 where EXTENSION_ID = X_EXTENSION_ID
598 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
599 for update of EXTENSION_ID nowait;
600 begin
601 open c;
602 fetch c into recinfo;
603 if (c%notfound) then
604 close c;
605 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
606 app_exception.raise_exception;
607 end if;
608 close c;
609 if ( ((recinfo.ATTR_GROUP_ID = X_ATTR_GROUP_ID)
610 OR ((recinfo.ATTR_GROUP_ID is null) AND (X_ATTR_GROUP_ID is null)))
611 AND ((recinfo.ITEM_PK_KEY = X_ITEM_PK_KEY)
612 OR ((recinfo.ITEM_PK_KEY is null) AND (X_ITEM_PK_KEY is null)))
613 AND ((recinfo.C_EXT_ATTR1 = X_C_EXT_ATTR1)
614 OR ((recinfo.C_EXT_ATTR1 is null) AND (X_C_EXT_ATTR1 is null)))
615 AND ((recinfo.C_EXT_ATTR2 = X_C_EXT_ATTR2)
616 OR ((recinfo.C_EXT_ATTR2 is null) AND (X_C_EXT_ATTR2 is null)))
617 AND ((recinfo.C_EXT_ATTR3 = X_C_EXT_ATTR3)
618 OR ((recinfo.C_EXT_ATTR3 is null) AND (X_C_EXT_ATTR3 is null)))
619 AND ((recinfo.C_EXT_ATTR4 = X_C_EXT_ATTR4)
620 OR ((recinfo.C_EXT_ATTR4 is null) AND (X_C_EXT_ATTR4 is null)))
621 AND ((recinfo.C_EXT_ATTR5 = X_C_EXT_ATTR5)
622 OR ((recinfo.C_EXT_ATTR5 is null) AND (X_C_EXT_ATTR5 is null)))
623 AND ((recinfo.C_EXT_ATTR6 = X_C_EXT_ATTR6)
624 OR ((recinfo.C_EXT_ATTR6 is null) AND (X_C_EXT_ATTR6 is null)))
625 AND ((recinfo.C_EXT_ATTR7 = X_C_EXT_ATTR7)
626 OR ((recinfo.C_EXT_ATTR7 is null) AND (X_C_EXT_ATTR7 is null)))
627 AND ((recinfo.C_EXT_ATTR8 = X_C_EXT_ATTR8)
628 OR ((recinfo.C_EXT_ATTR8 is null) AND (X_C_EXT_ATTR8 is null)))
629 AND ((recinfo.C_EXT_ATTR9 = X_C_EXT_ATTR9)
630 OR ((recinfo.C_EXT_ATTR9 is null) AND (X_C_EXT_ATTR9 is null)))
631 AND ((recinfo.C_EXT_ATTR10 = X_C_EXT_ATTR10)
632 OR ((recinfo.C_EXT_ATTR10 is null) AND (X_C_EXT_ATTR10 is null)))
633 AND ((recinfo.C_EXT_ATTR11 = X_C_EXT_ATTR11)
634 OR ((recinfo.C_EXT_ATTR11 is null) AND (X_C_EXT_ATTR11 is null)))
635 AND ((recinfo.C_EXT_ATTR12 = X_C_EXT_ATTR12)
636 OR ((recinfo.C_EXT_ATTR12 is null) AND (X_C_EXT_ATTR12 is null)))
637 AND ((recinfo.C_EXT_ATTR13 = X_C_EXT_ATTR13)
638 OR ((recinfo.C_EXT_ATTR13 is null) AND (X_C_EXT_ATTR13 is null)))
639 AND ((recinfo.C_EXT_ATTR14 = X_C_EXT_ATTR14)
640 OR ((recinfo.C_EXT_ATTR14 is null) AND (X_C_EXT_ATTR14 is null)))
641 AND ((recinfo.C_EXT_ATTR15 = X_C_EXT_ATTR15)
642 OR ((recinfo.C_EXT_ATTR15 is null) AND (X_C_EXT_ATTR15 is null)))
643 AND ((recinfo.C_EXT_ATTR16 = X_C_EXT_ATTR16)
644 OR ((recinfo.C_EXT_ATTR16 is null) AND (X_C_EXT_ATTR16 is null)))
645 AND ((recinfo.C_EXT_ATTR17 = X_C_EXT_ATTR17)
646 OR ((recinfo.C_EXT_ATTR17 is null) AND (X_C_EXT_ATTR17 is null)))
647 AND ((recinfo.C_EXT_ATTR18 = X_C_EXT_ATTR18)
648 OR ((recinfo.C_EXT_ATTR18 is null) AND (X_C_EXT_ATTR18 is null)))
649 AND ((recinfo.C_EXT_ATTR19 = X_C_EXT_ATTR19)
650 OR ((recinfo.C_EXT_ATTR19 is null) AND (X_C_EXT_ATTR19 is null)))
651 AND ((recinfo.C_EXT_ATTR20 = X_C_EXT_ATTR20)
652 OR ((recinfo.C_EXT_ATTR20 is null) AND (X_C_EXT_ATTR20 is null)))
653 AND ((recinfo.C_EXT_ATTR21 = X_C_EXT_ATTR21)
654 OR ((recinfo.C_EXT_ATTR21 is null) AND (X_C_EXT_ATTR21 is null)))
655 AND ((recinfo.C_EXT_ATTR22 = X_C_EXT_ATTR22)
656 OR ((recinfo.C_EXT_ATTR22 is null) AND (X_C_EXT_ATTR22 is null)))
657 AND ((recinfo.C_EXT_ATTR23 = X_C_EXT_ATTR23)
658 OR ((recinfo.C_EXT_ATTR23 is null) AND (X_C_EXT_ATTR23 is null)))
659 AND ((recinfo.C_EXT_ATTR24 = X_C_EXT_ATTR24)
660 OR ((recinfo.C_EXT_ATTR24 is null) AND (X_C_EXT_ATTR24 is null)))
661 AND ((recinfo.C_EXT_ATTR25 = X_C_EXT_ATTR25)
662 OR ((recinfo.C_EXT_ATTR25 is null) AND (X_C_EXT_ATTR25 is null)))
663 AND ((recinfo.C_EXT_ATTR26 = X_C_EXT_ATTR26)
664 OR ((recinfo.C_EXT_ATTR26 is null) AND (X_C_EXT_ATTR26 is null)))
665 AND ((recinfo.C_EXT_ATTR27 = X_C_EXT_ATTR27)
666 OR ((recinfo.C_EXT_ATTR27 is null) AND (X_C_EXT_ATTR27 is null)))
667 AND ((recinfo.C_EXT_ATTR28 = X_C_EXT_ATTR28)
668 OR ((recinfo.C_EXT_ATTR28 is null) AND (X_C_EXT_ATTR28 is null)))
669 AND ((recinfo.C_EXT_ATTR29 = X_C_EXT_ATTR29)
670 OR ((recinfo.C_EXT_ATTR29 is null) AND (X_C_EXT_ATTR29 is null)))
671 AND ((recinfo.C_EXT_ATTR30 = X_C_EXT_ATTR30)
672 OR ((recinfo.C_EXT_ATTR30 is null) AND (X_C_EXT_ATTR30 is null)))
673 AND ((recinfo.N_EXT_ATTR1 = X_N_EXT_ATTR1)
674 OR ((recinfo.N_EXT_ATTR1 is null) AND (X_N_EXT_ATTR1 is null)))
675 AND ((recinfo.N_EXT_ATTR2 = X_N_EXT_ATTR2)
676 OR ((recinfo.N_EXT_ATTR2 is null) AND (X_N_EXT_ATTR2 is null)))
677 AND ((recinfo.N_EXT_ATTR3 = X_N_EXT_ATTR3)
678 OR ((recinfo.N_EXT_ATTR3 is null) AND (X_N_EXT_ATTR3 is null)))
679 AND ((recinfo.N_EXT_ATTR4 = X_N_EXT_ATTR4)
680 OR ((recinfo.N_EXT_ATTR4 is null) AND (X_N_EXT_ATTR4 is null)))
681 AND ((recinfo.N_EXT_ATTR5 = X_N_EXT_ATTR5)
682 OR ((recinfo.N_EXT_ATTR5 is null) AND (X_N_EXT_ATTR5 is null)))
683 AND ((recinfo.N_EXT_ATTR6 = X_N_EXT_ATTR6)
684 OR ((recinfo.N_EXT_ATTR6 is null) AND (X_N_EXT_ATTR6 is null)))
688 OR ((recinfo.N_EXT_ATTR8 is null) AND (X_N_EXT_ATTR8 is null)))
685 AND ((recinfo.N_EXT_ATTR7 = X_N_EXT_ATTR7)
686 OR ((recinfo.N_EXT_ATTR7 is null) AND (X_N_EXT_ATTR7 is null)))
687 AND ((recinfo.N_EXT_ATTR8 = X_N_EXT_ATTR8)
689 AND ((recinfo.N_EXT_ATTR9 = X_N_EXT_ATTR9)
690 OR ((recinfo.N_EXT_ATTR9 is null) AND (X_N_EXT_ATTR9 is null)))
691 AND ((recinfo.N_EXT_ATTR10 = X_N_EXT_ATTR10)
692 OR ((recinfo.N_EXT_ATTR10 is null) AND (X_N_EXT_ATTR10 is null)))
693 AND ((recinfo.N_EXT_ATTR11 = X_N_EXT_ATTR11)
694 OR ((recinfo.N_EXT_ATTR11 is null) AND (X_N_EXT_ATTR11 is null)))
695 AND ((recinfo.N_EXT_ATTR12 = X_N_EXT_ATTR12)
696 OR ((recinfo.N_EXT_ATTR12 is null) AND (X_N_EXT_ATTR12 is null)))
697 AND ((recinfo.N_EXT_ATTR13 = X_N_EXT_ATTR13)
698 OR ((recinfo.N_EXT_ATTR13 is null) AND (X_N_EXT_ATTR13 is null)))
699 AND ((recinfo.N_EXT_ATTR14 = X_N_EXT_ATTR14)
700 OR ((recinfo.N_EXT_ATTR14 is null) AND (X_N_EXT_ATTR14 is null)))
701 AND ((recinfo.N_EXT_ATTR15 = X_N_EXT_ATTR15)
702 OR ((recinfo.N_EXT_ATTR15 is null) AND (X_N_EXT_ATTR15 is null)))
703 AND ((recinfo.N_EXT_ATTR16 = X_N_EXT_ATTR16)
704 OR ((recinfo.N_EXT_ATTR16 is null) AND (X_N_EXT_ATTR16 is null)))
705 AND ((recinfo.N_EXT_ATTR17 = X_N_EXT_ATTR17)
706 OR ((recinfo.N_EXT_ATTR17 is null) AND (X_N_EXT_ATTR17 is null)))
707 AND ((recinfo.N_EXT_ATTR18 = X_N_EXT_ATTR18)
708 OR ((recinfo.N_EXT_ATTR18 is null) AND (X_N_EXT_ATTR18 is null)))
709 AND ((recinfo.N_EXT_ATTR19 = X_N_EXT_ATTR19)
710 OR ((recinfo.N_EXT_ATTR19 is null) AND (X_N_EXT_ATTR19 is null)))
711 AND ((recinfo.N_EXT_ATTR20 = X_N_EXT_ATTR20)
712 OR ((recinfo.N_EXT_ATTR20 is null) AND (X_N_EXT_ATTR20 is null)))
713 AND ((recinfo.D_EXT_ATTR1 = X_D_EXT_ATTR1)
714 OR ((recinfo.D_EXT_ATTR1 is null) AND (X_D_EXT_ATTR1 is null)))
715 AND ((recinfo.D_EXT_ATTR2 = X_D_EXT_ATTR2)
716 OR ((recinfo.D_EXT_ATTR2 is null) AND (X_D_EXT_ATTR2 is null)))
717 AND ((recinfo.D_EXT_ATTR3 = X_D_EXT_ATTR3)
718 OR ((recinfo.D_EXT_ATTR3 is null) AND (X_D_EXT_ATTR3 is null)))
719 AND ((recinfo.D_EXT_ATTR4 = X_D_EXT_ATTR4)
720 OR ((recinfo.D_EXT_ATTR4 is null) AND (X_D_EXT_ATTR4 is null)))
721 AND ((recinfo.D_EXT_ATTR5 = X_D_EXT_ATTR5)
722 OR ((recinfo.D_EXT_ATTR5 is null) AND (X_D_EXT_ATTR5 is null)))
723 AND ((recinfo.D_EXT_ATTR6 = X_D_EXT_ATTR6)
724 OR ((recinfo.D_EXT_ATTR6 is null) AND (X_D_EXT_ATTR6 is null)))
725 AND ((recinfo.D_EXT_ATTR7 = X_D_EXT_ATTR7)
726 OR ((recinfo.D_EXT_ATTR7 is null) AND (X_D_EXT_ATTR7 is null)))
727 AND ((recinfo.D_EXT_ATTR8 = X_D_EXT_ATTR8)
728 OR ((recinfo.D_EXT_ATTR8 is null) AND (X_D_EXT_ATTR8 is null)))
729 AND ((recinfo.D_EXT_ATTR9 = X_D_EXT_ATTR9)
730 OR ((recinfo.D_EXT_ATTR9 is null) AND (X_D_EXT_ATTR9 is null)))
731 AND ((recinfo.D_EXT_ATTR10 = X_D_EXT_ATTR10)
732 OR ((recinfo.D_EXT_ATTR10 is null) AND (X_D_EXT_ATTR10 is null)))
733 AND ((recinfo.D_EXT_ATTR11 = X_D_EXT_ATTR11)
734 OR ((recinfo.D_EXT_ATTR11 is null) AND (X_D_EXT_ATTR11 is null)))
735 AND ((recinfo.D_EXT_ATTR12 = X_D_EXT_ATTR12)
736 OR ((recinfo.D_EXT_ATTR12 is null) AND (X_D_EXT_ATTR12 is null)))
737 AND ((recinfo.D_EXT_ATTR13 = X_D_EXT_ATTR13)
738 OR ((recinfo.D_EXT_ATTR13 is null) AND (X_D_EXT_ATTR13 is null)))
739 AND ((recinfo.D_EXT_ATTR14 = X_D_EXT_ATTR14)
740 OR ((recinfo.D_EXT_ATTR14 is null) AND (X_D_EXT_ATTR14 is null)))
741 AND ((recinfo.D_EXT_ATTR15 = X_D_EXT_ATTR15)
742 OR ((recinfo.D_EXT_ATTR15 is null) AND (X_D_EXT_ATTR15 is null)))
743 AND ((recinfo.D_EXT_ATTR16 = X_D_EXT_ATTR16)
744 OR ((recinfo.D_EXT_ATTR16 is null) AND (X_D_EXT_ATTR16 is null)))
745 AND ((recinfo.D_EXT_ATTR17 = X_D_EXT_ATTR17)
746 OR ((recinfo.D_EXT_ATTR17 is null) AND (X_D_EXT_ATTR17 is null)))
747 AND ((recinfo.D_EXT_ATTR18 = X_D_EXT_ATTR18)
748 OR ((recinfo.D_EXT_ATTR18 is null) AND (X_D_EXT_ATTR18 is null)))
749 AND ((recinfo.D_EXT_ATTR19 = X_D_EXT_ATTR19)
750 OR ((recinfo.D_EXT_ATTR19 is null) AND (X_D_EXT_ATTR19 is null)))
751 AND ((recinfo.D_EXT_ATTR20 = X_D_EXT_ATTR20)
752 OR ((recinfo.D_EXT_ATTR20 is null) AND (X_D_EXT_ATTR20 is null)))
753 ) then
754 null;
755 else
756 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
757 app_exception.raise_exception;
758 end if;
759
760 for tlinfo in c1 loop
761 if (tlinfo.BASELANG = 'Y') then
762 if ( ((tlinfo.TL_EXT_ATTR1 = X_TL_EXT_ATTR1)
763 OR ((tlinfo.TL_EXT_ATTR1 is null) AND (X_TL_EXT_ATTR1 is null)))
764 AND ((tlinfo.TL_EXT_ATTR2 = X_TL_EXT_ATTR2)
765 OR ((tlinfo.TL_EXT_ATTR2 is null) AND (X_TL_EXT_ATTR2 is null)))
766 AND ((tlinfo.TL_EXT_ATTR3 = X_TL_EXT_ATTR3)
767 OR ((tlinfo.TL_EXT_ATTR3 is null) AND (X_TL_EXT_ATTR3 is null)))
768 AND ((tlinfo.TL_EXT_ATTR4 = X_TL_EXT_ATTR4)
769 OR ((tlinfo.TL_EXT_ATTR4 is null) AND (X_TL_EXT_ATTR4 is null)))
770 AND ((tlinfo.TL_EXT_ATTR5 = X_TL_EXT_ATTR5)
771 OR ((tlinfo.TL_EXT_ATTR5 is null) AND (X_TL_EXT_ATTR5 is null)))
772 AND ((tlinfo.TL_EXT_ATTR6 = X_TL_EXT_ATTR6)
773 OR ((tlinfo.TL_EXT_ATTR6 is null) AND (X_TL_EXT_ATTR6 is null)))
774 AND ((tlinfo.TL_EXT_ATTR7 = X_TL_EXT_ATTR7)
775 OR ((tlinfo.TL_EXT_ATTR7 is null) AND (X_TL_EXT_ATTR7 is null)))
776 AND ((tlinfo.TL_EXT_ATTR8 = X_TL_EXT_ATTR8)
777 OR ((tlinfo.TL_EXT_ATTR8 is null) AND (X_TL_EXT_ATTR8 is null)))
778 AND ((tlinfo.TL_EXT_ATTR9 = X_TL_EXT_ATTR9)
779 OR ((tlinfo.TL_EXT_ATTR9 is null) AND (X_TL_EXT_ATTR9 is null)))
780 AND ((tlinfo.TL_EXT_ATTR10 = X_TL_EXT_ATTR10)
781 OR ((tlinfo.TL_EXT_ATTR10 is null) AND (X_TL_EXT_ATTR10 is null)))
785 OR ((tlinfo.TL_EXT_ATTR12 is null) AND (X_TL_EXT_ATTR12 is null)))
782 AND ((tlinfo.TL_EXT_ATTR11 = X_TL_EXT_ATTR11)
783 OR ((tlinfo.TL_EXT_ATTR11 is null) AND (X_TL_EXT_ATTR11 is null)))
784 AND ((tlinfo.TL_EXT_ATTR12 = X_TL_EXT_ATTR12)
786 AND ((tlinfo.TL_EXT_ATTR13 = X_TL_EXT_ATTR13)
787 OR ((tlinfo.TL_EXT_ATTR13 is null) AND (X_TL_EXT_ATTR13 is null)))
788 AND ((tlinfo.TL_EXT_ATTR14 = X_TL_EXT_ATTR14)
789 OR ((tlinfo.TL_EXT_ATTR14 is null) AND (X_TL_EXT_ATTR14 is null)))
790 AND ((tlinfo.TL_EXT_ATTR15 = X_TL_EXT_ATTR15)
791 OR ((tlinfo.TL_EXT_ATTR15 is null) AND (X_TL_EXT_ATTR15 is null)))
792 AND ((tlinfo.TL_EXT_ATTR16 = X_TL_EXT_ATTR16)
793 OR ((tlinfo.TL_EXT_ATTR16 is null) AND (X_TL_EXT_ATTR16 is null)))
794 AND ((tlinfo.TL_EXT_ATTR17 = X_TL_EXT_ATTR17)
795 OR ((tlinfo.TL_EXT_ATTR17 is null) AND (X_TL_EXT_ATTR17 is null)))
796 AND ((tlinfo.TL_EXT_ATTR18 = X_TL_EXT_ATTR18)
797 OR ((tlinfo.TL_EXT_ATTR18 is null) AND (X_TL_EXT_ATTR18 is null)))
798 AND ((tlinfo.TL_EXT_ATTR19 = X_TL_EXT_ATTR19)
799 OR ((tlinfo.TL_EXT_ATTR19 is null) AND (X_TL_EXT_ATTR19 is null)))
800 AND ((tlinfo.TL_EXT_ATTR20 = X_TL_EXT_ATTR20)
801 OR ((tlinfo.TL_EXT_ATTR20 is null) AND (X_TL_EXT_ATTR20 is null)))
802 AND ((tlinfo.TL_EXT_ATTR21 = X_TL_EXT_ATTR21)
803 OR ((tlinfo.TL_EXT_ATTR21 is null) AND (X_TL_EXT_ATTR21 is null)))
804 AND ((tlinfo.TL_EXT_ATTR22 = X_TL_EXT_ATTR22)
805 OR ((tlinfo.TL_EXT_ATTR22 is null) AND (X_TL_EXT_ATTR22 is null)))
806 AND ((tlinfo.TL_EXT_ATTR23 = X_TL_EXT_ATTR23)
807 OR ((tlinfo.TL_EXT_ATTR23 is null) AND (X_TL_EXT_ATTR23 is null)))
808 AND ((tlinfo.TL_EXT_ATTR24 = X_TL_EXT_ATTR24)
809 OR ((tlinfo.TL_EXT_ATTR24 is null) AND (X_TL_EXT_ATTR24 is null)))
810 AND ((tlinfo.TL_EXT_ATTR25 = X_TL_EXT_ATTR25)
811 OR ((tlinfo.TL_EXT_ATTR25 is null) AND (X_TL_EXT_ATTR25 is null)))
812 AND ((tlinfo.TL_EXT_ATTR26 = X_TL_EXT_ATTR26)
813 OR ((tlinfo.TL_EXT_ATTR26 is null) AND (X_TL_EXT_ATTR26 is null)))
814 AND ((tlinfo.TL_EXT_ATTR27 = X_TL_EXT_ATTR27)
815 OR ((tlinfo.TL_EXT_ATTR27 is null) AND (X_TL_EXT_ATTR27 is null)))
816 AND ((tlinfo.TL_EXT_ATTR28 = X_TL_EXT_ATTR28)
817 OR ((tlinfo.TL_EXT_ATTR28 is null) AND (X_TL_EXT_ATTR28 is null)))
818 AND ((tlinfo.TL_EXT_ATTR29 = X_TL_EXT_ATTR29)
819 OR ((tlinfo.TL_EXT_ATTR29 is null) AND (X_TL_EXT_ATTR29 is null)))
820 AND ((tlinfo.TL_EXT_ATTR30 = X_TL_EXT_ATTR30)
821 OR ((tlinfo.TL_EXT_ATTR30 is null) AND (X_TL_EXT_ATTR30 is null)))
822 ) then
823 null;
824 else
825 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
826 app_exception.raise_exception;
827 end if;
828 end if;
829 end loop;
830 return;
831 end LOCK_ROW;
832
833 procedure UPDATE_ROW (
834 X_EXTENSION_ID in NUMBER,
835 X_ATTR_GROUP_ID in NUMBER,
836 X_ITEM_PK_KEY in NUMBER,
837 X_C_EXT_ATTR1 in VARCHAR2,
838 X_C_EXT_ATTR2 in VARCHAR2,
839 X_C_EXT_ATTR3 in VARCHAR2,
840 X_C_EXT_ATTR4 in VARCHAR2,
841 X_C_EXT_ATTR5 in VARCHAR2,
842 X_C_EXT_ATTR6 in VARCHAR2,
843 X_C_EXT_ATTR7 in VARCHAR2,
844 X_C_EXT_ATTR8 in VARCHAR2,
845 X_C_EXT_ATTR9 in VARCHAR2,
846 X_C_EXT_ATTR10 in VARCHAR2,
847 X_C_EXT_ATTR11 in VARCHAR2,
848 X_C_EXT_ATTR12 in VARCHAR2,
849 X_C_EXT_ATTR13 in VARCHAR2,
850 X_C_EXT_ATTR14 in VARCHAR2,
851 X_C_EXT_ATTR15 in VARCHAR2,
852 X_C_EXT_ATTR16 in VARCHAR2,
853 X_C_EXT_ATTR17 in VARCHAR2,
854 X_C_EXT_ATTR18 in VARCHAR2,
855 X_C_EXT_ATTR19 in VARCHAR2,
856 X_C_EXT_ATTR20 in VARCHAR2,
857 X_C_EXT_ATTR21 in VARCHAR2,
858 X_C_EXT_ATTR22 in VARCHAR2,
859 X_C_EXT_ATTR23 in VARCHAR2,
860 X_C_EXT_ATTR24 in VARCHAR2,
861 X_C_EXT_ATTR25 in VARCHAR2,
862 X_C_EXT_ATTR26 in VARCHAR2,
863 X_C_EXT_ATTR27 in VARCHAR2,
864 X_C_EXT_ATTR28 in VARCHAR2,
865 X_C_EXT_ATTR29 in VARCHAR2,
866 X_C_EXT_ATTR30 in VARCHAR2,
867 X_N_EXT_ATTR1 in NUMBER,
868 X_N_EXT_ATTR2 in NUMBER,
869 X_N_EXT_ATTR3 in NUMBER,
870 X_N_EXT_ATTR4 in NUMBER,
871 X_N_EXT_ATTR5 in NUMBER,
872 X_N_EXT_ATTR6 in NUMBER,
873 X_N_EXT_ATTR7 in NUMBER,
874 X_N_EXT_ATTR8 in NUMBER,
875 X_N_EXT_ATTR9 in NUMBER,
876 X_N_EXT_ATTR10 in NUMBER,
877 X_N_EXT_ATTR11 in NUMBER,
878 X_N_EXT_ATTR12 in NUMBER,
879 X_N_EXT_ATTR13 in NUMBER,
880 X_N_EXT_ATTR14 in NUMBER,
881 X_N_EXT_ATTR15 in NUMBER,
882 X_N_EXT_ATTR16 in NUMBER,
883 X_N_EXT_ATTR17 in NUMBER,
884 X_N_EXT_ATTR18 in NUMBER,
885 X_N_EXT_ATTR19 in NUMBER,
886 X_N_EXT_ATTR20 in NUMBER,
887 X_D_EXT_ATTR1 in DATE,
888 X_D_EXT_ATTR2 in DATE,
889 X_D_EXT_ATTR3 in DATE,
890 X_D_EXT_ATTR4 in DATE,
891 X_D_EXT_ATTR5 in DATE,
892 X_D_EXT_ATTR6 in DATE,
893 X_D_EXT_ATTR7 in DATE,
894 X_D_EXT_ATTR8 in DATE,
895 X_D_EXT_ATTR9 in DATE,
896 X_D_EXT_ATTR10 in DATE,
897 X_D_EXT_ATTR11 in DATE,
898 X_D_EXT_ATTR12 in DATE,
899 X_D_EXT_ATTR13 in DATE,
900 X_D_EXT_ATTR14 in DATE,
901 X_D_EXT_ATTR15 in DATE,
902 X_D_EXT_ATTR16 in DATE,
903 X_D_EXT_ATTR17 in DATE,
904 X_D_EXT_ATTR18 in DATE,
905 X_D_EXT_ATTR19 in DATE,
906 X_D_EXT_ATTR20 in DATE,
907 X_TL_EXT_ATTR1 in VARCHAR2,
908 X_TL_EXT_ATTR2 in VARCHAR2,
909 X_TL_EXT_ATTR3 in VARCHAR2,
910 X_TL_EXT_ATTR4 in VARCHAR2,
911 X_TL_EXT_ATTR5 in VARCHAR2,
912 X_TL_EXT_ATTR6 in VARCHAR2,
913 X_TL_EXT_ATTR7 in VARCHAR2,
914 X_TL_EXT_ATTR8 in VARCHAR2,
918 X_TL_EXT_ATTR12 in VARCHAR2,
915 X_TL_EXT_ATTR9 in VARCHAR2,
916 X_TL_EXT_ATTR10 in VARCHAR2,
917 X_TL_EXT_ATTR11 in VARCHAR2,
919 X_TL_EXT_ATTR13 in VARCHAR2,
920 X_TL_EXT_ATTR14 in VARCHAR2,
921 X_TL_EXT_ATTR15 in VARCHAR2,
922 X_TL_EXT_ATTR16 in VARCHAR2,
923 X_TL_EXT_ATTR17 in VARCHAR2,
924 X_TL_EXT_ATTR18 in VARCHAR2,
925 X_TL_EXT_ATTR19 in VARCHAR2,
926 X_TL_EXT_ATTR20 in VARCHAR2,
927 X_TL_EXT_ATTR21 in VARCHAR2,
928 X_TL_EXT_ATTR22 in VARCHAR2,
929 X_TL_EXT_ATTR23 in VARCHAR2,
930 X_TL_EXT_ATTR24 in VARCHAR2,
931 X_TL_EXT_ATTR25 in VARCHAR2,
932 X_TL_EXT_ATTR26 in VARCHAR2,
933 X_TL_EXT_ATTR27 in VARCHAR2,
934 X_TL_EXT_ATTR28 in VARCHAR2,
935 X_TL_EXT_ATTR29 in VARCHAR2,
936 X_TL_EXT_ATTR30 in VARCHAR2,
937 X_LAST_UPDATE_DATE in DATE,
938 X_LAST_UPDATED_BY in NUMBER,
939 X_LAST_UPDATE_LOGIN in NUMBER
940 ) is
941 begin
942 update MTH_ITEMS_EXT_B set
943 ATTR_GROUP_ID = X_ATTR_GROUP_ID,
944 ITEM_PK_KEY = X_ITEM_PK_KEY,
945 C_EXT_ATTR1 = X_C_EXT_ATTR1,
946 C_EXT_ATTR2 = X_C_EXT_ATTR2,
947 C_EXT_ATTR3 = X_C_EXT_ATTR3,
948 C_EXT_ATTR4 = X_C_EXT_ATTR4,
949 C_EXT_ATTR5 = X_C_EXT_ATTR5,
950 C_EXT_ATTR6 = X_C_EXT_ATTR6,
951 C_EXT_ATTR7 = X_C_EXT_ATTR7,
952 C_EXT_ATTR8 = X_C_EXT_ATTR8,
953 C_EXT_ATTR9 = X_C_EXT_ATTR9,
954 C_EXT_ATTR10 = X_C_EXT_ATTR10,
955 C_EXT_ATTR11 = X_C_EXT_ATTR11,
956 C_EXT_ATTR12 = X_C_EXT_ATTR12,
957 C_EXT_ATTR13 = X_C_EXT_ATTR13,
958 C_EXT_ATTR14 = X_C_EXT_ATTR14,
959 C_EXT_ATTR15 = X_C_EXT_ATTR15,
960 C_EXT_ATTR16 = X_C_EXT_ATTR16,
961 C_EXT_ATTR17 = X_C_EXT_ATTR17,
962 C_EXT_ATTR18 = X_C_EXT_ATTR18,
963 C_EXT_ATTR19 = X_C_EXT_ATTR19,
964 C_EXT_ATTR20 = X_C_EXT_ATTR20,
965 C_EXT_ATTR21 = X_C_EXT_ATTR21,
966 C_EXT_ATTR22 = X_C_EXT_ATTR22,
967 C_EXT_ATTR23 = X_C_EXT_ATTR23,
968 C_EXT_ATTR24 = X_C_EXT_ATTR24,
969 C_EXT_ATTR25 = X_C_EXT_ATTR25,
970 C_EXT_ATTR26 = X_C_EXT_ATTR26,
971 C_EXT_ATTR27 = X_C_EXT_ATTR27,
972 C_EXT_ATTR28 = X_C_EXT_ATTR28,
973 C_EXT_ATTR29 = X_C_EXT_ATTR29,
974 C_EXT_ATTR30 = X_C_EXT_ATTR30,
975 N_EXT_ATTR1 = X_N_EXT_ATTR1,
976 N_EXT_ATTR2 = X_N_EXT_ATTR2,
977 N_EXT_ATTR3 = X_N_EXT_ATTR3,
978 N_EXT_ATTR4 = X_N_EXT_ATTR4,
979 N_EXT_ATTR5 = X_N_EXT_ATTR5,
980 N_EXT_ATTR6 = X_N_EXT_ATTR6,
981 N_EXT_ATTR7 = X_N_EXT_ATTR7,
982 N_EXT_ATTR8 = X_N_EXT_ATTR8,
983 N_EXT_ATTR9 = X_N_EXT_ATTR9,
984 N_EXT_ATTR10 = X_N_EXT_ATTR10,
985 N_EXT_ATTR11 = X_N_EXT_ATTR11,
986 N_EXT_ATTR12 = X_N_EXT_ATTR12,
987 N_EXT_ATTR13 = X_N_EXT_ATTR13,
988 N_EXT_ATTR14 = X_N_EXT_ATTR14,
989 N_EXT_ATTR15 = X_N_EXT_ATTR15,
990 N_EXT_ATTR16 = X_N_EXT_ATTR16,
991 N_EXT_ATTR17 = X_N_EXT_ATTR17,
992 N_EXT_ATTR18 = X_N_EXT_ATTR18,
993 N_EXT_ATTR19 = X_N_EXT_ATTR19,
994 N_EXT_ATTR20 = X_N_EXT_ATTR20,
995 D_EXT_ATTR1 = X_D_EXT_ATTR1,
996 D_EXT_ATTR2 = X_D_EXT_ATTR2,
997 D_EXT_ATTR3 = X_D_EXT_ATTR3,
998 D_EXT_ATTR4 = X_D_EXT_ATTR4,
999 D_EXT_ATTR5 = X_D_EXT_ATTR5,
1000 D_EXT_ATTR6 = X_D_EXT_ATTR6,
1001 D_EXT_ATTR7 = X_D_EXT_ATTR7,
1002 D_EXT_ATTR8 = X_D_EXT_ATTR8,
1003 D_EXT_ATTR9 = X_D_EXT_ATTR9,
1004 D_EXT_ATTR10 = X_D_EXT_ATTR10,
1005 D_EXT_ATTR11 = X_D_EXT_ATTR11,
1006 D_EXT_ATTR12 = X_D_EXT_ATTR12,
1007 D_EXT_ATTR13 = X_D_EXT_ATTR13,
1008 D_EXT_ATTR14 = X_D_EXT_ATTR14,
1009 D_EXT_ATTR15 = X_D_EXT_ATTR15,
1010 D_EXT_ATTR16 = X_D_EXT_ATTR16,
1011 D_EXT_ATTR17 = X_D_EXT_ATTR17,
1012 D_EXT_ATTR18 = X_D_EXT_ATTR18,
1013 D_EXT_ATTR19 = X_D_EXT_ATTR19,
1014 D_EXT_ATTR20 = X_D_EXT_ATTR20,
1015 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1016 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1017 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
1018 where EXTENSION_ID = X_EXTENSION_ID;
1019
1020 if (sql%notfound) then
1021 raise no_data_found;
1022 end if;
1023
1024 update MTH_ITEMS_EXT_TL set
1025 TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1026 TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1027 TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1028 TL_EXT_ATTR4 = X_TL_EXT_ATTR4,
1029 TL_EXT_ATTR5 = X_TL_EXT_ATTR5,
1030 TL_EXT_ATTR6 = X_TL_EXT_ATTR6,
1031 TL_EXT_ATTR7 = X_TL_EXT_ATTR7,
1032 TL_EXT_ATTR8 = X_TL_EXT_ATTR8,
1033 TL_EXT_ATTR9 = X_TL_EXT_ATTR9,
1034 TL_EXT_ATTR10 = X_TL_EXT_ATTR10,
1035 TL_EXT_ATTR11 = X_TL_EXT_ATTR11,
1036 TL_EXT_ATTR12 = X_TL_EXT_ATTR12,
1037 TL_EXT_ATTR13 = X_TL_EXT_ATTR13,
1038 TL_EXT_ATTR14 = X_TL_EXT_ATTR14,
1039 TL_EXT_ATTR15 = X_TL_EXT_ATTR15,
1040 TL_EXT_ATTR16 = X_TL_EXT_ATTR16,
1041 TL_EXT_ATTR17 = X_TL_EXT_ATTR17,
1042 TL_EXT_ATTR18 = X_TL_EXT_ATTR18,
1043 TL_EXT_ATTR19 = X_TL_EXT_ATTR19,
1044 TL_EXT_ATTR20 = X_TL_EXT_ATTR20,
1045 TL_EXT_ATTR21 = X_TL_EXT_ATTR21,
1046 TL_EXT_ATTR22 = X_TL_EXT_ATTR22,
1047 TL_EXT_ATTR23 = X_TL_EXT_ATTR23,
1048 TL_EXT_ATTR24 = X_TL_EXT_ATTR24,
1049 TL_EXT_ATTR25 = X_TL_EXT_ATTR25,
1050 TL_EXT_ATTR26 = X_TL_EXT_ATTR26,
1051 TL_EXT_ATTR27 = X_TL_EXT_ATTR27,
1052 TL_EXT_ATTR28 = X_TL_EXT_ATTR28,
1053 TL_EXT_ATTR29 = X_TL_EXT_ATTR29,
1054 TL_EXT_ATTR30 = X_TL_EXT_ATTR30,
1055 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1056 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1057 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1058 SOURCE_LANG = userenv('LANG')
1059 where EXTENSION_ID = X_EXTENSION_ID
1060 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1061
1062 if (sql%notfound) then
1063 raise no_data_found;
1064 end if;
1065 end UPDATE_ROW;
1066
1067 procedure DELETE_ROW (
1071 delete from MTH_ITEMS_EXT_TL
1068 X_EXTENSION_ID in NUMBER
1069 ) is
1070 begin
1072 where EXTENSION_ID = X_EXTENSION_ID;
1073
1074 if (sql%notfound) then
1075 raise no_data_found;
1076 end if;
1077
1078 delete from MTH_ITEMS_EXT_B
1079 where EXTENSION_ID = X_EXTENSION_ID;
1080
1081 if (sql%notfound) then
1082 raise no_data_found;
1083 end if;
1084 end DELETE_ROW;
1085 =========We do not need the procedures commented above for this release ============
1086 */
1087
1088 procedure ADD_LANGUAGE
1089 is
1090 begin
1091 delete from MTH_ITEMS_EXT_TL T
1092 where not exists
1093 (select NULL
1094 from MTH_ITEMS_EXT_B B
1095 where B.EXTENSION_ID = T.EXTENSION_ID
1096 );
1097
1098 update MTH_ITEMS_EXT_TL T set (
1099 TL_EXT_ATTR1,
1100 TL_EXT_ATTR2,
1101 TL_EXT_ATTR3,
1102 TL_EXT_ATTR4,
1103 TL_EXT_ATTR5,
1104 TL_EXT_ATTR6,
1105 TL_EXT_ATTR7,
1106 TL_EXT_ATTR8,
1107 TL_EXT_ATTR9,
1108 TL_EXT_ATTR10,
1109 TL_EXT_ATTR11,
1110 TL_EXT_ATTR12,
1111 TL_EXT_ATTR13,
1112 TL_EXT_ATTR14,
1113 TL_EXT_ATTR15,
1114 TL_EXT_ATTR16,
1115 TL_EXT_ATTR17,
1116 TL_EXT_ATTR18,
1117 TL_EXT_ATTR19,
1118 TL_EXT_ATTR20,
1119 TL_EXT_ATTR21,
1120 TL_EXT_ATTR22,
1121 TL_EXT_ATTR23,
1122 TL_EXT_ATTR24,
1123 TL_EXT_ATTR25,
1124 TL_EXT_ATTR26,
1125 TL_EXT_ATTR27,
1126 TL_EXT_ATTR28,
1127 TL_EXT_ATTR29,
1128 TL_EXT_ATTR30
1129 ) = (select
1130 B.TL_EXT_ATTR1,
1131 B.TL_EXT_ATTR2,
1132 B.TL_EXT_ATTR3,
1133 B.TL_EXT_ATTR4,
1134 B.TL_EXT_ATTR5,
1135 B.TL_EXT_ATTR6,
1136 B.TL_EXT_ATTR7,
1137 B.TL_EXT_ATTR8,
1138 B.TL_EXT_ATTR9,
1139 B.TL_EXT_ATTR10,
1140 B.TL_EXT_ATTR11,
1141 B.TL_EXT_ATTR12,
1142 B.TL_EXT_ATTR13,
1143 B.TL_EXT_ATTR14,
1144 B.TL_EXT_ATTR15,
1145 B.TL_EXT_ATTR16,
1146 B.TL_EXT_ATTR17,
1147 B.TL_EXT_ATTR18,
1148 B.TL_EXT_ATTR19,
1149 B.TL_EXT_ATTR20,
1150 B.TL_EXT_ATTR21,
1151 B.TL_EXT_ATTR22,
1152 B.TL_EXT_ATTR23,
1153 B.TL_EXT_ATTR24,
1154 B.TL_EXT_ATTR25,
1155 B.TL_EXT_ATTR26,
1156 B.TL_EXT_ATTR27,
1157 B.TL_EXT_ATTR28,
1158 B.TL_EXT_ATTR29,
1159 B.TL_EXT_ATTR30
1160 from MTH_ITEMS_EXT_TL B
1161 where B.EXTENSION_ID = T.EXTENSION_ID
1162 and B.LANGUAGE = T.SOURCE_LANG)
1163 where (
1164 T.EXTENSION_ID,
1165 T.LANGUAGE
1166 ) in (select
1167 SUBT.EXTENSION_ID,
1168 SUBT.LANGUAGE
1169 from MTH_ITEMS_EXT_TL SUBB, MTH_ITEMS_EXT_TL SUBT
1170 where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1171 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1172 and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1173 or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)
1174 or (SUBB.TL_EXT_ATTR1 is not null and SUBT.TL_EXT_ATTR1 is null)
1175 or SUBB.TL_EXT_ATTR2 <> SUBT.TL_EXT_ATTR2
1176 or (SUBB.TL_EXT_ATTR2 is null and SUBT.TL_EXT_ATTR2 is not null)
1177 or (SUBB.TL_EXT_ATTR2 is not null and SUBT.TL_EXT_ATTR2 is null)
1178 or SUBB.TL_EXT_ATTR3 <> SUBT.TL_EXT_ATTR3
1179 or (SUBB.TL_EXT_ATTR3 is null and SUBT.TL_EXT_ATTR3 is not null)
1180 or (SUBB.TL_EXT_ATTR3 is not null and SUBT.TL_EXT_ATTR3 is null)
1181 or SUBB.TL_EXT_ATTR4 <> SUBT.TL_EXT_ATTR4
1182 or (SUBB.TL_EXT_ATTR4 is null and SUBT.TL_EXT_ATTR4 is not null)
1183 or (SUBB.TL_EXT_ATTR4 is not null and SUBT.TL_EXT_ATTR4 is null)
1184 or SUBB.TL_EXT_ATTR5 <> SUBT.TL_EXT_ATTR5
1185 or (SUBB.TL_EXT_ATTR5 is null and SUBT.TL_EXT_ATTR5 is not null)
1186 or (SUBB.TL_EXT_ATTR5 is not null and SUBT.TL_EXT_ATTR5 is null)
1187 or SUBB.TL_EXT_ATTR6 <> SUBT.TL_EXT_ATTR6
1188 or (SUBB.TL_EXT_ATTR6 is null and SUBT.TL_EXT_ATTR6 is not null)
1189 or (SUBB.TL_EXT_ATTR6 is not null and SUBT.TL_EXT_ATTR6 is null)
1190 or SUBB.TL_EXT_ATTR7 <> SUBT.TL_EXT_ATTR7
1191 or (SUBB.TL_EXT_ATTR7 is null and SUBT.TL_EXT_ATTR7 is not null)
1192 or (SUBB.TL_EXT_ATTR7 is not null and SUBT.TL_EXT_ATTR7 is null)
1193 or SUBB.TL_EXT_ATTR8 <> SUBT.TL_EXT_ATTR8
1194 or (SUBB.TL_EXT_ATTR8 is null and SUBT.TL_EXT_ATTR8 is not null)
1195 or (SUBB.TL_EXT_ATTR8 is not null and SUBT.TL_EXT_ATTR8 is null)
1196 or SUBB.TL_EXT_ATTR9 <> SUBT.TL_EXT_ATTR9
1197 or (SUBB.TL_EXT_ATTR9 is null and SUBT.TL_EXT_ATTR9 is not null)
1198 or (SUBB.TL_EXT_ATTR9 is not null and SUBT.TL_EXT_ATTR9 is null)
1199 or SUBB.TL_EXT_ATTR10 <> SUBT.TL_EXT_ATTR10
1200 or (SUBB.TL_EXT_ATTR10 is null and SUBT.TL_EXT_ATTR10 is not null)
1201 or (SUBB.TL_EXT_ATTR10 is not null and SUBT.TL_EXT_ATTR10 is null)
1202 or SUBB.TL_EXT_ATTR11 <> SUBT.TL_EXT_ATTR11
1203 or (SUBB.TL_EXT_ATTR11 is null and SUBT.TL_EXT_ATTR11 is not null)
1204 or (SUBB.TL_EXT_ATTR11 is not null and SUBT.TL_EXT_ATTR11 is null)
1205 or SUBB.TL_EXT_ATTR12 <> SUBT.TL_EXT_ATTR12
1206 or (SUBB.TL_EXT_ATTR12 is null and SUBT.TL_EXT_ATTR12 is not null)
1207 or (SUBB.TL_EXT_ATTR12 is not null and SUBT.TL_EXT_ATTR12 is null)
1208 or SUBB.TL_EXT_ATTR13 <> SUBT.TL_EXT_ATTR13
1209 or (SUBB.TL_EXT_ATTR13 is null and SUBT.TL_EXT_ATTR13 is not null)
1210 or (SUBB.TL_EXT_ATTR13 is not null and SUBT.TL_EXT_ATTR13 is null)
1211 or SUBB.TL_EXT_ATTR14 <> SUBT.TL_EXT_ATTR14
1212 or (SUBB.TL_EXT_ATTR14 is null and SUBT.TL_EXT_ATTR14 is not null)
1213 or (SUBB.TL_EXT_ATTR14 is not null and SUBT.TL_EXT_ATTR14 is null)
1214 or SUBB.TL_EXT_ATTR15 <> SUBT.TL_EXT_ATTR15
1215 or (SUBB.TL_EXT_ATTR15 is null and SUBT.TL_EXT_ATTR15 is not null)
1216 or (SUBB.TL_EXT_ATTR15 is not null and SUBT.TL_EXT_ATTR15 is null)
1217 or SUBB.TL_EXT_ATTR16 <> SUBT.TL_EXT_ATTR16
1218 or (SUBB.TL_EXT_ATTR16 is null and SUBT.TL_EXT_ATTR16 is not null)
1219 or (SUBB.TL_EXT_ATTR16 is not null and SUBT.TL_EXT_ATTR16 is null)
1220 or SUBB.TL_EXT_ATTR17 <> SUBT.TL_EXT_ATTR17
1221 or (SUBB.TL_EXT_ATTR17 is null and SUBT.TL_EXT_ATTR17 is not null)
1222 or (SUBB.TL_EXT_ATTR17 is not null and SUBT.TL_EXT_ATTR17 is null)
1223 or SUBB.TL_EXT_ATTR18 <> SUBT.TL_EXT_ATTR18
1224 or (SUBB.TL_EXT_ATTR18 is null and SUBT.TL_EXT_ATTR18 is not null)
1225 or (SUBB.TL_EXT_ATTR18 is not null and SUBT.TL_EXT_ATTR18 is null)
1226 or SUBB.TL_EXT_ATTR19 <> SUBT.TL_EXT_ATTR19
1227 or (SUBB.TL_EXT_ATTR19 is null and SUBT.TL_EXT_ATTR19 is not null)
1228 or (SUBB.TL_EXT_ATTR19 is not null and SUBT.TL_EXT_ATTR19 is null)
1229 or SUBB.TL_EXT_ATTR20 <> SUBT.TL_EXT_ATTR20
1230 or (SUBB.TL_EXT_ATTR20 is null and SUBT.TL_EXT_ATTR20 is not null)
1231 or (SUBB.TL_EXT_ATTR20 is not null and SUBT.TL_EXT_ATTR20 is null)
1232 or SUBB.TL_EXT_ATTR21 <> SUBT.TL_EXT_ATTR21
1233 or (SUBB.TL_EXT_ATTR21 is null and SUBT.TL_EXT_ATTR21 is not null)
1234 or (SUBB.TL_EXT_ATTR21 is not null and SUBT.TL_EXT_ATTR21 is null)
1235 or SUBB.TL_EXT_ATTR22 <> SUBT.TL_EXT_ATTR22
1236 or (SUBB.TL_EXT_ATTR22 is null and SUBT.TL_EXT_ATTR22 is not null)
1237 or (SUBB.TL_EXT_ATTR22 is not null and SUBT.TL_EXT_ATTR22 is null)
1238 or SUBB.TL_EXT_ATTR23 <> SUBT.TL_EXT_ATTR23
1239 or (SUBB.TL_EXT_ATTR23 is null and SUBT.TL_EXT_ATTR23 is not null)
1240 or (SUBB.TL_EXT_ATTR23 is not null and SUBT.TL_EXT_ATTR23 is null)
1241 or SUBB.TL_EXT_ATTR24 <> SUBT.TL_EXT_ATTR24
1242 or (SUBB.TL_EXT_ATTR24 is null and SUBT.TL_EXT_ATTR24 is not null)
1243 or (SUBB.TL_EXT_ATTR24 is not null and SUBT.TL_EXT_ATTR24 is null)
1244 or SUBB.TL_EXT_ATTR25 <> SUBT.TL_EXT_ATTR25
1245 or (SUBB.TL_EXT_ATTR25 is null and SUBT.TL_EXT_ATTR25 is not null)
1246 or (SUBB.TL_EXT_ATTR25 is not null and SUBT.TL_EXT_ATTR25 is null)
1247 or SUBB.TL_EXT_ATTR26 <> SUBT.TL_EXT_ATTR26
1248 or (SUBB.TL_EXT_ATTR26 is null and SUBT.TL_EXT_ATTR26 is not null)
1249 or (SUBB.TL_EXT_ATTR26 is not null and SUBT.TL_EXT_ATTR26 is null)
1250 or SUBB.TL_EXT_ATTR27 <> SUBT.TL_EXT_ATTR27
1251 or (SUBB.TL_EXT_ATTR27 is null and SUBT.TL_EXT_ATTR27 is not null)
1252 or (SUBB.TL_EXT_ATTR27 is not null and SUBT.TL_EXT_ATTR27 is null)
1253 or SUBB.TL_EXT_ATTR28 <> SUBT.TL_EXT_ATTR28
1254 or (SUBB.TL_EXT_ATTR28 is null and SUBT.TL_EXT_ATTR28 is not null)
1255 or (SUBB.TL_EXT_ATTR28 is not null and SUBT.TL_EXT_ATTR28 is null)
1256 or SUBB.TL_EXT_ATTR29 <> SUBT.TL_EXT_ATTR29
1257 or (SUBB.TL_EXT_ATTR29 is null and SUBT.TL_EXT_ATTR29 is not null)
1258 or (SUBB.TL_EXT_ATTR29 is not null and SUBT.TL_EXT_ATTR29 is null)
1259 or SUBB.TL_EXT_ATTR30 <> SUBT.TL_EXT_ATTR30
1260 or (SUBB.TL_EXT_ATTR30 is null and SUBT.TL_EXT_ATTR30 is not null)
1261 or (SUBB.TL_EXT_ATTR30 is not null and SUBT.TL_EXT_ATTR30 is null)
1262 ));
1263
1264 insert into MTH_ITEMS_EXT_TL (
1265 EXTENSION_ID,
1266 ATTR_GROUP_ID,
1267 ITEM_PK_KEY,
1268 TL_EXT_ATTR1,
1269 TL_EXT_ATTR2,
1270 TL_EXT_ATTR3,
1271 TL_EXT_ATTR4,
1272 TL_EXT_ATTR5,
1273 TL_EXT_ATTR6,
1274 TL_EXT_ATTR7,
1275 TL_EXT_ATTR8,
1276 TL_EXT_ATTR9,
1277 TL_EXT_ATTR10,
1278 TL_EXT_ATTR11,
1279 TL_EXT_ATTR12,
1280 TL_EXT_ATTR13,
1281 TL_EXT_ATTR14,
1282 TL_EXT_ATTR15,
1283 TL_EXT_ATTR16,
1284 TL_EXT_ATTR17,
1285 TL_EXT_ATTR18,
1286 TL_EXT_ATTR19,
1287 TL_EXT_ATTR20,
1288 TL_EXT_ATTR21,
1289 TL_EXT_ATTR22,
1290 TL_EXT_ATTR23,
1291 TL_EXT_ATTR24,
1292 TL_EXT_ATTR25,
1293 TL_EXT_ATTR26,
1294 TL_EXT_ATTR27,
1295 TL_EXT_ATTR28,
1296 TL_EXT_ATTR29,
1297 TL_EXT_ATTR30,
1298 LAST_UPDATE_DATE,
1299 LAST_UPDATED_BY,
1300 LAST_UPDATE_LOGIN,
1301 CREATED_BY,
1302 CREATION_DATE,
1303 LANGUAGE,
1304 SOURCE_LANG
1305 ) select /*+ ORDERED */
1306 B.EXTENSION_ID,
1307 B.ATTR_GROUP_ID,
1308 B.ITEM_PK_KEY,
1309 B.TL_EXT_ATTR1,
1310 B.TL_EXT_ATTR2,
1311 B.TL_EXT_ATTR3,
1312 B.TL_EXT_ATTR4,
1313 B.TL_EXT_ATTR5,
1314 B.TL_EXT_ATTR6,
1315 B.TL_EXT_ATTR7,
1316 B.TL_EXT_ATTR8,
1317 B.TL_EXT_ATTR9,
1318 B.TL_EXT_ATTR10,
1319 B.TL_EXT_ATTR11,
1320 B.TL_EXT_ATTR12,
1321 B.TL_EXT_ATTR13,
1322 B.TL_EXT_ATTR14,
1323 B.TL_EXT_ATTR15,
1324 B.TL_EXT_ATTR16,
1325 B.TL_EXT_ATTR17,
1326 B.TL_EXT_ATTR18,
1327 B.TL_EXT_ATTR19,
1328 B.TL_EXT_ATTR20,
1329 B.TL_EXT_ATTR21,
1330 B.TL_EXT_ATTR22,
1331 B.TL_EXT_ATTR23,
1332 B.TL_EXT_ATTR24,
1333 B.TL_EXT_ATTR25,
1334 B.TL_EXT_ATTR26,
1335 B.TL_EXT_ATTR27,
1336 B.TL_EXT_ATTR28,
1337 B.TL_EXT_ATTR29,
1338 B.TL_EXT_ATTR30,
1339 B.LAST_UPDATE_DATE,
1340 B.LAST_UPDATED_BY,
1341 B.LAST_UPDATE_LOGIN,
1342 B.CREATED_BY,
1343 B.CREATION_DATE,
1344 L.LANGUAGE_CODE,
1345 B.SOURCE_LANG
1346 from MTH_ITEMS_EXT_TL B, FND_LANGUAGES L
1347 where L.INSTALLED_FLAG in ('I', 'B')
1348 and B.LANGUAGE = userenv('LANG')
1349 and not exists
1350 (select NULL
1351 from MTH_ITEMS_EXT_TL T
1352 where T.EXTENSION_ID = B.EXTENSION_ID
1353 and T.LANGUAGE = L.LANGUAGE_CODE);
1354 end ADD_LANGUAGE;
1355
1356 end MTH_ITEMS_EXT_PKG;
[Home] [Help]