Search Results cn_rt_formula_asgns




Overview
Explore in AI Chat

Overview

APPS.CN_RT_FORMULA_ASGNS_PKG is a PL/SQL package owned by the APPS schema that supports the Oracle E-Business Suite Incentive Compensation (formerly TeleSales/ETRM) product. Its role is to encapsulate the create, read, update, and delete operations for the runtime formula assignment entity, which links a compensation formula to the role, plan, or transaction context in which it is evaluated at runtime. The package provides the persistence-layer plumbing behind the formula assignment maintenance screens and is a building block consumed by higher-level compensation calculation logic. Within the ETRM 12.2.2 object registry it is classified as an OTHER API rather than a public or private API, and its status is listed as VALID, indicating that it compiles cleanly against the APPS schema in a supported 12.1.1 / 12.2.2 environment. The package is deliberately thin: it delegates business validation to the common API layer and concentrates on locking, inserting, updating, and deleting rows in the underlying assignment tables.

Key Procedures and Functions

The ETRM metadata documents four procedures in this package:

  • INSERT_ROW — Creates a new runtime formula assignment record. It initialises the new row, resolves surrogate keys, and writes the assignment definition into the base table so that the formula becomes available to the runtime engine.
  • LOCK_ROW — Obtains a row-level lock on an existing assignment to guarantee serialised access. This is typically called immediately before an update or delete so that concurrent sessions cannot modify the same record.
  • UPDATE_ROW — Modifies an existing assignment, such as changing the formula, effective dates, or associated context, and persists the changed values back to the base table while maintaining the corresponding translated/summary row.
  • DELETE_ROW — Removes a runtime formula assignment. The delete is normally preceded by a LOCK_ROW call to protect against lost updates.

No parameter lists are published in the documented metadata and none are asserted here.

Tables Accessed

  • CN_RT_FORMULA_ASGNS — the primary base table holding runtime formula assignment records. All four procedures read or write this table.
  • CN_RT_FORMULA_ASGNS_S — the companion table that stores the non-translated / translated (TL-style) attributes associated with each assignment. It is maintained in step with the base table during insert, update, and delete operations.
  • DUAL — used for scalar expressions, sequence or SYS_GUID retrieval, and other single-row select constructs required to generate keys and populate mandatory columns.

The documented dependency list confirms references to FND_GLOBAL (for session context such as user ID, responsibility, and login) and STANDARD (the standard who-column population utility), as well as the common API package CN_API.

Usage Notes

This package is an internal implementation package and is not intended to be called directly by end users. It is normally invoked through the Incentive Compensation setup and maintenance forms whenever an administrator defines, changes, or removes a runtime formula assignment, and through the CN_CALC_FORMULAS_PVT package, which the metadata lists as the sole documented dependent package. Because it manipulates the underlying assignment tables directly, customisations should call the public APIs or the owning form logic rather than these procedures, to preserve validation, WHO-column auditing, and the base/TL table integrity maintained by FND_GLOBAL and STANDARD. In both 12.1.1 and 12.2.2 the package resides in the APPS schema, and any custom code referencing it must use the APPS.CN_RT_FORMULA_ASGNS_PKG qualified name or an APPS synonym to resolve correctly.