APPS.PAYPLNK dependencies on FND_SESSIONS

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

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

Line 291: from fnd_sessions

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

Line 2872: l_fnd_sessions_date date;

2868: l_error_num number;
2869: l_warning_num number;
2870: --(bug 372339).
2871: l_health_plan_benefit boolean := TRUE;
2872: l_fnd_sessions_date date;
2873: l_commit number;
2874: --
2875: column_is_null exception;
2876: both_nulls exception;

Line 3186: l_fnd_sessions_date := sysdate;

3182: exception
3183: when no_data_found then
3184: l_health_plan_benefit := FALSE;
3185: end;
3186: l_fnd_sessions_date := sysdate;
3187: close csr_asg_lines;
3188: --
3189: --
3190: -- Validate each batch line in turn.

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

3203: SET effective_date = g_line_record.effective_date
3204: WHERE CURRENT OF csr_asg_lines;
3205: --
3206: -- If element is a benefit and effective_date for this line is
3207: -- different from the previous one then update the row in fnd_sessions.
3208: -- This will ensure that the entry is validated against coverage_type as on the
3209: -- date when entry will start (bug 372339).
3210: --
3211: if l_health_plan_benefit and

Line 3212: g_line_record.effective_date <> l_fnd_sessions_date then

3208: -- This will ensure that the entry is validated against coverage_type as on the
3209: -- date when entry will start (bug 372339).
3210: --
3211: if l_health_plan_benefit and
3212: g_line_record.effective_date <> l_fnd_sessions_date then
3213: dt_fndate.change_ses_date(g_line_record.effective_date,l_commit);
3214: l_fnd_sessions_date := g_line_record.effective_date;
3215: end if;
3216: --

Line 3214: l_fnd_sessions_date := g_line_record.effective_date;

3210: --
3211: if l_health_plan_benefit and
3212: g_line_record.effective_date <> l_fnd_sessions_date then
3213: dt_fndate.change_ses_date(g_line_record.effective_date,l_commit);
3214: l_fnd_sessions_date := g_line_record.effective_date;
3215: end if;
3216: --
3217: --
3218: -- Initialise variables