The Workflow Engine APIs can be called by an application program or a workflow function in the runtime phase to communicate with the engine and to change the status of each of the activities. These APIs are defined in a PL/SQL package called WF_ENGINE.

Many of these Workflow Engine APIs also have corresponding Java methods that you can call from any Java program to integrate with Oracle Workflow. The following list indicates whether the Workflow Engine APIs are available as PL/SQL functions/procedures, as Java methods, or both.

• CreateProcess - PL/SQL and Java

• SetItemUserKey - PL/SQL and Java

• GetItemUserKey - PL/SQL and Java

• GetActivityLabel - PL/SQL

• SetItemOwner - PL/SQL and Java

• StartProcess - PL/SQL and Java

• LaunchProcess - PL/SQL and Java

• SuspendProcess - PL/SQL and Java

• ResumeProcess - PL/SQL and Java

• AbortProcess - PL/SQL and Java

• CreateForkProcess - PL/SQL

• StartForkProcess - PL/SQL

• Background - PL/SQL

• AddItemAttribute - PL/SQL and Java

• AddItemAttributeArray - PL/SQL

• SetItemAttribute - PL/SQL and Java

• setItemAttrFormattedDate - Java

• SetItemAttributeArray - PL/SQL

• getItemTypes - Java

• GetItemAttribute - PL/SQL

• GetItemAttrClob - PL/SQL

• getItemAttributes - Java

• GetItemAttrInfo - PL/SQL

• GetActivityAttrInfo - PL/SQL

• GetActivityAttribute - PL/SQL

• GetActivityAttrClob - PL/SQL

• getActivityAttributes - Java

• BeginActivity - PL/SQL

• CompleteActivity - PL/SQL and Java

• CompleteActivityInternalName - PL/SQL

• AssignActivity - PL/SQL

• Event - PL/SQL

• HandleError - PL/SQL and Java

• SetItemParent - PL/SQL and Java

• ItemStatus - PL/SQL and Java

• getProcessStatus - Java

Some Workflow Engine APIs use PL/SQL table composite datatypes defined in the WF_ENGINE package. The following table shows the column datatype definition for each PL/SQL table type.

PL/SQL Table Types in WF_ENGINE