Search Results pa_resource_mapping




Overview
Explore in AI Chat

Overview

PA_RESOURCE_MAPPING is an Oracle Applications (APPS) PL/SQL package that supports the resource mapping infrastructure within Oracle Project Management and Oracle Project Resource Management. Its central business purpose is to resolve how a project resource — an expenditure type, event type, or inventory item — should be formatted, defaulted, and presented when resources are assigned to a project or resource list. The package acts as the rule engine that evaluates resource list formats, planning defaults, and precedence rules stored in the project accounting setup tables, and applies the appropriate format to a given resource. Through this mechanism, the package enables consistent rendering and selection of resources in project planning, resource list maintenance, and resource assignment pages.

The package carries a status of VALID in the APPS schema and is documented with an API classification of OTHER, indicating it is primarily an internal infrastructure package rather than a published, externally supported interface. Nevertheless, it is referenced by several other project applications packages, confirming that it plays a supporting role across the Project Management and Project Resource Management product family.

Key Procedures and Functions

ETRM documents two public program units within the package:

  • MAP_RESOURCE_LIST — Performs the core resource-to-list mapping operation. It applies the mapping rules defined for a resource list so that a given resource is associated with, or validated against, the correct resource list format and default definitions. This is the principal entry point for callers needing to determine the applicable mapping for a resource.
  • GET_FORMAT_PRECEDENCE — Returns the precedence applicable to a resource format. Because multiple format definitions and planning resource defaults can apply to the same resource, this function resolves the order in which those definitions take effect, allowing the caller to honor the highest-precedence format.

No parameter signatures are documented in the ETRM metadata; consumers should treat these as internal routines and avoid relying on their exact signatures across patch levels.

Tables Accessed

The package references the following tables via APPS synonyms, grouped by function:

Usage Notes

PA_RESOURCE_MAPPING is not intended for direct invocation from forms or concurrent programs. Instead, it is invoked indirectly by higher-level packages: PA_PLANNING_RESOURCE_UTILS, PA_RLMI_RBS_MAP_PUB, and PJI_FM_XBS_ACCUM_UTILS all reference this package, as does the package body itself. These callers operate within project planning, resource list maintenance, and cross-business-unit accumulation flows. Customizations should therefore prefer the calling APIs rather than PA_RESOURCE_MAPPING directly. Any modification of the underlying setup tables — resource lists, formats, or planning defaults — can alter the behavior of MAP_RESOURCE_LIST and GET_FORMAT_PRECEDENCE, so such configuration changes should be tested against the dependent packages.