DBA Data[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;