APPS.CCT_QDE_PUB dependencies on DBMS_AQ

Line 236: enqueue_options dbms_aq.enqueue_options_t;

232: RESOURCE_NOT_LOCKED EXCEPTION;
233: l_route_result VARCHAR2(2000);
234: l_agent_id number;
235: l_kvp cct_keyvalue_varr;
236: enqueue_options dbms_aq.enqueue_options_t;
237: message_properties dbms_aq.message_properties_t;
238: message_handle RAW(16);
239: message SYSTEM.cct_qde_response;
240:

Line 237: message_properties dbms_aq.message_properties_t;

233: l_route_result VARCHAR2(2000);
234: l_agent_id number;
235: l_kvp cct_keyvalue_varr;
236: enqueue_options dbms_aq.enqueue_options_t;
237: message_properties dbms_aq.message_properties_t;
238: message_handle RAW(16);
239: message SYSTEM.cct_qde_response;
240:
241: PRAGMA EXCEPTION_INIT(RESOURCE_NOT_LOCKED, -54);

Line 361: dbms_aq.enqueue(queue_name => CCT_QDE_QUEUE.queue_name,

357:
358:
359: message := SYSTEM.cct_qde_response(r1_rec.agent_id, p_item_id, p_item_type, p_classification, 172, l_kvp);
360: message_properties.correlation := r1_rec.agent_id;
361: dbms_aq.enqueue(queue_name => CCT_QDE_QUEUE.queue_name,
362: enqueue_options => enqueue_options,
363: message_properties => message_properties,
364: payload => message,
365: msgid => message_handle);