Line 576: UPDATE fnd_sessions SET SESSION_ID = l_sid
572: EXIT;
573: END LOOP;
574:
575: BEGIN 576: UPDATE fnd_sessions SET SESSION_ID = l_sid 577: WHERE SESSION_ID = l_sid;
578: IF SQL%NOTFOUND THEN
579: INSERT INTO fnd_sessions
580: (SESSION_ID,EFFECTIVE_DATE)
Line 579: INSERT INTO fnd_sessions
575: BEGIN
576: UPDATE fnd_sessions SET SESSION_ID = l_sid
577: WHERE SESSION_ID = l_sid;
578: IF SQL%NOTFOUND THEN 579: INSERT INTO fnd_sessions 580: (SESSION_ID,EFFECTIVE_DATE)
581: VALUES
582: (l_sid,sysdate);
583: END IF;