Search Results create_outcomes_args

Overview

OKC_OUTCOME_PVT is the private implementation package for the Outcomes feature within the Oracle E-Business Suite Contracts (OKC) module, part of the Enterprise Contracts / Contract Terms and Conditions (ETRM) architecture. Outcomes in Oracle Contracts represent the set of contractual agreements or results that can be selected when qualifying a contract, such as "Signed," "Verbal Agreement," or "Pending Approval." These outcomes drive business rules and determine which contract terms and conditions are applicable during contract authoring and qualification. The PVT (private) classification indicates that this package is not intended to be called directly by external consumers. Instead, it serves as the internal engine behind the public API OKC_OUTCOME_PUB, which delegates its operations to this package. By separating the public interface from the internal implementation, Oracle ensures that only validated, supported entry points are exposed while allowing internal logic to evolve independently.

Key Procedures and Functions

The package exposes 24 documented procedures and functions, structured around two related entities: Outcomes and Outcome Arguments. The primary outcome-level operations include CREATE_OUTCOME, which inserts a new outcome definition; UPDATE_OUTCOME, which modifies an existing outcome's attributes; DELETE_OUTCOME, which removes an outcome; VALIDATE_OUTCOME, which enforces business rules before persistence; and LOCK_OUTCOME, which retrieves and locks an outcome row for update. Parallel argument-level operations are provided through CREATE_OUT_ARG, UPDATE_OUT_ARG, DELETE_OUT_ARG, VALIDATE_OUT_ARG, and LOCK_OUT_ARG, which manage the argument rows associated with each outcome. Supporting procedures include ADD_LANGUAGE for loading translatable outcome text, and the argument-preparation routines CREATE_OUTCOMES_ARGS, UPDATE_OUTCOMES_ARGS, and VALIDATE_OUTCOMES_ARGS, which build and check the argument collections passed between the public and private layers. The remaining functions perform internal validation and data manipulation tasks that support these public operations.

Tables Accessed

The documented table reference for this package is the PL/SQL table type PLITBLM, accessed via its APPS synonym. PLITBLM is the standard Oracle Applications PL/SQL index-by table of VARCHAR2 used for processing multi-language and translated text. Its presence here confirms that OKC_OUTCOME_PVT handles the language-specific descriptions of outcomes and their arguments, enabling extended multilingual representation of outcome values and argument definitions within the ETRM data model.

Usage Notes

Because OKC_OUTCOME_PVT is classified as a private API, it should not be invoked directly from custom code, forms, or concurrent programs. All supported access is routed through the public package OKC_OUTCOME_PUB, which references this package for its implementation. Client extensions and integrations for handling outcomes must therefore call OKC_OUTCOME_PUB, relying on the thin public layer shown in the dependency listing. The package maintains internal dependencies on OKC_API, OKC_OAT_PVT, and OKC_OCE_PVT, indicating that outcome processing participates in broader contract qualification, terms, and search operations. Note that the metadata supplied is an ETRM extraction; the definitive list of parameters, exceptions, and constants for each procedure resides in the source definition of APPS.OKC_OUTCOME_PVT itself.