Search Results cn_get_expression




Overview
Explore in AI Chat

Overview

CN_GET_EXPRESSION is an Oracle E-Business Suite 12.1.1 / 12.2.2 PL/SQL package owned by the APPS schema and classified under the ETRM as an OTHER API. It belongs to the Channel Revenue Management (CN) product family, which governs trade promotions, channel rebates, claim and deduction processing, and vendor-attribute-driven pricing rules. Within that product family, CN_GET_EXPRESSION serves as a rule-expression utility: its documented purpose is to resolve and manage the attribute-rule expressions stored against channel attribute rules. Attribute rules in Channel Revenue Management determine how a qualifying attribute — a customer class, product category, channel, or qualifier group — is evaluated when an agreement, promotion, or claim is qualified. The package provides the mechanism by which the stored rule expression is retrieved and by which a previously defined expression is removed from the rule repository. The package is validated in both release codelines and remains an active dependency of the attribute-rule schema objects.

Key Procedures and Functions

The ETRM metadata documents two callable units in this package.

  • MAIN — The principal entry point of the package. It encapsulates the package's core expression-resolution behaviour and is the routine through which rule expressions associated with channel attribute rules are obtained and processed. As the primary procedure, MAIN is the unit most likely to be referenced by forms-level or concurrent-processing logic that requires the evaluated expression for a qualifying attribute rule.
  • DELETEEXPRESSION — Provides the maintenance counterpart to MAIN, removing an attribute-rule expression from the repository. It is used when an attribute rule is redefined, superseded, or otherwise no longer requires its stored expression, ensuring that stale expression definitions do not continue to be evaluated during qualification.

No parameter signatures are documented in the available metadata; the procedure names and purposes above are stated as recorded and should not be interpreted as exposing specific argument lists.

Tables Accessed

The package is documented as referencing the following tables through APPS synonyms:

  • CN_ATTRIBUTE_RULES — The header repository for channel attribute rules. CN_GET_EXPRESSION reads this table to identify the attribute rule whose expression is being resolved or removed.
  • CN_RULE_ATTR_EXPRESSION — The child table holding the actual expression text or expression definition attached to each attribute rule. This is the primary read target for expression retrieval and the primary write/delete target for DELETEEXPRESSION.
  • PLITBLM — The standard Oracle EBS PL/SQL integer-indexed table type used for passing collections between PL/SQL and Oracle Forms. Its presence indicates that the package's routines are invoked from Forms-based user interfaces and exchange set-based values with the calling form.

An additional dependency on the SYS.STANDARD package is recorded and reflects only the PL/SQL language's built-in package rather than any application data access.

Usage Notes

CN_GET_EXPRESSION is an internal utility rather than a publicly documented integration API. It is referenced by no other package in the documented dependency set, which indicates that its callers are Oracle Forms modules and concurrent programs within the Channel Revenue Management setup rather than other PL/SQL APIs. The PLITBLM dependency reinforces a Forms-driven invocation pattern, typically from the attribute-rule setup windows where the expression for a rule is displayed, validated, or cleared.

Custom code should not call CN_GET_EXPRESSION directly unless the attribute-rule expression structure is fully understood, because the package's behaviour is tightly coupled to the CN_ATTRIBUTE_RULES and CN_RULE_ATTR_EXPRESSION data model and is not published as a supported interface. Where custom logic genuinely requires attribute-rule expression resolution, the supported approach is to read CN_RULE_ATTR_EXPRESSION directly or to extend through the documented Channel Revenue Management APIs. Because the package is owned by APPS and marked VALID, its underlying expression storage remains the authoritative source for rule evaluation during qualification, but it should be treated as an internal component of the Channel Revenue Management rule engine.