Search Results jai_ap_il_org_pkg




Overview
Explore in AI Chat

Overview

JAI_AP_IL_ORG_PKG is an Oracle Applications (APPS) schema PL/SQL package that forms part of the Oracle E-Business Tax (EBTax) / ETRM (E-Business Tax Reporting and Management) localization framework within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package is oriented toward Israeli localization requirements for Oracle Payables, and its name reflects the "IL" (Israel) country designation used across Oracle's JAI-prefixed localization modules. The "ORG" element indicates that the package resolves organization-level attributes that influence invoice and tax processing.

Functionally, JAI_AP_IL_ORG_PKG supports Payables invoice and tax processing by supplying helper logic that populates or derives organization-, vendor-, and line-level attributes required during Israeli tax determination. It operates as a supporting API layer rather than a standalone concurrent program or form-backed module. In the ETRM object classification it is recorded as an OTHER-type API, meaning it is a utility/support package consumed internally by other Payables and tax processing components rather than a public integration API.

Within the documented metadata the package is marked VALID and is owned by APPS. It depends directly upon the SYS-owned STANDARD package and is referenced by at least one other package, JAI_AP_STND_TAX_PROCESS, confirming that it is an internal dependency of the standard Israeli tax processing flow rather than an entry point invoked directly by end users.

Key Procedures and Functions

The package exposes five documented procedures and functions:

  • FUN_IL_ORG — Resolves and returns Israeli localization organization-level context used by downstream tax and invoice routines. It is the primary organization-scoped accessor in the package and provides the organizational parameters on which the remaining functions rely.
  • FUN_MISC_LINE — Handles miscellaneous invoice line processing, deriving or validating line-level attributes for non-standard (miscellaneous) Payables distributions.
  • FUN_TDS_INVOICE — Supports Tax Deduction at Source (TDS) treatment at the invoice level, applying Israeli withholding-related logic to invoice records during processing.
  • FUN_MISC_PO — Provides handling for miscellaneous purchase-order-related invoice information, bridging PO-sourced data into the Israeli tax determination path.
  • FUN_TAX_CAT_ID — Returns or resolves the applicable tax category identifier based on the organization, vendor site, and line context assembled by the other functions in the package.

All five are declared as functions, indicating that each returns a value consumed by the calling routine (notably JAI_AP_STND_TAX_PROCESS). Parameter lists are not documented in the ETRM metadata and must be verified against the deployed package specification.

Tables Accessed

The package accesses the following tables via APPS synonyms, confirming that its scope is Payables invoice and tax data:

  • AP_INVOICES_ALL — The core Payables invoice header table; read for invoice-level attributes such as vendor, invoice type, and organization context used in TDS and tax category resolution.
  • AP_INVOICE_LINES — Payables invoice line detail; read to evaluate line-level tax and miscellaneous line attributes.
  • JAI_AP_INVOICE_LINES — The Israeli localization extension table storing country-specific invoice line data not held in the base Payables tables.
  • JAI_CMN_VENDOR_SITES — The localization vendor site table supplying Israeli-specific vendor site attributes, including tax registration and withholding configuration.
  • DUAL — Used for single-row scalar evaluation within the functions.

No table is documented as being written by this package in the available metadata; the functions appear to be read/derivation oriented, returning scalar values to callers.

Usage Notes

JAI_AP_IL_ORG_PKG is an internal support package. It is not exposed through a form, menu, or concurrent program, and should not be invoked directly from custom code unless the caller replicates the full context that JAI_AP_STND_TAX_PROCESS establishes. Its documented referencing object is the JAI_AP_STND_TAX_PROCESS package, which is the localization entry point invoked during Israeli Payables tax processing (typically through the standard Payables invoice validation and tax calculation flow).

Because it is called from within the tax determination pipeline, the package executes for each applicable invoice and invoice line rather than in batch isolation. Customizations should avoid modifying it in place; instead, extensions should be layered above JAI_AP_STND_TAX_PROCESS. Administrators validating dependencies in ETRM should note the package's reliance on SYS.STANDARD and its dependent relationship with JAI_AP_STND_TAX_PROCESS when troubleshooting validation or compilation failures across 12.1.1 and 12.2.2 environments.