Search Results cn_rate_dimensions_pvt




Overview
Explore in AI Chat

Overview

CN_RATE_DIMENSIONS_PVT is a private PL/SQL API package in the APPS schema that supports Oracle E-Business Suite's Compensation and rate management functionality, commonly associated with Oracle Trade Management and the ETRM (Enterprise Trade and Rate Management) module. Its business purpose is to manage the dimensions that qualify and structure rate schedules, allowing organizations to define the pricing conditions under which specific rates apply. A rate dimension represents a qualifying attribute—such as a customer, product, region, or other business criterion—used to build tiered and multi-dimensional rate models. The package provides the programmatic foundation for creating, modifying, and removing both rate dimensions and the tiers associated with them.

The package is classified as a PVT (private) API, indicating it is intended for internal consumption by other EBS packages rather than as a public interface for direct customer invocation. It encapsulates the lower-level validation, data manipulation, and exception handling that public APIs and user interfaces rely upon.

Key Procedures and Functions

The package exposes six documented program units, divided between dimension-level and tier-level operations:

  • CREATE_DIMENSION — Creates a new rate dimension record, establishing the qualifying attribute that will drive rate determination for a rate schedule.
  • UPDATE_DIMENSION — Modifies an existing rate dimension, allowing changes to dimension attributes while preserving referential integrity.
  • DELETE_DIMENSION — Removes a rate dimension from the system, typically subject to validation to prevent deletion of dimensions still in active use.
  • CREATE_TIER — Creates a tier within a rate dimension, supporting tiered or breakpoint-based rate structures.
  • UPDATE_TIER — Modifies an existing tier definition, enabling adjustment of tier boundaries or associated values.
  • DELETE_TIER — Removes a tier from a rate dimension.

Each procedure participates in the application's multi-level validation conventions, consistent with the FND_API error-handling framework that the package depends upon.

Tables Accessed

The package operates against several core rate management tables (referenced through APPS synonyms):

  • CN_RATE_DIMENSIONS — The primary table storing rate dimension definitions; the target of create, update, and delete dimension operations.
  • CN_RATE_DIM_TIERS — Stores tier definitions belonging to each rate dimension; the target of the tier management procedures.
  • CN_CALC_SQL_EXPS — Holds calculation SQL expressions used to compute rates dimensionally.
  • CN_RATE_SCH_DIMS — Associates rate schedules with their dimensions.
  • CN_RT_FORMULA_ASGNS — Stores formula assignments tied to rate structures.
  • DUAL and PLITBLM — Utility references; PLITBLM is the standard PL/SQL index-by table used internally for bulk processing.

Additional dependencies include CN_API, CN_RATE_DIMENSIONS_PVT references in CN_API, and the FND_API and STANDARD packages for error handling and standard PL/SQL constructs.

Usage Notes

Because CN_RATE_DIMENSIONS_PVT is a private package, it is not intended for direct invocation by end users or external integrations. It is referenced by three other packages: CN_COMP_PLAN_XMLCOPY_PVT, CN_MULTI_RATE_SCHEDULES_PUB, and its wrapper CN_RATE_DIMENSIONS_PVT_W. The wrapper (_W) package typically exposes selected functionality in a controlled manner, while the public package CN_MULTI_RATE_SCHEDULES_PUB serves as the sanctioned entry point for multi-rate schedule operations.

In practice, the package is invoked through the ETRM rate and compensation setup user interfaces and through concurrent or batch processing that populates and maintains rate schedules. Custom code should avoid calling the _PVT package directly; instead, developers should use the corresponding public API to ensure validation rules, security, and error propagation are preserved across EBS releases 12.1.1 and 12.2.2.