1 PACKAGE OE_Shipping_Tolerances_PUB AUTHID CURRENT_USER AS
2 /* $Header: OEXPTOLS.pls 120.0 2005/05/31 22:27:41 appldev noship $ */
3
4 -- Start of Comments
5 -- API name : Get_Max_Quantity_Remaining
6 -- Type : Public
7 -- Pre-reqs : None.
8 -- Function : This procedure will be called by to get the min and max quantity
9 -- remaining to be shipped for a line.
10 -- Parameters : p_api_version_number IN NUMBER Required
11 -- p_line_id IN NUMBER Required
12 -- line id of the line for which the remaining quantity
13 -- is requested.
14 -- Version : Current version = 1.0
15 -- Initial version = 1.0
16 -- End of Comments
17 --
18 -- HW Added Qty2 for OPM
19 PROCEDURE Get_Min_Max_Tolerance_Quantity
20 (
21 p_api_version_number IN NUMBER
22 , p_line_id IN NUMBER
23 , x_min_remaining_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
24 , x_max_remaining_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
25 , x_min_remaining_quantity2 OUT NOCOPY /* file.sql.39 change */ NUMBER
26 , x_max_remaining_quantity2 OUT NOCOPY /* file.sql.39 change */ NUMBER
27 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 );
31
32 PROCEDURE Get_Min_Max_quantity_Uom
33 (
34 p_api_version_number IN NUMBER
35 , p_line_id IN NUMBER
36 , x_min_remaining_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
37 , x_max_remaining_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_quantity_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , x_min_remaining_quantity2 OUT NOCOPY /* file.sql.39 change */ NUMBER
40 , x_max_remaining_quantity2 OUT NOCOPY /* file.sql.39 change */ NUMBER
41 , x_quantity_uom2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
44 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 );
46 END OE_Shipping_Tolerances_PUB;
47