Search Results jl_zz_ar_tx_lib_pkg




Overview
Explore in AI Chat

Overview

APPS.JL_ZZ_AR_TX_LIB_PKG is a Latin American localization library package body used within Oracle E-Business Suite Receivables (AR). The "JL" prefix identifies it as part of the global/localization layer, and the "ZZ" convention indicates it serves a generic or template role for country-specific tax and fiscal requirements. In Oracle EBS 12.1.1 and 12.2.2, this package supports the tax determination and fiscal classification logic required for Latin American transaction processing, including Argentina, Brazil, and Mexico localization flows where additional tax attributes such as fiscal classification codes, tax categories, and tax-inclusive flags must be derived beyond the standard EBS tax engine.

The package acts as a shared library called by other localization packages and by Oracle Receivables transaction processes to resolve taxation-related attributes for invoice, debit memo, and credit memo lines. It is documented as VALID and is referenced by 17 other database objects, confirming its role as a foundational dependency rather than a standalone entry-point program.

Key Procedures and Functions

The ETRM metadata documents 13 procedures and functions. Their purposes are as follows:

Tables Accessed

The package reads and writes across both localization-specific and standard EBS tables (via APPS synonyms). AR_MEMO_LINES and RA_CUSTOMER_TRX_LINES_ALL supply transaction and memo line data for tax and fiscal code derivation. AR_VAT_TAX and ZX_PRODUCT_OPTIONS / ZX_PRODUCT_OPTIONS_ALL provide tax setup and product options used by the EBS tax engine. HZ_CUST_ACCT_SITES, HZ_GEO_STRUCTURE_LEVELS, and JL_ZZ_AR_TX_CUS_CLS support customer and location classification logic. MTL_SYSTEM_ITEMS supplies item attributes for item-level fiscal transaction nature codes, AR_SYSTEM_PARAMETERS_ALL and OE_SYS_PARAMETERS provide system-level configuration, and FND_LOOKUPS is queried via GET_LOOKUP_MEANING.

Usage Notes

This package is typically invoked indirectly. Receivables localization packages, tax determination routines, and AutoInvoice processing call its functions to derive fiscal attributes before tax calculation. It is also referenced by 17 dependent objects, meaning any change to its signature or logic can affect a broad set of localization programs. The presence of SET_MO_ORG_ID and GET_MO_ORG_ID indicates that callers must establish the correct Multi-Org context before invoking other routines. Custom extensions should treat this package as read-only reference logic rather than modifying it, and should mirror the operating unit context handling to avoid cross-organization data leakage.