The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT substr(replace(user_concurrent_program_name,'''',' '),1,240),
substr(concurrent_program_name,1,30)
INTO user_conc_program_name, conc_program_name
FROM FND_CONCURRENT_PROGRAMS_VL
WHERE concurrent_program_id = conc_program_id
AND APPLICATION_ID = fnd_global.prog_appl_id;
SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS')
INTO timestamp
FROM SYS.DUAL;
concat_var :='SELECT ' || ''''||
'TRACE_USER_DETAILS: '||
'TIMESTAMP='||
nvl(timestamp,' ')||': '||
'USER_NAME='||
nvl(user_name,' ')||': '||
'CONC_REQUEST_ID='||
nvl(output_conc_request_id,' ')||': '||
'OLTP_OPT_MODE='||
nvl(oltp_opt_mode,' ')||': '||
'CONC_OPT_MODE='||
nvl(conc_opt_mode,' ')||': '||
'CONC_PROG_EXE='||
nvl(conc_program_name,' ')||': '||
'CONC_PROG_NAME='||
nvl(user_conc_program_name,' ')||': '||
'RESPONSIBILITY='||
nvl(resp_name,' ')||': '||
'APPL_NAME='||
nvl(application_short_name,' ')||
''''|| ' FROM DUAL' ;
INSERT INTO FND_TRACE_LOG VALUES (
user_name,
sysdate,
conc_request_id,
oltp_opt_mode,
conc_opt_mode,
conc_program_name,
user_conc_program_name,
resp_name,
application_short_name
);