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 598: -- Default = DBMS_AQ.NO_WAIT

594: --
595: -- GET_NOTICE API specific IN Parameters:
596: -- p_app_short_name IN VARCHAR2 Required
597: -- p_wait IN NUMBER Optional
598: -- Default = DBMS_AQ.NO_WAIT
599: --
600: -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
601: --
602: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 647: p_wait IN NUMBER := DBMS_AQ.NO_WAIT,

643: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
644: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
645: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
646: p_app_short_name IN VARCHAR2,
647: p_wait IN NUMBER := DBMS_AQ.NO_WAIT,
648: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
649: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
650: x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
651: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,

Line 1151: -- Default = DBMS_AQ.NO_WAIT

1147: --
1148: -- GET_EXCEPTION API specific IN Parameters:
1149: -- p_app_short_name IN VARCHAR2 Required
1150: -- p_wait IN NUMBER Optional
1151: -- Default = DBMS_AQ.NO_WAIT
1152: -- p_dequeue_mode IN VARCHAR2 Optional
1153: -- Default = DBMS_AQ.REMOVE
1154: -- p_navigation IN VARCHAR2 Optional
1155: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,

Line 1153: -- Default = DBMS_AQ.REMOVE

1149: -- p_app_short_name IN VARCHAR2 Required
1150: -- p_wait IN NUMBER Optional
1151: -- Default = DBMS_AQ.NO_WAIT
1152: -- p_dequeue_mode IN VARCHAR2 Optional
1153: -- Default = DBMS_AQ.REMOVE
1154: -- p_navigation IN VARCHAR2 Optional
1155: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,
1156: --
1157: -- GET_EXCEPTION API specific OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 1155: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,

1151: -- Default = DBMS_AQ.NO_WAIT
1152: -- p_dequeue_mode IN VARCHAR2 Optional
1153: -- Default = DBMS_AQ.REMOVE
1154: -- p_navigation IN VARCHAR2 Optional
1155: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,
1156: --
1157: -- GET_EXCEPTION API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
1158: --
1159: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1204: p_wait IN NUMBER := DBMS_AQ.NO_WAIT,

1200: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1201: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1202: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1203: p_app_short_name IN VARCHAR2,
1204: p_wait IN NUMBER := DBMS_AQ.NO_WAIT,
1205: p_dequeue_mode IN VARCHAR2 := DBMS_AQ.REMOVE,
1206: p_navigation IN VARCHAR2 := DBMS_AQ.FIRST_MESSAGE,
1207: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1208: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

Line 1205: p_dequeue_mode IN VARCHAR2 := DBMS_AQ.REMOVE,

1201: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1202: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1203: p_app_short_name IN VARCHAR2,
1204: p_wait IN NUMBER := DBMS_AQ.NO_WAIT,
1205: p_dequeue_mode IN VARCHAR2 := DBMS_AQ.REMOVE,
1206: p_navigation IN VARCHAR2 := DBMS_AQ.FIRST_MESSAGE,
1207: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1208: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1209: x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

Line 1206: p_navigation IN VARCHAR2 := DBMS_AQ.FIRST_MESSAGE,

1202: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1203: p_app_short_name IN VARCHAR2,
1204: p_wait IN NUMBER := DBMS_AQ.NO_WAIT,
1205: p_dequeue_mode IN VARCHAR2 := DBMS_AQ.REMOVE,
1206: p_navigation IN VARCHAR2 := DBMS_AQ.FIRST_MESSAGE,
1207: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1208: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1209: x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1210: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,