10666: l_return_status VARCHAR2(1);
10667: l_msg_count NUMBER;
10668: l_msg_data VARCHAR2(240);
10669: l_msg_index NUMBER;
10670: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;
10671: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
10672: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
10673: l_no_more_messages VARCHAR2(240);
10674: l_header_rec OE_Order_PUB.Header_Rec_Type;
10667: l_msg_count NUMBER;
10668: l_msg_data VARCHAR2(240);
10669: l_msg_index NUMBER;
10670: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;
10671: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
10672: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
10673: l_no_more_messages VARCHAR2(240);
10674: l_header_rec OE_Order_PUB.Header_Rec_Type;
10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
10668: l_msg_data VARCHAR2(240);
10669: l_msg_index NUMBER;
10670: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;
10671: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
10672: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
10673: l_no_more_messages VARCHAR2(240);
10674: l_header_rec OE_Order_PUB.Header_Rec_Type;
10675: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
10676: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;