1 PACKAGE wms_bulk_pick AUTHID CURRENT_USER AS
2 /* $Header: WMSBKPIS.pls 120.0.12010000.1 2008/07/28 18:32:13 appldev ship $*/
3
4 --
5 -- File : WMSBKPIS.pls
6 -- Content : WMS_bulk_pick package specification
7 -- Description : WMS bulk picking API for mobile application
8 -- Notes :
9 -- Modified : 07/30/2003 jali created
10 --
11
12 TYPE bulk_input_rec IS RECORD
13 (organization_id NUMBER
14 ,start_mo_request_number VARCHAR2(30) :=null
15 ,end_mo_request_number VARCHAR2(30) :=null
16 ,start_release_date DATE :=null
17 ,end_release_date DATE :=null
18 ,subinventory_code VARCHAR2(30)
19 ,item_id NUMBER := null
20 ,delivery_id NUMBER := null
21 ,trip_id NUMBER := null
22 ,only_sub_item NUMBER := null);
23
24
25 --
26 PROCEDURE wms_concurrent_bulk_process(
27 errbuf OUT NOCOPY VARCHAR2
28 ,retcode OUT NOCOPY NUMBER
29 ,p_organization_id IN NUMBER
30 ,p_start_mo_request_number IN VARCHAR2 :=null
31 ,p_end_mo_request_number IN VARCHAR2 :=null
32 ,p_start_release_date IN VARCHAR2 :=null
33 ,p_end_release_date IN VARCHAR2 :=null
34 ,p_subinventory_code IN VARCHAR2 :=null
35 ,p_item_id IN NUMBER := null
36 ,p_delivery_id IN NUMBER := null
37 ,p_trip_id IN NUMBER := null
38 ,p_only_sub_item IN NUMBER := null);
39
40
41 PROCEDURE bulk_pick(p_temp_id IN NUMBER,
42 p_txn_hdr_id IN NUMBER,
43 p_org_id IN NUMBER,
44 p_multiple_pick IN VARCHAR2 := 'N', -- to indicate if this is multiple pick or not
45 p_exception IN VARCHAR2 := null, -- to indicate if this is over picking or not
46 p_lot_controlled IN VARCHAR2 := 'N',
47 p_user_id IN NUMBER,
48 p_employee_id IN NUMBER,
49 p_reason_id IN NUMBER,
50 x_new_txn_hdr_id OUT NOCOPY NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54
55
56 END wms_bulk_pick;
57