APPS.PAY_JP_DEF_SS dependencies on FND_SESSIONS

Line 164: from fnd_sessions

160: is
161: l_rowid rowid;
162: cursor csr_session is
163: select rowid
164: from fnd_sessions
165: where session_id = userenv('sessionid')
166: for update nowait;
167: begin
168: open csr_session;

Line 171: insert into fnd_sessions(

167: begin
168: open csr_session;
169: fetch csr_session into l_rowid;
170: if csr_session%notfound then
171: insert into fnd_sessions(
172: session_id,
173: effective_date)
174: values( userenv('sessionid'),
175: p_effective_date);

Line 177: update fnd_sessions

173: effective_date)
174: values( userenv('sessionid'),
175: p_effective_date);
176: else
177: update fnd_sessions
178: set effective_date = p_effective_date
179: where rowid = l_rowid;
180: end if;
181: close csr_session;

Line 190: from fnd_sessions

186: procedure delete_session
187: is
188: begin
189: delete
190: from fnd_sessions
191: where session_id = userenv('sessionid');
192: end delete_session;
193: -- |---------------------------------------------------------------------------|
194: -- |--------------------------------< changed >--------------------------------|