Search Results create_act_atts

Overview

OKC_ACTIONS_PVT is a private PL/SQL API package in the Oracle E-Business Suite Contracts (OKC) module, owned by the APPS schema and classified as a PVT (private) API. It provides the internal programmatic interface for managing contract actions — the follow-up activities, tasks, and obligations that are attached to contracts and tracked through their lifecycle. Contract actions underpin functionality such as renewal notifications, termination activities, deliverable tracking, and clause-driven task generation within the Contracts application.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user, resolved against APPS synonyms. The header defines several global constants, including G_PKG_NAME, G_APP_NAME (derived from OKC_API), and standard error tokens such as G_UNEXPECTED_ERROR, SQLerrm, and SQLcode. A global exception, G_EXCEPTION_HALT_VALIDATION, allows validation routines to terminate processing early when an unrecoverable condition is detected. The package also declares subtypes aliasing the record and table structures from OKC_ACN_PVT (action records) and OKC_AAE_PVT (action attribute records), enabling typed bulk operations.

Key Procedures and Functions

The package exposes 25 documented procedures and functions organized around the action header and its associated attributes:

• ADD_LANGUAGE — Calls the individual add_language routines for the action and action attribute entities, inserting translated (NLS) rows for each.
• CREATE_ACTIONS — Object-type creation routine that accepts an action record plus an action-attribute table, returning the created structures. It invokes the record-level create first, then the attribute table version, so headers and attributes are committed together.
• UPDATE_ACTIONS — Modifies existing contract action records, including attribute changes, applying the same multi-level API pattern as creation.
• VALIDATE_ACTIONS — Performs business-rule validation on action data prior to insert or update, raising G_EXCEPTION_HALT_VALIDATION when validation must be aborted.
• LOCK_ACTIONS — Obtains a row-level lock on the target action to serialize concurrent modifications.
• DELETE_ACTIONS — Removes action records and their dependent data.
• CREATE_ACT_ATTS, UPDATE_ACT_ATTS, DELETE_ACT_ATTS, LOCK_ACT_ATTS, VALIDATE_ACT_ATTS — The corresponding CRUD, locking, and validation operations for the action attribute child entity, maintaining the parent-child integrity between an action and its attribute rows.

Each public routine follows the standard EBS API signature convention, returning x_return_status, x_msg_count, and x_msg_data so callers can inspect success, expected, or unexpected error states.

Tables Accessed

The package operates against OKC_ACTIONS_B (accessed via an APPS synonym), which stores the base action records, and PLITBLM, an EBS-standard PL/SQL index-by table used for message and error handling within the API framework. Attribute data is handled through the OKC_AAE_PVT structures, whose underlying tables are managed through the corresponding private API package.

Usage Notes

As a private package, OKC_ACTIONS_PVT is not intended for direct invocation by external custom code. It is referenced by one other package in the documented dependency graph and is normally called indirectly through the public Contracts API layer. Typical invocation scenarios include the Contracts forms when users create, update, or delete actions on a contract, concurrent programs that process contract deliverables or generate renewal and termination actions, and internal OKC processing that synchronizes clause-driven action rows. Developers working with contract actions should use the public OKC API surface; direct calls to OKC_ACTIONS_PVT bypass supported entry points and risk validation and locking inconsistencies.