DBA Data[Home] [Help]

APPS.GHR_PROCESS_SF52 dependencies on FND_SESSIONS

Line 2991: update fnd_sessions set SESSION_ID = l_sid

2987: exit;
2988: end loop;
2989:
2990: begin
2991: update fnd_sessions set SESSION_ID = l_sid
2992: where SESSION_ID = l_sid;
2993: if sql%notfound then
2994: INSERT INTO fnd_sessions
2995: (SESSION_ID,EFFECTIVE_DATE)

Line 2994: INSERT INTO fnd_sessions

2990: begin
2991: update fnd_sessions set SESSION_ID = l_sid
2992: where SESSION_ID = l_sid;
2993: if sql%notfound then
2994: INSERT INTO fnd_sessions
2995: (SESSION_ID,EFFECTIVE_DATE)
2996: VALUES
2997: (l_sid,sysdate);
2998: end if;