Search Results jl_zz_ar_tx_cus_cls




Overview
Explore in AI Chat

Overview

JL_ZZ_AR_TX_CUS_CLS_PKG is a customer-facing PL/SQL package body owned by the APPS schema in Oracle E-Business Suite and delivered as part of the E-Business Tax (EBTax) / ETRM localization components for Receivables. The package supports the maintenance of the customer class to tax attribute mapping used by the tax engine during tax determination. Specifically, it assembles and maintains rows in JL_ZZ_AR_TX_CUS_CLS, which links an AR customer or customer site address to a contributor class code, a tax category, and a set of contributor tax attributes. These mappings allow the tax service to pick the correct contributor attribute values when deriving tax for a given customer or site at transaction time. The package exposes a standard, generated-style API surface (insert, update, delete, lock, uniqueness check) plus one application-specific utility procedure, Populate_Cus_Cls_Rows, which bulk-seeds the mapping table from the contributor attribute class definition table JL_ZZ_AR_TX_ATT_CLS. In the 12.1.1 and 12.2.2 code lines this object is an APPS-owned, non-public API classified as OTHER, meaning it is intended for internal use by the tax localization layer rather than as a supported public integration interface.

Key Procedures and Functions

  • Populate_Cus_Cls_Rows — the primary business procedure. Given an address identifier, a class code, and an operating unit (org_id), it inserts a complete set of JL_ZZ_AR_TX_CUS_CLS rows by selecting the applicable tax category, attribute name, and attribute value combinations from JL_ZZ_AR_TX_ATT_CLS for contributor classes and contributor attributes. It derives keys from JL_ZZ_AR_TX_CUS_CLS_S and stamps enabled_flag, org, and audit columns from the FND_PROFILE session values. Note that its exception handler suppresses both NO_DATA_FOUND and OTHERS, so callers must verify results explicitly.
  • Insert_Row — inserts a single mapping row, including the rowid output and calling-sequence parameter used for diagnostic tracing.
  • Update_Row — updates an existing mapping row identified by the customer class definition.
  • Delete_Row — removes a mapping row, typically used when a customer-class assignment is retired or redefined.
  • Lock_Row — obtains a row-level lock on the mapping record for the duration of a transaction, guarding concurrent maintenance.
  • Check_Unique — validates that the combination of tax attribute class code, tax category, attribute name, and org_id does not already exist before insert or update.

Tables Accessed

  • JL_ZZ_AR_TX_CUS_CLS — the central mapping table written by every DML procedure. It stores the customer class/address assignment together with tax category, attribute name, attribute value, enabled flag, org_id, and WHO audit columns.
  • JL_ZZ_AR_TX_ATT_CLS — the contributor attribute class reference, read by Populate_Cus_Cls_Rows to source the category and attribute combinations for a contributor class code.
  • JL_ZZ_AR_TX_CUS_CLS_S — the sequence used to generate the primary key cus_class_id during population.

Usage Notes

Because the ETRM metadata records zero referencing packages, the object is not part of a broad internal call graph. It is typically invoked by the E-Business Tax configuration UI and its supporting form handlers when a user assigns contributor tax attributes to a customer or customer site, and by setup utilities that seed customer-class tax defaults during implementation. The generated-style procedures map directly to form-level DML operations (insert, update, delete, lock, unique check), which is the classic Forms-to-table-handler pattern. Populate_Cus_Cls_Rows is the entry point for bulk creation of mappings across an operating unit. As the package is classified OTHER and is not a public API, customizations should not call it directly without regression testing, and any extensions that write to JL_ZZ_AR_TX_CUS_CLS should respect the sequence and org_id conventions enforced here to avoid corrupting tax determination for affected customers.