53: l_msg SYSTEM.AR_REV_REC_TYP;
54: l_reqid NUMBER := 0;
55: l_req_data VARCHAR2(2000);
56: --
57: l_nq_opts DBMS_AQ.ENQUEUE_OPTIONS_T;
58: l_msg_prop DBMS_AQ.MESSAGE_PROPERTIES_T;
59: --
60: l_recipients DBMS_AQ.AQ$_RECIPIENT_LIST_T;
61: --
54: l_reqid NUMBER := 0;
55: l_req_data VARCHAR2(2000);
56: --
57: l_nq_opts DBMS_AQ.ENQUEUE_OPTIONS_T;
58: l_msg_prop DBMS_AQ.MESSAGE_PROPERTIES_T;
59: --
60: l_recipients DBMS_AQ.AQ$_RECIPIENT_LIST_T;
61: --
62: l_msg_id RAW(16);
56: --
57: l_nq_opts DBMS_AQ.ENQUEUE_OPTIONS_T;
58: l_msg_prop DBMS_AQ.MESSAGE_PROPERTIES_T;
59: --
60: l_recipients DBMS_AQ.AQ$_RECIPIENT_LIST_T;
61: --
62: l_msg_id RAW(16);
63: l_dq_success BOOLEAN :=FALSE;
64: