DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_SESSIONS

Line 758: insert into FND_SESSIONS (

754: hmask varchar2(11) := 'DD-MON-YYYY';
755: begin
756: l_ses_date := nvl(to_date(session_date, hmask),
757: trunc(sysdate));
758: insert into FND_SESSIONS (
759: SESSION_ID,
760: EFFECTIVE_DATE)
761: select
762: userenv('SESSIONID'),

Line 767: from FND_SESSIONS

763: l_ses_date
764: from sys.dual
765: where not exists
766: (select null
767: from FND_SESSIONS
768: where SESSION_ID = userenv('SESSIONID'));
769:
770: commit;
771: exception