1 PACKAGE wms_mdc_pvt AS
2 /* $Header: WMSVMDCS.pls 120.3.12010000.1 2008/07/28 18:37:51 appldev ship $ */
3
4 TYPE number_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5
6 -- Procedure to check if multiple LPNs LPN1, LPN2, ... can be packed into LPN0
7 PROCEDURE validate_to_lpn(p_from_lpn_ids IN number_table_type, -- LPN1, LPN2,...
8 p_from_delivery_ids IN number_table_type, -- Delivery1, Delivery2,...
9 p_to_lpn_id IN NUMBER, -- LPN0
10 p_to_sub IN VARCHAR2 DEFAULT NULL,
11 p_to_locator_id IN NUMBER DEFAULT NULL,
12 x_allow_packing OUT nocopy VARCHAR2,
13 x_return_status OUT nocopy VARCHAR2,
14 x_msg_count OUT nocopy NUMBER,
15 x_msg_data OUT nocopy VARCHAR2);
16
17 -- API to check if an LPN1 (delivery D1) can be packed into another LPN2
18 -- p_local_caller DEFAULT 'N', It will be passed as 'Y' when called from the overloaded
19 -- validate_to_lpn (used for mass_move functionality ). No one else should ever use it
20 -- x_allow_packing = Y, N, C, V
21 -- Y: Allow Packing
22 -- N: Do not Allow Packing
23 -- C: It is a consol Delivery. Next step in the calling module
24 -- is to Check the locator type of the staging locator or the TOLPNs locator.
25 -- This status is returned to lpn_mass_move API in WMSCONSB.pls
26 -- V: Needs further validations
27 -- This status is returned to overloaded API validate_to_lpn
28 -- The caller further validates the list of from LPNs and
29 -- TOLPN for AD/WD and aclls shipping API
30 --
31
32 PROCEDURE validate_to_lpn
33 (p_from_lpn_id IN NUMBER, -- LPN1
34 p_from_delivery_id IN NUMBER DEFAULT NULL, -- delivery ID for material in LPN1
35 p_to_lpn_id IN NUMBER, -- LPN2
36 p_is_from_to_delivery_same IN VARCHAR2, -- Y,N,U
37 p_is_from_lpn_mdc IN VARCHAR2 DEFAULT 'U',
38 p_is_to_lpn_mdc IN VARCHAR2 DEFAULT 'U',
39 p_to_sub IN VARCHAR2 DEFAULT NULL,
40 p_to_locator_id IN NUMBER DEFAULT NULL,
41 p_local_caller IN VARCHAR2 DEFAULT 'N',
42 x_allow_packing OUT nocopy VARCHAR2,
43 x_return_status OUT nocopy VARCHAR2,
44 x_msg_count OUT nocopy NUMBER,
45 x_msg_data OUT nocopy VARCHAR2);
46
47
48 -- API to suggest drop LPN, Subinventory and Locator
49 PROCEDURE suggest_to_lpn(p_lpn_id IN NUMBER, -- The LPN that is being dropped (from LPN)
50 p_delivery_id IN NUMBER, -- The delivery associated with the LPN
51 x_to_lpn_id OUT nocopy NUMBER, -- The LPN that is being dropped
52 x_to_subinventory_code OUT nocopy VARCHAR2, -- The subinventory of the suggested LPN
53 x_to_locator_id OUT nocopy NUMBER, -- The locator of the suggested LPN
54 x_return_status OUT nocopy VARCHAR2,
55 x_msg_count OUT nocopy NUMBER,
56 x_msg_data OUT nocopy VARCHAR2);
57
58 -- check if a delivery D1 can be shipped out
59 PROCEDURE can_ship_delivery(p_delivery_id NUMBER,
60 x_allow_shipping OUT nocopy VARCHAR2,
61 x_return_status OUT nocopy VARCHAR2,
62 x_msg_count OUT nocopy NUMBER,
63 x_msg_data OUT nocopy VARCHAR2);
64
65 -- Check if p_lpn_id belongs to a consolidation_delivery, if yes then It
66 -- returns consolidation delivery_id else it returns NULL
67
68 FUNCTION get_consol_delivery_id(p_lpn_id IN NUMBER) RETURN NUMBER ;
69
70 END wms_mdc_pvt;