Writing the Verify Organization Change Extension (Oracle Projects Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Writing the Verify Organization Change Extension

Oracle Projects provides a template package and procedure that you use as the basis of your verify organization change extension procedures. The name of the template package is pa_org_client_extn. The name of the procedure is verify_org_change.

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

PAXORCEB.pls Verify Organization Change Extension Package Body Template. This file contains the procedure that you can modify to implement the extension.

PAXORCES.pls Verify Organization Change Extension Package Specification Template. If you create procedures outside the predefined procedure within the pa_org_client_extn package, you must also modify this file to include those new procedures.

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

Package Procedure

pa_org_client_extn.verify_org_change

Table 1 - 133 lists the parameters that Oracle Projects provides for the verify organization change extension.

Parameter Usage Type Description

X_insert_update_ mode
IN VARCHAR2 Value = INSERT if the project/task record has not been saved in the database.
Value = UPDATE if the record exists in the database.

X_calling_module
IN VARCHAR2 PAXPREPR if this extension is called from the Projects window.
PAXBAUPD if this extension is called from the Process Mass Update Batches process.

X_project_id IN NUMBER Identifier of the project to be updated.

X_task_id IN NUMBER Identifier of the task to be updated. The value is NULL when the extension is called to verify a project organization change.

X_old_value IN NUMBER Identifier of the current organization of the project or task.

X_new_value IN NUMBER Identifier of the new organization to be assigned to the project or task.

X_project_type IN VARCHAR2 Identifier of the project type of the project.

X_project_start_date IN DATE Start date of the project.

X_project_end_date IN DATE End date of the project.

X_public_sector_flag IN VARCHAR2 Public sector flag on the project.

X_task_manager_ person_id IN NUMBER Identifier of the manager of the task.

X_service_type IN VARCHAR2 Service type code of the task.

X_task_start_date IN DATE Start date of the task.

X_task_end_date IN DATE End date of the task.

X_entered_by_user_ id IN NUMBER Identifier of the user who entered the project/ task.

X_attribute_category IN VARCHAR2 Attribute category of the project or task.

X_attribute_1 through X_attribute_10 IN VARCHAR2 Attribute values 1 through 10 of the project or task.

X_pm_product_code IN VARCHAR2 Project management product code specified for the project or task.

X_pm_project_ reference IN VARCHAR2 Project management product reference specified for the project.

X_pm_task_ reference IN VARCHAR2 Project management task reference specified for the task.

X_functional_ security_flag IN VARCHAR2 Value = Y if the user's responsibility has the function Project: Org Update: Override Standard Checks. Otherwise, value = N.

X_outcome OUT VARCHAR2 The message error code if a verification rule is violated or if there is an Oracle8 error.

Table 1 - 133. (Page 3 of 3) Verify Organization Change Parameters

PAXORCEB.pls	Verify Organization Change Extension Package Body Template. This file contains the procedure that you can modify to implement the extension.
PAXORCES.pls	Verify Organization Change Extension Package Specification Template. If you create procedures outside the predefined procedure within the pa_org_client_extn package, you must also modify this file to include those new procedures.

Parameter	Usage	Type	Description
X_insert_update_ mode	IN	VARCHAR2	Value = INSERT if the project/task record has not been saved in the database. Value = UPDATE if the record exists in the database.
X_calling_module	IN	VARCHAR2	PAXPREPR if this extension is called from the Projects window. PAXBAUPD if this extension is called from the Process Mass Update Batches process.
X_project_id	IN	NUMBER	Identifier of the project to be updated.
X_task_id	IN	NUMBER	Identifier of the task to be updated. The value is NULL when the extension is called to verify a project organization change.
X_old_value	IN	NUMBER	Identifier of the current organization of the project or task.
X_new_value	IN	NUMBER	Identifier of the new organization to be assigned to the project or task.
X_project_type	IN	VARCHAR2	Identifier of the project type of the project.
X_project_start_date	IN	DATE	Start date of the project.
X_project_end_date	IN	DATE	End date of the project.
X_public_sector_flag	IN	VARCHAR2	Public sector flag on the project.
X_task_manager_ person_id	IN	NUMBER	Identifier of the manager of the task.
X_service_type	IN	VARCHAR2	Service type code of the task.
X_task_start_date	IN	DATE	Start date of the task.
X_task_end_date	IN	DATE	End date of the task.
X_entered_by_user_ id	IN	NUMBER	Identifier of the user who entered the project/ task.
X_attribute_category	IN	VARCHAR2	Attribute category of the project or task.
X_attribute_1 through X_attribute_10	IN	VARCHAR2	Attribute values 1 through 10 of the project or task.
X_pm_product_code	IN	VARCHAR2	Project management product code specified for the project or task.
X_pm_project_ reference	IN	VARCHAR2	Project management product reference specified for the project.
X_pm_task_ reference	IN	VARCHAR2	Project management task reference specified for the task.
X_functional_ security_flag	IN	VARCHAR2	Value = Y if the user's responsibility has the function Project: Org Update: Override Standard Checks. Otherwise, value = N.
X_outcome	OUT	VARCHAR2	The message error code if a verification rule is violated or if there is an Oracle8 error.
Table 1 - 133. (Page 3 of 3) Verify Organization Change Parameters

Writing the Verify Organization Change Extension

Package Procedure

pa_org_client_extn.verify_org_change

See Also