DBA Data[Home] [Help]

APPS.AD_ZD_PREP dependencies on DBMS_AQADM_SYS

Line 1422: if (sys.dbms_aqadm_sys.mcq_8_1(l_qt_flags)) then

1418: -- Note that sys.dbms_prvtaqim.create_base_view internally calls
1419: -- sys.dbms_prvtaqim.create_deq_view. So you may not need to call another
1420: -- create_deq_view.
1421: --
1422: if (sys.dbms_aqadm_sys.mcq_8_1(l_qt_flags)) then
1423: -- For new multiconsumer queue (8.1 style and above)
1424: sys.dbms_aqadm_sys.create_buffer_view(x_owner, x_table, true);
1425: log(l_module, 'EVENT',
1426: 'Call sys.dbms_prvtaqim.create_base_view('|| x_owner||', '||x_table ||', '|| l_qt_flags||')');

Line 1424: sys.dbms_aqadm_sys.create_buffer_view(x_owner, x_table, true);

1420: -- create_deq_view.
1421: --
1422: if (sys.dbms_aqadm_sys.mcq_8_1(l_qt_flags)) then
1423: -- For new multiconsumer queue (8.1 style and above)
1424: sys.dbms_aqadm_sys.create_buffer_view(x_owner, x_table, true);
1425: log(l_module, 'EVENT',
1426: 'Call sys.dbms_prvtaqim.create_base_view('|| x_owner||', '||x_table ||', '|| l_qt_flags||')');
1427: sys.dbms_prvtaqim.create_base_view(x_owner, x_table, l_qt_flags);
1428: else

Line 1431: 'Call sys.dbms_aqadm_sys.create_base_view('|| x_owner||', '||x_table||', '|| l_qt_flags||')');

1427: sys.dbms_prvtaqim.create_base_view(x_owner, x_table, l_qt_flags);
1428: else
1429: -- only for 8.0 style queues
1430: log(l_module, 'EVENT',
1431: 'Call sys.dbms_aqadm_sys.create_base_view('|| x_owner||', '||x_table||', '|| l_qt_flags||')');
1432: sys.dbms_aqadm_sys.create_base_view(x_owner, x_table, l_qt_flags);
1433: end if;
1434: exception
1435: when others then

Line 1432: sys.dbms_aqadm_sys.create_base_view(x_owner, x_table, l_qt_flags);

1428: else
1429: -- only for 8.0 style queues
1430: log(l_module, 'EVENT',
1431: 'Call sys.dbms_aqadm_sys.create_base_view('|| x_owner||', '||x_table||', '|| l_qt_flags||')');
1432: sys.dbms_aqadm_sys.create_base_view(x_owner, x_table, l_qt_flags);
1433: end if;
1434: exception
1435: when others then
1436: log(l_module, 'ERROR', 'Error: '|| x_owner ||'.'|| x_table || ' '|| substr(sqlerrm,1,2000));