Line 560: UPDATE fnd_sessions SET SESSION_ID = l_sid
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)
Line 563: INSERT INTO fnd_sessions
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;