Results for “pa_action_sets_dyn”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_ACTION_SETS_DYN is an Oracle Application Object Library (APPS) PL/SQL package body that forms part of the Oracle Projects action set framework. Its role is to execute the individual lines that belong to an action set once the set has been triggered. Action sets in Oracle Projects are collections of ordered actions, such as notices, reminders, status update requests, or progress requests, that are grouped and applied against project or task records. The _DYN suffix indicates that this package performs the dynamic runtime execution of those action set lines, in contrast to configuration utilities that define them.

Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package is registered in the APPS schema with a status of VALID. Its ETRM classification is OTHER, reflecting that it is an internal framework package rather than a public, customer-facing API. The package orchestrates the processing mechanics for action sets, delegating shared logic to PA_ACTION_SET_UTILS and consuming configuration data from PA_ACTION_SETS and PA_ACTION_SET_LINES. It also touches several database views such as PA_ADV_RULE_OBJECTS_V, PA_PROJ_STATUS_REMINDER_V, and PA_TASK_PROGRESS_REMINDER_V that supply action-specific context.

Key Procedures and Functions

The package exposes five documented procedures and functions. Their names describe the lifecycle of processing an action set line:

• VALIDATE_ACTION_SET_LINE — Performs validation checks on an action set line before it is executed, confirming that the line definition and its associated data satisfy the conditions required for the action to run.
• PROCESS_ACTION_SET — The primary driver that processes an action set as a whole, coordinating the execution of its constituent lines and managing the overall flow of the action set run.
• PERFORM_ACTION_SET_LINE — Executes the business logic for a single action set line, applying the specific action the line represents.
• GET_ACTION_SET_LINE_IDS — A retrieval routine that obtains the identifiers of the lines belonging to an action set, supplying the list that processing iterates over.
• IS_ACTION_SET_STARTED_ON_APPLY — A predicate that determines whether the action set was initiated at the point of apply, supporting conditional behavior in the processing flow.

Parameter lists are intentionally omitted; the ETRM metadata documents names and roles but not signature details.

Tables Accessed

The package references two Oracle Projects base tables through APPS synonyms. PA_ACTION_SETS stores the header definition of each action set, including its identity and enabling attributes, and is read to establish which set is being processed. PA_ACTION_SET_LINES stores the individual ordered lines that compose a set, along with the action type and object references each line targets. Together these tables provide the configuration the package traverses dynamically at runtime. Supporting views such as the project status and task progress reminder views supply the reminder-specific content used when action lines produce reminders or status notifications.

Usage Notes

PA_ACTION_SETS_DYN is not referenced by any database object, which confirms that it is the top of its own call chain rather than a dependency of other packages. It in turn depends on PA_ACTION_SET_UTILS, PA_PROJ_STAT_ACTSET, PA_TASK_PROG_ACTSET, and PA_ADVERTISEMENTS_PUB, indicating it delegates shared and action-specific logic to those units. The package is typically invoked indirectly by the Oracle Projects action set framework in response to user or system events, such as applying an action set from a Projects form or a background process, rather than being called directly from customer code. Developers diagnosing action set behavior in 12.1.1 or 12.2.2 should profile these procedures to trace how individual lines are validated and executed.