Search Results pa_rlmi_rbs_map_pub




Overview
Explore in AI Chat

Overview

APPS.PA_RLMI_RBS_MAP_PUB is a public PL/SQL package body in the Oracle E-Business Suite Projects (PA) module. It supports resource list mapping and Resource Breakdown Structure (RBS) generation for project resource planning and budgeting. The package maps resource list members (RLMI) to RBS elements, populating temporary staging tables and pushing RBS versions into the planning schema. Its dependencies show heavy interaction with resource classes, resource lists, resource assignments, budget versions, and financial plan configuration.

Key Procedures and Functions

  • MAP_RLMI_RBS — the main entry point that orchestrates the mapping of resource list members to RBS structures.
  • INIT_REQDVARIABLES — initializes required variables and setup context for the mapping process.
  • POPULATE_RBSMAP_TMP — populates the RBS mapping temporary table used during processing.
  • POPULATE_RESMAP_TMP — populates the resource mapping temporary table.
  • POPULATE_RESRBSMAP_OUTTBLS — populates the output tables with resource-to-RBS mapping results.
  • PUSH_RBS_VERSION — pushes the constructed RBS version data into the target RBS version tables.

Seven documented procedures/functions support the overall workflow, from initialization through staging to final RBS version creation.

Tables Accessed

The package reads and writes core Project resource, budgeting, and financial planning tables. It references PA_RESOURCE_LISTS_ALL_BG, PA_RESOURCE_LIST_MEMBERS, PA_RESOURCE_CLASSES_B, and PA_RESOURCE_ASSIGNMENTS to resolve resource definitions. Budgeting and planning context comes from PA_BUDGET_VERSIONS, PA_PROJ_FP_OPTIONS, PA_FIN_PLAN_TYPES_TL, and PA_PROJ_ELEMENT_VERSIONS. RBS-specific structures include PA_RBS_MAPPING, PA_RBS_VERSIONS_B, PA_RBS_VERSIONS_V, and the temporary tables PA_RBS_PLANS_IN_TMP, PA_RBS_PLANS_OUT_TMP, PA_RES_LIST_MAP_TMP1, and PA_RES_LIST_MAP_TMP4. Additional lookups include PA_EXPENDITURE_CATEGORIES, PA_EXPENDITURE_TYPES, PA_EVENT_TYPES, PA_NON_LABOR_RESOURCES, PA_PLAN_RES_DEFAULTS, PA_PROJECTS_ALL, and MTL_ITEM_CATEGORIES.

Usage Notes

This package is invoked through Project resource planning and budgeting flows, typically from concurrent programs or supporting forms that generate RBS structures for financial plans. It leverages FND_API, FND_MSG_PUB, PA_DEBUG, and PA_INTERFACE_UTILS_PUB for error handling, messaging, and interface utilities. Custom extensions should call MAP_RLMI_RBS as the primary entry point, ensuring required setup variables are initialized. Developers extending or debugging the flow should be aware that the package is referenced by many other objects and depends on temporary staging tables, so concurrent execution and data cleanup require care.