Search Results pa_burden_cmts




Overview
Explore in AI Chat

Overview

PA_BURDEN_CMTS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, and it belongs to the Oracle Projects (PA) module. Its name — "CMTS" likely referring to cost multipliers / burden comment or costing method structures — places it within the burdening and costing engine that calculates fully burdened costs on project expenditures. The package is documented in ETRM (12.2.2) with an API classification of OTHER, meaning it is primarily an internal, supporting package rather than a public, published application programming interface.

The business function of PA_BURDEN_CMTS is to resolve and compile the cost multiplier and burden structure definitions that Oracle Projects applies when deriving burdened cost from raw expenditure items. It bridges the cost base, cost plus (rate) schedules, and cost plus structures, together with expenditure types, so that the burden engine can apply the correct multipliers for a given set of project expenditures. It is a dependency of several other packages rather than a user-facing entry point.

Key Procedures and Functions

The documented package exposes two procedures/functions:

  • GET_CMT_COMPILED_SET_ID — Returns the compiled set identifier for cost multipliers. This identifies the pre-compiled collection of cost multiplier definitions that the burden engine should use, allowing callers to resolve which compiled costing set is applicable rather than re-deriving it each time.
  • GET_CMT_BURDENED_COST — Returns the burdened cost value derived from the applicable cost multipliers for the given context. This is the core computation routine that yields the fully burdened figure used in project costing.

The package is referenced by six other packages, indicating it serves as a shared internal utility within the Oracle Projects burdening code path. The metadata does not document individual parameter lists, so parameter details are not reproduced here.

Tables Accessed

PA_BURDEN_CMTS references the following tables through APPS synonyms:

  • PA_EXPENDITURE_TYPES — Defines the expenditure categories (e.g., labor, expense) to which multipliers apply. The package reads this to determine which cost multipliers are relevant to a given expenditure type.
  • PA_COST_BASES — Defines the cost bases on which multipliers operate, used to identify the underlying base amounts for burdening.
  • PA_COST_PLUS_STRUCTURES — Defines the structure that organizes cost plus (rate) schedules, queried to resolve the compiled burdening structure.

It also shows a dependency on PA_COST_PLUS and on the package itself (PA_BURDEN_CMTS). No tables are documented as being written by this package; it is primarily read-oriented.

Usage Notes

PA_BURDEN_CMTS is an internal Oracle Projects burdening component. It is typically invoked by other Oracle Projects packages during burden cost calculation, particularly those handling cost multiplier compilation and burdened cost derivation. It is not intended as a standalone public API and is not exposed through Oracle Projects forms or standard concurrent programs directly.

Because it is referenced by six other packages, changes to this package can affect the broader burdening flow in both 12.1.1 and 12.2.2. Custom code should avoid calling its internal procedures directly unless the documented signatures are validated against the specific release. When troubleshooting burdening discrepancies, this object is one point of investigation for how compiled multiplier sets and burdened costs are resolved.