1 PACKAGE wms_pick_drop_pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSPKDPS.pls 120.2 2011/09/21 03:29:57 abasheer ship $ */
3
4 g_pkg_spec_ver CONSTANT VARCHAR2(100) := '$Header: WMSPKDPS.pls 120.2 2011/09/21 03:29:57 abasheer ship $';
5 g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_PICK_DROP_PVT';
6
7 TYPE t_genref IS REF CURSOR;
8
9
10 PROCEDURE chk_if_deconsolidate
11 ( x_multiple_drops OUT NOCOPY VARCHAR2
12 , x_drop_type OUT NOCOPY VARCHAR2
13 , x_bulk_pick OUT NOCOPY VARCHAR2
14 , x_drop_lpn_option OUT NOCOPY NUMBER
15 , x_delivery_id OUT NOCOPY NUMBER
16 , x_first_temp_id OUT NOCOPY NUMBER
17 , x_task_type OUT NOCOPY NUMBER
18 , x_txn_type_id OUT NOCOPY NUMBER
19 , x_return_status OUT NOCOPY VARCHAR2
20 , p_organization_id IN NUMBER
21 , p_transfer_lpn_id IN NUMBER
22 , p_suggestion_drop IN VARCHAR2 -- Added for bug 12853197
23 );
24
25
26
27 PROCEDURE fetch_next_drop
28 ( x_drop_type OUT NOCOPY VARCHAR2
29 , x_bulk_pick OUT NOCOPY VARCHAR2
30 , x_drop_lpn_option OUT NOCOPY NUMBER
31 , x_delivery_id OUT NOCOPY NUMBER
32 , x_tasks OUT NOCOPY t_genref
33 , x_lpn_done OUT NOCOPY VARCHAR2
34 , x_first_temp_id OUT NOCOPY NUMBER
35 , x_total_qty OUT NOCOPY NUMBER -- Added for bug 12853197
36 , x_task_type OUT NOCOPY NUMBER
37 , x_txn_type_id OUT NOCOPY NUMBER
38 , x_return_status OUT NOCOPY VARCHAR2
39 , p_organization_id IN NUMBER
40 , p_transfer_lpn_id IN NUMBER
41 );
42
43
44
45 PROCEDURE get_wip_job_info
46 ( x_entity_type OUT NOCOPY NUMBER
47 , x_job OUT NOCOPY VARCHAR2
48 , x_line OUT NOCOPY VARCHAR2
49 , x_dept OUT NOCOPY VARCHAR2
50 , x_operation_seq_num OUT NOCOPY NUMBER
51 , x_start_date OUT NOCOPY DATE
52 , x_schedule OUT NOCOPY VARCHAR2
53 , x_assembly OUT NOCOPY VARCHAR2
54 , x_return_status OUT NOCOPY VARCHAR2
55 , p_organization_id IN NUMBER
56 , p_transfer_lpn_id IN NUMBER
57 );
58
59
60
61 PROCEDURE get_sub_xfer_dest_info
62 (x_to_sub OUT NOCOPY VARCHAR2,
63 x_to_loc OUT NOCOPY VARCHAR2,
64 x_to_loc_id OUT NOCOPY NUMBER,
65 x_project_num OUT NOCOPY VARCHAR2,
66 x_prj_id OUT NOCOPY VARCHAR2,
67 x_task_num OUT NOCOPY VARCHAR2,
68 x_tsk_id OUT NOCOPY VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2,
70 p_organization_id IN NUMBER,
71 p_transfer_lpn_id IN NUMBER,
72 x_transfer_lpn_id OUT nocopy NUMBER,
73 x_transfer_lpn OUT nocopy VARCHAR2);
74
75
76 PROCEDURE get_default_drop_lpn
77 ( x_drop_lpn_num OUT NOCOPY VARCHAR2
78 , x_return_status OUT NOCOPY VARCHAR2
79 , p_organization_id IN NUMBER
80 , p_delivery_id IN NUMBER
81 , p_to_sub IN VARCHAR2
82 , p_to_loc IN NUMBER
83 );
84
85
86
87 PROCEDURE get_lot_lov
88 ( x_lot_lov OUT NOCOPY t_genref
89 , p_item_id IN NUMBER
90 , p_revision IN VARCHAR2
91 , p_inner_lpn IN VARCHAR2
92 , p_conf_uom_code IN VARCHAR2
93 , p_lot_num IN VARCHAR2
94 );
95
96
97
98 PROCEDURE get_serial_lov
99 ( x_serial_lov OUT NOCOPY t_genref
100 , p_item_id IN NUMBER
101 , p_revision IN VARCHAR2
102 , p_inner_lpn IN VARCHAR2
103 , p_lot_num IN VARCHAR2
104 , p_serial IN VARCHAR2
105 );
106
107
108
109 PROCEDURE process_inner_lpn
110 ( x_ret_code OUT NOCOPY NUMBER
111 , x_remaining_qty OUT NOCOPY NUMBER
112 , x_inner_lpn_exists OUT NOCOPY VARCHAR2
113 , x_return_status OUT NOCOPY VARCHAR2
114 , p_lpn IN VARCHAR2
115 , p_group_number IN NUMBER
116 , p_item_id IN NUMBER
117 , p_revision IN VARCHAR2
118 , p_qty IN NUMBER
119 , p_primary_uom IN VARCHAR2
120 , p_serial_control IN VARCHAR2
121 );
122
123
124
125 PROCEDURE process_loose_qty
126 ( x_loose_qty_exists OUT NOCOPY VARCHAR2
127 , x_return_status OUT NOCOPY VARCHAR2
128 , p_group_number IN NUMBER
129 , p_item_id IN NUMBER
130 , p_revision IN VARCHAR2
131 , p_qty IN NUMBER
132 , p_primary_uom IN VARCHAR2
133 );
134
135
136
137 PROCEDURE cancel_task
138 ( x_return_status OUT NOCOPY VARCHAR2
139 , p_organization_id IN NUMBER
140 , p_transfer_lpn_id IN NUMBER
141 );
142
143
144
145 PROCEDURE validate_xfer_to_lpn
146 ( x_return_status OUT NOCOPY VARCHAR2
147 , p_organization_id IN NUMBER
148 , p_transfer_lpn_id IN NUMBER
149 , p_group_number IN NUMBER
150 , p_outer_lpn_done IN VARCHAR2
151 , p_xfer_to_lpn IN VARCHAR2
152 , p_dest_sub IN VARCHAR2
153 , p_dest_loc_id IN NUMBER
154 , p_delivery_id IN NUMBER
155 );
156
157
158
159 PROCEDURE pick_drop
160 ( x_return_status OUT NOCOPY VARCHAR2
161 , p_organization_id IN NUMBER
162 , p_transfer_lpn_id IN NUMBER
163 , p_emp_id IN NUMBER
164 , p_drop_lpn IN VARCHAR2
165 , p_orig_subinv IN VARCHAR2
166 , p_subinventory IN VARCHAR2
167 , p_orig_locid IN VARCHAR2
168 , p_loc_id IN NUMBER
169 , p_reason_id IN NUMBER
170 , p_task_type IN NUMBER
171 , p_outer_lpn_done IN VARCHAR2
172 , p_bulk_drop IN VARCHAR2
173 );
174
175
176
177 PROCEDURE create_temp_id_list
178 ( x_temp_id_list OUT NOCOPY VARCHAR2
179 , x_return_status OUT NOCOPY VARCHAR2
180 , p_organization_id IN NUMBER
181 , p_transfer_lpn_id IN NUMBER
182 );
183
184
185
186 PROCEDURE process_serial
187 ( x_loose_qty_exists OUT NOCOPY VARCHAR2
188 , x_return_status OUT NOCOPY VARCHAR2
189 , p_organization_id IN NUMBER
190 , p_transfer_lpn_id IN NUMBER
191 , p_lpn IN VARCHAR2
192 , p_item_id IN NUMBER
193 , p_revision IN VARCHAR2
194 , p_lot_number IN VARCHAR2
195 , p_serial_number IN VARCHAR2
196 , p_group_number IN NUMBER
197 );
198
199
200
201 PROCEDURE get_delivery_info
202 ( x_delivery_name OUT NOCOPY VARCHAR2
203 , x_order_number OUT NOCOPY VARCHAR2
204 , x_return_status OUT NOCOPY VARCHAR2
205 , p_organization_id IN NUMBER
206 , p_transfer_lpn_id IN NUMBER
207 , p_delivery_id IN NUMBER
208 );
209
210
211
212 PROCEDURE process_conf_item
213 ( x_is_xref OUT NOCOPY VARCHAR2
214 , x_item_segs OUT NOCOPY VARCHAR2
215 , x_revision OUT NOCOPY VARCHAR2
216 , x_uom_code OUT NOCOPY VARCHAR2
217 , x_return_status OUT NOCOPY VARCHAR2
218 , p_organization_id IN NUMBER
219 , p_transfer_lpn_id IN NUMBER
220 , p_conf_item IN VARCHAR2
221 );
222
223
224
225 PROCEDURE validate_pick_drop_lpn
226 ( x_return_status OUT NOCOPY VARCHAR2
227 , p_organization_id IN NUMBER
228 , p_transfer_lpn_id IN NUMBER
229 , p_outer_lpn_done IN VARCHAR2
230 , p_drop_lpn IN VARCHAR2
231 , p_drop_sub IN VARCHAR2
232 , p_drop_loc_id IN NUMBER
233 , p_delivery_id IN NUMBER
234 );
235
236 END wms_pick_drop_pvt;