Search Results pn_location_id




Overview
Explore in AI Chat

Overview

APPS.JAI_GST_TAX_DEFAULTATION_PKG is an Oracle E-Business Suite PL/SQL package that encapsulates the India Localization (JAI) Goods and Services Tax (GST) tax category defaultation logic. Its principal business function is to determine and return the applicable GST tax category identifier for a given transaction party and context — customer, vendor, or first-party organization — using the party's registration details, item tax category details, and the effective dates of the tax category definition. The package header declares AUTHID CURRENT_USER, so its database objects resolve under the privileges of the invoking session rather than the package owner.

The package was introduced by the GST enhancement tracked under Bug 10043656 with a change date of 09/01/2010 (author Peng Zheng), and it references the design document TDD_12_2_FIN_JAI_Enhanced_GST.doc. The header comments in the shipped source file (jai_gst_tax_dflt.pls) indicate the package is built to deliver "New Tax Category Default logic for GST." Although the enhancement aligns with the 12.2.x India GST feature set, the object is present and documented in both 12.1.1 and 12.2.2 environments that carry the JAI GST patches.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within this package. Parameter lists are intentionally not reproduced here; the descriptions reflect their documented intent.

  • JAI_GST_CUST_DEFAULT_TAXES — Returns the default GST tax category for a customer or customer site. Its documented inputs include the first-party organization and location, the customer identifier, the ship-to site use identifier, the inventory item identifier, and the transaction date (used to compare against the tax category's start and end dates); the default tax category identifier is passed as an IN/OUT parameter. The header comments identify it as a public procedure called from JAI_AR_RCTLA_TRIGGER_PKG, confirming its role in receivables tax determination.
  • JAI_GST_VENDOR_DEFAULT_TAXES — Returns the default GST tax category for a vendor or vendor site, resolving the applicable registration and tax category from the supplier-side data. It serves the symmetrical payables-side determination to the customer procedure.
  • JAI_GST_ORG_DEFAULT_TAXES — Returns the default GST tax category at the first-party organization level, applying where the default is driven by the operating unit's own registrations and tax setup rather than by an external party.

Tables Accessed

The package reads the following tables through APPS synonyms, principally to resolve party identity, registration status, and item-level tax category treatment:

The package is referenced by one other package, consistent with a utility role in the broader India GST call chain.

Usage Notes

JAI_GST_TAX_DEFAULTATION_PKG is an internal localization utility rather than a user-facing interface. It is invoked programmatically during transaction processing — most notably from JAI_AR_RCTLA_TRIGGER_PKG in the receivables tax flow — when the system must derive a GST tax category before tax calculation. It would similarly be called from payables, order management, or organization-level GST setup paths that require a party or organization default.

Because the package resolves the default using the transaction date against tax category effective dates, callers must supply an accurate date to avoid selecting an expired or not-yet-effective category. Customizations should not modify the package directly; the supported approach is to call the procedures from custom code and treat the returned tax category identifier as an input to downstream tax determination. As with all JAI objects, it should be applied only in an environment where the India GST localization patches (starting from Bug 10043656) are installed.