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 3082: IF (l_lpn_context = wms_container_pub.lpn_context_inv) THEN

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

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

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

Line 3271: ELSIF (l_lpn_context = wms_container_pub.lpn_context_intransit OR

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

Line 3272: l_lpn_context = wms_container_pub.lpn_context_vendor) THEN

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