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