DBA Data[Home] [Help]

APPS.PAY_KR_YEA_PDF_PKG dependencies on FND_SESSIONS

Line 342: from fnd_sessions

338: --
339: cursor csr_session
340: is
341: select rowid
342: from fnd_sessions
343: where session_id = userenv('sessionid')
344: for update nowait;
345: --
346: begin

Line 353: insert into fnd_sessions(

349: fetch csr_session into l_rowid;
350: --
351: if csr_session%notfound then
352: --
353: insert into fnd_sessions(
354: session_id,
355: effective_date)
356: values(
357: userenv('sessionid'),

Line 362: update fnd_sessions

358: p_effective_date);
359: --
360: else
361: --
362: update fnd_sessions
363: set effective_date = p_effective_date
364: where rowid = l_rowid;
365: --
366: end if;

Line 380: from fnd_sessions

376: is
377: begin
378: --
379: delete
380: from fnd_sessions
381: where session_id = userenv('sessionid');
382: --
383: end delete_session;
384: --