9: P_Detail_1 := NVL(P_Detail,'Y');
10:
11: --hr_standard.event('BEFORE REPORT');
12:
13: insert into fnd_sessions (session_id,
14: effective_date)
15: select userenv('sessionid'),
16: trunc(sysdate)
17: from sys.dual
16: trunc(sysdate)
17: from sys.dual
18: where not exists
19: (select 1
20: from fnd_sessions fs
21: where fs.session_id = userenv('sessionid'));
22: BEGIN
23: SELECT parameter_value
24: INTO l_trace_value