834: from alr_actions
835: where action_id = p_action_id and
836: version_number = p_version_num;
837:
838: select alr_response_messages_s.nextval into seq from dual;
839: received := SYSDATE;
840:
841: insert into alr_response_messages(message_handle, node_handle,
842: application_id, alert_id, response_set_id, response_type,
837:
838: select alr_response_messages_s.nextval into seq from dual;
839: received := SYSDATE;
840:
841: insert into alr_response_messages(message_handle, node_handle,
842: application_id, alert_id, response_set_id, response_type,
843: response_id, response_message_id, date_processed,
844: to_recipients, cc_recipients, bcc_recipients, sent_from,
845: reply_to, subject, body, received)