Search Results pa_rbs_versions_pvt




Overview
Explore in AI Chat

Overview

APPS.PA_RBS_VERSIONS_PVT is a private PL/SQL package body within the Oracle E-Business Suite Projects (PA) module responsible for managing the lifecycle of Resource Breakdown Structure (RBS) versions. An RBS defines the hierarchical categorization of resources — people, organizations, and roles — used in project planning, budgeting, and reporting. Versioning allows the structure to evolve over time while preserving historical definitions for audit, comparison, and reporting continuity. This package encapsulates the low-level logic for creating working (draft) versions, promoting or copying frozen versions, and manipulating the reporting flags associated with individual RBS elements. As a PVT (private) API, it is not exposed for direct external invocation but is called internally by other PA components and by three documented packages. The source header (PARBSVVB.pls, version 120.1) indicates the file has been stable since 2005, with the same body shipped in both 12.1.1 and 12.2.2.

Key Procedures and Functions

  • CREATE_WORKING_VERSION_RECORD — Inserts a new "working" (draft) version row for an RBS header, delegating the physical insert to PA_RBS_VERSIONS_PKG.Insert_Row. It accepts version identity, header, name, description, start and end dates, job group, rule-based and validated flags, status code, and creation audit columns, returning the new record version number, RBS version ID, and any error message.
  • UPDATE_WORKING_VERSION — Modifies an existing draft version's attributes prior to freezing or publishing.
  • DELETE_WORKING_VERSION — Removes a draft version that is no longer required, typically before it has been frozen or referenced.
  • CREATE_NEW_WORKING_VERSION — Generates a fresh draft version, commonly derived from an existing frozen version, to begin a new edit cycle.
  • COPY_FROZEN_RBS_VERSION — Duplicates a frozen (immutable) version header into a new working version so that controlled changes can be made against a known baseline.
  • COPY_FROZEN_RBS_ELEMENTS — Copies the constituent elements belonging to a frozen version into the corresponding working version, preserving the RBS hierarchy.
  • SET_REPORTING_FLAG — Toggles the reporting indicator on RBS elements, controlling which elements are included in resource reporting.

Tables Accessed

The package operates across the RBS schema family:

All access is via APPS synonyms, consistent with the standard EBS data model and Multi-Org/MLS translation architecture.

Usage Notes

Because this is a PVT package, it is invoked indirectly. Typical callers are the RBS maintenance forms (Projects responsibility) when users create or edit resource breakdown structures, and internal PA packages during project setup, budget versioning, and reporting configuration. The package participates in the standard EBS concurrency and audit model, populating CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN from package globals and honoring WHO columns. Custom code should never call PA_RBS_VERSIONS_PVT directly; developers requiring RBS version manipulation should use the corresponding public API or the documented parent packages. As with all RBS changes, modifications made through these procedures must be committed by the calling transaction.