[Home] [Help]
PACKAGE: APPS.GMI_RESERVATION_PVT
Source
1 PACKAGE GMI_Reservation_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMIVRSVS.pls 115.12 2003/01/15 21:05:46 nchekuri ship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIVRSVS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains private procedures relating to OPM |
13 | reservation. |
14 | |
15 | - Query_Reservation |
16 | - Create_Reservation |
17 | - Update_Reservation |
18 | - Delete_Reservation |
19 | - Transfer_Reservation |
20 | - Check_Shipping_Details |
21 | - Calculate Prior Reservations
22 | |
23 | HISTORY |
24 | 21-FEB-2000 odaboval Created |
25 | 09/10/01 BUG#:1941429 Added code to support cross_docking |
26 | 03-OCT-2001 odaboval, local fix for bug 2025611 |
27 | added procedure Check_Shipping_Details |
28 | 13-JAN-2003 NC Added Calculate_prior_reservations Bug#2670928 |
29 | |
30 +=========================================================================+
31 API Name : GMI_Reservation_PVT
32 Type : Private
33 Function : This package contains Private procedures used to
34 OPM reservation process.
35 -
36 Pre-reqs : N/A
37 Parameters: Per function
38
39 Current Vers : 1.0
40 */
41
42
43 /*
44 TYPE ic_tran_pnd_tbl IS TABLE OF ic_tran_pnd%ROWTYPE
45 INDEX BY BINARY_INTEGER;
46
47 l_ic_tran_pnd_tbl ic_tran_pnd_tbl;
48
49
50 p_tran_rec ic_tran_pnd%rowtype;
51
52 p_tran_tbl is table of p_tran_rec index by binary_integer;
53 */
54
55 PROCEDURE Query_Reservation
56 (
57 x_return_status OUT NOCOPY VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER
59 , x_msg_data OUT NOCOPY VARCHAR2
60 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
61 , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
62 , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
63 , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
64 , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
65 , x_error_code OUT NOCOPY NUMBER
66 );
67
68 PROCEDURE Create_Reservation
69 (
70 x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_count OUT NOCOPY NUMBER
72 , x_msg_data OUT NOCOPY VARCHAR2
73 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
74 , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
75 , p_serial_number IN inv_reservation_global.serial_number_tbl_type
76 , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
77 , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
78 , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
79 , x_quantity_reserved OUT NOCOPY NUMBER
80 , x_reservation_id OUT NOCOPY NUMBER
81 );
82
83 PROCEDURE Update_Reservation
84 (
85 x_return_status OUT NOCOPY VARCHAR2
86 , x_msg_count OUT NOCOPY NUMBER
87 , x_msg_data OUT NOCOPY VARCHAR2
88 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
89 , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
90 , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
91 , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
92 , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
93 );
94
95 PROCEDURE Delete_Reservation
96 (
97 x_return_status OUT NOCOPY VARCHAR2
98 , x_msg_count OUT NOCOPY NUMBER
99 , x_msg_data OUT NOCOPY VARCHAR2
100 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
101 , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
102 , p_serial_number IN inv_reservation_global.serial_number_tbl_type
103 );
104
105 PROCEDURE Transfer_Reservation
106 (
107 p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
108 , x_return_status OUT NOCOPY VARCHAR2
109 , x_msg_count OUT NOCOPY NUMBER
110 , x_msg_data OUT NOCOPY VARCHAR2
111 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
112 , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113 , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114 , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115 , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116 , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117 , x_to_reservation_id OUT NOCOPY NUMBER
118 );
119
120 -- HW BUG#:1941429 procedure to calculate qty reserved for cross_docking
121 PROCEDURE Calculate_Reservation(
122 p_organization_id IN NUMBER,
123 p_item_id IN NUMBER,
124 p_demand_source_line_id IN NUMBER,
125 p_delivery_detail_id IN NUMBER,
126 p_requested_quantity IN NUMBER,
127 p_requested_quantity2 IN NUMBER DEFAULT NULL,
128 x_result_qty1 OUT NOCOPY NUMBER,
129 x_result_qty2 OUT NOCOPY NUMBER
130 );
131
132 PROCEDURE Check_Shipping_Details
133 ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
134 , x_return_status OUT NOCOPY VARCHAR2
135 , x_msg_count OUT NOCOPY NUMBER
136 , x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139 PROCEDURE query_qty_for_ATP(
140 p_organization_id IN NUMBER,
141 p_item_id IN NUMBER,
142 p_demand_source_line_id IN NUMBER,
143 x_onhand_qty1 OUT NOCOPY NUMBER,
144 x_onhand_qty2 OUT NOCOPY NUMBER,
145 x_avail_qty1 OUT NOCOPY NUMBER,
146 x_avail_qty2 OUT NOCOPY NUMBER
147 );
148
149 /* NC Added for prior reservations project Bug#2670928 */
150 PROCEDURE Calculate_Prior_Reservations(
151 p_organization_id IN NUMBER
152 ,p_item_id IN NUMBER
153 ,p_demand_source_line_id IN NUMBER
154 ,p_delivery_detail_id IN NUMBER
155 ,p_requested_quantity IN NUMBER
156 ,p_requested_quantity2 IN NUMBER DEFAULT NULL
157 ,x_result_qty1 OUT NOCOPY NUMBER
158 ,x_result_qty2 OUT NOCOPY NUMBER
159 ,x_return_status OUT NOCOPY VARCHAR2
160 ,x_msg_count OUT NOCOPY NUMBER
161 ,x_msg_data OUT NOCOPY VARCHAR2
162 );
163
164 END GMI_Reservation_PVT;