DBA Data[Home] [Help]

APPS.M4U_UCC_ADAPTER dependencies on DBMS_AQ

Line 31: enqueue_options dbms_aq.enqueue_options_t;

27: l_nextval NUMBER;
28: l_event_name VARCHAR2(256);
29: l_event wf_event_t;
30: l_parameter_list WF_PARAMETER_LIST_T;
31: enqueue_options dbms_aq.enqueue_options_t;
32: msg_properties dbms_aq.message_properties_t;
33: x_out_msg_id RAW(16);
34:
35: BEGIN

Line 32: msg_properties dbms_aq.message_properties_t;

28: l_event_name VARCHAR2(256);
29: l_event wf_event_t;
30: l_parameter_list WF_PARAMETER_LIST_T;
31: enqueue_options dbms_aq.enqueue_options_t;
32: msg_properties dbms_aq.message_properties_t;
33: x_out_msg_id RAW(16);
34:
35: BEGIN
36: q_schema_name := 'APPLSYS'; -- code workaround, for GSCC error, needs to be resolved subsequently.

Line 95: dbms_aq.enqueue(

91: IF (l_Debug_Level <= 1) THEN
92: cln_debug_pub.Add('Event to be enqueued initialized',2);
93: END IF;
94:
95: dbms_aq.enqueue(
96: queue_name => q_schema_name || '.' || q_name,
97: enqueue_options => enqueue_options,
98: message_properties => msg_properties,
99: payload => jms_msg,

Line 104: cln_debug_pub.Add('dbms_aq.enqueue msgid returned - ' || x_out_msg_id,2);

100: msgid => x_out_msg_id
101: );
102:
103: IF (l_Debug_Level <= 1) THEN
104: cln_debug_pub.Add('dbms_aq.enqueue msgid returned - ' || x_out_msg_id,2);
105: END IF;
106:
107:
108: IF (l_Debug_Level <= 2) THEN