[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into ad_zd_logs
( log_sequence,
module,
message_text,
session_id,
type ,
timestamp)
values (AD_ZD_LOGS_S.NEXTVAL,
l_module,
l_message,
SYS_CONTEXT('USERENV', 'SESSIONID'),
l_type,
current_timestamp);
select oracle_username into l_applsys
from system.fnd_oracle_userid
where read_only_flag in ('E')
and rownum < 2 ;