Results for “org_name”

50+ results




Overview
Explore in AI Chat

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

Overview

The ZX_ACCOUNT_TAX_RATES_PKG package belongs to the Oracle E-Business Tax (E-Business Tax / ETRM) module and resides in the APPS schema. Its documented purpose is to implement various data checking routines required by the underlying tax option configuration used during tax setup. The package header, source file zxglatrs.pls (version 120.2), was originally created on 24-NOV-2004 by Tai-Hyun Won and later maintained under a "noship" designation, indicating it is an internal support package rather than a public, callable API.

Functionally, the package centralizes validation and maintenance logic associated with the gl_tax_options configuration area, specifically the account-level tax rate setup. It supports the forms-based maintenance of tax rates per ledger and content owner, ensuring that duplicate configurations are detected, organizational context is resolved, and column values are consistently retrieved and persisted. In Oracle EBS 12.1.1 and 12.2.2, such packages act as the procedural back end for the Tax configuration user interface, shielding the base tables from direct manipulation.

Key Procedures and Functions

The ETRM metadata documents six procedures within the package. Their documented purposes are as follows:

  • SELECT_COLUMNS — Retrieves column values from the ZX_ACCOUNT_RATES table associated with a given ledger and content owner. The retrieved tax precision and tax minimum accountable unit (MAU) values are returned through IN OUT NOCOPY parameters, reflecting the current ledger's configured precision settings.
  • DUPLICATE_TAX_OPTIONS — Checks whether another record already exists for the same ledger and organization combination, using a row identifier to support uniqueness validation. This prevents conflicting tax option records from being committed.
  • ORG_NAME — Resolves and returns the name of the current organization based on the supplied organization identifier, providing display context for the tax options form.
  • INSERT_ROW — Inserts a new account tax rate row, populating ledger, content owner, account segment value, tax precision, calculation level code, and rate override attributes.
  • UPDATE_ROW — Updates an existing account tax rate record with revised configuration values.
  • LOCK_ROW — Acquires a row-level lock on the target record, supporting concurrency control during form-based maintenance transactions.

Tables Accessed

The only documented application table referenced by this package is ZX_ACCOUNT_RATES, accessed through an APPS synonym. This table stores the account-level tax rate configuration that the package reads from in SELECT_COLUMNS and writes to in INSERT_ROW and UPDATE_ROW. The metadata also lists DBMS_SQL, Oracle's built-in dynamic SQL package, which indicates that some procedures build or execute SQL dynamically rather than through static statements. No other base tables are documented, and the package is referenced by zero other packages, confirming its role as a leaf-level utility within the tax configuration stack.

Usage Notes

ZX_ACCOUNT_TAX_RATES_PKG is typically invoked from the Oracle E-Business Tax setup forms where account tax rates and tax options are maintained. The form triggers call ORG_NAME and SELECT_COLUMNS during query and display processing, DUPLICATE_TAX_OPTIONS during validation before save, and LOCK_ROW, INSERT_ROW, and UPDATE_ROW during commit processing. It is not documented as a concurrent program entry point, and because it carries a "noship" header and is not referenced by other packages, it should be treated as an internal implementation detail rather than a supported public API. Customizations requiring account tax rate maintenance should therefore prefer supported E-Business Tax APIs over direct calls to this package.