Results for “jl_zz_ar_tx_rules_pkg”

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

Overview

The APPS.JL_ZZ_AR_TX_RULES_PKG package body is a transaction-rule maintenance API within the Oracle E-Business Suite localization layer for Oracle Financials for Latin America (JL schema). It provides the low-level Data Manipulation Language (DML) operations that govern the JL_ZZ_AR_TX_RULES table, which stores the user-defined taxation rules applied to Oracle Receivables transactions. In Oracle EBS 12.1.1 and 12.2.2, this package functions as the server-side engine that persists and maintains the rule records consumed by the Latin American receivables tax determination logic, allowing organizations to define which tax rule level, tax category, contributor type, customer transaction type, and priority combination should be applied when deriving tax on an AR transaction.

The package is classified under the ETRM API classification OTHER, meaning it is an internal maintenance package rather than a published public API. It is owned by APPS and was last delivered with the header revision jlzztxrb.pls 120.2. The package exposes four documented procedures and is referenced by no other packages, confirming its role as a private, table-facing utility layer.

Key Procedures and Functions

The package body implements four documented procedures. None of these return values; each performs a single record-level operation against the underlying table.

• INSERT_ROW — Creates a new tax rule record in JL_ZZ_AR_TX_RULES. It accepts the rule attributes (rule identifier, tax rule level, rule, tax category, contributor type, customer transaction type, priority, description, and organization identifier) together with the standard EBS WHO columns (creation/update dates, users, login) and a calling sequence used for debug tracing. After the insert, a cursor re-queries the table by the business key combination to return the newly generated ROWID to the caller, raising NO_DATA_FOUND if the row cannot be located.
• LOCK_ROW — Obtains a row-level lock on an existing rule record, supporting the pessimistic locking pattern used by the surrounding EBS forms so that concurrent maintenance sessions cannot modify the same rule simultaneously.
• UPDATE_ROW — Modifies the mutable attributes of an existing tax rule record, refreshing the WHO audit columns to record the updating user and timestamp.
• DELETE_ROW — Removes a tax rule record from the table, typically invoked when a rule is retired or superseded by a new priority definition.

Tables Accessed

The package reads from and writes to a single documented table, JL_ZZ_AR_TX_RULES, accessed through its APPS synonym. Because the table carries an ORG_ID column and the insert routine selects by ORG_ID, the table is operating-unit (multi-org) enabled, and all operations are expected to run within a properly initialized MOAC context. The ROWID returned by the insert cursor provides the handle that EBS forms use for subsequent lock, update, and delete operations.

Usage Notes

This package is not intended for direct invocation by external interfaces. It is normally called by the Oracle Forms-based maintenance screens for Latin American receivables tax rules, where the form triggers invoke INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW as the user inserts, modifies, or removes rule definitions. The X_calling_sequence parameter is threaded through each call so that runtime errors can be traced back to the originating form or program unit.

Because ETRM documents no other packages referencing it, integrators should treat JL_ZZ_AR_TX_RULES_PKG as an internal implementation detail rather than a supported integration point. Custom code that requires programmatic rule maintenance should generally interact with the underlying table through the same WHO column conventions and MOAC initialization, or preferably use the higher-level localization APIs that populate the rule set. The package body remains present and unchanged across 12.1.1 and 12.2.2, so behavior is consistent between those releases.