DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on FND_SESSIONS

Line 3236: from fnd_sessions

3232: --
3233: cursor csr_session
3234: is
3235: select rowid
3236: from fnd_sessions
3237: where session_id = userenv('sessionid')
3238: for update nowait;
3239: --
3240: begin

Line 3247: insert into fnd_sessions(

3243: fetch csr_session into l_rowid;
3244: --
3245: if csr_session%notfound then
3246: --
3247: insert into fnd_sessions(
3248: session_id,
3249: effective_date)
3250: values(
3251: userenv('sessionid'),

Line 3256: update fnd_sessions

3252: p_effective_date);
3253: --
3254: else
3255: --
3256: update fnd_sessions
3257: set effective_date = p_effective_date
3258: where rowid = l_rowid;
3259: --
3260: end if;

Line 3274: from fnd_sessions

3270: is
3271: begin
3272: --
3273: delete
3274: from fnd_sessions
3275: where session_id = userenv('sessionid');
3276: --
3277: end delete_session;
3278: --