Search Results pa_control_items_s

Overview

PA_CONTROL_ITEMS_PKG is an Oracle Applications (APPS) PL/SQL package body within the Projects (PA) module of Oracle E-Business Suite, validated for releases 12.1.1 and 12.2.2. It provides the core programmatic interface for maintaining project control items — the configuration records that define which project-level validation and control behaviors are enforced during project and transaction processing. Control items govern functions such as the enforcement of budgetary controls, transaction cross-charge validation, and other project setup rules that must be present before a project can be transacted against.

The package is classified as an "OTHER" API, meaning it is an internal application programming unit rather than a fully documented public API. It exposes a small, focused set of Data Manipulation Language (DML) procedures that encapsulate insert, update, and delete operations against the underlying control item tables, insulating calling forms and other packages from direct table manipulation and ensuring that the associated descriptive and translated records remain synchronized.

Key Procedures and Functions

The package body documents three procedures:

• INSERT_ROW — Creates a new control item record. It writes the primary row and the corresponding translated/descriptive row, returning the generated identifier for downstream use by the caller.
• UPDATE_ROW — Modifies an existing control item, applying changes to both the base record and its associated descriptive data so that translation and description columns remain consistent.
• DELETE_ROW — Removes a control item, including its dependent translated rows, from the control item schema.

These routines follow the standard EBS API convention of operating on paired base and "_S" (translated/description) tables within a single logical transaction, which is why the package depends on PA_CONTROL_ITEMS_S and the PA_CI_TYPES_V view. No parameter lists are documented in the ETRM metadata; parameter signatures should be confirmed by inspecting the package specification in the target instance.

Tables Accessed

The documented table dependencies are:

• PA_CONTROL_ITEMS — the primary store of control item definitions; the target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW.
• PA_CONTROL_ITEMS_S — the translated description table associated with each control item; maintained in lockstep with the base row.
• DUAL — referenced for utility queries and sequence or value derivation.

In addition, the package references the view PA_CI_TYPES_V and the utility packages PA_CONTROL_ITEMS_UTILS and PA_UTILS, and it relies on the FND_API and FND_GLOBAL foundation packages for standard API error handling and session context (user, responsibility, login) resolution. Validation of control item types is performed against PA_CI_TYPES_V rather than the underlying type table.

Usage Notes

PA_CONTROL_ITEMS_PKG is invoked primarily from the Projects setup forms and internal project-processing logic that manage control item configuration. It is referenced by four other packages in the Projects schema, indicating that control item maintenance is consumed indirectly by higher-level project and transaction validation routines rather than being called ad hoc. Custom code should not modify the PA_CONTROL_ITEMS tables directly; instead, it should invoke the INSERT_ROW, UPDATE_ROW, and DELETE_ROW procedures so that translated rows, FND_GLOBAL context, and FND_API error handling are applied consistently. Because the package is not referenced by any database object, callers must supply their own sequencing and commit strategy, respecting the standard EBS practice of committing only after all procedure calls in a logical unit of work have succeeded.