APPS.ASO_ORDER_FEEDBACK_GET_PVT dependencies on DBMS_AQ

Line 38: -- Default = DBMS_AQ.REMOVE

34: -- p_app_short_name IN VARCHAR2 Required
35: -- p_queue_type IN VARCHAR2 Optional
36: -- Default = OF_QUEUE
37: -- p_dequeue_mode IN NUMBER Optional
38: -- Default = DBMS_AQ.REMOVE
39: -- p_navigation IN NUMBER Optional
40: -- Default = DBMS_AQ.FIRST_MESSAGE
41: -- p_wait IN NUMBER Optional
42: -- Default = DBMS_AQ.NO_WAIT

Line 40: -- Default = DBMS_AQ.FIRST_MESSAGE

36: -- Default = OF_QUEUE
37: -- p_dequeue_mode IN NUMBER Optional
38: -- Default = DBMS_AQ.REMOVE
39: -- p_navigation IN NUMBER Optional
40: -- Default = DBMS_AQ.FIRST_MESSAGE
41: -- p_wait IN NUMBER Optional
42: -- Default = DBMS_AQ.NO_WAIT
43: --
44: -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 42: -- Default = DBMS_AQ.NO_WAIT

38: -- Default = DBMS_AQ.REMOVE
39: -- p_navigation IN NUMBER Optional
40: -- Default = DBMS_AQ.FIRST_MESSAGE
41: -- p_wait IN NUMBER Optional
42: -- Default = DBMS_AQ.NO_WAIT
43: --
44: -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
45: --
46: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 92: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,

88: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
89: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
90: p_app_short_name IN VARCHAR2,
91: p_queue_type IN VARCHAR2 DEFAULT 'OF_QUEUE',
92: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
93: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
94: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
95: p_deq_condition IN VARCHAR2 DEFAULT NULL, /* Bug 9410311 */
96: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 93: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,

89: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
90: p_app_short_name IN VARCHAR2,
91: p_queue_type IN VARCHAR2 DEFAULT 'OF_QUEUE',
92: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
93: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
94: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
95: p_deq_condition IN VARCHAR2 DEFAULT NULL, /* Bug 9410311 */
96: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
97: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

Line 94: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,

90: p_app_short_name IN VARCHAR2,
91: p_queue_type IN VARCHAR2 DEFAULT 'OF_QUEUE',
92: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
93: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
94: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
95: p_deq_condition IN VARCHAR2 DEFAULT NULL, /* Bug 9410311 */
96: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
97: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
98: x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,