Results for “update_action_set”

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

Overview

PA_ACTION_SETS_PVT is the private implementation package for Oracle Projects action set functionality in Oracle E-Business Suite 12.1.1 and 12.2.2. An action set is a container that holds a sequence of executable lines, each representing a project action such as status transitions, advertisement generation, or task progression. The package sits in the APPS schema and is classified as a PVT (private) API, meaning it is not intended for direct invocation by external integrators. Instead, it supplies the business logic consumed by the corresponding public package PA_ACTION_SETS_PUB and by internal callers within the Oracle Projects suite.

The package encapsulates the full lifecycle of action sets: creation, maintenance, deletion, and the execution of individual action set lines. It also provides bulk operations and audit-line management, which support high-volume processing where individual row-by-row handling would be inefficient.

Key Procedures and Functions

The ETRM metadata documents twelve procedures and functions within the package:

• CREATE_ACTION_SET — Creates a new action set header record.
• UPDATE_ACTION_SET — Modifies attributes of an existing action set.
• DELETE_ACTION_SET — Removes an action set.
• CREATE_ACTION_SET_LINE — Adds a line to an action set.
• UPDATE_ACTION_SET_LINE — Modifies an existing action set line.
• DELETE_ACTION_SET_LINE — Removes a line from an action set.
• GET_DEF_REVERSE_AUDIT_LINES — Retrieves default or reverse audit lines associated with an action set line.
• BULK_INSERT_AUDIT_LINES — Inserts audit lines in bulk, supporting performance-sensitive batch processing.
• PERFORM_ACTION_SET_LINE — Executes the business action defined on a specific action set line.
• BULK_UPDATE_LINE_NUMBER — Reassigns line numbers across multiple action set lines in a single operation.
• BULK_UPDATE_CONDITION_DATE — Mass-updates condition dates on action set lines.
• BULK_UPDATE_LINE_STATUS — Mass-updates the status of action set lines.

The presence of three dedicated bulk procedures and a bulk audit insert indicates the package is designed to satisfy both interactive, single-record maintenance and set-based concurrent processing.

Tables Accessed

Via APPS synonyms, the package reads and writes the following documented tables:

• PA_ACTION_SETS — the action set header table, holding set-level attributes.
• PA_ACTION_SET_LINES — individual action lines belonging to each set.
• PA_ACTION_SET_TYPES — the action type definitions that classify what each line performs.
• PA_ACTION_SET_LINE_AUD — the audit table capturing line-level history, written by the audit-line procedures.
• PA_ACTION_SET_LINE_COND — condition records attached to action set lines, updated by BULK_UPDATE_CONDITION_DATE.
• PLITBLM — a standard Oracle Projects PL/SQL table used for passing and processing collections within bulk operations.

Usage Notes

Because PA_ACTION_SETS_PVT is a private package, it should be invoked through the public wrapper PA_ACTION_SETS_PUB rather than directly. The ETRM dependency data shows it is referenced by six other packages, including PA_ACTION_SETS_PUB, PA_ACTION_SET_UTILS, PA_ADVERTISEMENTS_PUB, PA_ADVERTISEMENTS_PVT, PA_PROJ_STAT_ACTSET, and PA_TASK_PROG_ACTSET, confirming its role as a shared internal service layer for advertisement generation and project status or task progression workflows.

Operationally, the package is triggered when users maintain action sets in Oracle Projects forms, when concurrent programs process project status actions, and when public APIs are called by custom extensions. It depends on FND_API for the standard API return-status and message-handling framework, so callers should expect FND_API-compliant error signaling through the x_return_status and x_msg_data conventions. Direct calls from custom code are discouraged and unsupported, since private APIs may change between releases.