APPS.AD_ZD_PREP dependencies on DBA_QUEUES

Line 484: from dba_queues aq

480: procedure DROP_TEMP_QUEUES is
481:
482: cursor c_queues is
483: select aq.owner , aq.name
484: from dba_queues aq
485: where aq.owner = g_xla_schema
486: and (aq.name like 'XLA_%_DOC_Q' or aq.name like 'XLA_%_COMP_Q');
487:
488: begin

Line 1359: from dba_queues aq

1355:
1356: cursor C_QUEUES(X_OWNER VARCHAR2, X_TABLE VARCHAR2) IS
1357: select '"'||aq.owner || '"."' || aq.name ||'"',
1358: aq.queue_type
1359: from dba_queues aq
1360: where aq.owner = x_owner
1361: and aq.queue_table = x_table
1362: and not ( aq.name like 'XLA_%_COMP_Q'
1363: OR aq.name like 'XLA_%_DOC_Q' );

Line 1403: from dba_queues aq

1399: l_qt_flags number;
1400: cursor c_queues is
1401: select aq.name,
1402: aq.queue_type
1403: from dba_queues aq
1404: where aq.owner = x_owner
1405: and aq.queue_table = x_table;
1406:
1407: begin

Line 1542: from dba_queues

1538: fetch c_columns INTO l_owner, l_table, l_column;
1539: while (c_columns%found) loop
1540:
1541: select count(name) into l_queue_count
1542: from dba_queues
1543: where owner = l_owner
1544: and queue_table = l_table;
1545:
1546: -- If it is a queue table, then fix the overall queue,

Line 1567: from dba_queues

1563: while (c_columns2%found) loop
1564:
1565: -- check if this is a queue table,
1566: select count(name) into l_queue_count
1567: from dba_queues
1568: where owner = l_owner
1569: and queue_table = l_table;
1570:
1571: -- If it is a queue table, then fix the overall queue,