Search Results je_jeitxlrg_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.JE_JEITXLRG_XMLP_PKG package body supports the Oracle E-Business Suite report that produces the Italian VAT Exempt Letters (lettere di esenzione) register. It belongs to the Oracle Financials for Italy localization layer (JE / JG schema prefix), which addresses tax-reporting obligations specific to Italian legal entities operating within EBS 12.1.1 and 12.2.2. The package encapsulates the PL/SQL logic that a BI Publisher / XML Publisher concurrent program executes at runtime: deriving tax-reporting entity identifiers, resolving the accounting period boundaries, validating legal entity assignment on exempt letters, and populating the report's data columns through a set of ref-cursor and formula functions.

The package is classified under ETRM metadata as API classification OTHER, i.e. it is a report-supporting package rather than a public application programming interface. It is not referenced by any other package, confirming it is a leaf-level implementation unit intended solely for the XML Publisher report template that invokes it.

Key Procedures and Functions

  • BEFOREREPORT — The before-report trigger. It establishes the organization context, resolves the reporting entity's legal entity ID from JG_ZZ_VAT_REP_ENTITIES, checks whether any exempt letters lack a legal entity assignment and if so calls the upgrade routine JE_IT_TAX_EX_UPGRADE.UPGRADE_MAIN, resolves the ledger ID from the GL_SET_OF_BKS_ID profile, and selects the period start and end dates from GL_PERIODS.
  • AFTERREPORT — The after-report trigger, used for cleanup and termination of the report session.
  • G_VENDOR_LETTERSGROUPFILTER — A group filter function applied to the vendor/letters data group to restrict the rows included in the report output.
  • CF_ISSUE_DATEFORMULA and CF_ISSUE_DATE1FORMULA — Column formula functions that format the issue date (and secondary issue date) values displayed on the exempt letter.
  • CF_ASTERISKSFORMULA — A column formula that conditionally renders a masked or asterisk-marked value, typically used to obscure confidential data such as taxpayer identifiers.
  • P_FIRST_DAY_P and P_LAST_DAY_P — Parameter accessor functions returning the resolved first and last day of the reporting period.
  • C_NAME_P, C_ADDRESS1_P, C_POSTAL_CODE_CITY_P, C_COUNTRY_P — Column functions returning the legal entity or party name, address line, postal code combined with city, and country description.
  • CP_MONTH_P, CP_YEAR_P, CP_COUNTRY_NAME_P — Parameter/column functions returning the reporting month, the fiscal year, and the localized country name.
  • C_VAT_REG_NUM_P, C_TAXPAYER_ID_P, C_COMMERCIAL_NUM_P — Column functions returning the VAT registration number, fiscal taxpayer ID (codice fiscale), and commercial register number respectively.

Tables Accessed

  • GL_PERIODS — Read to derive the period start date (P_FIRST_DAY) and end date (P_LAST_DAY) from the period set name and from/period names supplied as report parameters.
  • JE_IT_EXEMPT_LETTERS — The core transaction table for Italian VAT exempt letters; queried to detect letters with a null legal entity ID that require upgrade, and used as the primary data source for the report.
  • JG_ZZ_VAT_REP_ENTITIES — Joined to itself to map the reporting entity identifier to the associated legal entity ID.
  • HZ_GEOGRAPHIES — Used to resolve country names for the localized address and country columns.
  • XLE_ETB_PROFILES — Provides legal entity / establishment profile information for the tax-reporting context.
  • DUAL — Used for scalar lookups such as profile option values and constant derivations.

Usage Notes

The package is invoked exclusively through the concurrent program that drives the Italian VAT Exempt Letters XML Publisher report. The report template binds P_FIRST_DAY, P_LAST_DAY, and the C_* and CP_* functions as parameters and column data sources, so the accessors must remain stable for the template to render correctly.

Because BEFOREREPORT calls JE_IT_TAX_EX_UPGRADE.UPGRADE_MAIN, running the report can trigger a data migration that populates LEGAL_ENTITY_ID on legacy exempt letter rows. In 12.2.2 the ledger is resolved through GL_SET_OF_BKS_ID and the legal entity upgrade path remains necessary for releases where exempt letters predate the multi-org legal entity model. The package is not designed for direct call from custom PL/SQL: invocation from concurrent processing or form-driven report submission supplies the required parameters and the organization context established via FND_GLOBAL.ORG_ID.