Search Results get_rec

Overview

OKC_SPLIT1_PAV_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Contracts (OKC) module, specifically within the Contract Terms and Conditions (T&C) framework. Its name reflects its role: it supports the "Split1" contract terms layout and operates on Price Attribute Values (PAV). The package is defined with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner, which is standard practice for private helper packages invoked from the public API layer.

The package header declares a comprehensive set of global message constants (G_FND_APP, G_FORM_UNABLE_TO_RESERVE_REC, G_FORM_RECORD_DELETED, G_FORM_RECORD_CHANGED, G_RECORD_LOGICALLY_DELETED, G_REQUIRED_VALUE, G_INVALID_VALUE, and the token constants G_COL_NAME_TOKEN, G_PARENT_TABLE_TOKEN, G_CHILD_TABLE_TOKEN), all initialized from OKC_API. It also declares dedicated error constants for unexpected errors, foreign key violations, and unique key violations (G_UNEXPECTED_ERROR, G_FOREIGN_KEY_ERROR, G_UNIQUE_KEY_ERROR), plus SQL error tokens (G_SQLERRM_TOKEN, G_SQLCODE_TOKEN). A global exception G_EXCEPTION_HALT_VALIDATION is declared to allow validation logic to abort processing cleanly.

These declarations indicate that the package is a validation-oriented private utility. It uses the standard OKC message framework to raise consistent, translatable errors when price attribute value data fails integrity checks during contract authoring. Its private classification means it is not intended for direct customer invocation; it is called from the public API layer and from the form-level handlers that manage contract terms.

Key Procedures and Functions

The documented interface exposes two entry points:

• GET_REC — the retrieval routine. Based on the ETRM search term and the package's purpose, GET_REC fetches a single price attribute value record, presumably keyed by contract line or price attribute identifiers, and returns it to the calling layer. It is the read counterpart to the package's validation duties.
• NULL_OUT_DEFAULTS — a utility used to clear or null out default attribute values before validation or insert processing, ensuring that defaults do not mask user-entered or derived data.

No parameter lists are published in the ETRM metadata, and none should be assumed. Both procedures are private helper routines invoked through the public OKC API, and callers should rely on the public API rather than the PVT layer directly.

Tables Accessed

The package references a single documented table via an APPS synonym: OKC_PRICE_ATT_VALUES. This table stores the price attribute values associated with contract terms and lines. GET_REC reads from it to populate a record for display or validation; NULL_OUT_DEFAULTS and the surrounding validation logic ensure that default values held in this table are cleared appropriately before processing. The FK and unique key error constants in the header indicate that writes to this table are validated for referential and uniqueness constraints.

Usage Notes

OKC_SPLIT1_PAV_PVT is invoked in the context of contract terms authoring and validation, typically triggered from the Contracts form (OKC) when price attribute values are entered or maintained, and from the public OKC API layer that wraps the Split1 terms behavior. It is referenced by one other package, confirming its role as a subordinate helper rather than a standalone interface. In Oracle EBS 12.1.1 and 12.2.2 it should not be called directly from custom code; developers extending contract terms functionality should route through the supported public OKC APIs. The GET_REC routine is of particular interest to integrators who need to read price attribute values programmatically, but such reads should be performed through the public API equivalent.