Search Results update_header_det_attribs

Overview

The ZX_LINES_DET_FACTORS_PKG package, owned by APPS and classified as an OTHER API within the E-Business Tax (ETRM) module, provides the PL/SQL interface layer responsible for persisting and refreshing tax determining attributes on the transaction line records used by Oracle EBS Payables and Receivables. Tax determination in ETRM depends on a set of "determining factors" — attributes such as product fiscal classification, product category, intended use, transaction business category, assessable value, and tax classification code — which are evaluated at the line level and stored in ZX_LINES_DET_FACTORS. This package supplies the programmatic entry points through which the Tax Engine, the Oracle Forms layer, and calling APIs write those values back to the repository so that the Tax Workbench and related UI screens display current, consistent determination results.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, which is consistent with its role as a shared utility invoked from many calling contexts.

Key Procedures and Functions

Three procedures are documented in the ETRM metadata:

• UPDATE_LINE_DET_ATTRIBS — Updates the determining attributes at the individual transaction line level back into ZX_LINES_DET_FACTORS. It handles line-scoped factors such as transaction business category, line intended use, product fiscal classification, product category, product type, user-defined fiscal classification, assessable value, tax classification code, and the display tax classification flag, along with a transaction line record and an OUT return status. It is used when only line-level defaults have changed.
• UPDATE_HEADER_DET_ATTRIBS — The procedure corresponding to the user's search term. It invokes the defaulting API to re-default tax determining attributes after the taxation country has changed, then updates ZX_LINES_DET_FACTORS with the refreshed values so that the user interface reflects the new results. Its inputs include the taxation country, document subtype, tax invoice date and number, the display tax classification flag, a transaction record, an IN OUT event class record, and an OUT return status. Because taxation country and invoice context affect header-level defaults, this procedure drives a cascade of re-defaulting that propagates to the stored line factors.
• LOCK_LINE_DET_FACTORS — Locks all lines of a given transaction within ZX_LINES_DET_FACTORS, providing concurrency control so that determination updates and UI reads do not collide during transaction processing.

Tables Accessed

The package's principal repository is ZX_LINES_DET_FACTORS, the ETRM table holding the tax determining attribute values per transaction line. All three procedures operate against this table: UPDATE_LINE_DET_ATTRIBS and UPDATE_HEADER_DET_ATTRIBS write refreshed values, while LOCK_LINE_DET_FACTORS acquires row locks for the lines of a transaction. The package also references PLITBLM, a standard Oracle Applications PL/SQL table-index-by table used for in-memory collections during bulk processing. Reference to these tables occurs through APPS synonyms, per standard EBS naming conventions.

Usage Notes

ZX_LINES_DET_FACTORS_PKG sits beneath the ZX_API_PUB layer, and the metadata records that it is referenced by two other packages — consistent with its role as an internal utility called by higher-level tax APIs rather than by end users directly. It is typically invoked when a user changes the taxation country or other header-level context on an invoice, causing the Tax Engine to re-default determining attributes; UPDATE_HEADER_DET_ATTRIBS performs that re-default and synchronizes the line factors for the UI. Line-level edits trigger UPDATE_LINE_DET_ATTRIBS. Because the procedures carry OUT x_return_status parameters, callers must check the returned status and handle exceptions. Custom code should invoke the public ZX_API_PUB entry points rather than this package directly, and any direct call must respect the transaction record and event class record structures defined in ZX_API_PUB.