Search Results aso_contract_terms_int




Overview
Explore in AI Chat

Overview

ASO_CONTRACT_TERMS_INT is an Oracle Applications (APPS) PL/SQL package belonging to the Oracle Order Capture / Oracle Quoting product family. Its name reflects its role as an integration-layer package that bridges Oracle Quoting (ASO schema) with the contract terms engine (OKC schema). The package exposes the contract terms utility infrastructure of Oracle Contracts (OKC_TERMS_UTIL_GRP) so that quote-driven documents—quotes, quote lines, and their associated articles—can resolve and validate the variable values that appear inside standard and non-standard contract terms text. The header comment in the source dates the package to 2002, with the last recorded revision in 2005 (asoiktcs.pls version 120.1). In both Oracle EBS 12.1.1 and 12.2.2 the file is owned by APPS and classified as a standard "OTHER" API rather than a public, supported interface. It is best understood as an internal integration utility that keeps quotation terms synchronized with the shared OKC terms architecture.

Key Procedures and Functions

The documented package metadata exposes three callable units:

  • GET_ARTICLE_VARIABLE_VALUES — a procedure that returns the system variable values applicable to a document-level article. It accepts an API version, the standard initialization flag, the standard return status/message out parameters, a document identifier, and a system variable value table passed in and out. It is used when Quoting needs to substitute or display the runtime values of variables embedded in article text attached to a whole document.
  • GET_LINE_VARIABLE_VALUES — a procedure that resolves variable values at the document line level. It takes the API version, initialization flag, return status/message outputs, a document identifier, an input system variable value table, and returns an item detail table containing the per-line variable values. This supports articles and terms attached to individual quote lines rather than to the header.
  • OK_TO_COMMIT — a function returning a VARCHAR2 result indicating whether the document's terms may be committed. It accepts the API version, initialization flag, return status/message outputs, a document identifier, a document type defaulting to 'QUOTE', and a validation string. It acts as the contract terms gatekeeper before a quote is saved or submitted.

All three units follow the FND_API conventions: p_api_version is mandatory, p_init_msg_list defaults to fnd_api.g_false, and return status, message count, and message data are always returned. No additional procedures are documented beyond these three.

Tables Accessed

The package reads and writes data through APPS synonyms over the following tables: ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL (the quote header and line records whose articles and terms are being evaluated), ASO_PAYMENTS and ASO_SHIPMENTS (payment and shipment terms that feed variable resolution), ASO_QUOTE_STATUSES_B (the status of the quote, relevant to the commit decision in OK_TO_COMMIT), and the inventory tables MTL_SYSTEM_ITEMS_B, MTL_ITEM_CATEGORIES, and MTL_DEFAULT_CATEGORY_SETS, which supply item attributes and category values used as variable values. PLITBLM is referenced as a PL/SQL table storage construct used within the variable handling logic. These accesses reflect the package's purpose: gathering quote, item, and category context so that contract terms variables can be populated and validated.

Usage Notes

ASO_CONTRACT_TERMS_INT is an internal integration package. It is not intended for direct invocation by customers, and, as an "OTHER" classification API, it carries no supported public interface commitment. It is invoked indirectly by Oracle Quoting forms and business logic whenever terms and conditions text is rendered or a quote is validated and saved, and it is also referenced by one other package within the application. Because its source uses obsolete NOCOPY file.sql.39 directives, it should be treated as legacy code: customizations should call the supported OKC terms utilities rather than this ASO wrapper. DBAs and developers encountering ASO_CONTRACT_TERMS_INT during tracing or error analysis should recognize it as the Quoting-to-Contracts terms bridge active in both 12.1.1 and 12.2.2.