Results for “update_exchange_rate”

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

Overview

ZX_TRL_MANAGE_TAX_PKG is a private PL/SQL package in the Oracle E-Business Tax (EBTax) schema, owned by APPS and declared with AUTHID CURRENT_USER. Its responsibility is the lifecycle management of tax repository data for a given transaction, specifically the rows held in the ZX_LINES and ZX_LINES_SUMMARY tables that represent calculated tax lines and their summarized counterparts. In the Oracle EBS 12.1.1 and 12.2.2 architectures, this package acts as an internal service layer beneath the public E-Business Tax APIs: it performs the physical creation, modification, cancellation, purge, and deletion of tax lines once the tax determination and calculation engine has resolved the applicable taxes for an event class. The $Header attribute (120.24) indicates a long-maintained file with iterative fixes, and the presence of date-stamped revision comments from 2002 confirms its lineage through the original E-Business Tax release. The package is not intended for direct customer invocation; it is a supporting routine that other tax packages call to keep the tax repository consistent with the underlying transaction.

Key Procedures and Functions

The documented interface exposes twenty-two procedures. The central creation routines are CREATE_DETAIL_LINES, which inserts tax lines into the tax repository, and CREATE_SUMMARY_LINES_CRT_EVNT, which builds the corresponding summary rows. DELETE_DETAIL_LINES and DELETE_SUMMARY_LINES remove transaction records from ZX_LINES and ZX_LINES_SUMMARY respectively. Broader cleanup is handled by DELETE_TRANSACTION, CANCEL_TRANSACTION, and PURGE_TRANSACTION, which manage the removal or reversal of an entire tax transaction. Distribution-level maintenance is provided by CREATE_TAX_DISTRIBUTIONS, DELETE_LOOSE_TAX_DISTRIBUTIONS, DELETE_TAX_DISTRIBUTIONS, and DELETE_DIST_MARKED_FOR_DELETE. Marker and flag maintenance is performed by MARK_DETAIL_TAX_LINES_DELETE, UPDATE_FREEZE_FLAG, UPDATE_ITEM_DIST_CHANGED_FLAG, and UPDATE_EXIST_SUMMARY_LINE_ID. Financial attributes on existing lines are refreshed by UPDATE_TAXLINE_REC_NREC_AMT, UPDATE_GL_DATE, and UPDATE_EXCHANGE_RATE. DISCARD_TAX_ONLY_LINES removes tax-only lines, and RELEASE_DOCUMENT_TAX_HOLD lifts document-level tax holds during transaction processing.

Tables Accessed

The package reads and writes the core tax repository tables ZX_LINES, ZX_LINES_SUMMARY, ZX_LINES_SUMMARY_S, ZX_REC_NREC_DIST, and ZX_REC_NREC_DIST_S, together with the detail factor table ZX_LINES_DET_FACTORS. Temporary staging is performed through the global temporary tables ZX_DETAIL_TAX_LINES_GT, ZX_ITM_DISTRIBUTIONS_GT, ZX_REC_NREC_DIST_GT, ZX_TAX_DIST_ID_GT, and ZX_TRX_HEADERS_GT, which replaced the earlier PL/SQL table parameters. Event classification is resolved against ZX_EVNT_CLS_MAPPINGS. Payables integration tables AP_INVOICE_DISTRIBUTIONS_ALL and AP_SELF_ASSESSED_TAX_DIST_ALL are referenced for invoice and self-assessed tax distribution data. The PLITBLM table supports PL/SQL index-by-table handling. Two other packages reference this package, confirming its role as an internal dependency.

Usage Notes

ZX_TRL_MANAGE_TAX_PKG is invoked indirectly during E-Business Tax transaction processing, typically from the public tax APIs and from concurrent programs that calculate, adjust, or purge tax. Because it is a private package with an AUTHID CURRENT_USER declaration, custom code should not call it directly; developers requiring tax line maintenance should use the supported ZX_API_PUB entry points. The "tracefinancial license" search that surfaced this object reflects its grouping under E-Business Tax trace and financial license-related functionality rather than a distinct licensing module.