1 PACKAGE WSH_ASN_RECEIPT_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSHVASRS.pls 120.0 2005/05/26 17:54:40 appldev noship $ */
3
4 TYPE T_NUM is TABLE OF NUMBER;
5 TYPE T_V1 is TABLE OF VARCHAR2(1);
6 TYPE T_V250 is TABLE OF VARCHAR2(250);
7 TYPE T_V30 is TABLE OF VARCHAR2(30);
8 TYPE T_DATE is TABLE OF DATE;
9
10
11
12 TYPE local_dd_rec_type IS RECORD
13 (
14 del_detail_id NUMBER,
15 delivery_id NUMBER,
16 shipment_line_id NUMBER,
17 shpmt_line_id_idx NUMBER,
18 transaction_type VARCHAR2(50),
19 shipment_header_id number,
20 bol VARCHAR2(50),
21 trip_id NUMBER,
22 lpn_id NUMBER,
23 lpn_name VARCHAR2(50),
24 psno VARCHAR2(250),
25 waybill VARCHAR2(30),
26 truck_num VARCHAR2(35),
27 schedule_ship_date DATE,
28 expected_receipt_date DATE,
29 initial_pickup_date DATE,
30 rcv_gross_weight NUMBER,
34 rcv_Tare_weight NUMBER,
31 rcv_gross_weight_uom_code VARCHAR2(3),
32 rcv_net_weight NUMBER,
33 rcv_net_weight_uom_code VARCHAR2(3),
35 rcv_Tare_weight_uom_code VARCHAR2(3),
36 rcv_carrier_id NUMBER
37 );
38
39 TYPE local_dd_rec_table_type IS TABLE OF local_dd_rec_type index by binary_integer;
40
41 TYPE update_dd_rec_type is RECORD (
42 delivery_detail_id T_NUM := T_NUM(),
43 requested_quantity T_NUM := T_NUM(),
44 requested_quantity2 T_NUM := T_NUM(),
45 shipped_quantity T_NUM := T_NUM(),
46 returned_quantity T_NUM := T_NUM(),
47 received_quantity T_NUM := T_NUM(),
48 shipped_quantity2 T_NUM := T_NUM(),
49 returned_quantity2 T_NUM := T_NUM(),
50 received_quantity2 T_NUM := T_NUM(),
51 inventory_item_id T_NUM := T_NUM(),
52 ship_from_location_id T_NUM := T_NUM(),
53 item_description T_V250 := T_V250(),
54 released_status T_V1 := T_V1(),
55 rcv_shipment_line_id T_NUM := T_NUM(),
56 waybill_num T_V30 := T_V30(),
57 released_status_db T_V1 := T_V1(),
58 gross_weight T_NUM := T_NUM(),
59 net_weight T_NUM := T_NUM(),
60 volume T_NUM := T_NUM(),
61 last_update_date T_DATE := T_DATE(),
62 shipped_date T_DATE := T_DATE()
63 );
64
65 TYPE temp_dels_rec IS RECORD(
66 delivery_id NUMBER,
67 header_id NUMBER
68 );
69 TYPE temp_dels_type IS TABLE OF temp_dels_rec INDEX BY BINARY_INTEGER;
70
71 --=============================================================================
72 -- API name : Process_matched_txns
73 -- Type : Private.
74 -- Function :
75 -- Pre-reqs : None.
76 -- Parameters :
77 -- IN :
78 -- p_dd_rec IN WSH_IB_DEL_DET_REC_TYPE
79 -- p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
80 -- p_shipment_header_id IN NUMBER
81 -- p_action_prms IN wsh_glbl_var_Strct_grp.action_parameters_rec_type
82 -- p_max_txn_id IN NUMBER
83 -- OUT :
84 -- l_po_cancel_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
85 -- l_po_close_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
86 -- x_return_status OUT VARCHAR2(1)
87 --==============================================================================
88 PROCEDURE Process_Matched_Txns(
89 --p_dd_rec IN OUT NOCOPY WSH_IB_DEL_DET_REC_TYPE,
90 p_dd_rec IN OUT NOCOPY WSH_IB_UI_RECON_GRP.asn_rcv_del_det_rec_type,
91 p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
92 p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
93 p_shipment_header_id IN NUMBER,
94 p_max_txn_id IN NUMBER,
95 x_po_cancel_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
96 x_po_close_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
97 x_return_status OUT NOCOPY VARCHAR2);
98
99 --=============================================================================
100 -- API name : Cancel_ASN
101 -- Type : Private.
102 -- Function :
103 -- Pre-reqs : None.
104 -- Parameters :
105 -- IN :
106 -- p_header_id IN NUMBER
107 -- p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
108 -- p_action_prms IN wsh_glbl_var_Strct_grp.action_parameters_rec_type
109 -- OUT :
110 -- x_return_status OUT VARCHAR2(1)
111 --==============================================================================
112
113 PROCEDURE Cancel_ASN(
114 p_header_id IN NUMBER,
115 p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
116 x_return_status OUT NOCOPY VARCHAR2) ;
117
118
119
120
121 --=============================================================================
122 -- API name : Unassign_open_det_from_del
123 -- Type : Private.
124 -- Function :
125 -- Pre-reqs : None.
126 -- Parameters :
127 -- IN :
128 -- del_ids IN wsh_util_core.id_tab_type
129 -- OUT :
130 -- x_return_status OUT VARCHAR2
131 -- ==============================================================================
132 PROCEDURE Unassign_open_det_from_del(
133 p_del_ids IN wsh_util_core.id_tab_type,
134 p_action_prms IN wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
135 p_shipment_header_id IN NUMBER,
136 x_return_status OUT NOCOPY VARCHAR2 );
137
138
139 --=============================================================================
140 -- API name : initialize_txns
141 -- Type : Private.
142 -- Function :
143 -- Pre-reqs : None.
144 -- Parameters :
145 -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
146 -- p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
147 -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
148 -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
149 -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
150 -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
151 -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
152 -- p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
156 PROCEDURE initialize_txns(
153 -- p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.action_parameters_rec_type
154 -- x_return_status OUT NOCOPY VARCHAR2
155 -- =============================================================================
157 p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
158 p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
159 p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
160 p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
161 p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
162 p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
163 p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
164 p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
165 p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
166 p_shipment_header_id IN NUMBER,
167 x_return_status OUT NOCOPY VARCHAR2 );
168
169 --=============================================================================
170 -- API name : reconfigure_del_trips
171 -- Type : Private.
172 -- Function :
173 -- Pre-reqs : None.
174 -- Parameters :
175 -- dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE
176 -- x_return_status OUT VARCHAR2
177 -- =============================================================================
178 PROCEDURE reconfigure_del_trips(
179 p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
180 p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
181 x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
182 x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
183 x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
184 x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185 x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186 x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187 x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188 x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189 x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
190 x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
191 x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
192 x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
193 p_shipment_header_id IN NUMBER,
194 x_return_status OUT NOCOPY VARCHAR2);
195
196 --=============================================================================
197 -- API name : SORT_DD_REC
198 -- Type : Private.
199 -- Function :
200 -- Pre-reqs : None.
201 -- Parameters :
202 -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE
203 -- x_return_status OUT VARCHAR2
204 -- =============================================================================
205
206 PROCEDURE sort_dd_rec(
207 p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
208 x_return_status OUT NOCOPY VARCHAR2);
209
210 --=============================================================================
211 -- API name :Synch_bols
212 -- Type :Private.
213 -- Function :
214 -- Pre-reqs : None.
215 -- Parameters :
216 -- p_del_id IN NUMBER,
217 -- p_bol IN VARCHAR2
218 -- p_action_prms IN wsh_glbl_var_strct_grp.dd_action_parameters_rec_type
219 -- x_return_status OUT NOCOPY VARCHAR2
220 -- =============================================================================
221 Procedure Synch_bols(
222 p_del_id IN NUMBER,
223 p_bol IN VARCHAR2,
224 p_action_prms IN wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
225 x_return_status OUT NOCOPY VARCHAR2) ;
226
227 --=============================================================================
228 -- API name : update_status
229 -- Type : Private.
230 -- Function :
231 -- Pre-reqs : None.
232 -- Parameters :
233 -- action_code IN VARCHAR2
234 -- p_del_ids IN wsh_util_core.id_tab_type
235 -- p_trip_ids IN wsh_util_core.id_tab_type
236 -- p_stop_ids IN wsh_util_core.id_tab_type
237 -- p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
238 -- p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type
239 -- p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type
240 -- p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
241 -- x_return_status OUT VARCHAR2
242 -- ============================================================================
243
244 PROCEDURE update_status (
245 p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
246 p_del_ids IN wsh_util_core.id_tab_type,
247 p_trip_ids IN wsh_util_core.id_tab_type,
248 p_stop_ids IN wsh_util_core.id_tab_type,
249 p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
250 p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
251 p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
252 p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
253 p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
254 x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
255 x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
256 x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
257 x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258 x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259 x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260 x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261 x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262 x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
263 x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
264 x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
265 x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
266 x_return_status OUT NOCOPY VARCHAR2) ;
267
268 --=============================================================================
269 -- API name : consolidate_qty
270 -- Type : Private.
271 -- Function :
272 -- Pre-reqs : None.
273 -- Parameters :
277 -- p_remaining_qty IN NUMBER
274 -- p_consolidate_qty_rec IN OUT WSH_ASN_RECEIPT_PVT.consolidate_qty_rec_type
275 -- p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
276 -- p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
278 -- po_shipment_line_id IN NUMBER
279 -- x_return_status OUT VARCHAR2
280 -- ============================================================================
281
282 PROCEDURE consolidate_qty(
283 p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
284 p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
285 p_remaining_qty IN OUT NOCOPY NUMBER,
286 po_shipment_line_id IN NUMBER,
287 x_return_status OUT NOCOPY VARCHAR2);
288
289 Procedure populate_update_dd_rec(
290 p_dd_rec IN OUT NOCOPY WSH_IB_UI_RECON_GRP.asn_rcv_del_det_rec_type,
291 p_index IN NUMBER,
292 p_line_rec IN OE_WSH_BULK_GRP.line_rec_type,
293 p_gross_weight IN NUMBER DEFAULT NULL,
294 p_net_weight IN NUMBER DEFAULT NULL,
295 p_volume IN NUMBER DEFAULT NULL,
296 x_release_status IN VARCHAR2,
297 l_update_dd_rec IN OUT NOCOPY update_dd_rec_type,
298 x_lpnIdCacheTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299 x_lpnIdCacheExtTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300 x_return_status OUT NOCOPY VARCHAR2);
301
302
303 ---
304 --=============================================================================
305 -- API name : create_update_waybill_psno_bol
306 -- Type : Private.
307 -- Function :
308 -- Pre-reqs : None.
309 -- Parameters :
310 -- p_local_dd_rec IN OUT LOCAL_DD_REC_TABLE_TYPE
311 -- l_loop_index IN NUMBER
312 -- pack_ids IN OUT WSH_UTIL_CORE.id_tab_type
313 -- curr_del IN OUT NUMBER
314 -- curr_bol IN OUT VARCHAR2
315 -- curr_lpn IN OUT NUMBER
316 -- l_psno IN OUT VARCHAR2
317 -- l_waybill IN OUT VARCHAR2
318 -- l_use_lpns IN OUT NUMBER
319 -- l_psno_flag IN OUT NUMBER
320 -- l_trigger IN OUT NUMBER
321 -- l_waybill_flag IN OUT NUMBER
322 -- temp_trips IN OUT WSH_UTIL_CORE.id_tab_type
323 -- temp_dels IN OUT temp_dels_type
324 -- x_return_status OUT VARCHAR2
325 -- ============================================================================
326
327
328 PROCEDURE create_update_waybill_psno_bol(
329 p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
330 l_loop_index IN NUMBER,
331 pack_ids IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
332 curr_del IN OUT NOCOPY NUMBER,
333 curr_bol IN OUT NOCOPY VARCHAR2,
334 curr_lpn IN OUT NOCOPY NUMBER,
335 curr_lpn_name IN OUT NOCOPY VARCHAR2,
336 curr_del_det IN OUT NOCOPY NUMBER,
337 l_psno IN OUT NOCOPY VARCHAR2,
338 l_waybill IN OUT NOCOPY VARCHAR2,
339 l_psno_flag IN OUT NOCOPY NUMBER,
340 l_trigger IN OUT NOCOPY NUMBER,
341 l_waybill_flag IN OUT NOCOPY NUMBER,
342 temp_dels IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
343 p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
344 x_return_status OUT NOCOPY VARCHAR2
345 );
346
347
348
349
350 --=============================================================================
351 -- API name : create_update_inbound_document
352 -- Type : Private.
353 -- Function :
354 -- Pre-reqs : None.
355 -- Parameters :
356 -- p_document_number IN VARCHAR2,
357 -- p_entity_name IN VARCHAR2,
358 -- p_delivery_id IN NUMBER,
359 -- p_transaction_type IN VARCHAR2,
360 -- x_return_status OUT NOCOPY VARCHAR2
361 -- ============================================================================
362
363
364 PROCEDURE create_update_inbound_document (
365 p_document_number IN VARCHAR2,
366 p_entity_name IN VARCHAR2,
367 p_delivery_id IN NUMBER,
368 p_transaction_type IN VARCHAR2,
369 x_return_status OUT NOCOPY VARCHAR2);
370
371
372
373 --=============================================================================
374 -- API name : cancel_close_pending_txns
375 -- Type : Private.
376 -- Function :
377 -- Pre-reqs : None.
378 -- Parameters :
379 -- IN :
380 -- p_po_cancel_rec IN OE_WSH_BULK_GRP.line_rec_type
381 -- p_po_close_rec IN OE_WSH_BULK_GRP.line_rec_type
382 -- OUT :
383 -- x_return_status OUT VARCHAR2(1)
384 --==============================================================================
385
386 PROCEDURE cancel_close_pending_txns(
387 p_po_cancel_rec IN OE_WSH_BULK_GRP.line_rec_type,
388 p_po_close_rec IN OE_WSH_BULK_GRP.line_rec_type,
389 x_return_status OUT NOCOPY VARCHAR2);
390
391
392
393 END WSH_ASN_RECEIPT_PVT;