1 PACKAGE wms_overpick AS
2 /* $Header: WMSOPICS.pls 120.1 2005/06/20 04:57:02 appldev ship $ */
3
4 -- This API queries the quantity_tree to find OUT NOCOPY /* file.sql.39 change */ whether there is
5 -- sufficient quantity to be picked in a locator . If sufficient, the API
6 -- returns x_ret=1, otherwise x_ret=0
7
8 PROCEDURE validate_overpick
9 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2, -- return status (success/error/unexpected_error)
10 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER, -- number of messages in the message queue
11 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2, -- message text when x_msg_count>0
12 x_ret OUT NOCOPY /* file.sql.39 change */ NUMBER, -- returns 1 if p_qty > quantity from qty_tree
13 -- otherwise returns 0
14 x_att OUT NOCOPY /* file.sql.39 change */ NUMBER, -- quantity that is avail to transact
15 p_temp_id IN NUMBER, -- transaction_temp_id
16 p_qty IN NUMBER, -- quantity requested
17 p_uom IN VARCHAR2 -- unit of measure
18 );
19 END wms_overpick;
20
21