Previous	Next		Contents	Index	Glossary	Library

1. Select the item type that you want to create a function for in the navigator tree, then choose New Function from the Edit menu. Define your function activity in the Activity property page that appears.

2. A function activity must have an Internal Name (all uppercase and no spaces) and a Display Name, which is the translatable name that appears in your process diagram. Use the description to provide an explanation about this activity.

Attention: You cannot update the internal name of an activity once it is defined.

Caution: Do not include colons ":" or spaces in your internal name.

3. Enter the name of the PL/SQL stored procedure you want this function activity to execute, using the format: <package_name>.<procedure_name>. See: Standard API for PL/SQL Procedures Called by Function Activities.

4. Indicate the result type (a predefined Lookup Type) of this activity. Result types list the possible results returned by this activity. Your workflow diagram may branch depending on the value returned by your completed activity. See: To Create Lookup Types.

You can choose <None> as the result type if your activity does not return a value, or if your workflow process does not depend on the value returned.

5. Choose an icon that identifies your activity. You can use any icon, as long as the icon is stored in a .ico file, to symbolize the action of an activity. See: Adding Custom Icons to Oracle Workflow.

Choose Browse to view the icon files listed in the workflow icons subdirectory.

You can also drag and drop icon files from the Windows Explorer or File Manager onto an activity in your navigator tree to assign that icon to the activity.

6. Specify the cost of this function activity. See: Activity Cost.

7. Choose Apply to save your changes.

8. Select the Details tab to display and modify the Details property page of the activity. See: To Define Optional Activity Details.

9. Select the Roles tab page to specify the roles that have access to this function activity. (This functionality will be supported in a future release.)

10. Select the Access tab page to set the access levels allowed to modify this function. See: Allowing Access to an Object.

11. If you externalize a parameter for the PL/SQL stored procedure that your function activity calls, you can expose that parameter in Oracle Workflow Builder as an attribute of the function activity. Function activity attributes behave as parameters whose values you can modify for each usage of the activity in a process. Function activity attributes are specific to a function activity and are not global to a process. See: To Define an Item Type or Activity Attribute.

When you include a function activity in a process, you can assign a value to that function activity's attribute by displaying the Attribute Values properties page for that specific instance of the function activity. See: To Define Activity Attribute Values.

See Also

To Copy an Activity