Search Results update_perccomplete




Overview
Explore in AI Chat

Overview

PA_PROGRESS_REPORT_UTILS is a utility package body in the Oracle E-Business Suite Projects (PA) module. It centralizes the supporting logic required to create, validate, secure, and maintain progress reports, report cycles, and their associated page layouts and menu entries. Progress reports are the mechanism by which project managers communicate periodic status against a project or task, and this package supplies the shared routines that the Progress Reporter forms and concurrent processes depend upon. The single source file carries a header dated 2005 and was shipped as a non-customized (noship) object, indicating it is standard delivered code rather than an extension.

The package is classified as OTHER in the ETRM metadata, meaning it is not a formally published public API but is nonetheless referenced by four other packages. It exposes eighteen documented procedures and functions and operates against eleven documented tables, giving it a broad but tightly scoped role: it does not own any single business transaction, but instead answers the recurring questions the progress reporting screens must ask — which reporting dates apply, whether an action is permitted, whether a report or layout already exists, and which menu and page definitions are attached to an object.

Key Procedures and Functions

  • GET_REPORT_START_END_DATES — Derives the reporting start and end dates for a report, taking into account the object, report type, reporting cycle, offset days, publish flag, and any effective-from date. In the excerpt, it queries the maximum report end date from PA_PROGRESS_REPORT_VERS and falls back to the project start or creation date when no prior report exists.
  • CHECK_ACTION_ALLOWED — Determines whether a given action may be performed under the current object and user context.
  • VALIDATE_PROG_PROJ_DATES — Validates progress report dates against project dates to ensure consistency.
  • UPDATE_PERCCOMPLETE — Updates the percent complete value associated with a progress report.
  • IS_TEMPLATE_EDITABLE — Indicates whether a progress report template may be modified.
  • PROGRESS_REPORT_EXISTS — Checks whether a progress report already exists for the given criteria.
  • REMOVE_PROGRESS_REPORT_SETUP — Removes the setup associated with a progress report; this is the routine most commonly sought when cle