Writing Labor Billing Extensions (Oracle Projects Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Writing Labor Billing Extensions

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

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

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

PAXICTMS.pls Labor Billing 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_Billing.Calc_Bill_Amount

Table 1 - 110 lists the parameters that Oracle Projects provides for the labor billing extension.

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_amount IN OUT NUMBER The bill amount.

x_bill_rate_flag IN OUT VARCHAR2 Indicates if bill rate should be set.

x_status IN OUT NUMBER The status of the procedure.

Table 1 - 110. (Page 1 of 1) Labor Billing 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_amount	IN OUT	NUMBER	The bill amount.
x_bill_rate_flag	IN OUT	VARCHAR2	Indicates if bill rate should be set.
x_status	IN OUT	NUMBER	The status of the procedure.
Table 1 - 110. (Page 1 of 1) Labor Billing Extension Parameters

Additional Information About Parameters

Using Bill Rate

Return one of the following values as the x_bill_rate_flag parameter value to specify if the amount that you have derived is based on a bill rate or a percent markup:

B (specifies bill rate)

M (specifies markup, default if null)

If you specify that your amount is based on a bill rate, Oracle Projects populates the bill rate of the expenditure item by dividing the bill amount by the number of hours. If you specify that your amount is a markup, Oracle Projects does not set the bill rate.

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 and rolls back the transactions processed for the entire project.

x_status > 0 An application error occurred. Oracle Projects writes a rejection reason to PA_EXPENDITURE_ITEMS.REV_DIST_ REJECTION_CODE and does not mark items as revenue distributed. You can review the rejection reason in the revenue generation exception report.

Contents

Index

Navigation

Glossary

Library

PAXICTMB.pls.	Labor Billing Extension Package Body Template. This file contains the procedure that you modify to implement labor billing extensions. You can define as many procedures as you like within this package or within the predefined procedure.
PAXICTMS.pls	Labor Billing 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 and rolls back the transactions processed for the entire project.
x_status > 0	An application error occurred. Oracle Projects writes a rejection reason to PA_EXPENDITURE_ITEMS.REV_DIST_ REJECTION_CODE and does not mark items as revenue distributed. You can review the rejection reason in the revenue generation exception report.