APPS.PAYPLNK dependencies on FND_SESSIONS

Line 285: -- Need a row in fnd_sessions if it does not exist (bug 372339).

281: hr_utility.set_message(800, 'HR_449106_BEE_UPGRADING');
282: hr_utility.raise_error;
283: end if;
284: --
285: -- Need a row in fnd_sessions if it does not exist (bug 372339).
286: -- It may exist because next run_process may use same concurrent manager session
287: -- (this will not be neccessary when hr_utility.fnd_insert will do the check for
288: -- existing row before its insert).
289: --

Line 293: from fnd_sessions

289: --
290: begin
291: select null
292: into l_dummy
293: from fnd_sessions
294: where session_id = userenv('sessionid');
295: exception
296: when no_data_found then
297: l_row_not_exists := TRUE;

Line 2876: l_fnd_sessions_date date;

2872: l_error_num number;
2873: l_warning_num number;
2874: --(bug 372339).
2875: l_health_plan_benefit boolean := TRUE;
2876: l_fnd_sessions_date date;
2877: l_commit number;
2878: --
2879: column_is_null exception;
2880: both_nulls exception;

Line 3195: l_fnd_sessions_date := sysdate;

3191: exception
3192: when no_data_found then
3193: l_health_plan_benefit := FALSE;
3194: end;
3195: l_fnd_sessions_date := sysdate;
3196: close csr_asg_lines;
3197: --
3198: --
3199: -- Validate each batch line in turn.

Line 3216: -- different from the previous one then update the row in fnd_sessions.

3212: SET effective_date = g_line_record.effective_date
3213: WHERE CURRENT OF csr_asg_lines;
3214: --
3215: -- If element is a benefit and effective_date for this line is
3216: -- different from the previous one then update the row in fnd_sessions.
3217: -- This will ensure that the entry is validated against coverage_type as on the
3218: -- date when entry will start (bug 372339).
3219: --
3220: if l_health_plan_benefit and

Line 3221: g_line_record.effective_date <> l_fnd_sessions_date then

3217: -- This will ensure that the entry is validated against coverage_type as on the
3218: -- date when entry will start (bug 372339).
3219: --
3220: if l_health_plan_benefit and
3221: g_line_record.effective_date <> l_fnd_sessions_date then
3222: dt_fndate.change_ses_date(g_line_record.effective_date,l_commit);
3223: l_fnd_sessions_date := g_line_record.effective_date;
3224: end if;
3225: --

Line 3223: l_fnd_sessions_date := g_line_record.effective_date;

3219: --
3220: if l_health_plan_benefit and
3221: g_line_record.effective_date <> l_fnd_sessions_date then
3222: dt_fndate.change_ses_date(g_line_record.effective_date,l_commit);
3223: l_fnd_sessions_date := g_line_record.effective_date;
3224: end if;
3225: --
3226: --
3227: -- Initialise variables