Search Results ra_rec_type

Overview

OKS_TAX_UTIL_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Service Contracts (OKS) and Contracts Core (OKC) schema, owned by APPS and declared with AUTHID CURRENT_USER. Its business purpose is to centralize tax-related utility logic used across the service contracts and contracts authoring modules. The package encapsulates helper routines that resolve tax determination inputs—customer transaction types, legal entities, exemption status, and currency context—and that support controlled updates to tax-related setup data through the various manager APIs. It also contains a dedicated tax migration routine, which is the entry point associated with the "tax_migration" search term. Because the package references message constants and error tokens from OKC_API, it participates in the shared Contracts error-handling framework: it raises G_EXCEPTION_HALT_VALIDATION, G_EXCEPTION_ROLLBACK, and G_ERROR, and emits predefined tokens such as G_REQUIRED_VALUE, G_INVALID_VALUE, and G_NO_TRX_TYPE to alert callers to validation failures. A record type, RA_REC_TYPE, carries header and line identifiers together with TAX_EXEMPT_FLAG and TAX_EXEMPT_REASON, indicating that exemption handling is a core responsibility of the package.

Key Procedures and Functions

The documented interface exposes nine procedures and functions, whose names indicate their respective roles:

• TAX_MIGRATION — The migration driver that processes tax data for legacy or pre-existing contract records. This is the routine most closely associated with the tax_migration use case and is typically executed during release upgrades or data-conversion waves.
• UPDATE_TAX_BMGR / UPDATE_TAX_HMGR / UPDATE_TAX_BWKR / UPDATE_TAX_HWKR — A quad of update programs distinguished by manager and worker suffix, providing tax updates through manager-level (MGR) and worker-level (WKR) code paths, with variants likely corresponding to header-level (H) versus line or blanket-level (B) processing.
• GET_CUST_TRX_TYPE_ID — Resolves the customer transaction type identifier required for tax determination and for creating related AR transactions.
• GET_LEGAL_ENTITY_ID — Resolves the legal entity identifier, which drives tax jurisdiction and reporting party rules.
• THAT — An internal utility referenced in the package body, associated with the record-level structures used for tax processing.

Tables Accessed

The package reads and writes against the following APPS synonyms. Customer and site data—HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES, HZ_PARTIES, and HZ_LOCATIONS—supply ship-to, bill-to, and party context for tax determination. Contract headers and lines—OKC_K_HEADERS_ALL_B, OKC_K_LINES_B, OKS_K_HEADERS_B, OKS_K_HEADERS_BH, and OKC_K_ITEMS—are the primary records whose tax attributes are updated or migrated. AR_SYSTEM_PARAMETERS_ALL provides Receivables system options needed for transaction type validation and tax setup consistency. FND_CURRENCIES supplies currency information for tax amounts and exchange context. HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL resolve legal entity and organization names, including translated descriptions. Together these tables support the exemption record structure (RA_REC_TYPE) and the resolution logic in GET_CUST_TRX_TYPE_ID and GET_LEGAL_ENTITY_ID.

Usage Notes

Because the package is classified PVT and is referenced by nine other packages, it is not intended for direct customer invocation; it is called by the public Service Contracts and Contracts APIs and by concurrent programs that perform tax updates and migrations. The TAX_MIGRATION routine is normally driven by upgrade or data-fix scripts rather than by end-user forms. Administrators and developers troubleshooting contract tax issues typically observe this package indirectly—through errors surfaced from OKS_TAX_UTIL_PVT tokens—while custom code that requires tax utility behavior should call the supported public APIs rather than this private utility.