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