Search Results ja_jainsitr_xmlp_pkg




Overview
Explore in AI Chat

Overview

JA_JAINSITR_XMLP_PKG is an Oracle Applications (APPS) PL/SQL package body that supports the Japanese localizations for Oracle E-Business Suite, specifically the India/Japan regional reporting layer centered on the JA_JAINSITR concurrent program. The "XMLP" suffix indicates that this package is bound to a BI Publisher (XML Publisher) report definition; it supplies the report's data logic, formulas, and layout parameters rather than performing transactional business processing. In release 12.1.1 and 12.2.2 the package remains a read-mostly reporting component, generating register-style output derived from supplier, excise, and tax data stored in the JAI (Japan/India Localization) schema family. Because the object is a package body with no external callers, its public procedures are effectively entry points consumed only by the concurrent manager through the associated XML Publisher template.

Key Procedures and Functions

The documented package exposes eight program units. Their purposes are:

  • SERIAL_FFORMULA — formula function returning the serial number or document serial value used to identify report rows.
  • EXCISE_TAXFORMULA — formula function that derives and returns the excise tax amount for a report line.
  • CF_5FORMULA — formula function computing the CF-5 statutory value, a Japanese tax reporting column.
  • CSTFORMULA — formula function returning the central sales tax (CST) amount for the line.
  • OTHERS_FORMULA — aggregate formula function for residual or miscellaneous tax components not covered by the dedicated formulas.
  • BEFOREREPORT — the standard XML Publisher before-report trigger, used to initialize package state and session context prior to data retrieval.
  • AFTERREPORT — the standard XML Publisher after-report trigger, used to release state and finalize the run.
  • SERIAL_NUMBER_P — procedure responsible for generating serial-number sequencing for the report output.

Oracle documents no parameter signatures for these units; only their names and roles are catalogued.

Tables Accessed

The package references the following tables through APPS synonyms:

All access is read-oriented; the package does not own or maintain the localization tables it reports on.

Usage Notes

JA_JAINSITR_XMLP_PKG is not referenced by any other database object. It is invoked exclusively at runtime by the Oracle Concurrent Manager when the JA_JAINSITR XML Publisher report is submitted, with the BEFOREREPORT/AFTERREPORT triggers bracketing the data fetch. It is not a callable business API and should not be invoked from forms, OAF pages, or custom PL/SQL; extensions should instead target the JAI localization base tables or the underlying concurrent program definition. Because the object is version-dependent, any report customization should be applied through a copied XML Publisher template and a clone of the package, leaving APPS.JA_JAINSITR_XMLP_PKG intact across 12.1.1 and 12.2.2 upgrades.