DBA Data[Home] [Help]

APPS.BSC_SECURITY dependencies on FND_SESSION_MANAGEMENT

Line 468: -- We have found that we can call the api FND_SESSION_MANAGEMENT.Check_Session,

464: --
465: -- Clean BSC_CURRENT_SESSIONS for ibuilder when users click "logout" button
466: -- Added for BIS Application ID (191), so that loader session is not removed.
467: -- Fix locking issue with icx sessions:
468: -- We have found that we can call the api FND_SESSION_MANAGEMENT.Check_Session,
469: -- passing the icx session id and it will return any 'VALID', 'INVALID' or 'EXPIRED'.
470: -- This function does the validations to see if the icx session is valid or not and
471: -- also if it has exprired. This is based on the values of TIME_OUT, TIME_LIMIT, GUEST,
472: -- DISABLED, etc for the icx session.

Line 486: -- Where (fnd_session_management.check_session(session_id, null, null, 'N') <> 'VALID')

482: --Delete bsc_current_sessions
483: --Where icx_session_id In (
484: -- Select session_id
485: -- From icx_sessions
486: -- Where (fnd_session_management.check_session(session_id, null, null, 'N') <> 'VALID')
487: -- );
488: --commit;
489: --
490: --metadata optimizer , loader are conc requests.if the conc request is not running anymore

Line 765: WHERE (FND_SESSION_MANAGEMENT.CHECK_SESSION(SESSION_ID,NULL,NULL,'N') <> 'VALID'));

761: DELETE BSC_CURRENT_SESSIONS
762: WHERE ICX_SESSION_ID IN (
763: SELECT SESSION_ID
764: FROM ICX_SESSIONS
765: WHERE (FND_SESSION_MANAGEMENT.CHECK_SESSION(SESSION_ID,NULL,NULL,'N') <> 'VALID'));
766:
767: --Delete all sessions, which have their concurrent programs in invalid or hang status
768: FOR cd IN c_sessions LOOP
769: IF(l_session_ids IS NULL ) THEN