APPS.ASO_ORDER_FEEDBACK_GET_PVT dependencies on DBMS_AQ

Line 1469: -- Default = DBMS_AQ.REMOVE

1465: -- p_app_short_name IN VARCHAR2 Required
1466: -- p_queue_type IN VARCHAR2 Optional
1467: -- Default = OF_QUEUE
1468: -- p_dequeue_mode IN NUMBER Optional
1469: -- Default = DBMS_AQ.REMOVE
1470: -- p_dequeue_navigation IN NUMBER Optional
1471: -- Default = DBMS_AQ.FIRST_MESSAGE
1472: -- p_wait IN NUMBER Optional
1473: -- Default = DBMS_AQ.NO_WAIT

Line 1471: -- Default = DBMS_AQ.FIRST_MESSAGE

1467: -- Default = OF_QUEUE
1468: -- p_dequeue_mode IN NUMBER Optional
1469: -- Default = DBMS_AQ.REMOVE
1470: -- p_dequeue_navigation IN NUMBER Optional
1471: -- Default = DBMS_AQ.FIRST_MESSAGE
1472: -- p_wait IN NUMBER Optional
1473: -- Default = DBMS_AQ.NO_WAIT
1474: --
1475: -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 1473: -- Default = DBMS_AQ.NO_WAIT

1469: -- Default = DBMS_AQ.REMOVE
1470: -- p_dequeue_navigation IN NUMBER Optional
1471: -- Default = DBMS_AQ.FIRST_MESSAGE
1472: -- p_wait IN NUMBER Optional
1473: -- Default = DBMS_AQ.NO_WAIT
1474: --
1475: -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
1476: --
1477: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1523: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,

1519: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1520: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1521: p_app_short_name IN VARCHAR2,
1522: p_queue_type IN VARCHAR2 DEFAULT 'OF_QUEUE',
1523: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
1524: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
1525: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
1526: p_deq_condition IN VARCHAR2 DEFAULT NULL, /* Bug 9410311 */
1527: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1524: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,

1520: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1521: p_app_short_name IN VARCHAR2,
1522: p_queue_type IN VARCHAR2 DEFAULT 'OF_QUEUE',
1523: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
1524: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
1525: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
1526: p_deq_condition IN VARCHAR2 DEFAULT NULL, /* Bug 9410311 */
1527: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1528: x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

Line 1525: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,

1521: p_app_short_name IN VARCHAR2,
1522: p_queue_type IN VARCHAR2 DEFAULT 'OF_QUEUE',
1523: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
1524: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
1525: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
1526: p_deq_condition IN VARCHAR2 DEFAULT NULL, /* Bug 9410311 */
1527: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1528: x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1529: x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

Line 1560: l_dequeue_options dbms_aq.dequeue_options_t;

1556: i number;
1557: l_api_name CONSTANT VARCHAR2(30) := 'GET_NOTICE';
1558: l_api_version CONSTANT NUMBER := 1.0;
1559: l_queue_name VARCHAR2(30);
1560: l_dequeue_options dbms_aq.dequeue_options_t;
1561: l_message_properties dbms_aq.message_properties_t;
1562: l_msg_id RAW(16);
1563: l_message SYSTEM.ASO_Order_Feedback_Type;
1564: l_Header_rec OE_Order_PUB.Header_Rec_Type;

Line 1561: l_message_properties dbms_aq.message_properties_t;

1557: l_api_name CONSTANT VARCHAR2(30) := 'GET_NOTICE';
1558: l_api_version CONSTANT NUMBER := 1.0;
1559: l_queue_name VARCHAR2(30);
1560: l_dequeue_options dbms_aq.dequeue_options_t;
1561: l_message_properties dbms_aq.message_properties_t;
1562: l_msg_id RAW(16);
1563: l_message SYSTEM.ASO_Order_Feedback_Type;
1564: l_Header_rec OE_Order_PUB.Header_Rec_Type;
1565: l_old_Header_rec OE_Order_PUB.Header_Rec_Type;

Line 1651: dbms_aq.dequeue(

1647:
1648:
1649: -- Dequeue a message
1650:
1651: dbms_aq.dequeue(
1652: queue_name => l_queue_name,
1653: dequeue_options => l_dequeue_options,
1654: message_properties => l_message_properties,
1655: payload => l_message,