Search Results ja_jainvatr_xmlp_pkg




Overview
Explore in AI Chat

Overview

JA_JAINVATR_XMLP_PKG is an Oracle E-Business Suite (EBS) PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It is the report logic package associated with an Oracle Reports XML Publisher (XMLP) concurrent program used by the Oracle Financials for India (JA) product family. The suffix XMLP_PKG indicates a report-trigger package automatically generated to support a BI Publisher report template; the package exposes report-level parameters and a set of formula functions that the report layout calls during execution.

The business purpose of the object is to produce the India VAT/CST register summary. The report aggregates statutory indirect-tax transaction data — sales and purchase turnover and tax, VAT and CST amounts, non-creditable and creditable items, and input tax claimable — for a specified regime, organization, location, registration number and date range. The regime parameter (P_REGIME) is central to the report: it governs which tax regime and set of taxes (P_REGIME_TAXES) determine how the calculations are grouped and presented. The report therefore supports periodic Indian statutory tax reporting by legal entity and registration.

Key Procedures and Functions

The package declares global variables for the runtime parameters, including P_CONC_REQUEST_ID, P_REGIME, P_REGIME_TAXES, P_ORGN_ID, P_LOCN_ID, P_FROM_DATE, P_TO_DATE, P_REGN_NO and the cancellation date bounds P_CAN_DATE_FROM and P_CAN_DATE_TO. It exposes two report lifecycle functions: BEFOREREPORT, which performs pre-report initialization, and AFTERREPORT, which performs post-report cleanup.

Tables Accessed

The package reads transaction and setup data through APPS synonyms. Order and shipping data are drawn from OE_ORDER_HEADERS_ALL, JAI_OM_WSH_LINES_ALL and RCV_TRANSACTIONS (with JAI_RCV_RGM_LINES for receiving/regime detail); purchasing data comes from PO_REQUISITION_LINES_ALL. Concurrent program context is obtained from FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS, while V$DATABASE, V$SESSION and V$PROCESS supply database, session and process identifiers used for the concurrently running report instance. Consistent with its reporting role, the package is predominantly read-only.

Usage Notes

The package is invoked exclusively by the India VAT/CST summary concurrent program when the associated Oracle Reports executable runs. Parameters such as P_REGIME and P_REGIME_TAXES are supplied by the user at submission and consumed by the formula functions during data formatting. The ETRM metadata records no dependent packages and no inbound package references, confirming that this is a self-contained report support package rather than a callable business API. Customizations should avoid modifying the package directly, as report-trigger packages are regenerated when the underlying report is recompiled.