1 PACKAGE inv_rcv_std_inspect_apis AS
2 /* $Header: INVSTDIS.pls 120.0.12010000.1 2008/07/24 01:48:02 appldev ship $ */
3
4 /*
5 ** -------------------------------------------------------------------------
6 ** Procedure: main_process
7 ** Description:
8 ** Output:
9 ** x_return_status
10 ** return status indicating success, error, unexpected error
11 ** x_msg_count
12 ** number of messages in message list
13 ** x_msg_data
14 ** if the number of messages in message list is 1, contains
15 ** message text
16 ** Input:
17 **
18 ** Returns:
19 ** none
20 ** --------------------------------------------------------------------------
21 */
22
23 PROCEDURE main_process(
24 x_return_status OUT NOCOPY VARCHAR2
25 , x_msg_count OUT NOCOPY NUMBER
26 , x_msg_data OUT NOCOPY VARCHAR2
27 , p_inventory_item_id IN NUMBER
28 , p_organization_id IN NUMBER
29 , p_lpn_id IN NUMBER
30 , p_revision IN VARCHAR2
31 , p_lot_number IN VARCHAR2
32 , p_uom_code IN VARCHAR2
33 , p_quantity IN NUMBER
34 , p_inspection_code IN VARCHAR2
35 , p_quality_code IN VARCHAR2
36 , p_transaction_type IN VARCHAR2
37 , p_reason_id IN NUMBER
38 , p_serial_number IN VARCHAR2
39 , p_accept_lpn_id IN NUMBER
40 , p_reject_lpn_id IN NUMBER
41 , p_transaction_date IN DATE DEFAULT SYSDATE
42 , p_qa_collection_id IN NUMBER DEFAULT NULL
43 , p_vendor_lot IN VARCHAR2 DEFAULT NULL
44 , p_comments IN VARCHAR2 DEFAULT NULL
45 , p_attribute_category IN VARCHAR2 DEFAULT NULL
46 , p_attribute1 IN VARCHAR2 DEFAULT NULL
47 , p_attribute2 IN VARCHAR2 DEFAULT NULL
48 , p_attribute3 IN VARCHAR2 DEFAULT NULL
49 , p_attribute4 IN VARCHAR2 DEFAULT NULL
50 , p_attribute5 IN VARCHAR2 DEFAULT NULL
51 , p_attribute6 IN VARCHAR2 DEFAULT NULL
52 , p_attribute7 IN VARCHAR2 DEFAULT NULL
53 , p_attribute8 IN VARCHAR2 DEFAULT NULL
54 , p_attribute9 IN VARCHAR2 DEFAULT NULL
55 , p_attribute10 IN VARCHAR2 DEFAULT NULL
56 , p_attribute11 IN VARCHAR2 DEFAULT NULL
57 , p_attribute12 IN VARCHAR2 DEFAULT NULL
58 , p_attribute13 IN VARCHAR2 DEFAULT NULL
59 , p_attribute14 IN VARCHAR2 DEFAULT NULL
60 , p_attribute15 IN VARCHAR2 DEFAULT NULL
61 , p_secondary_qty IN NUMBER DEFAULT NULL); --OPM Convergence
62
63 procedure range_serial_process(
64 x_return_status OUT NOCOPY VARCHAR2
65 , x_msg_count OUT NOCOPY NUMBER
66 , x_msg_data OUT NOCOPY VARCHAR2
67 , p_inventory_item_id IN NUMBER
68 , p_organization_id IN NUMBER
69 , p_lpn_id IN NUMBER
70 , p_revision IN VARCHAR2
71 , p_lot_number IN VARCHAR2
72 , p_inspection_code IN VARCHAR2
73 , p_quality_code IN VARCHAR2
74 , p_transaction_type IN VARCHAR2
75 , p_reason_id IN NUMBER
76 , p_from_serial_number IN VARCHAR2
77 , p_to_serial_number IN VARCHAR2
78 , p_accept_lpn_id IN NUMBER
79 , p_reject_lpn_id IN NUMBER
80 , p_transaction_date IN DATE DEFAULT SYSDATE
81 , p_vendor_lot IN VARCHAR2 DEFAULT NULL
82 , p_comments IN VARCHAR2 DEFAULT NULL
83 , p_attribute_category IN VARCHAR2 DEFAULT NULL
84 , p_attribute1 IN VARCHAR2 DEFAULT NULL
85 , p_attribute2 IN VARCHAR2 DEFAULT NULL
86 , p_attribute3 IN VARCHAR2 DEFAULT NULL
87 , p_attribute4 IN VARCHAR2 DEFAULT NULL
88 , p_attribute5 IN VARCHAR2 DEFAULT NULL
89 , p_attribute6 IN VARCHAR2 DEFAULT NULL
90 , p_attribute7 IN VARCHAR2 DEFAULT NULL
91 , p_attribute8 IN VARCHAR2 DEFAULT NULL
92 , p_attribute9 IN VARCHAR2 DEFAULT NULL
93 , p_attribute10 IN VARCHAR2 DEFAULT NULL
94 , p_attribute11 IN VARCHAR2 DEFAULT NULL
95 , p_attribute12 IN VARCHAR2 DEFAULT NULL
96 , p_attribute13 IN VARCHAR2 DEFAULT NULL
97 , p_attribute14 IN VARCHAR2 DEFAULT NULL
98 , p_attribute15 IN VARCHAR2 DEFAULT NULL);
99
100 procedure main_process_po(
101 x_return_status OUT NOCOPY VARCHAR2
102 , x_msg_count OUT NOCOPY NUMBER
103 , x_msg_data OUT NOCOPY VARCHAR2
104 , p_inventory_item_id IN NUMBER
105 , p_organization_id IN NUMBER
106 , p_po_header_id IN NUMBER
107 , p_revision IN VARCHAR2
108 , p_uom_code IN VARCHAR2
109 , p_quantity IN NUMBER
110 , p_inspection_code IN VARCHAR2
111 , p_quality_code IN VARCHAR2
112 , p_transaction_type IN VARCHAR2
113 , p_reason_id IN NUMBER
114 , p_transaction_date IN DATE DEFAULT SYSDATE
115 , p_qa_collection_id IN NUMBER DEFAULT NULL
116 , p_vendor_lot IN VARCHAR2 DEFAULT NULL
117 , p_comments IN VARCHAR2 DEFAULT NULL
118 , p_attribute_category IN VARCHAR2 DEFAULT NULL
119 , p_attribute1 IN VARCHAR2 DEFAULT NULL
120 , p_attribute2 IN VARCHAR2 DEFAULT NULL
121 , p_attribute3 IN VARCHAR2 DEFAULT NULL
122 , p_attribute4 IN VARCHAR2 DEFAULT NULL
123 , p_attribute5 IN VARCHAR2 DEFAULT NULL
124 , p_attribute6 IN VARCHAR2 DEFAULT NULL
125 , p_attribute7 IN VARCHAR2 DEFAULT NULL
126 , p_attribute8 IN VARCHAR2 DEFAULT NULL
127 , p_attribute9 IN VARCHAR2 DEFAULT NULL
128 , p_attribute10 IN VARCHAR2 DEFAULT NULL
129 , p_attribute11 IN VARCHAR2 DEFAULT NULL
130 , p_attribute12 IN VARCHAR2 DEFAULT NULL
131 , p_attribute13 IN VARCHAR2 DEFAULT NULL
132 , p_attribute14 IN VARCHAR2 DEFAULT NULL
133 , p_attribute15 IN VARCHAR2 DEFAULT NULL
134 , p_secondary_qty IN NUMBER DEFAULT NULL); --OPM Convergence
135
136 procedure main_process_intransit(
137 x_return_status OUT NOCOPY VARCHAR2
138 , x_msg_count OUT NOCOPY NUMBER
139 , x_msg_data OUT NOCOPY VARCHAR2
140 , p_inventory_item_id IN NUMBER
141 , p_organization_id IN NUMBER
142 , p_shipment_header_id IN NUMBER
143 , p_revision IN VARCHAR2
144 , p_uom_code IN VARCHAR2
145 , p_quantity IN NUMBER
146 , p_inspection_code IN VARCHAR2
147 , p_quality_code IN VARCHAR2
148 , p_transaction_type IN VARCHAR2
149 , p_reason_id IN NUMBER
150 , p_transaction_date IN DATE DEFAULT SYSDATE
151 , p_qa_collection_id IN NUMBER DEFAULT NULL
152 , p_vendor_lot IN VARCHAR2 DEFAULT NULL
153 , p_comments IN VARCHAR2 DEFAULT NULL
154 , p_attribute_category IN VARCHAR2 DEFAULT NULL
155 , p_attribute1 IN VARCHAR2 DEFAULT NULL
156 , p_attribute2 IN VARCHAR2 DEFAULT NULL
157 , p_attribute3 IN VARCHAR2 DEFAULT NULL
158 , p_attribute4 IN VARCHAR2 DEFAULT NULL
159 , p_attribute5 IN VARCHAR2 DEFAULT NULL
160 , p_attribute6 IN VARCHAR2 DEFAULT NULL
161 , p_attribute7 IN VARCHAR2 DEFAULT NULL
162 , p_attribute8 IN VARCHAR2 DEFAULT NULL
163 , p_attribute9 IN VARCHAR2 DEFAULT NULL
164 , p_attribute10 IN VARCHAR2 DEFAULT NULL
165 , p_attribute11 IN VARCHAR2 DEFAULT NULL
166 , p_attribute12 IN VARCHAR2 DEFAULT NULL
167 , p_attribute13 IN VARCHAR2 DEFAULT NULL
168 , p_attribute14 IN VARCHAR2 DEFAULT NULL
169 , p_attribute15 IN VARCHAR2 DEFAULT NULL
170 , p_secondary_qty IN NUMBER DEFAULT NULL); --OPM Convergence
171
172 procedure main_process_rma(
173 x_return_status OUT NOCOPY VARCHAR2
174 , x_msg_count OUT NOCOPY NUMBER
175 , x_msg_data OUT NOCOPY VARCHAR2
176 , p_inventory_item_id IN NUMBER
177 , p_organization_id IN NUMBER
178 , p_oe_order_header_id IN NUMBER
179 , p_revision IN VARCHAR2
180 , p_uom_code IN VARCHAR2
181 , p_quantity IN NUMBER
182 , p_inspection_code IN VARCHAR2
183 , p_quality_code IN VARCHAR2
184 , p_transaction_type IN VARCHAR2
185 , p_reason_id IN NUMBER
186 , p_transaction_date IN DATE DEFAULT SYSDATE
187 , p_qa_collection_id IN NUMBER DEFAULT NULL
188 , p_vendor_lot IN VARCHAR2 DEFAULT NULL
189 , p_comments IN VARCHAR2 DEFAULT NULL
190 , p_attribute_category IN VARCHAR2 DEFAULT NULL
191 , p_attribute1 IN VARCHAR2 DEFAULT NULL
192 , p_attribute2 IN VARCHAR2 DEFAULT NULL
193 , p_attribute3 IN VARCHAR2 DEFAULT NULL
194 , p_attribute4 IN VARCHAR2 DEFAULT NULL
195 , p_attribute5 IN VARCHAR2 DEFAULT NULL
196 , p_attribute6 IN VARCHAR2 DEFAULT NULL
197 , p_attribute7 IN VARCHAR2 DEFAULT NULL
198 , p_attribute8 IN VARCHAR2 DEFAULT NULL
199 , p_attribute9 IN VARCHAR2 DEFAULT NULL
200 , p_attribute10 IN VARCHAR2 DEFAULT NULL
201 , p_attribute11 IN VARCHAR2 DEFAULT NULL
202 , p_attribute12 IN VARCHAR2 DEFAULT NULL
203 , p_attribute13 IN VARCHAR2 DEFAULT NULL
204 , p_attribute14 IN VARCHAR2 DEFAULT NULL
205 , p_attribute15 IN VARCHAR2 DEFAULT NULL
206 , p_secondary_qty IN NUMBER DEFAULT NULL); --OPM Convergence
207
208 procedure main_process_receipt(
209 x_return_status OUT NOCOPY VARCHAR2
210 , x_msg_count OUT NOCOPY NUMBER
211 , x_msg_data OUT NOCOPY VARCHAR2
212 , p_inventory_item_id IN NUMBER
213 , p_organization_id IN NUMBER
214 , p_receipt_num IN VARCHAR2
215 , p_revision IN VARCHAR2
216 , p_uom_code IN VARCHAR2
217 , p_quantity IN NUMBER
218 , p_inspection_code IN VARCHAR2
219 , p_quality_code IN VARCHAR2
220 , p_transaction_type IN VARCHAR2
221 , p_reason_id IN NUMBER
222 , p_transaction_date IN DATE DEFAULT SYSDATE
223 , p_qa_collection_id IN NUMBER DEFAULT NULL
224 , p_vendor_lot IN VARCHAR2 DEFAULT NULL
225 , p_comments IN VARCHAR2 DEFAULT NULL
226 , p_attribute_category IN VARCHAR2 DEFAULT NULL
227 , p_attribute1 IN VARCHAR2 DEFAULT NULL
228 , p_attribute2 IN VARCHAR2 DEFAULT NULL
229 , p_attribute3 IN VARCHAR2 DEFAULT NULL
230 , p_attribute4 IN VARCHAR2 DEFAULT NULL
231 , p_attribute5 IN VARCHAR2 DEFAULT NULL
232 , p_attribute6 IN VARCHAR2 DEFAULT NULL
233 , p_attribute7 IN VARCHAR2 DEFAULT NULL
234 , p_attribute8 IN VARCHAR2 DEFAULT NULL
235 , p_attribute9 IN VARCHAR2 DEFAULT NULL
236 , p_attribute10 IN VARCHAR2 DEFAULT NULL
237 , p_attribute11 IN VARCHAR2 DEFAULT NULL
238 , p_attribute12 IN VARCHAR2 DEFAULT NULL
239 , p_attribute13 IN VARCHAR2 DEFAULT NULL
240 , p_attribute14 IN VARCHAR2 DEFAULT NULL
241 , p_attribute15 IN VARCHAR2 DEFAULT NULL
242 , p_secondary_qty IN NUMBER DEFAULT NULL); --OPM Convergence
243
244 procedure insert_inspect_rec_rti (
245 x_return_status OUT NOCOPY VARCHAR2
246 , x_msg_count OUT NOCOPY NUMBER
247 , x_msg_data OUT NOCOPY VARCHAR2
248 , p_rcv_transaction_id IN NUMBER
249 , p_quantity IN NUMBER
250 , p_uom IN VARCHAR2
251 , p_inspection_code IN VARCHAR2
252 , p_quality_code IN VARCHAR2
253 , p_transaction_date IN DATE
254 , p_transaction_type IN VARCHAR2
255 , p_vendor_lot IN VARCHAR2
256 , p_reason_id IN NUMBER
257 , p_primary_qty IN NUMBER
258 , p_organization_id IN NUMBER
259 , p_comments IN VARCHAR2 DEFAULT NULL
260 , p_attribute_category IN VARCHAR2 DEFAULT NULL
261 , p_attribute1 IN VARCHAR2 DEFAULT NULL
262 , p_attribute2 IN VARCHAR2 DEFAULT NULL
263 , p_attribute3 IN VARCHAR2 DEFAULT NULL
264 , p_attribute4 IN VARCHAR2 DEFAULT NULL
265 , p_attribute5 IN VARCHAR2 DEFAULT NULL
266 , p_attribute6 IN VARCHAR2 DEFAULT NULL
267 , p_attribute7 IN VARCHAR2 DEFAULT NULL
268 , p_attribute8 IN VARCHAR2 DEFAULT NULL
269 , p_attribute9 IN VARCHAR2 DEFAULT NULL
270 , p_attribute10 IN VARCHAR2 DEFAULT NULL
271 , p_attribute11 IN VARCHAR2 DEFAULT NULL
272 , p_attribute12 IN VARCHAR2 DEFAULT NULL
273 , p_attribute13 IN VARCHAR2 DEFAULT NULL
274 , p_attribute14 IN VARCHAR2 DEFAULT NULL
275 , p_attribute15 IN VARCHAR2 DEFAULT NULL
276 , p_qa_collection_id IN NUMBER DEFAULT NULL
277 , p_lpn_id IN NUMBER DEFAULT NULL
278 , p_transfer_lpn_id IN NUMBER DEFAULT NULL
279 , p_mmtt_temp_id IN NUMBER DEFAULT NULL
280 , p_sec_uom IN VARCHAR2 DEFAULT NULL --OPM Convergenc
281 , p_secondary_qty IN NUMBER DEFAULT NULL
282 ); --OPM Convergence
283
284 procedure rcv_manager_rpc_call(
285 x_return_status out NOCOPY varchar2
286 , x_return_code out NOCOPY number);
287
288 procedure launch_rcv_manager_rpc(
289 x_return_status out NOCOPY varchar2
290 , x_return_code out NOCOPY number);
291
292 procedure rcv_manager_conc_call;
293
294 procedure launch_rcv_manager_conc;
295
296 FUNCTION get_inspection_qty(
297 p_type IN VARCHAR2
298 ,p_lpn_id IN NUMBER := NULL
299 ,p_po_header_id IN NUMBER := NULL
300 ,p_po_release_id IN NUMBER := NULL
301 ,p_po_line_id IN NUMBER := NULL
302 ,p_shipment_header_id IN NUMBER := NULL
303 ,p_oe_order_header_id IN NUMBER := NULL
304 ,p_organization_id IN NUMBER
305 ,p_item_id IN NUMBER
306 ,p_uom_code IN VARCHAR2
307 ,x_inspection_qty OUT NOCOPY NUMBER
308 ,x_return_status OUT NOCOPY VARCHAR2
309 ,x_msg_data OUT NOCOPY VARCHAR2) RETURN NUMBER;
310
311 FUNCTION get_inspection_qty_wrapper(
312 p_type IN VARCHAR2
313 ,p_id1 IN NUMBER := NULL
314 ,p_id2 IN NUMBER := NULL
315 ,p_id3 IN NUMBER := NULL
316 ,p_organization_id IN NUMBER
317 ,p_item_id IN NUMBER
318 ,p_uom_code IN VARCHAR2) RETURN NUMBER;
319
320
321 PROCEDURE obtain_receiving_information(
322 p_lpn_id IN NUMBER
323 , p_organization_id IN NUMBER
324 , p_inventory_item_id IN NUMBER
325 , x_po_id OUT NOCOPY VARCHAR2
326 , x_po_number OUT NOCOPY VARCHAR2
327 , x_po_return_status OUT NOCOPY VARCHAR2
328 , x_vendor_id OUT NOCOPY VARCHAR2
329 , x_vendor_name OUT NOCOPY VARCHAR2
330 , x_asl_status_id OUT NOCOPY VARCHAR2
331 , x_asl_status_dsp OUT NOCOPY VARCHAR2
332 , x_rma_id OUT NOCOPY VARCHAR2
333 , x_rma_number OUT NOCOPY VARCHAR2
334 , x_rma_return_status OUT NOCOPY VARCHAR2
335 , x_customer_id OUT NOCOPY VARCHAR2
336 , x_customer_number OUT NOCOPY VARCHAR2
337 , x_customer_name OUT NOCOPY VARCHAR2
338 , x_intshp_id OUT NOCOPY VARCHAR2
339 , x_intshp_number OUT NOCOPY VARCHAR2
340 , x_intshp_return_status OUT NOCOPY VARCHAR2
341 , x_receipt_number OUT NOCOPY VARCHAR2
342 , x_receipt_return_status OUT NOCOPY VARCHAR2
343 , x_msg_count OUT NOCOPY VARCHAR2
344 , x_msg_data OUT NOCOPY VARCHAR2);
345
346 FUNCTION is_revision_required (
347 p_source_type IN VARCHAR2
348 , p_source_id IN NUMBER
349 , p_item_id IN NUMBER
350 ) RETURN NUMBER;
351
352 end inv_rcv_std_inspect_apis;