[Home] [Help]
PACKAGE: APPS.INV_PR_PICK_SLIP_NUMBER
Source
1 PACKAGE inv_pr_pick_slip_number AUTHID CURRENT_USER AS
2 /* $Header: INVPRPNS.pls 120.2 2005/10/10 07:30:39 methomas noship $ */
3
4 --
5 -- Package
6 -- INV_PR_PICK_SLIP_NUMBER
7 --
8 -- Purpose
9 -- This package does the following:
10 -- - Initialize variables to be used in determining the how to group pick slips.
11 -- - Get pick slip number
12 --
13
14 -- Used only by Shipping related GET_PICK_SLIP_NUMBER
15 /* FP-J PAR Replenishment Count:
16 Introduced four new columns dest_subinventory, dest_locator_id, project_id,
17 task_id to the RECORD TYPE. */
18 TYPE keyrectyp IS RECORD
19 ( grouping_rule_id NUMBER
20 , header_id NUMBER
21 , customer_id NUMBER
22 , ship_method_code VARCHAR2(30)
23 , ship_to_loc_id NUMBER
24 , shipment_priority VARCHAR2(30)
25 , subinventory VARCHAR2(10)
26 , dest_subinventory VARCHAR2(10)
27 , dest_locator_id NUMBER
28 , project_id NUMBER
29 , task_id NUMBER
30 , trip_stop_id NUMBER
31 , delivery_id NUMBER
32 , inventory_item_id NUMBER
33 , locator_id NUMBER
34 -- Increased lot size to 80 Char - Mercy Thomas - B4625329
35 , lot_number VARCHAR2(80)
36 , revision VARCHAR2(3)
37 , organization_id NUMBER
38 , pick_slip_number NUMBER
39 , counter NUMBER);
40
41 TYPE keytabtyp IS TABLE OF keyrectyp
42 INDEX BY BINARY_INTEGER;
43
44 g_pskey_table keytabtyp;
45 g_order_pick_method VARCHAR2(1) := '1';
46 g_zone_pick_method VARCHAR2(1) := '2';
47 g_cluster_pick_method VARCHAR2(1) := '3';
48 g_bulk_pick_method VARCHAR2(1) := '4';
49
50 --
51 -- Name
52 -- PROCEDURE GET_PICK_SLIP_NUMBER (Used by Shipping)
53 --
54 -- Purpose
55 -- Returns Pick Slip Number and whether a Pick Slip should be printed. This
56 -- overloaded procedure is used by Shipping.
57 --
58 -- Input Parameters
59 -- p_ps_mode => Pick Slip Print Mode: I = Immediate, E = Deferred
60 -- p_pick_grouping_rule_id => Pick Grouping Rule ID
61 -- p_org_id => Organization ID
62 -- p_header_id => Order Header ID
63 -- p_customer_id => Customer ID
64 -- p_ship_method_code => Ship Method
65 -- p_ship_to_loc_id => Ship to Location
66 -- p_shipment_priority => Shipment Priority
67 -- p_subinventory => SubInventory
68 -- p_trip_stop_id => Trip Stop
69 -- p_delivery_id => Delivery
70 -- p_inventory_item_id => Inventory Item ID
71 -- p_locator_id => Locator ID
72 -- p_lot_number => Lot Number
73 -- p_revision => Revision
74 /* FP-J PAR Replenishment Count:
75 Introduced four new DEFAULT NULL inputs dest_subinventory, dest_locator_id,
76 project_id, task_id to the signature of the procedure. */
77 -- p_dest_subinventory => Destination Subinventory
78 -- p_dest_locator_id => Destination Locator Id
79 -- p_project_id => Project Id
80 -- p_task_id => Task Id
81 --
82 -- Output Parameters
83 -- x_pick_slip_number => Pick Slip Number
84 -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
85 -- x_api_status => FND_API.G_RET_STS_SUCESSS or
86 -- FND_API.G_RET_STS_ERROR
87 -- x_error_message => Error message
88 --
89 PROCEDURE get_pick_slip_number
90 ( p_ps_mode IN VARCHAR2
91 , p_pick_grouping_rule_id IN NUMBER
92 , p_org_id IN NUMBER
93 , p_header_id IN NUMBER
94 , p_customer_id IN NUMBER
95 , p_ship_method_code IN VARCHAR2
96 , p_ship_to_loc_id IN NUMBER
97 , p_shipment_priority IN VARCHAR2
98 , p_subinventory IN VARCHAR2
99 , p_trip_stop_id IN NUMBER
100 , p_delivery_id IN NUMBER
101 , p_inventory_item_id IN NUMBER DEFAULT NULL
102 , p_locator_id IN NUMBER DEFAULT NULL
103 , p_lot_number IN VARCHAR2 DEFAULT NULL
104 , p_revision IN VARCHAR2 DEFAULT NULL
105 , x_pick_slip_number OUT NOCOPY NUMBER
106 , x_ready_to_print OUT NOCOPY VARCHAR2
107 , x_call_mode OUT NOCOPY VARCHAR2
108 , x_api_status OUT NOCOPY VARCHAR2
109 , x_error_message OUT NOCOPY VARCHAR2
110 , p_dest_subinventory IN VARCHAR2 DEFAULT NULL
111 , p_dest_locator_id IN NUMBER DEFAULT NULL
112 , p_project_id IN NUMBER DEFAULT NULL
113 , p_task_id IN NUMBER DEFAULT NULL
114 );
115
116 --
117 -- Name
118 -- PROCEDURE GET_PICK_SLIP_NUMBER (Used by Component Picking (WIP))
119 --
120 -- Purpose
121 -- Returns Pick Slip Number. This overloaded procedure is used for WIP.
122 --
123 -- Input Parameters
124 -- p_pick_grouping_rule_id => Pick Grouping Rule ID
125 -- p_org_id => Organization ID
126 -- p_wip_entity_id => WIP Entity ID
127 -- p_rep_schedule_id => Repetitive Schedule ID
128 -- p_operation_seq_num => Operation Sequence Number
129 -- p_dept_id => Department ID
130 -- p_push_or_pull => Push or Pull
131 -- p_supply_subinventory => Supply SubInventory
132 -- p_supply_locator_id => Supply Locator ID
133 -- p_project_id => Project ID
134 -- p_task_id => Task ID
135 -- p_src_subinventory => Source SubInventory
136 -- p_src_locator_id => Source Locator ID
137 -- p_inventory_item_id => Inventory Item ID
138 -- p_revision => Revision
139 -- p_lot_number => Lot Number
140 --
141 -- Output Parameters
142 -- x_pick_slip_number => Pick Slip Number
143 -- x_api_status => FND_API.G_RET_STS_SUCESSS or
144 -- FND_API.G_RET_STS_ERROR
145 -- x_error_message => Error message
146 --
147 PROCEDURE get_pick_slip_number
148 ( p_pick_grouping_rule_id IN NUMBER
149 , p_org_id IN NUMBER
150 , p_wip_entity_id IN NUMBER
151 , p_rep_schedule_id IN NUMBER DEFAULT NULL
152 , p_operation_seq_num IN NUMBER
153 , p_dept_id IN NUMBER
154 , p_push_or_pull IN VARCHAR2
155 , p_supply_subinventory IN VARCHAR2 DEFAULT NULL
156 , p_supply_locator_id IN NUMBER DEFAULT NULL
157 , p_project_id IN NUMBER DEFAULT NULL
158 , p_task_id IN NUMBER DEFAULT NULL
159 , p_src_subinventory IN VARCHAR2
160 , p_src_locator_id IN NUMBER DEFAULT NULL
161 , p_inventory_item_id IN NUMBER
162 , p_revision IN VARCHAR2 DEFAULT NULL
163 , p_lot_number IN VARCHAR2 DEFAULT NULL
164 , x_pick_slip_number OUT NOCOPY NUMBER
165 , x_api_status OUT NOCOPY VARCHAR2
166 , x_error_message OUT NOCOPY VARCHAR2
167 );
168
169 --
170 -- Name
171 -- PROCEDURE PRINT_PICK_SLIP (Used by Component Picking (WIP))
172 --
173 -- Purpose
174 -- Submits the Concurrent Request to print the Move Order Pick Slip Report.
175 --
176 -- Input Parameters
177 -- p_organization_id => Organization ID
178 -- p_mo_request_number => Move Order Request Number
179 --
180 -- Output Parameters
181 -- x_request_id => Concurrent Request ID
182 -- x_return_status => FND_API.G_RET_STS_SUCESSS or
183 -- FND_API.G_RET_STS_ERROR
184 -- x_msg_data => Error Messages
185 -- x_msg_count => Error Messages Count
186 FUNCTION print_pick_slip
187 ( x_return_status OUT NOCOPY VARCHAR2
188 , x_msg_data OUT NOCOPY VARCHAR2
189 , x_msg_count OUT NOCOPY NUMBER
190 , p_organization_id NUMBER
191 , p_mo_request_number NUMBER
192 , p_plan_tasks BOOLEAN
193 )
194 RETURN NUMBER;
195
196 --
197 -- Name
198 -- PROCEDURE DELETE_WIP_PS_TBL
199 --
200 -- Purpose
201 -- Deletes the global PL/SQL table used to store pick slip numbers
202 -- This is called at the end of component pick release
203 --
204 -- Input Parameters
205 -- None
206 --
207 -- Output Parameters
208 -- None
209 PROCEDURE delete_wip_ps_tbl;
210
211 --
212 -- Name
213 -- PROCEDURE GET_PICK_SLIP_NUMBER_PARALLEL
214 --
215 -- Purpose
216 -- Returns Pick Slip Number and whether a Pick Slip should be printed. This
217 -- procedure used by Shipping in pick-release parallel mode
218 -- WSH_PICK_LIST.G_PICK_REL_PARALLEL = TRUE.
219 --
220 -- Input Parameters
221 -- p_ps_mode => Pick Slip Print Mode: I = Immediate, E = Deferred
222 -- p_pick_grouping_rule_id => Pick Grouping Rule ID
223 -- p_org_id => Organization ID
224 -- p_header_id => Order Header ID
225 -- p_customer_id => Customer ID
226 -- p_ship_method_code => Ship Method
227 -- p_ship_to_loc_id => Ship to Location
228 -- p_shipment_priority => Shipment Priority
229 -- p_subinventory => SubInventory
230 -- p_trip_stop_id => Trip Stop
231 -- p_delivery_id => Delivery
232 -- p_inventory_item_id => Inventory Item ID
233 -- p_locator_id => Locator ID
234 -- p_lot_number => Lot Number
235 -- p_revision => Revision
236 -- p_dest_subinventory => Destination Subinventory
237 -- p_dest_locator_id => Destination Locator Id
238 -- p_project_id => Project Id
239 -- p_task_id => Task Id
240 --
241 -- Output Parameters
242 -- x_pick_slip_number => Pick Slip Number
243 -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
244 -- x_api_status => FND_API.G_RET_STS_SUCESSS or
245 -- FND_API.G_RET_STS_ERROR
246 -- x_error_message => Error message
247 --
248
249 PROCEDURE GET_PICK_SLIP_NUMBER_PARALLEL
250 ( p_ps_mode IN VARCHAR2
251 , p_pick_grouping_rule_id IN NUMBER
252 , p_org_id IN NUMBER
253 , p_header_id IN NUMBER
254 , p_customer_id IN NUMBER
255 , p_ship_method_code IN VARCHAR2
256 , p_ship_to_loc_id IN NUMBER
257 , p_shipment_priority IN VARCHAR2
258 , p_subinventory IN VARCHAR2
259 , p_trip_stop_id IN NUMBER
260 , p_delivery_id IN NUMBER
261 , p_inventory_item_id IN NUMBER DEFAULT NULL
262 , p_locator_id IN NUMBER DEFAULT NULL
263 , p_lot_number IN VARCHAR2 DEFAULT NULL
264 , p_revision IN VARCHAR2 DEFAULT NULL
265 , x_pick_slip_number OUT NOCOPY NUMBER
266 , x_ready_to_print OUT NOCOPY VARCHAR2
267 , x_call_mode OUT NOCOPY VARCHAR2
268 , x_api_status OUT NOCOPY VARCHAR2
269 , x_error_message OUT NOCOPY VARCHAR2
270 , p_dest_subinventory IN VARCHAR2
271 , p_dest_locator_id IN NUMBER
272 , p_project_id IN NUMBER
273 , p_task_id IN NUMBER
274 );
275
276
277 END inv_pr_pick_slip_number;