Search Results map_resource_list

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:

• Resource formatting and lists: PA_RES_FORMATS_B, PA_PLAN_RL_FORMATS, and PA_RESOURCE_LISTS_ALL_BG hold the base format definitions, planning resource list formats, and resource list headers used to derive formatting and mapping.
• Planning defaults and precedence: PA_PLAN_RES_DEFAULTS and PA_ACT_PRL_PRECEDENCE supply the default planning resource values and the precedence rules resolved by GET_FORMAT_PRECEDENCE.
• Resource classification: PA_RESOURCE_CLASSES_B identifies resource classes; PA_EXPENDITURE_TYPES and PA_EVENT_TYPES identify the resource types being mapped; MTL_ITEM_CATEGORIES links inventory items to categories where item-based resources are involved.
• Temporary working storage: PA_RES_LIST_MAP_TMP1 and PA_RES_LIST_MAP_TMP3 are temporary structures used during the mapping process, and PLITBLM is the standard Oracle PL/SQL integer-table type used for bulk set operations. DUAL provides scalar evaluation.

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.