Search Results pa_rbs_headers

Overview

PA_RBS_HEADERS_PKG is a table handler package in the Oracle E-Business Suite Projects (PA) module that manages the persistence of Resource Breakdown Structure (RBS) header records. The RBS is a hierarchical classification of resources used within Oracle Projects for planning, budgeting, costing, and allocation. The header defines the top-level identity of a resource breakdown structure, including its name, effective date range, business group ownership, and whether the structure may be used for allocation purposes. This package, owned by APPS, encapsulates the insert, update, and translation-maintenance logic for the PA_RBS_HEADERS_B and PA_RBS_HEADERS_TL tables, shielding callers from the physical data model and from multi-language support (MLS) conventions. Its header comment identifies it explicitly as a table handler for the PA_RBS_HEADERS table, meaning its role is to provide discrete, well-defined operations rather than business validation, which remains the responsibility of higher-level private APIs.

Key Procedures and Functions

• INSERT_ROW — Creates a new RBS header. This procedure inserts the base row into PA_RBS_HEADERS_B and the corresponding translated row into PA_RBS_HEADERS_TL. It accepts the RBS header identifier, name, description, effective-from date, effective-to date, the use-for-allocation flag, and the business group identifier. Audit columns such as creation date, created by, last update date, last updated by, login, and record version number are populated internally using SYSDATE and FND_GLOBAL. The API is documented as being invoked from the PA_RBS_HEADER_PVT package, specifically the Insert_Header procedure.
• UPDATE_ROW — Modifies an existing RBS header, updating the base and translated records and maintaining the WHO columns and record version number. This supports the standard EBS concurrency and audit model for the table.
• ADD_LANGUAGE — Inserts a new language row into PA_RBS_HEADERS_TL for a given RBS header, enabling the MLS-based translated name and description to exist in an additional installed language. This follows the conventional EBS table-handler pattern for translation tables.

Tables Accessed

• PA_RBS_HEADERS_B — The base table holding language-independent RBS header attributes: header identifier, effective dates, business group identifier, and the use-for-allocation flag, along with standard audit columns.
• PA_RBS_HEADERS_TL — The translation table holding language-specific name and description values, keyed by language and RBS header identifier.
• FND_LANGUAGES — Read to validate or resolve installed languages, typically referenced in the ADD_LANGUAGE routine to confirm a language may be added for translation.

Usage Notes

This package is an internal repository-layer component and is not intended for direct invocation from forms or concurrent programs. The documented caller is PA_RBS_HEADER_PVT, the private API that presents higher-level, validated operations such as header creation for the Resource Breakdown Structure. Application forms and public APIs therefore exercise PA_RBS_HEADERS_PKG indirectly through that private layer. Given that it is referenced by only one other package and is classified as an OTHER API, custom integrations should avoid calling INSERT_ROW, UPDATE_ROW, or ADD_LANGUAGE directly; doing so would bypass the business rules enforced upstream. Where direct table access is unavoidable, callers must ensure the RBS header identifier is unique, that the business group is valid, that effective date ranges do not overlap improperly, and that both the _B and _TL rows are maintained in step to preserve MLS consistency.