APPS.BSC_MESSAGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

	G_Msg_Tbl.Delete;

Line: 150

       Insert Into BSC_MESSAGE_LOGS(
		Source,
		Type,
		Message,
		Creation_Date, Created_By,
		Last_Update_Date, Last_Updated_By,
		Last_Update_Login)
       Values(x_source, x_type, l_msg_str,
              SYSDATE, G_user_id,
              SYSDATE, G_user_id, G_session_id
              );

Line: 174

	Insert Into BSC_MESSAGE_LOGS(
		Source,
		Type,
		Message,
		Creation_Date, Created_By,
		Last_Update_Date, Last_Updated_By,
		Last_Update_Login)
       	Values (
    		G_Msg_Tbl(i).Source,
		G_Msg_Tbl(i).Type,
    		G_Msg_Tbl(i).Message,
		SYSDATE, G_user_id,
                SYSDATE, G_user_id, G_session_id
		);

Line: 206

	delete
	from 	BSC_MESSAGE_LOGS
        where
               	last_update_login = G_session_id;