1 PACKAGE oe_line_attributes AUTHID CURRENT_USER AS
2 /* $Header: OEXLATTS.pls 115.1 99/07/16 08:13:08 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 */
8
9 PROCEDURE set_so_line_attributes
10 (in_line_id IN NUMBER,
11 in_op_code IN VARCHAR2,
12 in_ord_source IN VARCHAR2,
13 in_orig_sys_ref IN VARCHAR2,
14 in_orig_sys_l_ref IN VARCHAR2,
15 in_req_id IN NUMBER,
16 out_result OUT NUMBER );
17
18 /*
19 ** set_industry_attributes is called from oeoord.lpc
20 ** to insert(delete) a complementing null record into so_line_attributes
21 ** whenever a line is inserted(deleted) into so_lines.
22 ** Also called from Order User Exit to update records when in GUI mode,
23 ** or to insert/delete records when in Character mode.
24 */
25
26 PROCEDURE set_industry_attributes
27 (in_op_code IN VARCHAR2,
28 in_line_id IN NUMBER,
29 in_industry_context IN VARCHAR2 DEFAULT NULL,
30 in_industry_attribute1 IN VARCHAR2 DEFAULT NULL,
31 in_industry_attribute2 IN VARCHAR2 DEFAULT NULL,
32 in_industry_attribute3 IN VARCHAR2 DEFAULT NULL,
33 in_industry_attribute4 IN VARCHAR2 DEFAULT NULL,
34 in_industry_attribute5 IN VARCHAR2 DEFAULT NULL,
35 in_industry_attribute6 IN VARCHAR2 DEFAULT NULL,
36 in_industry_attribute7 IN VARCHAR2 DEFAULT NULL,
37 in_industry_attribute8 IN VARCHAR2 DEFAULT NULL,
38 in_industry_attribute9 IN VARCHAR2 DEFAULT NULL,
39 in_industry_attribute10 IN VARCHAR2 DEFAULT NULL,
40 in_industry_attribute11 IN VARCHAR2 DEFAULT NULL,
41 in_industry_attribute12 IN VARCHAR2 DEFAULT NULL,
42 in_industry_attribute13 IN VARCHAR2 DEFAULT NULL,
43 in_industry_attribute14 IN VARCHAR2 DEFAULT NULL,
44 in_industry_attribute15 IN VARCHAR2 DEFAULT NULL,
45 in_global_attribute_category IN VARCHAR2 DEFAULT NULL,
46 in_global_attribute1 IN VARCHAR2 DEFAULT NULL,
47 in_global_attribute2 IN VARCHAR2 DEFAULT NULL,
48 in_global_attribute3 IN VARCHAR2 DEFAULT NULL,
49 in_global_attribute4 IN VARCHAR2 DEFAULT NULL,
50 in_global_attribute5 IN VARCHAR2 DEFAULT NULL,
51 in_global_attribute6 IN VARCHAR2 DEFAULT NULL,
52 in_global_attribute7 IN VARCHAR2 DEFAULT NULL,
53 in_global_attribute8 IN VARCHAR2 DEFAULT NULL,
54 in_global_attribute9 IN VARCHAR2 DEFAULT NULL,
55 in_global_attribute10 IN VARCHAR2 DEFAULT NULL,
56 in_global_attribute11 IN VARCHAR2 DEFAULT NULL,
57 in_global_attribute12 IN VARCHAR2 DEFAULT NULL,
58 in_global_attribute13 IN VARCHAR2 DEFAULT NULL,
59 in_global_attribute14 IN VARCHAR2 DEFAULT NULL,
60 in_global_attribute15 IN VARCHAR2 DEFAULT NULL,
61 in_global_attribute16 IN VARCHAR2 DEFAULT NULL,
62 in_global_attribute17 IN VARCHAR2 DEFAULT NULL,
63 in_global_attribute18 IN VARCHAR2 DEFAULT NULL,
64 in_global_attribute19 IN VARCHAR2 DEFAULT NULL,
65 in_global_attribute20 IN VARCHAR2 DEFAULT NULL
66 );
67
68 /*
69 ** get_industry_attributes is called from oexobj.lpc
70 ** to get industry attributes from the database given a line_id.
71 ** This is used to resolve locking issue.
72 */
73
74 PROCEDURE get_industry_attributes
75 (in_op_code IN VARCHAR2,
76 in_line_id IN NUMBER,
77 out_industry_context OUT VARCHAR2 ,
78 out_industry_attribute1 OUT VARCHAR2 ,
79 out_industry_attribute2 OUT VARCHAR2 ,
80 out_industry_attribute3 OUT VARCHAR2 ,
81 out_industry_attribute4 OUT VARCHAR2 ,
82 out_industry_attribute5 OUT VARCHAR2 ,
83 out_industry_attribute6 OUT VARCHAR2 ,
84 out_industry_attribute7 OUT VARCHAR2 ,
85 out_industry_attribute8 OUT VARCHAR2 ,
86 out_industry_attribute9 OUT VARCHAR2 ,
87 out_industry_attribute10 OUT VARCHAR2 ,
88 out_industry_attribute11 OUT VARCHAR2 ,
89 out_industry_attribute12 OUT VARCHAR2 ,
90 out_industry_attribute13 OUT VARCHAR2 ,
91 out_industry_attribute14 OUT VARCHAR2 ,
92 out_industry_attribute15 OUT VARCHAR2,
93 out_global_attribute_category OUT VARCHAR2 ,
94 out_global_attribute1 OUT VARCHAR2 ,
95 out_global_attribute2 OUT VARCHAR2 ,
96 out_global_attribute3 OUT VARCHAR2 ,
97 out_global_attribute4 OUT VARCHAR2 ,
98 out_global_attribute5 OUT VARCHAR2 ,
99 out_global_attribute6 OUT VARCHAR2 ,
100 out_global_attribute7 OUT VARCHAR2 ,
101 out_global_attribute8 OUT VARCHAR2 ,
102 out_global_attribute9 OUT VARCHAR2 ,
103 out_global_attribute10 OUT VARCHAR2 ,
104 out_global_attribute11 OUT VARCHAR2 ,
105 out_global_attribute12 OUT VARCHAR2 ,
106 out_global_attribute13 OUT VARCHAR2 ,
107 out_global_attribute14 OUT VARCHAR2 ,
108 out_global_attribute15 OUT VARCHAR2 ,
109 out_global_attribute16 OUT VARCHAR2 ,
110 out_global_attribute17 OUT VARCHAR2 ,
111 out_global_attribute18 OUT VARCHAR2 ,
112 out_global_attribute19 OUT VARCHAR2 ,
113 out_global_attribute20 OUT VARCHAR2
114 );
115 END oe_line_attributes;