eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_ORDER_FEEDBACK_PUB dependencies on DBMS_AQ

Line 193: -- Default = DBMS_AQ.NO_WAIT

189: --
190: -- GET_NOTICE API specific IN Parameters:
191: -- p_app_short_name IN VARCHAR2 Required
192: -- p_wait IN NUMBER Optional
193: -- Default = DBMS_AQ.NO_WAIT
194: --
195: -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
196: --
197: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 242: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,

238: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
239: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
240: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
241: p_app_short_name IN VARCHAR2,
242: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
243: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
244: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
245: x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
246: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,

Line 464: -- Default = DBMS_AQ.NO_WAIT

460: --
461: -- GET_EXCEPTION API specific IN Parameters:
462: -- p_app_short_name IN VARCHAR2 Required
463: -- p_wait IN NUMBER Optional
464: -- Default = DBMS_AQ.NO_WAIT
465: -- p_dequeue_mode IN VARCHAR2 Optional
466: -- Default = DBMS_AQ.REMOVE
467: -- p_navigation IN VARCHAR2 Optional
468: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,

Line 466: -- Default = DBMS_AQ.REMOVE

462: -- p_app_short_name IN VARCHAR2 Required
463: -- p_wait IN NUMBER Optional
464: -- Default = DBMS_AQ.NO_WAIT
465: -- p_dequeue_mode IN VARCHAR2 Optional
466: -- Default = DBMS_AQ.REMOVE
467: -- p_navigation IN VARCHAR2 Optional
468: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,
469: --
470: -- GET_EXCEPTION API specific OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 468: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,

464: -- Default = DBMS_AQ.NO_WAIT
465: -- p_dequeue_mode IN VARCHAR2 Optional
466: -- Default = DBMS_AQ.REMOVE
467: -- p_navigation IN VARCHAR2 Optional
468: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,
469: --
470: -- GET_EXCEPTION API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
471: --
472: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 517: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,

513: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
514: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
515: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
516: p_app_short_name IN VARCHAR2,
517: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
518: p_dequeue_mode IN VARCHAR2 DEFAULT DBMS_AQ.REMOVE,
519: p_navigation IN VARCHAR2 DEFAULT DBMS_AQ.FIRST_MESSAGE,
520: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
521: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

Line 518: p_dequeue_mode IN VARCHAR2 DEFAULT DBMS_AQ.REMOVE,

514: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
515: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
516: p_app_short_name IN VARCHAR2,
517: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
518: p_dequeue_mode IN VARCHAR2 DEFAULT DBMS_AQ.REMOVE,
519: p_navigation IN VARCHAR2 DEFAULT DBMS_AQ.FIRST_MESSAGE,
520: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
521: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
522: x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

Line 519: p_navigation IN VARCHAR2 DEFAULT DBMS_AQ.FIRST_MESSAGE,

515: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
516: p_app_short_name IN VARCHAR2,
517: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
518: p_dequeue_mode IN VARCHAR2 DEFAULT DBMS_AQ.REMOVE,
519: p_navigation IN VARCHAR2 DEFAULT DBMS_AQ.FIRST_MESSAGE,
520: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
521: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
522: x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
523: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,