APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on WMS_BUS_EVENT_DEVICES

Line 662: wms_bus_event_devices wbed,

658:
659: begin
660: seLECT DEVICE_ID INTO dev_ID FROM
661: ( SELECT wbed.DEVICE_ID FROM
662: wms_bus_event_devices wbed,
663: wms_devices_b wd
664: WHERE
665: wd.device_id = wbed.device_id
666: AND WBED.organization_id = WD.organization_id

Line 726: wms_bus_event_devices wbed,

722:
723: BEGIN
724: SELECT DEVICE_ID INTO dev_ID FROM
725: ( SELECT wbed.DEVICE_ID FROM
726: wms_bus_event_devices wbed,
727: wms_devices_b wd
728: WHERE
729: wd.device_id = wbed.device_id
730: AND WBED.organization_id = WD.organization_id

Line 1539: FROM wms_bus_event_devices

1535:
1536: BEGIN
1537: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists
1538: (SELECT 1
1539: FROM wms_bus_event_devices
1540: WHERE business_event_id = p_bus_event);
1541:
1542: EXCEPTION
1543: WHEN NO_DATA_FOUND THEN

Line 2012: will not have any logic to resolve the API from the table wms_bus_event_devices

2008: /*
2009: This will be the overloaded device_request API which will be called
2010: from an OPM UI. The difference in this API is that, the caller will
2011: know the device_id to which the the request must be sent and the API
2012: will not have any logic to resolve the API from the table wms_bus_event_devices
2013:
2014: Inserting into WDR is kept transparent to the OPM team who will call this
2015: through a wrapper API in a group package
2016:

Line 2084: FROM wms_bus_event_devices

2080:
2081: BEGIN
2082: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists
2083: (SELECT 1
2084: FROM wms_bus_event_devices
2085: WHERE business_event_id = p_bus_event);
2086:
2087: EXCEPTION
2088: WHEN NO_DATA_FOUND THEN

Line 2724: FROM wms_bus_event_devices

2720:
2721: BEGIN
2722: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists
2723: (SELECT 1
2724: FROM wms_bus_event_devices
2725: WHERE business_event_id = p_bus_event_id
2726: AND organization_id = p_org_id
2727: and business_event_id < 50);
2728: