APPS.OKC_AQ_PVT dependencies on AQ$OKC_AQ_EV_TAB

Line 503: FROM aq$okc_aq_ev_tab

499: AND q.CORRID = 'SHUTDOWN';
500: /*
501: changed cursor for performance bug# 1563692
502: SELECT msg_id,consumer_name
503: FROM aq$okc_aq_ev_tab
504: WHERE 'OKC.'||queue = p_queue
505: AND msg_state = 'READY'
506: AND UPPER(corr_id) = 'SHUTDOWN';*/
507: queue_rec queue_cur%ROWTYPE;

Line 575: FROM aq$okc_aq_ev_tab

571: (h.subscriber# = 0 AND h.address# = s.subscriber_id))
572: AND q.CORRID = 'SHUTDOWN';
573: --changed cursor for performance bug# 1563692
574: /*SELECT msg_id,consumer_name
575: FROM aq$okc_aq_ev_tab
576: WHERE 'OKC.'||queue = p_queue
577: AND msg_state = 'READY'
578: AND UPPER(corr_id) = 'SHUTDOWN';*/
579: queue_rec queue_cur%ROWTYPE;

Line 641: FROM AQ$OKC_AQ_EV_TAB_S

637: PRAGMA EXCEPTION_INIT ( e_listen_timeout, -25254);
638: -- bug 3621354 changed cursor to query subscriber view rather than table
639: CURSOR c_subscriber IS
640: SELECT name
641: FROM AQ$OKC_AQ_EV_TAB_S
642: WHERE queue = substr(OKC_AQ_PVT.g_event_queue_name,5);
643: --
644: l_proc varchar2(72) := ' OKC_AQ_PVT.'||'listen_event';
645: --

Line 733: FROM AQ$OKC_AQ_EV_TAB_S

729:
730: -- bug 3621354 changed cursor to query subscriber view rather than table
731: CURSOR c_subscriber IS
732: SELECT name
733: FROM AQ$OKC_AQ_EV_TAB_S
734: WHERE queue = substr(OKC_AQ_PVT.g_outcome_queue_name,5);
735: --
736: l_proc varchar2(72) := ' OKC_AQ_PVT.'||'listen_outcome';
737: --

Line 1594: FROM aq$okc_aq_ev_tab

1590:
1591:
1592: CURSOR msg_cur IS
1593: SELECT consumer_name,corr_id
1594: FROM aq$okc_aq_ev_tab
1595: WHERE msg_id = HEXTORAW(p_msg_id);
1596: msg_rec msg_cur%ROWTYPE;
1597:
1598: e_dequeue_timeout EXCEPTION;

Line 1751: FROM aq$okc_aq_ev_tab

1747:
1748:
1749: CURSOR msg_cur IS
1750: SELECT consumer_name,corr_id,queue
1751: FROM aq$okc_aq_ev_tab
1752: WHERE msg_id = HEXTORAW(p_msg_id);
1753: msg_rec msg_cur%ROWTYPE;
1754:
1755: e_dequeue_timeout EXCEPTION;