DBA Data[Home] [Help]

APPS.FND_TRACE_UTILS dependencies on ALL_TABLES

Line 422: select 'Y' into l_run_ok from all_tables

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
423: where table_name='PLSQL_PROFILER_RUNS' and rownum =1 and owner like '%';
424: select 'Y' into l_run_ok from all_tables
425: where table_name='PLSQL_PROFILER_UNITS' and rownum =1 and owner like '%';
426: select 'Y' into l_run_ok from all_tables

Line 424: select 'Y' into l_run_ok from all_tables

420: and object_name='DBMS_PROFILER';
421:
422: select 'Y' into l_run_ok from all_tables
423: where table_name='PLSQL_PROFILER_RUNS' and rownum =1 and owner like '%';
424: select 'Y' into l_run_ok from all_tables
425: where table_name='PLSQL_PROFILER_UNITS' and rownum =1 and owner like '%';
426: select 'Y' into l_run_ok from all_tables
427: where table_name='PLSQL_PROFILER_DATA' and rownum =1 and owner like '%';
428: EXCEPTION

Line 426: select 'Y' into l_run_ok from all_tables

422: select 'Y' into l_run_ok from all_tables
423: where table_name='PLSQL_PROFILER_RUNS' and rownum =1 and owner like '%';
424: select 'Y' into l_run_ok from all_tables
425: where table_name='PLSQL_PROFILER_UNITS' and rownum =1 and owner like '%';
426: select 'Y' into l_run_ok from all_tables
427: where table_name='PLSQL_PROFILER_DATA' and rownum =1 and owner like '%';
428: EXCEPTION
429: WHEN NO_DATA_FOUND THEN
430: dlog('Profiler Package and/or Profiler Tables could not be accessed.');