DBA Data[Home] [Help]

APPS.WF_XML dependencies on DBMS_AQ

Line 309: l_enqueue_options dbms_aq.enqueue_options_t;

305: p_priority number,
306: p_correlation in varchar2,
307: p_message in CLOB) is
308:
309: l_enqueue_options dbms_aq.enqueue_options_t;
310: l_message_properties dbms_aq.message_properties_t;
311: l_correlation varchar2(255) := NULL;
312: l_msgid raw(16);
313:

Line 310: l_message_properties dbms_aq.message_properties_t;

306: p_correlation in varchar2,
307: p_message in CLOB) is
308:
309: l_enqueue_options dbms_aq.enqueue_options_t;
310: l_message_properties dbms_aq.message_properties_t;
311: l_correlation varchar2(255) := NULL;
312: l_msgid raw(16);
313:
314: l_queueu VARCHAR2(200);

Line 324: l_dequeue_options dbms_aq.dequeue_options_t;

320:
321: l_amount binary_integer;
322: l_pos pls_integer;
323:
324: l_dequeue_options dbms_aq.dequeue_options_t;
325: begin
326:
327:
328: /** wf_message_payload_t is obsolete in 2.6.4 onwards **/

Line 352: l_enqueue_options dbms_aq.enqueue_options_t;

348: p_priority number,
349: p_correlation in varchar2,
350: p_message in VARCHAR2) is
351:
352: l_enqueue_options dbms_aq.enqueue_options_t;
353: l_message_properties dbms_aq.message_properties_t;
354: l_correlation varchar2(255) := NULL;
355: l_msgid raw(16);
356:

Line 353: l_message_properties dbms_aq.message_properties_t;

349: p_correlation in varchar2,
350: p_message in VARCHAR2) is
351:
352: l_enqueue_options dbms_aq.enqueue_options_t;
353: l_message_properties dbms_aq.message_properties_t;
354: l_correlation varchar2(255) := NULL;
355: l_msgid raw(16);
356:
357: -- l_msgLob CLOB;

Line 369: l_dequeue_options dbms_aq.dequeue_options_t;

365:
366: l_amount binary_integer;
367: l_pos pls_integer;
368:
369: l_dequeue_options dbms_aq.dequeue_options_t;
370: begin
371:
372: /** wf_message_payload_t is obsolete in 2.6.4 onwards **/
373: null;

Line 2064: l_dequeue_options dbms_aq.dequeue_options_t;

2060: p_message in out NOCOPY CLOB,
2061: p_timeout out NOCOPY boolean)
2062: as
2063:
2064: l_dequeue_options dbms_aq.dequeue_options_t;
2065: l_message_properties dbms_aq.message_properties_t;
2066: l_correlation varchar2(255) := NULL;
2067: l_message_handle RAW(16);
2068:

Line 2065: l_message_properties dbms_aq.message_properties_t;

2061: p_timeout out NOCOPY boolean)
2062: as
2063:
2064: l_dequeue_options dbms_aq.dequeue_options_t;
2065: l_message_properties dbms_aq.message_properties_t;
2066: l_correlation varchar2(255) := NULL;
2067: l_message_handle RAW(16);
2068:
2069: begin

Line 2424: l_dequeue_options dbms_aq.dequeue_options_t;

2420: procedure RemoveMessage(p_queue_name in varchar2,
2421: p_correlation in varchar2,
2422: p_timeout out NOCOPY boolean)
2423: is
2424: l_dequeue_options dbms_aq.dequeue_options_t;
2425: l_message_properties dbms_aq.message_properties_t;
2426: l_correlation varchar2(255) := NULL;
2427: l_message_handle RAW(16);
2428:

Line 2425: l_message_properties dbms_aq.message_properties_t;

2421: p_correlation in varchar2,
2422: p_timeout out NOCOPY boolean)
2423: is
2424: l_dequeue_options dbms_aq.dequeue_options_t;
2425: l_message_properties dbms_aq.message_properties_t;
2426: l_correlation varchar2(255) := NULL;
2427: l_message_handle RAW(16);
2428:
2429: begin