Results for “jl_zz_ar_tx_groups_pkg”

20 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JL_ZZ_AR_TX_GROUPS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM taxonomy as an "OTHER" API. It belongs to the Oracle Financials for Latin America (JL/ZX localization) family and maintains the tax group configuration records stored in the JL_ZZ_AR_TX_GROUPS table for Argentine (AR) tax processing. Tax groups define how individual tax categories are combined, sequenced, and applied during transaction and invoice tax calculation, including compounding order, minimum amount and taxable-basis thresholds, tax-inclusive treatment, and tributary substitution rules. The package provides the standard insert, update, delete, and locking primitives that keep this setup table synchronized with the corresponding EBS entity, together with validation routines that enforce data integrity. It is a low-level, form-facing API whose scope is confined to a single table and whose interface exposes every column of the underlying entity, including the organization identifier (ORG_ID) that supports multi-org partitioning and the Attribute1 through Attribute15 descriptive flexfield columns.

Key Procedures and Functions

  • INSERT_ROW — Creates a new tax group record in JL_ZZ_AR_TX_GROUPS. It accepts the full column set: group tax and tax category identifiers, establishment type, contributor type, transaction nature, effective start and end dates, threshold-control flags, compounding precedence, minimum amount/taxable basis/percentage values, tax-inclusive and tributary substitution flags, reduction attributes, base rate, tax code, org identifier, who-columns, and the fifteen descriptive flexfield attributes. It also accepts a calling sequence argument for diagnostic tracing.
  • LOCK_ROW — Obtains a pessimistic lock on an existing row and verifies that the current database values match those supplied by the caller, guarding against lost updates when two sessions edit the same tax group concurrently.
  • UPDATE_ROW — Modifies an existing tax group record identified by its rowid, writing the new column values and updating the audit (who) columns.
  • DELETE_ROW — Removes a tax group definition from JL_ZZ_AR_TX_GROUPS.
  • CHECK_UNIQUE — Validates uniqueness of the key attributes that identify a tax group, preventing duplicate definitions before insert or update.
  • CHECK_OVERLAPPED_DATES — Detects date-range conflicts, ensuring that the effective period of the tax group does not overlap an existing active definition.
  • CHECK_GAPS — Detects gaps in the effective date ranges so that a tax category is continuously covered by an active tax group definition.

Tables Accessed

The package reads and writes JL_ZZ_AR_TX_GROUPS (referenced through an APPS synonym). All of the documented procedures operate on this single table: INSERT_ROW, UPDATE_ROW, and DELETE_ROW manipulate its rows; LOCK_ROW queries and locks them; CHECK_UNIQUE, CHECK_OVERLAPPED_DATES, and CHECK_GAPS query it to validate key uniqueness and the continuity of the START_DATE_ACTIVE/END_DATE_ACTIVE interval. No other table is documented in the metadata, and the package is not referenced by any other package, confirming that it is a leaf-level API.

Usage Notes

This package is typically invoked from the Oracle EBS forms layer that maintains Argentine tax group setup — for example the tax group and tax category configuration windows used by localization administrators — and occasionally from custom or migration code that loads tax group definitions programmatically. In EBS 12.1.1 and 12.2.2 it runs in the APPS schema and should be called with the correct ORG_ID for the operating unit in multi-org environments. Because the API raises standard application errors on uniqueness, overlap, or gap violations, callers should invoke the CHECK_* routines before or as part of the DML. The header revision (120.2) reflects an older code line, so customers should validate behavior against their installed patch level. Direct updates to JL_ZZ_AR_TX_GROUPS are not recommended; use this package to preserve audit columns and validation integrity.