Search Results cn_rate_dimensions




Overview
Explore in AI Chat

Overview

The APPS.CN_RATE_DIMENSIONS_PKG package body is a technical database object within Oracle E-Business Suite Release 12.1.1 and 12.2.2, belonging to the Incentive Compensation (CN) module. It serves as the low-level data access and maintenance layer for rate dimension definitions, which are the configurable attributes that determine how compensation rates are structured and calculated. A rate dimension describes a measurable qualifier — such as a product category, a sales channel, or a performance tier — against which rate tiers and commission calculations are applied. The package is classified as an OTHER API, meaning it is an internal utility layer rather than a publicized, supported integration API.

The package encapsulates the insert, lock, update, and delete operations required to maintain records in the rate dimension schema. Because it was originally authored as a supporting object (the source header indicates a 2005 revision lineage), much of its logic reflects the pre-R12 data model. The R12 multi-org access control (MOAC) changes are visibly grafted into the procedure signatures, most notably through the addition of the X_ORG_ID parameter on INSERT_ROW, which ties each dimension definition to a specific operating unit or organization.

Key Procedures and Functions

  • INSERT_ROW — Creates a new rate dimension record. It accepts the dimension name, description, unit of measure code, number of tiers, descriptive flexfield attribute columns, and standard WHO audit columns. The primary key RATE_DIMENSION_ID is passed as an IN OUT NOCOPY parameter, allowing the procedure to return a generated identifier to the caller. Audit defaults such as SYSDATE and FND_GLOBAL.USER_ID are applied when not explicitly supplied.
  • LOCK_ROW — Acquires a pessimistic lock on an existing rate dimension row, typically using SELECT ... FOR UPDATE, to prevent concurrent modification during an update or delete sequence.
  • UPDATE_ROW — Modifies the mutable attributes of an existing rate dimension, including name, description, unit code, tier count, and flexfield attributes, while refreshing the audit columns.
  • DELETE_ROW — Removes a rate dimension definition, generally invoked only where no dependent tier or rate records would be orphaned.

Tables Accessed

  • CN_RATE_DIMENSIONS — The primary table holding rate dimension definitions; the target of insert, update, and delete operations.
  • CN_RATE_DIMENSIONS_S — The corresponding sequence or intersection table used to generate and track primary key values.
  • CN_RATE_DIM_TIERS — Referenced to support tier-related validation and dependency handling for dimensions.
  • DUAL — Used for single-row technical queries, such as sequence value retrieval.

Usage Notes

As an OTHER-classed package, CN_RATE_DIMENSIONS_PKG is not intended as a public extension point. It is typically invoked indirectly by the Incentive Compensation application forms (for example, the rate dimension setup screens), by concurrent programs that seed or maintain dimension data, and by other internal packages — the metadata records that one other package references it. Custom code should avoid direct calls and instead use the standard forms or the supported Incentive Compensation APIs, since the procedure signatures (particularly the MOAC X_ORG_ID parameter) differ between release levels and are subject to change without public notice.