DBA Data[Home] [Help]

APPS.GHR_ELT_TO_BEN_PKG dependencies on FND_SESSIONS

Line 476: UPDATE fnd_sessions SET SESSION_ID = l_sid

472: EXIT;
473: END LOOP;
474:
475: BEGIN
476: UPDATE fnd_sessions SET SESSION_ID = l_sid
477: WHERE SESSION_ID = l_sid;
478: IF SQL%NOTFOUND THEN
479: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
480: VALUES (l_sid,sysdate);

Line 479: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)

475: BEGIN
476: UPDATE fnd_sessions SET SESSION_ID = l_sid
477: WHERE SESSION_ID = l_sid;
478: IF SQL%NOTFOUND THEN
479: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
480: VALUES (l_sid,sysdate);
481: END IF;
482: END;
483: