Work on Stored Procs

Primary task today is to finish I18N work on a set of stored procs.
TODO: IDs generated for l10n strings will differ between dev, test and prod systems. These will need to be tracked and accounted for. Ideally, some way to keep them the same will present itself.
Also today, a brown bag lunch where I'll be presenting on Ch. 1 from the Design Patterns book. This will largely be review, but I am planning on including some material from the introduction. This material covers problem-solving approaches, and is good for any general situtation:

1. Slow down, stop and think.
2. There are no dumb questions. Avoid assumptions about the problem. Understand the problem as thoroughly as possible.
3. Talk about it, out loud. This uses a different part of the brain and will aid understanding and problem-solving. Ideally talking to another person.
4. Design the solution. Understand what conclusion you are trying to reach, and write down all the steps needed to get there.

Okay. Wrapped up conversion of stored procs. Five needed to be modified to receive a locale key string as a parameter. Derek has been notified of the changes by email, I'll need to follow up with him on these to make sure the java code changes appropriately.
Next up is to ensure that the I18N strings are in the LocalizedString table.
Also, fix the javascript for the pop-up calendar so that it properly handles foreign date formats, and also the DateScanner code so that it can receive those formats and properly parse them into java Date objects. As soon as this is done, Dale can begin testing parts of the system.