APPS.WMS_CONTAINER_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

Line 3875: FROM rcv_transactions_interface

3871: END IF;
3872:
3873: SELECT COUNT(1)
3874: INTO l_valid
3875: FROM rcv_transactions_interface
3876: WHERE lpn_id = p_lpn_id
3877: OR transfer_lpn_id = p_lpn_id;
3878:
3879: IF l_valid > 0 THEN

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

3877: OR transfer_lpn_id = p_lpn_id;
3878:
3879: IF l_valid > 0 THEN
3880: IF l_debug = 1 THEN
3881: mdebug('LPN : '||p_lpn_id||' has unprocessed records in rcv_transactions_interface table, cannot reuse');
3882: END IF;
3883: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';
3884: RAISE l_transactions_pending;
3885: END IF;

Line 3883: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';

3879: IF l_valid > 0 THEN
3880: IF l_debug = 1 THEN
3881: mdebug('LPN : '||p_lpn_id||' has unprocessed records in rcv_transactions_interface table, cannot reuse');
3882: END IF;
3883: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';
3884: RAISE l_transactions_pending;
3885: END IF;
3886:
3887: SELECT COUNT(1)