Skip Headers

Oracle Workflow Developer's Guide
Release 2.6.3

Part Number B10284-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

The Requisition Item Type

The Requisition process is associated with an item type called Requisition. Currently there are two workflow processes associated with Requisition: Requisition Approval and Notify Approver.

If you examine the property page of Requisition, you see that it has a persistence type of Temporary and persistence number of days of 0. This means that the run time data associated with any work items for this item type are eligible for purging as soon as they complete. You also see that it calls a selector function named WF_REQDEMO.SELECTOR. This selector function is an example PL/SQL stored procedure that returns the name of the process to run when more than one process exists for a given item type. The selector function in this example returns REQUISITION_APPROVAL or 'Requisition Approval' as the process to run.

The Requisition item type also has several attributes associated with it. These attributes reference information in the demonstration application tables. The attributes are used and maintained by function activities as well as notification activities throughout the process. The following table lists the Requisition item type attributes.

Display Name Description Type Length/Format/Lookup Type
Forward From Username Username of the person that the requisition is forwarded from Role  
Forward To Username Username of the person that the requisition is forwarded to Role  
Requestor Username Username of the requisition preparer Role  
Requisition Amount Requisition amount Number 9,999,999,999.99
Requisition Number Unique identifier of a requisition Text  
Monitor URL Monitor URL URL  
Requisition Description Unique user identifier of a requisition Text 80
Requisition Process Owner Username of the requisition owner Role  
Reminder Requisition Document Reminder Requisition Document is generated by PL/SQL Document  
Note Note Text  
Note for reminder Note for saving the previous responder's note Text  


         Previous  Next          Contents  Index  Glossary


Oracle Logo
Copyright © 2003 Oracle Corporation.

All rights reserved.