Search Results cn_rate_sch_dims




Overview
Explore in AI Chat

Overview

CN_RATE_SCH_DIMS_PKG is a table-handler package in the Oracle E-Business Suite Advanced Pricing or Contracts (CN) product family. It encapsulates the DML operations for the CN_RATE_SCH_DIMS entity, which stores the dimension rows that define how a rate schedule is structured. Each row associates a rate dimension with a rate schedule and assigns a display or processing sequence, allowing pricing and contracts rate schedules to be built from one or more rate dimensions. The package provides the standard PL/SQL API layer used by Oracle Forms and other EBS components so that inserts, updates, deletes, and locking operations against the underlying table are performed consistently, with the audit columns and multi-organization context populated correctly. As documented in ETRM 12.2.2, the package is owned by APPS and classified as an OTHER API, and it is referenced by one other package.

Key Procedures and Functions

The documented public interface consists of four procedures:

  • INSERT_ROW — Creates a new rate schedule dimension row. It accepts the primary key identifier as an IN OUT NOCOPY parameter, along with the foreign key references to the rate dimension and rate schedule, the dimension sequence, and the descriptive flexfield attribute columns. Audit columns default to SYSDATE and the current FND_GLOBAL user, login, and MOAC organization context. The R12 multi-organization change added the ORG_ID parameter, as noted in the package header comments.
  • LOCK_ROW — Acquires a row-level lock on an existing rate schedule dimension record, typically to serialize concurrent updates originating from an Oracle Forms block.
  • UPDATE_ROW — Modifies an existing rate schedule dimension record, including its dimension assignment, sequence, and descriptive flexfield attributes, while maintaining the standard audit and MOAC columns.
  • DELETE_ROW — Removes a rate schedule dimension row from the table.

The package header comment identifies it as cntschdb.pls, version 120.2, last modified 2005/10/05, with R12 MOAC changes applied.

Tables Accessed

The package operates on the CN_RATE_SCH_DIMS base table, which holds the rate schedule dimension records and their descriptive flexfield attribute columns and audit columns. It also references the CN_RATE_SCH_DIMS_S translation table, used to store language-specific seed or descriptive data associated with the dimension rows. The DUAL table is used for standard singleton queries, such as sequence or system value lookups. Access is performed through APPS synonyms, consistent with the package residing in the APPS schema.

Usage Notes

CN_RATE_SCH_DIMS_PKG is invoked by Oracle Forms when users maintain rate schedule dimensions, by the referencing package identified in the dependency metadata, and by custom code that needs to programmatically create, change, lock, or remove rate schedule dimension rows. Because the procedures populate FND_GLOBAL-based audit and organization columns automatically and enforce the MOAC organization context, callers should ensure the correct operating unit context is initialized before invoking INSERT_ROW or UPDATE_ROW. Direct DML against CN_RATE_SCH_DIMS is discouraged; the package should be used so that audit columns, flexfield attributes, and organization security are handled consistently. When extending or integrating with rate schedule setup, calling these procedures preserves compatibility with the supported EBS 12.1.1 and 12.2.2 data model.