Search Results get_cmt_compiled_set_id




Overview
Explore in AI Chat

Overview

PA_BURDEN_CMTS is an Oracle Projects PL/SQL package that supports the burdening and commitment reporting functionality within Oracle E-Business Suite. Its primary role is to resolve the compiled set identifiers and calculate burdened cost amounts used by commitment views and validation routines. The package acts as an internal utility that does not represent a public API; the ETRM classification for this object is OTHER, indicating it is invoked indirectly by other Oracle Projects components rather than through a formally published interface.

Within the Oracle EBS 12.1.1 and 12.2.2 release streams, PA_BURDEN_CMTS is part of the intricate dependency chain that powers commitment-based reporting in Oracle Projects. Commitment views such as PA_COMMITMENTS_V and PA_COMMITMENTS_V1 — the latter being the specific object referenced in the user's search — depend on this package to supply the necessary burdened amounts and compiled set identifiers. The same dependency applies to PA_COMMITMENT_TXNS_V, PA_CHECK_COMMITMENTS, and the Grants Management views GMS_COMMITMENTS_OVERRIDE_V and GMS_COMMITMENT_TXNS_V, reflecting the shared commitment infrastructure between Oracle Projects and Oracle Grants Management.

Key Procedures and Functions

The package exposes two documented program units:

  • GET_CMT_COMPILED_SET_ID — Returns the compiled set identifier associated with commitment burdening. This identifier is used to select the correct burden structure or cost plus structure applicable to a given commitment record.
  • GET_CMT_BURDENED_COST — Returns the burdened cost amount for a commitment transaction. This function supplies the burdened value consumed by the commitment views and validation logic, converting raw commitment amounts into burden-adjusted figures.

The package body is marked VALID in the deployment metadata, and no parameter lists are documented for these units; the descriptions above reflect their documented purpose only.

Tables Accessed

PA_BURDEN_CMTS references the following APPS tables through synonyms:

  • PA_EXPENDITURE_TYPES — Determines the expenditure type classification that governs how burdening is applied to commitment amounts.
  • PA_COST_BASES — Provides the cost base definitions against which burden multipliers are resolved.
  • PA_COST_PLUS_STRUCTURES — Supplies the cost plus (burden) structure that maps cost bases to burden multipliers, enabling the computation of the burdened cost and compiled set identifier.

These tables are read rather than written; the package serves as a lookup and calculation layer rather than a data-maintenance component.

Usage Notes

PA_BURDEN_CMTS is not intended for direct invocation from forms or concurrent programs. The ETRM metadata records that it is referenced by six other packages, including PA_CHECK_COMMITMENTS and PA_BURDEN_CMTS itself. In practice, the package is called internally when commitment views such as PA_COMMITMENTS_V and PA_COMMITMENTS_V1 are queried, and when commitment validation routines execute during transaction processing.

The dependency on STANDARD indicates reliance on standard PL/SQL package semantics. Custom code that requires commitment burdening values should reference the commitment views rather than calling this package directly, since its procedures are not documented as a supported public interface and may change without notice across patch levels or upgrades between 12.1.1 and 12.2.2.