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