[Home] [Help]
PACKAGE: APPS.OE_OE_FORM_LOT_SERIAL
Source
1 PACKAGE OE_OE_Form_Lot_Serial AUTHID CURRENT_USER AS
2 /* $Header: OEXFSRLS.pls 120.0 2005/06/01 00:18:39 appldev noship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY VARCHAR2
9
10 , x_msg_count OUT NOCOPY NUMBER
11
12 , x_msg_data OUT NOCOPY VARCHAR2
13
14 , p_line_id IN NUMBER
15 , x_attribute1 OUT NOCOPY VARCHAR2
16
17 , x_attribute10 OUT NOCOPY VARCHAR2
18
19 , x_attribute11 OUT NOCOPY VARCHAR2
20
21 , x_attribute12 OUT NOCOPY VARCHAR2
22
23 , x_attribute13 OUT NOCOPY VARCHAR2
24
25 , x_attribute14 OUT NOCOPY VARCHAR2
26
27 , x_attribute15 OUT NOCOPY VARCHAR2
28
29 , x_attribute2 OUT NOCOPY VARCHAR2
30
31 , x_attribute3 OUT NOCOPY VARCHAR2
32
33 , x_attribute4 OUT NOCOPY VARCHAR2
34
35 , x_attribute5 OUT NOCOPY VARCHAR2
36
37 , x_attribute6 OUT NOCOPY VARCHAR2
38
39 , x_attribute7 OUT NOCOPY VARCHAR2
40
41 , x_attribute8 OUT NOCOPY VARCHAR2
42
43 , x_attribute9 OUT NOCOPY VARCHAR2
44
45 , x_context OUT NOCOPY VARCHAR2
46
47 , x_from_serial_number OUT NOCOPY VARCHAR2
48
49 , x_line_id OUT NOCOPY NUMBER
50
51 , x_lot_number OUT NOCOPY VARCHAR2
52
53 --, x_sublot_number OUT NOCOPY VARCHAR2 --OPM 2380194 INVCONV
54
55 , x_lot_serial_id OUT NOCOPY NUMBER
56
57 , x_quantity OUT NOCOPY NUMBER
58
59 , x_quantity2 OUT NOCOPY NUMBER --OPM 2380194
60
61 , x_to_serial_number OUT NOCOPY VARCHAR2
62
63 , x_line OUT NOCOPY VARCHAR2
64
65 , x_lot_serial OUT NOCOPY VARCHAR2
66
67 );
68
69 -- Procedure : Change_Attribute
70 --
71
72 PROCEDURE Change_Attribute
73 ( x_return_status OUT NOCOPY VARCHAR2
74
75 , x_msg_count OUT NOCOPY NUMBER
76
77 , x_msg_data OUT NOCOPY VARCHAR2
78
79 , p_lot_serial_id IN NUMBER
80 , p_attr_id IN NUMBER
81 , p_attr_value IN VARCHAR2
82 , p_attribute1 IN VARCHAR2
83 , p_attribute10 IN VARCHAR2
84 , p_attribute11 IN VARCHAR2
85 , p_attribute12 IN VARCHAR2
86 , p_attribute13 IN VARCHAR2
87 , p_attribute14 IN VARCHAR2
88 , p_attribute15 IN VARCHAR2
89 , p_attribute2 IN VARCHAR2
90 , p_attribute3 IN VARCHAR2
91 , p_attribute4 IN VARCHAR2
92 , p_attribute5 IN VARCHAR2
93 , p_attribute6 IN VARCHAR2
94 , p_attribute7 IN VARCHAR2
95 , p_attribute8 IN VARCHAR2
96 , p_attribute9 IN VARCHAR2
97 , p_context IN VARCHAR2
98 , x_attribute1 OUT NOCOPY VARCHAR2
99
100 , x_attribute10 OUT NOCOPY VARCHAR2
101
102 , x_attribute11 OUT NOCOPY VARCHAR2
103
104 , x_attribute12 OUT NOCOPY VARCHAR2
105
106 , x_attribute13 OUT NOCOPY VARCHAR2
107
108 , x_attribute14 OUT NOCOPY VARCHAR2
109
110 , x_attribute15 OUT NOCOPY VARCHAR2
111
112 , x_attribute2 OUT NOCOPY VARCHAR2
113
114 , x_attribute3 OUT NOCOPY VARCHAR2
115
116 , x_attribute4 OUT NOCOPY VARCHAR2
117
118 , x_attribute5 OUT NOCOPY VARCHAR2
119
120 , x_attribute6 OUT NOCOPY VARCHAR2
121
122 , x_attribute7 OUT NOCOPY VARCHAR2
123
124 , x_attribute8 OUT NOCOPY VARCHAR2
125
126 , x_attribute9 OUT NOCOPY VARCHAR2
127
128 , x_context OUT NOCOPY VARCHAR2
129
130 , x_from_serial_number OUT NOCOPY VARCHAR2
131
132 , x_line_id OUT NOCOPY NUMBER
133
134 , x_lot_number OUT NOCOPY VARCHAR2
135
136 --, x_sublot_number OUT NOCOPY VARCHAR2 --OPM 2380194 INVCONV
137
138 , x_lot_serial_id OUT NOCOPY NUMBER
139
140 , x_quantity OUT NOCOPY NUMBER
141
142 , x_quantity2 OUT NOCOPY NUMBER --OPM 2380194
143
144 , x_to_serial_number OUT NOCOPY VARCHAR2
145
146 , x_line OUT NOCOPY VARCHAR2
147
148 , x_lot_serial OUT NOCOPY VARCHAR2
149
150 );
151
152 -- Procedure Validate_And_Write
153 --
154
155 PROCEDURE Validate_And_Write
156 ( x_return_status OUT NOCOPY VARCHAR2
157
158 , x_msg_count OUT NOCOPY NUMBER
159
160 , x_msg_data OUT NOCOPY VARCHAR2
161
162 , p_lot_serial_id IN NUMBER
163 , x_creation_date OUT NOCOPY DATE
164
165 , x_created_by OUT NOCOPY NUMBER
166
167 , x_last_update_date OUT NOCOPY DATE
168
169 , x_last_updated_by OUT NOCOPY NUMBER
170
171 , x_last_update_login OUT NOCOPY NUMBER
172
173 , x_lock_control OUT NOCOPY NUMBER
174
175 );
176
177 -- Procedure Delete_Row
178 --
179
180 PROCEDURE Delete_Row
181 ( x_return_status OUT NOCOPY VARCHAR2
182
183 , x_msg_count OUT NOCOPY NUMBER
184
185 , x_msg_data OUT NOCOPY VARCHAR2
186
187 , p_lot_serial_id IN NUMBER
188 );
189
190 -- Procedure Process_Entity
191 --
192
193 PROCEDURE Process_Entity
194 ( x_return_status OUT NOCOPY VARCHAR2
195
196 , x_msg_count OUT NOCOPY NUMBER
197
198 , x_msg_data OUT NOCOPY VARCHAR2
199
200 );
201
202 -- Procedure lock_Row
203 --
204
205 PROCEDURE Lock_Row
206 ( x_return_status OUT NOCOPY VARCHAR2
207
208 , x_msg_count OUT NOCOPY NUMBER
209
210 , x_msg_data OUT NOCOPY VARCHAR2
211
212 , p_lot_serial_id IN NUMBER
213 , p_lock_control IN NUMBER
214 );
215
216 END OE_OE_Form_Lot_Serial;