Search Results oks_interaction_hist_pub




Overview
Explore in AI Chat

Overview

The OKS_INTERACTION_HIST_PUB package is a public PL/SQL API within the Oracle E-Business Suite Service (OKS) module, owned by the APPS schema. It manages the persistence and lifecycle of service interaction history records, which capture the transactional narrative of customer engagements — calls, service requests, notes, and related communications associated with service contracts and covered items. In EBS 12.1.1 and 12.2.2, this package serves as the public entry point for interaction history maintenance, insulating callers from the private implementation logic housed in OKS_INTERACTION_HIST_PVT.

The package depends on the private package OKS_INTERACTION_HIST_PVT for its core business logic and on OKC_API for contract-related operations. Its status is recorded as VALID in the ETRM metadata, and it is classified as a PUB API, indicating it is intended for supported external invocation rather than internal-only use.

Key Procedures and Functions

The package exposes eighteen documented program units. The principal documented procedures and functions are:

  • INSERT_ROW — Creates a new interaction history record, populating the base table with the supplied attributes.
  • UPDATE_ROW — Modifies an existing interaction history record.
  • DELETE_ROW — Removes an interaction history record from the underlying table.
  • LOCK_ROW — Acquires a row-level lock on a specified record to prevent concurrent modification during a transaction.
  • VALIDATE_ROW — Performs attribute and referential validation prior to insert or update, enforcing business rules.
  • API_COPY — Duplicates an existing interaction history record, supporting reuse and template-style creation scenarios.
  • CHANGE_VERSION — Manages versioning of interaction history data, enabling controlled evolution of records across revisions.
  • QC — A quality-control handler, typically invoked to validate data integrity conditions for the entity.

These units follow the standard EBS PUB/PRIVATE pattern in which the public package delegates to OKS_INTERACTION_HIST_PVT. Parameter lists are intentionally not reproduced here; callers should consult the ETRM documentation or the package specification for exact signatures.

Tables Accessed

The ETRM metadata for this object lists no directly documented tables via APPS synonyms. In practice the package operates on the interaction history base table maintained by OKS_INTERACTION_HIST_PVT, with contract context supplied through OKC_API. Because table access is centralized in the private package, direct DML against the underlying table should be avoided in favor of this API.

Usage Notes

OKS_INTERACTION_HIST_PUB is typically invoked from Service module forms, concurrent programs, and custom extensions that create or maintain interaction history records. The metadata indicates the package is referenced by no other documented packages, meaning it is generally consumed by forms, reports, or bespoke code rather than by sibling APIs. Oracle recommends routing all interaction history DML through this public API to preserve validation, versioning, and quality-control behavior. When extending EBS, developers should call INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW in conjunction with VALIDATE_ROW to ensure data integrity. Direct table manipulation bypasses these safeguards and is not supported.