[Home] [Help]
PACKAGE: APPS.WMS_WCS_DEVICE_GRP
Source
1 PACKAGE WMS_WCS_DEVICE_GRP AS
2 /* $Header: WMSWCSS.pls 120.6 2005/10/09 03:48:26 simran noship $ */
3
4 --MHP
5 TYPE msg_component_lookup_type IS RECORD (
6 organization VARCHAR2 (200),
7 order_number NUMBER,
8 item VARCHAR2 (200),
9 business_event NUMBER,
10 action VARCHAR2 (4000),
11 device_id NUMBER,
12 host_id VARCHAR2 (400),
13 subinventory VARCHAR2 (400),
14 LOCATOR VARCHAR2 (400),
15 lpn VARCHAR2 (400),
16 lot VARCHAR2 (400),
17 uom VARCHAR2 (400),
18 cycle_count_id NUMBER,
19 quantity NUMBER,
20 requested_quantity NUMBER,
21 weight NUMBER,
22 weight_uom_code VARCHAR2 (400),
23 volume NUMBER,
24 volume_uom_code VARCHAR2 (400),
25 LENGTH NUMBER,
26 width NUMBER,
27 height NUMBER,
28 dimensional_weight NUMBER,
29 dimensional_weight_factor NUMBER,
30 net_weight NUMBER,
31 received_request_date_and_time DATE,
32 measurement_date_and_time DATE,
33 response_date_and_time DATE,
34 temperature NUMBER,
35 temperature_uom VARCHAR2 (400),
36 reason_id NUMBER,
37 reason_type VARCHAR2 (400),
38 sensor_measurement_type VARCHAR2 (400),
39 VALUE VARCHAR2 (400),
40 quality NUMBER,
41 opc_variant_code NUMBER,
42 epc VARCHAR2 (4000),
43 UNUSED VARCHAR2 (4000),
44 batch VARCHAR2 (400),
45 device_component_1 VARCHAR2 (4000),
46 device_component_2 VARCHAR2 (4000),
47 device_component_3 VARCHAR2 (4000),
48 device_component_4 VARCHAR2 (4000),
49 device_component_5 VARCHAR2 (4000),
50 device_component_6 VARCHAR2 (4000),
51 device_component_7 VARCHAR2 (4000),
52 device_component_8 VARCHAR2 (4000),
53 device_component_9 VARCHAR2 (4000),
54 device_component_10 VARCHAR2 (4000),
55 relation_id NUMBER,
56 task_id NUMBER,
57 task_summary VARCHAR2 (1),
58 organization_id NUMBER,
59 inventory_item_id NUMBER,
60 device_status VARCHAR2 (1),
61 transfer_lpn_id NUMBER,
62 destination_subinventory VARCHAR2 (400),
63 destination_locator_id NUMBER,
64 source_locator_id NUMBER
65 );
66 /*
67 * Call WMS_Task_Dispatch_Device.get_device_info
68 * And if the return status is "A" then it means that this device is already signed on.
69 * Throw an error WMS_DEVICE_ALREADY_SIGNED. And make the x_return_status of the Open API "E"
70 *
71 * If the return status is "S" then this device is valid.
72 * Call WMS_Task_Dispatch_Device. PROCEDURE insert_device
73 * And make the x_return_status of the Open API "S"
74 */
75 PROCEDURE DEVICE_SIGN_ON
76 (p_device_id IN NUMBER,
77 p_device_name IN VARCHAR2,
78 p_employee_id IN NUMBER,
79 p_organization_id IN NUMBER,
80 x_device_type OUT NOCOPY VARCHAR2,
81 x_device_desc OUT NOCOPY VARCHAR2,
82 x_subinventory OUT NOCOPY VARCHAR2,
83 x_signon_wrk_stn OUT NOCOPY VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2);
87
88 --Wrapper call on WMS_Task_Dispatch_Device.cleanup_device_and_tasks
89 PROCEDURE DEVICE_SIGN_OFF
90 (p_Employee_Id IN NUMBER,
91 p_org_id IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2);
95
96
97 --Wrapper call on overloaded WMS_Task_Dispatch_Device.cleanup_device_and_tasks
98 PROCEDURE SINGLE_DEVICE_SIGN_OFF
99 (p_Employee_Id IN NUMBER,
100 p_org_id IN NUMBER,
101 p_device_id IN NUMBER,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2);
105
106
107 --WMS-OPM
108 PROCEDURE DEVICE_REQUEST(
109 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
110 p_bus_event IN NUMBER,
111 p_call_ctx IN VARCHAR2 ,
112 p_task_trx_id IN NUMBER := NULL,
113 p_org_id IN NUMBER := NULL,
114 p_item_id IN NUMBER := NULL,
115 p_subinv IN VARCHAR2 := NULL,
116 p_locator_id IN NUMBER := NULL,
117 p_lpn_id IN NUMBER := NULL,
118 p_xfr_org_id IN NUMBER := NULL,
119 p_xfr_subinv IN VARCHAR2 := NULL,
120 p_xfr_locator_id IN NUMBER := NULL,
121 p_trx_qty IN NUMBER := NULL,
122 p_trx_uom IN VARCHAR2 := NULL,
123 p_rev IN VARCHAR2 := NULL,
124 x_request_msg OUT NOCOPY VARCHAR2,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_request_id IN OUT NOCOPY NUMBER,
129 p_device_id IN NUMBER
130 );
131
132 --Wrapper call on FUNCTION WMS_DEVICES_PKG.is_wcs_enabled
133 FUNCTION IS_WCS_ENABLED(p_org_id IN NUMBER)
134 RETURN VARCHAR2;
135
136 --API to process the parsed device response for WMS specific business events
137 PROCEDURE PROCESS_RESPONSE
138 (p_device_id IN NUMBER,
139 p_request_id IN NUMBER,
140 p_param_values_record IN MSG_COMPONENT_LOOKUP_TYPE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2);
144
145
146 END WMS_WCS_DEVICE_GRP;