3605: msgid=>v_msgid
3606: );
3607: end loop;
3608: -- start listener for inbound queue
3609: wf_event.listen(G_INBOUND_QUEUE);
3610: -- start listener on transaction queue
3611: wf_event.listen(G_TRANSACTION_QUEUE);
3612: --delete from OKL_STREAM_TRX_DATA where transaction_number = p_doc_number;
3613: x_return_status := G_RET_STS_SUCCESS;
3607: end loop;
3608: -- start listener for inbound queue
3609: wf_event.listen(G_INBOUND_QUEUE);
3610: -- start listener on transaction queue
3611: wf_event.listen(G_TRANSACTION_QUEUE);
3612: --delete from OKL_STREAM_TRX_DATA where transaction_number = p_doc_number;
3613: x_return_status := G_RET_STS_SUCCESS;
3614: commit;
3615: exception