DBA Data[Home] [Help]

APPS.PAY_PAYGB45L_XMLP_PKG dependencies on FND_SESSIONS

Line 12: insert into fnd_sessions (session_id,effective_date)

8: l_test number;
9: l_ers_address varchar2(60);
10: begin
11: /*srw.user_exit('FND SRWINIT');*/null;
12: insert into fnd_sessions (session_id,effective_date)
13: select userenv('sessionid'),trunc(sysdate)
14: from dual
15: where not exists
16: (select 1

Line 17: from fnd_sessions fs

13: select userenv('sessionid'),trunc(sysdate)
14: from dual
15: where not exists
16: (select 1
17: from fnd_sessions fs
18: where fs.session_id = userenv('sessionid'));
19:
20: p_session_date:=sysdate;
21: p_date_today:=sysdate;