3556: cursor xml_data_csr( p_trx_number NUMBER) IS
3557: SELECT
3558: IN_XML
3559: FROM
3560: OKL_STREAM_TRX_DATA
3561: WHERE
3562: transaction_number = p_trx_number;
3563: BEGIN
3564: savepoint enq_message;
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
3616: when others then