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

Line 1153: -- Default = DBMS_AQ.NO_WAIT

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

Line 1155: -- Default = DBMS_AQ.REMOVE

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

Line 1157: -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,

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

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

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

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

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

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

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