DBA Data[Home] [Help]

SYSTEM.AD_APPS_PRIVATE dependencies on DBA_QUEUES

Line 495: and use dba_queues that is faster than using dba_objects */

491:
492: EXCEPTION
493: /* Added for bug2765486 to trap ORA -1720 */
494: /* BUG 2892989, Since APPLSYS owns WF queues, we don't use the owner condition
495: and use dba_queues that is faster than using dba_objects */
496:
497: WHEN no_grant_exist THEN
498: BEGIN
499: SELECT 1, owner into l_exists, l_queue_owner

Line 500: FROM dba_queues where name = p_object_name;

496:
497: WHEN no_grant_exist THEN
498: BEGIN
499: SELECT 1, owner into l_exists, l_queue_owner
500: FROM dba_queues where name = p_object_name;
501:
502: EXCEPTION
503: WHEN OTHERS THEN
504: ad_apps_private.error_buf := 'create_grant('||