To Define a Document Attribute
2. You can identify one of two types of document for a document attribute: a PL/SQL document or an external document stored in a Document Management repository.
3. A PL/SQL document represents data from the database, generated from a PL/SQL procedure. Specify the default value of a PL/SQL document as
plsql:<procedure>/<document_identifier>.
Replace <procedure> with the PL/SQL package and procedure name, separated with a period. Replace <document_identifier> with the PL/SQL argument string that you want to pass directly to the procedure. The argument string should identify the document.
Note: The PL/SQL procedure must follow a standard API format. See:Standard API for a "PL/SQL" Document.
For example, the following string represents the PL/SQL document, po_req:2034, generated by the procedure po_wf.show_req.
plsql:po_wf.show_req/po_req:2034
4. If you wish to generate the document identifier for a PL/SQL document dynamically, you can token substitute the document identifier with other item type attributes. See: To Token Substitute an Attribute.
plsql:po_wf.show_req/&item_attr1:&item_attr2
Note: If you are defining a message attribute of type Document, you can also include a special token in your argument string called &#NID which Oracle Workflow substitutes with the notification ID of the runtime notification.
5. To specify a document managed by an external document management system, enter the following in the default value field:
DM:<node_ID>:<document_ID>:[version]
Replace <node_ID> with the node ID of the document management system, as listed in the Document Management Nodes web page. Replace <document_ID> with the ID assigned to the document by the document management system. You may also optionally specify the version number of the document, if multiple versions of the document exist. See: Defining Document Management Repositories.
6. Choose OK when you are done.