DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on DBMS_AQ

Line 10670: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;

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;

Line 10671: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;

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;

Line 10672: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;

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;