DBA Data[Home] [Help]

APPS.OKL_PROCESS_STREAMS_PVT dependencies on DBMS_AQ

Line 3520: v_enqueueoptions dbms_aq.enqueue_options_t;

3516: x_return_status OUT NOCOPY varchar2)
3517: IS
3518: i_tmp clob;
3519: v_message system.ecxmsg;
3520: v_enqueueoptions dbms_aq.enqueue_options_t;
3521: v_messageproperties dbms_aq.message_properties_t;
3522: v_msgid raw(16);
3523: c_nummessages CONSTANT INTEGER :=1;
3524: i_amount number;

Line 3521: v_messageproperties dbms_aq.message_properties_t;

3517: IS
3518: i_tmp clob;
3519: v_message system.ecxmsg;
3520: v_enqueueoptions dbms_aq.enqueue_options_t;
3521: v_messageproperties dbms_aq.message_properties_t;
3522: v_msgid raw(16);
3523: c_nummessages CONSTANT INTEGER :=1;
3524: i_amount number;
3525: i_message raw(32767);

Line 3576: dbms_aq.enqueue

3572: attribute5 => NULL);
3573: for v_counter in 1..c_nummessages
3574: loop
3575: -- Enqueue
3576: dbms_aq.enqueue
3577: (
3578: queue_name=> G_INBOUND_QUEUE,
3579: enqueue_options=>v_enqueueoptions,
3580: message_properties=>v_messageproperties,