APPS.HR_EMPLOYEE_API dependencies on FND_SESSIONS

Line 1501: select 1 into l_session_c from fnd_sessions

1497: hr_utility.set_location('Entering:'|| l_proc, 5);
1498: end if;
1499:
1500: begin
1501: select 1 into l_session_c from fnd_sessions
1502: where session_id=userenv('sessionid');
1503: exception
1504: when no_data_found then
1505: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),p_hire_date);

Line 1505: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),p_hire_date);

1501: select 1 into l_session_c from fnd_sessions
1502: where session_id=userenv('sessionid');
1503: exception
1504: when no_data_found then
1505: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),p_hire_date);
1506: l_session_c:=0;
1507: end;
1508:
1509: --

Line 1669: delete from fnd_sessions where session_id=userenv('sessionid');

1665: );
1666: --
1667:
1668: if(l_session_c = 0) then
1669: delete from fnd_sessions where session_id=userenv('sessionid');
1670: end if;
1671:
1672: end create_gb_employee;
1673: -- --------------------------------------------------------------------------