Search Results get_tax_exempt_flag

Overview

ASO_TAX_INT is the tax integration package within the Oracle E-Business Suite Order Capture / Oracle Quoting module (ASO). Its principal business function is to calculate tax for sales quotations at the header, line, and shipment levels and to persist the resulting tax detail records into the quoting data model. The package mediates between the Oracle Quoting application tables and the E-Business Tax engine (ZX) and Receivables tax APIs (ARP_TAX), assembling the tax attributes required to drive a tax determination and returning tax amounts, tax detail rows, and standard API status information to the caller.

The header comment identifies the source file as asoitaxs.pls (revision 120.7.12010000.1). The package declares a public record type, Tax_Control_Rec_Type, which carries a Tax_Level attribute defaulting to 'SHIPMENT' and an Update_DB flag, together with a global miss record used as a default for optional parameters. It also declares a PL/SQL table type based on RA_CUSTOMER_TRX_LINES%ROWTYPE for internal handling of tax lines.

Key Procedures and Functions

• CALCULATE_TAX — The core tax calculation entry point, overloaded to accept either a full set of quote header, line, shipment, and tax detail records, a quote header identifier with an optional quote line identifier, or a transaction-oriented set of identifiers (transaction, transaction line, charge line, and view name). Each variant returns the calculated tax amount, a tax detail table, and the standard return status, message count, and message data outputs.
• CALCULATE_TAX_WITH_GTT — A variant of tax calculation that operates against a global temporary table, used where intermediate tax results must be staged within a session.
• ASO_TAX_LINE — Processes tax at the individual tax line level, supporting the line-by-line population and maintenance of tax detail records.
• GET_TAX_DETAIL_ID — Retrieves the identifier of an existing tax detail record for a given quoting context.
• GET_TAX_CODE — Returns the tax code (tax regime, tax, and tax jurisdiction classification) applicable to the quoting context.
• GET_TAX_EXEMPT_FLAG — Returns the tax exemption flag indicating whether the customer or transaction is exempt from tax. This function is the object most commonly sought when integrators need to determine exemption status at the time a quote is priced.
• GET_TAX_EXEMPT_NUMBER — Returns the exemption certificate number associated with an exempt party.
• GET_TAX_EXEMPT_REASON_CODE — Returns the reason code explaining the basis for the exemption.
• GET_TAX_INVOICE_TO — Resolves the invoice-to party or site used for tax determination.
• GET_RA_TRX_TYPE_ID — Returns the Receivables transaction type identifier used to map the quote to the corresponding receivables transaction context for tax purposes.
• PRINT_TAX_INFO and PRINT_TAX_INFO_REC — Diagnostic and debug utilities that render tax information, either from a record or from a stored context, for troubleshooting and logging.

Tables Accessed

• ASO_QUOTE_HEADERS_ALL, ASO_SHIPMENTS, ASO_TAX_DETAILS, ASO_TAX_DETAILS_S — The quoting data model; tax details are read and written here, with shipments supplying the ship-to context that drives tax determination at the shipment level.
• HZ_PARTIES, HZ_PARTY_SITES, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES — Trading Community Architecture tables used to resolve party, site, and site-use information for the invoice-to and ship-to determinations.
• RA_CUST_TRX_TYPES, OE_TRANSACTION_TYPES, AR_SYSTEM_PARAMETERS — Provide the transaction type and Receivables system option context required to map a quote to the corresponding receivables transaction.
• FND_CURRENCIES — Supplies currency attributes needed for accurate tax amount computation.
• HR_ALL_ORGANIZATION_UNITS, PER_ALL_ASSIGNMENTS_F — Resolve the operating unit and organization context that governs which tax regime applies.
• ZX_DETAIL_TAX_LINES_GT — A global temporary table used by E-Business Tax to stage calculated tax lines during the calculation cycle.

Usage Notes

ASO_TAX_INT is an internal integration package rather than an end-user-facing API. It is invoked by the Oracle Quoting pricing and tax flow, by other ASO packages (the metadata reports three dependent packages), and by custom extensions that need to recompute or interrogate tax on a quotation. Calls are typically issued from Quote form logic and from concurrent or batch processes that recalculate tax across many quotes, as well as from custom PL/SQL where an integrator must obtain the exemption flag, exemption number, or tax code for a quote before pricing or order conversion. Because the package writes to ASO_TAX_DETAILS and its _S shadow table, callers should pass the Update_DB flag in Tax_Control_Rec_Type deliberately and should always inspect X_Return_Status, X_Msg_Count, and X_Msg_Data after each call. No public API version other than the documented P_Api_Version_Number parameter is exposed; direct calls should therefore be treated as version-sensitive, particularly between 12.1.1 and 12.2.2 where E-Business Tax configuration differs.