The Workflow Engine bulk APIs can be called by an application program in an Oracle E-Business Suite installation to launch multiple work items at once in bulk and to set values for item attributes in bulk across multiple work items. These APIs are defined in a PL/SQL package called WF_ENGINE_BULK.
Some Workflow Engine bulk APIs use PL/SQL table composite datatypes defined in the WF_ENGINE_BULK package. The following table shows the column datatype definition for each PL/SQL table type.
PL/SQL Table Types in WF_ENGINE_BULK
| PL/SQL Table Type | Column Datatype Definition |
|---|---|
| ItemKeyTabType | varchar2(240) |
| UserKeyTabType | varchar2(240) |
| OwnerRoleTabType | varchar2(320) |
Some Workflow Engine bulk APIs also use PL/SQL table composite datatypes defined in the WF_ENGINE package. See: PL/SQL Table Types in WF_ENGINE.