Previous	Next		Contents	Index	Navigation	Glossary	Library

Print out the following files before you begin writing project verification extensions. The files are located in the Oracle Projects admin/sql directory.

PAWFPCEB.pls	Project Workflow Extension Package Body Template. This file contains the procedures that you can modify to implement the extension.
PAWFPCES.pls	Project Workflow Extension Package Specification Template. If you create procedures outside the predefined procedure within the <pa_client_extn_project_wf package, you must also modify this file to include those new procedures.

Suggestion: After you write the procedures, do not forget to compile the extension and store it in the database. See: Writing PL/SQL Procedures.

Package Procedures

This procedure returns the project approver ID to the calling workflow process. You can modify the procedure to add rules to determine who can approve a project. The default procedure returns the ID of the supervisor of the person who submitted the project status change.

Table 1 - 126 lists the parameters that Oracle Projects provides for the select_project_approver procedure.

Parameter	Usage	Type	Description
p_project_id	IN	NUMBER	Identifier of the project.
p_workflow_ started_by_id	IN	NUMBER	Identifier of the person who submitted the project status change.
p_project_approver_ id	OUT	NUMBER	Identifier of the project approver.
Table 1 - 126. (Page 1 of 1) Select Project Approver Parameters

start_project_wf

This procedure starts the workflow process for project status changes.

Table 1 - 127 lists the parameters that Oracle Projects provides for the start_project_wf procedure.

Parameter	Usage	Type	Description
p_project_id	IN	NUMBER	Identifier of the project.
p_item_type	IN	VARCHAR2	The workflow item type.
p_process	IN	VARCHAR2	Name of the workflow process.
p_out_item_key	OUT	VARCHAR2	The workflow item key.
p_err_stack	OUT	VARCHAR2	Error handling stack.
p_err_stage	OUT	VARCHAR2	Error handling stage.
p_err_code	OUT	VARCHAR2	Error handling code.
Table 1 - 127. (Page 2 of 2) Start Project Workflow Parameters