Search Results cn_rate_sch_dims_pkg




Overview
Explore in AI Chat

Overview

CN_RATE_SCH_DIMS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (Enterprise Territory and Resource Management) module family associated with the CN product code. In Oracle EBS 12.1.1 and 12.2.2, this package serves as the low-level data access layer for the CN_RATE_SCH_DIMS entity, which stores the dimensional attributes (for example, dimension identifiers and their values) that make up rate schedule definitions used in contract and rate management processing. Rather than exposing business logic directly to end users, the package provides the primitive Create, Read, Update, Delete (CRUD) operations that higher-level APIs and private packages rely on when manipulating rate schedule dimension records. Its role is therefore infrastructural: it reconciles the requirements of the Oracle Forms-based UI layer with the underlying multi-org constrained table design.

Key Procedures and Functions

The package exposes four documented procedures, each corresponding to a standard table-handler operation:

  • INSERT_ROW — Inserts a new rate schedule dimension record into the underlying tables, deriving the appropriate primary key and, where applicable, populating the related identifier sequence.
  • LOCK_ROW — Acquires an exclusive lock on a specific row to support concurrent-safe updates performed through Oracle Forms or batch logic, preventing conflicting modifications.
  • UPDATE_ROW — Applies modified attribute values to an existing rate schedule dimension row, typically after the row has been locked via LOCK_ROW.
  • DELETE_ROW — Removes a rate schedule dimension record, allowing the associated rate schedule configuration to be redefined or retired.

These procedures follow the conventional Oracle EBS table-handler pattern and are not intended to be called directly by end users.

Tables Accessed

The package operates against two documented base tables referenced through APPS synonyms, plus the standard DUAL table for single-row expression evaluation:

  • CN_RATE_SCH_DIMS — The primary table storing rate schedule dimension detail rows. INSERT_ROW, UPDATE_ROW, and DELETE_ROW read and write here.
  • CN_RATE_SCH_DIMS_S — The corresponding sequence or shadow table used to generate and track unique identifiers for new dimension rows during INSERT_ROW.
  • DUAL — Used for scalar computations and sequence lookups that require no table access.

Usage Notes

CN_RATE_SCH_DIMS_PKG is referenced by CN_MULTI_RATE_SCHEDULES_PVT, a private package that encapsulates the higher-level multi-rate schedule business rules. In practice, the package is invoked indirectly: when a user maintains rate schedule dimensions through the EBS forms interface, or when a concurrent program or custom extension calls the private API, those callers ultimately delegate row-level persistence to this package. It also references CN_API and FND_GLOBAL, the latter supplying session context such as the current user and responsibility. Because the package is marked VALID and remains in the dependency chain of the multi-rate schedules private API, customizations should avoid modifying it in isolation; instead, extensions should call the documented public or private APIs so that dimension records remain consistent with rate schedule processing. Direct DML against CN_RATE_SCH_DIMS is discouraged, since bypassing these handlers can leave the sequence table and audit context out of synchronization.