DBA Data[Home] [Help]

APPS.GMO_DVC_INTG_PVT dependencies on FND_TABLE_OF_VARCHAR2_255

Line 355: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,

351: P_ORGANIZATION_ID IN NUMBER,
352: P_EVENT_ID IN NUMBER,
353: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
354: P_REQUESTER IN NUMBER,
355: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
356: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
357: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
358: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
359: X_DEVICE_STATUS OUT NOCOPY VARCHAR2,

Line 356: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,

352: P_EVENT_ID IN NUMBER,
353: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
354: P_REQUESTER IN NUMBER,
355: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
356: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
357: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
358: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
359: X_DEVICE_STATUS OUT NOCOPY VARCHAR2,
360: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 357: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

353: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
354: P_REQUESTER IN NUMBER,
355: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
356: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
357: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
358: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
359: X_DEVICE_STATUS OUT NOCOPY VARCHAR2,
360: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
361: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 358: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

354: P_REQUESTER IN NUMBER,
355: P_PARAMETER_ID IN FND_TABLE_OF_VARCHAR2_255,
356: P_PARAMETER_UOM_DEFN IN FND_TABLE_OF_VARCHAR2_255,
357: X_PARAMETER_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
358: X_PARAMETER_UOM OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
359: X_DEVICE_STATUS OUT NOCOPY VARCHAR2,
360: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
361: X_MSG_COUNT OUT NOCOPY NUMBER,
362: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 365: l_msg_component fnd_table_of_varchar2_255;

361: X_MSG_COUNT OUT NOCOPY NUMBER,
362: X_MSG_DATA OUT NOCOPY VARCHAR2)
363:
364: IS
365: l_msg_component fnd_table_of_varchar2_255;
366: l_param_id number;
367: l_response_code varchar2(30);
368: l_response_uom varchar2(30);
369: l_counter binary_integer;

Line 373: l_response_values fnd_table_of_varchar2_255;

369: l_counter binary_integer;
370: l_param_error varchar2(4000);
371: l_parameter_name varchar2(300);
372: l_parameter_map_err exception;
373: l_response_values fnd_table_of_varchar2_255;
374: l_uom_counter binary_integer;
375: l_value_counter binary_integer;
376:
377: l_uom_mismatch_err exception;

Line 385: l_msg_component := fnd_table_of_varchar2_255();

381: cursor c_get_msg_component is select RESP_COMP_CODE_VALUE, RESP_COMP_CODE_UOM from gmp_resource_device_messages where resource_id = P_RESOURCE_ID and device_id = P_DEVICE_ID and process_param_id = L_PARAM_ID AND EVENT_ID = P_EVENT_ID;
382: cursor c_get_parameter_details is select parameter_name from gmp_process_parameters where parameter_id = l_param_id;
383: BEGIN
384:
385: l_msg_component := fnd_table_of_varchar2_255();
386: l_counter := 0;
387:
388: FOR J IN 1..P_PARAMETER_ID.count LOOP
389: l_param_id := P_PARAMETER_ID(J);

Line 456: X_PARAMETER_UOM := fnd_table_of_varchar2_255();

452: X_MSG_COUNT => X_MSG_COUNT ,
453: X_MSG_DATA => X_MSG_DATA
454: );
455:
456: X_PARAMETER_UOM := fnd_table_of_varchar2_255();
457: X_PARAMETER_VALUE := fnd_table_of_varchar2_255();
458:
459: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN
460:

Line 457: X_PARAMETER_VALUE := fnd_table_of_varchar2_255();

453: X_MSG_DATA => X_MSG_DATA
454: );
455:
456: X_PARAMETER_UOM := fnd_table_of_varchar2_255();
457: X_PARAMETER_VALUE := fnd_table_of_varchar2_255();
458:
459: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN
460:
461: l_uom_counter := 0;

Line 556: P_MSG_COMPONENT IN FND_TABLE_OF_VARCHAR2_255,

552: P_ORGANIZATION_ID IN NUMBER,
553: P_EVENT_ID IN NUMBER,
554: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
555: P_REQUESTER IN NUMBER,
556: P_MSG_COMPONENT IN FND_TABLE_OF_VARCHAR2_255,
557: X_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
558: X_DEVICE_STATUS OUT NOCOPY VARCHAR2,
559: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
560: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 557: X_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

553: P_EVENT_ID IN NUMBER,
554: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
555: P_REQUESTER IN NUMBER,
556: P_MSG_COMPONENT IN FND_TABLE_OF_VARCHAR2_255,
557: X_VALUE OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
558: X_DEVICE_STATUS OUT NOCOPY VARCHAR2,
559: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
560: X_MSG_COUNT OUT NOCOPY NUMBER,
561: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 777: X_VALUE := fnd_table_of_varchar2_255();

773: end if;
774:
775: END LOOP;
776:
777: X_VALUE := fnd_table_of_varchar2_255();
778:
779: if (P_LOCK_UNLOCK = GMO_CONSTANTS_GRP.YES) THEN
780: UNLOCK_DEVICE(P_DEVICE_ID => P_DEVICE_ID,
781: P_REQUESTER => P_REQUESTER,