Thanks for sharing guys!
Most of my templates call custom code and are written to our company standards. I also don't have a place to share them yet. When the file sharing pages are up, maybe I'll make some of them more generic and post some examples. I'll share 2 ideas that help me though.
1. I put templates in the Program Units folder for all kinds of stuff. For example, UNIX shell scripts, table create scripts, data fix scripts etc. that conform to our company standards. I like how the templates work, so I start my UNIX shells in PL/SQL Developer first!
2. I "code by number". For example, I have a folder called "All My Stuff". In it, I have a folder called "files". In the files folder, I have 3 templates. "1. File variables"; another called "2. File initialize" that names the file and opens it; and another called "3. File Finalize" that flushes and closes the file.
Another example - for e-mails I call our custom e-mail package. I have a folder called e-mail with 3 templates: "1. Variables"; "2. email text" that contains the text and file attachments; and "3. Send the e-mail".
Those are simpler ones, but I have some with more steps and one to create spreadsheets that is 7 steps long. They help me code faster. The basic idea is to look for patterns that are done over and over and put them into steps.
. I will let you know when our file sharing pages are up.
