Search Results pa_percent_completes_s




Overview
Explore in AI Chat

Overview

PA_PERCENT_COMPLETES_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. Its name reflects its role in Project Management and Project Billing operations involving percent-complete calculations for projects and tasks. Percent complete is a fundamental driver for revenue recognition, billing, and cost-to-cost performance measurement in Oracle Projects, and this package provides the programmatic Data Manipulation Language (DML) layer for the underlying percent-complete records.

From an architectural standpoint, the package is classified as an "OTHER" API rather than a formal public interface API. It is a low-level maintenance package that exposes insert, update, and delete operations against the percent-complete data model. Its dependency list confirms it operates on the percent-complete entity tables directly while also leveraging Oracle Application Object Library utilities (FND_API, FND_MESSAGE, FND_MSG_PUB) for error handling and API framework components. The validation status is VALID and it is referenced by three other database objects, indicating it is an internal building block consumed by higher-level logic rather than a top-level entry point.

Key Procedures and Functions

The ETRM metadata documents three procedures in this package:

  • INSERT_ROW — Creates a new percent-complete record. This procedure is the entry point for establishing a percent-complete value for a project or task combination, first populating the base table row and its associated multilingual (_S) row so the record is available in all supported languages.
  • UPDATE_ROW — Modifies an existing percent-complete record. This is used when a percent-complete value must be revised, whether through manual correction or recalculation triggered by upstream project processes.
  • DELETE_ROW — Removes a percent-complete record from the data model. It handles the orderly removal of the row together with its translations.

No parameter lists are published in the available metadata, and none are fabricated here. The procedures are consistent with a standard row-maintenance API pattern: each accepts primary key or identifying information, the values to be written, and returns standard API status through the FND message stack.

Tables Accessed

The package references the following tables through APPS synonyms:

  • PA_PERCENT_COMPLETES — The base table holding percent-complete records for projects and tasks. INSERT_ROW, UPDATE_ROW, and DELETE_ROW all operate against this table.
  • PA_PERCENT_COMPLETES_S — The multilingual translation table corresponding to PA_PERCENT_COMPLETES. This table stores language-specific data and is maintained in parallel with the base table (the "_S" suffix is the standard Oracle Applications translated-table convention). The user's search term, "pa_percent_completes_s", maps directly to this object, confirming the table is registered in the dictionary and maintained by this package.
  • DUAL — The standard single-row utility table, used for simple evaluations and sequencing operations.

Usage Notes

PA_PERCENT_COMPLETES_PKG is not referenced by any other database object directly, but it is designed to be called by three dependent packages and by the Oracle Projects forms and concurrent programs that maintain percent-complete data. It is typically invoked indirectly — driven by the percent-complete entry forms, revenue and billing generation processes, or custom extensions that need to insert, adjust, or remove percent-complete rows using the supported API rather than direct SQL.

Because it relies on FND_MSG_PUB and the FND_API error stack, callers should inspect the message stack after invocation and commit or roll back the transaction as appropriate. Direct DML against PA_PERCENT_COMPLETES and its _S table should be avoided in favour of this package to preserve the integrity of the percent-complete data model.