Search Results get_receipt_class_flag
Overview
JAI_AR_UTILS_PKG is a JAI (Oracle Financials for India / Latin America localization) utility package owned by APPS. It consolidates shared Receivables-side tax and registration logic used by the Indian localization (JAI) layer of Oracle E-Business Suite. The package performs two broad classes of work: (1) tax recalculation and tax-determination support for Receivables transactions and receipts, including TCS/tax-category handling, and (2) maintenance of the registration and "apps release" reference data attached to Receivables transactions. It is classified in ETRM as an OTHER API and exposes six documented procedures/functions. It is referenced by three other packages, indicating it is treated as a shared internal utility rather than a public integration interface. The source header ships at version 120.1 (2005/07/20), so the package is long-lived and stable across 12.1.1 and 12.2.2.
Key Procedures and Functions
- RECALCULATE_TAX — Recomputes the tax amount for a Receivables transaction line. It accepts transaction and header/line context, tax category, assessable value, currency and conversion factor, item/quantity/UOM, vendor, and audit columns, and returns the recalculated tax amount through an IN OUT NOCOPY parameter. A separate VAT assessable value parameter supports VAT-style computation.
- LOCATOR_HANDLER — Handles locator (inventory locator) processing for a given transaction, controlled by a flag whose conventional value is the JAI constant for "yes".
- APPS_REL_INSERT — Inserts an "apps release" record linking organization, location, registration name, and completion flag, together with creator/updater audit columns. This is the procedure associated with the apps_rel_insert search term.
- GET_TCS_FLAG — Retrieves the TCS (Tax Collected at Source) indicator relevant to the calling transaction context.
- GET_RECEIPT_CLASS_FLAG — Returns a flag derived from receipt classification, used to decide receipt tax treatment.
- IS_RECEIPT_TAXES_EXISTS — Determines whether taxes already exist for a receipt, typically to prevent duplicate tax application.
Tables Accessed
Through APPS synonyms the package touches Receivables setup and JAI transaction tables:
- AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS — Receipt setup used by the receipt-class and receipt-tax checks.
- JAI_AR_TRX_APPS_RELS_T — Target of APPS_REL_INSERT, storing the transaction-to-registration/release association.
- JAI_AR_TRX_TAX_LINES, JAI_AR_TRX_UPDATE_T — Per-line tax amounts and transaction update staging consumed during recalculation.
- JAI_CMN_TAXES_ALL, JAI_CMN_DOCUMENT_TAXES — Tax definition and document-tax mapping used to resolve rates and applicability.
- JAI_RGM_DEFINITIONS, JAI_RGM_REGISTRATIONS — Registration definitions and registrations used by APPS_REL_INSERT.
- MTL_UNITS_OF_MEASURE — UOM validation/conversion support for tax computation.
Usage Notes
JAI_AR_UTILS_PKG is invoked from localization forms, Receivables transaction and receipt workflows, and JAI concurrent programs, and is called by other JAI packages (three documented dependents). RECALCULATE_TAX is normally called during transaction entry or update in the India localization when tax must be re-derived from assessable value; LOCATOR_HANDLER is called during transaction processing when locator handling is required. APPS_REL_INSERT is called when a transaction must be associated with registration/release reference data, and is also suitable for targeted correction scripts run by a DBA where that association is missing. Because the package is an internal utility rather than a documented public API, callers should observe its IN OUT NOCOPY and default-parameter conventions, pass the JAI constants for flag values, and supply consistent audit columns. No autonomous commit behavior should be assumed; commit responsibility remains with the calling process.