556: EXIT;
557: END LOOP;
558:
559: BEGIN
560: UPDATE fnd_sessions SET SESSION_ID = l_sid
561: WHERE SESSION_ID = l_sid;
562: IF SQL%NOTFOUND THEN
563: INSERT INTO fnd_sessions
564: (SESSION_ID,EFFECTIVE_DATE)
559: BEGIN
560: UPDATE fnd_sessions SET SESSION_ID = l_sid
561: WHERE SESSION_ID = l_sid;
562: IF SQL%NOTFOUND THEN
563: INSERT INTO fnd_sessions
564: (SESSION_ID,EFFECTIVE_DATE)
565: VALUES
566: (l_sid,sysdate);
567: END IF;