eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_DEF_SS dependencies on FND_SESSIONS

Line 171: from fnd_sessions

167: is
168: l_rowid rowid;
169: cursor csr_session is
170: select rowid
171: from fnd_sessions
172: where session_id = userenv('sessionid')
173: for update nowait;
174: begin
175: open csr_session;

Line 178: insert into fnd_sessions(

174: begin
175: open csr_session;
176: fetch csr_session into l_rowid;
177: if csr_session%notfound then
178: insert into fnd_sessions(
179: session_id,
180: effective_date)
181: values( userenv('sessionid'),
182: p_effective_date);

Line 184: update fnd_sessions

180: effective_date)
181: values( userenv('sessionid'),
182: p_effective_date);
183: else
184: update fnd_sessions
185: set effective_date = p_effective_date
186: where rowid = l_rowid;
187: end if;
188: close csr_session;

Line 197: from fnd_sessions

193: procedure delete_session
194: is
195: begin
196: delete
197: from fnd_sessions
198: where session_id = userenv('sessionid');
199: end delete_session;
200: -- |---------------------------------------------------------------------------|
201: -- |--------------------------------< changed >--------------------------------|