Results for “jl_zz_ar_tx_groups”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.JL_ZZ_AR_TX_GROUPS_PKG package body is a custom (non-seeded, "ZZ" prefixed) PL/SQL construct registered in the ETRM repository under the APPS schema with the classification OTHER. It operates within the Oracle E-Business Suite Financials and Localizations architecture and is designed to provide transaction processing logic for the JL_ZZ_AR_TX_GROUPS table, which is associated with Oracle Localizations (JL) for Receivables (AR) tax group handling. The package encapsulates the standard DML operations — insert, update, delete, and lock — together with validation routines for uniqueness, overlapping date ranges, and gaps within date ranges. Its documented status is VALID, indicating the object compiles successfully within the target EBS release (12.1.1 or 12.2.2). Because no other database object references this package, it functions as a top-level API rather than a subordinate internal library, and is typically bound to a form or custom concurrent process that manages tax group records.
Key Procedures and Functions
The package body exposes seven documented program units:
- INSERT_ROW — Inserts a new tax group row into
JL_ZZ_AR_TX_GROUPS, presumably applying defaults and validations before persisting the record. - LOCK_ROW — Acquires a row-level lock (typically via
SELECT ... FOR UPDATE) against an existing tax group record to protect it during concurrent editing. - UPDATE_ROW — Modifies an existing tax group row, updating the stored attributes while maintaining referential integrity.
- DELETE_ROW — Removes a tax group record from the underlying table.
- CHECK_UNIQUE — Validates that the key attributes of the tax group do not duplicate an existing entry, enforcing uniqueness.
- CHECK_OVERLAPPED_DATES — Verifies that the effective date range of a group does not overlap the date range of another active group.
- CHECK_GAPS — Detects gaps between the end date of one record and the start date of the next, enforcing continuity of coverage where required.
The three CHECK routines are validation helpers; the four DML routines constitute the write interface. No parameter lists are documented in the ETRM metadata, so signatures should be inspected directly in the compiled source before any custom invocation.
Tables Accessed
The package references a single documented table: JL_ZZ_AR_TX_GROUPS, accessed through its APPS synonym. This table stores the tax group definitions — likely comprising group identifier, description, and effective start/end dates — that drive the date-range validation logic. The overlap and gap checks operate directly on the date columns of this table, comparing a candidate row against existing rows to enforce temporal consistency.
Usage Notes
Given its dependency footprint — APP_EXCEPTION, FND_MESSAGE, and STANDARD — the package raises errors through the EBS message dictionary, allowing the calling form or program to display user-friendly Oracle Applications error messages. Typical invocation occurs from an Oracle Forms-based maintenance screen for tax groups, supported by the standard insert/lock/update/delete pattern (with LOCK_ROW called before UPDATE_ROW in the interactive flow). Because the package is not referenced by any other database object, it is not part of a broader seeded call chain; instead it is invoked directly by custom code, a form trigger, or a concurrent program. When extending or debugging, note that all validation logic must be run before the DML routines; the CHECK procedures should be called explicitly to avoid surfacing database constraint violations at commit time.
-
View: JL_ZZ_AR_TX_GROUPS_V 12.2.2
APPS.JL_ZZ_AR_TX_GROUPS_V·↳ AR_SYSTEM_PARAMETERS_ALL·↳ AR_VAT_TAX·↳ AR_VAT_TAX_ALL_B·Explore JL module →
-
View: JL_ZZ_AR_TX_GROUPS_V 12.1.1
APPS.JL_ZZ_AR_TX_GROUPS_V·↳ AR_SYSTEM_PARAMETERS_ALL·↳ AR_VAT_TAX·↳ AR_VAT_TAX_ALL_B·Explore JL module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.JL_ZZ_TAX 12.1.1
-
PACKAGE BODY: APPS.JL_ZZ_TAX 12.1.1
-
PACKAGE BODY: APPS.JL_ZZ_TAX 12.2.2
-
PACKAGE: APPS.JL_ZZ_TAX 12.2.2
-
Not implemented in this database·Explore JL module →
-
Not implemented in this database·Explore JL module →
-
PACKAGE BODY: APPS.JL_ZZ_TAX 12.1.1
-
PACKAGE BODY: APPS.JL_ZZ_TAX 12.2.2
-
eTRM - JL Tables and Views 12.1.1
Temporary Table For Inflation Adjustment Report
-
eTRM - JL Tables and Views 12.2.2
JL_ZZ_INFO_T is temporary table
-
PACKAGE BODY: APPS.AD_MORG 12.1.1
-
PACKAGE BODY: APPS.AD_MORG 12.2.2
-
eTRM - JL Tables and Views 12.1.1
Temporary Table For Inflation Adjustment Report
-
12.2.2 DBA Data 12.2.2