18.2.5 Choosing Descriptive Process Names

Choose clear process names and conditions to make execution chains easier to understand and maintain.

By using descriptive names, appropriate server-side conditions, and nesting chains as needed, you simplify maintenance of your processing logic. The final steps in the readable outline of logic to send a welcome packet include:
  • If User is HR Rep... execution chain conditionally includes materials only relevant for HR reps.
  • Zip Materials from Collection process invokes the ZIP_NOTICES procedure to prepare a zip file in a collection named NOTICES_ZIP containing the appropriate materials for the selected employee.
  • Email Recipient step shown below sends the zip file to the employee as an email attachment.

It uses a native Send E-Mail process type and configures &P34_EMPLOYEE_EMAIL. as the recipient in the To property. Using the Attachment SQL below, it includes the zip file by querying the BLOB from the NOTICES_ZIP collection.

select blob001                      as contents,
       'woods_newhire_notices.zip'  as file_name,
       'application/zip'            as mime_type,
       null /* Normal Attachment */ as content_id 
from apex_collections
where collection_name = 'NOTICES_ZIP'
fetch first row only

Figure 18-6 Sending Email with a Native Page Process