Search Results okc_actions_pub




Overview
Explore in AI Chat

Overview

The APPS.OKC_ACTIONS_PUB package body is the public API layer for managing actions in the Oracle E-Business Suite Contract Lifecycle Management (CLM) module, delivered as part of the Oracle Contracts (OKC) application family. In Oracle EBS 12.1.1 and 12.2.2, the ETRM repository records this object as a VALID package body owned by the APPS schema, and classifies it with an API classification of PUB — denoting a published, externally callable interface rather than an internal private routine.

Its business purpose is to provide a programmatic, transaction-safe mechanism for creating, updating, validating, locking, and deleting contract actions and their associated action attributes. Actions represent the contractual clauses, deliverables, or obligations attached to a contract, and the public package shields calling applications from the underlying private implementation and from the bulk of contract API mechanics. The package is not referenced by any database object, consistent with its role as a top-consuming interface layer that other code calls into rather than being called by database triggers or views.

Key Procedures and Functions

The ETRM metadata documents 25 procedures/functions across the package. The principal entries are:

  • CREATE_ACTIONS — creates new action records on a contract, invoking validation and applying defaults through the underlying private package.
  • UPDATE_ACTIONS — modifies existing action records and their attribute values.
  • VALIDATE_ACTIONS — performs pre-write validation of action data without persisting changes, typically called before create or update to enforce business rules.
  • LOCK_ACTIONS — obtains a lock on action records to serialise concurrent modification.
  • DELETE_ACTIONS — removes actions from a contract.
  • CREATE_ACT_ATTS — creates action attribute records (the descriptive and flexible-value details attached to an action).
  • LOCK_ACT_ATTS — locks action attribute rows for update.
  • UPDATE_ACT_ATTS — updates existing action attribute values.
  • DELETE_ACT_ATTS — deletes action attribute rows.
  • VALIDATE_ACT_ATTS — validates action attribute data prior to persistence.
  • ADD_LANGUAGE — installs translated (MLS) language rows for action definitions, supporting multi-language contract content.

Each routine follows the standard Contracts API pattern of validate-then-process, surfaces errors via the FND_API messaging stack, and is invoked by the OKC_ACTIONS_PVT private layer for the actual DML.

Tables Accessed

The documented table references for this package (via APPS synonyms) list PLITBLM, the PL/SQL implementation table used by the PL/SQL compiler for intermediate code; this is a system dependency, not a functional data table. Functional DML against contract action and action attribute tables is performed indirectly through the private dependencies OKC_ACTIONS_PVT, OKC_ACN_PVT, OKC_AAE_PVT, and OKC_API. Additional dependencies include FND_API (API framework error handling), FND_PROFILE (profile option values), OKC_UTIL (utility helpers), and STANDARD.

Usage Notes

OKC_ACTIONS_PUB is typically invoked from Oracle Contracts forms and from custom extensions that must create or maintain contract actions without a user interface. Because it is classified PUB and is not referenced by any other database object, custom code should call this package directly rather than the private OKC_ACTIONS_PVT. Callers should invoke validation before create/update, respect the locking routines when concurrent changes are possible, and inspect the FND_API return status rather than relying on exceptions. Subscription to the standard EBS multi-language and profile-driven behaviour is automatic through the ADD_LANGUAGE routine and FND_PROFILE dependency respectively.