Results for “psb_ws_pos3”

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

Overview

PSB_WS_POS3 is a private implementation package in the Oracle E-Business Suite HRMS/Payroll family, owned by APPS and classified under the generic "OTHER" API category. It belongs to the PSB module — the Position Control and Budgeting / Compensation Workbench infrastructure used by Oracle Human Resources and Oracle Payroll — and its name reflects its role as a worksheet-driven position and element processing engine (POS3 being the third member of the PSB_WS_POS series). The package supports the PSB worksheets feature, which lets compensation and budget administrators model position hierarchies, distribute budget amounts, and apply compensation elements against those positions before committing the data back to payroll and HR. Its current header revision is 120.4, dated 07-Apr-2006, and the earliest documented procedures were created in December 1997, indicating a long-lived component carried forward unchanged into EBS 12.1.1 and 12.2.2.

The package follows the standard EBS API conventions: procedures accept p_api_version and p_validation_level inputs and return a p_return_status OUT parameter, with defaults drawn from FND_API such as G_VALID_LEVEL_NONE, G_MISS_CHAR, and G_MISS_NUM.

Key Procedures and Functions

• APPLY_ELEMENT_PARAMETERS — Applies element-level parameters to a worksheet, driving the element side of a budgeting exercise.
• APPLY_POSITION_PARAMETERS — Applies position-level parameters to a worksheet, driving the position side of the same exercise.
• APPLY_ELEMENT_CONSTRAINTS / APPLY_POSITION_CONSTRAINTS — Evaluate constraint formulas against elements and positions respectively.
• PROCESS_ELEMCONS_DETAILED — Detailed processing of element constraint results, producing per-row diagnostics.
• PROCESS_ELEMPARAM, PROCESS_ELEMPARAM_AUTOINC — Apply element parameters, with the AUTOINC variant handling automatic increment / spreading logic.
• PROCESS_POSPARAM, PROCESS_POSPARAM_DETAILED, PROCESS_POSPARAM_AUTOINC — The position equivalents: bulk parameter application, detailed row-level processing, and automatic increment handling.
• REDISTRIBUTE_FOLLOW_SALARY — Redistributes budget amounts where a position follows a salary-based allocation rule.
• REVISE_POSITION_PROJECTIONS / REVISE_ELEMENT_PROJECTIONS — Recalculate projected position and element costs after worksheet changes.
• GET_DEBUG — Returns the current debug flag state for diagnostic tracing.

Tables Accessed

The package reads and writes the PSB worksheet and budget tables, including PSB_WORKSHEETS, PSB_BUDGET_PERIODS, PSB_BUDGET_POSITIONS, PSB_BUDGET_REVISION_POSITIONS and PSB_BUDGET_REVISION_POS_LINES. It resolves configuration through PSB_PARAMETER_FORMULAS, PSB_CONSTRAINT_FORMULAS and PSB_SET_RELATIONS, and reads position and assignment context from PSB_POSITIONS and PSB_POSITION_ASSIGNMENTS. Payroll element data comes from PSB_PAY_ELEMENTS, PSB_PAY_ELEMENT_OPTIONS and PSB_PAY_ELEMENT_RATES. PSB_ENTITY provides entity lookup and PSB_ERROR_MESSAGES supplies message text for error reporting. All access is through APPS synonyms.

Usage Notes

PSB_WS_POS3 is not a public API and is not intended for direct customer invocation. It is called internally by the PSB worksheet UI — typically the Compensation Workbench and position budgeting forms — and by the concurrent programs that finalize worksheet data into budget revisions and payroll element entries. The documented metadata shows the package is referenced by four other PL/SQL packages, confirming its role as a shared internal service layer. Custom code should treat it as unsupported and instead use the supported public APIs in the same module; upgrades between 12.1.1 and 12.2.2 carry the package forward unchanged because the header has not been revised since 2006.