DBA Data[Home] [Help]

APPS.WMS_RFID_DEVICE_PUB dependencies on WMS_CONTAINER_PUB

Line 491: IF (p_lpn_context = wms_container_pub.lpn_context_picked OR

487: trace('Inside is_valid_txn_device');
488: END IF;
489:
490:
491: IF (p_lpn_context = wms_container_pub.lpn_context_picked OR
492: p_lpn_context = wms_container_pub.lpn_context_inv) THEN
493:
494: BEGIN
495: SELECT business_event_id,verification_required INTO x_out_business_event_id,x_verif_req FROM wms_bus_event_devices

Line 492: p_lpn_context = wms_container_pub.lpn_context_inv) THEN

488: END IF;
489:
490:
491: IF (p_lpn_context = wms_container_pub.lpn_context_picked OR
492: p_lpn_context = wms_container_pub.lpn_context_inv) THEN
493:
494: BEGIN
495: SELECT business_event_id,verification_required INTO x_out_business_event_id,x_verif_req FROM wms_bus_event_devices
496: WHERE device_id = p_device_id

Line 514: ELSIF (p_lpn_context = wms_container_pub.lpn_context_intransit OR p_lpn_context = wms_container_pub.lpn_context_vendor) THEN

510: x_valid_device_for_txn := -1;
511: END;
512:
513:
514: ELSIF (p_lpn_context = wms_container_pub.lpn_context_intransit OR p_lpn_context = wms_container_pub.lpn_context_vendor) THEN
515:
516: BEGIN
517: SELECT business_event_id,verification_required INTO x_out_business_event_id,X_VERIF_REQ FROM wms_bus_event_devices
518: WHERE device_id = p_device_id

Line 3083: IF (l_lpn_context = wms_container_pub.lpn_context_inv) THEN

3079:
3080: --PROCESS THE ACTUAL TRANSACTION
3081: IF l_return_status ='S' THEN --Verification successful
3082:
3083: IF (l_lpn_context = wms_container_pub.lpn_context_inv) THEN
3084:
3085: IF (l_debug = 1) THEN
3086: trace('process_rfid_txn :Direct Ship');
3087: END IF;

Line 3175: ELSIF (l_lpn_context = wms_container_pub.lpn_context_picked ) THEN

3171:
3172: END IF; --FOR l_out_business_event_id
3173:
3174:
3175: ELSIF (l_lpn_context = wms_container_pub.lpn_context_picked ) THEN
3176: IF (l_debug = 1) THEN
3177: trace('process_rfid_txn :Normal LPN Ship');
3178: END IF;
3179:

Line 3272: ELSIF (l_lpn_context = wms_container_pub.lpn_context_intransit OR

3268: END IF;
3269:
3270: END IF;
3271:
3272: ELSIF (l_lpn_context = wms_container_pub.lpn_context_intransit OR
3273: l_lpn_context = wms_container_pub.lpn_context_vendor) THEN
3274:
3275: IF (l_debug = 1) THEN
3276: trace('process_rfid_txn : processing receiving txn');

Line 3273: l_lpn_context = wms_container_pub.lpn_context_vendor) THEN

3269:
3270: END IF;
3271:
3272: ELSIF (l_lpn_context = wms_container_pub.lpn_context_intransit OR
3273: l_lpn_context = wms_container_pub.lpn_context_vendor) THEN
3274:
3275: IF (l_debug = 1) THEN
3276: trace('process_rfid_txn : processing receiving txn');
3277: END IF;