Some general style guidelines to follow for the purpose of consistency across applications.
Standard indentation is four spaces. Our PL/SQL code is not only viewable in the SQL files but also through our SQL and PL/SQL browsers. This means that we should try to make it as consistent as possible to all source code readers.
Lowercase everything, with the exception of %TYPE and %ROWTYPE.