Search Results okc_acn_pvt




Overview
Explore in AI Chat

Overview

OKC_ACN_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Oracle Contracts (OKC), part of the Enterprise Contracts / Service Contracts (formerly Telecommunications) module family. The "PVT" classification indicates a private implementation layer: it encapsulates the low-level data manipulation logic behind the public actions API, OKC_ACTIONS, which manages the definition and lifecycle of contract action types. Contract actions represent the configurable activities or behaviors attached to a contract (for example, notifications, renewals, or approval-related tasks), and this package provides the internal machinery for creating, translating, updating, validating, locking, and versioning that reference data.

In ETRM 12.2.2 the package is documented as VALID and exposes 14 procedures and functions. Because it is not referenced by any other database object beyond the OKC layer, it is intended to be invoked exclusively through the public OKC_ACTIONS API or by sibling packages, not directly by customer code. In Oracle EBS 12.1.1 the structure and role are substantially the same; differences are confined to minor internal changes rather than functional scope.

Key Procedures and Functions

  • QC — Quality-control or consistency helper invoked internally by the API to confirm that prerequisite conditions are met before DML is permitted.
  • CHANGE_VERSION — Updates the version/attribute tracking information for an action record, supporting the multi-language and multi-versioned nature of the OKC_ACTIONS_TL table.
  • API_COPY — Copies an existing action definition (base row plus translations) so a new action can be created from an existing template.
  • ADD_LANGUAGE — Inserts translated rows into OKC_ACTIONS_TL for a language not yet defined, maintaining the seeded/maintained language set.
  • INSERT_ROW — Performs the base-table insert into OKC_ACTIONS_B and the associated translation rows.
  • LOCK_ROW — Acquires a row-level lock on the target action record to serialize concurrent updates.
  • UPDATE_ROW — Applies modifications to the base and translation tables.
  • DELETE_ROW — Removes the action definition and its translations, subject to validation.
  • VALIDATE_ROW — Enforces business rules such as uniqueness of action names and mandatory attribute checks before commits.

Tables Accessed

  • OKC_ACTIONS_B — Base table holding language-independent action attributes; the primary target of INSERT_ROW, UPDATE_ROW, DELETE_ROW and LOCK_ROW.
  • OKC_ACTIONS_TL — Translation table storing language-specific names and descriptions; read/written by ADD_LANGUAGE and the translation portions of the DML routines.
  • OKC_ACTIONS_S1 — Public synonym used for sequence/identifier generation for new action rows.
  • FND_APPLICATION, FND_LANGUAGES, FND_GLOBAL, FND_PROFILE — Foundation lookups supplying application context, the installed language list, session identity (user, responsibility, login), and profile option values.
  • DUAL and PLITBLM — Utility objects used for singleton selects and PL/SQL table manipulation.

Usage Notes

OKC_ACN_PVT is normally invoked indirectly. The public package OKC_ACTIONS delegates its create, update, delete, and copy operations to this private body, and it is also called from sibling packages within the OKC API family (it is referenced by four other packages and by OKC_API, OKC_UTIL, and OKC_P_UTIL). Standard EBS setup forms and the Contracts administration UI for action types therefore reach this code through the API layer; direct calls from customer extensions are unsupported. Because the package relies on FND_GLOBAL and FND_PROFILE, callers must operate within an initialized EBS session with valid application context. Any enhancements should be made to the public OKC_ACTIONS API or via personalization rather than by modifying this private implementation.