Search Results pa_planning_resource_pvt




Overview
Explore in AI Chat

Overview

PA_PLANNING_RESOURCE_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business PLANNING, part of the Oracle Projects (PA) module. It serves as the core implementation layer for managing planning resources — the generic labor, non-labor, and material resources assigned to a project or resource list during the planning life cycle. The package encapsulates the insert, update, delete, and copy logic that keeps the PA_RESOURCES, PA_RESOURCE_ASSIGNMENTS, and PA_RESOURCE_LISTS_ALL_BG structures consistent when planners build and revise project resource plans.

Because the package is classified as PVT (private), it is not itself an exposed API. Its procedures are consumed internally by the public planning resource API (PA_PLANNING_RESOURCE_PUB) and by utility, mapping, upgrade, and task-assignment packages. The ETRM metadata documents the package as VALID on both Oracle EBS 12.1.1 and 12.2.2, with the package and package body both present.

The package depends on FND_API (for the standard error/return-status convention), FND_GLOBAL (for session context such as user and responsibility), the STANDARD package, and the PL/SQL collection type PA_NUM_TBL_TYPE, which is used to pass sets of numeric identifiers between internal routines.

Key Procedures and Functions

The ETRM documentation lists five entry points on this package:

  • CHECK_PL_ALIAS_UNIQUE — validates that a planning resource alias (short name) is unique before a resource is created or renamed, preventing duplicate aliases within the planning scope.
  • CREATE_PLANNING_RESOURCE — performs the core insertion of a planning resource, including its assignment to a resource list and the population of default and format attributes.
  • UPDATE_PLANNING_RESOURCE — modifies attributes of an existing planning resource and its associated resource-list membership records.
  • DELETE_PLANNING_RESOURCE — removes a planning resource and cleans up the corresponding member and assignment rows.
  • COPY_PLANNING_RESOURCES — duplicates one or more planning resources, typically when a resource list is copied between projects, versions, or planning scenarios.

Each routine is understood to observe the FND_API return-status model (success, error, unexpected error) so that calling packages can propagate failures to the calling form or concurrent program. Parameter lists are not enumerated in the metadata and should be confirmed against the package specification in the target instance.

Tables Accessed

The package reads and writes a well-defined set of APPS-synonym tables:

Usage Notes

PA_PLANNING_RESOURCE_PVT is not intended to be called directly from customer extension code. It is referenced by PA_PLANNING_RESOURCE_PUB, PA_PLANNING_RESOURCE_UTILS, PA_PLAN_RES_LIST_PUB, PA_RESOURCE_MAPPING, PA_RES_LIST_UPGRADE_PKG, and PA_TASK_ASSIGNMENT_UTILS, and self-references its own package body for internal helper calls. In practice it is invoked when a planner adds, edits, deletes, or copies resources in the Project Resource Management and resource-list maintenance forms, and when concurrent processes for resource-list copy and upgrade execute. Customizations should call the public PA_PLANNING_RESOURCE_PUB wrapper rather than this private package; direct calls may bypass validation and are subject to change between releases. Because the package relies on FND_GLOBAL session context, it must be run within a valid EBS application session.