Oracle Workflow Guide
Release 2.6.2

Part Number A95265-03
  Go to previous page Go to next page       Go To Table Of Contents Go To Index Go To Table Of Contents

                     Contents  Index  Glossary Master Index Feedback
 

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  
Requisition Description Unique user identifier of a requisition Text 30
Requisition Process Owner Username of the requisition owner Role  
Note Note Text  
Monitor URL Monitor URL URL  
Requisition Document Requisition Document is generated by PL/SQL Document  
Reminder Requisition Document Reminder Requisition Document is generated by PL/SQL Document  

 
         Previous  Next          Contents  Index  Glossary


Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.