Results for “create_element_lines”

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

Overview

PSB_WS_POS_PVT is a private PL/SQL package in the APPS schema that forms part of the Oracle E-Business Suite position management and costing engine within the PSB (Public Sector/Budgeting) product family. Its API classification is PVT, indicating that it is an internal, supporting package rather than a public interface. In Oracle EBS 12.1.1 and 12.2.2, the package provides the core procedural logic used to build, validate, cost, and revise position and element data used in workforce and salary planning. It manipulates position lines, FTE (full-time equivalent) lines, and account lines, and applies the parameters that drive element-level and position-level cost calculations. As a private package, PSB_WS_POS_PVT primarily serves the worksheets subsystem, exposing reusable logic to other PSB_WS_* packages.

Key Procedures and Functions

The ETRM metadata documents eighteen procedures and functions within this package. They fall into several functional groups:

• Validation and gatekeeping: CHECK_ALLOWED and VALIDATE_POSITIONS_CP verify whether a requested operation is permitted and validate position data before processing (the _CP suffix indicates a concurrent-program usable entry point).
• Line creation: CREATE_POSITION_LINES, CREATE_POSITION_MATRIX, CREATE_FTE_LINES, and CREATE_ELEMENT_LINES populate the position, matrix, FTE, and element line structures used by the worksheets.
• Costing and parameter application: CALCULATE_POSITION_COST computes position cost; APPLY_ELEMENT_PARAMETERS and APPLY_ELEMENT_PARAMETERS_CP apply element-level parameters; APPLY_POSITION_PARAMETERS applies position-level parameters.
• Projection and revision: REVISE_POSITION_PROJECTIONS, REVISE_POSITION_PROJECTIONS_CP, REVISE_ELEMENT_PROJECTIONS, and REVISE_ELEMENT_PROJECTIONS_CP recalculate forward-looking position and element projections.
• FTE maintenance: UPDATE_ANNUAL_FTE maintains the annual FTE figure, and REDISTRIBUTE_FOLLOW_SALARY redistributes salary across follow-on or successor positions.

No parameter lists are documented and none are asserted here; the descriptions above reflect the named intent of each program unit.

Tables Accessed

The package operates against three tables through APPS synonyms: PSB_WS_ACCOUNT_LINES, PSB_WS_FTE_LINES, and PSB_WS_LINES. These hold the account distribution, FTE, and general worksheet line records that the position-costing process reads and writes. The CREATE_* and REVISE_* procedures insert, update, or redrive lines in these tables, while the calculation and parameter-application routines derive cost and FTE values that are persisted back to them. The package also depends on FND_API for standard validation and concurrent-processing support, and on PSB_WS_ACCT1 for account-related logic.

Usage Notes

PSB_WS_POS_PVT is an internal dependency rather than a directly invoked API. It is referenced by seven other packages, including PSB_EXCEL2_PVT, PSB_WS_OPS_PVT, PSB_WS_POSITION_CPC_PVT, PSB_WS_POSITION_CR_LINES_I_PVT, PSB_WS_POSITION_FTE_I_PVT, PSB_WS_POSITION_FTE_O_PVT, PSB_WS_POSITION_RFS_PVT, and itself recursively. These callers are typically driven from EBS forms, concurrent programs, or external worksheet (Excel) integration layers. Custom code should not call the PVT package directly; instead the public-facing PSB_WS_* packages should be used, as PVT signatures may change between releases. When troubleshooting position or salary costing in 12.1.1 or 12.2.2, developers should confirm all dependent packages are VALID and that PSB_WS_ACCOUNT_LINES, PSB_WS_FTE_LINES, and PSB_WS_LINES contain consistent data.