118:
119: -- package cursor
120: CURSOR csr_get_tx_id
121: IS
122: SELECT hxc_transactions_s.NEXTVAL
123: FROM SYS.DUAL;
124:
125: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
126: IS
7816: -- p_exception_description - exception description
7817: -- p_rollback - is the retrieval being rolled back
7818: PROCEDURE update_transaction_status (
7819: p_process hxc_retrieval_processes.NAME%TYPE,
7820: p_status hxc_transactions.status%TYPE,
7821: p_exception_description hxc_transactions.exception_description%TYPE,
7822: p_rollback BOOLEAN DEFAULT FALSE
7823: )
7824: IS