Results for “get_header_information”

32 results




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

Overview

AP_APXSSIMP_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the generic "OTHER" API category. The package supports the Oracle Payables Supplier Site Import program, exposing an XML Publisher (BI Publisher) report interface for that concurrent process. Under the EBS XML Publisher concurrent program architecture, the report tool generates a package body containing the report triggers and data-select logic needed to produce the final document output. AP_APXSSIMP_XMLP_PKG functions as the PL/SQL wrapper that supplies header content, NLS-translated strings, and report-level initialization variables to the Supplier Site Import report before and after the report is executed.

The package body header identifies it as APXSSIMPB.pls, release 120.0, dated December 27, 2007, and marked "noship," indicating it is not delivered through the standard shipped-file process but generated or seeded for use with the XML Publisher report definition.

Key Procedures and Functions

The package documents 22 procedures and functions. The principal report triggers are BEFOREREPORT and AFTERREPORT, which execute the setup and cleanup logic surrounding report execution, including the initialization of global report parameters and debug state. GET_NLS_STRINGS performs the core national-language-support initialization: it queries FND_LOOKUPS and AP_LOOKUP_CODES to populate cached values for the Yes, No, All, Void, and NA display strings, and retrieves message text for the "no data exists" and "end of report" labels via FND_MESSAGE. The function returns TRUE on success and FALSE on exception.

GET_COMPANY_NAME and GET_HEADER_INFORMATION build the report header, with GET_HEADER_INFORMATION being the function most commonly referenced by users searching this object. The remaining functions are package-level accessors for cached report variables: C_NLS_YES_P, C_NLS_NO_P, C_NLS_ALL_P, C_NLS_NO_DATA_EXISTS_P, C_NLS_VOID_P, C_NLS_NA_P, and C_NLS_END_OF_REPORT_P expose the NLS strings; C_REPORT_START_DATE_P returns the report run date; C_COMPANY_NAME_HEADER_P returns the formatted company name; and C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_DESCRIPTION_P, and C_CHART_OF_ACCOUNTS_ID_P expose the ledger's functional currency and chart-of-accounts attributes used to format monetary and accounting output. APPLICATIONS_TEMPLATE_REPORT_P is the standard XML Publisher boilerplate function invoked by the report template.

Tables Accessed

The package directly references the AP_SUPPLIER_SITES_INT interface table through APPS synonyms, which is the staging table for the Supplier Site Import concurrent program. This package reads that interface table to produce the report output summarizing supplier site import activity. Ancillary data is retrieved from FND_LOOKUPS, AP_LOOKUP_CODES, and FND_MESSAGE, which supply the translated lookup meanings and message text consumed by the NLS initialization logic.

Usage Notes

AP_APXSSIMP_XMLP_PKG is invoked automatically by the XML Publisher runtime when the Supplier Site Import report is submitted as a concurrent program; it is not intended for direct invocation from forms or custom code. No other packages reference it, confirming its role as a report-bound, self-contained unit. Its procedures should not be called directly, as the report trigger sequence (before-report, data model, after-report) is managed by the XML Publisher engine. Customizations should be limited to the underlying report template and the Supplier Site Import parameters rather than to this package body, which is regenerated by the report definition tool and carries the "noship" designation.