DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PKG dependencies on AQ$_AGENT

Line 1721: l_agent sys.aq$_agent;

1717:
1718: dequeue_options DBMS_AQ.dequeue_options_t;
1719: message_properties DBMS_AQ.message_properties_t;
1720: message_handle RAW(16);
1721: l_agent sys.aq$_agent;
1722: l_req_type VARCHAR2(1) :='P';
1723:
1724: no_messages exception;
1725: pragma exception_init(no_messages, -25228);

Line 1750: l_agent := sys.aq$_agent(p_request,null,null);

1746: x_desc := g_payload.l_desc;
1747: dequeue_options.navigation := DBMS_AQ.NEXT_MESSAGE;
1748: END LOOP;
1749: --remove subscriber.
1750: l_agent := sys.aq$_agent(p_request,null,null);
1751: dbms_aqadm.remove_subscriber(queue_name => g_qname, subscriber => l_agent);
1752: COMMIT;
1753: exception
1754: WHEN no_messages THEN