1 PACKAGE WMS_Task_Dispatch_Device AUTHID CURRENT_USER AS
2 /* $Header: WMSTKDVS.pls 120.4 2005/10/09 03:40:07 simran noship $ */
3
4
5 PROCEDURE insert_device
6 (p_Employee_Id IN NUMBER,
7 p_device_id IN NUMBER,
8 p_org_id IN NUMBER,
9 x_return_status OUT NOCOPY VARCHAR2);
10
11
12
13 PROCEDURE cleanup_device_and_tasks(
14 p_Employee_Id IN NUMBER,
15 p_org_id IN NUMBER,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2,
19 p_retain_dispatched_tasks IN VARCHAR2 default 'N');
20
21
22 /*
23 This is the overloaded procedure
24 It takes one additional parameter p_device_id
25 The call to sync_device
26 Deleting From Wms_device_assignment_temp &
27 Deleting or Updating WDT
28 will be only for that particular device
29 */
30 PROCEDURE cleanup_device_and_tasks(
31 p_Employee_Id IN NUMBER,
32 p_org_id IN NUMBER,
33 p_device_id IN NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_retain_dispatched_tasks IN VARCHAR2 default 'N');
38
39
40 PROCEDURE get_device_info(p_organization_id IN NUMBER,
41 p_device_name IN VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_device_id OUT NOCOPY NUMBER,
44 x_device_type OUT NOCOPY VARCHAR2,
45 x_device_desc OUT NOCOPY VARCHAR2,
46 x_subinventory OUT NOCOPY VARCHAR2,
47 p_emp_id IN NUMBER,
48 x_signed_onto_wrk_stn OUT NOCOPY VARCHAR2);
49
50
51 FUNCTION get_eligible_device(
52 p_organization_id IN NUMBER
53 , p_subinventory IN VARCHAR2
54 , p_locator_id IN NUMBER
55
56 ) return NUMBER;
57
58
59
60 END WMS_Task_Dispatch_Device;