Search Results header_adj

Overview

The APPS.OE_HEADER_ADJ_ATTR package body is a descriptor-flex attribute registration utility within the Oracle Order Management (OM) module. Its business function is to populate the global attribute table OE_GENERATE.g_attr_tbl with the set of descriptive flexfield segments that apply to order header price adjustment records. Specifically, the package declares each seeded ATTRIBUTEn column of the header adjustment descriptive flexfield — beginning with ATTRIBUTE1 and continuing through ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, and so on — as a VARCHAR2 segment of length 150, categorized as OE_GENERATE.G_CAT_DESC_FLEX and tagged with the descriptive context value HEADER_ADJ. This metadata is consumed by Oracle's generic OE_GENERATE framework, which uses it to build and render the header adjustment flexfield at runtime without hard-coded references to individual columns.

Key Procedures and Functions

• GET_ATTR_TBL — Loads the global attribute table with the header adjustment descriptive flexfield segment definitions. The procedure first deletes any existing contents of OE_GENERATE.g_attr_tbl, then iteratively constructs attribute records based on the template OE_GENERATE.G_MISS_ATTR_REC. Each record is populated with the column name (for example, ATTRIBUTE1), the data type (VARCHAR2), the segment length (150), the display name and code (lower-case attribute1), the flexfield category, and the discriminator value HEADER_ADJ. The completed records are stored into sequential slots of the global table.
• GET_ATTR_VALUE_TBL — Retrieves the corresponding attribute value table for the header adjustment flexfield, supplying the runtime values that pair with the segment definitions registered by GET_ATTR_TBL. This supports generation and rendering of the flexfield within the OE_GENERATE framework.

Tables Accessed

The only documented table reference is PLITBLM (accessed through an APPS synonym). PLITBLM is the Oracle Forms/PL/SQL internal table used to buffer large PL/SQL tables between program units. Its presence here reflects the fact that the package manipulates and passes large PL/SQL table structures — the global attribute and attribute value tables used by OE_GENERATE — rather than performing conventional DML against order or flexfield base tables. No application data tables are read or written by this package.

Usage Notes

OE_HEADER_ADJ_ATTR is an internal registration utility rather than a user-facing API. It is invoked indirectly by the OE_GENERATE framework whenever the header adjustment descriptive flexfield must be assembled, validated, or rendered — typically during order entry, order import, or whenever adjustment flexfield values are displayed or captured. The metadata confirms that it is not referenced by any other documented package, indicating it is called dynamically or through the generation framework rather than by named dependencies. The package is classified as OTHER, consistent with supporting-utility status; it should not be called directly from custom code, as OE_GENERATE maintains the global table state. The header text indicates an unship (noship) source control status, and the package is functionally identical between EBS 12.1.1 and 12.2.2.