Search Results p_transaction_date_to




Overview
Explore in AI Chat

Overview

JA_JAINRACT_XMLP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner. The _XMLP_PKG suffix identifies it as the generated PL/SQL stub associated with an Oracle XML Publisher (BI Publisher) concurrent program. In this case the underlying report is the India Localization "Receipt Accounting" (JAINRACT) report, part of the JA (Oracle Financials for India) product family. The package serves as the server-side companion to the XML template: it declares the report's bind parameters, performs pre-report setup logic, executes trigger validation, and carries out any post-report cleanup. Its header comment dates to 2007 and it remains listed in ETRM at 12.1.1 and 12.2.2.

Key Procedures and Functions

  • BEFOREREPORT — Returns BOOLEAN. This is the standard XML Publisher before-report hook that the concurrent manager invokes prior to executing the data model. It is used to initialize session context, resolve organization or ledger defaults, and set up any globals required by the report query.
  • AFTERREPORT — Returns BOOLEAN. The corresponding after-report hook, invoked once the report output has been produced. It is typically used to reset package-level state or release resources.
  • P_ACCT_NATUREVALIDTRIGGER — Returns BOOLEAN. A validation trigger function bound to the P_ACCT_NATURE parameter, enforcing that only permissible account-nature values are accepted before the concurrent request proceeds.

The package also exposes the report's global parameter variables, including P_RECEIPT_NUM, P_ORGANIZATION_CODE, P_TRANSACTION_TYPE, P_TRANSACTION_DATE_FROM, P_TRANSACTION_DATE_TO, P_LINE_NUM, P_ACCT_NATURE, P_CENVAT, P_EXPENSE and P_CONC_REQUEST_ID. The user search term "p_expense" refers to P_EXPENSE VARCHAR2(30), a report input that filters or classifies records by expense type or expense account indicator within the receipt accounting output.

Tables Accessed

  • FND_CONCURRENT_PROGRAMS — Read to obtain the definition of the concurrent program driving the report, including its executable and parameter metadata.
  • FND_CONCURRENT_REQUESTS — Read to correlate the runtime request with the P_CONC_REQUEST_ID parameter, enabling the report to log and associate its output with the correct concurrent request record.

Usage Notes

This package is not intended for direct invocation by application forms or by custom PL/SQL. It is executed implicitly by the Oracle Concurrent Manager whenever the associated Receipt Accounting XML Publisher program is submitted. The user supplies values such as Receipt Number, Organization Code, Transaction Type, date range, Line Number, Account Nature, CENVAT indicator and Expense through the concurrent program parameter form; the parameter defaults and validation are enforced server-side by this package, with P_ACCT_NATUREVALIDTRIGGER handling account-nature validation. Developers extending or cloning the report should preserve the package signature, since XML Publisher binds its data template to these globals by name. No other packages in the environment are documented as referencing JA_JAINRACT_XMLP_PKG, confirming its role as a terminal, report-specific unit within the India Localization module.