Search Results post_task

Overview

APPS.PA_TASK_WORKFLOW_PKG is a PL/SQL package body that implements the Task Approval Workflow for Oracle Projects. It provides the server-side logic that launches Oracle Workflow processes for project task approval, generates approval and notification content, and manages the lifecycle state of tasks as they move through the approval cycle. The package is registered in Oracle E-Business Suite as an API of classification OTHER, and it is referenced by one other package, indicating that it functions as a shared service layer rather than a standalone entry point.

Functionally, the package supports the workflow-driven approval of project tasks, including parent-child task relationships, change document (control item) context, and status transitions. The package header declares a debug mode flag driven by the PA_DEBUG_MODE profile option and holds global error variables (error message, error stack, error stage) used to propagate failure information back to callers.

Key Procedures and Functions

The documented package metadata lists thirteen procedures and functions:

• START_TASK_APRV_WF — Initiates the task approval workflow for a given task, project, and structure version, resolving starter and approver user information before launching the workflow.
• IS_CHILD_TASK — Determines whether a task is a child within the task hierarchy, used to control approval routing for hierarchical task structures.
• IS_PARENT_TASK_APPROVED — Checks whether the parent task has already been approved, supporting dependency rules between parent and child approvals.
• APPEND_VARCHAR_TO_CLOB — Utility that appends VARCHAR2 content to a CLOB, used when accumulating notification or message bodies.
• SHOW_TASK_NOTIFY_PREVIEW — Produces a preview of the task approval notification content for display or review.
• GENERATE_TASK_APRV_NOTIFY — Generates the approval notification payload delivered to approvers.
• POST_TASK — Posts the task, typically applying the approval outcome and persisting task state as part of the workflow callback.
• UPDATE_TASK_STATUS — Updates the status of a task, reflecting the current approval or processing state.
• DELETE_TASK — Removes a task record as part of workflow-driven cleanup or cancellation.
• SHOW_ERROR — Displays or returns the accumulated error message, stack, and stage for troubleshooting.
• VERIFY_TASK_STATUS — Validates that a task is in the expected status before an operation proceeds.
• MARK_CO_STATUS — Marks the status of the associated control item (change order/change document) in support of the approval process.
• IS_LAST_TASK — Determines whether the current task is the last in the approval sequence.

Tables Accessed

The package reads and writes a set of Oracle Projects and Workflow tables through APPS synonyms:

• FND_USER — Resolves user names and full names for workflow starters and approvers.
• PA_PROJECTS_ALL — Supplies project-level context for the approval.
• PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_SCHEDULE — Provide task definitions, versions, and scheduling data.
• PA_TASKS — The primary task record whose status is posted, updated, or deleted.
• PA_WF_PROCESSES, PA_WORKFLOW_ITEMKEY_S, PA_OBJECT_RELATIONSHIPS — Track workflow process instances and their relationship to project objects.
• PA_CONTROL_ITEMS, PA_CI_ACTIONS — Hold change document information used by MARK_CO_STATUS and notification generation.
• PA_BUDGET_VERSIONS, PA_RESOURCE_ASSIGNMENTS, PA_PAGE_CONTENTS — Support approval context and display content.
• FND_NEW_MESSAGES — Used when composing workflow notification messages.

Usage Notes

PA_TASK_WORKFLOW_PKG is invoked indirectly from Oracle Projects forms and workflow activity callbacks rather than directly by end users. It is most commonly triggered when a task approval is submitted from the Project Workplan or Task Management UI (for example, through the "Post Task" action, corresponding to POST_TASK), and by Oracle Workflow activities that call back into EBS to update task status or generate notifications. Custom extensions may call START_TASK_APRV_WF to launch approval programmatically. The PA_DEBUG_MODE profile option controls diagnostic output through the log_message helper. Because the package maintains global error variables, callers should check the returned error code, stack, and stage after each invocation.