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