Search Results get_attr_tbl

Overview

The APPS.OE_HEADER_ADJ_ATTR package is a PL/SQL specification belonging to the Oracle Order Management (OM) module of Oracle E-Business Suite. It resides in the APPS schema and is classified under the ETRM repository as an "OTHER" API, indicating that it is not a public, supported extension interface but rather an internal utility package used by Order Management forms and concurrent processing logic. Its name — combining "OE" (Order Entry), "HEADER_ADJ" (header adjustments), and "ATTR" (attributes) — positions it as a supporting component for the flexible attribute framework associated with order header adjustments, such as price lists, modifiers, promotions, and qualifiers applied at the order header level.

In Oracle EBS 12.1.1 and 12.2.2, Order Management relies heavily on descriptive and extensible flexfields (DDF/DFF) to capture customer-specific and industry-specific attributes. The OE_HEADER_ADJ_ATTR package encapsulates the logic for retrieving the definitions and values of these adjustment-level attributes, allowing the adjustment engine and associated UI components to resolve them consistently without embedding SQL directly in forms or workflow code.

Key Procedures and Functions

The package specification exposes two documented procedures, as reflected in the ETRM metadata and the source header (OEXAHADS.pls 120.0):

• Get_Attr_Tbl — Retrieves the attribute table, that is, the set of attribute definitions applicable to order header adjustments. The procedure populates an internal or caller-supplied table structure with the attribute metadata (name, prompt, column mapping, and related descriptive information) required by the adjustment framework.
• Get_Attr_Value_Tbl — Retrieves the attribute value table, that is, the runtime values assigned to those attributes for a given adjustment context. This complements Get_Attr_Tbl by supplying the data rather than the definition.

Both procedures are declared without an explicit parameter list in the specification, indicating that they operate on package-level global or session-based tables (PL/SQL tables) populated and consumed by the caller. No parameter lists are invented here; the ETRM documentation confirms only the procedure names and their descriptive comments.

Tables Accessed

According to the documented metadata, the package references a single database object via its APPS synonym: PLITBLM. This is the PL/SQL table mapping table used extensively throughout Oracle Order Management and Oracle Pricing. PLITBLM stores mappings between PL/SQL table indices and underlying descriptive flexfield segment columns, enabling applications to bind flexfield attributes to the correct database column at runtime. In the context of OE_HEADER_ADJ_ATTR, this table is read to resolve which flexfield segments correspond to the adjustment attributes being requested by Get_Attr_Tbl and Get_Attr_Value_Tbl.

Usage Notes

Because the ETRM classification is "OTHER" and the package is referenced by zero other packages, OE_HEADER_ADJ_ATTR is best understood as a leaf-level utility invoked directly by Order Management forms and concurrent programs rather than as part of a broader API call chain. Typical invocation points include:

• Order Management adjustment setup forms (for example, modifier and qualifier definition windows) that need to render attribute prompts and default values.
• Adjustment validation and pricing engine routines that must resolve attribute values during order entry, booking, or pricing.
• Custom extensions that require the same attribute definition and value semantics used internally by Order Management.

Developers should treat this package as internal and unsupported for direct customer modification. Custom code that calls Get_Attr_Tbl or Get_Attr_Value_Tbl should be validated carefully against each patch level, since the procedures are declared without formal parameters and rely on package global state. The header version (120.0) and the absence of downstream references both suggest the package is stable and narrow in scope, intended purely to support the header adjustment attribute framework across EBS 12.1.1 and 12.2.2.