Search Results fun_tds_invoice




Overview
Explore in AI Chat

Overview

JAI_AP_IL_ORG_PKG is an Oracle E-Business Suite India Localization package that supports the Payables Invoice Workbench (APXINWKB.fmb) when it invokes India Localization functionality. The package encapsulates the PL/SQL tables, procedures, and functions required to determine whether India Localization is active in a given customer instance and to classify invoices and related transactions for Indian tax treatment, including Tax Deducted at Source (TDS). The source header identifies the file as jaiaporgb.pls, with a header revision dated 2008/07/29 and copyright attributed to Oracle Corporation (2007). The package is owned by APPS and is classified as OTHER, meaning it is not a formal public API but is still referenced by other database objects. Its scope is deliberately narrow: it answers a small set of localization questions rather than performing full invoice processing, leaving calculation and accounting to other India Localization components.

Key Procedures and Functions

The package exposes five documented functions:

  • FUN_IL_ORG — Determines whether India Localization is installed at the customer instance. It evaluates the event registry entry JAI_EXISTENCE_OF_TABLES under owner JA and checks the currency passed to it, returning true only when localization tables exist and the currency is INR.
  • FUN_TDS_INVOICE — Classifies an invoice as a TDS invoice, taking an invoice identifier as input. The comment block records a history entry dated 15-Feb-2008 in which Eric changed this function under bug#6787209.
  • FUN_MISC_LINE — Identifies miscellaneous invoice lines for India Localization purposes, allowing the form to distinguish these lines from regular item or tax lines.
  • FUN_MISC_PO — Performs the corresponding determination for purchase order-related miscellaneous data within the India Localization context.
  • FUN_TAX_CAT_ID — Derives the applicable tax category identifier used by India Localization when categorizing invoice tax treatment.

No parameter lists are documented for FUN_MISC_LINE, FUN_MISC_PO, or FUN_TAX_CAT_ID, and callers should consult the deployed package specification before invoking them directly.

Tables Accessed

The package reads from several Payables and India Localization tables through APPS synonyms:

  • AP_INVOICES_ALL — The base Payables invoice header table, used to validate and classify the invoice under evaluation.
  • AP_INVOICE_LINES — Standard invoice line data, consulted when evaluating line-level conditions such as miscellaneous lines.
  • JAI_AP_INVOICE_LINES — The India Localization extension of invoice lines, holding localization-specific attributes including TDS indicators.
  • JAI_CMN_VENDOR_SITES — India Localization vendor site information, used for supplier-related localization checks.
  • DUAL — Used for simple single-row evaluations and registry-style lookups.

In addition, the source references AD_EVENT_REGISTRY_PKG.Is_Event_Done, which reads the Applications event registry to confirm that India Localization tables have been installed.

Usage Notes

JAI_AP_IL_ORG_PKG is invoked primarily from the Payables Invoice Workbench form (APXINWKB.fmb) when that form calls India Localization logic. It is also referenced by one other package, so downstream localization code may depend on its return values. Because functions such as FUN_IL_ORG gate behavior on whether the installation is India Localization-enabled and the currency is INR, the package is effectively inert in non-Indian, non-INR environments. Callers should be aware that FUN_TDS_INVOICE was changed for bug#6787209 and that comment text in the source is inconsistent regarding the true/false semantics; integrators must verify actual return behavior from the deployed specification rather than relying on the header comment alone. As an OTHER-classified package, it should be treated as internal implementation rather than a supported public API.