DBA Data[Home] [Help]

APPS.FND_TRACE_UTILS dependencies on ALL_OBJECTS

Line 416: select 'Y' into l_run_ok from all_objects

412: G_CUTOFF_PCT:=CUTOFF_PCT;
413:
414: -- Check if the profiler package and the tables exist, if not log and exit.
415: BEGIN
416: select 'Y' into l_run_ok from all_objects
417: where owner='SYS' and object_type='PACKAGE' and object_name='DBMS_PROFILER';
418: select 'Y' into l_run_ok from all_objects
419: where owner='SYS' and object_type='PACKAGE BODY'
420: and object_name='DBMS_PROFILER';

Line 418: select 'Y' into l_run_ok from all_objects

414: -- Check if the profiler package and the tables exist, if not log and exit.
415: BEGIN
416: select 'Y' into l_run_ok from all_objects
417: where owner='SYS' and object_type='PACKAGE' and object_name='DBMS_PROFILER';
418: select 'Y' into l_run_ok from all_objects
419: where owner='SYS' and object_type='PACKAGE BODY'
420: and object_name='DBMS_PROFILER';
421:
422: select 'Y' into l_run_ok from all_tables