DBA Data[Home] [Help]

APPS.HR_JP_DATA_MIGRATION_PKG dependencies on FND_SESSIONS

Line 706: from fnd_sessions

702: --
703: cursor csr_session
704: is
705: select rowid
706: from fnd_sessions
707: where session_id = userenv('sessionid')
708: for update nowait;
709: --
710: begin

Line 717: insert into fnd_sessions(

713: fetch csr_session into l_rowid;
714: --
715: if csr_session%notfound then
716: --
717: insert into fnd_sessions(
718: session_id,
719: effective_date)
720: values(
721: userenv('sessionid'),

Line 726: update fnd_sessions

722: p_effective_date);
723: --
724: else
725: --
726: update fnd_sessions
727: set effective_date = p_effective_date
728: where rowid = l_rowid;
729: --
730: end if;

Line 744: from fnd_sessions

740: is
741: begin
742: --
743: delete
744: from fnd_sessions
745: where session_id = userenv('sessionid');
746: --
747: end delete_session;
748: --