Portion of AskTom Office Hours session, considering the PL/SQL you don't need to write.
The recording will be made available at AskTOM
This application demonstrates
- HTML Expression
- Conditions
- 12c Triggers
- Interpreted PL/SQL
- Exceptions
- Supplied APIs
Any required DDL can be copied from the page that utilises it - just simple tables.