APPS.BEN_PBB_INS dependencies on FND_SESSIONS

Line 374: l_session_id fnd_sessions.session_id%type;

370: p_validation_start_date in date,
371: p_validation_end_date in date) is
372: --
373: l_proc varchar2(72) := g_package||'post_insert';
374: l_session_id fnd_sessions.session_id%type;
375: l_sess_effective_date date;
376: --
377: -- Bug : 2166235
378: --

Line 381: from fnd_sessions

377: -- Bug : 2166235
378: --
379: cursor c_fnd_session is
380: select session_id, effective_date
381: from fnd_sessions
382: where session_id = userenv('SESSIONID');
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);

Line 392: insert into fnd_sessions (SESSION_ID, effective_date)

388: fetch c_fnd_session into l_session_id, l_sess_effective_date;
389: --
390: if c_fnd_session%notfound then
391: --
392: insert into fnd_sessions (SESSION_ID, effective_date)
393: values (userenv('SESSIONID'), trunc(p_effective_date));
394: --
395: else
396: --

Line 397: update fnd_sessions set effective_date = trunc(p_effective_date)

393: values (userenv('SESSIONID'), trunc(p_effective_date));
394: --
395: else
396: --
397: update fnd_sessions set effective_date = trunc(p_effective_date)
398: where SESSION_ID = userenv('SESSIONID');
399: --
400: end if;
401: close c_fnd_session;

Line 416: update fnd_sessions set effective_date = l_sess_effective_date

412: );
413: --
414: if l_sess_effective_date is not null then
415: --
416: update fnd_sessions set effective_date = l_sess_effective_date
417: where SESSION_ID = userenv('SESSIONID');
418: --
419: end if;
420: --