| Previous | Next |  | Contents | Index | Glossary

## Requisition Process Activities

Following is a description of each activity listed by the activity's display name. You can create all the components for an activity in the graphical Oracle Workflow Builder except for the PL/SQL stored procedures that the function activities call. Function activities can execute functions external to the database by integration with Oracle8 i Advanced Queues or execute PL/SQL stored procedures which you must create and store in the Oracle RDBMS. All the function activities in the Requisition process execute PL/SQL stored procedures. The naming convention for the PL/SQL stored procedures used in the Requisition process is:

    WF_REQDEMO.<PROCEDURE>

`WF_REQDEMO` is the name of the package that groups all the procedures used by the Requisition process. `<PROCEDURE>` represents the name of the procedure.

Several activities are described in greater depth to give you an idea of how they are constructed. See: Example Function Activities and Example Notification Activities.

#### Start (Node 1)

This is a Standard function activity that simply marks the start of the process.

Function | WF_STANDARD.NOOP
Result Type | None
Prerequisite Activities | None

#### Select Approver (Node 2)

This function activity determines who the next approver is for the requisition by checking the employee approval hierarchy table. This activity also saves the name of the previous approver or the name of the preparer if the requisition was never approved before. If an approver is found, this procedure returns a value of `'T'`, for True, otherwise it returns a value of `'F'` for False.

Function | WF_REQDEMO.SelectApprover
Result Type | Boolean
Prerequisite Activities | None

#### Notify Requestor No Approver Available (Node 3)

This activity notifies the requisition preparer that no appropriate approver could be found for the requisition. The message includes 'Send' attributes that display the requisition number, requisition description, requisition amount, and who the last approver was, if there was any.

This activity occurs in process node 3. If you display the property page of the node, you see that the activity is assigned to a performer whose name is stored in an item type attribute named Requestor Username.

Message | Requisition No Approver Found
Result Type | None
Prerequisite Activities | Select Approver

#### Notify Requestor of Forward (Node 5)

This activity notifies the requisition preparer that the requisition was forwarded for approval. The message includes 'Send' attributes that display the requisition number, requisition description, requisition amount, name of the approver that the requisition is forwarded to, name of the previous approver, if any, and the most recent comments appended to the requisition.

If you display the property page of this node, you see that the activity is assigned to a performer whose name is stored in an item type attribute named Requestor Username.

Message | Requisition Forward
Result Type | None
Prerequisite Activities | Select Approver

#### Record Requisition Forward (Node 6)

Currently this activity does nothing, however, if you have a Purchasing/Requisition application that you wish to integrate this workflow into, you can customize this activity to execute a PL/SQL stored procedure that updates your purchasing/requisition application table to indicate that the requisition is being forwarded to the next approver.

Function | WF_REQDEMO.Forward_Req
Result Type | None
Prerequisite Activities | Select Approver

#### And (Node 7)

This Standard function activity merges two or more parallel branches in the flow only when the activities in all of those branches complete.

Function | WF_STANDARD.ANDJOIN
Result Type | None
Prerequisite Activities | Must have at least two separate activities that each transition into this activity.

#### Notify Approver (Node 8)

This activity is a subprocess that notifies the approver that an action needs to be taken to either approve or reject the requisition. To view the subprocess, double-click on Notify Approver under the Processes branch in the navigator tree. The subprocess sends a notification to the approver and if the approver does not respond within a specified time, sends another reminder notification to the approver to take action. See: Summary of the Notify Approver Subprocess.

Result Type | Approval
Prerequisite Activities | Select Approver

#### Reject Requisition (Node 9)

Currently this activity does nothing, however, if you have a Purchasing/Requisition application that you wish to integrate this workflow into, you can customize this activity to execute a PL/SQL stored procedure that updates your purchasing/requisition application table to indicate that the requisition is rejected.

Function | WF_REQDEMO.Reject_Req
Result Type | None
Prerequisite Activities | Select Approver, Notify Approver

#### Notify Requestor of Rejection (Node 10)

This activity notifies the requisition preparer that the requisition was rejected. The message includes 'Send' attributes that display the requisition number, requisition description, requisition amount, name of the manager that rejected the requisition, and comments from that manager.

If you display the property page of this activity node, you see that the activity is assigned to a performer whose name is stored in an item type attribute named Requestor Username.

Message | Requisition Rejected
Result Type | None
Prerequisite Activities | Notify Approver

#### Verify Authority (Node 12)

This function activity verifies whether the current approver has sufficient authority to approve the requisition. The procedure compares the requisition amount with the approver's approval limit amount and returns a value of `'Y'` for Yes or `'N'` for No. If your business rules are not sensitive to the amount that an approver can approve, then you can remove this activity to customize the process.

Function | WF_REQDEMO.VerifyAuthority
Result Type | Yes/No
Prerequisite Activities | Select Approver and Notify Approver

#### Approve Requisition (Node 13)

Currently this activity does nothing, however, if you have a Purchasing/Requisition application that you wish to integrate this workflow into, you can customize this activity to execute a PL/SQL stored procedure that updates your purchasing/requisition application table to indicate that the requisition is approved.

Function | WF_REQDEMO.Approve_Req
Result Type | None
Prerequisite Activities | Select Approver, Notify Approver, Verify Authority

#### Notify Requestor of Approval (Node 14)

This activity notifies the requisition preparer that the requisition was approved. The message includes "Send" attributes that display the requisition number, requisition description, requisition amount, approver name, and comments from the approver.

If you display the property page of the activity node, you see that the activity is assigned to a performer whose name is stored in an item type attribute named Requestor Username.

Message | Requisition Approved
Result Type | None
Prerequisite Activities | Select Approver, Notify Approver, Verify Authority

#### End (Nodes 4, 11, and 15)

This function activity marks the end of the process. Although the activity itself does not have a result type, each node of this activity in the process must have a process result assigned to it. The process result is assigned in the property page of the activity node. Since the Requisition process activity has a result type of Approval, each End activity node must have a process result matching one of the lookup codes in the Approval lookup type.

Function | WF_STANDARD.NOOP
Result Type | None
Prerequisite Activities | Start

| Previous | Next |  | Contents | Index | Glossary