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 151: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

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

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

291:
292: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
293: BEGIN
294:
295: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
296: x_request_id := l_request_id;
297:
298: IF (p_bus_event=WMS_BE_PICK_DROP) OR
299: ((p_bus_event=WMS_BE_PUTAWAY_DROP) AND (p_xfr_subinv IS NOT NULL)) THEN

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

406:
407: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
408: BEGIN
409:
410: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
411: x_request_id := l_request_id;
412:
413: IF (p_bus_event=WMS_BE_PICK_DROP) OR
414: ((p_bus_event=WMS_BE_PUTAWAY_DROP) AND (p_xfr_subinv IS NOT NULL)) THEN

Line 1042: SELECT 1 INTO l_detail_available FROM dual

1038: -- Bug 2762697: Lot information is not populated for device request
1039: -- The problem is that if there is more than one detail record
1040: -- The select into will fail
1041: -- Change to just check existence
1042: SELECT 1 INTO l_detail_available FROM dual
1043: WHERE exists(
1044: SELECT 1
1045: FROM wms_device_requests
1046: WHERE device_id = p_device_id

Line 1537: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists

1533: --If there is no record in the setup table for the concerned business
1534: --event then, return from here itself with success;
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:

Line 2082: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists

2078: --If there is no record in the setup table for the concerned business
2079: --event then, return from here itself with success;
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:

Line 2704: SELECT 1 INTO l_device_cnt FROM DUAL WHERE exists

2700:
2701: IF p_org_id IS NOT NULL THEN
2702: BEGIN
2703: --Check whether any device exist
2704: SELECT 1 INTO l_device_cnt FROM DUAL WHERE exists
2705: (SELECT 1
2706: FROM wms_devices_b
2707: WHERE ORGANIZATION_ID= p_org_id);
2708: EXCEPTION

Line 2722: SELECT 1 INTO l_setup_row_cnt FROM DUAL WHERE exists

2718: RETURN;
2719: ELSIF p_bus_event_id IS NOT NULL THEN --check in the association table between device and bus_event
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

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

2742:
2743: END IF ;
2744:
2745: END IF ;
2746: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
2747: wms_pkRel_dev_req_id := l_request_id;
2748:
2749: --global parameter wms_call_device_request is used in WMSCRTNB.pls
2750: IF p_bus_event_id = wms_be_pick_release then