Within a database their are a variety of locks available, many developers do not use locks explicitly. They use stored procedures which lock the data that they need. Stored procedures also promote code reuse in multiple applications. How far can stored procedures go this way? Discuss.