1 PACKAGE inv_3pl_loc_pvt AUTHID CURRENT_USER AS
2 /* $Header: INVVSSCS.pls 120.1 2010/05/25 11:16:57 damahaja noship $ */
3
4 PROCEDURE update_locator_capacity
5 ( x_return_status OUT NOCOPY VARCHAR2, -- return status (success/error/unexpected_error)
6 x_msg_count OUT NOCOPY NUMBER, -- number of messages in the message queue
7 x_msg_data OUT NOCOPY VARCHAR2, -- message text when x_msg_count>0
8 p_inventory_location_id IN NUMBER, -- identifier of locator
9 p_organization_id IN NUMBER, -- org of locator whose capacity is to be determined
10 p_client_code IN VARCHAR2, -- identifier of item
11 p_transaction_action_id IN NUMBER, -- transaction action id for pack,unpack,issue,receive,transfer
12 p_quantity IN NUMBER,
13 p_transaction_date IN DATE
14 );
15
16 Function update_3pl_loc_occupancy
17 (
18 l_Last_Receipt_Date DATE,
19 l_current_onhand NUMBER ,
20 l_locator_id NUMBER ,
21 l_transaction_date DATE ,
22 l_transaction_action NUMBER ,
23 l_transaction_quantity NUMBER ,
24 l_organization_id NUMBER,
25 l_client_code VARCHAR2 ,
26 l_number_of_days number
27 ) RETURN VARCHAR2;
28
29 Function insert_3pl_loc_occupancy
30 (
31 l_Last_Receipt_Date date,
32 l_current_onhand NUMBER ,
33 l_locator_id NUMBER ,
34 l_transaction_date DATE ,
35 l_transaction_action NUMBER ,
36 l_transaction_quantity NUMBER ,
37 l_organization_id NUMBER,
38 l_client_code VARCHAR2 ,
39 l_number_of_days number
40 ) RETURN VARCHAR2;
41
42 END inv_3pl_loc_pvt;