Search Results get_holders

Overview

PER_POS_BGT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Human Resources (PER) module and provides the server-side logic that supports position budgeting and position incumbent analysis within Oracle HRMS. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the definer. This is consistent with the standard Oracle EBS practice for packages that must respect the security profile and session context of the calling application, such as the business group and organization identifiers passed into its procedures.

The primary business function of the package is to answer workforce planning questions about a position: who currently holds it, what budgeted value is associated with it, and how the headcount of the position moves across a defined time period. Functions such as starters, leavers, and period start/end counts allow HR and budgeting users to analyze position strength at points in time and to reconcile movement within a budget period.

Key Procedures and Functions

• GET_HOLDERS — Calculates the number of people holding a given position. It returns the holder name and employee number to the output parameters when exactly one holder exists, and returns an appropriate message when the holder count is zero or greater than one.
• GET_BUDGET_VALUE — Returns the budgeted value for a position, along with the associated budget value identifier, using the position, budget version, and time period as inputs.
• GET_PERIOD_START — Returns the count of the position as of the start date for the selected period.
• GET_PERIOD_END — Returns the count of the position as of the end date for the selected period. This is the procedure most commonly associated with the search term "get_period_end," and is typically used to obtain a point-in-time position strength figure at period close.
• GET_STARTERS — Calculates the number of persons attaining a position within a period (period movement in).
• GET_LEAVERS — Calculates the number of persons leaving a position within a period (period movement out).
• POPULATE_FIELDS — Populates derived or display fields, likely used to support a form or report that presents position budget data.

Note that procedure signatures, including datatypes, were revised from VARCHAR2 to DATE for date parameters (X_START_DATE and X_END_DATE) under Bug 572545, dated 31-10-1997. Custom integrations should assume DATE typing for these parameters.

Tables Accessed

Through APPS synonyms, the package references the following base tables:

• PER_ASSIGNMENT_BUDGET_VALUES_F — Stores assignment-level budget values; used by procedures that determine budgeted amounts and period movement counts.
• PER_ASSIGNMENT_STATUS_TYPES — Defines valid assignment statuses; used to identify active versus terminated assignments for holder, starter, and leaver calculations.
• PER_BUDGET_ELEMENTS — Defines budget element entries that group position budget data.
• PER_BUDGET_VALUES — Holds the budget values themselves; used by GET_BUDGET_VALUE and related procedures.

Usage Notes

The package is an internal HRMS server-side utility rather than a public API. It is most commonly invoked from Oracle HRMS forms and concurrent programs that present position budget and establishment information, and its procedures can be called from custom PL/SQL when the caller requires period-based position counts or budget values. Because it uses AUTHID CURRENT_USER, callers must have appropriate privileges on the referenced tables and must supply valid business group and organization identifiers. The package is referenced by zero other documented packages, so it is typically called directly rather than through a wrapper API.