DBA Data[Home] [Help]

APPS.FND_DEBUG_REP_UTIL SQL Statements

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

Line: 39

     select 'dbg' || fnd_debug_rule_executions_s.nextval || '.log'
       into trc_file_name
       from dual;
Line: 92

      select rtrim(substr(machine, instr(machine,'\')+1),
			FND_GLOBAL.local_chr(0))
        into node_name
        from gv$session
       where audsid = userenv('SESSIONID');
Line: 127

    select DECODE(emethod, 'P', 'REPORTS',
                                'I', 'PLSQL_CP',
                                'J', 'JAVA_STORED_CP',
                                'K', 'JAVA_CP',
                                'Q', 'SQLPLUS_CP',
                                'E', 'PERL_CP',
                                'S', 'SUBROUTINE_CP',
                                'A', 'SPAWNED_CP',
                                'H', 'HOST_CP',
                                'L', 'LOADER_CP',
                                'NOT_SUPPORTED')
       into dbg_comp
       from dual;