DBA Data[Home] [Help]

PACKAGE: APPS.INV_RCV_MOBILE_PROCESS_TXN

Source


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;