APPS.GHR_ELT_TO_BEN_PKG dependencies on FND_SESSIONS

Line 479: UPDATE fnd_sessions SET SESSION_ID = l_sid

475: EXIT;
476: END LOOP;
477:
478: BEGIN
479: UPDATE fnd_sessions SET SESSION_ID = l_sid
480: WHERE SESSION_ID = l_sid;
481: IF SQL%NOTFOUND THEN
482: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
483: VALUES (l_sid,sysdate);

Line 482: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)

478: BEGIN
479: UPDATE fnd_sessions SET SESSION_ID = l_sid
480: WHERE SESSION_ID = l_sid;
481: IF SQL%NOTFOUND THEN
482: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
483: VALUES (l_sid,sysdate);
484: END IF;
485: END;
486:

Line 2237: from fnd_sessions

2233: l_peopleei_data per_people_extra_info%rowtype;
2234:
2235: cursor get_sess_date is
2236: select trunc(effective_date)
2237: from fnd_sessions
2238: where session_id = l_session_id;
2239:
2240: cursor c_peopleei_getovn(cp_people_ei_id number) is
2241: select object_version_number

Line 2397: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)

2393: select userenv('sessionid') INTO l_session_id from dual;
2394: open get_sess_date;
2395: fetch get_sess_date into l_sess_date;
2396: IF get_sess_date%NOTFOUND THEN
2397: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
2398: values(l_session_id,l_calculated_date);
2399: ELSIF l_sess_date <> l_calculated_date then
2400: update fnd_sessions set effective_date = l_calculated_date
2401: where session_id = l_session_id;

Line 2400: update fnd_sessions set effective_date = l_calculated_date

2396: IF get_sess_date%NOTFOUND THEN
2397: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
2398: values(l_session_id,l_calculated_date);
2399: ELSIF l_sess_date <> l_calculated_date then
2400: update fnd_sessions set effective_date = l_calculated_date
2401: where session_id = l_session_id;
2402: end if;
2403: close get_sess_date;
2404: ghr_history_fetch.fetch_peopleei(p_person_id => l_person_id,