Search Results get_form_startup_values

Overview

APPS.OE_OE_FORM_HEADER is a server-side PL/SQL package in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that supports the Oracle Order Management (ONT) order entry form (OEXOEORD) and its attendant business logic. The package encapsulates header-level processing for sales orders, including attribute defaulting, attribute changes, validation, row locking, cascading updates, and lookup-driven field derivation. It is classified under ETRM as an OTHER API, signifying that it is primarily an internal helper package rather than a public, standalone integration API. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling session, and it references Oracle Applications public APIs such as OE_ORDER_PUB for the canonical header record structures.

Within the order management flow, OE_OE_FORM_HEADER provides the form-level plumbing that prepares and persists the OE_ORDER_PUB.Header_Rec_Type, Header_Val_Rec_Type, and related DFF records before the core order API processes the transaction.

Key Procedures and Functions

The ETRM registry documents 28 procedures and functions. Representative entries include:

• DEFAULT_ATTRIBUTES — Initializes header attribute values, applying profile-driven and reference defaults to the incoming header record.
• CHANGE_ATTRIBUTE — Applies a change to a specific header attribute (identified by attribute ID) and returns the updated header, value, and prior-image records.
• VALIDATE_AND_WRITE — Validates pending header changes and, subject to a cascade flag, writes the results; also returns creation metadata.
• DELETE_ROW / DELETE_ALL_REQUESTS / CLEAR_RECORD — Manage row-level and form-session cleanup, including removal of requests and clearing the current record buffer.
• PROCESS_ENTITY / PROCESS_OBJECT — Drive header entity and object-level processing within the form’s workflow.
• LOCK_ROW — Acquires a lock on the header row to prevent concurrent modification.
• SALES_PERSON — Resolves salesperson-related header information.
• GET_FORM_STARTUP_VALUES / POPULATE_CONTROL_FIELDS — Populate form control fields and startup values when the order form is opened.
• GET_CASCADE_FLAG / SET_CASCADE_FLAG_FALSE — Read and reset the cascade-processing flag that governs propagation of header changes to lines.
• LOAD_SET_OF_BOOKS — Loads the set of books (ledger) context used for currency and accounting-related derivations on the header.
• GET_INVOICE_TO_CUSTOMER_ID / GET_SHIP_TO_CUSTOMER_ID — Return the invoice-to and ship-to customer identifiers for the current header.
• RESET_DEBUG_LEVEL / SET_DEBUG_LEVEL — Adjust the package’s diagnostic verbosity for troubleshooting.
• GET_GSA_INDICATOR — Returns the GSA (government) indicator used in pricing and compliance logic.

Parameter lists are intentionally omitted; naming and purpose reflect the documented metadata.

Tables Accessed

The package reads and writes through APPS synonyms. Customer and party information is drawn from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS, HZ_CONTACT_POINTS, and HZ_PHONE_FORMATS, supporting ship-to and invoice-to resolution and contact data. Accounting and currency context comes from AR_SYSTEM_PARAMETERS, AR_SYSTEM_PARAMETERS_ALL, and GL_DAILY_CONVERSION_TYPES. Descriptive flexfield structures are read from FND_ID_FLEX_STRUCTURES, and lookup values from FND_LOOKUP_VALUES. User identity is obtained from FND_USER, and AD_BUGS supports internal diagnostic and patch-tracking logic.

Usage Notes

OE_OE_FORM_HEADER is typically invoked indirectly by the Order Management order entry form rather than called directly by external integrations. Customizations that extend the order entry form—such as additional header-level validations, defaulting rules for DFFs, or cascading attribute propagation—may invoke its procedures from form-level triggers or custom PL/SQL. Because it is categorized as OTHER and depends on form session state, custom code should treat it as an internal helper and prefer the public OE_ORDER_PUB APIs for external integrations, invoking OE_OE_FORM_HEADER only where form-equivalent behavior is required. The package is referenced by two other packages, reinforcing its role as a shared form-support layer. Debug procedures (SET_DEBUG_LEVEL, RESET_DEBUG_LEVEL) are useful when diagnosing header behavior during implementation or support.