Search Results fetch_rbs_element

Overview

PA_RBS_PUB is a public PL/SQL package in the Oracle E-Business Suite (EBS) Applications schema (APPS) that manages Resource Breakdown Structures (RBS) for Oracle Projects. An RBS defines the hierarchical structure of resource types and resources that may be assigned to projects, and is a prerequisite for project resource planning, budgeting, and cost collection. The package exposes a public API for creating, updating, loading, and maintaining RBS definitions and versions, allowing both internal Oracle Projects flows and external or custom code to manipulate RBS data in a controlled, supported manner. It is documented for EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes 15 documented procedures/functions. Their purposes are as follows:

• INIT_RBS_PROCESSING — Initializes internal processing state for an RBS operation, preparing global structures and context before the main work occurs.
• CREATE_RBS — Creates a new RBS definition, including header and associated version data.
• UPDATE_RBS — Modifies an existing RBS definition.
• LOAD_RBS_HEADER — Loads the RBS header record (name, description, and related attributes) into the working structures or tables.
• LOAD_RBS_VERSION — Loads version-level information for an RBS.
• LOAD_RBS_ELEMENTS — Loads the individual elements (nodes) that make up the RBS hierarchy.
• FETCH_RBS_HEADER — Retrieves an RBS header for a specified RBS.
• FETCH_RBS_VERSION — Retrieves version data for an RBS.
• FETCH_RBS_ELEMENT — Retrieves an individual RBS element.
• EXEC_CREATE_RBS — Executes the full create-RBS workflow, orchestrating the load and insert operations.
• EXEC_UPDATE_RBS — Executes the full update-RBS workflow.
• COPY_RBS_WORKING_VERSION — Copies a working version of an RBS, supporting version duplication.
• FREEZE_RBS_VERSION — Freezes an RBS version, preventing further modification and establishing a baseline.
• ASSIGN_RBS_TO_PROJECT — Associates an RBS with a project so the project can use the defined resource structure.
• POPULATEERRORSTACK — Records error messages into the error stack for diagnostics and message reporting.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

• PA_RBS_HEADERS_B / PA_RBS_HEADERS_TL — Base and translation tables storing RBS header definitions.
• PA_RBS_VERSIONS_B / PA_RBS_VERSIONS_TL — Base and translation tables storing RBS version data.
• PA_RBS_ELEMENTS — Stores individual RBS element/node records.
• PA_RBS_ELEMENT_MAP — Maps elements within the RBS structure.
• PA_RBS_NODES_TEMP — Temporary staging table used during RBS node loading/processing.
• PLITBLM — Standard PL/SQL index-by table used for communication/integration purposes.

Usage Notes

PA_RBS_PUB is invoked from Oracle Projects forms, concurrent programs, and custom integrations that need to define or maintain resource breakdown structures. The CREATE_RBS and UPDATE_RBS APIs, together with EXEC_CREATE_RBS and EXEC_UPDATE_RBS, encapsulate the standard create/update workflow, so callers should prefer these entry points rather than inserting directly into the underlying tables. ASSIGN_RBS_TO_PROJECT links a defined RBS to a project. The package is referenced by zero other packages (Referenced by 0), so it functions as an entry-point API exposed to callers rather than an internal dependency. Applications should call the public APIs and rely on POPULATEERRORSTACK for error handling.