DBA Data[Home] [Help]

APPS.GMO_DVC_INTG_PVT dependencies on GMO_CONSTANTS_GRP

Line 353: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,

349: procedure READ_DEVICE (P_RESOURCE_ID IN NUMBER,
350: P_DEVICE_ID IN NUMBER,
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,

Line 554: P_LOCK_UNLOCK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,

550: --This procedure reads the device.
551: procedure READ_DEVICE (P_DEVICE_ID IN NUMBER,
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,

Line 633: if (nvl (l_wcs_enabled, GMO_CONSTANTS_GRP.NO) = GMO_CONSTANTS_GRP.NO) then

629:
630: -- check if the organization is wcs enabled
631: -- this is required from wms architecture perspective
632:
633: if (nvl (l_wcs_enabled, GMO_CONSTANTS_GRP.NO) = GMO_CONSTANTS_GRP.NO) then
634:
635: open c_get_org_details;
636: fetch c_get_org_details into l_org_code;
637: close c_get_org_details;

Line 672: if (P_LOCK_UNLOCK = GMO_CONSTANTS_GRP.YES) THEN

668: end if;
669:
670:
671:
672: if (P_LOCK_UNLOCK = GMO_CONSTANTS_GRP.YES) THEN
673: l_is_device_locked := true;
674: LOCK_DEVICE (P_DEVICE_ID => P_DEVICE_ID,
675: P_REQUESTER => P_REQUESTER,
676: P_ORGANIZATION_ID => P_ORGANIZATION_ID,

Line 779: if (P_LOCK_UNLOCK = GMO_CONSTANTS_GRP.YES) THEN

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,
782: P_ORGANIZATION_ID => P_ORGANIZATION_ID,
783: X_RETURN_STATUS => l_return_status,