APPS.PQH_GEN_FORM dependencies on FND_SESSIONS

Line 45: l_session_id fnd_sessions.session_id%type;

41: -- local Variables
42: l_ins varchar2(32000);
43: l_sel varchar2(32000);
44: l_where varchar2(32000);
45: l_session_id fnd_sessions.session_id%type;
46: l_effective_date date;
47: --
48: -- Primary Cursor fetching txn related details
49: --

Line 200: from fnd_sessions

196: and a.enable_flag = 'Y' ;
197: --
198: cursor c_session is
199: select session_id, effective_date
200: from fnd_sessions
201: where session_id = userenv('sessionid')
202: for update of effective_date;
203: --
204: --internal function

Line 231: insert into fnd_sessions (session_id, effective_date)

227: open c_session ;
228: fetch c_session into l_session_id, l_effective_date;
229: --
230: if c_session%notfound then
231: insert into fnd_sessions (session_id, effective_date)
232: values ( userenv('sessionid'), nvl(rec.src_effective_date, trunc(sysdate)));
233: else
234: update fnd_sessions
235: set effective_date = nvl(rec.src_effective_date,trunc(sysdate))

Line 234: update fnd_sessions

230: if c_session%notfound then
231: insert into fnd_sessions (session_id, effective_date)
232: values ( userenv('sessionid'), nvl(rec.src_effective_date, trunc(sysdate)));
233: else
234: update fnd_sessions
235: set effective_date = nvl(rec.src_effective_date,trunc(sysdate))
236: where current of c_session;
237: end if;
238: close c_session;