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 1092: l_enqueueoptions dbms_aq.enqueue_options_t;

1088: is
1089:
1090: l_ecx_inengobj system.ecx_inengobj;
1091: l_debug_mode pls_integer;
1092: l_enqueueoptions dbms_aq.enqueue_options_t;
1093: l_messageproperties dbms_aq.message_properties_t;
1094: l_msgid raw(16);
1095: l_module Varchar2(2000);
1096:

Line 1093: l_messageproperties dbms_aq.message_properties_t;

1089:
1090: l_ecx_inengobj system.ecx_inengobj;
1091: l_debug_mode pls_integer;
1092: l_enqueueoptions dbms_aq.enqueue_options_t;
1093: l_messageproperties dbms_aq.message_properties_t;
1094: l_msgid raw(16);
1095: l_module Varchar2(2000);
1096:
1097: begin

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

1103: l_debug_mode := p_event.getValueForParameter('ECX_DEBUG_LEVEL');
1104:
1105: l_ecx_inengobj := system.ecx_inengobj(p_msgid_in, l_debug_mode);
1106:
1107: dbms_aq.enqueue(queue_name => p_queue_name,
1108: enqueue_options => l_enqueueoptions,
1109: message_properties => l_messageproperties,
1110: payload => l_ecx_inengobj,
1111: msgid => x_msgid_out );