APEX is famous for it’s useful applications, so when the idea poped into my head that I would like to track my personal contracts, APEX was first in line to develop such an application.

The purpose of this app is to be able to track longrunning contracts with their renewalperiods. One month before you should end the contract (checked on contract enddate) you’ll receive an email. I used Oracle’s DBMS_SCHEDUAL to call the procedure that sends out the email. Also, it has an authentication scheme so that different users can use this online app. Although it’s dutch, everyone can apply now.

 http://apex.oracle.com/pls/otn/f?p=23729

Popularity: 255 points