Search Results pa_task_prog_actset




Overview
Explore in AI Chat

Overview

PA_TASK_PROG_ACTSET is an Oracle EBS Applications (APPS) PL/SQL package within the Project Accounting (PA) module. Its name reflects its role in the execution of action sets associated with task progress reporting. Within Oracle Projects, an action set is a configured group of actions that are performed together under defined conditions. The PA_TASK_PROG_ACTSET package provides the runtime engine that processes these configured action sets, evaluating each action set line in turn and determining whether the corresponding action is permissible for the current project or task status. It further supports the copying, validation, updating, and deletion of action set definitions.

The package is classified as an API of type OTHER, indicating that it is not one of the primary public interfaces of Oracle Projects but rather an internal utility invoked by other Project Accounting components. It depends upon the FND_API foundation layer for standard API error handling and upon PA_ACTION_SET_UTILS, PA_ACTION_SETS, and PA_ACTION_SET_LINES for the underlying action set data model. It is referenced by PA_ACTION_SETS_DYN, PA_PROGRESS_REPORT_PVT, and PA_PROJECT_CORE1, confirming its role as a shared service consumed by progress reporting and project core logic.

Key Procedures and Functions

The package exposes nine documented procedures and functions. No parameter lists are published in the metadata; the descriptions below address purpose only.

  • PROCESS_ACTION_SET — The principal entry point that drives execution of an action set. It iterates through the action set lines and applies the appropriate processing for each.
  • PERFORM_ACTION_SET_LINE — Performs a single action set line, applying the logic required for the individual action it represents.
  • COPY_ACTION_SETS — Duplicates existing action set definitions, typically to support configuration across projects or organizations.
  • VALIDATE_ACTION_TYPE_CODE — Confirms that a supplied action type code is valid against the supported action type values.
  • ACTION_ALLOWED_FOR_STATUS — Determines whether a given action is permitted for the current project or task status.
  • OK_TO_PERFORM_ACTION — Evaluates the conditions associated with an action to decide whether it may proceed.
  • IS_ACTION_REPEATING — Indicates whether an action is repeatable, which governs whether it may be executed more than once within a workflow.
  • DELETE_ACTION_SET — Removes an action set definition and its associated lines.
  • UPDATE_ACTION_SET — Modifies an existing action set definition.

Tables Accessed

The package reads and writes a defined set of Project Accounting tables through APPS synonyms:

  • PA_ACTION_SETS — The header definition of each action set.
  • PA_ACTION_SET_LINES — The individual action lines belonging to an action set.
  • PA_ACTION_SET_LINE_COND — Conditions attached to action set lines that gate execution.
  • PA_PROJECTS_ALL — Project and task information used in status evaluation and action processing.
  • PA_OBJECT_PAGE_LAYOUTS — Layout metadata consulted when actions involve page presentation.
  • DUAL — Used for single-row expression evaluation.
  • PLITBLM — The standard PL/SQL index-by table memory structure.

Usage Notes

PA_TASK_PROG_ACTSET is typically invoked indirectly rather than by end users. It is reached through progress reporting and project core processing paths, and through the dynamic action set logic in PA_ACTION_SETS_DYN. Customizations that need to process or validate action sets should call this package rather than manipulate the underlying tables directly, so that the validation and condition checks performed by VALIDATE_ACTION_TYPE_CODE, ACTION_ALLOWED_FOR_STATUS, and OK_TO_PERFORM_ACTION are applied consistently. Because the package is classified as OTHER and is not a formal public interface, extensions should be developed against it with the understanding that its internal behavior may change between maintenance releases.