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 Data Modeling > Building Data Models > Triggers and Procedures