16: P_ORGANIZATION_ID IN NUMBER,
17: P_EVENT_ID IN NUMBER,
18: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
19: P_REQUESTER IN NUMBER,
20: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
21: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
22: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
23: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
24: X_DEVICE_STATUS OUT NOCOPY VARCHAR2)
17: P_EVENT_ID IN NUMBER,
18: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
19: P_REQUESTER IN NUMBER,
20: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
21: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
22: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
23: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
24: X_DEVICE_STATUS OUT NOCOPY VARCHAR2)
25:
18: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
19: P_REQUESTER IN NUMBER,
20: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
21: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
22: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
23: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
24: X_DEVICE_STATUS OUT NOCOPY VARCHAR2)
25:
26: IS
19: P_REQUESTER IN NUMBER,
20: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
21: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
22: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
23: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
24: X_DEVICE_STATUS OUT NOCOPY VARCHAR2)
25:
26: IS
27:
124: X_DEVICE_STATUS OUT NOCOPY VARCHAR2)
125:
126: IS
127:
128: l_parameter_id fnd_table_of_varchar2_255;
129: l_parameter_uom_defn fnd_table_of_varchar2_255;
130: l_parameter_value fnd_table_of_varchar2_255;
131: l_parameter_uom fnd_table_of_varchar2_255;
132:
125:
126: IS
127:
128: l_parameter_id fnd_table_of_varchar2_255;
129: l_parameter_uom_defn fnd_table_of_varchar2_255;
130: l_parameter_value fnd_table_of_varchar2_255;
131: l_parameter_uom fnd_table_of_varchar2_255;
132:
133: BEGIN
126: IS
127:
128: l_parameter_id fnd_table_of_varchar2_255;
129: l_parameter_uom_defn fnd_table_of_varchar2_255;
130: l_parameter_value fnd_table_of_varchar2_255;
131: l_parameter_uom fnd_table_of_varchar2_255;
132:
133: BEGIN
134:
127:
128: l_parameter_id fnd_table_of_varchar2_255;
129: l_parameter_uom_defn fnd_table_of_varchar2_255;
130: l_parameter_value fnd_table_of_varchar2_255;
131: l_parameter_uom fnd_table_of_varchar2_255;
132:
133: BEGIN
134:
135: l_parameter_id := fnd_table_of_varchar2_255();
131: l_parameter_uom fnd_table_of_varchar2_255;
132:
133: BEGIN
134:
135: l_parameter_id := fnd_table_of_varchar2_255();
136: l_parameter_uom_defn := fnd_table_of_varchar2_255();
137: l_parameter_value := fnd_table_of_varchar2_255();
138: l_parameter_uom := fnd_table_of_varchar2_255();
139:
132:
133: BEGIN
134:
135: l_parameter_id := fnd_table_of_varchar2_255();
136: l_parameter_uom_defn := fnd_table_of_varchar2_255();
137: l_parameter_value := fnd_table_of_varchar2_255();
138: l_parameter_uom := fnd_table_of_varchar2_255();
139:
140: FOR J IN 1..P_PARAMETER_ID.count LOOP
133: BEGIN
134:
135: l_parameter_id := fnd_table_of_varchar2_255();
136: l_parameter_uom_defn := fnd_table_of_varchar2_255();
137: l_parameter_value := fnd_table_of_varchar2_255();
138: l_parameter_uom := fnd_table_of_varchar2_255();
139:
140: FOR J IN 1..P_PARAMETER_ID.count LOOP
141: l_parameter_id.EXTEND;
134:
135: l_parameter_id := fnd_table_of_varchar2_255();
136: l_parameter_uom_defn := fnd_table_of_varchar2_255();
137: l_parameter_value := fnd_table_of_varchar2_255();
138: l_parameter_uom := fnd_table_of_varchar2_255();
139:
140: FOR J IN 1..P_PARAMETER_ID.count LOOP
141: l_parameter_id.EXTEND;
142: l_parameter_id(J) := P_PARAMETER_ID(J);
207: IS
208:
209: l_api_name CONSTANT VARCHAR2(30) := 'READ_DEVICE';
210: l_api_version CONSTANT NUMBER := 1.0;
211: l_response_code fnd_table_of_varchar2_255;
212: l_response_value fnd_table_of_varchar2_255;
213:
214: BEGIN
215:
208:
209: l_api_name CONSTANT VARCHAR2(30) := 'READ_DEVICE';
210: l_api_version CONSTANT NUMBER := 1.0;
211: l_response_code fnd_table_of_varchar2_255;
212: l_response_value fnd_table_of_varchar2_255;
213:
214: BEGIN
215:
216: -- Standard Start of API savepoint
226: END IF;
227:
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230: l_response_code := fnd_table_of_varchar2_255();
231: l_response_code.extend;
232: l_response_code(1) := P_MSG_COMPONENT_PARAM;
233: l_response_code.extend;
234: l_response_code(2) := P_MSG_COMPONENT_UOM;