APPS.WMS_CONTAINER_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

Line 3797: FROM rcv_transactions_interface

3793: END IF;
3794:
3795: SELECT COUNT(1)
3796: INTO l_valid
3797: FROM rcv_transactions_interface
3798: WHERE lpn_id = p_lpn_id
3799: OR transfer_lpn_id = p_lpn_id;
3800:
3801: IF l_valid > 0 THEN

Line 3803: mdebug('LPN : '||p_lpn_id||' has unprocessed records in rcv_transactions_interface table, cannot reuse');

3799: OR transfer_lpn_id = p_lpn_id;
3800:
3801: IF l_valid > 0 THEN
3802: IF l_debug = 1 THEN
3803: mdebug('LPN : '||p_lpn_id||' has unprocessed records in rcv_transactions_interface table, cannot reuse');
3804: END IF;
3805: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';
3806: RAISE l_transactions_pending;
3807: END IF;

Line 3805: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';

3801: IF l_valid > 0 THEN
3802: IF l_debug = 1 THEN
3803: mdebug('LPN : '||p_lpn_id||' has unprocessed records in rcv_transactions_interface table, cannot reuse');
3804: END IF;
3805: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';
3806: RAISE l_transactions_pending;
3807: END IF;
3808:
3809: SELECT COUNT(1)