Results for “after_report”

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

Overview

JE_ES_MODELO_EXT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. The name follows the Spanish-language naming convention used for localized tax reporting extensions, where "Modelo" refers to the official Spanish tax declaration models (such as Modelo 340, Modelo 347, or similar informational returns) required by the Agencia Tributaria. The package serves as an external reporting model generator, extracting transactional data from Oracle Payables and Oracle Receivables and formatting it into the structure required for Spanish regulatory submission.

The package is classified as API type OTHER in the ETRM repository and carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2. It is referenced only by itself, indicating it is a standalone utility rather than a shared library. Its dependency graph is narrow, referencing the GL_PERIODS table and SYS.STANDARD, which confirms that its core logic revolves around period selection and standard PL/SQL built-ins rather than deep integration with other application packages.

Key Procedures and Functions

The ETRM metadata documents four entry points within this package:

• BEFORE_REPORT — An initialization routine that executes before the main report generation logic. It typically establishes session context, resolves period parameters, and prepares the working data set used by subsequent procedures.
• AFTER_REPORT — A cleanup and finalization routine executed after report output is produced. It handles post-processing tasks such as releasing resources or updating status indicators.
• GETKEYID — A utility function that returns a key identifier, most likely supporting surrogate key generation or retrieval for records written to staging or reporting tables.
• FORMAT_AMOUNT — A formatting function that converts numeric monetary values into the string representation required by the Spanish tax model output, including decimal separator and sign conventions mandated by the regulatory specification.

These four procedures represent the classic before-process-after pattern used by Oracle's localized reporting utilities, with the two helper functions supplying key and formatting services to the main extraction logic.

Tables Accessed

The package reads from a broad cross-section of Payables, Receivables, and Trading Community Architecture tables through APPS synonyms:

• GL_PERIODS — Supplies the accounting period definitions used to bound the reporting window.
• AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS — Provide supplier invoice headers and line distributions for the payables side of the declaration.
• AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL — Supply supplier identification and tax-relevant site information, including NIF (tax identification number) data.
• AR_CASH_RECEIPTS_ALL and AR_RECEIVABLE_APPLICATIONS_ALL — Provide customer receipt and application data for the receivables side.
• HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, and HZ_CONTACT_POINTS — Supply the customer party, account, site, address, and contact details needed for the counterparty records in the tax model.
• FND_CURRENCIES and FND_TERRITORIES — Provide currency codes and territory/country designations for multi-currency and geographic classification.

This table set confirms that the package consolidates both inbound (payables) and outbound (receivables) transactions, consistent with the requirements of a Spanish VAT or informational return.

Usage Notes

JE_ES_MODELO_EXT_PKG is not invoked by any other documented package. It is therefore most likely called directly from a concurrent program or a custom report driver, with BEFORE_REPORT and AFTER_REPORT bracketing the report execution and FORMAT_AMOUNT and GETKEYID called internally or by the report template. Because the package depends on GL_PERIODS, callers must supply a valid period name or period set matching an open or closed GL period. Typical invocation occurs during periodic Spanish tax filing cycles, when the localization is active and the corresponding concurrent program is submitted from the Spanish responsibility. Customizations should avoid direct modification of the package body and instead wrap it in a custom driver to preserve supportability across EBS 12.1.1 and 12.2.2 upgrades.