[Home] [Help]
6: begin
7:
8: --hr_standard.event('BEFORE REPORT');
9:
10: insert into fnd_sessions (session_id,
11: effective_date)
12: select userenv('sessionid'),
13: trunc(sysdate)
14: from sys.dual
13: trunc(sysdate)
14: from sys.dual
15: where not exists
16: (select 1
17: from fnd_sessions fs
18: where fs.session_id = userenv('sessionid'));
19: BEGIN
20: SELECT parameter_value
21: INTO l_trace_value