Search Results cn_rt_formula_asgns_pkg




Overview
Explore in AI Chat

Overview

CN_RT_FORMULA_ASGNS_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It is part of the Oracle Trade Management (formerly Oracle Contracts) module, identified by the CN product prefix. The package encapsulates the core data manipulation logic for the Formula Assignments entity, which associates pricing or accrual formulas with specific runtime contexts such as rebate agreements, promotional offers, or qualifying criteria.

In Oracle EBS 12.1.1 and 12.2.2, the Trade Management runtime engine evaluates formula-driven calculations during rebate and promotion processing. The assignments defined through this package determine which formula applies to a given combination of agreement, qualifier, and benefit, ensuring that pricing, accrual, and settlement calculations resolve consistently. The package body is classified as OTHER in the ETRM documentation, indicating it is a supporting application logic unit rather than a formal public workflow or business API.

Key Procedures and Functions

The ETRM metadata documents four procedures in this package body:

  • INSERT_ROW — Creates a new formula assignment record, populating the base table with the association between a formula and its qualifying context. It is the primary entry point for defining a new assignment.
  • LOCK_ROW — Acquires a row-level lock on an existing assignment record, typically invoked by concurrent or interactive processes to serialize modification and prevent lost updates before an update or delete.
  • UPDATE_ROW — Modifies an existing formula assignment, allowing changes to the qualifying criteria or associated formula definition while preserving the row identity and audit columns.
  • DELETE_ROW — Removes a formula assignment record, logically or physically disassociating the formula from its context.

These procedures follow a conventional CRUD pattern. No parameter lists are published in the ETRM metadata, so callers should reference the package specification or review the source in the EBS instance before invoking the procedures directly.

Tables Accessed

The package operates against the following objects, accessed through APPS synonyms:

  • CN_RT_FORMULA_ASGNS — The base table storing active formula assignment rows. It is the primary target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW operations.
  • CN_RT_FORMULA_ASGNS_S — A secondary sequence or intersection table associated with the assignments entity, used to generate or track surrogate identifiers and ordering during inserts.
  • DUAL — Referenced for scalar evaluations within the package's SQL statements.

The package also depends on CN_API, FND_API, FND_GLOBAL, FND_MESSAGE, and FND_MSG_PUB, indicating that it participates in the standard EBS API error-handling and message-stacking framework and uses FND_GLOBAL for session and user context during DML.

Usage Notes

CN_RT_FORMULA_ASGNS_PKG is not referenced by any other database object, confirming it is an internally consumed API rather than a reusable public interface. It is typically invoked from:

  • Oracle Forms or OAF pages within the Trade Management setup and agreement workbenches, where users configure formula assignments and the form's transactional triggers call INSERT_ROW, UPDATE_ROW, or DELETE_ROW.
  • Concurrent programs that bulk-load or refresh formula assignments during rebate and promotion setup.
  • Custom extensions or migration scripts that need to register formula assignments programmatically.

Because the package body is VALID and its dependencies resolve cleanly in both 12.1.1 and 12.2.2, it is safe to reference in custom code, though developers should prefer the package specification contract and honor the LOCK_ROW discipline before updates. Direct DML against the underlying tables should be avoided to preserve the integrity and auditing logic embedded in this package.