Search Results pa_planning_resource_pub




Overview
Explore in AI Chat

Overview

PA_PLANNING_RESOURCE_PUB is a public PL/SQL application programming interface (API) package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Projects (PA) module and provides the programmatic interface for creating, maintaining, and removing planning resources associated with project planning activities. In the Oracle Projects architecture, planning resources represent the labor, financial, or non-labor assignments that are reserved against a project or project template during the planning lifecycle. This package abstracts the underlying planning tables and business logic so that forms, concurrent programs, and custom extensions can manipulate planning resources without directly touching the base tables, thereby preserving data integrity and enforcing Oracle Projects business rules.

The package is classified as a PUB (public) API, meaning it is intended for supported external invocation by other Oracle EBS modules and customer-developed code. It carries a VALID status in the data dictionary, confirming that the package specification and body compiled successfully in the target release. The metadata confirms this package is documented for both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented public interface exposes three procedures:

  • CREATE_PLANNING_RESOURCE — Responsible for inserting a new planning resource record into the Oracle Projects planning structures. It encapsulates the validation and defaulting logic required to establish a resource against a plan or template.
  • UPDATE_PLANNING_RESOURCE — Modifies an existing planning resource. It applies the same validation framework as the create routine but targets an already-identified resource record.
  • DELETE_PLANNING_RESOURCE — Removes a planning resource from the planning structures, applying referential and business-rule checks before deletion.

All three follow the standard Oracle EBS API conventions, relying on FND_API for the common API framework (message handling, error stack management, and the standard return status), and on FND_GLOBAL for session context such as user ID, responsibility, and login information. No parameter lists are documented in the ETRM metadata, so callers should reference the package specification directly for exact signatures.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed through an APPS synonym. PLITBLM is a standard Oracle Projects planning table used to store planning resource and plan-line information. The create, update, and delete procedures operate on this table as the persistence layer for planning resource data.

The package additionally depends on the following collection types defined in the schema: PA_NUM_TBL_TYPE, PA_VARCHAR2_1_TBL_TYPE, PA_VARCHAR2_30_TBL_TYPE, PA_VARCHAR2_80_TBL_TYPE, PA_VARCHAR2_150_TBL_TYPE, and PA_VARCHAR2_240_TBL_TYPE. These are used to pass multi-row numeric and character arrays into the API, a common pattern in Oracle Projects public APIs that support bulk or set-based operations. Core SYS dependencies include STANDARD.

Usage Notes

PA_PLANNING_RESOURCE_PUB is typically invoked by the Oracle Projects planning forms and by concurrent programs that manage project resource assignments. Custom integrations and extensions that need to programmatically add, change, or remove planning resources should call this public API rather than performing direct DML against PLITBLM, because the API enforces validation and maintains consistency with related planning data.

Per the ETRM dependency information, the package is not referenced by any other packages, indicating it functions as a leaf-level public interface rather than an internal building block. Callers should always inspect the FND_API return status and the message stack after invocation to detect validation failures.