1 PACKAGE GMI_Shipping_Util AUTHID CURRENT_USER AS
2 /* $Header: GMIUSHPS.pls 115.25 2004/02/20 01:42:37 hwahdani ship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIUSHPS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains private utilities relating to OPM |
13 | shipping. |
14 | |
15 +=========================================================================+
16 */
17
18 /* NC - 11/02/01 Temperary declaration of this record type. Should be
19 deleted when OM changes are incorporated */
20
21 TYPE SplitDetailRecType IS RECORD (
22 delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
23 requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
24 picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
25 shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26 cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27 requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28 requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29 picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30 shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31 cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32 requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33 organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34 inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35 subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36 lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37 sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38 locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39 source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40 net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41 cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42 cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43 serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44 to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
45 transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
46 container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
47 released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
48 delivery_id WSH_DELIVERY_ASSIGNMENTS.delivery_id%TYPE,
49 parent_delivery_detail_id WSH_DELIVERY_ASSIGNMENTS.parent_delivery_detail_id%TYPE
50 );
51 PROCEDURE GMI_CREATE_BACKORDER_TXN
52 ( p_shipping_line IN wsh_delivery_details%ROWTYPE
53 , x_return_status OUT NOCOPY VARCHAR2
54 , x_msg_count OUT NOCOPY NUMBER
55 , x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE GMI_UPDATE_SHIPMENT_TXN
59 ( p_shipping_line IN wsh_delivery_details%ROWTYPE
60 , p_actual_ship_date IN Date
61 , x_return_status OUT NOCOPY VARCHAR2
62 , x_msg_count OUT NOCOPY NUMBER
63 , x_msg_data OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE GMI_APPLY_BACKORDER_UPDATES
67 ( p_original_source_line_id IN NUMBER
68 , p_source_line_id IN NUMBER
69 , p_action_flag IN VARCHAR2
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_count OUT NOCOPY NUMBER
72 , x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 /* NC 23-AUG-01 Added the following two procedure headers BUG#1675561 */
76 PROCEDURE UPDATE_OPM_TRANSACTION
77 ( p_old_delivery_detail_id IN NUMBER,
78 p_lot_number IN VARCHAR2,
79 p_sublot_number IN VARCHAR2,
80 p_organization_id IN NUMBER,
81 p_inventory_item_id IN NUMBER,
82 p_old_source_line_id IN NUMBER,
83 p_locator_id IN NUMBER,
84 p_new_delivery_detail_id IN NUMBER,
85 p_old_req_quantity IN NUMBER,
86 p_old_req_quantity2 IN NUMBER,
87 p_req_quantity IN NUMBER,
88 p_req_quantity2 IN NUMBER DEFAULT NULL,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2 );
92
93 PROCEDURE UPDATE_OPM_IC_TRAN_PND
94 (
95 p_delivery_detail_id IN NUMBER,
96 p_trans_id IN NUMBER,
97 p_staged_flag IN NUMBER
98 );
99
100 PROCEDURE PRINT_DEBUG
101 ( p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
102 , p_routine IN VARCHAR2
103 );
104
105 PROCEDURE create_rcv_transaction
106 ( p_shipping_line IN wsh_delivery_details%ROWTYPE
107 , p_trip_stop_rec IN wsh_trip_stops%ROWTYPE
108 , p_group_id IN NUMBER
109 , x_return_status OUT NOCOPY VARCHAR2
110 , x_msg_count OUT NOCOPY NUMBER
111 , x_msg_data OUT NOCOPY VARCHAR2
112 );
113
114 PROCEDURE process_OPM_orders(
115 p_stop_id IN NUMBER
116 , x_return_status OUT NOCOPY VARCHAR2
117 ) ;
118
119
120 PROCEDURE MATCH_LINES ;
121
122 PROCEDURE unreserve_inv
123 ( p_trans_id IN NUMBER
124 , x_return_status OUT NOCOPY VARCHAR2
125 );
126
127 PROCEDURE split_opm_trans
128 ( p_old_delivery_detail_id IN NUMBER,
129 p_released_status IN VARCHAR2,
130 p_lot_number IN VARCHAR2,
131 p_sublot_number IN VARCHAR2,
132 p_organization_id IN NUMBER,
133 p_inventory_item_id IN NUMBER,
134 p_old_source_line_id IN NUMBER,
135 p_locator_id IN NUMBER,
136 p_old_req_quantity IN NUMBER,
137 p_old_req_quantity2 IN NUMBER,
138 p_new_delivery_detail_id IN NUMBER,
139 p_qty_to_split IN NUMBER,
140 p_qty2_to_split IN NUMBER,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2
144 );
145
146 PROCEDURE split_trans
147 ( p_old_delivery_detail_id IN NUMBER,
148 p_new_delivery_detail_id IN NUMBER,
149 p_old_source_line_id IN NUMBER,
150 p_new_source_line_id IN NUMBER,
151 p_qty_to_split IN NUMBER,
152 p_qty2_to_split IN NUMBER,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2
156 );
157 procedure check_non_ctl
158 ( p_delivery_detail_id IN NUMBER
159 ,p_shipped_quantity IN NUMBER
160 ,p_shipped_quantity2 IN NUMBER
161 ,x_return_status OUT NOCOPY VARCHAR2
162 );
163
164 -- HW 3157172
165 -- Added this procedure to replace the call to GMI_SHIPPING_UTIl.unreserve_inv
166 -- This procedure will be called from WSHDDACB.pls in WSH.J
167 -- This procedure was in place in the package body but was never
168 -- in use till 11.5.10
169 -- HW 12345 added p_consolidate_bo_lines for 11510
170 Procedure unreserve_delivery_detail
171 ( p_delivery_detail_id IN NUMBER
172 , p_quantity_to_unreserve IN NUMBER
173 , p_quantity_to_unreserve2 IN NUMBER default NULL
174 , p_unreserve_mode IN VARCHAR2
175 , x_return_status OUT NOCOPY VARCHAR2
176 );
177
178 -- HW 3388186
179 -- This procedure is introduced because of WSH Consolidate backorder Line Project in 11510
180 -- p_cons_dd_id Consolidated delivery_detail_id
181 -- p_old_dd_ids Old delivery_detail_ids that were consolidated
182
183 -- This procedure will pass old delivery detail_ids and the new condsolidated
184 -- delivery_detail_ids to update the inventory transactions
185 -- with new delivery_detail_id
186 -- This procedure is called from WSHDDSPB.pls (11510), procedure: Backorder
187 -- This procedure will be called when Consolidated Backorder Line
188 -- is checked in Global Parameter under Shipping > Setup and
189 -- Action is Cycle Count All
190 PROCEDURE UPDATE_NEW_LINE_DETAIL_ID
191 ( p_cons_dd_id IN NUMBER
192 , p_old_dd_ids IN WSH_UTIL_CORE.Id_Tab_Type
193 , x_return_status OUT NOCOPY VARCHAR2
194 );
195
196 END GMI_Shipping_Util;