This purpose of this application is to allow development teams to create an online Rules & Guidelines development document. The template for this application is based on Patrick Cimolini's (Cayman Islands Government) presentation at ODTUG.

The concept of the R&G template is:

Rule: Follow 100% of the timeGuideline: Follow 90% of the time

Mandatory Headings:

Rule/Guideline: Active voice sentence.Why:Important for Team Buy-In

Optional Headings:

Result: Illustration of desired outcomeHow: How the result is achieved.Notes: State the non-obviousSee Also: Point to related Rules and Guidelines

You can use this template for both APEX development and your PL/SQL standards. I've included the installation files in the demo application so feel free to install at your organization. If you are using it please post any comments/suggestions on this post and I'll try to write some updates.

Dimitri made a similar suggestion about doing validations for each rule. Patrick Wolf created the APEX Essentials tool which does all the validations. I'll have to see how/if I can tie my application into his.

I didn't enter it to competition - I was to slow (lazy).But you can enjoy it here:http://apex.oracle.com/pls/otn/f?p=20622:4

I think that the idea of some kind of source/quality control tool for APEX is in the air.

I also caught this virus and wrote an application (APEX of course) that uses database trigger to log all changes to the database objects. User could review these changes, compare old and new code for packages, procedures and so on…

It is not bad but this is just one piece of a puzzle and what we need is source control for apex project plus source control for stored procedures, data model plus quality control for all parts of the project based on rules.