Results for “cn_sca_crruleattr_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.CN_SCA_CRRULEATTR_PVT package body is a private (PVT-classified) PL/SQL API within the Oracle E-Business Suite Channel Revenue Management (formerly Dropship/Channel) module. Its name reflects its role in managing "SCA" (Supplier/Customer Agreement) credit rule attributes — the metadata definitions that determine how individual transactional columns, source columns, and user-facing column names are mapped to credit rules used in channel revenue and claim processing. In Oracle EBS 12.1.1 and 12.2.2, this package operates within the CN schema family and is invoked internally by public APIs and concurrent programs rather than being exposed directly to end users or external integrations.

The package header comment refers to helper logic such as Get_PayGroup_ID and a Get_Credit_Rule_Attr procedure that queries FND_FLEX_VALUE_SETS using flex_value_set_id to resolve a value set name. This is directly relevant to the user's search for "get_value_set_id": the package resolves value set identifiers to their descriptive names when building credit rule attribute definitions.

Key Procedures and Functions

Three procedures are documented in the ETRM metadata for this package body:

• CREATE_CREDIT_RULEATTR — Inserts a new credit rule attribute record into CN_SCA_RULE_ATTRIBUTES. It validates the incoming column mappings (transaction source, source column, user column) and associates them with the appropriate flex value set before persisting the definition.
• UPDATE_CREDIT_RULEATTR — Modifies an existing credit rule attribute definition, updating the associated column mappings and value set references. Because rule attributes drive downstream claim and credit calculation logic, updates propagate to the seeded data in CN_SCA_RULE_ATTRIBUTES_S.
• GENERATE_PACKAGE — Generates or regenerates a PL/SQL package dynamically from credit rule attribute metadata. This supports the extensibility model where rule attributes are configured at runtime and the corresponding runtime package is materialized for execution by claim processing routines.

Parameter lists are intentionally not documented here per the source metadata; callers should reference the package specification for exact signatures.

Tables Accessed

• CN_SCA_RULE_ATTRIBUTES — The primary table storing credit rule attribute definitions, including transaction source, source column, and user column name mappings.
• CN_SCA_RULE_ATTRIBUTES_S — The seeded/translation or shadow table used to hold the base (non-translated) or secure version of rule attribute rows.
• FND_FLEX_VALUE_SETS — Used via a cursor keyed on flex_value_set_id to resolve the flex_value_set_name for each attribute, ensuring the flexfield value set association is correct.
• CN_REPOSITORIES — Stores repository metadata describing the source columns and objects that credit rules reference.
• CN_SCA_CONDITIONS — Holds the condition definitions that determine when a given credit rule attribute applies, providing context for rule evaluation.

Usage Notes

CN_SCA_CRRULEATTR_PVT is a private package and is not intended for direct invocation by customer code. It is called internally by public CN APIs, by Oracle Forms within the Channel Revenue Management setup windows where administrators configure credit rule attributes, and by concurrent programs that regenerate rule packages. One other package in the ETRM schema references it, indicating a layered call pattern where the public API validates input and delegates persistence to this private body. Customizations should avoid calling this package directly; instead, use the documented public APIs that wrap it. Because the package queries flex_value_set_id from FND_FLEX_VALUE_SETS, any custom flexfield value set configuration must be committed before rule attribute imports run, or lookups will fail.