461: BEGIN
462:
463: SELECT max(transaction_id)
464: INTO l_transaction_id
465: FROM icx_transactions
466: WHERE session_id = icx_sec.g_session_id
467: AND responsibility_id = icx_sec.g_responsibility_id
468: AND security_group_id = icx_sec.g_security_group_id
469: AND function_id = icx_sec.g_function_id
471:
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN
474:
475: SELECT icx_transactions_s.nextval
476: INTO l_transaction_id
477: FROM sys.dual;
478:
479: END;