Search Results update_versions

Overview

PA_RBS_HEADER_PVT is a private PL/SQL package in the APPS schema that implements the low-level business logic supporting Oracle E-Business Suite resource breakdown structure (RBS) header maintenance. RBS headers define the hierarchical grouping of resources used for project planning, budgeting, costing, and resource allocation. Because it is an API-classified private (PVT) package, PA_RBS_HEADER_PVT is not intended to be called directly by customer code; rather, it provides the internal create, update, and validation primitives that the public package PA_RBS_HEADER_PUB invokes on behalf of forms, concurrent programs, and other application modules. The package version is VALID in both EBS 12.1.1 and 12.2.2, and it references the view PA_RBS_HEADERS_V in addition to the base RBS tables.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions:

• INSERT_HEADER — Creates a new RBS header record, establishing the top-level resource breakdown structure definition.
• INSERT_VERSIONS — Inserts the initial version rows associated with a newly created RBS header, along with the required translated and language rows.
• INSERT_STRUCTURE_ELEMENT — Adds an individual element (node) to the RBS hierarchy, persisting the structural relationship between parent and child resources.
• UPDATE_HEADER — Modifies attributes of an existing RBS header, such as descriptive or status information.
• UPDATE_VERSIONS — Updates existing RBS version records, typically when a new version of the structure is published or revised.
• VALIDATE_RBS_FOR_ALLOCATIONS — Performs the validation checks required before an RBS can participate in resource allocation processing, confirming that the structure and versions are complete and usable.

Tables Accessed

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

• PA_RBS_HEADERS_S — primary store for RBS header definitions.
• PA_RBS_VERSIONS_B, PA_RBS_VERSIONS_S, PA_RBS_VERSIONS_TL — base, sequence, and translated tables holding RBS version data.
• PA_RBS_ELEMENTS, PA_RBS_ELEMENTS_S — base and sequence tables for individual RBS structural elements.
• PA_RBS_ELEMENT_IDENTIFIER_S — sequence source for element identifiers.
• FND_LANGUAGES — language reference used when creating translated (TL) records.

These accesses support the insert, update, and validation operations described above.

Usage Notes

Because PA_RBS_HEADER_PVT is a private package, it should never be invoked directly from custom code. The supported entry point is PA_RBS_HEADER_PUB, which the ETRM metadata confirms as one of the packages that reference PA_RBS_HEADER_PVT. PA_RBS_VERSIONS_PUB also calls into this private layer. In practice, RBS header creation and maintenance are driven from the Oracle Projects RBS setup forms and from resource allocation concurrent programs, both of which ultimately route through PA_RBS_HEADER_PUB and, in turn, PA_RBS_HEADER_PVT. The VALIDATE_RBS_FOR_ALLOCATIONS procedure is exercised when allocation processing requires assurance that the RBS structure is complete and version-consistent. Developers extending Oracle Projects should call PA_RBS_HEADER_PUB rather than this package, preserving Oracle's supported upgrade path across 12.1.1 and 12.2.2.