Results for “pa_action_sets_pub”

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

Overview

PA_ACTION_SETS_PUB is the public API package in the Oracle Projects (PA) module responsible for creating, maintaining, and executing Action Sets. An Action Set is a reusable, ordered collection of actions (such as status changes, workflow notifications, or field updates) that the application applies against a project or an entity within a project. The package exposes a PL/SQL interface that allows both Oracle EBS application code and customer extensions to define action-set templates, manage the individual lines and conditional logic that make up each set, and then perform those sets against live business objects.

The package belongs to the APPS schema, carries a public (PUB) API classification, and is validated in Oracle EBS 12.1.1 and 12.2.2. It forms part of the broader Action Sets framework used by features such as project status processing, task progression, and assignment workflows.

Key Procedures and Functions

The package documents 13 procedures and functions. Their responsibilities are grouped as follows.

• Action Set header maintenance: CREATE_ACTION_SET, UPDATE_ACTION_SET, and DELETE_ACTION_SET manage the header-level definition of an action set, including its type and descriptive attributes.
• Action Set line maintenance: CREATE_ACTION_SET_LINE, UPDATE_ACTION_SET_LINE, and DELETE_ACTION_SET_LINE manage the individual action lines contained within a set, including their sequencing.
• Conditional line logic: CREATE_LINE_SINGLE_COND and UPDATE_LINE_SINGLE_COND define and modify the conditions under which a given line is applied, allowing conditional branching within a set.
• Execution: APPLY_ACTION_SET and PERFORM_SINGLE_ACTION_SET execute a single action set against the target entity; PERFORM_ACTION_SETS executes multiple sets; REPLACE_ACTION_SET substitutes the contents of an existing set; and PROCESS_ACTION_SET drives the overall processing logic that evaluates conditions and applies the resulting actions.

No parameter signatures are reproduced here; callers should consult the package specification for exact argument lists.

Tables Accessed

The package reads and writes the core Action Sets tables through APPS synonyms:

• PA_ACTION_SETS — header definitions of each action set.
• PA_ACTION_SET_LINES — the ordered action lines belonging to each set.
• PA_ACTION_SET_LINE_COND — conditional criteria evaluated for individual lines.
• PA_ACTION_SET_TYPES — the valid action-set types that determine how a set behaves.
• PA_ACTION_SET_REPORT_TEMP — a temporary/reporting structure used during processing.
• PLITBLM — the standard PL/SQL table type used for bulk collections (for example, arrays of IDs passed into processing routines).

Supporting logic is delegated to PA_ACTION_SET_UTILS and the FND_API error-handling framework.

Usage Notes

PA_ACTION_SETS_PUB is the standard entry point for Action Sets. It is invoked by concurrent programs and standard forms through PA_ACTION_SETS_PVT, and it is referenced by other public and private packages including PA_ADVERTISEMENTS_PUB, PA_ASSIGNMENTS_PUB, PA_ASSIGNMENT_APPROVAL_PUB, PA_OPEN_ASSIGNMENT_PVT, and the concurrent-program packages PA_PROJ_STAT_ACTSET, PA_TASK_PROG_ACTSET, and PA_PAPERACR_XMLP_PKG. Because Oracle's own code layers on top of this API, customizations should call PA_ACTION_SETS_PUB rather than writing directly to the underlying tables. Callers should supply standard FND_API parameters (such as p_init_msg_list and x_return_status) and inspect the returned message list, since the package relies on FND_API conventions for error reporting. In a multi-org context, the appropriate MOAC initialization should be performed before invocation.