1 PACKAGE INV_RCV_MOBILE_PROCESS_TXN AUTHID CURRENT_USER AS
2 /* $Header: INVRCVPS.pls 120.2 2009/06/24 07:09:54 aditshar ship $*/
3
4
5 PROCEDURE rcv_process_receive_txn(x_return_status OUT nocopy VARCHAR2,
6 x_msg_data OUT nocopy VARCHAR2);
7
8 -- procedure check_existing_parent_lot and create_lot_uom_conversion added as part of bug# 8539263
9 Procedure lot_uom_conversion(
10 p_org_id IN NUMBER
11 , p_itemid IN NUMBER
12 , p_from_uom_code IN VARCHAR2
13 , p_to_uom_code IN VARCHAR2
14 , p_lot_number IN VARCHAR2
15 , p_user_response IN NUMBER
16 , p_create_lot_uom_conv IN NUMBER
17 , p_conversion_rate IN NUMBER
18 , x_return_status OUT nocopy VARCHAR2,
19 x_msg_data OUT nocopy VARCHAR2
20
21 ) ;
22 PROCEDURE check_existing_lot
23 ( p_org_id IN NUMBER
24 , p_item_id IN NUMBER
25 , p_lot_number IN VARCHAR2
26 , x_lot_exist OUT NOCOPY NUMBER
27 , x_return_status OUT NOCOPY VARCHAR2
28 , x_msg_data OUT NOCOPY VARCHAR2
29 );
30 END INV_RCV_MOBILE_PROCESS_TXN;