DBA Data[Home] [Help]

PACKAGE: APPS.WMS_TASK_DISPATCH_DEVICE

Source


1 PACKAGE WMS_Task_Dispatch_Device 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;