Search Results ja_jainstpr_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.JA_JAINSTPR_XMLP_PKG package is a PL/SQL wrapper package associated with an Oracle EBS concurrent program responsible for generating the JA (Asia/Pacific Localizations) invoice serial number printing report. The package encapsulates the report logic and serves as the bind-variable container and formula engine for the XML Publisher (BI Publisher) report definition. Its name suffix, _XMLP_PKG, indicates it was auto-generated by the Oracle XML Publisher concurrent program report builder, which creates a package to hold report-level parameters, formula columns, and trigger functions.

The business purpose of the report is to produce a printed listing of supplier invoice serial numbers, integrating excise tax, central sales tax (CST), and other indirect tax amounts for India Localization (JA = Japan/Asia localizations, used for Indian statutory reporting). The package exposes invoice-level calculated fields—excise tax, CST, "others" amounts, and a computed serial number—that are consumed by the report layout. The package also tracks concurrent request context, such as the request ID and trace flags, which are standard for concurrent-program-based XML Publisher reports.

Key Procedures and Functions

The package declares several global variables, including JAINBATCHID, P_TRACE, P_DETAIL_TRACE, P_CONC_REQUEST_ID, and SERIAL_NUMBER, which hold report state and trace settings used across formulas. The documented functions are:

  • SERIAL_FFORMULA — Computes the serial number value used in the report output, likely deriving a sequence or formatted serial from the invoice batch.
  • EXCISE_TAXFORMULA — Calculates the excise tax amount for a given customer transaction and supplier invoice type.
  • CF_5FORMULA — A custom formula column (column F5) that returns a report-specific calculated value, typically tax or amount aggregation.
  • CSTFORMULA — Computes the Central Sales Tax amount for the transaction and invoice type supplied.
  • OTHERS_FORMULA — Aggregates residual or "other" tax and charge amounts not covered by excise or CST.
  • BEFOREREPORT — Standard XML Publisher trigger fired before report generation, used to initialize parameters and session context.
  • AFTERREPORT — Trigger fired after report completion, used to reset state or release resources.
  • BEFOREPFORM — Trigger fired before the report's PDF/print formatting stage.
  • P_TRACEVALIDTRIGGER — Validates the trace parameter value entered by the concurrent program user.
  • SERIAL_NUMBER_P — Returns the computed serial number, exposed as a report parameter/function; this is the member associated with the user's search term "serial_number_p".

Tables Accessed

The package reads data through APPS synonyms. The indirect tax tables—JAI_AR_SUP_HDRS_ALL, JAI_AR_SUP_LINES, and JAI_AR_SUP_TAXES—store supplier invoice headers, lines, and tax details used by the excise, CST, and other tax formulas. JAI_CMN_TAXES_ALL provides the tax code and rate definitions. The concurrent manager tables FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS supply concurrent program metadata and the request context (P_CONC_REQUEST_ID). The dynamic performance views V$DATABASE, V$PROCESS, and V$SESSION are typically accessed for diagnostic or trace logging of the report run.

Usage Notes

This package is not intended to be called directly by application forms. It is invoked by the Oracle EBS Concurrent Manager when the associated JA invoice serial number report is submitted, and internally by the XML Publisher engine to evaluate formula columns and triggers defined in the report template. The public function SERIAL_NUMBER_P allows the report definition and any dependent custom code to retrieve the serial number value. Because it is a generated report package, direct modification is not recommended; customizations should be applied through the XML Publisher template or by extending the underlying tax calculation logic. It is not referenced by any other documented packages, so its call surface is confined to its own report and concurrent program.