Search Results delete_project_set_line

Overview

PA_PROJECT_SETS_PVT is a private PL/SQL API package in the Oracle E-Business Suite Projects (PA) module. Its header comment identifies the source file as PAPPSPVB.pls, version 120.2. The package encapsulates the business logic required to maintain project sets — the groupings of projects that control access, reporting, and inquiry scope for project managers and users. By designating a PVT (private) API classification in ETRM, the package is intended for internal consumption by other PA packages and public APIs rather than as a directly callable integration interface. Application logic in the surrounding product code, and several other packages, depend on its procedures to create, modify, and remove project set definitions and the individual project-to-set associations stored as project set lines.

Key Procedures and Functions

ETRM documents six procedures in the package body:

• CREATE_PROJECT_SET — Creates a new project set header record. It accepts the set name, owning party identifier, effective start and end dates, access level, description, and the standard descriptive flexfield attribute columns (attribute_category and attribute1 through attribute15). It returns the generated project_set_id and a return status.
• UPDATE_PROJECT_SET — Modifies an existing project set header, including effective dating, access level, party association, and flexfield attribute values.
• DELETE_PROJECT_SET — Removes a project set definition, including its associated line records.
• CREATE_PROJECT_SET_LINE — Adds a single project to a project set, establishing the membership record in PA_PROJECT_SET_LINES.
• DELETE_PROJECT_SET_LINE — Removes a single project from a project set. This is the procedure users locate when selecting a project line and choosing a remove or delete action; it deletes the corresponding row in PA_PROJECT_SET_LINES without affecting the underlying project itself.
• DELETE_PROJ_FROM_PROJ_SET — Removes project memberships, providing a companion deletion path for cleaning up a project's presence in one or more sets.

The body initializes the standard FND_API return status to success at the start of each call, and reads the PA_DEBUG_MODE profile option into an internal logging flag.

Tables Accessed

The package operates across the following APPS synonyms. PA_PROJECT_SETS_B and PA_PROJECT_SETS_TL hold the base and translated (name and description) project set header data read and written by create, update, and delete operations. PA_PROJECT_SET_LINES stores the individual project-to-set assignments manipulated by CREATE_PROJECT_SET_LINE, DELETE_PROJECT_SET_LINE, and DELETE_PROJ_FROM_PROJ_SET. HZ_PARTIES is referenced to validate and resolve the owning party (p_party_name / p_party_id) associated with the set. PLITBLM, the FND message-handling table type, supports the API's message stack, allowing error and informational messages to propagate to callers. All access is performed under the APPS schema through public synonyms.

Usage Notes

Because PA_PROJECT_SETS_PVT is a private API, it is normally invoked indirectly — from the Project Set entry forms in Oracle Projects, from public wrapper APIs, or from other PA packages (ETRM notes that two packages reference it). Customizations on EBS 12.1.1 or 12.2.2 that need to manipulate project set headers or memberships programmatically should call this package within the same transaction context and honor the returned x_return_status, checking the FND message stack via the standard FND_MSG_PUB routines when the status indicates error. Setting the PA_DEBUG_MODE profile option enables logging. Direct table DML against the project set tables is discouraged, since this package enforces the effective-dating, flexfield, and translation logic associated with the Project Sets entity.