DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_SESSIONS

Line 734: insert into FND_SESSIONS (

730: hmask varchar2(11) := 'DD-MON-YYYY';
731: begin
732: l_ses_date := nvl(to_date(session_date, hmask),
733: trunc(sysdate));
734: insert into FND_SESSIONS (
735: SESSION_ID,
736: EFFECTIVE_DATE)
737: select
738: userenv('SESSIONID'),

Line 743: from FND_SESSIONS

739: l_ses_date
740: from sys.dual
741: where not exists
742: (select null
743: from FND_SESSIONS
744: where SESSION_ID = userenv('SESSIONID'));
745:
746: commit;
747: exception