Search Results is_attribute_used

Overview

QP_VALIDATE_SEG is a server-side PL/SQL validation package in the Oracle E-Business Suite Advanced Pricing module. Its role is to enforce business rules against the segment, qualifier, and pricing attribute definitions that govern how pricing qualifiers and modifiers are resolved at run time. In the Oracle Pricing data model, a "segment" corresponds to a validated combination of pricing attribute values used to define qualifier and modifier structures. Before any such record is inserted, updated, or deleted, this package is responsible for verifying that required attributes are populated, that conditionally required attributes are supplied when their governing conditions are satisfied, and that inter-attribute dependencies remain internally consistent.

The package follows the standard EBS PL/SQL API conventions as defined by FND_API, including the NOCOPY OUT parameter for return status, the use of G_RET_STS_SUCCESS, G_RET_STS_ERROR, and G_RET_STS_UNEXP_ERROR constants, and the raising of G_EXC_ERROR and G_EXC_UNEXP_ERROR exceptions. It is classified as an OTHER API in the ETRM repository, meaning it is not a published public API but is nonetheless a recognized object within the pricing schema.

Key Procedures and Functions

Three procedures are documented in the package metadata:

• Entity — Performs validation of a single segment entity record. It checks required attributes (for example, a NULL segment_id triggers error message QP_ATTRIBUTE_REQUIRED), evaluates conditionally required attributes, and validates attribute dependencies. It receives a segment record and an optional prior-version record for update scenarios, and returns a status indicator through the standard FND_API return status parameter.
• Attributes — Validates the pricing attribute values associated with a segment record. This procedure enforces attribute-level rules after entity-level validation has succeeded, ensuring that the attribute set conforms to the qualifier and pricing context definitions.
• Entity_Delete — Validates whether a segment entity may be deleted. It performs referential and dependency checks to prevent removal of segment definitions that are still referenced by existing pricing constructs.

Each procedure uses the OE_MSG_PUB messaging infrastructure to post user-facing errors at the appropriate message level, and each returns status via the FND_API error-handling pattern.

Tables Accessed

The package operates against the following tables through APPS synonyms:

• QP_QUALIFIERS — Stores qualifier header definitions against which segment records are validated.
• QP_PRICING_ATTRIBUTES — Holds the pricing attribute definitions that determine which attributes are valid within a given pricing context.
• QP_PRC_CONTEXTS_B — Defines the pricing contexts that group attributes and control conditional requirements.
• QP_LIMIT_ATTRIBUTES — Associates limits-related attributes used in qualifier validation.
• QP_LIMITS — Stores limit definitions referenced during dependency checks.

These tables are read to resolve attribute metadata and dependency rules. The ETRM metadata does not confirm any direct writes, so the package is understood primarily as a read-and-validate component.

Usage Notes

QP_VALIDATE_SEG is invoked internally by the Pricing attribute and qualifier APIs, specifically within the QP_Attributes_PUB layer, rather than being called directly by end users. It is referenced by one other package in the ETRM dependency graph. Typical invocation points include the Pricing qualifier and modifier setup forms, concurrent programs that load or migrate pricing definitions, and custom extensions that insert segment records programmatically. Because the procedures raise FND_API exceptions, calling code must include the standard FND_API exception handlers to capture and surface validation errors correctly.