Search Results pa_resource_pkg




Overview
Explore in AI Chat

Overview

PA_RESOURCE_PKG is a private PL/SQL package in the APPS schema that supports Oracle Projects resource management functionality. Its primary business role is to insert and maintain records in the project resource tables — PA_RESOURCES and PA_RESOURCE_TXN_ATTRIBUTES — which define and describe the resources (people, organizations, equipment, or other resource types) that can be assigned to, and charged against, projects and tasks. In Oracle EBS 12.1.1 and 12.2.2, resource definitions are foundational to project planning, task assignment, costing, and transaction processing, so this package feeds the base data that downstream Projects modules consume. The ETRM metadata classifies its API type as OTHER, indicating it is not a published extension API but an internal/utility component invoked by other Projects code.

Key Procedures and Functions

The documented package exposes two procedures:

  • INSERT_ROW1 — Executes the first of the package's insert paths, creating a new row in the resource structures it maintains. It is used when the calling process needs to establish a resource definition through the primary insertion route.
  • INSERT_ROW2 — Executes the alternate insertion path, performing insertion logic for resource records under a distinct set of conditions or a different table/column target than INSERT_ROW1.

Both procedures are private/internal in nature and are not documented as public integration points. Because the ETRM metadata does not publish parameter signatures, the parameter lists are not reproduced here; callers should reference the deployed package specification for exact arguments.

Tables Accessed

The package reads and writes the following tables, referenced through APPS synonyms:

  • PA_RESOURCES — The master table of project resources. INSERT_ROW1 and INSERT_ROW2 populate this table to register resources available for project use.
  • PA_RESOURCE_TXN_ATTRIBUTES — The attributes table that stores transactional characteristics associated with resources. The package inserts rows here to attach attribute detail to the resource records it creates.

The package also carries dependency references under the SYS and STANDARD schemas, representing standard PL/SQL runtime dependencies rather than Projects data objects.

Usage Notes

PA_RESOURCE_PKG is not intended for direct invocation by end users or by customer extension code. The ETRM metadata confirms that it is referenced by the following package:

Accordingly, PA_RESOURCE_PKG is normally invoked indirectly, by PA_R_PROJECT_RESOURCES_PVT and related Projects internal code, when resource or resource attribute records must be created. Typical invocation contexts include Projects forms and processes that manipulate project resources, concurrent programs that build or refresh resource data, and internal PL/SQL routines executing within the module. Because it is a private package with undocumented signatures and status VALID, customizations should call the supported public Projects APIs (such as PA_R_PROJECT_RESOURCES_PVT) rather than PA_RESOURCE_PKG directly, and any direct use risks incompatibility across EBS 12.1.1 and 12.2.2 upgrades.