The DBMS Trigger templates, Trigger template items, and Procedure templates are accessible via the tabs in the Resource Editor window. In addition, for Oracle, there is a tab for database package templates.
Templates for stored procedures are defined under the Procedure category in the DBMS tree view.
For more information, see the Triggers and Procedures chapter in the Data Modeling guide.