1 PACKAGE GMO_DVC_INTG_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMOVDVCS.pls 120.1 2005/09/05 23:21 rahugupt noship $ */
3
4 --This procedure would lock the device.
5
6 -- Start of comments
7 -- API name : lock_device
8 -- Type : Private Utility.
9 -- Function : lock the device for the user
10 -- Pre-reqs : None.
11 -- Parameters :
12 -- IN : p_device_id in number
13 -- p_requester in number
14 -- p_organization_id in number
15 -- OUT : x_device_type out varchar2
16 -- x_device_desc out varchar2
17 -- x_subinventory out varchar2
18 -- x_return_status out varchar2
19 -- x_msg_count out number
20 -- x_msg_data out varchar2
21 -- End of comments
22
23
24 procedure LOCK_DEVICE (P_DEVICE_ID IN NUMBER,
25 P_REQUESTER IN NUMBER,
26 P_ORGANIZATION_ID IN NUMBER,
27 X_DEVICE_TYPE OUT NOCOPY VARCHAR2,
28 X_DEVICE_DESC OUT NOCOPY VARCHAR2,
29 X_SUBINVENTORY OUT NOCOPY VARCHAR2,
30 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31 X_MSG_COUNT OUT NOCOPY NUMBER,
32 X_MSG_DATA OUT NOCOPY VARCHAR2);
33
34
35 --This procdeure would unlock the device.
36
37 -- Start of comments
38 -- API name : unlock_device
39 -- Type : Private Utility.
40 -- Function : unlock the device for the user
41 -- Pre-reqs : None.
42 -- Parameters :
43 -- IN : p_device_id in number
44 -- p_requester in number
45 -- p_organization_id in number
46 -- OUT : x_return_status out varchar2
47 -- x_msg_count out number
48 -- x_msg_data out varchar2
49 -- End of comments
50
51 procedure UNLOCK_DEVICE (P_DEVICE_ID IN NUMBER,
52 P_REQUESTER IN NUMBER,
53 P_ORGANIZATION_ID IN NUMBER,
54 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55 X_MSG_COUNT OUT NOCOPY NUMBER,
56 X_MSG_DATA OUT NOCOPY VARCHAR2);
57
58
59 --This procdeure would clean the data from the temporary tables.
60
61 -- Start of comments
62 -- API name : temp_data_cleanup
63 -- Type : Private Utility.
64 -- Function : cleans up the temporary tables
65 -- Pre-reqs : None.
66 -- Parameters :
67 -- IN : p_cleanup_to_date in date default null
68 -- OUT : x_return_status out varchar2
69 -- x_msg_count out number
70 -- x_msg_data out varchar2
71 -- End of comments
72
73 procedure TEMP_DATA_CLEANUP (P_CLEANUP_TO_DATE IN DATE DEFAULT NULL,
74 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
75 X_MSG_COUNT OUT NOCOPY NUMBER,
76 X_MSG_DATA OUT NOCOPY VARCHAR2);
77
78
79 --This procedure reads the device.
80
81 -- Start of comments
82 -- API name : read_device
83 -- Type : Private Utility.
84 -- Function : reads the device
85 -- Pre-reqs : None.
86 -- Parameters :
87 -- IN : p_device_id in number
88 -- p_organization_id in number
89 -- p_event_id in number
90 -- p_lock_unlock in varchar2 default gmo_constants_grp.yes,
91 -- p_requester in number,
92 -- p_parameter_id in fnd_table_of_varchar2_255
93 -- p_parameter_uom_defn in fnd_table_of_varchar2_255
94 -- OUT : x_parameter_value out fnd_table_of_varchar2_255
95 -- x_parameter_uom out fnd_table_of_varchar2_255
96 -- x_device_status out varchar2
97 -- x_return_status out varchar2
98 -- x_msg_count out number
99 -- x_msg_data out varchar2
100 -- End of comments
101
102 procedure READ_DEVICE (P_RESOURCE_ID IN NUMBER,
103 P_DEVICE_ID IN NUMBER,
104 P_ORGANIZATION_ID IN NUMBER,
105 P_EVENT_ID IN NUMBER,
106 P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
107 P_REQUESTER IN NUMBER,
108 P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
109 P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
110 X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
111 X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
112 X_DEVICE_STATUS OUT NOCOPY VARCHAR2,
113 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
114 X_MSG_COUNT OUT NOCOPY NUMBER,
115 X_MSG_DATA OUT NOCOPY VARCHAR2);
116
117
118 --This procedure reads the device.
119
120 -- Start of comments
121 -- API name : read_device
122 -- Type : Private Utility.
123 -- Function : reads the device
124 -- Pre-reqs : None.
125 -- Parameters :
126 -- IN : p_device_id in number
127 -- p_organization_id in number
128 -- p_event_id in number
129 -- p_lock_unlock in varchar2 default gmo_constants_grp.yes,
130 -- p_requester in number,
131 -- p_msg_component in varchar2,
132 -- OUT : x_value out varchar2
133 -- x_device_status out varchar2
134 -- x_return_status out varchar2
135 -- x_msg_count out number
136 -- x_msg_data out varchar2
137 -- End of comments
138
139 procedure READ_DEVICE (P_DEVICE_ID IN NUMBER,
140 P_ORGANIZATION_ID IN NUMBER,
141 P_EVENT_ID IN NUMBER,
142 P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
143 P_REQUESTER IN NUMBER,
144 P_MSG_COMPONENT IN FND_TABLE_OF_VARCHAR2_255,
145 X_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
146 X_DEVICE_STATUS OUT NOCOPY VARCHAR2,
147 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
148 X_MSG_COUNT OUT NOCOPY NUMBER,
149 X_MSG_DATA OUT NOCOPY VARCHAR2);
150
151 --This procedure would process the device response
152
153 -- Start of comments
154 -- API name : PROCESS_DEVICE_RESPONSE
155 -- Type : Public Utility.
156 -- Function : Process device response
157 -- Pre-reqs : None.
158 -- Parameters :
159 -- IN : p_param_values_record in wms_wcs_device_grp.msg_component_lookup_type
160 -- OUT : x_return_status out varchar2
161 -- x_msg_count out number
162 -- x_msg_data out varchar2
163 -- End of comments
164
165 PROCEDURE PROCESS_DEVICE_RESPONSE ( P_REQUEST_ID IN NUMBER,
166 P_DEVICE_ID IN NUMBER,
167 P_PARAM_VALUES_RECORD IN WMS_WCS_DEVICE_GRP.MSG_COMPONENT_LOOKUP_TYPE,
168 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
169 X_MSG_COUNT OUT NOCOPY NUMBER,
170 X_MSG_DATA OUT NOCOPY VARCHAR2);
171
172 END GMO_DVC_INTG_PVT;