1 PACKAGE INV_TO_Form_Trolin AUTHID CURRENT_USER AS
2 /* $Header: INVFTRLS.pls 120.0 2005/05/25 06:49:03 appldev noship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY VARCHAR2
9 , x_msg_count OUT NOCOPY NUMBER
10 , x_msg_data OUT NOCOPY VARCHAR2
11 , p_header_id IN NUMBER
12 , x_attribute1 OUT NOCOPY VARCHAR2
13 , x_attribute10 OUT NOCOPY VARCHAR2
14 , x_attribute11 OUT NOCOPY VARCHAR2
15 , x_attribute12 OUT NOCOPY VARCHAR2
16 , x_attribute13 OUT NOCOPY VARCHAR2
17 , x_attribute14 OUT NOCOPY VARCHAR2
18 , x_attribute15 OUT NOCOPY VARCHAR2
19 , x_attribute2 OUT NOCOPY VARCHAR2
20 , x_attribute3 OUT NOCOPY VARCHAR2
21 , x_attribute4 OUT NOCOPY VARCHAR2
22 , x_attribute5 OUT NOCOPY VARCHAR2
23 , x_attribute6 OUT NOCOPY VARCHAR2
24 , x_attribute7 OUT NOCOPY VARCHAR2
25 , x_attribute8 OUT NOCOPY VARCHAR2
26 , x_attribute9 OUT NOCOPY VARCHAR2
27 , x_attribute_category OUT NOCOPY VARCHAR2
28 , x_date_required OUT NOCOPY DATE
29 , x_from_locator_id OUT NOCOPY NUMBER
30 , x_from_subinventory_code OUT NOCOPY VARCHAR2
31 , x_from_subinventory_id OUT NOCOPY NUMBER
32 , x_header_id OUT NOCOPY NUMBER
33 , x_inventory_item_id OUT NOCOPY NUMBER
34 , x_line_id OUT NOCOPY NUMBER
35 , x_line_number OUT NOCOPY NUMBER
36 , x_line_status OUT NOCOPY NUMBER
37 , x_lot_number OUT NOCOPY VARCHAR2
38 , x_organization_id OUT NOCOPY NUMBER
39 , x_project_id OUT NOCOPY NUMBER
40 , x_quantity OUT NOCOPY NUMBER
41 , x_quantity_delivered OUT NOCOPY NUMBER
42 , x_quantity_detailed OUT NOCOPY NUMBER
43 , x_reason_id OUT NOCOPY NUMBER
44 , x_reference OUT NOCOPY VARCHAR2
45 , x_reference_id OUT NOCOPY NUMBER
46 , x_reference_type_code OUT NOCOPY NUMBER
47 , x_revision OUT NOCOPY VARCHAR2
48 , x_serial_number_end OUT NOCOPY VARCHAR2
49 , x_serial_number_start OUT NOCOPY VARCHAR2
50 , x_status_date OUT NOCOPY DATE
51 , x_task_id OUT NOCOPY NUMBER
52 , x_to_account_id OUT NOCOPY NUMBER
53 , x_to_locator_id OUT NOCOPY NUMBER
54 , x_to_subinventory_code OUT NOCOPY VARCHAR2
55 , x_to_subinventory_id OUT NOCOPY NUMBER
56 , x_transaction_header_id OUT NOCOPY NUMBER
57 , x_uom_code OUT NOCOPY VARCHAR2
58 , x_from_locator OUT NOCOPY VARCHAR2
59 , x_inventory_item OUT NOCOPY VARCHAR2
60 , x_project OUT NOCOPY VARCHAR2
61 , x_reason OUT NOCOPY VARCHAR2
62 , x_reference_type OUT NOCOPY VARCHAR2
63 , x_task OUT NOCOPY VARCHAR2
64 , x_to_account OUT NOCOPY VARCHAR2
65 , x_to_locator OUT NOCOPY VARCHAR2
66 , x_transaction_type_id OUT NOCOPY NUMBER
67 , x_transaction_source_type_id OUT NOCOPY NUMBER
68 , x_txn_source_id OUT NOCOPY NUMBER
69 , x_txn_source_line_id OUT NOCOPY NUMBER
70 , x_txn_source_line_detail_id OUT NOCOPY NUMBER
71 , x_primary_quantity OUT NOCOPY NUMBER
72 , x_to_organization_id OUT NOCOPY NUMBER
73 , x_pick_strategy_id OUT NOCOPY NUMBER
74 , x_put_away_strategy_id OUT NOCOPY NUMBER
75 , x_unit_number OUT NOCOPY VARCHAR2
76 -- , x_ship_to_location_id OUT NOCOPY NUMBER -- NL MERGE
77 , x_transaction_type OUT NOCOPY VARCHAR2
78 , x_secondary_quantity OUT NOCOPY NUMBER --INVCONV change
79 , x_secondary_quantity_delivered OUT NOCOPY NUMBER --INVCONV change
80 , x_secondary_quantity_detailed OUT NOCOPY NUMBER --INVCONV change
81 , x_secondary_uom_code OUT NOCOPY VARCHAR2 --INVCONV change
82 , x_grade_code OUT NOCOPY VARCHAR2 --INVCONV change
83 );
84
85 -- Procedure : Validate_Record
86 --
87
88 PROCEDURE Validate_Record
89 ( x_return_status OUT NOCOPY VARCHAR2
90 , x_msg_count OUT NOCOPY NUMBER
91 , x_msg_data OUT NOCOPY VARCHAR2
92 , p_attribute1 IN VARCHAR2
93 , p_attribute10 IN VARCHAR2
94 , p_attribute11 IN VARCHAR2
95 , p_attribute12 IN VARCHAR2
96 , p_attribute13 IN VARCHAR2
97 , p_attribute14 IN VARCHAR2
98 , p_attribute15 IN VARCHAR2
99 , p_attribute2 IN VARCHAR2
100 , p_attribute3 IN VARCHAR2
101 , p_attribute4 IN VARCHAR2
102 , p_attribute5 IN VARCHAR2
103 , p_attribute6 IN VARCHAR2
104 , p_attribute7 IN VARCHAR2
105 , p_attribute8 IN VARCHAR2
106 , p_attribute9 IN VARCHAR2
107 , p_attribute_category IN VARCHAR2
108 , p_date_required IN DATE
109 , p_from_locator_id IN NUMBER
110 , p_from_subinventory_code IN VARCHAR2
111 , p_from_subinventory_id IN NUMBER
112 , p_header_id IN NUMBER
113 , p_inventory_item_id IN NUMBER
114 , p_line_id IN NUMBER
115 , p_line_number IN NUMBER
116 , p_line_status IN NUMBER
117 , p_lot_number IN VARCHAR2
118 , p_organization_id IN NUMBER
119 , p_project_id IN NUMBER
120 , p_quantity IN NUMBER
121 , p_quantity_delivered IN NUMBER
122 , p_quantity_detailed IN NUMBER
123 , p_reason_id IN NUMBER
124 , p_reference IN VARCHAR2
125 , p_reference_id IN NUMBER
126 , p_reference_type_code IN NUMBER
127 , p_revision IN VARCHAR2
128 , p_serial_number_end IN VARCHAR2
129 , p_serial_number_start IN VARCHAR2
130 , p_status_date IN DATE
131 , p_task_id IN NUMBER
132 , p_to_account_id IN NUMBER
133 , p_to_locator_id IN NUMBER
134 , p_to_subinventory_code IN VARCHAR2
135 , p_to_subinventory_id IN NUMBER
136 , p_transaction_header_id IN NUMBER
137 , p_uom_code IN VARCHAR2
138 , p_transaction_type_id IN NUMBER
139 , p_transaction_source_type_id IN NUMBER
140 , p_txn_source_id IN NUMBER
141 , p_txn_source_line_id IN NUMBER
142 , p_txn_source_line_detail_id IN NUMBER
143 , p_primary_quantity IN NUMBER
144 , p_to_organization_id IN NUMBER
145 , p_pick_strategy_id IN NUMBER
146 , p_put_away_strategy_id IN NUMBER
147 , p_unit_number IN VARCHAR2
148 , p_ship_to_location_id IN NUMBER DEFAULT NULL
149 , p_from_cost_group_id IN NUMBER DEFAULT NULL
150 , p_to_cost_group_id IN NUMBER DEFAULT NULL
151 , p_lpn_id IN NUMBER DEFAULT NULL
152 , p_to_lpn_id IN NUMBER DEFAULT NULL
153 , p_db_flag IN VARCHAR2
154 , p_secondary_quantity IN NUMBER DEFAULT NULL --INVCONV change
155 , p_secondary_quantity_delivered IN NUMBER DEFAULT NULL --INVCONV change
156 , p_secondary_quantity_detailed IN NUMBER DEFAULT NULL --INVCONV change
157 , p_secondary_uom_code IN VARCHAR2 DEFAULT NULL --INVCONV change
158 , p_grade_code IN VARCHAR2 DEFAULT NULL --INVCONV change
159 );
160
161 -- Procedure Validate_And_Write
162 --
163
164 PROCEDURE Validate_And_Write
165 ( x_return_status OUT NOCOPY VARCHAR2
166 , x_msg_count OUT NOCOPY NUMBER
167 , x_msg_data OUT NOCOPY VARCHAR2
168 , p_attribute1 IN VARCHAR2
169 , p_attribute10 IN VARCHAR2
170 , p_attribute11 IN VARCHAR2
171 , p_attribute12 IN VARCHAR2
172 , p_attribute13 IN VARCHAR2
173 , p_attribute14 IN VARCHAR2
174 , p_attribute15 IN VARCHAR2
175 , p_attribute2 IN VARCHAR2
176 , p_attribute3 IN VARCHAR2
177 , p_attribute4 IN VARCHAR2
178 , p_attribute5 IN VARCHAR2
179 , p_attribute6 IN VARCHAR2
180 , p_attribute7 IN VARCHAR2
181 , p_attribute8 IN VARCHAR2
182 , p_attribute9 IN VARCHAR2
183 , p_attribute_category IN VARCHAR2
184 , p_date_required IN DATE
185 , p_from_locator_id IN NUMBER
186 , p_from_subinventory_code IN VARCHAR2
187 , p_from_subinventory_id IN NUMBER
188 , p_header_id IN NUMBER
189 , p_inventory_item_id IN NUMBER
190 , p_line_id IN NUMBER
191 , p_line_number IN NUMBER
192 , p_line_status IN NUMBER
193 , p_lot_number IN VARCHAR2
194 , p_organization_id IN NUMBER
195 , p_project_id IN NUMBER
196 , p_quantity IN NUMBER
197 , p_quantity_delivered IN NUMBER
198 , p_quantity_detailed IN NUMBER
199 , p_reason_id IN NUMBER
200 , p_reference IN VARCHAR2
201 , p_reference_id IN NUMBER
202 , p_reference_type_code IN NUMBER
203 , p_revision IN VARCHAR2
204 , p_serial_number_end IN VARCHAR2
205 , p_serial_number_start IN VARCHAR2
206 , p_status_date IN DATE
207 , p_task_id IN NUMBER
208 , p_to_account_id IN NUMBER
209 , p_to_locator_id IN NUMBER
210 , p_to_subinventory_code IN VARCHAR2
211 , p_to_subinventory_id IN NUMBER
212 , p_transaction_header_id IN NUMBER
213 , p_uom_code IN VARCHAR2
214 , p_transaction_type_id IN NUMBER
215 , p_transaction_source_type_id IN NUMBER
216 , p_txn_source_id IN NUMBER
217 , p_txn_source_line_id IN NUMBER
218 , p_txn_source_line_detail_id IN NUMBER
219 , p_primary_quantity IN NUMBER
220 , p_to_organization_id IN NUMBER
221 , p_pick_strategy_id IN NUMBER
222 , p_put_away_strategy_id IN NUMBER
223 , p_unit_number IN VARCHAR2
224 , p_ship_to_location_id IN NUMBER DEFAULT NULL
225 , p_from_cost_group_id IN NUMBER DEFAULT NULL
226 , p_to_cost_group_id IN NUMBER DEFAULT NULL
227 , p_lpn_id IN NUMBER DEFAULT NULL
228 , p_to_lpn_id IN NUMBER DEFAULT NULL
229 , p_db_flag IN VARCHAR2
230 , p_secondary_quantity IN NUMBER DEFAULT NULL --INVCONV change
231 , p_secondary_quantity_delivered IN NUMBER DEFAULT NULL --INVCONV change
232 , p_secondary_quantity_detailed IN NUMBER DEFAULT NULL --INVCONV change
233 , p_secondary_uom_code IN VARCHAR2 DEFAULT NULL --INVCONV change
234 , p_grade_code IN VARCHAR2 DEFAULT NULL --INVCONV change
235 , x_creation_date OUT NOCOPY DATE
236 , x_created_by OUT NOCOPY NUMBER
237 , x_last_update_date OUT NOCOPY DATE
238 , x_last_updated_by OUT NOCOPY NUMBER
239 , x_last_update_login OUT NOCOPY NUMBER
240 );
241
242 -- Procedure Delete_Row
243 --
244
245 PROCEDURE Delete_Row
246 ( x_return_status OUT NOCOPY VARCHAR2
247 , x_msg_count OUT NOCOPY NUMBER
248 , x_msg_data OUT NOCOPY VARCHAR2
249 , p_line_id IN NUMBER
250 );
251
252 -- Procedure Process_Entity
253 --
254
255 PROCEDURE Process_Entity
256 ( x_return_status OUT NOCOPY VARCHAR2
257 , x_msg_count OUT NOCOPY NUMBER
258 , x_msg_data OUT NOCOPY VARCHAR2
259 );
260
261 -- Procedure lock_Row
262 --
263
264 PROCEDURE Lock_Row
265 ( x_return_status OUT NOCOPY VARCHAR2
266 , x_msg_count OUT NOCOPY NUMBER
267 , x_msg_data OUT NOCOPY VARCHAR2
268 , p_attribute1 IN VARCHAR2
269 , p_attribute10 IN VARCHAR2
270 , p_attribute11 IN VARCHAR2
271 , p_attribute12 IN VARCHAR2
272 , p_attribute13 IN VARCHAR2
273 , p_attribute14 IN VARCHAR2
274 , p_attribute15 IN VARCHAR2
275 , p_attribute2 IN VARCHAR2
276 , p_attribute3 IN VARCHAR2
277 , p_attribute4 IN VARCHAR2
278 , p_attribute5 IN VARCHAR2
279 , p_attribute6 IN VARCHAR2
280 , p_attribute7 IN VARCHAR2
281 , p_attribute8 IN VARCHAR2
282 , p_attribute9 IN VARCHAR2
283 , p_attribute_category IN VARCHAR2
284 , p_created_by IN NUMBER
285 , p_creation_date IN DATE
286 , p_date_required IN DATE
287 , p_from_locator_id IN NUMBER
288 , p_from_subinventory_code IN VARCHAR2
289 , p_from_subinventory_id IN NUMBER
290 , p_header_id IN NUMBER
291 , p_inventory_item_id IN NUMBER
292 , p_last_updated_by IN NUMBER
293 , p_last_update_date IN DATE
294 , p_last_update_login IN NUMBER
295 , p_line_id IN NUMBER
296 , p_line_number IN NUMBER
297 , p_line_status IN NUMBER
298 , p_lot_number IN VARCHAR2
299 , p_organization_id IN NUMBER
300 , p_program_application_id IN NUMBER
301 , p_program_id IN NUMBER
302 , p_program_update_date IN DATE
303 , p_project_id IN NUMBER
304 , p_quantity IN NUMBER
305 , p_quantity_delivered IN NUMBER
306 , p_quantity_detailed IN NUMBER
307 , p_reason_id IN NUMBER
308 , p_reference IN VARCHAR2
309 , p_reference_id IN NUMBER
310 , p_reference_type_code IN NUMBER
311 , p_request_id IN NUMBER
312 , p_revision IN VARCHAR2
313 , p_serial_number_end IN VARCHAR2
314 , p_serial_number_start IN VARCHAR2
315 , p_status_date IN DATE
316 , p_task_id IN NUMBER
317 , p_to_account_id IN NUMBER
318 , p_to_locator_id IN NUMBER
319 , p_to_subinventory_code IN VARCHAR2
320 , p_to_subinventory_id IN NUMBER
321 , p_transaction_header_id IN NUMBER
322 , p_transaction_type_id IN NUMBER
323 , p_transaction_source_type_id IN NUMBER
324 , p_txn_source_id IN NUMBER
325 , p_txn_source_line_id IN NUMBER
326 , p_txn_source_line_detail_id IN NUMBER
327 , p_primary_quantity IN NUMBER
328 , p_to_organization_id IN NUMBER
329 , p_pick_strategy_id IN NUMBER
330 , p_put_away_strategy_id IN NUMBER
331 , p_unit_number IN VARCHAR2
332 , p_uom_code IN VARCHAR2
333 , p_ship_to_location_id IN NUMBER DEFAULT NULL
337 , p_to_lpn_id IN NUMBER DEFAULT NULL
334 , p_from_cost_group_id IN NUMBER DEFAULT NULL
335 , p_to_cost_group_id IN NUMBER DEFAULT NULL
336 , p_lpn_id IN NUMBER DEFAULT NULL
338 , p_secondary_quantity IN NUMBER DEFAULT NULL --INVCONV change
339 , p_secondary_quantity_delivered IN NUMBER DEFAULT NULL --INVCONV change
340 , p_secondary_quantity_detailed IN NUMBER DEFAULT NULL --INVCONV change
341 , p_secondary_uom_code IN VARCHAR2 DEFAULT NULL --INVCONV change
342 , p_grade_code IN VARCHAR2 DEFAULT NULL --INVCONV change
343 );
344
345 END INV_TO_Form_Trolin;