4 TYPE t_genref IS REF CURSOR;
1 PACKAGE WMS_RETURN_SV AUTHID CURRENT_USER AS
2 /* $Header: WMSRETNS.pls 120.0.12020000.3 2013/03/19 14:42:34 ssingams ship $ */
3
5
6 /* Called from INVRCVFB.pls
7 ** This procedure is used to unpack LPN for Return To Vendor and Correction
8 ** Transactions with parent transaction type = RECEIVING as Inventory Manager
9 ** is not called for these transactions.
10 */
11
12 PROCEDURE txn_complete(
13 p_group_id IN NUMBER,
14 p_txn_status IN VARCHAR2, -- TRUE/FALSE
15 p_txn_mode IN VARCHAR2, -- ONLINE/IMMEDIATE
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_data OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER);
19
20 /*
21 ** This Procedure is called from the Returns/Corrections Form to Mark the LPN Contents
22 ** that are selected for return/correction.
23 */
24
25 PROCEDURE mark_returns (
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_rcv_trx_interface_id IN NUMBER,
30 p_ret_transaction_type IN VARCHAR2,
31 p_lpn_id IN NUMBER,
32 p_item_id IN NUMBER,
33 p_item_revision IN VARCHAR2,
37 p_lot_controlled IN NUMBER,
34 p_quantity IN NUMBER,
35 p_uom IN VARCHAR2,
36 p_serial_controlled IN NUMBER,
38 p_org_id IN NUMBER,
39 p_subinventory IN VARCHAR2,
40 p_locator_id IN NUMBER
41 );
42
43 /*
44 --16197273
45 --Description:API to unmark the wms_lpn_contents table at the time of processing new rti/mti.
46 --This api will be called from RTV specific package :RCVWSHIB.pls
47 */
48
49 PROCEDURE unmark_returns (
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_rcv_trx_interface_id IN NUMBER,
54 p_ret_transaction_type IN VARCHAR2,
55 p_lpn_id IN NUMBER,
56 p_item_id IN NUMBER,
57 p_item_revision IN VARCHAR2,
58 p_org_id IN NUMBER,
59 p_lot_number IN VARCHAR2 );
60
61
62
63 /*
64 --16197273
65 --Description:API to create container WDD and WDA for Return order.
66 --This api will be called from RTV specific package :RCVWSHIB.pls
67
68 */
69
70 PROCEDURE Create_Update_Containers_RTV (
71 x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73 , x_msg_data OUT NOCOPY VARCHAR2
74 , p_interface_txn_id IN NUMBER
75 , p_wdd_table WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type
76
77 );
78
79 /*
80 --16197273/16514543
81 --Description;API created to do post TM updates from WMS side .
82
83 */
84
85 PROCEDURE perform_post_TM_wms_updates (
86 x_return_status OUT NOCOPY VARCHAR2
87 ,x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2
89 ,p_rcv_trx_interface_id IN NUMBER
90 ,p_ship_flag IN VARCHAR2 ) ;
91
92 /*
93 --16514543
94 --Description:Chnages done to Unpack qty from LPN ,in case of Partial Cancelation of Return Order.
95 --This api will be called from RTV specific package :RCVWSHIB.pls
96 */
97
98
99
100 PROCEDURE cancel_return_order_RTV (
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_rtv_order IN NUMBER
105 );
106
107 /*
108 ** This Procedure is called from the Corrections Form to Pack and Mark the LPN Contents
109 ** that are selected for Positive Correction on RECEIVE/RETURN TO VENDOR/RETURN TO CUSTOMER
110 */
111
112 PROCEDURE PACK_INTO_RECEIVING ( x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_rcv_trx_interface_id IN NUMBER,
116 p_ret_transaction_type IN VARCHAR2,
117 p_lpn_id IN NUMBER,
118 p_item_id IN NUMBER,
119 p_item_revision IN VARCHAR2,
120 p_quantity IN NUMBER,
121 p_uom IN VARCHAR2,
122 p_serial_controlled IN NUMBER,
123 p_lot_controlled IN NUMBER,
124 p_org_id IN NUMBER
125 );
126
127 /*
128 ** This procedure is called from Mobile Returns when the input LPN
129 ** is totally marked for Return.
130 */
131
132 PROCEDURE PROCESS_WHOLE_LPN_RETURN (
133 x_return_status OUT NOCOPY VARCHAR2, --1
134 x_msg_count OUT NOCOPY NUMBER, --2
135 x_msg_data OUT NOCOPY VARCHAR2, --3
136 p_org_id IN NUMBER, --4
137 p_lpn_id IN NUMBER, --5
138 p_txn_proc_mode IN VARCHAR2, --6
139 p_group_id IN NUMBER --7
140 );
141
142 /*
143 ** This procedure is called from Mobile Returns when the input LPN
144 ** is partially marked for Return.
145 */
146
147 PROCEDURE PROCESS_RETURNS (
148 x_return_status OUT NOCOPY VARCHAR2, --1
149 x_msg_count OUT NOCOPY NUMBER, --2
150 x_msg_data OUT NOCOPY VARCHAR2, --3
151 p_org_id IN NUMBER, --4
152 p_lpn_id IN NUMBER, --5
153 p_item_id IN NUMBER, --6
154 p_item_revision IN VARCHAR2, --7
158 p_quantity IN NUMBER, --11
155 p_uom IN VARCHAR2, --8
156 p_lot_code IN VARCHAR2, --9
157 p_serial_code IN VARCHAR2, --10
159 p_serial_controlled IN NUMBER, --12
160 p_lot_controlled IN NUMBER, --13
161 p_txn_proc_mode IN VARCHAR2, --14
162 p_group_id IN NUMBER, --15
163 p_to_lpn_id IN NUMBER --16
164 );
165
166 /*
167 ** This procedure is called from Mobile Returns to determine the
168 ** Receiving Processing Mode and Group ID from sequence that are used
169 ** to stamp on RTI. This single wrapper procedure is created so that Mobile
170 ** Returns visits Database only once to get both Receiving Processing Mode
171 ** and Group ID.
172 */
173
174 PROCEDURE GET_TRX_VALUES(
175 transaction_processor_value OUT NOCOPY VARCHAR2,
176 group_id OUT NOCOPY NUMBER);
177
178
179 /*
180 ** This procedure is called from Mobile Returns to launch the Receiving
181 ** Processor after setting the input group ID and receiving processing mode.
182 */
183
184 PROCEDURE RCV_PROCESS_WRAPPER(
185 x_return_status OUT NOCOPY VARCHAR2
186 , x_msg_data OUT NOCOPY VARCHAR2
187 , p_trx_proc_mode IN VARCHAR2
188 , p_group_id IN NUMBER);
189
190 /*
191 ** This procedure is called from Mobile Returns to get the suggested 'To LPN'
192 ** if any, for the input From LPN and Item.
193 */
194
195 PROCEDURE GET_SUGGESTED_TO_LPN(
196 x_lpn_lov OUT NOCOPY t_genref
197 , p_org_id IN NUMBER
198 , p_lpn_id IN NUMBER
199 , p_item_id IN NUMBER
200 , p_revision IN VARCHAR2);
201
202 /*
203 ** This Function is called from procedure 'GET_TRX_VALUES' to get Receiving
204 ** Processing Mode.
205 */
206
207 FUNCTION GET_TRX_PROC_MODE RETURN VARCHAR2;
208
209 /* This function is called from LOV Cursor procedure 'GET_RETURN_LPN' of
210 ** WMSLPNLB.pls to determine if the LPN is fully marked or partially marked.
211 */
212
213 FUNCTION GET_LPN_MARKED_STATUS (
214 p_lpn_id IN NUMBER,
215 p_org_id IN NUMBER) RETURN VARCHAR2;
216
217 g_pkg_name varchar2(30) := 'WMS_RETURN_SV';
218
219 /* This procedure is used to create a reservation during a Return. Called
220 ** from WMSTXERE.pld after creating an rcv_transaction_interface_record
221 */
222 PROCEDURE CREATE_RETURN_RESV(
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY VARCHAR2,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_org_id IN NUMBER,
227 p_item_id IN NUMBER,
228 p_revision IN VARCHAR2,
229 p_subinventory_code IN VARCHAR2,
230 p_locator_id IN NUMBER,
231 p_lpn_id IN NUMBER,
232 p_reservation_qty IN NUMBER,
233 p_unit_of_measure IN VARCHAR2,
234 p_requirement_date IN DATE,
235 p_dem_src_type_id IN NUMBER,
236 p_dem_src_hdr_id IN NUMBER,
237 p_dem_src_line_id IN NUMBER,
238 p_intf_txn_id IN NUMBER DEFAULT NULL);
239
240 END;