Search Results okc_split2_pav_pvt




Overview
Explore in AI Chat

Overview

OKC_SPLIT2_PAV_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Contracts (OKC) module, owned by the APPS schema. It supports the Contracts Core functionality surrounding price attribute values (PAV) and contract line processing. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the defining user, which is standard for ETRM private-layer packages that operate under the caller's security context.

The package encapsulates global message constants, exception handling, and helper logic drawn from OKC_API, including tokens for column names, parent/child tables, and standard error messages such as G_UNEXPECTED_ERROR, G_FOREIGN_KEY_ERROR, and G_UNIQUE_KEY_ERROR. The source header ($Header: OKCSPAVSPTS.pls 120.1) confirms it is a server-side PL/SQL specification file maintained under the OKC Contracts schema numbering conventions. As a private API, it is not intended for direct invocation by external integrations; it is called internally by other packages and by contract maintenance flows.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within this package:

  • MIGRATE — Handles migration of price attribute value data, typically associated with upgrade or data-conversion operations that move existing contract pricing attributes between schema versions or storage models.
  • INSERT_ROW_UPG — This is the routine directly matching the user search term "insert_row_upg". It performs insert operations during upgrade processing, inserting rows into the relevant price attribute value tables as part of an upgrade or backfill routine.
  • RESTORE_VERSION — Restores a prior version of price attribute value records, supporting Contracts versioning and history functionality.

These routines collectively support data movement and version management for price attribute values, rather than online transactional entry. No parameter lists are published in the metadata and should be confirmed by inspecting the package body in the target environment.

Tables Accessed

The package references the following tables through APPS synonyms:

  • OKC_K_LINES_B — The base table for contract lines; PAV records are tied to specific contract lines.
  • OKC_PRICE_ATT_VALUES — The primary table storing price attribute values associated with contract lines.
  • OKC_PRICE_ATT_VALUES_H — The history/version table corresponding to price attribute values, used by RESTORE_VERSION.
  • PLITBLM — A generic EBS table used for storing large text or message content, often referenced in upgrade and validation utilities.

Usage Notes

Because OKC_SPLIT2_PAV_PVT is classified as a private API, it is not part of the supported public interface for Oracle Contracts. It is typically invoked during upgrade scripts, patch drivers, or internal contract-line processing flows rather than from Oracle Forms directly. The INSERT_ROW_UPG routine in particular is associated with upgrade-time row insertion, and MIGRATE and RESTORE_VERSION support data conversion and version restoration respectively. Custom code should avoid calling this package directly; instead, use supported public OKC APIs. The metadata notes the package is referenced by one other package, confirming its role as an internal dependency. Always verify the package body version in the specific EBS release (12.1.1 or 12.2.2) before relying on behavior, as this file's header dates to 2010 but ships within later code lines.