APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on WMS_DEVICE_REQUESTS_S

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 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