1 PACKAGE WSH_WMS_LPN_GRP AUTHID CURRENT_USER AS
2 /* $Header: WSHWLGPS.pls 120.1.12010000.1 2008/07/29 06:21:02 appldev ship $ */
3
4 g_call_group_api VARCHAR2(2) := 'Y';
5 g_update_to_container VARCHAR2(2) := 'N';
6 g_update_to_containers VARCHAR2(2) := 'N';
7 G_CALLBACK_REQUIRED VARCHAR2(2) := 'Y';
8 g_caller VARCHAR2(100);
9 g_hw_time_stamp DATE;
10 g_prev_hw_time_stamp DATE;
11
12 GK_WMS_PACK CONSTANT BOOLEAN := TRUE;
13 GK_INV_PACK CONSTANT BOOLEAN := FALSE;
14 GK_WMS_UNPACK CONSTANT BOOLEAN := TRUE;
15 GK_INV_UNPACK CONSTANT BOOLEAN := FALSE;
16 GK_WMS_ASSIGN_DLVY CONSTANT BOOLEAN := FALSE;
17 GK_INV_ASSIGN_DLVY CONSTANT BOOLEAN := FALSE;
18 GK_WMS_UNASSIGN_DLVY CONSTANT BOOLEAN := FALSE;
19 GK_INV_UNASSIGN_DLVY CONSTANT BOOLEAN := FALSE;
20 GK_WMS_UPD_KEY CONSTANT BOOLEAN := TRUE;
21 GK_INV_UPD_KEY CONSTANT BOOLEAN := TRUE;
22 GK_WMS_UPD_WV CONSTANT BOOLEAN := TRUE;
23 GK_INV_UPD_WV CONSTANT BOOLEAN := FALSE;
24 GK_WMS_UPD_FILL CONSTANT BOOLEAN := FALSE;
25 GK_INV_UPD_FILL CONSTANT BOOLEAN := FALSE;
26 GK_WMS_UPD_MISC CONSTANT BOOLEAN := FALSE;
27 GK_INV_UPD_MISC CONSTANT BOOLEAN := FALSE;
28 GK_WMS_UPD_PACK CONSTANT BOOLEAN := FALSE;
29 GK_INV_UPD_PACK CONSTANT BOOLEAN := FALSE;
30 GK_WMS_UPD_ITEM CONSTANT BOOLEAN := FALSE;
31 GK_INV_UPD_ITEM CONSTANT BOOLEAN := FALSE;
32 GK_WMS_UPD_FLEX CONSTANT BOOLEAN := FALSE;
33 GK_INV_UPD_FLEX CONSTANT BOOLEAN := FALSE;
34 GK_WMS_UPD_GRP CONSTANT BOOLEAN := FALSE;
35 GK_INV_UPD_GRP CONSTANT BOOLEAN := FALSE;
36 GK_WMS_UPD_INB_GRP CONSTANT BOOLEAN := FALSE;
37 GK_INV_UPD_INB_GRP CONSTANT BOOLEAN := FALSE;
38 GK_WMS_UPD_STS CONSTANT BOOLEAN := FALSE;
39 GK_INV_UPD_STS CONSTANT BOOLEAN := FALSE;
40 GK_WMS_UPD_DATE CONSTANT BOOLEAN := FALSE;
41 GK_INV_UPD_DATE CONSTANT BOOLEAN := FALSE;
42 GK_WMS_UPD_INV_CTRL CONSTANT BOOLEAN := FALSE;
43 GK_INV_UPD_INV_CTRL CONSTANT BOOLEAN := FALSE;
44 GK_WMS_UPD_QTY CONSTANT BOOLEAN := FALSE;
45 GK_INV_UPD_QTY CONSTANT BOOLEAN := FALSE;
46
47 --========================================================================
48 -- PROCEDURE : create_update_containers Must be called only by WMS APIs
49 --
50 -- PARAMETERS: p_api_version known api version error buffer
51 -- p_init_msg_list FND_API.G_TRUE to reset list
52 -- x_return_status return status
53 -- x_msg_count number of messages in the list
54 -- x_msg_data text of messages
55 -- p_in_rec Record for caller,
56 -- and action_code ( CREATE,UPDATE,
57 -- UPDATE_NULL)
58 -- p_detail_info_tab Table of attributes for the containers
59 -- x_OUT_rec not used (bms)
60 -- VERSION : current version 1.0
61 -- initial version 1.0
62 -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
63 -- specified in p_delivery_info
64 --========================================================================
65
66 PROCEDURE create_update_containers
67 ( p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2,
69 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_detail_info_tab IN OUT NOCOPY
74 WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type,
75 p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
76 x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
77 );
78
79
80 --========================================================================
81 -- PROCEDURE : Delivery_Detail_Action Must be called only by WMS APIs
82 --
83 -- PARAMETERS: p_api_version known api version error buffer
84 -- p_init_msg_list FND_API.G_TRUE to reset list
85 -- x_return_status return status
86 -- x_msg_count number of messages in the list
87 -- x_msg_data text of messages
88 -- p_lpn_id_tbl PLSQL table of LPN Ids for perform
89 -- any of the actions 'PACK', 'UNPACK'
90 -- 'ASSIGN', 'UNASSIGN'.
91 -- p_del_det_id_tbl PLSQL table of non-container delivery
92 -- lines to perform the same actions as above
93 -- p_action_prms Contains actions related parameters
94 -- like action_code that can take any of the
95 -- four values mentioned above.
96 -- caller should be something like 'WMS%'
97 -- lpn_rec must be populated for actions
98 -- 'PACK' or 'UNPACK'
99 -- x_defaults not used currenlty.
100 -- x_action_out_rec not used currenlty.
101 -- VERSION : current version 1.0
102 -- initial version 1.0
103 -- COMMENT : Performs any of the four actions as mentioned above i.e. 'PACK', 'UNPACK'
104 -- or 'ASSIGN', 'UNASSIGN'.
105 --========================================================================
106
107 PROCEDURE Delivery_Detail_Action
108 (
109 p_api_version_number IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_lpn_id_tbl IN wsh_util_core.id_tab_type,
116 p_del_det_id_tbl IN wsh_util_core.id_tab_type,
117 p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
118 x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type,
119 x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
120 );
121
122 --========================================================================
123 -- PROCEDURE : Check_purge Called only by WMS APIs
124 --
125 -- PARAMETERS: p_api_version known api version error buffer
126 -- p_init_msg_list FND_API.G_TRUE to reset list
127 -- x_return_status return status
128 -- x_msg_count number of messages in the list
129 -- x_msg_data text of messages
130 -- x_action_out_rec not used currenlty.
131 -- COMMENT : Validates if the container records identified by
132 -- p_lpn_rec.lpn_ids, are purgable. It populates the same table
133 -- with eligible records.
134 --========================================================================
135
136 PROCEDURE Check_purge
137 (
138 p_api_version_number IN NUMBER,
139 p_init_msg_list IN VARCHAR2,
140 p_commit IN VARCHAR2,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 P_lpn_rec IN OUT NOCOPY
145 WSH_GLBL_VAR_STRCT_GRP.purgeInOutRecType
146 );
147
148 --========================================================================
149 -- PROCEDURE : is_valid_consol
150 --
151 -- PARAMETERS: p_init_msg_list FND_API.G_TRUE to reset list
152 -- p_input_delivery_id_tab Table of delivery records to process
153 --
154 -- p_target_consol_delivery_id Table of delivery ids to process
155 -- x_deconsolidation_location deconsolidation location
156 -- x_msg_count Number of messages in the list
157 -- x_msg_data Text of messages
158 -- x_return_status Return status
159 -- COMMENT : This procedure is to find if a set of deliveries can be assigned to a consol delivery.
160 -- This procedure is called from WMS.
161 --
162 --========================================================================
163
164 PROCEDURE is_valid_consol( p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
165 p_input_delivery_id_tab IN WSH_UTIL_CORE.id_tab_type,
166 p_target_consol_delivery_id IN NUMBER,
167 p_caller IN VARCHAR2 DEFAULT NULL,
168 x_deconsolidation_location OUT NOCOPY NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2
172 );
173
174
175
176
177 END WSH_WMS_LPN_GRP;