The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'dbg' || fnd_debug_rule_executions_s.nextval || '.log'
into trc_file_name
from dual;
select rtrim(substr(machine, instr(machine,'\')+1),
FND_GLOBAL.local_chr(0))
into node_name
from gv$session
where audsid = userenv('SESSIONID');
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;