Search Results validate_action_set_line




Overview
Explore in AI Chat

Overview

PA_ACTION_SETS_DYN is a dynamic PL/SQL package within the Oracle Projects (PA) module of Oracle E-Business Suite, owned by the APPS schema and declared with AUTHID CURRENT_USER. It implements the runtime engine that executes action sets, the configurable rule-based constructs used in Oracle Projects to automate status transitions and related business actions. An action set defines an ordered sequence of action set lines, each carrying its own conditions and target action. PA_ACTION_SETS_DYN evaluates those lines against a project or object context and determines whether the action set should proceed, which individual lines qualify, and what result code applies to each. The package name suffix "DYN" indicates that it supports dynamic, data-driven evaluation rather than hard-coded logic, making it the core runtime component invoked whenever an action set is applied to a project or related object. The source header places the package at version 120.1, with the shipped header comment referencing patch-level fixes tied to 11.5.9 mandates, which remain relevant in the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

  • VALIDATE_ACTION_SET_LINE — Validates a single action set line record, including its associated action line conditions, before execution. It returns a status indicator so callers can reject or report invalid line definitions.
  • PROCESS_ACTION_SET — Drives processing of a complete action set identified by type code and action set ID, honoring the action set template flag to distinguish template versus concrete action sets.
  • PERFORM_ACTION_SET_LINE — The procedure relevant to the user's search term "perform_action_set_line". It executes an individual action set line using the action set details record, the action set line record, and the action line conditions table. It returns an audit lines table and an action line result code, enabling downstream auditing of the outcome.
  • GET_ACTION_SET_LINE_IDS — Returns collections of action set line IDs, object names, and project numbers for a given action set type code and project number range, supporting bulk retrieval and processing scenarios.
  • IS_ACTION_SET_STARTED_ON_APPLY — A function that reports whether an action set has already begun execution when applied, keyed by action set type code and object type/ID, guarding against duplicate application.

Tables Accessed

  • PA_ACTION_SETS — Stores the header definition of each action set, including its type code and template status. PA_ACTION_SETS_DYN reads this table to resolve the action set being processed and to build the details record passed to PERFORM_ACTION_SET_LINE.
  • PA_ACTION_SET_LINES — Stores the individual action set lines belonging to each action set. The package reads lines to evaluate conditions, validate definitions, and execute the corresponding action.

Both tables are referenced through APPS synonyms, consistent with the AUTHID CURRENT_USER declaration.

Usage Notes

PA_ACTION_SETS_DYN is an internal engine API rather than an end-user interface. It is typically invoked by Oracle Projects forms and concurrent programs when a user applies an action set to a project, and it is referenced by two other packages, which likely supply higher-level orchestration such as validation and utility services. Custom code may call PERFORM_ACTION_SET_LINE or PROCESS_ACTION_SET directly to programmatically apply action sets, but callers must construct the pa_action_set_lines%ROWTYPE and action line conditions collection correctly, and should honor the returned audit table and result code for error handling. Because the package does not expose a documented public API classification, customizations should treat it as a low-level, version-sensitive dependency; the header revision history confirms that interface details, including audit mandates, have changed across patch levels.