Example Function Activities
In general, function activities must have the following information specified in its Activity property page:
- Internal name for the activity.
- Display name for the activity.
- Result type for the activity, which can be none or the name of a predefined lookup type.
- Name of the PL/SQL stored procedure that the activity calls.
Also, the PL/SQL stored procedure that a function activity calls must comply with a specific API. See: Standard API for PL/SQL Procedures Called by Function Activities.
You can view the scripts that create the WF_REQDEMO stored procedure package used by the Requisition Approval process in the demo subdirectory of the Oracle Workflow directory structure on your server.
See Also
Example: Select Approver
Example: Verify Authority