Results for “jl_zz_ar_tx_cat_att”

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

Overview

The APPS.JL_ZZ_AR_TX_CAT_ATT_PKG package is a database-tier PL/SQL package that belongs to the Oracle E-Business Suite (EBS) localization layer for Latin American (JL) tax processing, specifically the Argentina (AR) tax category attribute functionality. Its owner is the APPS schema, its status is VALID, and its API classification is listed as OTHER, which indicates that it is not a public, published EBS API but rather an internal supporting package. In Oracle EBS 12.1.1 and 12.2.2, this package underpins the maintenance of tax category attribute records used by the Latin American tax engine. Tax category attributes associate a given tax category with additional configurable values (attributes) that drive how taxes are computed, reported, or validated for a specific jurisdiction. Because the package name embeds the _PKG suffix and exposes a standardized CRUD surface (insert, update, delete, lock, and uniqueness checks), it functions as the backbone of a multi-row maintenance form or table-handler-based user interface rather than a business-facing API.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

• INSERT_ROW — Creates a new tax category attribute record in the base table.
• UPDATE_ROW — Modifies an existing tax category attribute record.
• DELETE_ROW — Removes a tax category attribute record.
• LOCK_ROW — Obtains a row-level lock on a target record to support concurrency control during form-based editing.
• CHECK_UNIQUE — Validates that no duplicate attribute combination exists for the same tax category before insertion or update.
• CHECK_DETERMINING_FACTOR — Validates the determining factor associated with the attribute, ensuring the configuration conforms to the determining-factor rules defined for the localization.
• LOCK_ROW_PRIORITY_NUMBER — Locks a record identified by its priority number, used when ordering or sequencing attributes.
• UPDATE_ROW_PRIORITY_NUMBER — Updates the priority number assigned to an existing attribute record, allowing sequencing changes without altering other columns.

The presence of separate lock and update routines for the priority number indicates that the priority value participates in a controlled editing flow, likely within a detail block of a form.

Tables Accessed

The package references two tables through APPS synonyms:

• JL_ZZ_AR_TX_CAT_ATT — The base table holding Argentina tax category attribute definitions. This is the primary target of the INSERT_ROW, UPDATE_ROW, and DELETE_ROW operations and the source for the uniqueness and determining-factor validations.
• JL_ZZ_AR_TX_ATT_VAL — The related table of attribute values. It is consulted during CHECK_DETERMINING_FACTOR and related validations to confirm that the attribute value supplied for a tax category is valid within the configured value set.

Usage Notes

The package is referenced by no other packages in the documented dependency set, and its own dependency list is limited to SYS.STANDARD. This confirms it is a leaf-level entity-maintenance package invoked directly by client code rather than called from a broader processing chain. In practice, such packages are called from Oracle Forms modules (the table handler of the tax category attribute maintenance screen) so that form-level insert, update, delete, and lock events delegate to server-side PL/SQL. Customers and partners may also call the routines from custom concurrent programs or scripts that seed or migrate tax category attribute configuration. Because it is classified as OTHER and carries ETRM documentation marked proprietary and confidential, it should be treated as an internal implementation object: direct invocation is possible but unsupported, and any customization should avoid altering the package specification to preserve upgrade safety across 12.1.1 and 12.2.2.