Search Results cn_formula_inputs_pkg




Overview
Explore in AI Chat

Overview

CN_FORMULA_INPUTS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the maintenance of formula input definitions within the Oracle Process Manufacturing (OPM) product family. In EBS 12.1.1 and 12.2.2, formula inputs describe the relationship between a formula and the ingredients, byproducts, or other components consumed or produced when the formula is executed. The package encapsulates the low-level Data Manipulation Language operations required to create, modify, lock, and remove records in the underlying formula input tables, allowing Oracle Forms and other callers to persist changes without embedding direct SQL against the base tables.

The package is classified as an OTHER API in the ETRM documentation, meaning it is a supporting utility package rather than a public, versioned interface. Its primary consumers are internal OPM components, most notably CN_CALC_FORMULAS_PVT, which references this package during formula calculation and validation processing.

Key Procedures and Functions

ETRM documents four procedures or functions in CN_FORMULA_INPUTS_PKG. The specific parameter lists are not reproduced here; only the documented purpose of each routine is described.

  • INSERT_ROW — Inserts a new formula input record. It writes a row into the formula inputs base table and the associated translation table, populating the mandatory columns and standard WHO audit fields via FND_GLOBAL.
  • LOCK_ROW — Acquires a row-level lock on an existing formula input record. It is typically called before an update or delete to ensure that the record has not been modified by another concurrent session.
  • UPDATE_ROW — Updates an existing formula input record. It modifies the attribute values of a row previously identified and locked, and refreshes the standard WHO update audit columns.
  • DELETE_ROW — Removes a formula input record from the base table and its translation table, maintaining referential integrity for the formula definition.

Tables Accessed

The package operates against the following objects through APPS synonyms:

  • CN_FORMULA_INPUTS — The base table storing formula input records, including the parent formula identifier and input attributes. It is the primary target of the INSERT_ROW, UPDATE_ROW, LOCK_ROW, and DELETE_ROW operations.
  • CN_FORMULA_INPUTS_S — The translation (or sequence) table associated with CN_FORMULA_INPUTS. It holds the language-specific or surrogate keyed rows that complement the base table and is maintained in parallel with it.
  • DUAL — The standard Oracle single-row utility table, used for lightweight validation or initialization queries within the package body.

Audit columns are sourced from FND_GLOBAL, the standard EBS session context package. The package also references CN_API, which supplies shared OPM application logic used across formula-related packages.

Usage Notes

CN_FORMULA_INPUTS_PKG is an internal implementation package and is not intended for direct invocation by external or custom code. In practice it is called from Oracle Forms-based maintenance screens for formula inputs and from the CN_CALC_FORMULAS_PVT package during formula calculation, explosion, and validation routines. Because the procedures rely on FND_GLOBAL for WHO audit information, they must be executed within a properly initialized EBS session that has established the application, responsibility, and user context.

Customizations should avoid direct calls to INSERT_ROW, UPDATE_ROW, LOCK_ROW, or DELETE_ROW where a supported public API exists, since the internal signature and behavior are not guaranteed across EBS releases. Where integration requires manipulation of formula inputs, the recommended approach is to use the supported OPM formula APIs or the Forms interface, which invoke this package on the caller's behalf. The package was documented as VALID in ETRM 12.2.2 and is referenced by only one other package, confirming its role as a narrowly scoped, low-level helper within the OPM formula subsystem.