Search Results get_header_info




Overview
Explore in AI Chat

Overview

JAI_OM_TAX_PROCESSING_PKG is an Oracle EBS Application Object Library (APPS) package that centralizes the taxation logic applied to Order Management sales order headers and lines for the India localization (JAI — "India" tax and regulatory modules). In Oracle EBS 12.1.1 and 12.2.2, this package supports the calculation, defaulting, validation, and persistence of transactional taxes on order lines, including excise duties, VAT, and related assessable values used in Indian indirect tax determination. It serves as the integration point between Order Management (OE) transaction flows and the JAI tax infrastructure, ensuring that tax attributes are consistently populated and validated as sales orders are created, changed, or copied.

Key Procedures and Functions

The package exposes four documented procedures, each framed around a before/after record pattern (pr_old, pr_new) passed from the Order Management transaction API, plus a return code and message for error handling:

  • ORDER_LINE_VALIDATION — Validates order line data against India tax rules during order entry or modification, returning a status code and error message.
  • POPULATE_TAX — Derives and populates default tax attributes (excise, VAT, assessable values) onto the order line when it is inserted or updated.
  • UPDATE_TAX — Applies tax recalculations and updates the associated tax records when line data changes.
  • DEFAULT_TAX — Establishes defaulting behavior for tax fields so that lines inherit appropriate tax treatment based on item, organization, or setup.

The package also declares cursors, most notably get_header_info and get_copy_order_line. The get_header_info cursor, which is the search term that led to this object, is a private cursor that retrieves order header details from OE_ORDER_HEADERS_ALL. It returns the row identifier, organization ID, sold-to customer, source document reference, order number, price list, order category, transactional currency, conversion type and rate, conversion date, and ordered date (falling back to creation date). This information supplies the header context required for tax processing on the associated lines.

Tables Accessed

The package reads and writes through APPS synonyms across Order Management, JAI tax, and inventory schemas. Source order data is drawn from OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL, with India-specific tax line detail stored in JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES. Customer site usage is resolved via HZ_CUST_SITE_USES_ALL. Tax determination relies on JAI_CMN_TAXES_ALL, JAI_INV_ITM_SETUPS, JAI_INV_SUBINV_DTLS, and JAI_CMN_INVENTORY_ORGS. Bond and regulatory detail is held in JAI_OM_OE_BOND_REG_DTLS and JAI_OM_OE_BOND_REG_HDRS. Return/RMA tax is handled through JAI_OM_OE_RMA_LINES and JAI_OM_OE_RMA_TAXES, shipment lines through JAI_OM_WSH_LINES_ALL, and debugging through JAI_CMN_DEBUG_CONTEXTS.

Usage Notes

This package is not typically called directly by end users. It is invoked indirectly by the Order Management transaction APIs when sales orders are entered, copied, or modified through the order entry forms or via interfaces and concurrent programs. Its procedures follow the standard EBS API convention of accepting old and new line records and returning a return code plus message, allowing calling transactions to roll back on validation failure. Because the package is referenced by two other packages, it functions as a shared utility layer within the JAI Order Management tax stack. Customizations and extensions that need consistent India tax behavior on sales orders should invoke these procedures rather than replicating tax logic. The get_header_info cursor remains private and is not exposed for external use.