DBA Data[Home] [Help]

APPS.WF_XML dependencies on DBMS_AQ

Line 304: l_enqueue_options dbms_aq.enqueue_options_t;

300: p_priority number,
301: p_correlation in varchar2,
302: p_message in CLOB) is
303:
304: l_enqueue_options dbms_aq.enqueue_options_t;
305: l_message_properties dbms_aq.message_properties_t;
306: l_correlation varchar2(255) := NULL;
307: l_msgid raw(16);
308:

Line 305: l_message_properties dbms_aq.message_properties_t;

301: p_correlation in varchar2,
302: p_message in CLOB) is
303:
304: l_enqueue_options dbms_aq.enqueue_options_t;
305: l_message_properties dbms_aq.message_properties_t;
306: l_correlation varchar2(255) := NULL;
307: l_msgid raw(16);
308:
309: l_queueu VARCHAR2(200);

Line 319: l_dequeue_options dbms_aq.dequeue_options_t;

315:
316: l_amount binary_integer;
317: l_pos pls_integer;
318:
319: l_dequeue_options dbms_aq.dequeue_options_t;
320: begin
321:
322:
323: /** wf_message_payload_t is obsolete in 2.6.4 onwards **/

Line 347: l_enqueue_options dbms_aq.enqueue_options_t;

343: p_priority number,
344: p_correlation in varchar2,
345: p_message in VARCHAR2) is
346:
347: l_enqueue_options dbms_aq.enqueue_options_t;
348: l_message_properties dbms_aq.message_properties_t;
349: l_correlation varchar2(255) := NULL;
350: l_msgid raw(16);
351:

Line 348: l_message_properties dbms_aq.message_properties_t;

344: p_correlation in varchar2,
345: p_message in VARCHAR2) is
346:
347: l_enqueue_options dbms_aq.enqueue_options_t;
348: l_message_properties dbms_aq.message_properties_t;
349: l_correlation varchar2(255) := NULL;
350: l_msgid raw(16);
351:
352: -- l_msgLob CLOB;

Line 364: l_dequeue_options dbms_aq.dequeue_options_t;

360:
361: l_amount binary_integer;
362: l_pos pls_integer;
363:
364: l_dequeue_options dbms_aq.dequeue_options_t;
365: begin
366:
367: /** wf_message_payload_t is obsolete in 2.6.4 onwards **/
368: null;

Line 2135: l_dequeue_options dbms_aq.dequeue_options_t;

2131: p_message in out NOCOPY CLOB,
2132: p_timeout out NOCOPY boolean)
2133: as
2134:
2135: l_dequeue_options dbms_aq.dequeue_options_t;
2136: l_message_properties dbms_aq.message_properties_t;
2137: l_correlation varchar2(255) := NULL;
2138: l_message_handle RAW(16);
2139:

Line 2136: l_message_properties dbms_aq.message_properties_t;

2132: p_timeout out NOCOPY boolean)
2133: as
2134:
2135: l_dequeue_options dbms_aq.dequeue_options_t;
2136: l_message_properties dbms_aq.message_properties_t;
2137: l_correlation varchar2(255) := NULL;
2138: l_message_handle RAW(16);
2139:
2140: begin

Line 2495: l_dequeue_options dbms_aq.dequeue_options_t;

2491: procedure RemoveMessage(p_queue_name in varchar2,
2492: p_correlation in varchar2,
2493: p_timeout out NOCOPY boolean)
2494: is
2495: l_dequeue_options dbms_aq.dequeue_options_t;
2496: l_message_properties dbms_aq.message_properties_t;
2497: l_correlation varchar2(255) := NULL;
2498: l_message_handle RAW(16);
2499:

Line 2496: l_message_properties dbms_aq.message_properties_t;

2492: p_correlation in varchar2,
2493: p_timeout out NOCOPY boolean)
2494: is
2495: l_dequeue_options dbms_aq.dequeue_options_t;
2496: l_message_properties dbms_aq.message_properties_t;
2497: l_correlation varchar2(255) := NULL;
2498: l_message_handle RAW(16);
2499:
2500: begin