APPS.ECX_OXTA_PKG dependencies on DBMS_AQ

Line 29: v_dequeueoptions dbms_aq.dequeue_options_t;

25: p_msgid out nocopy raw,
26: p_org_msgid out nocopy varchar2
27: ) is
28: v_message system.ecxmsg;
29: v_dequeueoptions dbms_aq.dequeue_options_t;
30: v_messageproperties dbms_aq.message_properties_t;
31: l_password varchar2(500);
32: l_errmsg varchar2(2000);
33: l_retcode pls_integer;

Line 30: v_messageproperties dbms_aq.message_properties_t;

26: p_org_msgid out nocopy varchar2
27: ) is
28: v_message system.ecxmsg;
29: v_dequeueoptions dbms_aq.dequeue_options_t;
30: v_messageproperties dbms_aq.message_properties_t;
31: l_password varchar2(500);
32: l_errmsg varchar2(2000);
33: l_retcode pls_integer;
34: no_messages exception;

Line 38: v_dequeueoptions.navigation := dbms_aq.FIRST_MESSAGE;

34: no_messages exception;
35: pragma exception_init (no_messages, -25228);
36:
37: begin
38: v_dequeueoptions.navigation := dbms_aq.FIRST_MESSAGE;
39: v_dequeueoptions.wait := dbms_aq.NO_WAIT;
40: v_dequeueoptions.correlation := 'OXTA';
41:
42:

Line 39: v_dequeueoptions.wait := dbms_aq.NO_WAIT;

35: pragma exception_init (no_messages, -25228);
36:
37: begin
38: v_dequeueoptions.navigation := dbms_aq.FIRST_MESSAGE;
39: v_dequeueoptions.wait := dbms_aq.NO_WAIT;
40: v_dequeueoptions.correlation := 'OXTA';
41:
42:
43: dbms_aq.dequeue

Line 43: dbms_aq.dequeue

39: v_dequeueoptions.wait := dbms_aq.NO_WAIT;
40: v_dequeueoptions.correlation := 'OXTA';
41:
42:
43: dbms_aq.dequeue
44: (
45: queue_name=>p_queue_name,
46: dequeue_options=>v_dequeueoptions,
47: message_properties=>v_messageproperties,

Line 105: v_enqueueoptions dbms_aq.enqueue_options_t;

101: p_delay in number,
102: p_msgid out nocopy raw
103: ) is
104: v_message system.ecxmsg;
105: v_enqueueoptions dbms_aq.enqueue_options_t;
106: v_messageproperties dbms_aq.message_properties_t;
107: begin
108:
109: v_message := system.ecxmsg( p_message_type,

Line 106: v_messageproperties dbms_aq.message_properties_t;

102: p_msgid out nocopy raw
103: ) is
104: v_message system.ecxmsg;
105: v_enqueueoptions dbms_aq.enqueue_options_t;
106: v_messageproperties dbms_aq.message_properties_t;
107: begin
108:
109: v_message := system.ecxmsg( p_message_type,
110: p_message_standard,

Line 131: dbms_aq.enqueue

127:
128: v_messageproperties.correlation := 'OXTA';
129: v_messageproperties.delay := p_delay;
130:
131: dbms_aq.enqueue
132: (
133: queue_name=>p_queue_name,
134: enqueue_options=>v_enqueueoptions,
135: message_properties=>v_messageproperties,