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