Search Results entity_delete

Overview

QP_VALIDATE_FNA is an Oracle E-Business Suite PL/SQL validation package owned by the APPS schema and shipped as part of the Advanced Pricing (QP) application. Its role is to enforce business rules against records that describe the mapping between source systems and pricing attribute areas — the "FNA" (Flexible Name Attribute) definitions used by Oracle Pricing and Oracle Advanced Pricing when integrating external source systems with pricing entities. The package is classified as OTHER by ETRM documentation, indicating it is not a full public API with a stable external contract, but rather an internal validation service consumed by other pricing infrastructure components. It provides the validation layer that confirms attribute mappings conform to expected structure, referential integrity, and business constraints before they are persisted or removed from the pricing data model.

Key Procedures and Functions

The package exposes three documented procedures, all of which return a status indicator through an OUT parameter:

• Entity — Validates an FNA entity record, comparing the incoming record against a prior ("old") version of the same FNA record. Accepts both the new record and an optional old record defaulting to the missing-record sentinel from QP_Attr_Map_PUB, which allows the caller to signal an insert versus an update scenario. Its output is a return status indicating whether the entity passed validation.
• Attributes — Validates the attribute-level details attached to an FNA record, again comparing the current version with an optional prior version. This separates entity-level validation from attribute-level validation, permitting different rule sets for the two layers of the pricing attribute mapping.
• Entity_Delete — Performs the deletion-time validation for an FNA record. It accepts only the record being removed and a return status; there is no "old" version parameter because deletion validation concerns the record as it currently exists. This is the procedure most directly associated with the user's search term, "entity_delete," and is the hook that enforces deletion preconditions before a mapping is removed.

Tables Accessed

Three APPS-synonym tables are documented as referenced by this package's validation logic:

• MTL_DEFAULT_CATEGORY_SETS — Consulted to verify that default category set definitions associated with the FNA mapping exist and are valid, ensuring the source system mapping references legitimate inventory category structures.
• QP_PTE_SOURCE_SYSTEMS — The pricing source systems table, used to confirm that the source system identified on the FNA record is a registered and active pricing source system.
• QP_SOURCESYSTEM_FNAREA_MAP — The core mapping table between source systems and pricing FNA areas. Validation reads from and reasons against this table to detect duplicate, conflicting, or orphaned mappings.

Usage Notes

QP_VALIDATE_FNA is invoked programmatically rather than through a standalone concurrent program. Its primary consumers are the attribute-mapping infrastructure in Advanced Pricing and any caller that populates or deletes records in QP_SOURCESYSTEM_FNAREA_MAP. ETRM documentation indicates the package is referenced by one other package, meaning it is a dependent validation library rather than a top-level entry point. Customization or extension of pricing source-system mappings should route through the documented parent API (QP_Attr_Map_PUB and its record types), which in turn calls into this package's Entity, Attributes, and Entity_Delete procedures. Direct invocation is discouraged because the package is classified as OTHER and its signature may change without notice. In 12.1.1 and 12.2.2 the source header version (120.1) indicates the package has been stable for many releases, but its header comment explicitly marks it "noship," meaning it is an internal object not intended for customer use.