Results for “p_close_date_t”

6 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

INV_INVTRCLS_XMLP_PKG is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a generated BI Publisher report package, identified by the _XMLP_PKG suffix, and is bound to the Inventory Transaction Historical (Transaction Reconciliation / Transaction Class) report. The package is declared with AUTHID CURRENT_USER and carries a single global-scope data block that exposes the report's runtime parameters and shared variables to the report's data model, group filters, and formulas.

The public interface is deliberately minimal: eleven public variable declarations and four callable program units. This is characteristic of Oracle's XML Publisher report wrapper packages, where the package supplies parameter plumbing, a currency-code lookup formula, a dynamic ORDER BY builder, and before/after report hooks that the concurrent manager invokes during report execution. The parameter P_CLOSE_DATE_T, the element referenced in the user's search, is the string-typed companion to the DATE parameter P_CLOSE_DATE; it preserves the user-entered value from the concurrent program parameter form so the report layout can render the date as typed rather than re-formatting it from the canonical DATE value.

Key Procedures and Functions

  • BEFOREREPORT — A boolean function invoked by the report engine before the main data query executes. It is the standard XMLP initialization hook used to resolve session context, derive dependent parameter values, and populate package-level variables such as the currency precision (C_STD_PRECISION) and the runtime organization.
  • AFTERREPORT — A boolean function invoked after the report data has been fetched and the layout produced. It performs the standard clean-up role in the XMLP report lifecycle, releasing package state once the concurrent request completes.
  • C_CURRENCY_CODEFORMULA — A formula function that accepts a currency code and returns a VARCHAR2. It is referenced from the report's data model or layout to translate a stored currency code into the display value expected on the report output.
  • C_ORDER_BYFORMULA — A formula function returning a VARCHAR2 that supplies a dynamic ORDER BY clause. This pattern allows the concurrent program's SORT_ID / sort parameters (P_SORT_ID, and the related condition parameter P_CONDITION) to drive row sequencing at runtime instead of hard-coding it in the query.

Tables Accessed

The documented ETRM metadata for this package lists no directly referenced base tables through APPS synonyms. This is expected for a wrapper package: the SQL that drives the report — drawing from Inventory transaction and transaction-history entities, organization definitions, and currency reference data — resides in the report's data model and supporting query objects, not in the package body itself. The package contributes parameter values and formula output to that query rather than performing its own DML. No INSERT, UPDATE, or DELETE operations are implied; the package is read-only with respect to application data.

Usage Notes

The package is not referenced by any other PL/SQL package in the ETRM catalog, confirming that its only consumer is the associated concurrent program and its XML Publisher report definition. It is invoked exclusively through the concurrent manager: the parameter form collects values such as P_ORG_ID, P_STRUCT_NUM, P_CONDITION, P_SORT_ID, and the close-date pair P_CLOSE_DATE/P_CLOSE_DATE_T, which the concurrent manager assigns into the package globals. In 12.1.1 and 12.2.2 the execution path is identical, though the 12.2.x file system and OAF-based concurrent request submission change how the XML Publisher template is resolved. Customizations should be limited to the report template and the underlying data model query; direct modification of the generated package is not supported, as the header comment (INVTRCLSS.pls) indicates Oracle-maintained source that is regenerated on patching.