Search Results pa_action_set_utils




Overview
Explore in AI Chat

Overview

PA_ACTION_SET_UTILS is a utility package in the Oracle EBS Projects (PA) module, owned by the APPS schema and holding a VALID status in both release 12.1.1 and 12.2.2. Its role is to centralize shared access and validation logic for the Action Sets feature, which allows Project Management to define configurable bundles of automated actions that fire against projects, tasks, and related entities. Rather than duplicating queries and validation rules across the Action Set maintenance forms and the Action Set processing engine, this package exposes a stable set of helper functions that callers use to retrieve header, line, and condition data, to test business rules, and to surface error or informational messages.

The package is classified as OTHER in the ETRM documentation, meaning it is an internal support utility rather than a published, standalone public API. It is consumed by twelve other database objects, most notably PA_ACTION_SETS_PVT, which holds the primary create/update/delete logic, while PA_ACTION_SET_UTILS itself is not referenced by any external database object. This confirms its position as a lower-level service layer used by the Action Set business logic.

Key Procedures and Functions

The ETRM metadata documents fourteen procedures and functions:

Tables Accessed

  • PA_ACTION_SETS — Stores Action Set definitions; read to resolve IDs and header details.
  • PA_ACTION_SET_LINES — Stores the individual action lines; read to return line collections and existence checks.
  • PA_ACTION_SET_LINE_AUD — Holds audit records for lines; read by GET_ACTIVE_AUDIT_LINES and DO_AUDIT_LINES_EXIST.
  • PA_ACTION_SET_LINE_COND — Stores conditional logic applied to lines; read by GET_ACTION_LINE_CONDITIONS.
  • PA_ACTION_SET_TYPES — Stores Action Set type definitions; used for name-uniqueness validation.
  • PLITBLM — System table used in list-processing operations.

The package also depends on PA_ACTION_SETS_PVT, FND_API, PA_DEBUG, PA_UTILS, and the PL/SQL table types PA_NUM_TBL_TYPE and PA_VARCHAR2_2000_TBL_TYPE, indicating it uses standard FND error-handling and debug conventions.

Usage Notes

PA_ACTION_SET_UTILS is invoked indirectly through the Action Set maintenance forms and the Action Set processing engine rather than being called directly by end users. Developers writing extensions or custom concurrent programs that manipulate Action Sets should preferably call PA_ACTION_SETS_PVT for mainline operations and use PA_ACTION_SET_UTILS only for the read and validation services it exposes. Because the package depends on FND_API and PA_DEBUG, its routines participate in the standard EBS message stack and debug logging, so callers should initialize the FND message stack before invocation and check the returned status and message outputs. Debug output can be enabled through the standard PA debug facilities.