Search Results get_attribute_code

Overview

QP_BLANKET_AGR_UTIL is a utility package in the Oracle EBS Advanced Pricing (QP) module, owned by the APPS schema and classified in the ETRM repository as a utility (UTIL) API. Its documented purpose is to resolve descriptive flexfield (DFF) attribute codes for blanket agreements into their underlying seeded segment names and segment codes. In Oracle Advanced Pricing, blanket agreements and their pricing attributes are frequently captured through descriptive flexfields, where a user-visible "attribute" must be translated into the internal seeded attribute code before pricing logic, qualification, or attribute-mapping rules can evaluate the data correctly. This package encapsulates that translation inside a single, reusable function, insulating higher-level pricing code from the mechanics of the flexfield segment tables.

The package body is small and tightly scoped. Its header indicates it was last revised in 2005 and shipped as a "noship" (not shipped to customer-facing schema) internal unit, which is consistent with an internal plumbing utility rather than a public extension point.

Key Procedures and Functions

The ETRM documentation records exactly one callable program unit in this package:

• GET_ATTRIBUTE_CODE — Returns the seeded attribute code derived from a supplied flexfield name, context name, and attribute. It determines whether the calling session has pricing debug enabled via QP_PREQ_GRP.G_DEBUG_ENGINE and, when true, writes entry and exit trace messages using QP_PREQ_GRP.engine_debug. The resolution work is delegated to QP_UTIL.Get_Attribute_Code, whose results are passed back through output parameters; the function returns the resolved seeded attribute code to the caller. The exception handler records the error with FND_MSG_PUB.Add_Exc_Msg and re-raises FND_API.G_EXC_UNEXPECTED_ERROR, so failures surface to the calling pricing process as standard Oracle APIs errors rather than being silently swallowed.

No other procedures or functions are documented in the ETRM metadata for this package body, and no parameter lists should be inferred beyond the signature fragment contained in the source excerpt.

Tables Accessed

According to the ETRM metadata, the package references the following tables through APPS synonyms:

• QP_SEGMENTS_B — The base table holding pricing flexfield segment definitions; supplies SEGMENT_CODE, which the function uses as its segment-name workspace variable.
• QP_SEGMENTS_TL — The translation table for pricing flexfield segments; supplies SEEDED_SEGMENT_NAME, used to hold the resolved attribute code.

These references are consistent with a utility that must reconcile a user-facing flexfield attribute with the seeded, language-independent segment definition. Access is read-oriented; the documented contract returns values rather than persisting them.

Usage Notes

Because this is a UTIL-classified internal package, it is not intended as a customer-facing extension API. The ETRM metadata records that it is referenced by two other packages, indicating it is called from within the Advanced Pricing code stack — for example, during blanket agreement validation or attribute-mapping processing — rather than being initiated directly by an end user. It is not associated with a concurrent program or form in the documented metadata.

Custom code should normally invoke the underlying public wrapper (QP_UTIL.Get_Attribute_Code) unless replicating internal behavior is strictly required. When debugging attribute resolution, note that trace output depends on QP_PREQ_GRP.G_DEBUG_ENGINE being set to FND_API.G_TRUE; without that flag the function executes silently. Calls run under the APPS schema and should be made within the standard Advanced Pricing initialization context to ensure FND message handling is available.