Search Results process_order_line

Overview

JAI_CREDIT_CHECK_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It belongs to the Oracle Financials for India (JAI) product family and supports credit checking and tax verification for order-to-cash transactions managed through Oracle Order Management. The package applies India-specific taxation and credit validation logic that is not delivered by the standard Order Management credit check facility, verifying tax amounts calculated on sales order lines and RMA lines, comparing them against expected values, and processing credit-related outcomes for orders and lines.

The package header carries the revision marker $Header: jai_credit_check.pls 120.4 2011/09/23 03:14:24 qioliu noship $, indicating a production file version maintained under the Oracle India localization code line. Within the ETRM repository the package is classified as API classification OTHER, and it is referenced by one other package.

Key Procedures and Functions

The documented interface exposes four functions and three procedures. All are described below by purpose only.

• check_credit_setup — A function that validates whether credit checking is correctly configured for a given customer account and site use. It returns a VARCHAR2 status value that callers use to determine whether credit checking may proceed.
• check_tax_amount_difference — A function that evaluates a sales order for discrepancies between the tax amount stored on the order and the tax amount expected for it. It returns a VARCHAR2 result indicating the outcome of the comparison.
• get_jai_tax_amount — A function that derives the India-localized tax amount for a specified order line and returns it as a NUMBER.
• process_tax_credit_check — A concurrent-program style procedure accepting the standard concurrent manager OUT parameters (errbuf, retcode) along with optional customer, order type, and header ID range parameters. It drives tax credit checking across a set of sales orders.
• process_order_line — The procedure located by the user's search term. It processes credit checking for a single order line identified by header ID and line ID, together with the line type, and returns a return code and return message through OUT parameters to communicate the result.
• process_trading_tax_amount — A procedure invoked in the trading and receiving flow. It reconciles tax amounts for a sales order line in relation to a receipt and a referenced line, with a subinventory parameter providing inventory context.

Tables Accessed

The package reaches its data through APPS synonyms, spanning Oracle Receivables customer configuration, Order Management transaction tables, and the JAI localization tax tables.

• Customer and site configuration: HZ_CUSTOMER_PROFILES, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL supply the customer account, site, and profile information required by check_credit_setup.
• Order Management tables: OE_ORDER_HEADERS and OE_ORDER_LINES provide the order and line records under evaluation; OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJUSTMENTS_S supply pricing adjustment lines from which line amounts are derived; WSH_DELIVERY_DETAILS links order lines to shipping and delivery context used in the trading tax calculation.
• JAI localization tables: JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES hold India-specific sales order line and tax detail; JAI_OM_OE_RMA_LINES and JAI_OM_OE_RMA_TAXES hold the equivalent detail for returns; JAI_CMN_TAXES_ALL and JAI_CMN_MATCH_TAXES provide the common tax definitions and matching rules against which calculated amounts are compared.

Usage Notes

JAI_CREDIT_CHECK_PKG is intended for invocation from India-localized Order Management processing rather than from end-user forms directly. process_order_line is typically called for each order line during order entry or order import validation, so that tax and credit results are returned to the calling process through its return code and return message parameters. process_tax_credit_check follows the concurrent program contract, taking errbuf and retcode, and is therefore suitable for registration as a concurrent program that scans a range of order headers for a customer or order type. process_trading_tax_amount is invoked from the trading and receiving flows, such as receipt processing, where a sales order line, receipt, and referenced line must be reconciled with respect to tax. Because the package is declared AUTHID CURRENT_USER, privileges are resolved against the invoking schema, and custom code calling the package must ensure that the necessary OE, HZ, WSH, and JAI objects are accessible. The functions check_credit_setup, check_tax_amount_difference, and get_jai_tax_amount are reusable validation utilities suitable for direct calls from custom extensions that need to test credit configuration or retrieve India tax amounts for a line.