Previous  Next          Contents  Index  Navigation  Glossary  Library

Writing Project Verification Extensions

Oracle Projects provides a template package and procedure that you use as the basis of your project verification extension procedures. The name of the template package is pa_client_extn_proj_status.

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

PAXPCECB.pls Project Verification Extension Package Body Template. This file contains the procedures that you can modify to implement the extension.
PAXPCECS.pls Project Verification Extension Package Specification Template. If you create procedures outside the predefined procedure within the pa_client_extn_proj_status 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

verify_project_status_change

Use this procedure to define requirements a project must satisfy to change from one project status to another. Detailed instructions for modifying the procedure are included in the package body.

Table 1 - 124 lists the parameters that Oracle Projects provides for the verify_project_status_change procedure.

Parameter Usage Type Description
x_calling_module IN VARCHAR2 The module that called the extension.
x_project_id IN NUMBER Identifier of the project.
x_old_proj_status_ code IN VARCHAR2 The current project status code.
x_new_proj_status_ code IN VARCHAR2 The new project status code.
x_project_type IN VARCHAR2 The project type of the project.
x_project_start_date IN DATE The project start date.
x_project_end_date IN DATE The project end date.
x_public_sector_flag IN VARCHAR2 Public sector indicator.
x_attribute_category IN VARCHAR2 Descriptive flexfield context.
x_attribute1 through x_attribute10 IN VARCHAR2 Descriptive flexfield segments.
x_pm_product_code IN VARCHAR2 The project management product code.
x_err_code< OUT NUMBER Error handling code.
x_warnings_only_ flag OUT VARCHAR2  
Table 1 - 124. (Page 2 of 2) Verify Project Status Change Parameters

check_wf_enabled

When Oracle Projects determines whether to call Workflow for a project status change, it bases the decision on the settings in the project status record and the project type. You can use this procedure to override those settings and/or add additional requirements.

Table 1 - 125 lists the parameters that Oracle Projects provides for the check_wf_enabled procedure.

Parameter Usage Type Description
x_project_status_ code IN VARCHAR2 The current project status code.
x_project_type IN VARCHAR2 The project type of the project.
x_project_id IN NUMBER Identifier of the project.
x_wf_enabled_flag OUT VARCHAR2 Flag indicating whether Workflow is enabled for the status change. Value is either Y or N.
x_err_code OUT NUMBER Error handling code.
Table 1 - 125. (Page 2 of 2) Check Workflow Enabled Parameters

         Previous  Next          Contents  Index  Navigation  Glossary  Library