Search Results jai_ap_invoice_lines_s

Overview

JAI_AP_STND_TAX_PROCESS is an APPS-owned PL/SQL package body within the Oracle E-Business Suite financials module, specifically serving the Oracle Financials for India (JAI) localization layer that manages India-specific tax requirements for Payables. The package encapsulates the logic required to populate, default, recalculate, and persist standard indirect taxes on Oracle Payables invoices. It forms the bridge between core Oracle Payables invoice structures (AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL) and the JAI India tax repository (JAI_CMN_DOCUMENT_TAXES, JAI_CMN_TAXES_ALL, JAI_AP_INVOICE_LINES). Because the localization must respect reporting geography and registration schemes, the package also consults JAI_RGM_DEFINITIONS and JAI_RGM_REGISTRATIONS, alongside JAI_CMN_VENDOR_SITES, to determine applicable tax treatment for a given supplier site transaction.

Key Procedures and Functions

• POPULATE_STND_INV_TAXES — This procedure populates the standard tax information associated with an invoice, assembling the set of applicable India tax records from the defaultation and tax repository tables and writing them back into the JAI document tax structures. It effectively seeds the tax lines that the remaining routines default and calculate.
• CREATE_TAX_LINES — Responsible for generating the persistent tax line records that correspond to the calculated taxes, inserting into the JAI invoice line and document tax tables so the tax amounts become addressable by downstream reporting and posting logic.
• DEFAULT_CALCULATE_TAXES — Combines defaultation and computation: it derives default tax codes from configuration (via JAI_CMN_TAX_DEFAULTATION_PKG) and then calculates the resulting tax amounts for the invoice, honoring registration and vendor site attributes.
• UPDATE_CCID — Updates the code combination identifier (CCID) linkage, ensuring tax distributions resolve to the correct GL_CODE_COMBINATIONS accounting flexfield values so that tax amounts post to the appropriate accounts.

Tables Accessed

The package reads and writes against core Payables synonyms: AP_INVOICES_ALL (invoice headers), AP_INVOICE_LINES_ALL (invoice lines), and AP_INVOICE_DISTRIBUTIONS_ALL/AP_INVOICE_DISTRIBUTIONS_S (distribution and accounting representations). It manipulates the JAI tax tables JAI_AP_INVOICE_LINES, JAI_AP_INVOICE_LINES_S, JAI_CMN_DOCUMENT_TAXES, and JAI_CMN_DOCUMENT_TAXES_S for India document-level tax detail, and reads JAI_CMN_TAXES_ALL for tax code/master definitions. Registration and reporting context are drawn from JAI_RGM_DEFINITIONS, JAI_RGM_REGISTRATIONS, and JAI_CMN_VENDOR_SITES, while JAI_INTERFACE_LINES_ALL supports interface-based invoice flows. GL_CODE_COMBINATIONS is read and updated to resolve accounting flexfield assignments.

Usage Notes

JAI_AP_STND_TAX_PROCESS is invoked within the India Payables tax workflow, most commonly triggered from the Payables invoice entry forms and from India-specific concurrent programs that process invoice tax defaultation and calculation. It depends on FND_GLOBAL for session context, FND_LOG for debug logging, and helper packages JAI_AP_IL_ORG_PKG, JAI_CMN_RGM_RECORDING_PKG, JAI_CMN_TAX_DEFAULTATION_PKG, and JAI_CONSTANTS for organization defaults, reporting registrations, and constant values. The ETRM metadata records it as an OTHER-classification API referenced by one other package and referencing numerous JAI and Oracle objects; it is not referenced internally by other database objects in this release. Customizations should call the documented routines rather than manipulate the underlying JAI tax tables directly, preserving defaultation and CCID integrity.