1 PACKAGE WMS_RETURN_SV AUTHID CURRENT_USER AS
2 /* $Header: WMSRETNS.pls 115.5 2004/03/01 21:08:53 mankuma ship $ */
3
4 TYPE t_genref IS REF CURSOR;
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,
34 p_quantity IN NUMBER,
35 p_uom IN VARCHAR2,
36 p_serial_controlled IN NUMBER,
37 p_lot_controlled IN NUMBER,
38 p_org_id IN NUMBER,
39 p_subinventory IN VARCHAR2,
40 p_locator_id IN NUMBER
41 );
42
43 /*
44 ** This Procedure is called from the Corrections Form to Pack and Mark the LPN Contents
45 ** that are selected for Positive Correction on RECEIVE/RETURN TO VENDOR/RETURN TO CUSTOMER
46 */
47
48 PROCEDURE PACK_INTO_RECEIVING ( x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_rcv_trx_interface_id IN NUMBER,
52 p_ret_transaction_type IN VARCHAR2,
53 p_lpn_id IN NUMBER,
54 p_item_id IN NUMBER,
55 p_item_revision IN VARCHAR2,
56 p_quantity IN NUMBER,
57 p_uom IN VARCHAR2,
58 p_serial_controlled IN NUMBER,
59 p_lot_controlled IN NUMBER,
60 p_org_id IN NUMBER
61 );
62
63 /*
64 ** This procedure is called from Mobile Returns when the input LPN
65 ** is totally marked for Return.
66 */
67
68 PROCEDURE PROCESS_WHOLE_LPN_RETURN (
69 x_return_status OUT NOCOPY VARCHAR2, --1
70 x_msg_count OUT NOCOPY NUMBER, --2
71 x_msg_data OUT NOCOPY VARCHAR2, --3
72 p_org_id IN NUMBER, --4
73 p_lpn_id IN NUMBER, --5
74 p_txn_proc_mode IN VARCHAR2, --6
75 p_group_id IN NUMBER --7
76 );
77
78 /*
79 ** This procedure is called from Mobile Returns when the input LPN
80 ** is partially marked for Return.
81 */
82
83 PROCEDURE PROCESS_RETURNS (
84 x_return_status OUT NOCOPY VARCHAR2, --1
85 x_msg_count OUT NOCOPY NUMBER, --2
86 x_msg_data OUT NOCOPY VARCHAR2, --3
87 p_org_id IN NUMBER, --4
88 p_lpn_id IN NUMBER, --5
89 p_item_id IN NUMBER, --6
90 p_item_revision IN VARCHAR2, --7
91 p_uom IN VARCHAR2, --8
92 p_lot_code IN VARCHAR2, --9
93 p_serial_code IN VARCHAR2, --10
94 p_quantity IN NUMBER, --11
95 p_serial_controlled IN NUMBER, --12
96 p_lot_controlled IN NUMBER, --13
97 p_txn_proc_mode IN VARCHAR2, --14
98 p_group_id IN NUMBER, --15
99 p_to_lpn_id IN NUMBER --16
100 );
101
102 /*
103 ** This procedure is called from Mobile Returns to determine the
104 ** Receiving Processing Mode and Group ID from sequence that are used
105 ** to stamp on RTI. This single wrapper procedure is created so that Mobile
106 ** Returns visits Database only once to get both Receiving Processing Mode
107 ** and Group ID.
108 */
109
110 PROCEDURE GET_TRX_VALUES(
111 transaction_processor_value OUT NOCOPY VARCHAR2,
112 group_id OUT NOCOPY NUMBER);
113
114
115 /*
116 ** This procedure is called from Mobile Returns to launch the Receiving
117 ** Processor after setting the input group ID and receiving processing mode.
118 */
119
120 PROCEDURE RCV_PROCESS_WRAPPER(
121 x_return_status OUT NOCOPY VARCHAR2
122 , x_msg_data OUT NOCOPY VARCHAR2
123 , p_trx_proc_mode IN VARCHAR2
124 , p_group_id IN NUMBER);
125
126 /*
127 ** This procedure is called from Mobile Returns to get the suggested 'To LPN'
128 ** if any, for the input From LPN and Item.
129 */
130
131 PROCEDURE GET_SUGGESTED_TO_LPN(
132 x_lpn_lov OUT NOCOPY t_genref
133 , p_org_id IN NUMBER
134 , p_lpn_id IN NUMBER
135 , p_item_id IN NUMBER
136 , p_revision IN VARCHAR2);
137
138 /*
139 ** This Function is called from procedure 'GET_TRX_VALUES' to get Receiving
140 ** Processing Mode.
141 */
142
143 FUNCTION GET_TRX_PROC_MODE RETURN VARCHAR2;
144
145 /* This function is called from LOV Cursor procedure 'GET_RETURN_LPN' of
146 ** WMSLPNLB.pls to determine if the LPN is fully marked or partially marked.
147 */
148
149 FUNCTION GET_LPN_MARKED_STATUS (
150 p_lpn_id IN NUMBER,
151 p_org_id IN NUMBER) RETURN VARCHAR2;
152
153 g_pkg_name varchar2(30) := 'WMS_RETURN_SV';
154
155 /* This procedure is used to create a reservation during a Return. Called
156 ** from WMSTXERE.pld after creating an rcv_transaction_interface_record
157 */
158 PROCEDURE CREATE_RETURN_RESV(
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY VARCHAR2,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_org_id IN NUMBER,
163 p_item_id IN NUMBER,
164 p_revision IN VARCHAR2,
165 p_subinventory_code IN VARCHAR2,
166 p_locator_id IN NUMBER,
167 p_lpn_id IN NUMBER,
168 p_reservation_qty IN NUMBER,
169 p_unit_of_measure IN VARCHAR2,
170 p_requirement_date IN DATE,
171 p_dem_src_type_id IN NUMBER,
172 p_dem_src_hdr_id IN NUMBER,
173 p_dem_src_line_id IN NUMBER,
174 p_intf_txn_id IN NUMBER DEFAULT NULL);
175
176 END;