Search Results check_usedtask_status

Overview

PA_TASK_APPROVAL_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified within ETRM under the API classification OTHER. Its purpose is to support the task-level approval process within Oracle Projects, specifically in the context of Change Orders and the Task Management workflow. The package provides the server-side logic that determines whether tasks associated with a project change order may proceed through approval, whether a given task is a child or parent task in the project hierarchy, and whether a parent task has already been approved. It is declared AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the invoking user rather than the package owner, so callers require the appropriate grants on the underlying PA tables and on the package itself.

The package was last modified under header revision 120.3 (2009), and its procedures remain part of the standard Oracle Projects task approval infrastructure in both 12.1.1 and 12.2.2.

Key Procedures and Functions

Five documented program units are exposed by this package.

• MARK_CO_STATUS — This is the procedure returned by the search term "mark_co_status". It is invoked from the Change Order workflow to verify whether any task used by the change order is already approved. It accepts the change document identifier (p_ci_id) as input and returns p_return_status, p_msg_count, and p_msg_data as OUT parameters. The standard return status values are S (success), E (business rule violation), and U (unexpected error). Callers use p_msg_count for fetching messages from the global message table and p_msg_data for a single message code.
• CHECK_USEDTASK_STATUS — Compares the approval status of tasks referenced by a change document, returning the same standard status and message parameters as MARK_CO_STATUS.
• IS_CHILD_TASK — Called from the Task workflow package to determine whether the submitted task is a child task. It takes project identifier, project element (task) identifier, and parent structure version as inputs.
• IS_PARENT_TASK_APPROVED — Returns whether the parent task of a submitted task has already been approved.
• SUBMIT_TASK — Supports submission of a task into the approval workflow.

Tables Accessed

The package operates against the following APPS-synonymed tables:

• PA_CONTROL_ITEMS — Stores the change order (control item) header identified by p_ci_id.
• PA_OBJECT_RELATIONSHIPS — Links change orders to the tasks they affect, enabling the "used task" checks.
• PA_TASKS and PA_PROJ_ELEMENTS — Hold task definitions and project element records.
• PA_PROJ_ELEMENT_VERSIONS — Provides the versioned task structure used to resolve parent and child relationships.
• PA_BUDGET_VERSIONS — Supports evaluation of budget-related task state.
• PA_RESOURCE_ASSIGNMENTS — Supplies assignments associated with tasks during validity checks.

Usage Notes

PA_TASK_APPROVAL_PKG is not intended for direct end-user invocation. It is called by the Oracle Projects Change Order and Task workflows, and it is referenced by two other packages within the APPS schema, which use it to validate task status before progressing workflow activities. Customizations that call these procedures directly must pass a valid change document or task identifier, inspect p_return_status for S, E, or U, and retrieve messages using p_msg_count and p_msg_data. Because the package is AUTHID CURRENT_USER, executing schemas must hold explicit EXECUTE grants and the necessary table privileges. No concurrent program is documented for this package; it is a workflow-facing utility rather than a standalone request.