APPS.HR_H2PI_BG_UPLOAD dependencies on FND_SESSIONS

Line 375: FROM fnd_sessions

371:
372: --
373: CURSOR csr_session_date is
374: SELECT effective_date
375: FROM fnd_sessions
376: WHERE session_id = userenv('sessionid');
377: --
378: v_ud_hr_org hr_h2pi_hr_organizations%ROWTYPE;
379: l_hr_org_id hr_all_organization_units.organization_id%TYPE := NULL;

Line 400: -- Insert fnd_sessions row

396:
397: BEGIN
398: hr_utility.set_location('Entering:'|| l_proc, 10);
399:
400: -- Insert fnd_sessions row
401: OPEN csr_session_date;
402: hr_utility.set_location(l_proc, 11);
403: FETCH csr_session_date into l_session_date;
404: hr_utility.set_location(l_proc, 12);

Line 407: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)

403: FETCH csr_session_date into l_session_date;
404: hr_utility.set_location(l_proc, 12);
405: IF csr_session_date%notfound then
406: hr_utility.set_location(l_proc, 13);
407: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
408: values(userenv('sessionid'), trunc(SYSDATE));
409: hr_utility.set_location(l_proc, 14);
410: hr_utility.set_location(l_proc || ': ' || userenv('sessionid'), 15);
411: END IF;