Search Results aso_core_contracts_pub




Overview
Explore in AI Chat

Overview

ASO_CORE_CONTRACTS_PUB is a public PL/SQL package in the APPS schema that serves as the core contract management API for the Oracle E-Business Suite Order Capture and Contracts (ASO) module. In the context of Oracle EBS 12.1.1 and 12.2.2, this package is the primary programmatic interface through which contract header records are created, modified, and communicated within the sales and quoting lifecycle. The ASO module underpins functionality shared by Oracle Quoting, iStore, and Order Management, where a "contract" refers to the agreement object that captures the commercial terms negotiated with a customer before an order is placed.

The package qualifies as a public API (PUB classification), meaning its procedures form a supported, externally callable interface rather than an internal-only utility. It is registered as VALID in the ETRM repository and depends on the standard Oracle Application Object Library API framework, FND_API, whose message-handling and exception conventions govern its error reporting. Its documented dependents are limited, with one other package referencing it directly.

Key Procedures and Functions

The ETRM metadata documents four public procedures and functions:

  • CREATE_CONTRACT — Creates a new contract header record. This is the primary entry point for programmatically originating a contract, populating the core header attributes and returning a contract identifier for subsequent operations.
  • UPDATE_CONTRACT — Modifies an existing contract. It applies changes to contract attributes previously established through CREATE_CONTRACT, maintaining referential integrity across dependent structures.
  • NOTIFY_CONTRACT_CHANGE — Raises or propagates notification of a contract change. This supports business events or workflow-driven communication so that downstream processes and subscribers are informed when a contract is altered.
  • CHECK_CUSTOMER_ACCOUNTS — Validates customer account information associated with a contract, ensuring that the account context supplied is consistent and eligible before a contract is created or updated.

Consistent with FND_API conventions, these procedures are expected to expose standard p_init_msg_list, x_return_status, and x_msg_count/x_msg_data parameters. The metadata does not document explicit parameter lists, and no further signatures should be inferred.

Tables Accessed

The ETRM excerpt does not enumerate the base tables accessed through APPS synonyms. Functionally, ASO_CORE_CONTRACTS_PUB operates against the ASO contract header and related ASO contract tables, together with the customer and account reference data required by CHECK_CUSTOMER_ACCOUNTS and the notification infrastructure used by NOTIFY_CONTRACT_CHANGE. Because all access is performed through APPS synonyms, the underlying base tables reside in the ASO and dependent schemas and remain subject to the module's standard business rules and validation logic.

Usage Notes

ASO_CORE_CONTRACTS_PUB is typically invoked indirectly through the Oracle Quoting and iStore user interfaces, where contract creation and modification are driven by form and JSP flows. The package IBE_QUOTE_SAVE_PVT, referenced in the ETRM dependencies, is an example of a module component that consumes this API during quote save processing. Customizations and integrations that need to create or amend contracts programmatically — whether from concurrent programs, workflow activities, or external interfaces — should call these public procedures rather than writing directly to the underlying tables, thereby preserving validation, notification, and API-standard error handling. Because it is classified as a public API and remains VALID in both 12.1.1 and 12.2.2, it is a stable integration point for the ASO contracts domain.