Search Results arp_tax

Overview

ASO_QUOTE_MISC_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Order Management / Advanced Pricing schema (APPS). It is a member of the ASO module family that supports Oracle Sales Quotations, and its name — "Misc" (miscellaneous) plus the "PVT" suffix — signals that it contains internal utility logic rather than a public, callable business API. The package is not intended to be invoked directly by external integrations; it supplies supporting diagnostic functionality used within the quotation pricing and tax determination flow.

In the ETRM 12.1.1 / 12.2.2 metadata, ASO_QUOTE_MISC_PVT is classified as a PVT API and exposes exactly one documented procedure: DEBUG_TAX_INFO_NOTIFICATION. Its header comment (asovqmib.pls 120.2 2005/07/20) places the last significant revision in the 11.5.x era, after which it has been carried forward largely unchanged into the 12.1.1 and 12.2.2 releases. Because of this, the package reflects older profile-driven and USERENV-based coding patterns that were subsequently reworked for Multi-Org Access Control (MOAC).

Key Procedures and Functions

• DEBUG_TAX_INFO_NOTIFICATION — the sole documented procedure. Its purpose is to assemble and, when enabled, email diagnostic information about tax determination for a quotation. It accepts a quote header record, a shipment record, and a reason string, builds a text buffer describing the tax context, and sends the output to the address configured in the ASO_DIAG_EMAIL_ADDRESS profile option. Email delivery is gated by the ASO_ENABLE_DEBUG_EMAIL profile option. Internally it uses a local Writeln helper to append lines to a VARCHAR2 buffer and, when ASO_DEBUG_PUB.G_Debug_Flag is 'Y', writes trace messages through ASO_DEBUG_PUB.ADD.

The procedure illustrates the two profile options that control tax debug output: ASO_DIAG_EMAIL_ADDRESS (recipient) and ASO_ENABLE_DEBUG_EMAIL (master on/off switch). It also contains commented-out blocks that formerly derived the operating unit from USERENV('CLIENT_INFO'); these were superseded by reading org_id directly from the incoming quote header record, the change annotated "New Code Yogeshwar (MOAC)".

Tables Accessed

No base tables are documented as referenced through APPS synonyms for this package. The procedure operates on the record structures passed in from ASO_QUOTE_PUB (QTE_HEADER_REC_TYPE and SHIPMENT_REC_TYPE) and on profile values obtained via FND_PROFILE.VALUE. Its only data retrieval is that profile lookup and the org_id carried on the header record, so no direct SQL against quotation, pricing, or tax tables occurs. This is consistent with its diagnostic role, which reports on data already assembled by the caller rather than querying it.

Usage Notes

ASO_QUOTE_MISC_PVT is referenced internally within the ASO quotation stack rather than from Oracle Forms, concurrent programs, or external custom code; the ETRM metadata reports that no other packages reference it and that it references none. It is invoked during quotation pricing/tax processing when diagnostic tracing is required, and its output depends entirely on the debug profile settings being enabled. Because it is a PVT package, its interface is not guaranteed across releases, and customizations should not bind to it. For support and troubleshooting of quotation tax issues, administrators toggle the ASO_ENABLE_DEBUG_EMAIL profile to 'Y' and set ASO_DIAG_EMAIL_ADDRESS, reproduce the pricing transaction, and inspect the emailed output.