DBA Data[Home] [Help]

APPS.GMO_DVC_INTG_GRP dependencies on FND_TABLE_OF_VARCHAR2_255

Line 20: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,

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)

Line 21: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,

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:

Line 22: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

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

Line 23: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

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:

Line 128: l_parameter_id fnd_table_of_varchar2_255;

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:

Line 129: l_parameter_uom_defn fnd_table_of_varchar2_255;

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

Line 130: l_parameter_value fnd_table_of_varchar2_255;

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:

Line 131: l_parameter_uom fnd_table_of_varchar2_255;

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();

Line 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:

Line 136: l_parameter_uom_defn := 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:
140: FOR J IN 1..P_PARAMETER_ID.count LOOP

Line 137: l_parameter_value := fnd_table_of_varchar2_255();

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;

Line 138: l_parameter_uom := fnd_table_of_varchar2_255();

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);

Line 211: l_response_code fnd_table_of_varchar2_255;

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:

Line 212: l_response_value fnd_table_of_varchar2_255;

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

Line 230: l_response_code := fnd_table_of_varchar2_255();

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;