Search Results pa_rbs_header_pub




Overview
Explore in AI Chat

Overview

PA_RBS_HEADER_PUB is a public PL/SQL API package in the APPS schema that supports the Resource Breakdown Structure (RBS) feature within Oracle Projects. An RBS defines the hierarchical structure of resources—such as people, organizations, and roles—used for planning, budgeting, and forecasting activity. This package provides the programmatic interface for creating and maintaining the header-level records that identify each RBS definition and its associated versions.

The package is classified as a public (PUB) API, indicating it is intended for use by external callers rather than as a purely internal implementation utility. It conforms to the Oracle Application Object Library API conventions, depending on FND_API for standard error handling, message retrieval, and the G_MISS constants used to signal unspecified attribute values. The package status is VALID in the documented environment, confirming that both the specification and body compile successfully against their dependencies.

Key Procedures and Functions

The documented interface exposes two procedures, both concerned with the lifecycle of RBS header records:

  • INSERT_HEADER — Creates a new RBS header definition. Invoking this procedure persists a new resource breakdown structure in the repository, establishing its identifying attributes and establishing the version context under which resources will subsequently be organized. It is the entry point for introducing a new RBS into an Oracle Projects implementation.
  • UPDATE_HEADER — Modifies the attributes of an existing RBS header. This procedure is used when the descriptive or controlling information associated with an RBS definition must be changed, while preserving the underlying structure and its historical versions.

Both procedures follow the standard API pattern of returning a success or failure status along with any applicable error messages, rather than raising unhandled exceptions to the calling environment.

Tables Accessed

The package writes to and reads from three base tables through APPS synonyms:

  • PA_RBS_HEADERS_B — The base table holding the primary header records for each resource breakdown structure. INSERT_HEADER and UPDATE_HEADER operate on this table as their principal target.
  • PA_RBS_HEADERS_TL — The translation table storing language-specific, user-facing text for RBS headers. Because RBS names and descriptions may be displayed in multiple languages, the API maintains the corresponding translated rows alongside the base record.
  • PA_RBS_VERSIONS_B — The versions table, which associates each RBS header with one or more numbered versions. The API references this table to maintain the relationship between an RBS definition and its version history, ensuring that header changes remain consistent with versioning rules.

Usage Notes

PA_RBS_HEADER_PUB is typically invoked from Oracle Projects setup and maintenance flows, from custom extensions that automate RBS definition, and from other Oracle Projects packages. The dependency metadata shows that PA_RBS_PUB references PA_RBS_HEADER_PUB, indicating that the broader RBS public API layer delegates header-level operations to this package. The package also references itself in the dependency listing, reflecting internal calls between its specification and body.

Because the package is a public API, custom code should call INSERT_HEADER and UPDATE_HEADER rather than performing direct DML against PA_RBS_HEADERS_B, PA_RBS_HEADERS_TL, or PA_RBS_VERSIONS_B. Direct manipulation bypasses the validation, translation handling, and version consistency logic embedded in the API and may leave the RBS data in an inconsistent state. As with all Oracle EBS public APIs, callers should check the returned status and inspect the error message stack on failure. The behavior described here is consistent across Oracle EBS 12.1.1 and 12.2.2.