Search Results get_process_for_appl_flg

Overview

ZX_TDS_CALC_SERVICES_PUB_PKG is the public calculation services package within the Oracle E-Business Suite Tax (EBS Tax / ETRM) module. Its primary business function is to serve as the central API layer for tax determination, tax line calculation, and tax data maintenance across the EBS Tax engine. The package encapsulates the procedural logic required to evaluate tax regimes, calculate taxes on transactions, apply overrides to both detail and summary tax lines, validate documents for tax processing, and reverse previously calculated tax. In Oracle EBS 12.1.1 and 12.2.2, this package is declared with AUTHID CURRENT_USER and is classified as an API, meaning it is intended to be called programmatically by other application modules, concurrent programs, and extensions rather than directly by an end user. Because the package is referenced by 22 other packages, it functions as a foundational service layer that other Tax components depend upon. The internal record types defined in the specification—transaction_rec_type and event_class_rec_type—demonstrate that the package operates on structured transaction and event-class data, driving party, jurisdiction, rounding, and party-source attributes used throughout tax calculation.

Key Procedures and Functions

The package exposes 17 documented procedures and functions. The calculation-oriented routines include CALCULATE_TAX, which drives tax computation for standard transactions, and CALCULATE_TAX_FOR_IMPORT, which handles the imported transaction path. TAX_LINE_DETERMINATION establishes tax lines for a transaction, while GET_TAX_REGIMES retrieves the tax regimes applicable to a given transaction context. Override handling is provided by OVERRIDE_DETAIL_TAX_LINES and OVERRIDE_SUMMARY_TAX_LINES, which allow manual adjustment of calculated detail and summary tax lines respectively. PRORATE_IMPORTED_SUM_TAX_LINES distributes imported summary tax amounts, and ROUND_TAX_CURR_XML_INV performs currency rounding operations for tax amounts. Document lifecycle support is delivered by VALIDATE_DOCUMENT_FOR_TAX, which checks a document for tax-processing eligibility, and REVERSE_DOCUMENT, which reverses tax on a previously processed document. Utility routines include DUMP_DETAIL_TAX_LINES_INTO_GT, which moves detail tax line data into a global temporary structure, UPDATE_EXCHANGE_RATE, which refreshes exchange rate information, INITIALIZE, which sets up package state, GET_PROCESS_FOR_APPL_FLG, which resolves a process flag for an application, and GET_REP_CODE_ID, the routine users most commonly search for. GET_REP_CODE_ID resolves the reporting code identifier, linking reporting code definitions used in tax reporting and recovery.

Tables Accessed

The package reads and writes a defined set of Tax and reference tables through APPS synonyms. ZX_LINES, ZX_LINES_SUMMARY, ZX_DETAIL_TAX_LINES_GT, and ZX_PROCESS_RESULTS hold calculated tax lines, summary results, temporary detail lines, and process outcomes. Configuration and definition data come from ZX_REGIMES_B, ZX_TAXES_B, ZX_JURISDICTIONS_B, ZX_CONDITIONS, ZX_CONDITION_GROUPS_B, ZX_DET_FACTOR_TEMPL_B, and ZX_REPORTING_CODES_B, supporting regime lookup, tax and jurisdiction identification, condition evaluation, and reporting code resolution. ZX_PARTY_TAX_PROFILE supplies party-level tax profile attributes, and ZX_EVNT_CLS_MAPPINGS maps event classes used during determination. HZ_LOCATIONS provides location data for party and address context, while FND_CURRENCIES supports exchange rate and currency handling used in rounding and rate updates.

Usage Notes

ZX_TDS_CALC_SERVICES_PUB_PKG is typically invoked by the EBS Tax engine, Tax Simulator, and related calculation flows rather than directly by end users. Forms such as tax calculation and tax line review screens, concurrent programs that calculate or validate tax for batches of transactions, and custom PL/SQL extensions that need to invoke standard tax calculation or override behavior all call into this package's public procedures. Because it is a PUBLIC API with AUTHID CURRENT_USER, callers must ensure appropriate grants and execution privileges. Custom code should call the documented public routines rather than internal logic, and should account for package state initialized by INITIALIZE. The heavy dependency from 22 other packages means changes or upgrades affecting this package can ripple across the Tax application, so it should be treated as a stable integration point in Oracle EBS 12.1.1 and 12.2.2 environments.