DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

Line 2484: FROM rcv_transactions_interface rti

2480: IF (p_trx_header_id IS NOT NULL) AND (p_trx_header_id <> -1 ) THEN
2481:
2482: SELECT Count(rti.interface_transaction_id)
2483: INTO l_count
2484: FROM rcv_transactions_interface rti
2485: WHERE rti.processing_status_code = 'RUNNING'
2486: AND rti.processing_mode_code = 'ONLINE'
2487: AND rti.transaction_status_code = 'PENDING'
2488: AND EXISTS

Line 2500: UPDATE rcv_transactions_interface rti

2496: SELECT rcv_interface_groups_s.NEXTVAL
2497: INTO l_group_id
2498: FROM dual;
2499:
2500: UPDATE rcv_transactions_interface rti
2501: SET group_id = l_group_id
2502: WHERE rti.processing_status_code = 'RUNNING'
2503: AND rti.processing_mode_code = 'ONLINE'
2504: AND rti.transaction_status_code = 'PENDING'