DBA Data[Home] [Help]

APPS.CLN_DEBUG_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

          select substr('cln-' || to_char(sysdate,'dd-mon-yyyy') || '-' || lpad(cln_debug_s.nextval,6,'0'),1,22) || '.dbg'
          into G_FILE
          from dual;
Line: 37

    G_Debug_tbl.DELETE;