Writing Labor Costing Extensions (Oracle Projects Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Writing Labor Costing Extensions

Oracle Projects provides a template package and procedure that you use as the basis of your labor costing extension procedures. The name of the package is PA_Client_Extn_Costing, the name of the procedure is Calc_Raw_Cost.

Print out and review the following files before you begin writing labor costing extensions. The files are located in the Oracle Projects admin/sql directory.

PAXCCECB.pls. Labor Costing Extension Package Body Template. This file contains the procedure that you modify to implement labor costing extensions. You can define as many procedures as you like within this package or within the predefined procedure.

PAXCCECS.pls Labor Costing Extension Package Specification Template. If you create procedures within the package outside the predefined procedure, you must also modify this file.

Suggestion: After you write the procedure, do not forget to compile it and store it in the database. See: Storing Your Procedures.

Package.Procedure

PA_Client_Extn_Costing.Calc_Raw_Cost

Table 1 - 106 lists the parameters that Oracle Projects provides for the labor costing procedure.

Parameter Usage Type Description

x_expenditure_item_id IN NUMBER The identifier of the expenditure item.

x_sys_linkage_function IN VARCHAR2 The expenditure type class of the expenditure item.

x_raw_cost IN OUT NUMBER The raw cost amount.

x_status IN OUT NUMBER The status of the procedure.

Table 1 - 106. (Page 1 of 1) Labor Costing Extension Parameters

Parameter	Usage	Type	Description
x_expenditure_item_id	IN	NUMBER	The identifier of the expenditure item.
x_sys_linkage_function	IN	VARCHAR2	The expenditure type class of the expenditure item.
x_raw_cost	IN OUT	NUMBER	The raw cost amount.
x_status	IN OUT	NUMBER	The status of the procedure.
Table 1 - 106. (Page 1 of 1) Labor Costing Extension Parameters

Using Raw Cost

The raw cost amount that your procedure calculates is assigned to the x_raw_cost parameter. Leave this value blank if you want to use the standard costing method which uses the employee's hourly cost rate.

If you pass a value to this parameter, Oracle Projects calculates the raw cost rate of the transaction using the x_raw_cost parameter value divided by the number of hours.

Using Status

Use the x_status parameter to handle error conditions for your procedure. This parameter indicates the processing status of your extension as follows:

x_status = 0 The extension executed successfully.

x_status < 0 An Oracle8 error occurred and the process did not complete. Oracle Projects writes an error message to the process log file.

x_status > 0 An application error occurred. Oracle Projects writes a rejection reason to PA_EXPENDITURE_ITEMS.COST_ DIST_REJECTION_CODE and does not cost the transaction. You can review the rejection reason in the labor cost distribution exception report.

Contents

Index

Navigation

Glossary

Library

PAXCCECB.pls.	Labor Costing Extension Package Body Template. This file contains the procedure that you modify to implement labor costing extensions. You can define as many procedures as you like within this package or within the predefined procedure.
PAXCCECS.pls	Labor Costing Extension Package Specification Template. If you create procedures within the package outside the predefined procedure, you must also modify this file.

x_status = 0	The extension executed successfully.
x_status < 0	An Oracle8 error occurred and the process did not complete. Oracle Projects writes an error message to the process log file.
x_status > 0	An application error occurred. Oracle Projects writes a rejection reason to PA_EXPENDITURE_ITEMS.COST_ DIST_REJECTION_CODE and does not cost the transaction. You can review the rejection reason in the labor cost distribution exception report.