118:
119: -- package cursor
120: CURSOR csr_get_tx_id
121: IS
122: SELECT hxc_transactions_s.NEXTVAL
123: FROM SYS.DUAL;
124:
125: -- Bug 9346163
126: -- Rewrote the cursor to pick nextval(s) from the sequence.
8921: -- p_exception_description - exception description
8922: -- p_rollback - is the retrieval being rolled back
8923: PROCEDURE update_transaction_status (
8924: p_process hxc_retrieval_processes.NAME%TYPE,
8925: p_status hxc_transactions.status%TYPE,
8926: p_exception_description hxc_transactions.exception_description%TYPE,
8927: p_rollback BOOLEAN DEFAULT FALSE
8928: )
8929: IS