Previous  Next          Contents  Index  Navigation  Glossary  Library

Burdening Commitments

You can burden your commitment amounts using the burden schedule that you have assigned to the task for internal costing purposes. See: Burdening.

To burden the commitment amounts, you call the following functions in the select statement for the TOT_CMT_BURDENED_COST and CMT_IND_COMPILED_SET_ID columns of your view definition:

Oracle Projects provides an example of burdening commitments in the PACMTVW.sql in the Oracle Projects admin/sql directory.

The pa_burden_cmts.get_cmt_burdened_cost function calculates the total burdened cost. If it cannot calculate the burdened cost or encounters an error, it returns the raw cost. You pass the following values to this function:

Parameter Usage Type Description
X_task_id IN NUMBER The identifier of the task
X_expenditure_item_date IN DATE The expenditure item date
X_expenditure_type IN VARCHAR2 The expenditure type
X_organization_id IN NUMBER The identifier for the expenditure organization
X_schedule_type IN VARCHAR2 The type of burden schedule. Set this to C
X_raw_cost IN NUMBER The amount to be burdened

The pa_burden_cmts.get_cmt_compiled_set_id function determines the compiled set id, which identifies the set of burden multipliers used to calculate the burdened amount. You can use the compiled set ID for reporting individual burden components of the burdened cost. This value is only populated when you burden the costs. If it cannot find the compiled set ID or it encounters an error, it returns null. You pass the following values to this function:

Parameter Usage Type Description
X_task_id IN NUMBER The identifier for the task
X_expenditure_item_date IN DATE The expenditure item date
X_organization_id IN NUMBER The identifier for the organization
X_schedule_type IN VARCHAR2 The type of burden schedule. Set this to C


         Previous  Next          Contents  Index  Navigation  Glossary  Library