32 Project Foundation Configuration: Define Project Extensions

This chapter contains the following:

Project Status Change Workflow Enabled Extension

Project Status Change Rules Extension

Organization Change Rules Extension

Project Status Change Approver Extension

Project Status Change Workflow Enabled Extension

Use the Project Status Change Workflow Enabled Extension to determine whether to call the workflow process when the project status changes.

The extension is identified by the following items:

Extension Component	Name
Body template	pjf_client_extn_proj_status.pkb
Specification template	pjf_client_extn_proj_status.pkh
Package	pjf_client_extn_proj_status

Important

Do not change the name of the extension procedure or parameters. Also, do not change the parameter types or parameter order in the procedure. After you write a procedure, compile it and store it in the database.

Oracle Fusion Projects calls the Project Status Change Workflow Enabled Extension when a change of status is requested for a project.

When designing Project Status Change Workflow Enabled Extensions, you determine what business rules to apply when a project status change is selected for a project.

The name of this procedure is Check_Bpel_enabled. Oracle Fusion Projects determines whether to call workflow for a project status change based on the Enable Workflow option on the project status definition.

Project Status Change Rules Extension

Use the Project Status Change Rules Extension to define rules to determine whether a project status can change.

The extension is identified by the following items:

Extension Component	Name
Body template	pjf_client_extn_proj_status.pkb
Specification template	pjf_client_extn_proj_status.pkh
Package	pjf_client_extn_proj_status

Important

Oracle Fusion Projects calls the Project Status Change Rules Extension when a change of status is requested for a project.

When designing Project Status Change Rules Extensions, you determine what business rules to apply when a project status change is selected for a project.

The name of this procedure is Verify_Project_Status_Change.

Organization Change Rules Extension

Use the Organization Change Rules Extension to build business rules to determine whether an organization change is allowed for a project and task owning organization, and to define the error messages that are used when the rules are violated.

Oracle Fusion Projects calls the Organization Change Rules Extension during the Change Project and Task Organizations process, and in the project definition when you change the project and task owning organization.

This table shows the names of the extension components.

Extension Component	Name
Body template	pjf_org_client_extn.pkb
Specification template	pjf_org_client_extn.pkh
Package	PJF_ORG_CLIENT_EXTN
Procedure	verify_org_change

Important

Project Status Change Approver Extension

Use the Project Status Change Approver Extension to override the internal identifier of the project status change approver.

By default, the extension returns the internal identifier of the project manager. The default project workflow process calls the Project Status Change Approver Extension to determine the project approver.

The extension is identified by the following items:

Extension Component	Name
Body template	pjf_client_extn_project_wf.pkb
Specification template	pjf_client_extn_project_wf.pkh
Package	pjf_client_extn_project_wf

Important

Do not change the name of the extension procedures or parameters. Also, do not change the parameter types or parameter order in your procedure. After you write a procedure, compile it and store it in the database.

The Select Project Approver (select_project_approver) procedure is included in the Project Status Change Approver Extension. 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 project manager.