DBA Data[Home] [Help]

APPS.GHR_WF_WGI_PKG dependencies on FND_SESSIONS

Line 1051: Cursor c_fnd_sessions is

1047: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE
1048: ,p_gbx_user_id in ghr_pois.person_id%TYPE)
1049: is
1050: --
1051: Cursor c_fnd_sessions is
1052: Select 1
1053: From fnd_sessions
1054: where session_id = userenv('sessionid');
1055: -- Local variables

Line 1053: From fnd_sessions

1049: is
1050: --
1051: Cursor c_fnd_sessions is
1052: Select 1
1053: From fnd_sessions
1054: where session_id = userenv('sessionid');
1055: -- Local variables
1056: --
1057: l_exists boolean := false;

Line 1458: -- The previous code did not perform a commit after writing to fnd_sessions

1454:
1455: dt_fndate.change_ses_date(p_ses_date => trunc(sysdate),
1456: p_commit => l_commit
1457: );
1458: -- The previous code did not perform a commit after writing to fnd_sessions
1459: -- Hence not issuing a Commit based on the value of the l_commit out variable
1460:
1461:
1462: