APPS.BSC_SECURITY dependencies on BSC_MESSAGE_LOGS

Line 309: FROM bsc_message_logs

305: h_current_fn);
306:
307: SELECT COUNT(*)
308: INTO h_count
309: FROM bsc_message_logs
310: WHERE
311: type IN (DB_ERR_MSG, APP_ERR_MSG)
312: AND source = h_current_fn
313: AND Last_Update_Login = h_session_id;

Line 454: -- Clean BSC_MESSAGE_LOGS for the current session

450: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
451: h_session_id := USERENV('SESSIONID');
452: h_user_id := BSC_APPS.fnd_global_user_id;
453:
454: -- Clean BSC_MESSAGE_LOGS for the current session
455: DELETE bsc_message_logs
456: WHERE last_update_login = h_session_id;
457: commit;
458:

Line 455: DELETE bsc_message_logs

451: h_session_id := USERENV('SESSIONID');
452: h_user_id := BSC_APPS.fnd_global_user_id;
453:
454: -- Clean BSC_MESSAGE_LOGS for the current session
455: DELETE bsc_message_logs
456: WHERE last_update_login = h_session_id;
457: commit;
458:
459: BSC_SECURITY.Refresh_System_Lock(x_program_id);

Line 904: -- Clean BSC_MESSAGE_LOGS for the current session

900: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
901: h_session_id := USERENV('SESSIONID');
902: h_user_id := BSC_APPS.fnd_global_user_id;
903:
904: -- Clean BSC_MESSAGE_LOGS for the current session
905: DELETE bsc_message_logs
906: WHERE last_update_login = h_session_id;
907: commit;
908:

Line 905: DELETE bsc_message_logs

901: h_session_id := USERENV('SESSIONID');
902: h_user_id := BSC_APPS.fnd_global_user_id;
903:
904: -- Clean BSC_MESSAGE_LOGS for the current session
905: DELETE bsc_message_logs
906: WHERE last_update_login = h_session_id;
907: commit;
908:
909: -- Clean BSC_CURRENT_SESSIONS in the source system to leave only current sessions