Results for “revise_position_projections”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSB_WS_POS_PVT is a private PL/SQL package body owned by APPS in Oracle E-Business Suite. It belongs to the Oracle Public Sector Budgeting / Position Budgeting product family (the PSB module) and is classified as a private API (PVT), meaning it is intended for internal consumption by the product's own code rather than as a publicly supported integration interface. The package encapsulates the core business logic for validating, creating, costing, and revising position and element projections within a position worksheet. It is the procedural engine behind worksheet-level position budgeting operations: it verifies whether a position budget group may be used against a given worksheet, generates position lines and their associated matrix and FTE (full-time equivalent) records, applies element and position parameters, projects costs, and recalculates annualized salary figures. Because the source header carries a $Header tag consistent with the 12.1.x/12.2.x code line, the package is present in both Oracle EBS 12.1.1 and 12.2.2 environments, with the same internal structure.

Key Procedures and Functions

The package exposes eighteen documented program units, all of which are internal and support the worksheet position-building lifecycle. The most relevant to the search term validate_positions_cp is VALIDATE_POSITIONS_CP, the concurrent-program-oriented entry point that performs validation of position data before downstream costing or projection steps proceed.

• CHECK_ALLOWED — determines whether a specified worksheet and position budget group combination is permitted. It opens with a standard FND_API.Compatible_API_Call check, initializes the message list conditionally, delegates to the private PSB_WS_POS1 implementation, and returns a Boolean-style VARCHAR2 result via the standard FND message stack.
• CREATE_POSITION_LINES, CREATE_POSITION_MATRIX, CREATE_FTE_LINES, CREATE_ELEMENT_LINES — populate the worksheet with position, matrix, FTE, and element line records respectively.
• UPDATE_ANNUAL_FTE — recalculates and updates annualized FTE values on existing lines.
• REDISTRIBUTE_FOLLOW_SALARY — spreads salary amounts across periods or positions following salary-linked distribution rules.
• APPLY_ELEMENT_PARAMETERS and APPLY_ELEMENT_PARAMETERS_CP — apply element-level parameters, with the _CP variant sized for concurrent program processing.
• APPLY_POSITION_PARAMETERS — applies position-level parameters to worksheet rows.
• CALCULATE_POSITION_COST — computes the cost of a position for the worksheet.
• REVISE_POSITION_PROJECTIONS and REVISE_POSITION_PROJECTIONS_CP — adjust position projections, with the _CP variant for set-based concurrent execution.
• REVISE_ELEMENT_PROJECTIONS and REVISE_ELEMENT_PROJECTIONS_CP — adjust element projections for the worksheet, again with a concurrent-program variant.
• VALIDATE_POSITIONS_CP — validates positions in a worksheet or position budget group, typically invoked from a concurrent program before projections are calculated.

The _CP suffix denotes program units written for set-based, concurrent-program invocation rather than for single-row form interactions.

Tables Accessed

The package operates against three APPS synonyms: PSB_WS_ACCOUNT_LINES, PSB_WS_FTE_LINES, and PSB_WS_LINES. Together these form the worksheet staging model. PSB_WS_LINES holds the primary worksheet line rows — positions and elements — that the create, apply, and revise routines write. PSB_WS_FTE_LINES stores FTE and annualized salary detail, updated by UPDATE_ANNUAL_FTE and the FTE creation and revision routines. PSB_WS_ACCOUNT_LINES carries the account distribution or costing detail that CALCULATE_POSITION_COST and the projection revisions read and adjust. Validation routines such as VALIDATE_POSITIONS_CP read across all three structures to confirm consistency before cost roll-ups occur.

Usage Notes

Because PSB_WS_POS_PVT is classified PVT and is referenced by seven other packages, it is not called directly from the OA Framework or Forms layer in normal operation. It is invoked by the public position-budgeting APIs and by concurrent programs — notably the _CP functions — during worksheet generation, validation, and cost calculation. Developers extending Position Budgeting should call the public API wrappers rather than this package, and any direct dependency on PSB_WS_POS_PVT should be treated as unsupported and regression-tested on upgrades from 12.1.1 to 12.2.2.