1 PACKAGE GML_RCV_DB_COMMON AUTHID CURRENT_USER AS
2 /* $Header: GMLRCVCS.pls 120.0 2005/05/25 16:35:20 appldev noship $ */
3
4 PROCEDURE RAISE_QUALITY_EVENT( x_transaction_id IN NUMBER,
5 x_item_id IN NUMBER,
6 x_organization_id IN NUMBER);
7
8
9 Procedure VALIDATE_RMA_LOT_QUANTITIES( p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11 p_opm_item_id IN NUMBER,
12 p_lot_id IN NUMBER,
13 p_lot_no IN VARCHAR2,
14 p_sublot_no IN VARCHAR2,
15 p_oe_header_id IN NUMBER,
16 p_oe_line_id IN NUMBER,
17 p_trx_qty IN NUMBER,
18 p_trx_uom IN VARCHAR2,
19 p_rma_lot_qty IN NUMBER,
20 p_rma_lot_uom IN VARCHAR2,
21 p_line_set_id IN NUMBER,
22 p_called_from IN VARCHAR2 DEFAULT 'FORM',
23 X_allowed OUT NOCOPY VARCHAR2,
24 X_allowed_quantity OUT NOCOPY NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2);
26
27
28 Procedure VALIDATE_IO_LOT_QUANTITIES (p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30 p_opm_item_id IN NUMBER,
31 p_lot_id IN NUMBER,
32 p_trx_qty IN NUMBER,
33 p_trx_uom IN VARCHAR2,
34 p_order_num IN NUMBER,
35 p_req_header_id IN NUMBER,
36 p_req_line_id IN NUMBER,
37 p_shipment_header_id IN NUMBER,
38 p_shipment_line_id IN NUMBER,
39 p_req_distribution_id IN NUMBER,
40 p_called_from IN VARCHAR2 DEFAULT 'FORM',
41 X_allowed OUT NOCOPY VARCHAR2,
42 X_allowed_quantity OUT NOCOPY NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45 END GML_RCV_DB_COMMON;