APPS.PAY_JP_ISDF_SS_PKG dependencies on FND_SESSIONS

Line 3903: from fnd_sessions

3899: --
3900: cursor csr_session
3901: is
3902: select rowid
3903: from fnd_sessions
3904: where session_id = userenv('sessionid')
3905: for update nowait;
3906: --
3907: begin

Line 3914: insert into fnd_sessions(

3910: fetch csr_session into l_rowid;
3911: --
3912: if csr_session%notfound then
3913: --
3914: insert into fnd_sessions(
3915: session_id,
3916: effective_date)
3917: values(
3918: userenv('sessionid'),

Line 3923: update fnd_sessions

3919: p_effective_date);
3920: --
3921: else
3922: --
3923: update fnd_sessions
3924: set effective_date = p_effective_date
3925: where rowid = l_rowid;
3926: --
3927: end if;

Line 3941: from fnd_sessions

3937: is
3938: begin
3939: --
3940: delete
3941: from fnd_sessions
3942: where session_id = userenv('sessionid');
3943: --
3944: end delete_session;
3945: --