Search Results p_last_day_p

Overview

APPS.JE_JEITXLRG_XMLP_PKG is a PL/SQL package associated with the Oracle E-Business Suite Italian Localization (JG/JE) subledger reporting framework. It supports the Exempt Letters report (JEITXLRG), a Rome/VAT-related statutory document that generates exemption letters for Italian legal reporting. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the defining APPS schema, which is consistent with Oracle Reports XML Publisher (XMLP) integration packages in EBS 12.1.1 and 12.2.2. Its source header indicates a 2007 revision, and the package is a standard XML Publisher report package generated to support a concurrent program running through the Oracle Reports/BI Publisher runtime. The functions exposed here are the report's user-exit hooks and bind variable accessors, invoked at runtime by the report engine.

Key Procedures and Functions

The documented procedures and functions fall into three categories.

• Report lifecycle: BEFOREREPORT and AFTERREPORT are the standard Oracle Reports triggers that initialize and finalize processing. BEFOREREPORT typically resolves profile options, sets up periods, and populates globals; AFTERREPORT performs cleanup.
• Conditional formatting / row-level logic: G_VENDOR_LETTERSGROUPFILTER acts as a group filter, controlling which rows of the vendor/letter data set are rendered. CF_ISSUE_DATEFORMULA and CF_ISSUE_DATE1FORMULA are format functions that convert the ISSUE_DATE input into a printable character representation; the user's search term "cf_issue_dateformula" refers to the first of these. CF_ASTERISKSFORMULA produces decorative or masking output, commonly used in statutory layouts to obscure sensitive identifiers or mark exempt amounts.
• Bind variable accessors: The functions ending in _P (P_FIRST_DAY_P, P_LAST_DAY_P, C_NAME_P, C_ADDRESS1_P, C_POSTAL_CODE_CITY_P, CP_MONTH_P, C_COUNTRY_P, C_VAT_REG_NUM_P, C_TAXPAYER_ID_P, C_COMMERCIAL_NUM_P, CP_YEAR_P, CP_COUNTRY_NAME_P) are generated accessor stubs that expose package-level variables to the report layout. These variables include the company name, address, postal code/city, VAT registration number, taxpayer ID, commercial registration number, and country name, as well as period start/end dates derived from GL_PERIODS.

Tables Accessed

The package references six underlying objects through APPS synonyms. GL_PERIODS supplies the accounting period boundaries used to derive P_FIRST_DAY and P_LAST_DAY. HZ_GEOGRAPHIES and the associated geography reference resolve country names printed on the letter, including CP_COUNTRY_NAME. JG_ZZ_VAT_REP_ENTITIES and XLE_ETB_PROFILES provide legal entity and first-party tax registration attributes (VAT registration number, taxpayer ID, commercial number), consistent with the Italian VAT reporting data model. JE_IT_EXEMPT_LETTERS stores the exemption letters and issue dates that drive the report content and the CF_ISSUE_DATEFORMULA logic. DUAL is used for simple scalar initializations and date conversions.

Usage Notes

This package is not intended for direct invocation by custom code. It is compiled into the APPS schema and called by the JEITXLRG Oracle Reports/XML Publisher concurrent program during report execution. The report engine calls BEFOREREPORT on entry, evaluates G_VENDOR_LETTERSGROUPFILTER and the CF_* formula functions as each row is processed, and invokes AFTERREPORT at completion. The _P accessors are consumed by the report XML/RDF layout to render variables. Because the package is AUTHID CURRENT_USER and no other packages reference it (referenced by 0 objects), it is effectively self-contained. Developers troubleshooting an issue with a value such as the issue date on an exempt letter should inspect the CF_ISSUE_DATEFORMULA logic and JE_IT_EXEMPT_LETTERS data rather than altering the package, since any modification risks invalidating a seeded localization artifact.