[Home] [Help]
PACKAGE BODY: APPS.OE_LINE_ATTRIBUTES
Source
1 PACKAGE BODY oe_line_attributes AS
2 /* $Header: OEXLATTB.pls 115.2 99/07/16 08:13:05 porting shi $ */
3
4 /*
5 ** set_so_line_attributes is called from OrderImport to manipulate so_line_attributes
6 ** given the records in so_line_attributes_interface.
7 ** For op_code = INSERT/UPDATE, we only do UPDATE the records since
8 ** insertion is already done in oeoord()
9 ** For op_code = DELETE, we don't do any deletion since the complementing record in
10 ** so_line_attributes is deleted from oeoord()
11 */
12
13 PROCEDURE set_so_line_attributes
14 (in_line_id IN NUMBER,
15 in_op_code IN VARCHAR2,
16 in_ord_source IN VARCHAR2,
17 in_orig_sys_ref IN VARCHAR2,
18 in_orig_sys_l_ref IN VARCHAR2,
19 in_req_id IN NUMBER,
20 out_result OUT NUMBER )
21 IS
22
23
24 l_date DATE;
25 l_updated_by NUMBER;
26 l_login_id NUMBER;
27 l_program_application_id NUMBER;
28 l_program_id NUMBER;
29 l_request_id NUMBER;
30 l_industry_context VARCHAR2(30);
31 l_industry_attribute1 VARCHAR2(150);
32 l_industry_attribute2 VARCHAR2(150);
33 l_industry_attribute3 VARCHAR2(150);
34 l_industry_attribute4 VARCHAR2(150);
35 l_industry_attribute5 VARCHAR2(150);
36 l_industry_attribute6 VARCHAR2(150);
37 l_industry_attribute7 VARCHAR2(150);
38 l_industry_attribute8 VARCHAR2(150);
39 l_industry_attribute9 VARCHAR2(150);
40 l_industry_attribute10 VARCHAR2(150);
41 l_industry_attribute11 VARCHAR2(150);
42 l_industry_attribute12 VARCHAR2(150);
43 l_industry_attribute13 VARCHAR2(150);
44 l_industry_attribute14 VARCHAR2(150);
45 l_industry_attribute15 VARCHAR2(150);
46 l_global_attribute_category VARCHAR2(30);
47 l_global_attribute1 VARCHAR2(150);
48 l_global_attribute2 VARCHAR2(150);
49 l_global_attribute3 VARCHAR2(150);
50 l_global_attribute4 VARCHAR2(150);
51 l_global_attribute5 VARCHAR2(150);
52 l_global_attribute6 VARCHAR2(150);
53 l_global_attribute7 VARCHAR2(150);
54 l_global_attribute8 VARCHAR2(150);
55 l_global_attribute9 VARCHAR2(150);
56 l_global_attribute10 VARCHAR2(150);
57 l_global_attribute11 VARCHAR2(150);
58 l_global_attribute12 VARCHAR2(150);
59 l_global_attribute13 VARCHAR2(150);
60 l_global_attribute14 VARCHAR2(150);
61 l_global_attribute15 VARCHAR2(150);
62 l_global_attribute16 VARCHAR2(150);
63 l_global_attribute17 VARCHAR2(150);
64 l_global_attribute18 VARCHAR2(150);
65 l_global_attribute19 VARCHAR2(150);
66 l_global_attribute20 VARCHAR2(150);
67
68 BEGIN
69
70
71 /* standard WHO */
72 l_date := SYSDATE;
73 l_updated_by := FND_GLOBAL.USER_ID;
74 l_login_id := FND_GLOBAL.LOGIN_ID;
75
76 /* standard concurrent program info */
77 l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
78 l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
79 l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
80
81
82 IF ((in_op_code = 'INSERT') OR (in_op_code = 'UPDATE')) THEN
83
84 SELECT
85 industry_context,
86 industry_attribute1,
87 industry_attribute2,
88 industry_attribute3,
89 industry_attribute4,
90 industry_attribute5,
91 industry_attribute6,
92 industry_attribute7,
93 industry_attribute8,
94 industry_attribute9,
95 industry_attribute10,
96 industry_attribute11,
97 industry_attribute12,
98 industry_attribute13,
99 industry_attribute14,
100 industry_attribute15,
101 global_attribute_category,
102 global_attribute1,
103 global_attribute2,
104 global_attribute3,
105 global_attribute4,
106 global_attribute5,
107 global_attribute6,
108 global_attribute7,
109 global_attribute8,
110 global_attribute9,
111 global_attribute10,
112 global_attribute11,
113 global_attribute12,
114 global_attribute13,
115 global_attribute14,
116 global_attribute15,
117 global_attribute16,
118 global_attribute17,
119 global_attribute18,
120 global_attribute19,
121 global_attribute20
122 INTO
123 l_industry_context,
124 l_industry_attribute1,
125 l_industry_attribute2,
126 l_industry_attribute3,
127 l_industry_attribute4,
128 l_industry_attribute5,
129 l_industry_attribute6,
130 l_industry_attribute7,
131 l_industry_attribute8,
132 l_industry_attribute9,
133 l_industry_attribute10,
134 l_industry_attribute11,
135 l_industry_attribute12,
136 l_industry_attribute13,
137 l_industry_attribute14,
138 l_industry_attribute15,
139 l_global_attribute_category,
140 l_global_attribute1,
141 l_global_attribute2,
142 l_global_attribute3,
143 l_global_attribute4,
144 l_global_attribute5,
145 l_global_attribute6,
146 l_global_attribute7,
147 l_global_attribute8,
148 l_global_attribute9,
149 l_global_attribute10,
150 l_global_attribute11,
151 l_global_attribute12,
152 l_global_attribute13,
153 l_global_attribute14,
154 l_global_attribute15,
155 l_global_attribute16,
156 l_global_attribute17,
157 l_global_attribute18,
158 l_global_attribute19,
159 l_global_attribute20
160
161 FROM so_line_attributes_interface
162 WHERE order_source_id = in_ord_source
163 AND original_system_reference = in_orig_sys_ref
164 AND original_system_line_reference = in_orig_sys_l_ref
165 AND Nvl(error_flag,'N') <> 'Y';
166
167
168 UPDATE so_line_attributes
169 SET
170 last_update_date = sysdate,
171 last_updated_by = l_updated_by,
172 last_update_login = l_login_id,
173 program_application_id = l_program_application_id,
174 program_id = l_program_id,
175 program_update_date = l_date,
176 request_id = l_request_id,
177 industry_context = l_industry_context,
178 industry_attribute1 = l_industry_attribute1,
179 industry_attribute2 = l_industry_attribute2,
180 industry_attribute3 = l_industry_attribute3,
181 industry_attribute4 = l_industry_attribute4,
182 industry_attribute5 = l_industry_attribute5,
183 industry_attribute6 = l_industry_attribute6,
184 industry_attribute7 = l_industry_attribute7,
185 industry_attribute8 = l_industry_attribute8,
186 industry_attribute9 = l_industry_attribute9,
187 industry_attribute10 = l_industry_attribute10,
188 industry_attribute11 = l_industry_attribute11,
189 industry_attribute12 = l_industry_attribute12,
190 industry_attribute13 = l_industry_attribute13,
191 industry_attribute14 = l_industry_attribute14,
192 industry_attribute15 = l_industry_attribute15,
193 global_attribute_category = l_global_attribute_category,
194 global_attribute1 = l_global_attribute1,
195 global_attribute2 = l_global_attribute2,
196 global_attribute3 = l_global_attribute3,
197 global_attribute4 = l_global_attribute4,
198 global_attribute5 = l_global_attribute5,
199 global_attribute6 = l_global_attribute6,
200 global_attribute7 = l_global_attribute7,
201 global_attribute8 = l_global_attribute8,
202 global_attribute9 = l_global_attribute9,
203 global_attribute10 = l_global_attribute10,
204 global_attribute11 = l_global_attribute11,
205 global_attribute12 = l_global_attribute12,
206 global_attribute13 = l_global_attribute13,
207 global_attribute14 = l_global_attribute14,
208 global_attribute15 = l_global_attribute15,
209 global_attribute16 = l_global_attribute16,
210 global_attribute17 = l_global_attribute17,
211 global_attribute18 = l_global_attribute18,
212 global_attribute19 = l_global_attribute19,
213 global_attribute20 = l_global_attribute20
214 WHERE line_id = in_line_id;
215
216 /* we don't do anything for DELETE */
217
218 END IF;
219
220
221 out_result := 1;
222
223 EXCEPTION
224 WHEN NO_DATA_FOUND THEN
225 out_result := 1;
226
227 END set_so_line_attributes;
228
229
230 /*
231 ** set_industry_attributes is called from oeoord.lpc
232 ** to insert(delete) a complementing null record into so_line_attributes
233 ** whenever a line is inserted(deleted) into so_lines.
234 ** Also called from Order User Exit to update records when in GUI mode,
235 ** or to insert/delete records when in Character mode.
236 */
237
238 PROCEDURE set_industry_attributes
239 (in_op_code IN VARCHAR2,
240 in_line_id IN NUMBER,
241 in_industry_context IN VARCHAR2 DEFAULT NULL,
242 in_industry_attribute1 IN VARCHAR2 DEFAULT NULL,
243 in_industry_attribute2 IN VARCHAR2 DEFAULT NULL,
244 in_industry_attribute3 IN VARCHAR2 DEFAULT NULL,
245 in_industry_attribute4 IN VARCHAR2 DEFAULT NULL,
246 in_industry_attribute5 IN VARCHAR2 DEFAULT NULL,
247 in_industry_attribute6 IN VARCHAR2 DEFAULT NULL,
248 in_industry_attribute7 IN VARCHAR2 DEFAULT NULL,
249 in_industry_attribute8 IN VARCHAR2 DEFAULT NULL,
250 in_industry_attribute9 IN VARCHAR2 DEFAULT NULL,
251 in_industry_attribute10 IN VARCHAR2 DEFAULT NULL,
252 in_industry_attribute11 IN VARCHAR2 DEFAULT NULL,
253 in_industry_attribute12 IN VARCHAR2 DEFAULT NULL,
254 in_industry_attribute13 IN VARCHAR2 DEFAULT NULL,
255 in_industry_attribute14 IN VARCHAR2 DEFAULT NULL,
256 in_industry_attribute15 IN VARCHAR2 DEFAULT NULL,
257 in_global_attribute_category IN VARCHAR2 DEFAULT NULL,
258 in_global_attribute1 IN VARCHAR2 DEFAULT NULL,
259 in_global_attribute2 IN VARCHAR2 DEFAULT NULL,
260 in_global_attribute3 IN VARCHAR2 DEFAULT NULL,
261 in_global_attribute4 IN VARCHAR2 DEFAULT NULL,
262 in_global_attribute5 IN VARCHAR2 DEFAULT NULL,
263 in_global_attribute6 IN VARCHAR2 DEFAULT NULL,
264 in_global_attribute7 IN VARCHAR2 DEFAULT NULL,
265 in_global_attribute8 IN VARCHAR2 DEFAULT NULL,
266 in_global_attribute9 IN VARCHAR2 DEFAULT NULL,
267 in_global_attribute10 IN VARCHAR2 DEFAULT NULL,
268 in_global_attribute11 IN VARCHAR2 DEFAULT NULL,
269 in_global_attribute12 IN VARCHAR2 DEFAULT NULL,
270 in_global_attribute13 IN VARCHAR2 DEFAULT NULL,
271 in_global_attribute14 IN VARCHAR2 DEFAULT NULL,
272 in_global_attribute15 IN VARCHAR2 DEFAULT NULL,
273 in_global_attribute16 IN VARCHAR2 DEFAULT NULL,
274 in_global_attribute17 IN VARCHAR2 DEFAULT NULL,
275 in_global_attribute18 IN VARCHAR2 DEFAULT NULL,
276 in_global_attribute19 IN VARCHAR2 DEFAULT NULL,
277 in_global_attribute20 IN VARCHAR2 DEFAULT NULL)
278
279 IS
280
281 l_date DATE;
282 l_user_id NUMBER;
283 l_login_id NUMBER;
284
285 l_request_id NUMBER;
286 l_prog_application_id NUMBER;
287 l_program_id NUMBER;
288
289 BEGIN
290
291 /* standard WHO */
292 l_date := SYSDATE;
293 l_user_id := FND_GLOBAL.USER_ID;
294 l_login_id := FND_GLOBAL.LOGIN_ID;
295
296 /* standard concurrent program info */
297 l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
298 l_prog_application_id := FND_GLOBAL.PROG_APPL_ID;
299 l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
300
301 IF (in_op_code = 'INSERT') THEN
302
303 INSERT INTO so_line_attributes
304 (line_id,
305 creation_date,
306 created_by,
307 last_update_date,
308 last_updated_by,
309 last_update_login,
310 program_application_id,
311 program_id,
312 program_update_date,
313 request_id,
314 industry_context,
315 industry_attribute1,
316 industry_attribute2,
317 industry_attribute3,
318 industry_attribute4,
319 industry_attribute5,
320 industry_attribute6,
321 industry_attribute7,
322 industry_attribute8,
323 industry_attribute9,
324 industry_attribute10,
325 industry_attribute11,
326 industry_attribute12,
327 industry_attribute13,
328 industry_attribute14,
329 industry_attribute15,
330 global_attribute_category,
331 global_attribute1,
332 global_attribute2,
333 global_attribute3,
334 global_attribute4,
335 global_attribute5,
336 global_attribute6,
337 global_attribute7,
338 global_attribute8,
339 global_attribute9,
340 global_attribute10,
341 global_attribute11,
342 global_attribute12,
343 global_attribute13,
344 global_attribute14,
345 global_attribute15,
346 global_attribute16,
347 global_attribute17,
348 global_attribute18,
349 global_attribute19,
350 global_attribute20)
351
352 VALUES
353 (in_line_id,
354 l_date,
355 l_user_id,
356 l_date,
357 l_user_id,
358 l_login_id,
359 l_prog_application_id,
360 l_program_id,
361 l_date,
362 l_request_id,
363 in_industry_context,
364 in_industry_attribute1,
365 in_industry_attribute2,
366 in_industry_attribute3,
367 in_industry_attribute4,
368 in_industry_attribute5,
369 in_industry_attribute6,
370 in_industry_attribute7,
371 in_industry_attribute8,
372 in_industry_attribute9,
373 in_industry_attribute10,
374 in_industry_attribute11,
375 in_industry_attribute12,
376 in_industry_attribute13,
377 in_industry_attribute14,
378 in_industry_attribute15,
379 in_global_attribute_category,
380 in_global_attribute1,
381 in_global_attribute2,
382 in_global_attribute3,
383 in_global_attribute4,
384 in_global_attribute5,
385 in_global_attribute6,
386 in_global_attribute7,
387 in_global_attribute8,
388 in_global_attribute9,
389 in_global_attribute10,
390 in_global_attribute11,
391 in_global_attribute12,
392 in_global_attribute13,
393 in_global_attribute14,
394 in_global_attribute15,
395 in_global_attribute16,
396 in_global_attribute17,
397 in_global_attribute18,
398 in_global_attribute19,
399 in_global_attribute20);
400
401 ELSIF (in_op_code = 'UPDATE') THEN
402
403 BEGIN
404
405 UPDATE so_line_attributes
406 SET
407 last_update_date = l_date,
408 last_updated_by = l_user_id,
409 last_update_login = l_login_id,
410 program_application_id = l_prog_application_id,
411 program_id = l_program_id,
412 program_update_date = l_date,
413 request_id = l_request_id,
414 industry_context = in_industry_context,
415 industry_attribute1 = in_industry_attribute1,
416 industry_attribute2 = in_industry_attribute2,
417 industry_attribute3 = in_industry_attribute3,
418 industry_attribute4 = in_industry_attribute4,
419 industry_attribute5 = in_industry_attribute5,
420 industry_attribute6 = in_industry_attribute6,
421 industry_attribute7 = in_industry_attribute7,
422 industry_attribute8 = in_industry_attribute9,
423 industry_attribute9 = in_industry_attribute9,
424 industry_attribute10 = in_industry_attribute10,
425 industry_attribute11 = in_industry_attribute11,
426 industry_attribute12 = in_industry_attribute12,
427 industry_attribute13 = in_industry_attribute13,
428 industry_attribute14 = in_industry_attribute14,
429 industry_attribute15 = in_industry_attribute15,
430 global_attribute_category = in_global_attribute_category,
431 global_attribute1 = in_global_attribute1,
432 global_attribute2 = in_global_attribute2,
433 global_attribute3 = in_global_attribute3,
434 global_attribute4 = in_global_attribute4,
435 global_attribute5 = in_global_attribute5,
436 global_attribute6 = in_global_attribute6,
437 global_attribute7 = in_global_attribute7,
438 global_attribute8 = in_global_attribute8,
439 global_attribute9 = in_global_attribute9,
440 global_attribute10 = in_global_attribute10,
441 global_attribute11 = in_global_attribute11,
442 global_attribute12 = in_global_attribute12,
443 global_attribute13 = in_global_attribute13,
444 global_attribute14 = in_global_attribute14,
445 global_attribute15 = in_global_attribute15,
446 global_attribute16 = in_global_attribute16,
447 global_attribute17 = in_global_attribute17,
448 global_attribute18 = in_global_attribute18,
449 global_attribute19 = in_global_attribute19,
450 global_attribute20 = in_global_attribute20
451 WHERE line_id = in_line_id;
452
453 /* existing order lines that were inserted PRE-ReleaseAccountingInstallation
454 would have no complementing records in so_line_attributes.
455 In this case, we should insert a new record with the new information */
456
457 IF SQL%NOTFOUND THEN -- update failed
458
459 INSERT INTO so_line_attributes
460 (line_id,
461 creation_date,
462 created_by,
463 last_update_date,
464 last_updated_by,
465 last_update_login,
466 program_application_id,
467 program_id,
468 program_update_date,
469 request_id,
470 industry_context,
471 industry_attribute1,
472 industry_attribute2,
473 industry_attribute3,
474 industry_attribute4,
475 industry_attribute5,
476 industry_attribute6,
477 industry_attribute7,
478 industry_attribute8,
479 industry_attribute9,
480 industry_attribute10,
481 industry_attribute11,
482 industry_attribute12,
483 industry_attribute13,
484 industry_attribute14,
485 industry_attribute15,
486 global_attribute_category,
487 global_attribute1,
488 global_attribute2,
489 global_attribute3,
490 global_attribute4,
491 global_attribute5,
492 global_attribute6,
493 global_attribute7,
494 global_attribute8,
495 global_attribute9,
496 global_attribute10,
497 global_attribute11,
498 global_attribute12,
499 global_attribute13,
500 global_attribute14,
501 global_attribute15,
502 global_attribute16,
503 global_attribute17,
504 global_attribute18,
505 global_attribute19,
506 global_attribute20)
507
508 VALUES
509 (in_line_id,
510 l_date,
511 l_user_id,
512 l_date,
513 l_user_id,
514 l_login_id,
515 l_prog_application_id,
516 l_program_id,
517 l_date,
518 l_request_id,
519 in_industry_context,
520 in_industry_attribute1,
521 in_industry_attribute2,
522 in_industry_attribute3,
523 in_industry_attribute4,
524 in_industry_attribute5,
525 in_industry_attribute6,
526 in_industry_attribute7,
527 in_industry_attribute8,
528 in_industry_attribute9,
529 in_industry_attribute10,
530 in_industry_attribute11,
531 in_industry_attribute12,
532 in_industry_attribute13,
533 in_industry_attribute14,
534 in_industry_attribute15,
535 in_global_attribute_category,
536 in_global_attribute1,
537 in_global_attribute2,
538 in_global_attribute3,
539 in_global_attribute4,
540 in_global_attribute5,
541 in_global_attribute6,
542 in_global_attribute7,
543 in_global_attribute8,
544 in_global_attribute9,
545 in_global_attribute10,
546 in_global_attribute11,
547 in_global_attribute12,
548 in_global_attribute13,
549 in_global_attribute14,
550 in_global_attribute15,
551 in_global_attribute16,
552 in_global_attribute17,
553 in_global_attribute18,
554 in_global_attribute19,
555 in_global_attribute20);
556
557 END IF; /* no record exists for update */
558
559 END;
560
561 ELSIF (in_op_code = 'DELETE') THEN
562
563 DELETE
564 FROM so_line_attributes
565 WHERE line_id = in_line_id;
566
567 END if;
568
569 END set_industry_attributes;
570
571
572 /*
573 ** get_industry_attributes is called from oexobj.lpc
574 ** to get industry attributes from the database given a line_id.
575 ** This is used to resolve locking issue.
576 */
577
578 PROCEDURE get_industry_attributes
579 (in_op_code IN VARCHAR2,
580 in_line_id IN NUMBER,
581 out_industry_context OUT VARCHAR2 ,
582 out_industry_attribute1 OUT VARCHAR2 ,
583 out_industry_attribute2 OUT VARCHAR2 ,
584 out_industry_attribute3 OUT VARCHAR2 ,
585 out_industry_attribute4 OUT VARCHAR2 ,
586 out_industry_attribute5 OUT VARCHAR2 ,
587 out_industry_attribute6 OUT VARCHAR2 ,
588 out_industry_attribute7 OUT VARCHAR2 ,
589 out_industry_attribute8 OUT VARCHAR2 ,
590 out_industry_attribute9 OUT VARCHAR2 ,
591 out_industry_attribute10 OUT VARCHAR2 ,
592 out_industry_attribute11 OUT VARCHAR2 ,
593 out_industry_attribute12 OUT VARCHAR2 ,
594 out_industry_attribute13 OUT VARCHAR2 ,
595 out_industry_attribute14 OUT VARCHAR2 ,
596 out_industry_attribute15 OUT VARCHAR2,
597 out_global_attribute_category OUT VARCHAR2 ,
598 out_global_attribute1 OUT VARCHAR2 ,
599 out_global_attribute2 OUT VARCHAR2 ,
600 out_global_attribute3 OUT VARCHAR2 ,
601 out_global_attribute4 OUT VARCHAR2 ,
602 out_global_attribute5 OUT VARCHAR2 ,
603 out_global_attribute6 OUT VARCHAR2 ,
604 out_global_attribute7 OUT VARCHAR2 ,
605 out_global_attribute8 OUT VARCHAR2 ,
606 out_global_attribute9 OUT VARCHAR2 ,
607 out_global_attribute10 OUT VARCHAR2 ,
608 out_global_attribute11 OUT VARCHAR2 ,
609 out_global_attribute12 OUT VARCHAR2 ,
610 out_global_attribute13 OUT VARCHAR2 ,
611 out_global_attribute14 OUT VARCHAR2 ,
612 out_global_attribute15 OUT VARCHAR2 ,
613 out_global_attribute16 OUT VARCHAR2 ,
614 out_global_attribute17 OUT VARCHAR2 ,
615 out_global_attribute18 OUT VARCHAR2 ,
616 out_global_attribute19 OUT VARCHAR2 ,
617 out_global_attribute20 OUT VARCHAR2
618 )
619 IS
620
621 BEGIN
622 IF (in_op_code = 'SELECT') THEN
623
624 SELECT
625 industry_context,
626 industry_attribute1,
627 industry_attribute2,
628 industry_attribute3,
629 industry_attribute4,
630 industry_attribute5,
631 industry_attribute6,
632 industry_attribute7,
633 industry_attribute8,
634 industry_attribute9,
635 industry_attribute10,
636 industry_attribute11,
637 industry_attribute12,
638 industry_attribute13,
639 industry_attribute14,
640 industry_attribute15,
641 global_attribute_category,
642 global_attribute1,
643 global_attribute2,
644 global_attribute3,
645 global_attribute4,
646 global_attribute5,
647 global_attribute6,
648 global_attribute7,
649 global_attribute8,
650 global_attribute9,
651 global_attribute10,
652 global_attribute11,
653 global_attribute12,
654 global_attribute13,
655 global_attribute14,
656 global_attribute15,
657 global_attribute16,
658 global_attribute17,
659 global_attribute18,
660 global_attribute19,
661 global_attribute20
662
663 INTO
664 out_industry_context,
665 out_industry_attribute1,
666 out_industry_attribute2,
667 out_industry_attribute3,
668 out_industry_attribute4,
669 out_industry_attribute5,
670 out_industry_attribute6,
671 out_industry_attribute7,
672 out_industry_attribute8,
673 out_industry_attribute9,
674 out_industry_attribute10,
675 out_industry_attribute11,
676 out_industry_attribute12,
677 out_industry_attribute13,
678 out_industry_attribute14,
679 out_industry_attribute15,
680 out_global_attribute_category,
681 out_global_attribute1,
682 out_global_attribute2,
683 out_global_attribute3,
684 out_global_attribute4,
685 out_global_attribute5,
686 out_global_attribute6,
687 out_global_attribute7,
688 out_global_attribute8,
689 out_global_attribute9,
690 out_global_attribute10,
691 out_global_attribute11,
692 out_global_attribute12,
693 out_global_attribute13,
694 out_global_attribute14,
695 out_global_attribute15,
696 out_global_attribute16,
697 out_global_attribute17,
698 out_global_attribute18,
699 out_global_attribute19,
700 out_global_attribute20
701 FROM
702 so_line_attributes
703 WHERE
704 line_id = in_line_id;
705
706 END IF;
707
708 EXCEPTION
709 WHEN NO_DATA_FOUND THEN
710 out_industry_context := NULL ;
711 out_industry_attribute1 := NULL ;
712 out_industry_attribute2 := NULL ;
713 out_industry_attribute3 := NULL ;
714 out_industry_attribute4 := NULL ;
715 out_industry_attribute5 := NULL ;
716 out_industry_attribute6 := NULL ;
717 out_industry_attribute7 := NULL ;
718 out_industry_attribute8 := NULL ;
719 out_industry_attribute9 := NULL ;
720 out_industry_attribute10 := NULL ;
721 out_industry_attribute11 := NULL ;
722 out_industry_attribute12 := NULL ;
723 out_industry_attribute13 := NULL ;
724 out_industry_attribute14 := NULL ;
725 out_industry_attribute15 := NULL ;
726 out_global_attribute_category := NULL ;
727 out_global_attribute1 := NULL ;
728 out_global_attribute2 := NULL ;
729 out_global_attribute3 := NULL ;
730 out_global_attribute4 := NULL ;
731 out_global_attribute5 := NULL ;
732 out_global_attribute6 := NULL ;
733 out_global_attribute7 := NULL ;
734 out_global_attribute8 := NULL ;
735 out_global_attribute9 := NULL ;
736 out_global_attribute10 := NULL ;
737 out_global_attribute11 := NULL ;
738 out_global_attribute12 := NULL ;
739 out_global_attribute13 := NULL ;
740 out_global_attribute14 := NULL ;
741 out_global_attribute15 := NULL ;
742 out_global_attribute16 := NULL ;
743 out_global_attribute17 := NULL ;
744 out_global_attribute18 := NULL ;
745 out_global_attribute19 := NULL ;
746 out_global_attribute20 := NULL ;
747
748
749 END get_industry_attributes;
750
751 END oe_line_attributes;