Search Results check_progress_status

Overview

PA_PROGRESS_REPORT_WORKFLOW is an Oracle Projects PL/SQL package that orchestrates the Oracle Workflow-driven approval and notification life cycle for project progress reports. Progress reports in Oracle E-Business Suite are authored, submitted, reviewed, approved, or rejected, and this package provides the programmatic glue between the progress report entities and the Workflow engine. It is invoked primarily by PA_PROGRESS_REPORT_PVT and PA_PROJ_STAT_ACTSET, which confirms its role as the submission and status-transition layer rather than the report editing layer. The package status is VALID in the APPS schema and it depends on PA_ACTION_SET_LINES and PA_ACTION_SET_UTILS, indicating that the workflow it starts is driven by configurable action sets that determine who must approve or act upon a submitted report. The package belongs to the Oracle Projects family and is classified as OTHER rather than a formally published open interface, so direct customer invocation is not the intended usage path.

Key Procedures and Functions

The package exposes 18 documented procedures and functions covering the full progress report workflow cycle:

• START_WORKFLOW / CANCEL_WORKFLOW — initiate and terminate the workflow process associated with a progress report; CANCEL_WORKFLOW is typically called when a report is withdrawn or superseded.
• GET_WORKFLOW_URL — returns the URL used to open or notify the workflow item.
• CHECK_PROGRESS_STATUS — evaluates the current workflow status of the report.
• CHANGE_STATUS_REJECTED / CHANGE_STATUS_WORKING / CHANGE_STATUS_APPROVED — transition the report to its rejected, in-progress, or approved states as workflow activity outcomes are processed.
• IS_SUBMITTER_SAME_AS_REPORTER — determines whether the submitter and reporter are the same person, which affects routing and approval rules.
• START_ACTION_SET_WORKFLOW — initiates the action-set-driven workflow, leveraging PA_ACTION_SET_LINES and PA_ACTION_SET_UTILS to resolve the required approvers or actors.
• SET_REMINDER_REPORT_NOTIFY / SET_MISSING_REPORT_NOTIFY — configure reminder and missing-report notification behavior.
• FORWARD_NOTIFICATION / POST_NOTIFICATION — forward a workflow notification to another recipient and post a notification into the workflow notification store.
• SHOW_STATUS_REPORT, SHOW_STATUS_REPORT_CANCEL, SHOW_STATUS_REPORT_SUBMIT — generate or present status information for the report, its cancellation, and its submission.
• SHOW_PROJECT_INFO / SHOW_REPORT_CONTENT — present project context and report content, typically for inclusion in notification or status output.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• PA_PROGRESS_REPORT_VERS and PA_PROGRESS_REPORT_VALS — hold the version and value-level content of the progress report being routed.
• PA_PROJECTS_ALL and PA_PROJECT_PARTIES — provide project context and identify project parties used in routing and notification.
• PA_REPORT_TYPES — supplies the configured report type definition.
• PA_ACTION_SET_LINES, PA_ACTION_SET_LINE_COND — define the action-set lines and their conditions that determine the workflow path.
• PA_WF_PROCESSES and PA_WORKFLOW_ITEMKEY_S — store the workflow process definition mapping and generate item keys for workflow instances.
• PA_PAGE_CONTENTS and PA_OBJECT_PAGE_LAYOUTS — hold page content and layout used when rendering report or status information.
• FND_USER, PER_ALL_PEOPLE_F, HR_ALL_ORGANIZATION_UNITS, HZ_PARTIES — provide the user, person, organization, and party identities required for notification and assignment.

Usage Notes

PA_PROGRESS_REPORT_WORKFLOW is an internal Oracle Projects component. It is referenced by PA_PROGRESS_REPORT_PVT and PA_PROJ_STAT_ACTSET, and it references PA_ACTION_SET_LINES and PA_ACTION_SET_UTILS. Invocation therefore typically occurs indirectly: a project administrator submits or cancels a progress report from the Oracle Projects progress report form or a related concurrent process, PA_PROGRESS_REPORT_PVT calls this package, and the package starts or cancels the associated workflow, updates status, and posts notifications to the identified approvers and recipients. Because the package depends on the Workflow schema (STANDARD) and on configured action sets, any customization should be performed through action-set and report-type configuration rather than by modifying this package. Custom code that requires progress report status should preferably call the public PA_PROGRESS_REPORT_PVT APIs, which will in turn use this package, rather than invoking PA_PROGRESS_REPORT_WORKFLOW directly. Behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, with the object remaining VALID in the APPS schema in both releases.