Search Results delete_all_requests

Overview

OE_OE_HTML_HEADER is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API type. Its name indicates a specialized role within the Order Management (OE) module: providing the server-side logic that supports HTML-based, browser-rendered order entry interfaces. In EBS releases 12.1.1 and 12.2.2, this package participates in the header-level processing of sales orders presented through web or HTML-based user interfaces, complementing the core OE_ORDER_PUB public APIs.

The package is defined with AUTHID CURRENT_USER and declares two PL/SQL collection types, Number_Tbl_Type and Varchar2_Tbl_Type, both indexed by BINARY_INTEGER. It also declares global null collection variables, G_NULL_NUMBER_TBL and G_NULL_VARCHAR2_TBL, which act as default placeholders for optional table-typed parameters. This design allows callers to pass attribute identifier and value pairs in bulk without constructing full records.

Key Procedures and Functions

Nine documented procedures form the package interface:

• DEFAULT_ATTRIBUTES — populates default values for a header record and its associated attribute value record during order creation or entry.
• CHANGE_ATTRIBUTE — modifies a single header attribute, accepting a header identifier, an attribute identifier, and a value, while also supporting bulk attribute-id and attribute-value tables. It maintains old and new header record images for change tracking.
• SAVE_HEADER — persists header changes, with an optional processing flag controlling downstream processing behavior.
• DELETE_ROW — removes a header row identified by header id.
• PROCESS_OBJECT — orchestrates the object-level processing workflow, observing the standard initialization message-list convention.
• LOCK_ROW — acquires a row-level lock on the header to prevent concurrent modification.
• CLEAR_RECORD — resets the in-memory header record structure.
• DELETE_ALL_REQUESTS — clears pending request records associated with the HTML header context.
• POPULATE_TRANSIENT_ATTRIBUTES — fills transient, non-persistent attributes needed by the HTML presentation layer.

Tables Accessed

The package references four trading community (HZ) tables through APPS synonyms: HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, and HZ_PARTIES. These reads support customer validation and derivation of ship-to and bill-to information during header entry, ensuring that order headers reference valid customer accounts, account sites, and site uses. The package is referenced by one other package, indicating it is a dependent utility rather than a top-level entry point.

Usage Notes

OE_OE_HTML_HEADER is typically invoked from the HTML-based order entry flow rather than from Oracle Forms directly. Customizations should treat it as an internal supporting package: callers work through the OE_ORDER_PUB header record types passed into each procedure. Developers extending HTML order entry should preserve the IN OUT NOCOPY record semantics and the standard return-status, message-count, and message-data out parameters when wrapping these procedures. Because the package is classified as OTHER rather than a fully public API, Oracle does not guarantee interface stability across patches, so custom code should validate behavior after applying EBS 12.1.1 or 12.2.2 patch updates.