APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on DUAL

Line 46: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

42:
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44: BEGIN
45:
46: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
47: x_request_id := l_request_id;
48:
49: SELECT wdd1.organization_id,
50: wdd1.subinventory,

Line 152: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

148:
149: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
150: BEGIN
151:
152: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
153: x_request_id := l_request_id;
154:
155: SELECT organization_id,
156: subinventory_code,

Line 303: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

299:
300: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
301: BEGIN
302:
303: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
304: x_request_id := l_request_id;
305:
306: --Added for Bug#8778050 start
307:

Line 430: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

426:
427: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
428: BEGIN
429:
430: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
431: x_request_id := l_request_id;
432:
433: IF (p_bus_event=WMS_BE_PICK_DROP) OR
434: ((p_bus_event=WMS_BE_PUTAWAY_DROP) AND (p_xfr_subinv IS NOT NULL)) THEN

Line 1063: SELECT 1 INTO l_detail_available FROM dual

1059: -- Bug 2762697: Lot information is not populated for device request
1060: -- The problem is that if there is more than one detail record
1061: -- The select into will fail
1062: -- Change to just check existence
1063: SELECT 1 INTO l_detail_available FROM dual
1064: WHERE exists(
1065: SELECT 1
1066: FROM wms_device_requests
1067: WHERE device_id = p_device_id

Line 1576: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists

1572: --If there is no record in the setup table for the concerned business
1573: --event then, return from here itself with success;
1574:
1575: BEGIN
1576: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists
1577: (SELECT 1
1578: FROM wms_bus_event_devices
1579: WHERE business_event_id = p_bus_event);
1580:

Line 2166: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists

2162: --If there is no record in the setup table for the concerned business
2163: --event then, return from here itself with success;
2164:
2165: BEGIN
2166: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists
2167: (SELECT 1
2168: FROM wms_bus_event_devices
2169: WHERE business_event_id = p_bus_event);
2170:

Line 2788: SELECT 1 INTO l_device_cnt FROM DUAL WHERE exists

2784:
2785: IF p_org_id IS NOT NULL THEN
2786: BEGIN
2787: --Check whether any device exist
2788: SELECT 1 INTO l_device_cnt FROM DUAL WHERE exists
2789: (SELECT 1
2790: FROM wms_devices_b
2791: WHERE ORGANIZATION_ID= p_org_id);
2792: EXCEPTION

Line 2806: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists

2802: RETURN;
2803: ELSIF p_bus_event_id IS NOT NULL THEN --check in the association table between device and bus_event
2804:
2805: BEGIN
2806: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists
2807: (SELECT 1
2808: FROM wms_bus_event_devices
2809: WHERE business_event_id = p_bus_event_id
2810: AND organization_id = p_org_id

Line 2830: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

2826:
2827: END IF ;
2828:
2829: END IF ;
2830: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
2831: wms_pkRel_dev_req_id := l_request_id;
2832:
2833: --global parameter wms_call_device_request is used in WMSCRTNB.pls
2834: IF p_bus_event_id = wms_be_pick_release then