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