Results for “bulk_insert_formula”

10 results




Overview
Explore in AI Chat

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

Overview

ZX_FORMULA_PKG is the internal repository maintenance package for tax formula definitions within the Oracle E-Business Tax (EBTax / ETRM) module. Its principal role is to encapsulate the low-level DML operations against the ZX_FORMULA_B and ZX_FORMULA_TL tables that store tax formula header records and their translated (language-specific) name and description columns. In the ETRM 12.1.1 / 12.2.2 data model, a "formula" defines the configurable calculation rule set applied to a taxable basis — the base rate modifier, the treatment of cash, volume, and trading discounts, and the applicability of transfer, transport, insurance, and other charges. The package therefore sits at the persistence layer beneath the tax formula setup UI and any programmatic seeding of formula records.

The package header is defined on the source line package body ZX_FORMULA_PKG as, with the module's version identifiable by the header line $Header: zxdformulab.pls 120.9 2005/10/21 22:06:41 rsanthan ship $. The ETRM 12.2.2 classification for the owning object is OTHER, indicating it is not a formally published public API but an internal support package.

Key Procedures and Functions

  • INSERT_ROW — Inserts a single formula definition. It receives the full set of formula attributes: the formula identifier, formula type code, formula code, tax regime code, tax, effective dates, taxable basis type code, record type code, base rate modifier, the discount and charge applicability flags (cash, volume, trading, transfer, transport, insurance, other), the descriptive flexfield attribute columns, the audit/WHO columns (creation and last-update metadata), the request, program application, program, program login identifiers, formula name and description, enabled flag, content owner identifier, and object version number. The procedure uses a local cursor C that selects the ROWID from ZX_FORMULA_B where FORMULA_ID matches the supplied identifier, and returns the row identifier through X_ROWID.
  • LOCK_ROW — Acquires a row-level lock on the target formula record, supporting concurrency control during subsequent updates or deletes.
  • UPDATE_ROW — Modifies an existing formula record and its translated columns, reapplying the formula attribute set and audit information.
  • DELETE_ROW — Removes a formula definition and its dependent translated rows.
  • ADD_LANGUAGE — Inserts the translation row for a newly enabled language, propagating the base formula name and description into ZX_FORMULA_TL.
  • BULK_INSERT_FORMULA — Performs set-based insertion of multiple formula records, used for high-volume seeding or migration scenarios.

Tables Accessed

  • ZX_FORMULA_B — The base table holding formula header data; the primary target of insert, update, delete, and lock operations, and the source of the ROWID used by INSERT_ROW.
  • ZX_FORMULA_TL — Stores the language-specific formula name and description; maintained by ADD_LANGUAGE and refreshed on update or delete.
  • FND_LANGUAGES — Supplies the set of installed/active languages for translation row creation.
  • ZX_PROCESS_RESULTS — Captures processing outcomes and diagnostic information.
  • PLITBLM — The standard EBS PL/SQL index-by table utility, used for array processing such as that required by BULK_INSERT_FORMULA.
  • All tables are referenced through APPS synonyms.

Usage Notes

ZX_FORMULA_PKG is an internal implementation package: ETRM metadata records zero dependent packages, meaning no other packaged code calls it directly. It is invoked by the E-Business Tax configuration forms (and, historically, by Oracle Receivables tax setup flows) whenever a user creates, modifies, or deletes a tax formula, and by concurrent programs or seeding scripts that bulk-load formula definitions via BULK_INSERT_FORMULA. The ROWID returned by INSERT_ROW is typically retained in the calling form's block for subsequent update, lock, and delete navigation. Customizations should not call INSERT_ROW, UPDATE_ROW, or DELETE_ROW as a public API, because the package is not classified as a supported interface; direct DML risks bypassing the concurrency and translation handling maintained by LOCK_ROW and ADD_LANGUAGE. For release 12.2.2, the same behavior applies as in 12.1.1, with the package name unchanged.