Search Results cancel_action

Overview

PA_CI_ACTIONS_PVT is a private (PVT) API package in the Oracle E-Business Suite Projects (PA) module that manages actions associated with Control Items. Control Items (CIs) represent controlled project entities such as deliverables, issues, change requests, or work items tracked through the project lifecycle. The package provides the programmatic foundation for creating, closing, reassigning, cancelling, and commenting upon these actions, and it serves as the underlying implementation layer invoked by the public API and by Oracle Forms and workflow components. It follows the standard EBS PL/SQL API convention, accepting p_api_version, p_init_msg_list, p_commit, and p_validate_only parameters and returning x_return_status, x_msg_count, and x_msg_data. Errors are accumulated through PA_UTILS.Add_Message and the debug stack is initialized via PA_DEBUG.init_err_stack. Because it is a PVT package, it is not intended to be called directly by customers; supported entry points are exposed through the public API layer.

Key Procedures and Functions

• CREATE_CI_ACTION — Inserts a new action for a given Control Item. It derives the CI record version number, generates an action number, and supports assignment, required date, sign-off flag, comments, and a source action reference for action chains. It fires workflow notifications through PA_WF_PROCESSES.
• CLOSE_CI_ACTION — Marks an existing action as closed, updating status and audit columns.
• REASSIGN_CI_ACTION — Changes the assignee of an existing action.
• ADD_CI_COMMENT — Attaches a comment record to an action.
• UPDATE_CI_COMMENT — Modifies an existing comment on an action.
• CANCEL_CI_ACTION — Cancels a single action; this is the operation most commonly surfaced when applications or users search for "cancel_action".
• DELETE_ALL_ACTIONS — Removes all actions associated with a Control Item.
• CANCEL_ALL_ACTIONS — Cancels every action belonging to a Control Item in a single operation.

Tables Accessed

• PA_CI_ACTIONS — Primary table storing action records; the package inserts, updates, and cancels rows here.
• PA_CI_COMMENTS — Stores comment text attached to actions; written by ADD_CI_COMMENT and UPDATE_CI_COMMENT.
• PA_CONTROL_ITEMS — Source of the Control Item record version number and parent of the action; read to validate and lock the CI.
• PA_PROJECT_STATUSES — Consulted to validate project status constraints affecting whether actions may be created or cancelled.
• PA_WF_PROCESSES — Provides the item key used to launch workflow notifications for actions (referenced in the CREATE_CI_ACTION body).

Usage Notes

PA_CI_ACTIONS_PVT is invoked indirectly by Oracle Forms-based Control Item windows, by workflow background processes, and by the public API wrapper that external and custom code should call. Referenced by five other packages in the APPS schema, it functions as a shared internal service layer. Customizations should not call it directly; instead, they should use the corresponding public API, which validates inputs and manages transaction boundaries. The p_commit and p_validate_only flags allow callers to perform validation-only or deferred-commit execution, supporting both form interactions and batch concurrent processing. Because the package raises messages through the FND message stack, callers must inspect x_return_status and x_msg_data to detect validation or business-rule failures. All behavior is symmetric across Oracle EBS 12.1.1 and 12.2.2.