[Home] [Help]
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);
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: