Search Results delete_status




Overview
Explore in AI Chat

Overview

The APPS.PA_STATUSES_PUB package body is the public application programming interface for maintaining project status definitions within Oracle Projects. In Oracle E-Business Suite 12.1.1 and 12.2.2, project statuses represent the lifecycle states that a project, and its associated tasks and deliverables, can occupy, such as Approved, On Hold, Closed, or Rejected. These statuses drive system behavior across Oracle Projects, including transaction entry validation, reporting, and workflow processing. The PA_STATUSES_PUB package provides the supported, externally callable entry point through which client code can perform maintenance operations against project status definitions while preserving the integrity rules enforced by the underlying private packages.

The package conforms to the standard Oracle EBS API architecture. It is classified as a PUB (public) API and delegates its core processing to the private package PA_STATUSES_PVT, while relying on the Oracle Application Object Library utilities FND_API, FND_MESSAGE, and FND_MSG_PUB for the standard API return status, message stacking, and error handling conventions. It is listed with a status of VALID in the APPS schema, indicating a successfully compiled and active object.

Key Procedures and Functions

The documented interface exposes one procedure:

  • DELETE_STATUS — Removes a project status definition. Consistent with Oracle Projects API conventions, this procedure accepts a standard API parameter set that includes a row identifier or status identifier for the record to be deleted, along with the standard p_init_msg_list, p_commit, and x_return_status, x_msg_count, and x_msg_data parameters. The procedure validates the deletion request, invokes the corresponding routine in PA_STATUSES_PVT, and returns the outcome through the standard message stack.

The package body also depends on PA_PROJECT_STUS_UTILS and PA_INTERFACE_UTILS_PUB, which supply shared status validation and interface utility logic used during processing. No parameter lists are invented here; consumers should obtain the exact signature from the packaged procedure declaration in the ETRM or the database.

Tables Accessed

The package operates against the PA_PROJECT_STATUSES table, accessed through its APPS synonym. This table stores the definition of each project status, including the status code, its user-facing name, and attributes that govern how the status behaves within Oracle Projects. The DELETE_STATUS procedure writes to this table by removing the targeted status row, after validation confirms that removal is permissible. Read access to the table supports the validation logic that determines whether a status may be deleted, for example to prevent the removal of a status that is system-seeded or currently assigned to a project.

Usage Notes

PA_STATUSES_PUB is the supported programmatic route for deleting project statuses. It is typically invoked from Oracle Projects setup forms, from concurrent programs that perform configuration maintenance, or from custom PL/SQL code that must remove obsolete status definitions during implementation or data cleanup activities. Callers should observe the standard EBS API protocol: initialize the message list when requested, check x_return_status for FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR, and inspect the stacked messages via FND_MSG_PUB when a call does not succeed. Because the package commits only when instructed through its commit parameter, callers retain control over transaction boundaries. The ETRM metadata records that PA_STATUSES_PUB is not referenced by any other database object, confirming that it is intended as an entry point for external callers rather than as a dependency of other packaged code.