DBA Data[Home] [Help]

APPS.PQH_RBC_STAGE dependencies on FND_SESSIONS

Line 8: from fnd_sessions

4: l_cnt number;
5: begin
6: select 1
7: into l_cnt
8: from fnd_sessions
9: where session_id = userenv('sessionid');
10: exception
11: when no_data_found then
12: hr_utility.set_location('session date not there, inserting',10);

Line 13: insert into fnd_sessions (session_id,effective_date) values (userenv('sessionid'),trunc(p_effective_date));

9: where session_id = userenv('sessionid');
10: exception
11: when no_data_found then
12: hr_utility.set_location('session date not there, inserting',10);
13: insert into fnd_sessions (session_id,effective_date) values (userenv('sessionid'),trunc(p_effective_date));
14: when others then
15: hr_utility.set_location('issues in session date pulling ',10);
16: raise;
17: end;