DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on DBMS_AQ

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

11682: l_return_status VARCHAR2(1);
11683: l_msg_count NUMBER;
11684: l_msg_data VARCHAR2(240);
11685: l_msg_index NUMBER;
11686: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;
11687: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
11688: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
11689: l_no_more_messages VARCHAR2(240);
11690: l_header_rec OE_Order_PUB.Header_Rec_Type;

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

11683: l_msg_count NUMBER;
11684: l_msg_data VARCHAR2(240);
11685: l_msg_index NUMBER;
11686: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;
11687: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
11688: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
11689: l_no_more_messages VARCHAR2(240);
11690: l_header_rec OE_Order_PUB.Header_Rec_Type;
11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

Line 11688: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;

11684: l_msg_data VARCHAR2(240);
11685: l_msg_index NUMBER;
11686: l_dequeue_mode VARCHAR2(240) DEFAULT DBMS_AQ.REMOVE;
11687: l_navigation VARCHAR2(240) DEFAULT DBMS_AQ.NEXT_MESSAGE;
11688: l_wait NUMBER DEFAULT DBMS_AQ.NO_WAIT;
11689: l_no_more_messages VARCHAR2(240);
11690: l_header_rec OE_Order_PUB.Header_Rec_Type;
11691: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
11692: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;