Previous	Next		Contents	Index	Navigation	Glossary	Library

The name of the template report is PAXDLIOT.rdf. It is located in the Oracle Projects reports directory. You do not need to modify this report. You should only need to modify the PL/SQL procedures in the overtime calculation extension template package. See: Writing the Overtime Calculation Extension.

Figure 1 - 64 shows the structure of the Overtime Calculation Report. The procedures you are most likely to modify to implement your company's overtime rules are marked with an asterisk (*) in the diagram.

The report first calls the Check_Overtime_Tasks_Exist procedure. This procedure looks for overtime projects and tasks and returns all relevant task names, up to a maximum of five. These tasks determine the column titles in the report.

Next, the report queries the database for all records processed by the Distribute Labor Costs process. The report then calls the Process_Overtime procedure. This procedure determines the amount and type of overtime for each employee and period, creates new expenditure items for these values, and passes the values back to the report.

Calc_Overtime and Calc_Daily_Overtime are procedures used by the Process_Overtime procedure. You can decide whether to use these procedures in your customized extension.

Your extension must also adjust overtime that relates to any adjustments made to the original transactions. For best results, use the Process_Overtime procedure to create the new overtime records, as this procedure handles all the inserts and updates to the Oracle Projects tables.