Search Results pa_rbs_headers_pkg




Overview
Explore in AI Chat

Overview

PA_RBS_HEADERS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Resource Breakdown Structure (RBS) functionality of Oracle Projects. The RBS is the mechanism by which Oracle Projects organizes and groups project resources — people, organizations, roles, and other resource types — into a hierarchical reporting and planning structure used by costing, budgeting, and resource management processes.

This package operates as a data-access layer for the RBS header definition itself. Rather than containing the heavy business validation logic that governs RBS creation and maintenance (which resides in the companion private package PA_RBS_HEADER_PVT), PA_RBS_HEADERS_PKG performs the low-level, multi-language-aware persistence operations against the RBS header base and translation tables. In the layered architecture typical of Oracle Projects, the public "headers" package writes the physical rows, while the private "PVT" package enforces business rules, security, and transactional control. This separation keeps the DML layer reusable and consistent, particularly for the language-specific handling required when a resource breakdown structure is created or modified in a multilingual environment.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new Resource Breakdown Structure header record. The procedure creates the base row in PA_RBS_HEADERS_B and the corresponding translated/descriptive row in PA_RBS_HEADERS_TL, ensuring the identifying and language-independent attributes of the RBS header are persisted correctly.
  • UPDATE_ROW — Updates an existing RBS header definition. This procedure maintains changes to the translatable attributes of the RBS header, updating the appropriate language rows in the translation table while leaving the base record consistent with them.
  • ADD_LANGUAGE — Populates translated rows for a language that does not yet have a corresponding record. It is used when a new language is installed or enabled, so that existing RBS headers acquire description rows for that language and remain usable across the installation.

Detailed parameter signatures are not published in the ETRM extract; callers should reference the package specification in the database for exact argument lists before invoking these procedures directly.

Tables Accessed

  • PA_RBS_HEADERS_B — The base (language-independent) table holding the RBS header rows. INSERT_ROW and UPDATE_ROW write the core RBS header attributes here.
  • PA_RBS_HEADERS_TL — The translation table holding language-specific descriptive columns for each RBS header. INSERT_ROW, UPDATE_ROW, and ADD_LANGUAGE maintain these rows.
  • FND_LANGUAGES — The Oracle Application Object Library language definition table. It is referenced to resolve the set of installed/active languages, principally supporting ADD_LANGUAGE and language-aware DML.

Usage Notes

PA_RBS_HEADERS_PKG is not intended as a public, standalone API. It is invoked internally by Oracle Projects code — most directly by PA_RBS_HEADER_PVT, which is documented as referencing this package — on behalf of the Resource Breakdown Structure maintenance forms and related programs in the Oracle Projects module. The documented dependency set confirms this direction of use: PA_RBS_HEADERS_PKG references only SYS.STANDARD among external objects, and is referenced by PA_RBS_HEADERS_PKG and PA_RBS_HEADER_PVT.

Delivered Oracle Projects forms generally do not call this package directly; users create and maintain RBS headers through the standard RBS setup windows, and the form-level processing delegates to the private package, which in turn delegates the physical DML to this package. Its relevance in Oracle EBS 12.1.1 and 12.2.2 remains the same, as the RBS data model is stable across these releases. Custom code should avoid direct calls to INSERT_ROW, UPDATE_ROW, or ADD_LANGUAGE, since bypassing PA_RBS_HEADER_PVT skips validation, concurrency control, and translation consistency checks. Where automated loading of RBS headers is required, Oracle Projects' supported APIs or concurrent programs should be preferred, with this package treated strictly as an internal implementation detail.