Search Results c_hold_name_where




Overview
Explore in AI Chat

Overview

ONT_OEXOHHSA_XMLP_PKG is an Oracle Application Object Library (APPS) package that supports the Oracle Order Management XML Publisher report OEXOHHSA, commonly associated with order hold and hold activity analysis. The package encapsulates the report-level global variables, select-list lookups, and formula functions used by the concurrent program's underlying XML Publisher data definition. Its purpose is to compute the derived values that appear on the printed or published report, such as the accounting book (set of books) display name and the concatenated "where" clause fragments that drive the hold name and hold type filters. The package is unusually narrow in scope: it is bound to a single report, is not referenced by any other package in the EBS schema, and exists solely to bridge the concurrent program's parameter structure to the report's SQL and XML templates.

Key Procedures and Functions

  • SOB_NAMEFORMULA — Returns the display name of the set of books (ledger) identified by the package-level P_SOB_ID variable. This is the function referenced by the "sob_nameformula" search term, and it is the SOB/ledger name lookup used to print the book name on the report header.
  • BEFOREREPORT — Initializes the package state before the report's main query is executed, including resolution of the pform parameters and setup of the global where-clause variables.
  • AFTERPFORM — Applied after the parameter form is processed to finalize the selection criteria used by the report's data retrieval.
  • AFTERREPORT — Performs post-report cleanup and returns the report completion status to the concurrent manager.
  • C_ACTIVITY_MEANINGFORMULA — Returns the display meaning of the activity value used in the report's hold activity column.
  • C_HOLD_TYPE_WHERE — Returns the dynamic SQL where-clause fragment that restricts rows by hold type.
  • C_HOLD_NAME_WHERE — Returns the dynamic SQL where-clause fragment that restricts rows by hold name.
  • C_ENTITY_VALUE — Resolves an entity's descriptive value from an object type code and object ID, typically used to translate a hold's owning entity into a readable name.
  • C_ENTITY_VALUE2 — A second entity-resolution function providing the same translation behavior for a secondary entity column on the report.

Tables Accessed

The package reads a set of Oracle Receivables and Oracle Order Management tables through APPS synonyms to resolve party and account context. HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS and HZ_LOC_ASSIGNMENTS are used to construct the customer name and address information displayed for the hold-affected entities. OE_ORDER_HEADERS provides the order-level header data to which holds (including credit, invoicing, and general holds tracked by the report) are attached. The package does not modify these tables; all access is read-only for reporting.

Usage Notes

ONT_OEXOHHSA_XMLP_PKG is invoked only by the OEXOHHSA XML Publisher concurrent program when the report is submitted from the Order Management responsibility. It is not exposed as a public API, is not called by any other package, and should not be invoked directly from custom code. Customizations typically avoid editing this file and instead copy the report definition or extend the source SQL, because the file header marks it "noship" (not shipped for support). In R12.1.1 and 12.2.2 the same package structure is retained; the significant 12.2 transformation concerns the underlying ledger model rather than this package, though SOB_NAMEFORMULA continues to reference the legacy SOB identifier.