1 PACKAGE BODY BOM_COMPONENTS_EXT_PKG AS
2 /* $Header: BOMPCUAB.pls 115.0 2004/02/03 13:34:45 hgelli noship $ */
3
4 ----------------------------------------------------------------------
5
6 PROCEDURE INSERT_ROW (
7 X_ROWID IN OUT NOCOPY VARCHAR2,
8 X_EXTENSION_ID IN NUMBER,
9 X_N_EXT_ATTR14 IN NUMBER,
10 X_N_EXT_ATTR15 IN NUMBER,
11 X_N_EXT_ATTR16 IN NUMBER,
12 X_N_EXT_ATTR17 IN NUMBER,
13 X_N_EXT_ATTR18 IN NUMBER,
14 X_N_EXT_ATTR19 IN NUMBER,
15 X_N_EXT_ATTR20 IN NUMBER,
16 X_D_EXT_ATTR1 IN DATE,
17 X_D_EXT_ATTR2 IN DATE,
18 X_D_EXT_ATTR3 IN DATE,
19 X_D_EXT_ATTR4 IN DATE,
20 X_D_EXT_ATTR5 IN DATE,
21 X_D_EXT_ATTR6 IN DATE,
22 X_D_EXT_ATTR7 IN DATE,
23 X_D_EXT_ATTR8 IN DATE,
24 X_D_EXT_ATTR9 IN DATE,
25 X_D_EXT_ATTR10 IN DATE,
26 X_UOM_EXT_ATTR1 IN VARCHAR2,
27 X_UOM_EXT_ATTR2 IN VARCHAR2,
28 X_UOM_EXT_ATTR3 IN VARCHAR2,
29 X_UOM_EXT_ATTR4 IN VARCHAR2,
30 X_UOM_EXT_ATTR5 IN VARCHAR2,
31 X_UOM_EXT_ATTR6 IN VARCHAR2,
32 X_UOM_EXT_ATTR7 IN VARCHAR2,
33 X_UOM_EXT_ATTR8 IN VARCHAR2,
34 X_UOM_EXT_ATTR9 IN VARCHAR2,
35 X_UOM_EXT_ATTR10 IN VARCHAR2,
36 X_UOM_EXT_ATTR11 IN VARCHAR2,
37 X_UOM_EXT_ATTR12 IN VARCHAR2,
38 X_UOM_EXT_ATTR13 IN VARCHAR2,
39 X_UOM_EXT_ATTR14 IN VARCHAR2,
40 X_UOM_EXT_ATTR15 IN VARCHAR2,
41 X_UOM_EXT_ATTR16 IN VARCHAR2,
42 X_UOM_EXT_ATTR17 IN VARCHAR2,
43 X_UOM_EXT_ATTR18 IN VARCHAR2,
44 X_UOM_EXT_ATTR19 IN VARCHAR2,
45 X_UOM_EXT_ATTR20 IN VARCHAR2,
46 X_BILL_SEQUENCE_ID IN NUMBER,
47 X_COMPONENT_SEQUENCE_ID IN NUMBER,
48 X_STRUCTURE_TYPE_ID IN NUMBER,
49 X_ATTR_GROUP_ID IN NUMBER,
50 X_C_EXT_ATTR1 IN VARCHAR2,
51 X_C_EXT_ATTR2 IN VARCHAR2,
52 X_C_EXT_ATTR3 IN VARCHAR2,
53 X_C_EXT_ATTR4 IN VARCHAR2,
54 X_C_EXT_ATTR5 IN VARCHAR2,
55 X_C_EXT_ATTR6 IN VARCHAR2,
56 X_C_EXT_ATTR7 IN VARCHAR2,
57 X_C_EXT_ATTR8 IN VARCHAR2,
58 X_C_EXT_ATTR9 IN VARCHAR2,
59 X_C_EXT_ATTR10 IN VARCHAR2,
60 X_C_EXT_ATTR11 IN VARCHAR2,
61 X_C_EXT_ATTR12 IN VARCHAR2,
62 X_C_EXT_ATTR13 IN VARCHAR2,
63 X_C_EXT_ATTR14 IN VARCHAR2,
64 X_C_EXT_ATTR15 IN VARCHAR2,
65 X_C_EXT_ATTR16 IN VARCHAR2,
66 X_C_EXT_ATTR17 IN VARCHAR2,
67 X_C_EXT_ATTR18 IN VARCHAR2,
68 X_C_EXT_ATTR19 IN VARCHAR2,
69 X_C_EXT_ATTR20 IN VARCHAR2,
70 X_C_EXT_ATTR21 IN VARCHAR2,
71 X_C_EXT_ATTR22 IN VARCHAR2,
72 X_C_EXT_ATTR23 IN VARCHAR2,
73 X_C_EXT_ATTR24 IN VARCHAR2,
74 X_C_EXT_ATTR25 IN VARCHAR2,
75 X_C_EXT_ATTR26 IN VARCHAR2,
76 X_C_EXT_ATTR27 IN VARCHAR2,
77 X_C_EXT_ATTR28 IN VARCHAR2,
78 X_C_EXT_ATTR29 IN VARCHAR2,
79 X_C_EXT_ATTR30 IN VARCHAR2,
80 X_C_EXT_ATTR31 IN VARCHAR2,
81 X_C_EXT_ATTR32 IN VARCHAR2,
82 X_C_EXT_ATTR33 IN VARCHAR2,
83 X_C_EXT_ATTR34 IN VARCHAR2,
84 X_C_EXT_ATTR35 IN VARCHAR2,
85 X_C_EXT_ATTR36 IN VARCHAR2,
86 X_C_EXT_ATTR37 IN VARCHAR2,
87 X_C_EXT_ATTR38 IN VARCHAR2,
88 X_C_EXT_ATTR39 IN VARCHAR2,
89 X_C_EXT_ATTR40 IN VARCHAR2,
90 X_N_EXT_ATTR1 IN NUMBER,
91 X_N_EXT_ATTR2 IN NUMBER,
92 X_N_EXT_ATTR3 IN NUMBER,
93 X_N_EXT_ATTR4 IN NUMBER,
94 X_N_EXT_ATTR5 IN NUMBER,
95 X_N_EXT_ATTR6 IN NUMBER,
96 X_N_EXT_ATTR7 IN NUMBER,
97 X_N_EXT_ATTR8 IN NUMBER,
98 X_N_EXT_ATTR9 IN NUMBER,
99 X_N_EXT_ATTR10 IN NUMBER,
100 X_N_EXT_ATTR11 IN NUMBER,
101 X_N_EXT_ATTR12 IN NUMBER,
102 X_N_EXT_ATTR13 IN NUMBER,
103 X_TL_EXT_ATTR1 IN VARCHAR2,
104 X_TL_EXT_ATTR2 IN VARCHAR2,
105 X_TL_EXT_ATTR3 IN VARCHAR2,
106 X_TL_EXT_ATTR4 IN VARCHAR2,
107 X_TL_EXT_ATTR5 IN VARCHAR2,
108 X_TL_EXT_ATTR6 IN VARCHAR2,
109 X_TL_EXT_ATTR7 IN VARCHAR2,
110 X_TL_EXT_ATTR8 IN VARCHAR2,
111 X_TL_EXT_ATTR9 IN VARCHAR2,
112 X_TL_EXT_ATTR10 IN VARCHAR2,
113 X_TL_EXT_ATTR11 IN VARCHAR2,
114 X_TL_EXT_ATTR12 IN VARCHAR2,
115 X_TL_EXT_ATTR13 IN VARCHAR2,
116 X_TL_EXT_ATTR14 IN VARCHAR2,
117 X_TL_EXT_ATTR15 IN VARCHAR2,
118 X_TL_EXT_ATTR16 IN VARCHAR2,
119 X_TL_EXT_ATTR17 IN VARCHAR2,
120 X_TL_EXT_ATTR18 IN VARCHAR2,
121 X_TL_EXT_ATTR19 IN VARCHAR2,
122 X_TL_EXT_ATTR20 IN VARCHAR2,
123 X_TL_EXT_ATTR21 IN VARCHAR2,
124 X_TL_EXT_ATTR22 IN VARCHAR2,
125 X_TL_EXT_ATTR23 IN VARCHAR2,
126 X_TL_EXT_ATTR24 IN VARCHAR2,
127 X_TL_EXT_ATTR25 IN VARCHAR2,
128 X_TL_EXT_ATTR26 IN VARCHAR2,
129 X_TL_EXT_ATTR27 IN VARCHAR2,
130 X_TL_EXT_ATTR28 IN VARCHAR2,
131 X_TL_EXT_ATTR29 IN VARCHAR2,
132 X_TL_EXT_ATTR30 IN VARCHAR2,
133 X_TL_EXT_ATTR31 IN VARCHAR2,
134 X_TL_EXT_ATTR32 IN VARCHAR2,
135 X_TL_EXT_ATTR33 IN VARCHAR2,
136 X_TL_EXT_ATTR34 IN VARCHAR2,
137 X_TL_EXT_ATTR35 IN VARCHAR2,
138 X_TL_EXT_ATTR36 IN VARCHAR2,
139 X_TL_EXT_ATTR37 IN VARCHAR2,
140 X_TL_EXT_ATTR38 IN VARCHAR2,
141 X_TL_EXT_ATTR39 IN VARCHAR2,
142 X_TL_EXT_ATTR40 IN VARCHAR2,
143 X_CREATION_DATE IN DATE,
144 X_CREATED_BY IN NUMBER,
145 X_LAST_UPDATE_DATE IN DATE,
146 X_LAST_UPDATED_BY IN NUMBER,
147 X_LAST_UPDATE_LOGIN IN NUMBER
148 ) IS
149 CURSOR C IS SELECT ROWID FROM BOM_COMPONENTS_EXT_B
150 WHERE EXTENSION_ID = X_EXTENSION_ID
151 ;
152 BEGIN
153 INSERT INTO BOM_COMPONENTS_EXT_B (
154 N_EXT_ATTR14,
155 N_EXT_ATTR15,
156 N_EXT_ATTR16,
157 N_EXT_ATTR17,
158 N_EXT_ATTR18,
159 N_EXT_ATTR19,
160 N_EXT_ATTR20,
161 D_EXT_ATTR1,
162 D_EXT_ATTR2,
163 D_EXT_ATTR3,
164 D_EXT_ATTR4,
165 D_EXT_ATTR5,
166 D_EXT_ATTR6,
167 D_EXT_ATTR7,
168 D_EXT_ATTR8,
169 D_EXT_ATTR9,
170 D_EXT_ATTR10,
171 UOM_EXT_ATTR1,
172 UOM_EXT_ATTR2,
173 UOM_EXT_ATTR3,
174 UOM_EXT_ATTR4,
175 UOM_EXT_ATTR5,
176 UOM_EXT_ATTR6,
177 UOM_EXT_ATTR7,
178 UOM_EXT_ATTR8,
179 UOM_EXT_ATTR9,
180 UOM_EXT_ATTR10,
181 UOM_EXT_ATTR11,
182 UOM_EXT_ATTR12,
183 UOM_EXT_ATTR13,
184 UOM_EXT_ATTR14,
185 UOM_EXT_ATTR15,
186 UOM_EXT_ATTR16,
187 UOM_EXT_ATTR17,
188 UOM_EXT_ATTR18,
189 UOM_EXT_ATTR19,
190 UOM_EXT_ATTR20,
191 BILL_SEQUENCE_ID,
192 EXTENSION_ID,
193 COMPONENT_SEQUENCE_ID,
194 STRUCTURE_TYPE_ID,
195 ATTR_GROUP_ID,
196 C_EXT_ATTR1,
197 C_EXT_ATTR2,
198 C_EXT_ATTR3,
199 C_EXT_ATTR4,
200 C_EXT_ATTR5,
201 C_EXT_ATTR6,
202 C_EXT_ATTR7,
203 C_EXT_ATTR8,
204 C_EXT_ATTR9,
205 C_EXT_ATTR10,
206 C_EXT_ATTR11,
207 C_EXT_ATTR12,
208 C_EXT_ATTR13,
209 C_EXT_ATTR14,
210 C_EXT_ATTR15,
211 C_EXT_ATTR16,
212 C_EXT_ATTR17,
213 C_EXT_ATTR18,
214 C_EXT_ATTR19,
215 C_EXT_ATTR20,
216 C_EXT_ATTR21,
217 C_EXT_ATTR22,
218 C_EXT_ATTR23,
219 C_EXT_ATTR24,
220 C_EXT_ATTR25,
221 C_EXT_ATTR26,
222 C_EXT_ATTR27,
223 C_EXT_ATTR28,
224 C_EXT_ATTR29,
225 C_EXT_ATTR30,
226 C_EXT_ATTR31,
227 C_EXT_ATTR32,
228 C_EXT_ATTR33,
229 C_EXT_ATTR34,
230 C_EXT_ATTR35,
231 C_EXT_ATTR36,
232 C_EXT_ATTR37,
233 C_EXT_ATTR38,
234 C_EXT_ATTR39,
235 C_EXT_ATTR40,
236 N_EXT_ATTR1,
237 N_EXT_ATTR2,
238 N_EXT_ATTR3,
239 N_EXT_ATTR4,
240 N_EXT_ATTR5,
241 N_EXT_ATTR6,
242 N_EXT_ATTR7,
243 N_EXT_ATTR8,
244 N_EXT_ATTR9,
245 N_EXT_ATTR10,
246 N_EXT_ATTR11,
247 N_EXT_ATTR12,
248 N_EXT_ATTR13,
249 CREATION_DATE,
250 CREATED_BY,
251 LAST_UPDATE_DATE,
252 LAST_UPDATED_BY,
253 LAST_UPDATE_LOGIN
254 ) VALUES (
255 X_N_EXT_ATTR14,
256 X_N_EXT_ATTR15,
257 X_N_EXT_ATTR16,
258 X_N_EXT_ATTR17,
259 X_N_EXT_ATTR18,
260 X_N_EXT_ATTR19,
261 X_N_EXT_ATTR20,
262 X_D_EXT_ATTR1,
263 X_D_EXT_ATTR2,
264 X_D_EXT_ATTR3,
265 X_D_EXT_ATTR4,
266 X_D_EXT_ATTR5,
267 X_D_EXT_ATTR6,
268 X_D_EXT_ATTR7,
269 X_D_EXT_ATTR8,
270 X_D_EXT_ATTR9,
271 X_D_EXT_ATTR10,
272 X_UOM_EXT_ATTR1,
273 X_UOM_EXT_ATTR2,
274 X_UOM_EXT_ATTR3,
275 X_UOM_EXT_ATTR4,
276 X_UOM_EXT_ATTR5,
277 X_UOM_EXT_ATTR6,
278 X_UOM_EXT_ATTR7,
279 X_UOM_EXT_ATTR8,
280 X_UOM_EXT_ATTR9,
281 X_UOM_EXT_ATTR10,
282 X_UOM_EXT_ATTR11,
283 X_UOM_EXT_ATTR12,
284 X_UOM_EXT_ATTR13,
285 X_UOM_EXT_ATTR14,
286 X_UOM_EXT_ATTR15,
287 X_UOM_EXT_ATTR16,
288 X_UOM_EXT_ATTR17,
289 X_UOM_EXT_ATTR18,
290 X_UOM_EXT_ATTR19,
291 X_UOM_EXT_ATTR20,
292 X_BILL_SEQUENCE_ID,
293 X_EXTENSION_ID,
294 X_COMPONENT_SEQUENCE_ID,
295 X_STRUCTURE_TYPE_ID,
296 X_ATTR_GROUP_ID,
297 X_C_EXT_ATTR1,
298 X_C_EXT_ATTR2,
299 X_C_EXT_ATTR3,
300 X_C_EXT_ATTR4,
301 X_C_EXT_ATTR5,
302 X_C_EXT_ATTR6,
303 X_C_EXT_ATTR7,
304 X_C_EXT_ATTR8,
305 X_C_EXT_ATTR9,
306 X_C_EXT_ATTR10,
307 X_C_EXT_ATTR11,
308 X_C_EXT_ATTR12,
309 X_C_EXT_ATTR13,
310 X_C_EXT_ATTR14,
311 X_C_EXT_ATTR15,
312 X_C_EXT_ATTR16,
313 X_C_EXT_ATTR17,
314 X_C_EXT_ATTR18,
315 X_C_EXT_ATTR19,
316 X_C_EXT_ATTR20,
317 X_C_EXT_ATTR21,
318 X_C_EXT_ATTR22,
319 X_C_EXT_ATTR23,
320 X_C_EXT_ATTR24,
321 X_C_EXT_ATTR25,
322 X_C_EXT_ATTR26,
323 X_C_EXT_ATTR27,
324 X_C_EXT_ATTR28,
325 X_C_EXT_ATTR29,
326 X_C_EXT_ATTR30,
327 X_C_EXT_ATTR31,
328 X_C_EXT_ATTR32,
329 X_C_EXT_ATTR33,
330 X_C_EXT_ATTR34,
331 X_C_EXT_ATTR35,
332 X_C_EXT_ATTR36,
333 X_C_EXT_ATTR37,
334 X_C_EXT_ATTR38,
335 X_C_EXT_ATTR39,
336 X_C_EXT_ATTR40,
337 X_N_EXT_ATTR1,
338 X_N_EXT_ATTR2,
339 X_N_EXT_ATTR3,
340 X_N_EXT_ATTR4,
341 X_N_EXT_ATTR5,
342 X_N_EXT_ATTR6,
343 X_N_EXT_ATTR7,
344 X_N_EXT_ATTR8,
345 X_N_EXT_ATTR9,
346 X_N_EXT_ATTR10,
347 X_N_EXT_ATTR11,
348 X_N_EXT_ATTR12,
349 X_N_EXT_ATTR13,
350 X_CREATION_DATE,
351 X_CREATED_BY,
352 X_LAST_UPDATE_DATE,
353 X_LAST_UPDATED_BY,
354 X_LAST_UPDATE_LOGIN
355 );
356
357 INSERT INTO BOM_COMPONENTS_EXT_TL (
358 EXTENSION_ID,
359 COMPONENT_SEQUENCE_ID,
360 STRUCTURE_TYPE_ID,
361 ATTR_GROUP_ID,
362 LAST_UPDATE_DATE,
363 LAST_UPDATED_BY,
364 LAST_UPDATE_LOGIN,
365 CREATED_BY,
366 CREATION_DATE,
367 TL_EXT_ATTR1,
368 TL_EXT_ATTR2,
369 TL_EXT_ATTR3,
370 TL_EXT_ATTR4,
371 TL_EXT_ATTR5,
372 TL_EXT_ATTR6,
373 TL_EXT_ATTR7,
374 TL_EXT_ATTR8,
375 TL_EXT_ATTR9,
376 TL_EXT_ATTR10,
377 TL_EXT_ATTR11,
378 TL_EXT_ATTR12,
379 TL_EXT_ATTR13,
380 TL_EXT_ATTR14,
381 TL_EXT_ATTR15,
382 TL_EXT_ATTR16,
383 TL_EXT_ATTR17,
384 TL_EXT_ATTR18,
385 TL_EXT_ATTR19,
386 TL_EXT_ATTR20,
387 TL_EXT_ATTR21,
388 TL_EXT_ATTR22,
389 TL_EXT_ATTR23,
390 TL_EXT_ATTR24,
391 TL_EXT_ATTR25,
392 TL_EXT_ATTR26,
393 TL_EXT_ATTR27,
394 TL_EXT_ATTR28,
395 TL_EXT_ATTR29,
396 TL_EXT_ATTR30,
397 TL_EXT_ATTR31,
398 TL_EXT_ATTR32,
399 TL_EXT_ATTR33,
400 TL_EXT_ATTR34,
401 TL_EXT_ATTR35,
402 TL_EXT_ATTR36,
403 TL_EXT_ATTR37,
404 TL_EXT_ATTR38,
405 TL_EXT_ATTR39,
406 TL_EXT_ATTR40,
407 BILL_SEQUENCE_ID,
408 LANGUAGE,
409 SOURCE_LANG
410 ) SELECT
411 X_EXTENSION_ID,
412 X_COMPONENT_SEQUENCE_ID,
413 X_STRUCTURE_TYPE_ID,
414 X_ATTR_GROUP_ID,
415 X_LAST_UPDATE_DATE,
416 X_LAST_UPDATED_BY,
417 X_LAST_UPDATE_LOGIN,
418 X_CREATED_BY,
419 X_CREATION_DATE,
420 X_TL_EXT_ATTR1,
421 X_TL_EXT_ATTR2,
422 X_TL_EXT_ATTR3,
423 X_TL_EXT_ATTR4,
424 X_TL_EXT_ATTR5,
425 X_TL_EXT_ATTR6,
426 X_TL_EXT_ATTR7,
427 X_TL_EXT_ATTR8,
428 X_TL_EXT_ATTR9,
429 X_TL_EXT_ATTR10,
430 X_TL_EXT_ATTR11,
431 X_TL_EXT_ATTR12,
432 X_TL_EXT_ATTR13,
433 X_TL_EXT_ATTR14,
434 X_TL_EXT_ATTR15,
435 X_TL_EXT_ATTR16,
436 X_TL_EXT_ATTR17,
437 X_TL_EXT_ATTR18,
438 X_TL_EXT_ATTR19,
439 X_TL_EXT_ATTR20,
440 X_TL_EXT_ATTR21,
441 X_TL_EXT_ATTR22,
442 X_TL_EXT_ATTR23,
443 X_TL_EXT_ATTR24,
444 X_TL_EXT_ATTR25,
445 X_TL_EXT_ATTR26,
446 X_TL_EXT_ATTR27,
447 X_TL_EXT_ATTR28,
448 X_TL_EXT_ATTR29,
449 X_TL_EXT_ATTR30,
450 X_TL_EXT_ATTR31,
451 X_TL_EXT_ATTR32,
452 X_TL_EXT_ATTR33,
453 X_TL_EXT_ATTR34,
454 X_TL_EXT_ATTR35,
455 X_TL_EXT_ATTR36,
456 X_TL_EXT_ATTR37,
457 X_TL_EXT_ATTR38,
458 X_TL_EXT_ATTR39,
462 USERENV('LANG')
459 X_TL_EXT_ATTR40,
460 X_BILL_SEQUENCE_ID,
461 L.LANGUAGE_CODE,
463 FROM FND_LANGUAGES L
464 WHERE L.INSTALLED_FLAG IN ('I', 'B')
465 AND NOT EXISTS
466 (SELECT NULL
467 FROM BOM_COMPONENTS_EXT_TL T
468 WHERE T.EXTENSION_ID = X_EXTENSION_ID
469 AND T.LANGUAGE = L.LANGUAGE_CODE);
470
471 OPEN c;
472 FETCH c INTO X_ROWID;
473 IF (c%NOTFOUND) THEN
474 CLOSE c;
475 RAISE NO_DATA_FOUND;
476 END IF;
477 CLOSE c;
478
479 END INSERT_ROW;
480
481 PROCEDURE LOCK_ROW (
482 X_EXTENSION_ID IN NUMBER,
483 X_N_EXT_ATTR14 IN NUMBER,
484 X_N_EXT_ATTR15 IN NUMBER,
485 X_N_EXT_ATTR16 IN NUMBER,
486 X_N_EXT_ATTR17 IN NUMBER,
487 X_N_EXT_ATTR18 IN NUMBER,
488 X_N_EXT_ATTR19 IN NUMBER,
489 X_N_EXT_ATTR20 IN NUMBER,
490 X_D_EXT_ATTR1 IN DATE,
491 X_D_EXT_ATTR2 IN DATE,
492 X_D_EXT_ATTR3 IN DATE,
493 X_D_EXT_ATTR4 IN DATE,
494 X_D_EXT_ATTR5 IN DATE,
495 X_D_EXT_ATTR6 IN DATE,
496 X_D_EXT_ATTR7 IN DATE,
497 X_D_EXT_ATTR8 IN DATE,
498 X_D_EXT_ATTR9 IN DATE,
499 X_D_EXT_ATTR10 IN DATE,
500 X_UOM_EXT_ATTR1 IN VARCHAR2,
501 X_UOM_EXT_ATTR2 IN VARCHAR2,
502 X_UOM_EXT_ATTR3 IN VARCHAR2,
503 X_UOM_EXT_ATTR4 IN VARCHAR2,
504 X_UOM_EXT_ATTR5 IN VARCHAR2,
505 X_UOM_EXT_ATTR6 IN VARCHAR2,
506 X_UOM_EXT_ATTR7 IN VARCHAR2,
507 X_UOM_EXT_ATTR8 IN VARCHAR2,
508 X_UOM_EXT_ATTR9 IN VARCHAR2,
509 X_UOM_EXT_ATTR10 IN VARCHAR2,
510 X_UOM_EXT_ATTR11 IN VARCHAR2,
511 X_UOM_EXT_ATTR12 IN VARCHAR2,
512 X_UOM_EXT_ATTR13 IN VARCHAR2,
513 X_UOM_EXT_ATTR14 IN VARCHAR2,
514 X_UOM_EXT_ATTR15 IN VARCHAR2,
515 X_UOM_EXT_ATTR16 IN VARCHAR2,
516 X_UOM_EXT_ATTR17 IN VARCHAR2,
517 X_UOM_EXT_ATTR18 IN VARCHAR2,
518 X_UOM_EXT_ATTR19 IN VARCHAR2,
519 X_UOM_EXT_ATTR20 IN VARCHAR2,
520 X_BILL_SEQUENCE_ID IN NUMBER,
521 X_COMPONENT_SEQUENCE_ID IN NUMBER,
522 X_STRUCTURE_TYPE_ID IN NUMBER,
523 X_ATTR_GROUP_ID IN NUMBER,
524 X_C_EXT_ATTR1 IN VARCHAR2,
525 X_C_EXT_ATTR2 IN VARCHAR2,
526 X_C_EXT_ATTR3 IN VARCHAR2,
527 X_C_EXT_ATTR4 IN VARCHAR2,
528 X_C_EXT_ATTR5 IN VARCHAR2,
529 X_C_EXT_ATTR6 IN VARCHAR2,
530 X_C_EXT_ATTR7 IN VARCHAR2,
531 X_C_EXT_ATTR8 IN VARCHAR2,
532 X_C_EXT_ATTR9 IN VARCHAR2,
533 X_C_EXT_ATTR10 IN VARCHAR2,
534 X_C_EXT_ATTR11 IN VARCHAR2,
535 X_C_EXT_ATTR12 IN VARCHAR2,
536 X_C_EXT_ATTR13 IN VARCHAR2,
537 X_C_EXT_ATTR14 IN VARCHAR2,
538 X_C_EXT_ATTR15 IN VARCHAR2,
539 X_C_EXT_ATTR16 IN VARCHAR2,
540 X_C_EXT_ATTR17 IN VARCHAR2,
541 X_C_EXT_ATTR18 IN VARCHAR2,
542 X_C_EXT_ATTR19 IN VARCHAR2,
543 X_C_EXT_ATTR20 IN VARCHAR2,
544 X_C_EXT_ATTR21 IN VARCHAR2,
545 X_C_EXT_ATTR22 IN VARCHAR2,
546 X_C_EXT_ATTR23 IN VARCHAR2,
547 X_C_EXT_ATTR24 IN VARCHAR2,
548 X_C_EXT_ATTR25 IN VARCHAR2,
549 X_C_EXT_ATTR26 IN VARCHAR2,
550 X_C_EXT_ATTR27 IN VARCHAR2,
551 X_C_EXT_ATTR28 IN VARCHAR2,
552 X_C_EXT_ATTR29 IN VARCHAR2,
553 X_C_EXT_ATTR30 IN VARCHAR2,
554 X_C_EXT_ATTR31 IN VARCHAR2,
555 X_C_EXT_ATTR32 IN VARCHAR2,
556 X_C_EXT_ATTR33 IN VARCHAR2,
557 X_C_EXT_ATTR34 IN VARCHAR2,
558 X_C_EXT_ATTR35 IN VARCHAR2,
559 X_C_EXT_ATTR36 IN VARCHAR2,
560 X_C_EXT_ATTR37 IN VARCHAR2,
561 X_C_EXT_ATTR38 IN VARCHAR2,
562 X_C_EXT_ATTR39 IN VARCHAR2,
563 X_C_EXT_ATTR40 IN VARCHAR2,
564 X_N_EXT_ATTR1 IN NUMBER,
565 X_N_EXT_ATTR2 IN NUMBER,
566 X_N_EXT_ATTR3 IN NUMBER,
567 X_N_EXT_ATTR4 IN NUMBER,
568 X_N_EXT_ATTR5 IN NUMBER,
569 X_N_EXT_ATTR6 IN NUMBER,
570 X_N_EXT_ATTR7 IN NUMBER,
571 X_N_EXT_ATTR8 IN NUMBER,
572 X_N_EXT_ATTR9 IN NUMBER,
573 X_N_EXT_ATTR10 IN NUMBER,
574 X_N_EXT_ATTR11 IN NUMBER,
575 X_N_EXT_ATTR12 IN NUMBER,
576 X_N_EXT_ATTR13 IN NUMBER,
577 X_TL_EXT_ATTR1 IN VARCHAR2,
578 X_TL_EXT_ATTR2 IN VARCHAR2,
579 X_TL_EXT_ATTR3 IN VARCHAR2,
580 X_TL_EXT_ATTR4 IN VARCHAR2,
581 X_TL_EXT_ATTR5 IN VARCHAR2,
582 X_TL_EXT_ATTR6 IN VARCHAR2,
583 X_TL_EXT_ATTR7 IN VARCHAR2,
584 X_TL_EXT_ATTR8 IN VARCHAR2,
585 X_TL_EXT_ATTR9 IN VARCHAR2,
586 X_TL_EXT_ATTR10 IN VARCHAR2,
587 X_TL_EXT_ATTR11 IN VARCHAR2,
588 X_TL_EXT_ATTR12 IN VARCHAR2,
589 X_TL_EXT_ATTR13 IN VARCHAR2,
590 X_TL_EXT_ATTR14 IN VARCHAR2,
591 X_TL_EXT_ATTR15 IN VARCHAR2,
592 X_TL_EXT_ATTR16 IN VARCHAR2,
593 X_TL_EXT_ATTR17 IN VARCHAR2,
594 X_TL_EXT_ATTR18 IN VARCHAR2,
595 X_TL_EXT_ATTR19 IN VARCHAR2,
596 X_TL_EXT_ATTR20 IN VARCHAR2,
597 X_TL_EXT_ATTR21 IN VARCHAR2,
598 X_TL_EXT_ATTR22 IN VARCHAR2,
599 X_TL_EXT_ATTR23 IN VARCHAR2,
600 X_TL_EXT_ATTR24 IN VARCHAR2,
601 X_TL_EXT_ATTR25 IN VARCHAR2,
602 X_TL_EXT_ATTR26 IN VARCHAR2,
603 X_TL_EXT_ATTR27 IN VARCHAR2,
604 X_TL_EXT_ATTR28 IN VARCHAR2,
605 X_TL_EXT_ATTR29 IN VARCHAR2,
606 X_TL_EXT_ATTR30 IN VARCHAR2,
607 X_TL_EXT_ATTR31 IN VARCHAR2,
608 X_TL_EXT_ATTR32 IN VARCHAR2,
609 X_TL_EXT_ATTR33 IN VARCHAR2,
610 X_TL_EXT_ATTR34 IN VARCHAR2,
611 X_TL_EXT_ATTR35 IN VARCHAR2,
612 X_TL_EXT_ATTR36 IN VARCHAR2,
613 X_TL_EXT_ATTR37 IN VARCHAR2,
614 X_TL_EXT_ATTR38 IN VARCHAR2,
615 X_TL_EXT_ATTR39 IN VARCHAR2,
616 X_TL_EXT_ATTR40 IN VARCHAR2
617 ) IS
618 CURSOR c IS SELECT
619 N_EXT_ATTR14,
620 N_EXT_ATTR15,
621 N_EXT_ATTR16,
622 N_EXT_ATTR17,
623 N_EXT_ATTR18,
624 N_EXT_ATTR19,
625 N_EXT_ATTR20,
626 D_EXT_ATTR1,
627 D_EXT_ATTR2,
628 D_EXT_ATTR3,
629 D_EXT_ATTR4,
633 D_EXT_ATTR8,
630 D_EXT_ATTR5,
631 D_EXT_ATTR6,
632 D_EXT_ATTR7,
634 D_EXT_ATTR9,
635 D_EXT_ATTR10,
636 UOM_EXT_ATTR1,
637 UOM_EXT_ATTR2,
638 UOM_EXT_ATTR3,
639 UOM_EXT_ATTR4,
640 UOM_EXT_ATTR5,
641 UOM_EXT_ATTR6,
642 UOM_EXT_ATTR7,
643 UOM_EXT_ATTR8,
644 UOM_EXT_ATTR9,
645 UOM_EXT_ATTR10,
646 UOM_EXT_ATTR11,
647 UOM_EXT_ATTR12,
648 UOM_EXT_ATTR13,
649 UOM_EXT_ATTR14,
650 UOM_EXT_ATTR15,
651 UOM_EXT_ATTR16,
652 UOM_EXT_ATTR17,
653 UOM_EXT_ATTR18,
654 UOM_EXT_ATTR19,
655 UOM_EXT_ATTR20,
656 BILL_SEQUENCE_ID,
657 COMPONENT_SEQUENCE_ID,
658 STRUCTURE_TYPE_ID,
659 ATTR_GROUP_ID,
660 C_EXT_ATTR1,
661 C_EXT_ATTR2,
662 C_EXT_ATTR3,
663 C_EXT_ATTR4,
664 C_EXT_ATTR5,
665 C_EXT_ATTR6,
666 C_EXT_ATTR7,
667 C_EXT_ATTR8,
668 C_EXT_ATTR9,
669 C_EXT_ATTR10,
670 C_EXT_ATTR11,
671 C_EXT_ATTR12,
672 C_EXT_ATTR13,
673 C_EXT_ATTR14,
674 C_EXT_ATTR15,
675 C_EXT_ATTR16,
676 C_EXT_ATTR17,
677 C_EXT_ATTR18,
678 C_EXT_ATTR19,
679 C_EXT_ATTR20,
680 C_EXT_ATTR21,
681 C_EXT_ATTR22,
682 C_EXT_ATTR23,
683 C_EXT_ATTR24,
684 C_EXT_ATTR25,
685 C_EXT_ATTR26,
686 C_EXT_ATTR27,
687 C_EXT_ATTR28,
688 C_EXT_ATTR29,
689 C_EXT_ATTR30,
690 C_EXT_ATTR31,
691 C_EXT_ATTR32,
692 C_EXT_ATTR33,
693 C_EXT_ATTR34,
694 C_EXT_ATTR35,
695 C_EXT_ATTR36,
696 C_EXT_ATTR37,
697 C_EXT_ATTR38,
698 C_EXT_ATTR39,
699 C_EXT_ATTR40,
700 N_EXT_ATTR1,
701 N_EXT_ATTR2,
702 N_EXT_ATTR3,
703 N_EXT_ATTR4,
704 N_EXT_ATTR5,
705 N_EXT_ATTR6,
706 N_EXT_ATTR7,
707 N_EXT_ATTR8,
708 N_EXT_ATTR9,
709 N_EXT_ATTR10,
710 N_EXT_ATTR11,
711 N_EXT_ATTR12,
712 N_EXT_ATTR13
713 FROM BOM_COMPONENTS_EXT_B
714 WHERE EXTENSION_ID = X_EXTENSION_ID
715 FOR UPDATE OF EXTENSION_ID NOWAIT;
716 recinfo c%ROWTYPE;
717
718 CURSOR c1 IS SELECT
719 TL_EXT_ATTR1,
720 TL_EXT_ATTR2,
721 TL_EXT_ATTR3,
722 TL_EXT_ATTR4,
723 TL_EXT_ATTR5,
724 TL_EXT_ATTR6,
725 TL_EXT_ATTR7,
726 TL_EXT_ATTR8,
727 TL_EXT_ATTR9,
728 TL_EXT_ATTR10,
729 TL_EXT_ATTR11,
730 TL_EXT_ATTR12,
731 TL_EXT_ATTR13,
732 TL_EXT_ATTR14,
733 TL_EXT_ATTR15,
734 TL_EXT_ATTR16,
735 TL_EXT_ATTR17,
736 TL_EXT_ATTR18,
737 TL_EXT_ATTR19,
738 TL_EXT_ATTR20,
739 TL_EXT_ATTR21,
740 TL_EXT_ATTR22,
741 TL_EXT_ATTR23,
742 TL_EXT_ATTR24,
743 TL_EXT_ATTR25,
744 TL_EXT_ATTR26,
745 TL_EXT_ATTR27,
746 TL_EXT_ATTR28,
747 TL_EXT_ATTR29,
748 TL_EXT_ATTR30,
749 TL_EXT_ATTR31,
750 TL_EXT_ATTR32,
751 TL_EXT_ATTR33,
752 TL_EXT_ATTR34,
753 TL_EXT_ATTR35,
754 TL_EXT_ATTR36,
755 TL_EXT_ATTR37,
756 TL_EXT_ATTR38,
757 TL_EXT_ATTR39,
758 TL_EXT_ATTR40,
759 DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
760 FROM BOM_COMPONENTS_EXT_TL
761 WHERE EXTENSION_ID = X_EXTENSION_ID
762 AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
763 FOR UPDATE OF EXTENSION_ID NOWAIT;
764 BEGIN
765 OPEN c;
766 FETCH c INTO recinfo;
767 IF (c%NOTFOUND) THEN
768 CLOSE c;
769 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
770 app_exception.raise_exception;
771 END IF;
772 CLOSE c;
773 IF ( ((recinfo.N_EXT_ATTR14 = X_N_EXT_ATTR14)
774 OR ((recinfo.N_EXT_ATTR14 IS NULL) AND (X_N_EXT_ATTR14 IS NULL)))
775 AND ((recinfo.N_EXT_ATTR15 = X_N_EXT_ATTR15)
776 OR ((recinfo.N_EXT_ATTR15 IS NULL) AND (X_N_EXT_ATTR15 IS NULL)))
777 AND ((recinfo.N_EXT_ATTR16 = X_N_EXT_ATTR16)
778 OR ((recinfo.N_EXT_ATTR16 IS NULL) AND (X_N_EXT_ATTR16 IS NULL)))
779 AND ((recinfo.N_EXT_ATTR17 = X_N_EXT_ATTR17)
780 OR ((recinfo.N_EXT_ATTR17 IS NULL) AND (X_N_EXT_ATTR17 IS NULL)))
781 AND ((recinfo.N_EXT_ATTR18 = X_N_EXT_ATTR18)
782 OR ((recinfo.N_EXT_ATTR18 IS NULL) AND (X_N_EXT_ATTR18 IS NULL)))
783 AND ((recinfo.N_EXT_ATTR19 = X_N_EXT_ATTR19)
784 OR ((recinfo.N_EXT_ATTR19 IS NULL) AND (X_N_EXT_ATTR19 IS NULL)))
785 AND ((recinfo.N_EXT_ATTR20 = X_N_EXT_ATTR20)
786 OR ((recinfo.N_EXT_ATTR20 IS NULL) AND (X_N_EXT_ATTR20 IS NULL)))
787 AND ((recinfo.D_EXT_ATTR1 = X_D_EXT_ATTR1)
788 OR ((recinfo.D_EXT_ATTR1 IS NULL) AND (X_D_EXT_ATTR1 IS NULL)))
789 AND ((recinfo.D_EXT_ATTR2 = X_D_EXT_ATTR2)
790 OR ((recinfo.D_EXT_ATTR2 IS NULL) AND (X_D_EXT_ATTR2 IS NULL)))
791 AND ((recinfo.D_EXT_ATTR3 = X_D_EXT_ATTR3)
792 OR ((recinfo.D_EXT_ATTR3 IS NULL) AND (X_D_EXT_ATTR3 IS NULL)))
793 AND ((recinfo.D_EXT_ATTR4 = X_D_EXT_ATTR4)
794 OR ((recinfo.D_EXT_ATTR4 IS NULL) AND (X_D_EXT_ATTR4 IS NULL)))
795 AND ((recinfo.D_EXT_ATTR5 = X_D_EXT_ATTR5)
796 OR ((recinfo.D_EXT_ATTR5 IS NULL) AND (X_D_EXT_ATTR5 IS NULL)))
797 AND ((recinfo.D_EXT_ATTR6 = X_D_EXT_ATTR6)
798 OR ((recinfo.D_EXT_ATTR6 IS NULL) AND (X_D_EXT_ATTR6 IS NULL)))
802 OR ((recinfo.D_EXT_ATTR8 IS NULL) AND (X_D_EXT_ATTR8 IS NULL)))
799 AND ((recinfo.D_EXT_ATTR7 = X_D_EXT_ATTR7)
800 OR ((recinfo.D_EXT_ATTR7 IS NULL) AND (X_D_EXT_ATTR7 IS NULL)))
801 AND ((recinfo.D_EXT_ATTR8 = X_D_EXT_ATTR8)
803 AND ((recinfo.D_EXT_ATTR9 = X_D_EXT_ATTR9)
804 OR ((recinfo.D_EXT_ATTR9 IS NULL) AND (X_D_EXT_ATTR9 IS NULL)))
805 AND ((recinfo.D_EXT_ATTR10 = X_D_EXT_ATTR10)
806 OR ((recinfo.D_EXT_ATTR10 IS NULL) AND (X_D_EXT_ATTR10 IS NULL)))
807 AND ((recinfo.UOM_EXT_ATTR1 = X_UOM_EXT_ATTR1)
808 OR ((recinfo.UOM_EXT_ATTR1 IS NULL) AND (X_UOM_EXT_ATTR1 IS NULL)))
809 AND ((recinfo.UOM_EXT_ATTR2 = X_UOM_EXT_ATTR2)
810 OR ((recinfo.UOM_EXT_ATTR2 IS NULL) AND (X_UOM_EXT_ATTR2 IS NULL)))
811 AND ((recinfo.UOM_EXT_ATTR3 = X_UOM_EXT_ATTR3)
812 OR ((recinfo.UOM_EXT_ATTR3 IS NULL) AND (X_UOM_EXT_ATTR3 IS NULL)))
813 AND ((recinfo.UOM_EXT_ATTR4 = X_UOM_EXT_ATTR4)
814 OR ((recinfo.UOM_EXT_ATTR4 IS NULL) AND (X_UOM_EXT_ATTR4 IS NULL)))
815 AND ((recinfo.UOM_EXT_ATTR5 = X_UOM_EXT_ATTR5)
816 OR ((recinfo.UOM_EXT_ATTR5 IS NULL) AND (X_UOM_EXT_ATTR5 IS NULL)))
817 AND ((recinfo.UOM_EXT_ATTR6 = X_UOM_EXT_ATTR6)
818 OR ((recinfo.UOM_EXT_ATTR6 IS NULL) AND (X_UOM_EXT_ATTR6 IS NULL)))
819 AND ((recinfo.UOM_EXT_ATTR7 = X_UOM_EXT_ATTR7)
820 OR ((recinfo.UOM_EXT_ATTR7 IS NULL) AND (X_UOM_EXT_ATTR7 IS NULL)))
821 AND ((recinfo.UOM_EXT_ATTR8 = X_UOM_EXT_ATTR8)
822 OR ((recinfo.UOM_EXT_ATTR8 IS NULL) AND (X_UOM_EXT_ATTR8 IS NULL)))
823 AND ((recinfo.UOM_EXT_ATTR9 = X_UOM_EXT_ATTR9)
824 OR ((recinfo.UOM_EXT_ATTR9 IS NULL) AND (X_UOM_EXT_ATTR9 IS NULL)))
825 AND ((recinfo.UOM_EXT_ATTR10 = X_UOM_EXT_ATTR10)
826 OR ((recinfo.UOM_EXT_ATTR10 IS NULL) AND (X_UOM_EXT_ATTR10 IS NULL)))
827 AND ((recinfo.UOM_EXT_ATTR11 = X_UOM_EXT_ATTR11)
828 OR ((recinfo.UOM_EXT_ATTR11 IS NULL) AND (X_UOM_EXT_ATTR11 IS NULL)))
829 AND ((recinfo.UOM_EXT_ATTR12 = X_UOM_EXT_ATTR12)
830 OR ((recinfo.UOM_EXT_ATTR12 IS NULL) AND (X_UOM_EXT_ATTR12 IS NULL)))
831 AND ((recinfo.UOM_EXT_ATTR13 = X_UOM_EXT_ATTR13)
832 OR ((recinfo.UOM_EXT_ATTR13 IS NULL) AND (X_UOM_EXT_ATTR13 IS NULL)))
833 AND ((recinfo.UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14)
834 OR ((recinfo.UOM_EXT_ATTR14 IS NULL) AND (X_UOM_EXT_ATTR14 IS NULL)))
835 AND ((recinfo.UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15)
836 OR ((recinfo.UOM_EXT_ATTR15 IS NULL) AND (X_UOM_EXT_ATTR15 IS NULL)))
837 AND ((recinfo.UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16)
838 OR ((recinfo.UOM_EXT_ATTR16 IS NULL) AND (X_UOM_EXT_ATTR16 IS NULL)))
839 AND ((recinfo.UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17)
840 OR ((recinfo.UOM_EXT_ATTR17 IS NULL) AND (X_UOM_EXT_ATTR17 IS NULL)))
841 AND ((recinfo.UOM_EXT_ATTR18 = X_UOM_EXT_ATTR18)
842 OR ((recinfo.UOM_EXT_ATTR18 IS NULL) AND (X_UOM_EXT_ATTR18 IS NULL)))
843 AND ((recinfo.UOM_EXT_ATTR19 = X_UOM_EXT_ATTR19)
844 OR ((recinfo.UOM_EXT_ATTR19 IS NULL) AND (X_UOM_EXT_ATTR19 IS NULL)))
845 AND ((recinfo.UOM_EXT_ATTR20 = X_UOM_EXT_ATTR20)
846 OR ((recinfo.UOM_EXT_ATTR20 IS NULL) AND (X_UOM_EXT_ATTR20 IS NULL)))
847 AND ((recinfo.BILL_SEQUENCE_ID = X_BILL_SEQUENCE_ID)
848 OR ((recinfo.BILL_SEQUENCE_ID IS NULL) AND (X_BILL_SEQUENCE_ID IS NULL)))
849 AND (recinfo.COMPONENT_SEQUENCE_ID = X_COMPONENT_SEQUENCE_ID)
850 AND (recinfo.STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID)
851 AND (recinfo.ATTR_GROUP_ID = X_ATTR_GROUP_ID)
852 AND ((recinfo.C_EXT_ATTR1 = X_C_EXT_ATTR1)
853 OR ((recinfo.C_EXT_ATTR1 IS NULL) AND (X_C_EXT_ATTR1 IS NULL)))
854 AND ((recinfo.C_EXT_ATTR2 = X_C_EXT_ATTR2)
855 OR ((recinfo.C_EXT_ATTR2 IS NULL) AND (X_C_EXT_ATTR2 IS NULL)))
856 AND ((recinfo.C_EXT_ATTR3 = X_C_EXT_ATTR3)
857 OR ((recinfo.C_EXT_ATTR3 IS NULL) AND (X_C_EXT_ATTR3 IS NULL)))
858 AND ((recinfo.C_EXT_ATTR4 = X_C_EXT_ATTR4)
859 OR ((recinfo.C_EXT_ATTR4 IS NULL) AND (X_C_EXT_ATTR4 IS NULL)))
860 AND ((recinfo.C_EXT_ATTR5 = X_C_EXT_ATTR5)
861 OR ((recinfo.C_EXT_ATTR5 IS NULL) AND (X_C_EXT_ATTR5 IS NULL)))
862 AND ((recinfo.C_EXT_ATTR6 = X_C_EXT_ATTR6)
863 OR ((recinfo.C_EXT_ATTR6 IS NULL) AND (X_C_EXT_ATTR6 IS NULL)))
864 AND ((recinfo.C_EXT_ATTR7 = X_C_EXT_ATTR7)
865 OR ((recinfo.C_EXT_ATTR7 IS NULL) AND (X_C_EXT_ATTR7 IS NULL)))
866 AND ((recinfo.C_EXT_ATTR8 = X_C_EXT_ATTR8)
867 OR ((recinfo.C_EXT_ATTR8 IS NULL) AND (X_C_EXT_ATTR8 IS NULL)))
868 AND ((recinfo.C_EXT_ATTR9 = X_C_EXT_ATTR9)
869 OR ((recinfo.C_EXT_ATTR9 IS NULL) AND (X_C_EXT_ATTR9 IS NULL)))
870 AND ((recinfo.C_EXT_ATTR10 = X_C_EXT_ATTR10)
871 OR ((recinfo.C_EXT_ATTR10 IS NULL) AND (X_C_EXT_ATTR10 IS NULL)))
872 AND ((recinfo.C_EXT_ATTR11 = X_C_EXT_ATTR11)
873 OR ((recinfo.C_EXT_ATTR11 IS NULL) AND (X_C_EXT_ATTR11 IS NULL)))
874 AND ((recinfo.C_EXT_ATTR12 = X_C_EXT_ATTR12)
875 OR ((recinfo.C_EXT_ATTR12 IS NULL) AND (X_C_EXT_ATTR12 IS NULL)))
876 AND ((recinfo.C_EXT_ATTR13 = X_C_EXT_ATTR13)
877 OR ((recinfo.C_EXT_ATTR13 IS NULL) AND (X_C_EXT_ATTR13 IS NULL)))
878 AND ((recinfo.C_EXT_ATTR14 = X_C_EXT_ATTR14)
879 OR ((recinfo.C_EXT_ATTR14 IS NULL) AND (X_C_EXT_ATTR14 IS NULL)))
880 AND ((recinfo.C_EXT_ATTR15 = X_C_EXT_ATTR15)
881 OR ((recinfo.C_EXT_ATTR15 IS NULL) AND (X_C_EXT_ATTR15 IS NULL)))
882 AND ((recinfo.C_EXT_ATTR16 = X_C_EXT_ATTR16)
883 OR ((recinfo.C_EXT_ATTR16 IS NULL) AND (X_C_EXT_ATTR16 IS NULL)))
884 AND ((recinfo.C_EXT_ATTR17 = X_C_EXT_ATTR17)
885 OR ((recinfo.C_EXT_ATTR17 IS NULL) AND (X_C_EXT_ATTR17 IS NULL)))
886 AND ((recinfo.C_EXT_ATTR18 = X_C_EXT_ATTR18)
887 OR ((recinfo.C_EXT_ATTR18 IS NULL) AND (X_C_EXT_ATTR18 IS NULL)))
888 AND ((recinfo.C_EXT_ATTR19 = X_C_EXT_ATTR19)
889 OR ((recinfo.C_EXT_ATTR19 IS NULL) AND (X_C_EXT_ATTR19 IS NULL)))
893 OR ((recinfo.C_EXT_ATTR21 IS NULL) AND (X_C_EXT_ATTR21 IS NULL)))
890 AND ((recinfo.C_EXT_ATTR20 = X_C_EXT_ATTR20)
891 OR ((recinfo.C_EXT_ATTR20 IS NULL) AND (X_C_EXT_ATTR20 IS NULL)))
892 AND ((recinfo.C_EXT_ATTR21 = X_C_EXT_ATTR21)
894 AND ((recinfo.C_EXT_ATTR22 = X_C_EXT_ATTR22)
895 OR ((recinfo.C_EXT_ATTR22 IS NULL) AND (X_C_EXT_ATTR22 IS NULL)))
896 AND ((recinfo.C_EXT_ATTR23 = X_C_EXT_ATTR23)
897 OR ((recinfo.C_EXT_ATTR23 IS NULL) AND (X_C_EXT_ATTR23 IS NULL)))
898 AND ((recinfo.C_EXT_ATTR24 = X_C_EXT_ATTR24)
899 OR ((recinfo.C_EXT_ATTR24 IS NULL) AND (X_C_EXT_ATTR24 IS NULL)))
900 AND ((recinfo.C_EXT_ATTR25 = X_C_EXT_ATTR25)
901 OR ((recinfo.C_EXT_ATTR25 IS NULL) AND (X_C_EXT_ATTR25 IS NULL)))
902 AND ((recinfo.C_EXT_ATTR26 = X_C_EXT_ATTR26)
903 OR ((recinfo.C_EXT_ATTR26 IS NULL) AND (X_C_EXT_ATTR26 IS NULL)))
904 AND ((recinfo.C_EXT_ATTR27 = X_C_EXT_ATTR27)
905 OR ((recinfo.C_EXT_ATTR27 IS NULL) AND (X_C_EXT_ATTR27 IS NULL)))
906 AND ((recinfo.C_EXT_ATTR28 = X_C_EXT_ATTR28)
907 OR ((recinfo.C_EXT_ATTR28 IS NULL) AND (X_C_EXT_ATTR28 IS NULL)))
908 AND ((recinfo.C_EXT_ATTR29 = X_C_EXT_ATTR29)
909 OR ((recinfo.C_EXT_ATTR29 IS NULL) AND (X_C_EXT_ATTR29 IS NULL)))
910 AND ((recinfo.C_EXT_ATTR30 = X_C_EXT_ATTR30)
911 OR ((recinfo.C_EXT_ATTR30 IS NULL) AND (X_C_EXT_ATTR30 IS NULL)))
912 AND ((recinfo.C_EXT_ATTR31 = X_C_EXT_ATTR31)
913 OR ((recinfo.C_EXT_ATTR31 IS NULL) AND (X_C_EXT_ATTR31 IS NULL)))
914 AND ((recinfo.C_EXT_ATTR32 = X_C_EXT_ATTR32)
915 OR ((recinfo.C_EXT_ATTR32 IS NULL) AND (X_C_EXT_ATTR32 IS NULL)))
916 AND ((recinfo.C_EXT_ATTR33 = X_C_EXT_ATTR33)
917 OR ((recinfo.C_EXT_ATTR33 IS NULL) AND (X_C_EXT_ATTR33 IS NULL)))
918 AND ((recinfo.C_EXT_ATTR34 = X_C_EXT_ATTR34)
919 OR ((recinfo.C_EXT_ATTR34 IS NULL) AND (X_C_EXT_ATTR34 IS NULL)))
920 AND ((recinfo.C_EXT_ATTR35 = X_C_EXT_ATTR35)
921 OR ((recinfo.C_EXT_ATTR35 IS NULL) AND (X_C_EXT_ATTR35 IS NULL)))
922 AND ((recinfo.C_EXT_ATTR36 = X_C_EXT_ATTR36)
923 OR ((recinfo.C_EXT_ATTR36 IS NULL) AND (X_C_EXT_ATTR36 IS NULL)))
924 AND ((recinfo.C_EXT_ATTR37 = X_C_EXT_ATTR37)
925 OR ((recinfo.C_EXT_ATTR37 IS NULL) AND (X_C_EXT_ATTR37 IS NULL)))
926 AND ((recinfo.C_EXT_ATTR38 = X_C_EXT_ATTR38)
927 OR ((recinfo.C_EXT_ATTR38 IS NULL) AND (X_C_EXT_ATTR38 IS NULL)))
928 AND ((recinfo.C_EXT_ATTR39 = X_C_EXT_ATTR39)
929 OR ((recinfo.C_EXT_ATTR39 IS NULL) AND (X_C_EXT_ATTR39 IS NULL)))
930 AND ((recinfo.C_EXT_ATTR40 = X_C_EXT_ATTR40)
931 OR ((recinfo.C_EXT_ATTR40 IS NULL) AND (X_C_EXT_ATTR40 IS NULL)))
932 AND ((recinfo.N_EXT_ATTR1 = X_N_EXT_ATTR1)
933 OR ((recinfo.N_EXT_ATTR1 IS NULL) AND (X_N_EXT_ATTR1 IS NULL)))
934 AND ((recinfo.N_EXT_ATTR2 = X_N_EXT_ATTR2)
935 OR ((recinfo.N_EXT_ATTR2 IS NULL) AND (X_N_EXT_ATTR2 IS NULL)))
936 AND ((recinfo.N_EXT_ATTR3 = X_N_EXT_ATTR3)
937 OR ((recinfo.N_EXT_ATTR3 IS NULL) AND (X_N_EXT_ATTR3 IS NULL)))
938 AND ((recinfo.N_EXT_ATTR4 = X_N_EXT_ATTR4)
939 OR ((recinfo.N_EXT_ATTR4 IS NULL) AND (X_N_EXT_ATTR4 IS NULL)))
940 AND ((recinfo.N_EXT_ATTR5 = X_N_EXT_ATTR5)
941 OR ((recinfo.N_EXT_ATTR5 IS NULL) AND (X_N_EXT_ATTR5 IS NULL)))
942 AND ((recinfo.N_EXT_ATTR6 = X_N_EXT_ATTR6)
943 OR ((recinfo.N_EXT_ATTR6 IS NULL) AND (X_N_EXT_ATTR6 IS NULL)))
944 AND ((recinfo.N_EXT_ATTR7 = X_N_EXT_ATTR7)
945 OR ((recinfo.N_EXT_ATTR7 IS NULL) AND (X_N_EXT_ATTR7 IS NULL)))
946 AND ((recinfo.N_EXT_ATTR8 = X_N_EXT_ATTR8)
947 OR ((recinfo.N_EXT_ATTR8 IS NULL) AND (X_N_EXT_ATTR8 IS NULL)))
948 AND ((recinfo.N_EXT_ATTR9 = X_N_EXT_ATTR9)
949 OR ((recinfo.N_EXT_ATTR9 IS NULL) AND (X_N_EXT_ATTR9 IS NULL)))
950 AND ((recinfo.N_EXT_ATTR10 = X_N_EXT_ATTR10)
951 OR ((recinfo.N_EXT_ATTR10 IS NULL) AND (X_N_EXT_ATTR10 IS NULL)))
952 AND ((recinfo.N_EXT_ATTR11 = X_N_EXT_ATTR11)
953 OR ((recinfo.N_EXT_ATTR11 IS NULL) AND (X_N_EXT_ATTR11 IS NULL)))
954 AND ((recinfo.N_EXT_ATTR12 = X_N_EXT_ATTR12)
955 OR ((recinfo.N_EXT_ATTR12 IS NULL) AND (X_N_EXT_ATTR12 IS NULL)))
956 AND ((recinfo.N_EXT_ATTR13 = X_N_EXT_ATTR13)
957 OR ((recinfo.N_EXT_ATTR13 IS NULL) AND (X_N_EXT_ATTR13 IS NULL)))
958 ) THEN
959 NULL;
960 ELSE
961 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
962 app_exception.raise_exception;
963 END IF;
964
965 FOR tlinfo IN c1 LOOP
966 IF (tlinfo.BASELANG = 'Y') THEN
967 IF ( ((tlinfo.TL_EXT_ATTR1 = X_TL_EXT_ATTR1)
968 OR ((tlinfo.TL_EXT_ATTR1 IS NULL) AND (X_TL_EXT_ATTR1 IS NULL)))
969 AND ((tlinfo.TL_EXT_ATTR2 = X_TL_EXT_ATTR2)
970 OR ((tlinfo.TL_EXT_ATTR2 IS NULL) AND (X_TL_EXT_ATTR2 IS NULL)))
971 AND ((tlinfo.TL_EXT_ATTR3 = X_TL_EXT_ATTR3)
972 OR ((tlinfo.TL_EXT_ATTR3 IS NULL) AND (X_TL_EXT_ATTR3 IS NULL)))
973 AND ((tlinfo.TL_EXT_ATTR4 = X_TL_EXT_ATTR4)
974 OR ((tlinfo.TL_EXT_ATTR4 IS NULL) AND (X_TL_EXT_ATTR4 IS NULL)))
975 AND ((tlinfo.TL_EXT_ATTR5 = X_TL_EXT_ATTR5)
976 OR ((tlinfo.TL_EXT_ATTR5 IS NULL) AND (X_TL_EXT_ATTR5 IS NULL)))
977 AND ((tlinfo.TL_EXT_ATTR6 = X_TL_EXT_ATTR6)
978 OR ((tlinfo.TL_EXT_ATTR6 IS NULL) AND (X_TL_EXT_ATTR6 IS NULL)))
979 AND ((tlinfo.TL_EXT_ATTR7 = X_TL_EXT_ATTR7)
980 OR ((tlinfo.TL_EXT_ATTR7 IS NULL) AND (X_TL_EXT_ATTR7 IS NULL)))
981 AND ((tlinfo.TL_EXT_ATTR8 = X_TL_EXT_ATTR8)
982 OR ((tlinfo.TL_EXT_ATTR8 IS NULL) AND (X_TL_EXT_ATTR8 IS NULL)))
983 AND ((tlinfo.TL_EXT_ATTR9 = X_TL_EXT_ATTR9)
984 OR ((tlinfo.TL_EXT_ATTR9 IS NULL) AND (X_TL_EXT_ATTR9 IS NULL)))
985 AND ((tlinfo.TL_EXT_ATTR10 = X_TL_EXT_ATTR10)
989 AND ((tlinfo.TL_EXT_ATTR12 = X_TL_EXT_ATTR12)
986 OR ((tlinfo.TL_EXT_ATTR10 IS NULL) AND (X_TL_EXT_ATTR10 IS NULL)))
987 AND ((tlinfo.TL_EXT_ATTR11 = X_TL_EXT_ATTR11)
988 OR ((tlinfo.TL_EXT_ATTR11 IS NULL) AND (X_TL_EXT_ATTR11 IS NULL)))
990 OR ((tlinfo.TL_EXT_ATTR12 IS NULL) AND (X_TL_EXT_ATTR12 IS NULL)))
991 AND ((tlinfo.TL_EXT_ATTR13 = X_TL_EXT_ATTR13)
992 OR ((tlinfo.TL_EXT_ATTR13 IS NULL) AND (X_TL_EXT_ATTR13 IS NULL)))
993 AND ((tlinfo.TL_EXT_ATTR14 = X_TL_EXT_ATTR14)
994 OR ((tlinfo.TL_EXT_ATTR14 IS NULL) AND (X_TL_EXT_ATTR14 IS NULL)))
995 AND ((tlinfo.TL_EXT_ATTR15 = X_TL_EXT_ATTR15)
996 OR ((tlinfo.TL_EXT_ATTR15 IS NULL) AND (X_TL_EXT_ATTR15 IS NULL)))
997 AND ((tlinfo.TL_EXT_ATTR16 = X_TL_EXT_ATTR16)
998 OR ((tlinfo.TL_EXT_ATTR16 IS NULL) AND (X_TL_EXT_ATTR16 IS NULL)))
999 AND ((tlinfo.TL_EXT_ATTR17 = X_TL_EXT_ATTR17)
1000 OR ((tlinfo.TL_EXT_ATTR17 IS NULL) AND (X_TL_EXT_ATTR17 IS NULL)))
1001 AND ((tlinfo.TL_EXT_ATTR18 = X_TL_EXT_ATTR18)
1002 OR ((tlinfo.TL_EXT_ATTR18 IS NULL) AND (X_TL_EXT_ATTR18 IS NULL)))
1003 AND ((tlinfo.TL_EXT_ATTR19 = X_TL_EXT_ATTR19)
1004 OR ((tlinfo.TL_EXT_ATTR19 IS NULL) AND (X_TL_EXT_ATTR19 IS NULL)))
1005 AND ((tlinfo.TL_EXT_ATTR20 = X_TL_EXT_ATTR20)
1006 OR ((tlinfo.TL_EXT_ATTR20 IS NULL) AND (X_TL_EXT_ATTR20 IS NULL)))
1007 AND ((tlinfo.TL_EXT_ATTR21 = X_TL_EXT_ATTR21)
1008 OR ((tlinfo.TL_EXT_ATTR21 IS NULL) AND (X_TL_EXT_ATTR21 IS NULL)))
1009 AND ((tlinfo.TL_EXT_ATTR22 = X_TL_EXT_ATTR22)
1010 OR ((tlinfo.TL_EXT_ATTR22 IS NULL) AND (X_TL_EXT_ATTR22 IS NULL)))
1011 AND ((tlinfo.TL_EXT_ATTR23 = X_TL_EXT_ATTR23)
1012 OR ((tlinfo.TL_EXT_ATTR23 IS NULL) AND (X_TL_EXT_ATTR23 IS NULL)))
1013 AND ((tlinfo.TL_EXT_ATTR24 = X_TL_EXT_ATTR24)
1014 OR ((tlinfo.TL_EXT_ATTR24 IS NULL) AND (X_TL_EXT_ATTR24 IS NULL)))
1015 AND ((tlinfo.TL_EXT_ATTR25 = X_TL_EXT_ATTR25)
1016 OR ((tlinfo.TL_EXT_ATTR25 IS NULL) AND (X_TL_EXT_ATTR25 IS NULL)))
1017 AND ((tlinfo.TL_EXT_ATTR26 = X_TL_EXT_ATTR26)
1018 OR ((tlinfo.TL_EXT_ATTR26 IS NULL) AND (X_TL_EXT_ATTR26 IS NULL)))
1019 AND ((tlinfo.TL_EXT_ATTR27 = X_TL_EXT_ATTR27)
1020 OR ((tlinfo.TL_EXT_ATTR27 IS NULL) AND (X_TL_EXT_ATTR27 IS NULL)))
1021 AND ((tlinfo.TL_EXT_ATTR28 = X_TL_EXT_ATTR28)
1022 OR ((tlinfo.TL_EXT_ATTR28 IS NULL) AND (X_TL_EXT_ATTR28 IS NULL)))
1023 AND ((tlinfo.TL_EXT_ATTR29 = X_TL_EXT_ATTR29)
1024 OR ((tlinfo.TL_EXT_ATTR29 IS NULL) AND (X_TL_EXT_ATTR29 IS NULL)))
1025 AND ((tlinfo.TL_EXT_ATTR30 = X_TL_EXT_ATTR30)
1026 OR ((tlinfo.TL_EXT_ATTR30 IS NULL) AND (X_TL_EXT_ATTR30 IS NULL)))
1027 AND ((tlinfo.TL_EXT_ATTR31 = X_TL_EXT_ATTR31)
1028 OR ((tlinfo.TL_EXT_ATTR31 IS NULL) AND (X_TL_EXT_ATTR31 IS NULL)))
1029 AND ((tlinfo.TL_EXT_ATTR32 = X_TL_EXT_ATTR32)
1030 OR ((tlinfo.TL_EXT_ATTR32 IS NULL) AND (X_TL_EXT_ATTR32 IS NULL)))
1031 AND ((tlinfo.TL_EXT_ATTR33 = X_TL_EXT_ATTR33)
1032 OR ((tlinfo.TL_EXT_ATTR33 IS NULL) AND (X_TL_EXT_ATTR33 IS NULL)))
1033 AND ((tlinfo.TL_EXT_ATTR34 = X_TL_EXT_ATTR34)
1034 OR ((tlinfo.TL_EXT_ATTR34 IS NULL) AND (X_TL_EXT_ATTR34 IS NULL)))
1035 AND ((tlinfo.TL_EXT_ATTR35 = X_TL_EXT_ATTR35)
1036 OR ((tlinfo.TL_EXT_ATTR35 IS NULL) AND (X_TL_EXT_ATTR35 IS NULL)))
1037 AND ((tlinfo.TL_EXT_ATTR36 = X_TL_EXT_ATTR36)
1038 OR ((tlinfo.TL_EXT_ATTR36 IS NULL) AND (X_TL_EXT_ATTR36 IS NULL)))
1039 AND ((tlinfo.TL_EXT_ATTR37 = X_TL_EXT_ATTR37)
1040 OR ((tlinfo.TL_EXT_ATTR37 IS NULL) AND (X_TL_EXT_ATTR37 IS NULL)))
1041 AND ((tlinfo.TL_EXT_ATTR38 = X_TL_EXT_ATTR38)
1042 OR ((tlinfo.TL_EXT_ATTR38 IS NULL) AND (X_TL_EXT_ATTR38 IS NULL)))
1043 AND ((tlinfo.TL_EXT_ATTR39 = X_TL_EXT_ATTR39)
1044 OR ((tlinfo.TL_EXT_ATTR39 IS NULL) AND (X_TL_EXT_ATTR39 IS NULL)))
1045 AND ((tlinfo.TL_EXT_ATTR40 = X_TL_EXT_ATTR40)
1046 OR ((tlinfo.TL_EXT_ATTR40 IS NULL) AND (X_TL_EXT_ATTR40 IS NULL)))
1047 ) THEN
1048 NULL;
1049 ELSE
1050 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1051 app_exception.raise_exception;
1052 END IF;
1053 END IF;
1054 END LOOP;
1055 RETURN;
1056 END LOCK_ROW;
1057
1058 PROCEDURE UPDATE_ROW (
1059 X_EXTENSION_ID IN NUMBER,
1060 X_N_EXT_ATTR14 IN NUMBER,
1061 X_N_EXT_ATTR15 IN NUMBER,
1062 X_N_EXT_ATTR16 IN NUMBER,
1063 X_N_EXT_ATTR17 IN NUMBER,
1064 X_N_EXT_ATTR18 IN NUMBER,
1065 X_N_EXT_ATTR19 IN NUMBER,
1066 X_N_EXT_ATTR20 IN NUMBER,
1067 X_D_EXT_ATTR1 IN DATE,
1068 X_D_EXT_ATTR2 IN DATE,
1069 X_D_EXT_ATTR3 IN DATE,
1070 X_D_EXT_ATTR4 IN DATE,
1071 X_D_EXT_ATTR5 IN DATE,
1072 X_D_EXT_ATTR6 IN DATE,
1073 X_D_EXT_ATTR7 IN DATE,
1074 X_D_EXT_ATTR8 IN DATE,
1075 X_D_EXT_ATTR9 IN DATE,
1076 X_D_EXT_ATTR10 IN DATE,
1077 X_UOM_EXT_ATTR1 IN VARCHAR2,
1078 X_UOM_EXT_ATTR2 IN VARCHAR2,
1079 X_UOM_EXT_ATTR3 IN VARCHAR2,
1080 X_UOM_EXT_ATTR4 IN VARCHAR2,
1081 X_UOM_EXT_ATTR5 IN VARCHAR2,
1082 X_UOM_EXT_ATTR6 IN VARCHAR2,
1083 X_UOM_EXT_ATTR7 IN VARCHAR2,
1084 X_UOM_EXT_ATTR8 IN VARCHAR2,
1085 X_UOM_EXT_ATTR9 IN VARCHAR2,
1086 X_UOM_EXT_ATTR10 IN VARCHAR2,
1087 X_UOM_EXT_ATTR11 IN VARCHAR2,
1088 X_UOM_EXT_ATTR12 IN VARCHAR2,
1089 X_UOM_EXT_ATTR13 IN VARCHAR2,
1090 X_UOM_EXT_ATTR14 IN VARCHAR2,
1091 X_UOM_EXT_ATTR15 IN VARCHAR2,
1092 X_UOM_EXT_ATTR16 IN VARCHAR2,
1093 X_UOM_EXT_ATTR17 IN VARCHAR2,
1094 X_UOM_EXT_ATTR18 IN VARCHAR2,
1095 X_UOM_EXT_ATTR19 IN VARCHAR2,
1096 X_UOM_EXT_ATTR20 IN VARCHAR2,
1097 X_BILL_SEQUENCE_ID IN NUMBER,
1101 X_C_EXT_ATTR1 IN VARCHAR2,
1098 X_COMPONENT_SEQUENCE_ID IN NUMBER,
1099 X_STRUCTURE_TYPE_ID IN NUMBER,
1100 X_ATTR_GROUP_ID IN NUMBER,
1102 X_C_EXT_ATTR2 IN VARCHAR2,
1103 X_C_EXT_ATTR3 IN VARCHAR2,
1104 X_C_EXT_ATTR4 IN VARCHAR2,
1105 X_C_EXT_ATTR5 IN VARCHAR2,
1106 X_C_EXT_ATTR6 IN VARCHAR2,
1107 X_C_EXT_ATTR7 IN VARCHAR2,
1108 X_C_EXT_ATTR8 IN VARCHAR2,
1109 X_C_EXT_ATTR9 IN VARCHAR2,
1110 X_C_EXT_ATTR10 IN VARCHAR2,
1111 X_C_EXT_ATTR11 IN VARCHAR2,
1112 X_C_EXT_ATTR12 IN VARCHAR2,
1113 X_C_EXT_ATTR13 IN VARCHAR2,
1114 X_C_EXT_ATTR14 IN VARCHAR2,
1115 X_C_EXT_ATTR15 IN VARCHAR2,
1116 X_C_EXT_ATTR16 IN VARCHAR2,
1117 X_C_EXT_ATTR17 IN VARCHAR2,
1118 X_C_EXT_ATTR18 IN VARCHAR2,
1119 X_C_EXT_ATTR19 IN VARCHAR2,
1120 X_C_EXT_ATTR20 IN VARCHAR2,
1121 X_C_EXT_ATTR21 IN VARCHAR2,
1122 X_C_EXT_ATTR22 IN VARCHAR2,
1123 X_C_EXT_ATTR23 IN VARCHAR2,
1124 X_C_EXT_ATTR24 IN VARCHAR2,
1125 X_C_EXT_ATTR25 IN VARCHAR2,
1126 X_C_EXT_ATTR26 IN VARCHAR2,
1127 X_C_EXT_ATTR27 IN VARCHAR2,
1128 X_C_EXT_ATTR28 IN VARCHAR2,
1129 X_C_EXT_ATTR29 IN VARCHAR2,
1130 X_C_EXT_ATTR30 IN VARCHAR2,
1131 X_C_EXT_ATTR31 IN VARCHAR2,
1132 X_C_EXT_ATTR32 IN VARCHAR2,
1133 X_C_EXT_ATTR33 IN VARCHAR2,
1134 X_C_EXT_ATTR34 IN VARCHAR2,
1135 X_C_EXT_ATTR35 IN VARCHAR2,
1136 X_C_EXT_ATTR36 IN VARCHAR2,
1137 X_C_EXT_ATTR37 IN VARCHAR2,
1138 X_C_EXT_ATTR38 IN VARCHAR2,
1139 X_C_EXT_ATTR39 IN VARCHAR2,
1140 X_C_EXT_ATTR40 IN VARCHAR2,
1141 X_N_EXT_ATTR1 IN NUMBER,
1142 X_N_EXT_ATTR2 IN NUMBER,
1143 X_N_EXT_ATTR3 IN NUMBER,
1144 X_N_EXT_ATTR4 IN NUMBER,
1145 X_N_EXT_ATTR5 IN NUMBER,
1146 X_N_EXT_ATTR6 IN NUMBER,
1147 X_N_EXT_ATTR7 IN NUMBER,
1148 X_N_EXT_ATTR8 IN NUMBER,
1149 X_N_EXT_ATTR9 IN NUMBER,
1150 X_N_EXT_ATTR10 IN NUMBER,
1151 X_N_EXT_ATTR11 IN NUMBER,
1152 X_N_EXT_ATTR12 IN NUMBER,
1153 X_N_EXT_ATTR13 IN NUMBER,
1154 X_TL_EXT_ATTR1 IN VARCHAR2,
1155 X_TL_EXT_ATTR2 IN VARCHAR2,
1156 X_TL_EXT_ATTR3 IN VARCHAR2,
1157 X_TL_EXT_ATTR4 IN VARCHAR2,
1158 X_TL_EXT_ATTR5 IN VARCHAR2,
1159 X_TL_EXT_ATTR6 IN VARCHAR2,
1160 X_TL_EXT_ATTR7 IN VARCHAR2,
1161 X_TL_EXT_ATTR8 IN VARCHAR2,
1162 X_TL_EXT_ATTR9 IN VARCHAR2,
1163 X_TL_EXT_ATTR10 IN VARCHAR2,
1164 X_TL_EXT_ATTR11 IN VARCHAR2,
1165 X_TL_EXT_ATTR12 IN VARCHAR2,
1166 X_TL_EXT_ATTR13 IN VARCHAR2,
1167 X_TL_EXT_ATTR14 IN VARCHAR2,
1168 X_TL_EXT_ATTR15 IN VARCHAR2,
1169 X_TL_EXT_ATTR16 IN VARCHAR2,
1170 X_TL_EXT_ATTR17 IN VARCHAR2,
1171 X_TL_EXT_ATTR18 IN VARCHAR2,
1172 X_TL_EXT_ATTR19 IN VARCHAR2,
1173 X_TL_EXT_ATTR20 IN VARCHAR2,
1174 X_TL_EXT_ATTR21 IN VARCHAR2,
1175 X_TL_EXT_ATTR22 IN VARCHAR2,
1176 X_TL_EXT_ATTR23 IN VARCHAR2,
1177 X_TL_EXT_ATTR24 IN VARCHAR2,
1178 X_TL_EXT_ATTR25 IN VARCHAR2,
1179 X_TL_EXT_ATTR26 IN VARCHAR2,
1180 X_TL_EXT_ATTR27 IN VARCHAR2,
1181 X_TL_EXT_ATTR28 IN VARCHAR2,
1182 X_TL_EXT_ATTR29 IN VARCHAR2,
1183 X_TL_EXT_ATTR30 IN VARCHAR2,
1184 X_TL_EXT_ATTR31 IN VARCHAR2,
1185 X_TL_EXT_ATTR32 IN VARCHAR2,
1186 X_TL_EXT_ATTR33 IN VARCHAR2,
1187 X_TL_EXT_ATTR34 IN VARCHAR2,
1188 X_TL_EXT_ATTR35 IN VARCHAR2,
1189 X_TL_EXT_ATTR36 IN VARCHAR2,
1190 X_TL_EXT_ATTR37 IN VARCHAR2,
1191 X_TL_EXT_ATTR38 IN VARCHAR2,
1192 X_TL_EXT_ATTR39 IN VARCHAR2,
1193 X_TL_EXT_ATTR40 IN VARCHAR2,
1194 X_LAST_UPDATE_DATE IN DATE,
1195 X_LAST_UPDATED_BY IN NUMBER,
1196 X_LAST_UPDATE_LOGIN IN NUMBER
1197 ) IS
1198 BEGIN
1199 UPDATE BOM_COMPONENTS_EXT_B SET
1200 N_EXT_ATTR14 = X_N_EXT_ATTR14,
1201 N_EXT_ATTR15 = X_N_EXT_ATTR15,
1202 N_EXT_ATTR16 = X_N_EXT_ATTR16,
1203 N_EXT_ATTR17 = X_N_EXT_ATTR17,
1204 N_EXT_ATTR18 = X_N_EXT_ATTR18,
1205 N_EXT_ATTR19 = X_N_EXT_ATTR19,
1206 N_EXT_ATTR20 = X_N_EXT_ATTR20,
1207 D_EXT_ATTR1 = X_D_EXT_ATTR1,
1208 D_EXT_ATTR2 = X_D_EXT_ATTR2,
1209 D_EXT_ATTR3 = X_D_EXT_ATTR3,
1210 D_EXT_ATTR4 = X_D_EXT_ATTR4,
1211 D_EXT_ATTR5 = X_D_EXT_ATTR5,
1212 D_EXT_ATTR6 = X_D_EXT_ATTR6,
1213 D_EXT_ATTR7 = X_D_EXT_ATTR7,
1214 D_EXT_ATTR8 = X_D_EXT_ATTR8,
1215 D_EXT_ATTR9 = X_D_EXT_ATTR9,
1216 D_EXT_ATTR10 = X_D_EXT_ATTR10,
1217 UOM_EXT_ATTR1 = X_UOM_EXT_ATTR1,
1218 UOM_EXT_ATTR2 = X_UOM_EXT_ATTR2,
1219 UOM_EXT_ATTR3 = X_UOM_EXT_ATTR3,
1220 UOM_EXT_ATTR4 = X_UOM_EXT_ATTR4,
1221 UOM_EXT_ATTR5 = X_UOM_EXT_ATTR5,
1222 UOM_EXT_ATTR6 = X_UOM_EXT_ATTR6,
1223 UOM_EXT_ATTR7 = X_UOM_EXT_ATTR7,
1224 UOM_EXT_ATTR8 = X_UOM_EXT_ATTR8,
1225 UOM_EXT_ATTR9 = X_UOM_EXT_ATTR9,
1226 UOM_EXT_ATTR10 = X_UOM_EXT_ATTR10,
1227 UOM_EXT_ATTR11 = X_UOM_EXT_ATTR11,
1228 UOM_EXT_ATTR12 = X_UOM_EXT_ATTR12,
1229 UOM_EXT_ATTR13 = X_UOM_EXT_ATTR13,
1230 UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14,
1231 UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15,
1232 UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16,
1233 UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17,
1234 UOM_EXT_ATTR18 = X_UOM_EXT_ATTR18,
1235 UOM_EXT_ATTR19 = X_UOM_EXT_ATTR19,
1236 UOM_EXT_ATTR20 = X_UOM_EXT_ATTR20,
1237 BILL_SEQUENCE_ID = X_BILL_SEQUENCE_ID,
1238 COMPONENT_SEQUENCE_ID = X_COMPONENT_SEQUENCE_ID,
1239 STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID,
1240 ATTR_GROUP_ID = X_ATTR_GROUP_ID,
1241 C_EXT_ATTR1 = X_C_EXT_ATTR1,
1242 C_EXT_ATTR2 = X_C_EXT_ATTR2,
1243 C_EXT_ATTR3 = X_C_EXT_ATTR3,
1244 C_EXT_ATTR4 = X_C_EXT_ATTR4,
1245 C_EXT_ATTR5 = X_C_EXT_ATTR5,
1246 C_EXT_ATTR6 = X_C_EXT_ATTR6,
1247 C_EXT_ATTR7 = X_C_EXT_ATTR7,
1248 C_EXT_ATTR8 = X_C_EXT_ATTR8,
1249 C_EXT_ATTR9 = X_C_EXT_ATTR9,
1250 C_EXT_ATTR10 = X_C_EXT_ATTR10,
1251 C_EXT_ATTR11 = X_C_EXT_ATTR11,
1252 C_EXT_ATTR12 = X_C_EXT_ATTR12,
1256 C_EXT_ATTR16 = X_C_EXT_ATTR16,
1253 C_EXT_ATTR13 = X_C_EXT_ATTR13,
1254 C_EXT_ATTR14 = X_C_EXT_ATTR14,
1255 C_EXT_ATTR15 = X_C_EXT_ATTR15,
1257 C_EXT_ATTR17 = X_C_EXT_ATTR17,
1258 C_EXT_ATTR18 = X_C_EXT_ATTR18,
1259 C_EXT_ATTR19 = X_C_EXT_ATTR19,
1260 C_EXT_ATTR20 = X_C_EXT_ATTR20,
1261 C_EXT_ATTR21 = X_C_EXT_ATTR21,
1262 C_EXT_ATTR22 = X_C_EXT_ATTR22,
1263 C_EXT_ATTR23 = X_C_EXT_ATTR23,
1264 C_EXT_ATTR24 = X_C_EXT_ATTR24,
1265 C_EXT_ATTR25 = X_C_EXT_ATTR25,
1266 C_EXT_ATTR26 = X_C_EXT_ATTR26,
1267 C_EXT_ATTR27 = X_C_EXT_ATTR27,
1268 C_EXT_ATTR28 = X_C_EXT_ATTR28,
1269 C_EXT_ATTR29 = X_C_EXT_ATTR29,
1270 C_EXT_ATTR30 = X_C_EXT_ATTR30,
1271 C_EXT_ATTR31 = X_C_EXT_ATTR31,
1272 C_EXT_ATTR32 = X_C_EXT_ATTR32,
1273 C_EXT_ATTR33 = X_C_EXT_ATTR33,
1274 C_EXT_ATTR34 = X_C_EXT_ATTR34,
1275 C_EXT_ATTR35 = X_C_EXT_ATTR35,
1276 C_EXT_ATTR36 = X_C_EXT_ATTR36,
1277 C_EXT_ATTR37 = X_C_EXT_ATTR37,
1278 C_EXT_ATTR38 = X_C_EXT_ATTR38,
1279 C_EXT_ATTR39 = X_C_EXT_ATTR39,
1280 C_EXT_ATTR40 = X_C_EXT_ATTR40,
1281 N_EXT_ATTR1 = X_N_EXT_ATTR1,
1282 N_EXT_ATTR2 = X_N_EXT_ATTR2,
1283 N_EXT_ATTR3 = X_N_EXT_ATTR3,
1284 N_EXT_ATTR4 = X_N_EXT_ATTR4,
1285 N_EXT_ATTR5 = X_N_EXT_ATTR5,
1286 N_EXT_ATTR6 = X_N_EXT_ATTR6,
1287 N_EXT_ATTR7 = X_N_EXT_ATTR7,
1288 N_EXT_ATTR8 = X_N_EXT_ATTR8,
1289 N_EXT_ATTR9 = X_N_EXT_ATTR9,
1290 N_EXT_ATTR10 = X_N_EXT_ATTR10,
1291 N_EXT_ATTR11 = X_N_EXT_ATTR11,
1292 N_EXT_ATTR12 = X_N_EXT_ATTR12,
1293 N_EXT_ATTR13 = X_N_EXT_ATTR13,
1294 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1295 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1296 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
1297 WHERE EXTENSION_ID = X_EXTENSION_ID;
1298
1299 IF (SQL%NOTFOUND) THEN
1300 RAISE NO_DATA_FOUND;
1301 END IF;
1302
1303 UPDATE BOM_COMPONENTS_EXT_TL SET
1304 TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1305 TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1306 TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1307 TL_EXT_ATTR4 = X_TL_EXT_ATTR4,
1308 TL_EXT_ATTR5 = X_TL_EXT_ATTR5,
1309 TL_EXT_ATTR6 = X_TL_EXT_ATTR6,
1310 TL_EXT_ATTR7 = X_TL_EXT_ATTR7,
1311 TL_EXT_ATTR8 = X_TL_EXT_ATTR8,
1312 TL_EXT_ATTR9 = X_TL_EXT_ATTR9,
1313 TL_EXT_ATTR10 = X_TL_EXT_ATTR10,
1314 TL_EXT_ATTR11 = X_TL_EXT_ATTR11,
1315 TL_EXT_ATTR12 = X_TL_EXT_ATTR12,
1316 TL_EXT_ATTR13 = X_TL_EXT_ATTR13,
1317 TL_EXT_ATTR14 = X_TL_EXT_ATTR14,
1318 TL_EXT_ATTR15 = X_TL_EXT_ATTR15,
1319 TL_EXT_ATTR16 = X_TL_EXT_ATTR16,
1320 TL_EXT_ATTR17 = X_TL_EXT_ATTR17,
1321 TL_EXT_ATTR18 = X_TL_EXT_ATTR18,
1322 TL_EXT_ATTR19 = X_TL_EXT_ATTR19,
1323 TL_EXT_ATTR20 = X_TL_EXT_ATTR20,
1324 TL_EXT_ATTR21 = X_TL_EXT_ATTR21,
1325 TL_EXT_ATTR22 = X_TL_EXT_ATTR22,
1326 TL_EXT_ATTR23 = X_TL_EXT_ATTR23,
1327 TL_EXT_ATTR24 = X_TL_EXT_ATTR24,
1328 TL_EXT_ATTR25 = X_TL_EXT_ATTR25,
1329 TL_EXT_ATTR26 = X_TL_EXT_ATTR26,
1330 TL_EXT_ATTR27 = X_TL_EXT_ATTR27,
1331 TL_EXT_ATTR28 = X_TL_EXT_ATTR28,
1332 TL_EXT_ATTR29 = X_TL_EXT_ATTR29,
1333 TL_EXT_ATTR30 = X_TL_EXT_ATTR30,
1334 TL_EXT_ATTR31 = X_TL_EXT_ATTR31,
1335 TL_EXT_ATTR32 = X_TL_EXT_ATTR32,
1336 TL_EXT_ATTR33 = X_TL_EXT_ATTR33,
1337 TL_EXT_ATTR34 = X_TL_EXT_ATTR34,
1338 TL_EXT_ATTR35 = X_TL_EXT_ATTR35,
1339 TL_EXT_ATTR36 = X_TL_EXT_ATTR36,
1340 TL_EXT_ATTR37 = X_TL_EXT_ATTR37,
1341 TL_EXT_ATTR38 = X_TL_EXT_ATTR38,
1342 TL_EXT_ATTR39 = X_TL_EXT_ATTR39,
1343 TL_EXT_ATTR40 = X_TL_EXT_ATTR40,
1344 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1345 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1346 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1347 SOURCE_LANG = USERENV('LANG')
1348 WHERE EXTENSION_ID = X_EXTENSION_ID
1349 AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
1350
1351 IF (SQL%NOTFOUND) THEN
1352 RAISE NO_DATA_FOUND;
1353 END IF;
1354 END UPDATE_ROW;
1355
1356 PROCEDURE DELETE_ROW (
1357 X_EXTENSION_ID IN NUMBER
1358 ) IS
1359 BEGIN
1360 DELETE FROM BOM_COMPONENTS_EXT_TL
1361 WHERE EXTENSION_ID = X_EXTENSION_ID;
1362
1363 IF (SQL%NOTFOUND) THEN
1364 RAISE NO_DATA_FOUND;
1365 END IF;
1366
1367 DELETE FROM BOM_COMPONENTS_EXT_B
1368 WHERE EXTENSION_ID = X_EXTENSION_ID;
1369
1370 IF (SQL%NOTFOUND) THEN
1371 RAISE NO_DATA_FOUND;
1372 END IF;
1373 END DELETE_ROW;
1374
1375 PROCEDURE ADD_LANGUAGE
1376 IS
1377 BEGIN
1378 DELETE FROM BOM_COMPONENTS_EXT_TL T
1379 WHERE NOT EXISTS
1380 (SELECT NULL
1381 FROM BOM_COMPONENTS_EXT_B B
1382 WHERE B.EXTENSION_ID = T.EXTENSION_ID
1383 );
1384
1385 UPDATE BOM_COMPONENTS_EXT_TL T SET (
1386 TL_EXT_ATTR1,
1387 TL_EXT_ATTR2,
1388 TL_EXT_ATTR3,
1389 TL_EXT_ATTR4,
1390 TL_EXT_ATTR5,
1391 TL_EXT_ATTR6,
1392 TL_EXT_ATTR7,
1393 TL_EXT_ATTR8,
1394 TL_EXT_ATTR9,
1395 TL_EXT_ATTR10,
1396 TL_EXT_ATTR11,
1397 TL_EXT_ATTR12,
1398 TL_EXT_ATTR13,
1399 TL_EXT_ATTR14,
1400 TL_EXT_ATTR15,
1401 TL_EXT_ATTR16,
1402 TL_EXT_ATTR17,
1403 TL_EXT_ATTR18,
1404 TL_EXT_ATTR19,
1405 TL_EXT_ATTR20,
1406 TL_EXT_ATTR21,
1407 TL_EXT_ATTR22,
1408 TL_EXT_ATTR23,
1409 TL_EXT_ATTR24,
1410 TL_EXT_ATTR25,
1411 TL_EXT_ATTR26,
1412 TL_EXT_ATTR27,
1413 TL_EXT_ATTR28,
1414 TL_EXT_ATTR29,
1415 TL_EXT_ATTR30,
1416 TL_EXT_ATTR31,
1417 TL_EXT_ATTR32,
1418 TL_EXT_ATTR33,
1419 TL_EXT_ATTR34,
1423 TL_EXT_ATTR38,
1420 TL_EXT_ATTR35,
1421 TL_EXT_ATTR36,
1422 TL_EXT_ATTR37,
1424 TL_EXT_ATTR39,
1425 TL_EXT_ATTR40
1426 ) = (SELECT
1427 B.TL_EXT_ATTR1,
1428 B.TL_EXT_ATTR2,
1429 B.TL_EXT_ATTR3,
1430 B.TL_EXT_ATTR4,
1431 B.TL_EXT_ATTR5,
1432 B.TL_EXT_ATTR6,
1433 B.TL_EXT_ATTR7,
1434 B.TL_EXT_ATTR8,
1435 B.TL_EXT_ATTR9,
1436 B.TL_EXT_ATTR10,
1437 B.TL_EXT_ATTR11,
1438 B.TL_EXT_ATTR12,
1439 B.TL_EXT_ATTR13,
1440 B.TL_EXT_ATTR14,
1441 B.TL_EXT_ATTR15,
1442 B.TL_EXT_ATTR16,
1443 B.TL_EXT_ATTR17,
1444 B.TL_EXT_ATTR18,
1445 B.TL_EXT_ATTR19,
1446 B.TL_EXT_ATTR20,
1447 B.TL_EXT_ATTR21,
1448 B.TL_EXT_ATTR22,
1449 B.TL_EXT_ATTR23,
1450 B.TL_EXT_ATTR24,
1451 B.TL_EXT_ATTR25,
1452 B.TL_EXT_ATTR26,
1453 B.TL_EXT_ATTR27,
1454 B.TL_EXT_ATTR28,
1455 B.TL_EXT_ATTR29,
1456 B.TL_EXT_ATTR30,
1457 B.TL_EXT_ATTR31,
1458 B.TL_EXT_ATTR32,
1459 B.TL_EXT_ATTR33,
1460 B.TL_EXT_ATTR34,
1461 B.TL_EXT_ATTR35,
1462 B.TL_EXT_ATTR36,
1463 B.TL_EXT_ATTR37,
1464 B.TL_EXT_ATTR38,
1465 B.TL_EXT_ATTR39,
1466 B.TL_EXT_ATTR40
1467 FROM BOM_COMPONENTS_EXT_TL B
1468 WHERE B.EXTENSION_ID = T.EXTENSION_ID
1469 AND B.LANGUAGE = T.SOURCE_LANG)
1470 WHERE (
1471 T.EXTENSION_ID,
1472 T.LANGUAGE
1473 ) IN (SELECT
1474 SUBT.EXTENSION_ID,
1475 SUBT.LANGUAGE
1476 FROM BOM_COMPONENTS_EXT_TL SUBB, BOM_COMPONENTS_EXT_TL SUBT
1477 WHERE SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1478 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1479 AND (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1480 OR (SUBB.TL_EXT_ATTR1 IS NULL AND SUBT.TL_EXT_ATTR1 IS NOT NULL)
1481 OR (SUBB.TL_EXT_ATTR1 IS NOT NULL AND SUBT.TL_EXT_ATTR1 IS NULL)
1482 OR SUBB.TL_EXT_ATTR2 <> SUBT.TL_EXT_ATTR2
1483 OR (SUBB.TL_EXT_ATTR2 IS NULL AND SUBT.TL_EXT_ATTR2 IS NOT NULL)
1484 OR (SUBB.TL_EXT_ATTR2 IS NOT NULL AND SUBT.TL_EXT_ATTR2 IS NULL)
1485 OR SUBB.TL_EXT_ATTR3 <> SUBT.TL_EXT_ATTR3
1486 OR (SUBB.TL_EXT_ATTR3 IS NULL AND SUBT.TL_EXT_ATTR3 IS NOT NULL)
1487 OR (SUBB.TL_EXT_ATTR3 IS NOT NULL AND SUBT.TL_EXT_ATTR3 IS NULL)
1488 OR SUBB.TL_EXT_ATTR4 <> SUBT.TL_EXT_ATTR4
1489 OR (SUBB.TL_EXT_ATTR4 IS NULL AND SUBT.TL_EXT_ATTR4 IS NOT NULL)
1490 OR (SUBB.TL_EXT_ATTR4 IS NOT NULL AND SUBT.TL_EXT_ATTR4 IS NULL)
1491 OR SUBB.TL_EXT_ATTR5 <> SUBT.TL_EXT_ATTR5
1492 OR (SUBB.TL_EXT_ATTR5 IS NULL AND SUBT.TL_EXT_ATTR5 IS NOT NULL)
1493 OR (SUBB.TL_EXT_ATTR5 IS NOT NULL AND SUBT.TL_EXT_ATTR5 IS NULL)
1494 OR SUBB.TL_EXT_ATTR6 <> SUBT.TL_EXT_ATTR6
1495 OR (SUBB.TL_EXT_ATTR6 IS NULL AND SUBT.TL_EXT_ATTR6 IS NOT NULL)
1496 OR (SUBB.TL_EXT_ATTR6 IS NOT NULL AND SUBT.TL_EXT_ATTR6 IS NULL)
1497 OR SUBB.TL_EXT_ATTR7 <> SUBT.TL_EXT_ATTR7
1498 OR (SUBB.TL_EXT_ATTR7 IS NULL AND SUBT.TL_EXT_ATTR7 IS NOT NULL)
1499 OR (SUBB.TL_EXT_ATTR7 IS NOT NULL AND SUBT.TL_EXT_ATTR7 IS NULL)
1500 OR SUBB.TL_EXT_ATTR8 <> SUBT.TL_EXT_ATTR8
1501 OR (SUBB.TL_EXT_ATTR8 IS NULL AND SUBT.TL_EXT_ATTR8 IS NOT NULL)
1502 OR (SUBB.TL_EXT_ATTR8 IS NOT NULL AND SUBT.TL_EXT_ATTR8 IS NULL)
1503 OR SUBB.TL_EXT_ATTR9 <> SUBT.TL_EXT_ATTR9
1504 OR (SUBB.TL_EXT_ATTR9 IS NULL AND SUBT.TL_EXT_ATTR9 IS NOT NULL)
1505 OR (SUBB.TL_EXT_ATTR9 IS NOT NULL AND SUBT.TL_EXT_ATTR9 IS NULL)
1506 OR SUBB.TL_EXT_ATTR10 <> SUBT.TL_EXT_ATTR10
1507 OR (SUBB.TL_EXT_ATTR10 IS NULL AND SUBT.TL_EXT_ATTR10 IS NOT NULL)
1508 OR (SUBB.TL_EXT_ATTR10 IS NOT NULL AND SUBT.TL_EXT_ATTR10 IS NULL)
1509 OR SUBB.TL_EXT_ATTR11 <> SUBT.TL_EXT_ATTR11
1510 OR (SUBB.TL_EXT_ATTR11 IS NULL AND SUBT.TL_EXT_ATTR11 IS NOT NULL)
1511 OR (SUBB.TL_EXT_ATTR11 IS NOT NULL AND SUBT.TL_EXT_ATTR11 IS NULL)
1512 OR SUBB.TL_EXT_ATTR12 <> SUBT.TL_EXT_ATTR12
1513 OR (SUBB.TL_EXT_ATTR12 IS NULL AND SUBT.TL_EXT_ATTR12 IS NOT NULL)
1514 OR (SUBB.TL_EXT_ATTR12 IS NOT NULL AND SUBT.TL_EXT_ATTR12 IS NULL)
1515 OR SUBB.TL_EXT_ATTR13 <> SUBT.TL_EXT_ATTR13
1516 OR (SUBB.TL_EXT_ATTR13 IS NULL AND SUBT.TL_EXT_ATTR13 IS NOT NULL)
1517 OR (SUBB.TL_EXT_ATTR13 IS NOT NULL AND SUBT.TL_EXT_ATTR13 IS NULL)
1518 OR SUBB.TL_EXT_ATTR14 <> SUBT.TL_EXT_ATTR14
1519 OR (SUBB.TL_EXT_ATTR14 IS NULL AND SUBT.TL_EXT_ATTR14 IS NOT NULL)
1520 OR (SUBB.TL_EXT_ATTR14 IS NOT NULL AND SUBT.TL_EXT_ATTR14 IS NULL)
1521 OR SUBB.TL_EXT_ATTR15 <> SUBT.TL_EXT_ATTR15
1522 OR (SUBB.TL_EXT_ATTR15 IS NULL AND SUBT.TL_EXT_ATTR15 IS NOT NULL)
1523 OR (SUBB.TL_EXT_ATTR15 IS NOT NULL AND SUBT.TL_EXT_ATTR15 IS NULL)
1524 OR SUBB.TL_EXT_ATTR16 <> SUBT.TL_EXT_ATTR16
1525 OR (SUBB.TL_EXT_ATTR16 IS NULL AND SUBT.TL_EXT_ATTR16 IS NOT NULL)
1526 OR (SUBB.TL_EXT_ATTR16 IS NOT NULL AND SUBT.TL_EXT_ATTR16 IS NULL)
1527 OR SUBB.TL_EXT_ATTR17 <> SUBT.TL_EXT_ATTR17
1528 OR (SUBB.TL_EXT_ATTR17 IS NULL AND SUBT.TL_EXT_ATTR17 IS NOT NULL)
1529 OR (SUBB.TL_EXT_ATTR17 IS NOT NULL AND SUBT.TL_EXT_ATTR17 IS NULL)
1530 OR SUBB.TL_EXT_ATTR18 <> SUBT.TL_EXT_ATTR18
1531 OR (SUBB.TL_EXT_ATTR18 IS NULL AND SUBT.TL_EXT_ATTR18 IS NOT NULL)
1532 OR (SUBB.TL_EXT_ATTR18 IS NOT NULL AND SUBT.TL_EXT_ATTR18 IS NULL)
1533 OR SUBB.TL_EXT_ATTR19 <> SUBT.TL_EXT_ATTR19
1534 OR (SUBB.TL_EXT_ATTR19 IS NULL AND SUBT.TL_EXT_ATTR19 IS NOT NULL)
1535 OR (SUBB.TL_EXT_ATTR19 IS NOT NULL AND SUBT.TL_EXT_ATTR19 IS NULL)
1536 OR SUBB.TL_EXT_ATTR20 <> SUBT.TL_EXT_ATTR20
1537 OR (SUBB.TL_EXT_ATTR20 IS NULL AND SUBT.TL_EXT_ATTR20 IS NOT NULL)
1538 OR (SUBB.TL_EXT_ATTR20 IS NOT NULL AND SUBT.TL_EXT_ATTR20 IS NULL)
1539 OR SUBB.TL_EXT_ATTR21 <> SUBT.TL_EXT_ATTR21
1540 OR (SUBB.TL_EXT_ATTR21 IS NULL AND SUBT.TL_EXT_ATTR21 IS NOT NULL)
1544 OR (SUBB.TL_EXT_ATTR22 IS NOT NULL AND SUBT.TL_EXT_ATTR22 IS NULL)
1541 OR (SUBB.TL_EXT_ATTR21 IS NOT NULL AND SUBT.TL_EXT_ATTR21 IS NULL)
1542 OR SUBB.TL_EXT_ATTR22 <> SUBT.TL_EXT_ATTR22
1543 OR (SUBB.TL_EXT_ATTR22 IS NULL AND SUBT.TL_EXT_ATTR22 IS NOT NULL)
1545 OR SUBB.TL_EXT_ATTR23 <> SUBT.TL_EXT_ATTR23
1546 OR (SUBB.TL_EXT_ATTR23 IS NULL AND SUBT.TL_EXT_ATTR23 IS NOT NULL)
1547 OR (SUBB.TL_EXT_ATTR23 IS NOT NULL AND SUBT.TL_EXT_ATTR23 IS NULL)
1548 OR SUBB.TL_EXT_ATTR24 <> SUBT.TL_EXT_ATTR24
1549 OR (SUBB.TL_EXT_ATTR24 IS NULL AND SUBT.TL_EXT_ATTR24 IS NOT NULL)
1550 OR (SUBB.TL_EXT_ATTR24 IS NOT NULL AND SUBT.TL_EXT_ATTR24 IS NULL)
1551 OR SUBB.TL_EXT_ATTR25 <> SUBT.TL_EXT_ATTR25
1552 OR (SUBB.TL_EXT_ATTR25 IS NULL AND SUBT.TL_EXT_ATTR25 IS NOT NULL)
1553 OR (SUBB.TL_EXT_ATTR25 IS NOT NULL AND SUBT.TL_EXT_ATTR25 IS NULL)
1554 OR SUBB.TL_EXT_ATTR26 <> SUBT.TL_EXT_ATTR26
1555 OR (SUBB.TL_EXT_ATTR26 IS NULL AND SUBT.TL_EXT_ATTR26 IS NOT NULL)
1556 OR (SUBB.TL_EXT_ATTR26 IS NOT NULL AND SUBT.TL_EXT_ATTR26 IS NULL)
1557 OR SUBB.TL_EXT_ATTR27 <> SUBT.TL_EXT_ATTR27
1558 OR (SUBB.TL_EXT_ATTR27 IS NULL AND SUBT.TL_EXT_ATTR27 IS NOT NULL)
1559 OR (SUBB.TL_EXT_ATTR27 IS NOT NULL AND SUBT.TL_EXT_ATTR27 IS NULL)
1560 OR SUBB.TL_EXT_ATTR28 <> SUBT.TL_EXT_ATTR28
1561 OR (SUBB.TL_EXT_ATTR28 IS NULL AND SUBT.TL_EXT_ATTR28 IS NOT NULL)
1562 OR (SUBB.TL_EXT_ATTR28 IS NOT NULL AND SUBT.TL_EXT_ATTR28 IS NULL)
1563 OR SUBB.TL_EXT_ATTR29 <> SUBT.TL_EXT_ATTR29
1564 OR (SUBB.TL_EXT_ATTR29 IS NULL AND SUBT.TL_EXT_ATTR29 IS NOT NULL)
1565 OR (SUBB.TL_EXT_ATTR29 IS NOT NULL AND SUBT.TL_EXT_ATTR29 IS NULL)
1566 OR SUBB.TL_EXT_ATTR30 <> SUBT.TL_EXT_ATTR30
1567 OR (SUBB.TL_EXT_ATTR30 IS NULL AND SUBT.TL_EXT_ATTR30 IS NOT NULL)
1568 OR (SUBB.TL_EXT_ATTR30 IS NOT NULL AND SUBT.TL_EXT_ATTR30 IS NULL)
1569 OR SUBB.TL_EXT_ATTR31 <> SUBT.TL_EXT_ATTR31
1570 OR (SUBB.TL_EXT_ATTR31 IS NULL AND SUBT.TL_EXT_ATTR31 IS NOT NULL)
1571 OR (SUBB.TL_EXT_ATTR31 IS NOT NULL AND SUBT.TL_EXT_ATTR31 IS NULL)
1572 OR SUBB.TL_EXT_ATTR32 <> SUBT.TL_EXT_ATTR32
1573 OR (SUBB.TL_EXT_ATTR32 IS NULL AND SUBT.TL_EXT_ATTR32 IS NOT NULL)
1574 OR (SUBB.TL_EXT_ATTR32 IS NOT NULL AND SUBT.TL_EXT_ATTR32 IS NULL)
1575 OR SUBB.TL_EXT_ATTR33 <> SUBT.TL_EXT_ATTR33
1576 OR (SUBB.TL_EXT_ATTR33 IS NULL AND SUBT.TL_EXT_ATTR33 IS NOT NULL)
1577 OR (SUBB.TL_EXT_ATTR33 IS NOT NULL AND SUBT.TL_EXT_ATTR33 IS NULL)
1578 OR SUBB.TL_EXT_ATTR34 <> SUBT.TL_EXT_ATTR34
1579 OR (SUBB.TL_EXT_ATTR34 IS NULL AND SUBT.TL_EXT_ATTR34 IS NOT NULL)
1580 OR (SUBB.TL_EXT_ATTR34 IS NOT NULL AND SUBT.TL_EXT_ATTR34 IS NULL)
1581 OR SUBB.TL_EXT_ATTR35 <> SUBT.TL_EXT_ATTR35
1582 OR (SUBB.TL_EXT_ATTR35 IS NULL AND SUBT.TL_EXT_ATTR35 IS NOT NULL)
1583 OR (SUBB.TL_EXT_ATTR35 IS NOT NULL AND SUBT.TL_EXT_ATTR35 IS NULL)
1584 OR SUBB.TL_EXT_ATTR36 <> SUBT.TL_EXT_ATTR36
1585 OR (SUBB.TL_EXT_ATTR36 IS NULL AND SUBT.TL_EXT_ATTR36 IS NOT NULL)
1586 OR (SUBB.TL_EXT_ATTR36 IS NOT NULL AND SUBT.TL_EXT_ATTR36 IS NULL)
1587 OR SUBB.TL_EXT_ATTR37 <> SUBT.TL_EXT_ATTR37
1588 OR (SUBB.TL_EXT_ATTR37 IS NULL AND SUBT.TL_EXT_ATTR37 IS NOT NULL)
1589 OR (SUBB.TL_EXT_ATTR37 IS NOT NULL AND SUBT.TL_EXT_ATTR37 IS NULL)
1590 OR SUBB.TL_EXT_ATTR38 <> SUBT.TL_EXT_ATTR38
1591 OR (SUBB.TL_EXT_ATTR38 IS NULL AND SUBT.TL_EXT_ATTR38 IS NOT NULL)
1592 OR (SUBB.TL_EXT_ATTR38 IS NOT NULL AND SUBT.TL_EXT_ATTR38 IS NULL)
1593 OR SUBB.TL_EXT_ATTR39 <> SUBT.TL_EXT_ATTR39
1594 OR (SUBB.TL_EXT_ATTR39 IS NULL AND SUBT.TL_EXT_ATTR39 IS NOT NULL)
1595 OR (SUBB.TL_EXT_ATTR39 IS NOT NULL AND SUBT.TL_EXT_ATTR39 IS NULL)
1596 OR SUBB.TL_EXT_ATTR40 <> SUBT.TL_EXT_ATTR40
1597 OR (SUBB.TL_EXT_ATTR40 IS NULL AND SUBT.TL_EXT_ATTR40 IS NOT NULL)
1598 OR (SUBB.TL_EXT_ATTR40 IS NOT NULL AND SUBT.TL_EXT_ATTR40 IS NULL)
1599 ));
1600
1601 INSERT INTO BOM_COMPONENTS_EXT_TL (
1602 EXTENSION_ID,
1603 COMPONENT_SEQUENCE_ID,
1604 STRUCTURE_TYPE_ID,
1605 ATTR_GROUP_ID,
1606 LAST_UPDATE_DATE,
1607 LAST_UPDATED_BY,
1608 LAST_UPDATE_LOGIN,
1609 CREATED_BY,
1610 CREATION_DATE,
1611 TL_EXT_ATTR1,
1612 TL_EXT_ATTR2,
1613 TL_EXT_ATTR3,
1614 TL_EXT_ATTR4,
1615 TL_EXT_ATTR5,
1616 TL_EXT_ATTR6,
1617 TL_EXT_ATTR7,
1618 TL_EXT_ATTR8,
1619 TL_EXT_ATTR9,
1620 TL_EXT_ATTR10,
1621 TL_EXT_ATTR11,
1622 TL_EXT_ATTR12,
1623 TL_EXT_ATTR13,
1624 TL_EXT_ATTR14,
1625 TL_EXT_ATTR15,
1626 TL_EXT_ATTR16,
1627 TL_EXT_ATTR17,
1628 TL_EXT_ATTR18,
1629 TL_EXT_ATTR19,
1630 TL_EXT_ATTR20,
1631 TL_EXT_ATTR21,
1632 TL_EXT_ATTR22,
1633 TL_EXT_ATTR23,
1634 TL_EXT_ATTR24,
1635 TL_EXT_ATTR25,
1636 TL_EXT_ATTR26,
1637 TL_EXT_ATTR27,
1638 TL_EXT_ATTR28,
1639 TL_EXT_ATTR29,
1640 TL_EXT_ATTR30,
1641 TL_EXT_ATTR31,
1642 TL_EXT_ATTR32,
1643 TL_EXT_ATTR33,
1644 TL_EXT_ATTR34,
1645 TL_EXT_ATTR35,
1646 TL_EXT_ATTR36,
1647 TL_EXT_ATTR37,
1648 TL_EXT_ATTR38,
1649 TL_EXT_ATTR39,
1650 TL_EXT_ATTR40,
1651 BILL_SEQUENCE_ID,
1652 LANGUAGE,
1653 SOURCE_LANG
1654 ) SELECT /*+ ORDERED */
1655 B.EXTENSION_ID,
1656 B.COMPONENT_SEQUENCE_ID,
1657 B.STRUCTURE_TYPE_ID,
1658 B.ATTR_GROUP_ID,
1659 B.LAST_UPDATE_DATE,
1660 B.LAST_UPDATED_BY,
1661 B.LAST_UPDATE_LOGIN,
1662 B.CREATED_BY,
1663 B.CREATION_DATE,
1664 B.TL_EXT_ATTR1,
1665 B.TL_EXT_ATTR2,
1666 B.TL_EXT_ATTR3,
1667 B.TL_EXT_ATTR4,
1668 B.TL_EXT_ATTR5,
1669 B.TL_EXT_ATTR6,
1670 B.TL_EXT_ATTR7,
1671 B.TL_EXT_ATTR8,
1672 B.TL_EXT_ATTR9,
1673 B.TL_EXT_ATTR10,
1677 B.TL_EXT_ATTR14,
1674 B.TL_EXT_ATTR11,
1675 B.TL_EXT_ATTR12,
1676 B.TL_EXT_ATTR13,
1678 B.TL_EXT_ATTR15,
1679 B.TL_EXT_ATTR16,
1680 B.TL_EXT_ATTR17,
1681 B.TL_EXT_ATTR18,
1682 B.TL_EXT_ATTR19,
1683 B.TL_EXT_ATTR20,
1684 B.TL_EXT_ATTR21,
1685 B.TL_EXT_ATTR22,
1686 B.TL_EXT_ATTR23,
1687 B.TL_EXT_ATTR24,
1688 B.TL_EXT_ATTR25,
1689 B.TL_EXT_ATTR26,
1690 B.TL_EXT_ATTR27,
1691 B.TL_EXT_ATTR28,
1692 B.TL_EXT_ATTR29,
1693 B.TL_EXT_ATTR30,
1694 B.TL_EXT_ATTR31,
1695 B.TL_EXT_ATTR32,
1696 B.TL_EXT_ATTR33,
1697 B.TL_EXT_ATTR34,
1698 B.TL_EXT_ATTR35,
1699 B.TL_EXT_ATTR36,
1700 B.TL_EXT_ATTR37,
1701 B.TL_EXT_ATTR38,
1702 B.TL_EXT_ATTR39,
1703 B.TL_EXT_ATTR40,
1704 B.BILL_SEQUENCE_ID,
1705 L.LANGUAGE_CODE,
1706 B.SOURCE_LANG
1707 FROM BOM_COMPONENTS_EXT_TL B, FND_LANGUAGES L
1708 WHERE L.INSTALLED_FLAG IN ('I', 'B')
1709 AND B.LANGUAGE = USERENV('LANG')
1710 AND NOT EXISTS
1711 (SELECT NULL
1712 FROM BOM_COMPONENTS_EXT_TL T
1713 WHERE T.EXTENSION_ID = B.EXTENSION_ID
1714 AND T.LANGUAGE = L.LANGUAGE_CODE);
1715 END ADD_LANGUAGE;
1716
1717 END BOM_COMPONENTS_EXT_PKG;
[Home] [Help]