DBA Data[Home] [Help]

APPS.FND_TRACE_UTILS dependencies on ALL_OBJECTS

Line 418: select 'Y' into l_run_ok from all_objects

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

Line 420: select 'Y' into l_run_ok from all_objects

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