Search Results pa_proj_stat_actset




Overview
Explore in AI Chat

Overview

PA_PROJ_STAT_ACTSET is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. In Oracle EBS 12.1.1 and 12.2.2, it implements the business logic supporting project status action sets within Oracle Projects. Action sets define ordered sequences of actions that the application performs against a project based on conditions evaluated against project status, project dates, and related project attributes. The package encapsulates the validation and execution engine that determines whether an action is permitted, which action set lines qualify for execution, and how selected actions are applied to one or more projects.

Functionally, the package acts as the runtime controller for the Project Status Action Sets feature. It coordinates validation of action set definitions, evaluation of line-level conditions, enforcement of action type rules, and the actual invocation of actions such as status changes. Because it is a private implementation package, it is not itself referenced by other database objects; instead it calls into public and private sibling packages such as PA_ACTION_SETS_PUB, PA_ACTION_SETS_PVT, PA_ACTION_SET_UTILS, PA_PROJECT_UTILS, and PA_PROJECT_DATES_UTILS, and it uses the FND_API and FND_MSG_PUB messaging framework for standardized error handling.

Key Procedures and Functions

  • PROCESS_ACTION_SET — Drives the overall processing of an action set against a project, orchestrating line evaluation and action execution.
  • PERFORM_ACTION_SET_LINE — Executes the individual action defined on a single action set line.
  • VALIDATE_ACTION_SET_LINE — Validates the definition of a specific action set line, including associated conditions.
  • VALIDATE_ACTION_SET — Validates the action set as a whole before processing or maintenance operations.
  • VALIDATE_ACTION_TYPE_CODE — Confirms that an action type code is recognized and permitted by the action set framework.
  • ACTION_ALLOWED_FOR_STATUS — Determines whether a given action is permitted for the current project status.
  • PROJECT_DATES_VALID — Evaluates whether project date attributes satisfy the requirements for an action.
  • OK_TO_PERFORM_ACTION — Performs the consolidated eligibility check that gates whether an action may proceed.
  • PERFORM_SELECTED_ACTION — Executes a single action identified as applicable to the project.
  • COPY_ACTION_SETS — Supports duplication of action set definitions, including their constituent lines.
  • IS_ACTION_REPEATING — Indicates whether an action is repeatable within an action set sequence.
  • DELETE_ACTION_SET — Removes an action set and its related definition data.
  • UPDATE_ACTION_SET — Maintains changes to existing action set definitions.

Tables Accessed

The package operates primarily on the action set definition tables PA_ACTION_SETS and PA_ACTION_SET_LINES, reading and writing the header and line records that constitute an action set. PA_ACTION_SET_LINE_COND stores line-level conditions that must be satisfied before a line executes. PA_OBJECT_PAGE_LAYOUTS supplies object page layout information used in this context, while FND_NEW_MESSAGES and the FND messaging framework provide message text and error reporting. PA_PROJECTS_ALL is queried to evaluate project attributes such as status and dates, and PLITBLM is referenced as a standard PL/SQL character-table type used by the implementation for internal data handling.

Usage Notes

PA_PROJ_STAT_ACTSET is invoked indirectly rather than through direct calls from external code. It is most commonly exercised when a user defines or maintains action sets in the Oracle Projects administrative setup, when action set validation is triggered from the corresponding forms, and when the Project Status Action Sets feature processes actions during project lifecycle events and workflow-driven processing (notably through PA_PROGRESS_REPORT_WORKFLOW). The package is referenced by three other packages, which represent the typical entry points into its logic. Customizations should avoid calling this private package directly; instead, integrators should prefer the supported public interfaces such as PA_ACTION_SETS_PUB, since the internal signatures and behavior of PA_PROJ_STAT_ACTSET are not published and may change between releases.