In Oracle 10g, enhancements have been made to allow you to create applications in multiple languages using a language dimension.
See: