DBA Data[Home] [Help]

APPS.OKL_PROCESS_STREAMS_PVT dependencies on DBMS_AQ

Line 3543: v_enqueueoptions dbms_aq.enqueue_options_t;

3539: x_return_status OUT NOCOPY varchar2)
3540: IS
3541: i_tmp clob;
3542: v_message system.ecxmsg;
3543: v_enqueueoptions dbms_aq.enqueue_options_t;
3544: v_messageproperties dbms_aq.message_properties_t;
3545: v_msgid raw(16);
3546: c_nummessages CONSTANT INTEGER :=1;
3547: i_amount number;

Line 3544: v_messageproperties dbms_aq.message_properties_t;

3540: IS
3541: i_tmp clob;
3542: v_message system.ecxmsg;
3543: v_enqueueoptions dbms_aq.enqueue_options_t;
3544: v_messageproperties dbms_aq.message_properties_t;
3545: v_msgid raw(16);
3546: c_nummessages CONSTANT INTEGER :=1;
3547: i_amount number;
3548: i_message raw(32767);

Line 3599: dbms_aq.enqueue

3595: attribute5 => NULL);
3596: for v_counter in 1..c_nummessages
3597: loop
3598: -- Enqueue
3599: dbms_aq.enqueue
3600: (
3601: queue_name=> G_INBOUND_QUEUE,
3602: enqueue_options=>v_enqueueoptions,
3603: message_properties=>v_messageproperties,