Search Results not_matched

Overview

JAI_AP_STND_TAX_PROCESS is an Oracle Application Object Library (APPS) PL/SQL package that belongs to the Oracle Financials for India (JAI) localization layer, specifically the payables (AP) tax processing module. Its business function is to process and populate tax lines for standard loan invoices — that is, invoices processed through the standard Oracle Payables invoice workflow where India-localized tax computation must be applied. The package is responsible for deriving the applicable taxes on an invoice line, generating the corresponding tax lines, and defaulting or calculating taxes when no explicit tax information has been supplied. The source header confirms that the package was created by Eric Ma on 23-Aug-2007 and last revised in November 2008, and it is classified under the API classification "OTHER" within ETRM 12.2.2 documentation.

Key Procedures and Functions

ETRM documents four procedures/functions for this package:

• POPULATE_STND_INV_TAXES — The main entry point for the package. It is invoked by the India Payables form and, in turn, calls the tax-line creation logic. Its documented parameter set covers invoice id, line number, vendor site id, currency, line amount, tax category id, and a tax-modified flag; the procedure operates under the precondition that the invoice is valid, and it raises the exception path that causes default taxes to be created.
• CREATE_TAX_LINES — Creates the tax lines associated with an invoice. It is called from POPULATE_STND_INV_TAXES and drives the physical insertion of tax detail rows.
• DEFAULT_CALCULATE_TAXES — Calculates and applies default tax treatment when transaction-level tax information is absent or incomplete. The package-level constant GV_NOT_MATCH_TYPE (value 'NOT_MATCHED') and GV_CONSTANT_MISCELLANEOUS / GV_CONSTANT_ITEM support this matching and defaulting logic.
• UPDATE_CCID — Updates the code combination id (CCID) associated with tax accounting entries, ensuring that the correct general ledger accounting flexfield is referenced for the generated tax lines.

Tables Accessed

The package reads and writes through APPS synonyms, spanning standard Payables and India-localization tables. Standard Payables tables include AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_DISTRIBUTIONS_S, and GL_CODE_COMBINATIONS, which supply invoice headers, lines, distributions, and accounting flexfield data. India-localization tables include JAI_AP_INVOICE_LINES and JAI_AP_INVOICE_LINES_S (the localization extension of invoice lines), JAI_CMN_DOCUMENT_TAXES and JAI_CMN_DOCUMENT_TAXES_S (document-level tax details), JAI_CMN_TAXES_ALL (tax master), JAI_CMN_VENDOR_SITES (vendor site tax registration data), JAI_INTERFACE_LINES_ALL (interface staging), and the registration tables JAI_RGM_DEFINITIONS and JAI_RGM_REGISTRATIONS (registration and rule-group definitions used to determine applicability of taxes). These tables are accessed to determine which taxes apply to a given vendor site and line, to store computed tax lines, and to resolve the accounting flexfield for tax postings.

Usage Notes

JAI_AP_STND_TAX_PROCESS is typically invoked from the India Payables invoice entry form, where POPULATE_STND_INV_TAXES serves as the entry point whenever tax lines must be generated or recalculated for a standard invoice. It is also referenced by at least one other package in the India localization suite, and can be called from custom code or extension logic when programmatic tax line generation is required. The package-level globals GV_MODULE_PREFIX, GV_CONSTANT_MISCELLANEOUS, GV_CONSTANT_ITEM, GV_NOT_MATCH_TYPE, GV_JAI_AP_INVOICE_LINES, and GV_LINES_CREATEED govern the module logging prefix, tax type classification, unmatched-tax handling, and line-creation status flag respectively. Because the documented procedures are private APIs invoked in a specific Payables processing sequence, callers should ensure the invoice is valid before entry, as the package assumes that precondition and handles invalid or missing tax data through its default calculation path.