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: p_deq_condition IN VARCHAR2 DEFAULT NULL, /* Bug 9410311 */
244: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
245: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
246: x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

Line 465: -- Default = DBMS_AQ.NO_WAIT

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

Line 467: -- Default = DBMS_AQ.REMOVE

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

Line 469: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,

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

Line 518: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,

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

Line 519: p_dequeue_mode IN VARCHAR2 DEFAULT DBMS_AQ.REMOVE,

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

Line 520: p_navigation IN VARCHAR2 DEFAULT DBMS_AQ.FIRST_MESSAGE,

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