DBA Data[Home] [Help]

APPS.ECX_RULE dependencies on DBMS_AQ

Line 196: v_enqueueoptions dbms_aq.enqueue_options_t;

192: l_standard_code varchar2(2000);
193: l_standard_type varchar2(2000);
194: i_queue_name varchar2(2000);
195: v_ect_inengobj system.ecx_inengobj;
196: v_enqueueoptions dbms_aq.enqueue_options_t;
197: v_messageproperties dbms_aq.message_properties_t;
198: v_msgid raw(16);
199: v_msgid_out raw(16);
200: i_trigger_id number;

Line 197: v_messageproperties dbms_aq.message_properties_t;

193: l_standard_type varchar2(2000);
194: i_queue_name varchar2(2000);
195: v_ect_inengobj system.ecx_inengobj;
196: v_enqueueoptions dbms_aq.enqueue_options_t;
197: v_messageproperties dbms_aq.message_properties_t;
198: v_msgid raw(16);
199: v_msgid_out raw(16);
200: i_trigger_id number;
201: debug_level pls_integer;

Line 466: dbms_aq.enqueue(queue_name => i_queue_name,

462:
463: v_ect_inengobj := system.ecx_inengobj(v_msgid,debug_level);
464:
465: begin
466: dbms_aq.enqueue(queue_name => i_queue_name,
467: enqueue_options => v_enqueueoptions,
468: message_properties => v_messageproperties,
469: payload => v_ect_inengobj,
470: msgid => v_msgid_out );

Line 1084: l_enqueueoptions dbms_aq.enqueue_options_t;

1080: is
1081:
1082: l_ecx_inengobj system.ecx_inengobj;
1083: l_debug_mode pls_integer;
1084: l_enqueueoptions dbms_aq.enqueue_options_t;
1085: l_messageproperties dbms_aq.message_properties_t;
1086: l_msgid raw(16);
1087: l_module Varchar2(2000);
1088:

Line 1085: l_messageproperties dbms_aq.message_properties_t;

1081:
1082: l_ecx_inengobj system.ecx_inengobj;
1083: l_debug_mode pls_integer;
1084: l_enqueueoptions dbms_aq.enqueue_options_t;
1085: l_messageproperties dbms_aq.message_properties_t;
1086: l_msgid raw(16);
1087: l_module Varchar2(2000);
1088:
1089: begin

Line 1099: dbms_aq.enqueue(queue_name => p_queue_name,

1095: l_debug_mode := p_event.getValueForParameter('ECX_DEBUG_LEVEL');
1096:
1097: l_ecx_inengobj := system.ecx_inengobj(p_msgid_in, l_debug_mode);
1098:
1099: dbms_aq.enqueue(queue_name => p_queue_name,
1100: enqueue_options => l_enqueueoptions,
1101: message_properties => l_messageproperties,
1102: payload => l_ecx_inengobj,
1103: msgid => x_msgid_out );