[Home] [Help]
PACKAGE: APPS.GMI_PICK_WAVE_CONFIRM_PVT
Source
1 PACKAGE GMI_PICK_WAVE_CONFIRM_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMIVPWCS.pls 115.12 2003/04/22 14:15:36 hwahdani ship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIVPWCS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains private routines For Pick Wave Confirmation |
13 | |
14 | |
15 | |
16 | HISTORY |
17 | 03-MAY-2000 hverddin Created |
18 | HW BUG#:2296620 Added a new procedure called CHECK_SHIP_SET and |
19 | added a new parameter to PICK_CONFIRM called |
20 | p_manual_pick for ship sets functionality |
21 | |
22 +=========================================================================+
23 API Name : GMI_PICK_WAVE_CONFIRM_PVT
24 Type : Global
25 -
26 Pre-reqs : N/A
27 Parameters: Per function
28
29 Current Vers : 1.0
30
31 */
32
33 /* Following procedure added for Enhancement 2320442 - Lakshmi Swamy */
34
35 PROCEDURE BALANCE_NONCTL_INV_TRAN
36 (
37 p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
38 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
39 , p_item_id IN NUMBER
40 , p_whse_code IN VARCHAR2
41 , p_requested_qty IN NUMBER
42 , p_requested_qty2 IN NUMBER
43 , p_delivery_detail_id IN NUMBER
44 , x_available_qty OUT NOCOPY NUMBER
45 , x_available_qty2 OUT NOCOPY NUMBER
46 , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_msg_count OUT NOCOPY NUMBER
49 , x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 -- HW OPM changes for NOCOPY
53 -- Added NOCOPY to x_mo_line_tbl
54
55 PROCEDURE PICK_CONFIRM
56 (
57 p_api_version_number IN NUMBER
58 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
59 , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
60 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
61 , p_delivery_detail_id IN NUMBER DEFAULT NULL
62 , p_mo_line_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
63 , x_mo_line_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl
64 , x_return_status OUT NOCOPY VARCHAR2
65 , x_msg_count OUT NOCOPY NUMBER
66 , x_msg_data OUT NOCOPY VARCHAR2
67 , p_manual_pick IN VARCHAR2 DEFAULT NULL
68 );
69
70
71 FUNCTION check_required
72 (
73 p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
74 )
75 RETURN BOOLEAN;
76
77
78 PROCEDURE GET_OPM_CONVERTED_QTY
79 (
80 p_opm_item_id IN NUMBER,
81 p_apps_from_uom IN VARCHAR2,
82 p_apps_to_uom IN VARCHAR2,
83 p_opm_lot_id IN NUMBER,
84 p_original_qty IN NUMBER,
85 x_converted_qty OUT NOCOPY NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90 PROCEDURE Check_Shipping_Tolerances
91 ( x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 x_allowed OUT NOCOPY VARCHAR2,
95 x_max_quantity OUT NOCOPY NUMBER,
96 x_max_quantity2 OUT NOCOPY NUMBER,
97 p_line_id IN NUMBER,
98 p_quantity IN NUMBER,
99 p_quantity2 IN NUMBER
100 ) ;
101
102 --HW BUG#:2296620
103 PROCEDURE CHECK_SHIP_SET
104 (
105 p_ship_set_id IN NUMBER,
106 p_manual_pick IN VARCHAR2,
107 x_return_status OUT NOCOPY VARCHAR2
108 ) ;
109
110 PROCEDURE FORM_PICK_CONFIRM
111 (
112 p_api_version_number IN NUMBER
113 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
114 , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
115 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
116 , p_mo_line_tbl IN GMI_Move_Order_Global.MO_LINE_TBL
117 , x_mo_line_tbl OUT NOCOPY GMI_Move_Order_Global.MO_LINE_TBL
118 , x_return_status OUT NOCOPY VARCHAR2
119 , x_msg_count OUT NOCOPY NUMBER
120 , x_msg_data OUT NOCOPY VARCHAR2
121 , p_manual_pick IN VARCHAR2 DEFAULT NULL
122 ) ;
123
124 END GMI_PICK_WAVE_CONFIRM_PVT;