Writing the Overtime Calculation Extension (Oracle Projects Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Writing the Overtime Calculation Extension

Oracle Projects provides a template package that contains the procedures that you modify to implement overtime calculation. The name of the package is pa_calc_overtime.

Print out and review the following files before you begin writing the overtime calculation extension. These files are located in the Oracle Projects admin/sql directory.

PAXDLCOB.pls. Overtime Calculation Extension Body Template. This file contains the procedure that you modify to implement overtime calculation. You can define as many procedures as you like within this package or within the predefined procedure.

PAXDLCOS.pls Overtime Calculation Extension Specification Template. If you create procedures outside the predefined procedure within the pa_calc_overtime 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: Storing Your Procedures.

We recommend that you use the PL/SQL User's Guide and Reference Manual and the Oracle Projects Technical Reference Manual as reference material while defining procedures:

Contents

Index

Navigation

Glossary

Library

PAXDLCOB.pls.	Overtime Calculation Extension Body Template. This file contains the procedure that you modify to implement overtime calculation. You can define as many procedures as you like within this package or within the predefined procedure.
PAXDLCOS.pls	Overtime Calculation Extension Specification Template. If you create procedures outside the predefined procedure within the pa_calc_overtime package, you must also modify this file to include those new procedures.