DBA Data[Home] [Help]

APPS.PAY_PYGBNSEX_XMLP_PKG dependencies on FND_SESSIONS

Line 16: insert into fnd_sessions (session_id, effective_date)

12:
13: begin
14: /*srw.user_exit('FND SRWINIT');*/null;
15:
16: insert into fnd_sessions (session_id, effective_date)
17: select userenv('sessionid'),trunc(sysdate)
18: from dual
19: where not exists
20: (select 1

Line 21: from fnd_sessions fs

17: select userenv('sessionid'),trunc(sysdate)
18: from dual
19: where not exists
20: (select 1
21: from fnd_sessions fs
22: where fs.session_id = userenv('sessionid'));
23: /*if p_effective_date is null then
24: p_effective_date := sysdate;
25: end if;*/