Search Results p_vat_reporting_entity_id

Overview

APPS.JE_IT_LISTING_PKG is a PL/SQL package in Oracle E-Business Suite that supports the Italian VAT reporting (Esterometro / Intrastat-style listing) requirements delivered through the Oracle Financials localization for Italy. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the package owner, and it is registered under the ETRM classification OTHER. Its core responsibility is the extraction, finalization, and purging of transactional VAT listing data scoped to a specific VAT reporting entity and declaration year. All documented procedures share the parameter p_vat_reporting_entity_id, which identifies the legal reporting entity (typically a legal entity or VAT registration) whose data is being processed, and p_year_of_declaration, which scopes the operation to a fiscal declaration year. The package therefore acts as the processing engine behind the Italian VAT listing concurrent programs.

Key Procedures and Functions

• PURGE_TRX_DATA — Removes previously extracted or staged transaction data for a given VAT reporting entity and declaration year. It is used to clear stale extract results before a re-run or after a completed declaration cycle.
• FINAL_DATA — Standard concurrent-program entry point (with errbuf and retcode OUT parameters) that finalizes the listing data for the specified VAT reporting entity and declaration year, typically producing or validating the reportable dataset.
• EXTRACT_DATA — The main extraction routine. In addition to the standard concurrent errbuf/retcode parameters and the entity/year identifiers, it accepts reporting controls such as report type, VAT indicator, report mode, EFT indicator, party limit, customer and vendor sort columns, and a group-parties flag. These parameters govern how the extract is filtered, sorted, and consolidated.
• GET_BSV — A helper function that returns a balancing segment value (BSV) for a supplied code combination identifier (CCID), used to enrich extracted rows with the appropriate accounting flexfield context.

Tables Accessed

The ETRM metadata for this object does not enumerate the underlying tables accessed through APPS synonyms, and no tables are explicitly documented in the excerpt. Functionally, the package reads from Italian VAT listing staging and transaction tables and from standard Oracle Financials sources (payables, receivables, and accounting flexfield combination tables) to build the reportable dataset, and writes to the interim and final listing tables targeted by EXTRACT_DATA and FINAL_DATA. The GET_BSV function implies read access to the accounting flexfield combinations table. Because the exact object list is not documented in the available metadata, implementers should confirm the precise base tables on their release before writing dependent code.

Usage Notes

This package is designed primarily for invocation by Oracle EBS concurrent programs. EXTRACT_DATA and FINAL_DATA expose the standard errbuf/retcode signature expected by the concurrent manager, so they are typically registered as concurrent program executables and submitted from the Italian VAT listing responsibility or via the Submit Request form. PURGE_TRX_DATA may be called from a menu function, a scheduled purge request, or orchestrated by a wrapping program prior to extraction. The package reports zero other packages referencing it in the documented metadata, indicating it is an entry-point package rather than a shared library. Customizations should preserve the reported parameter conventions and should not be applied to the seeded package body, since it carries a shipped header revision; extensions belong in a separate custom package.