Search Results per_pos_bgt_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_POS_BGT_PKG is a PL/SQL package body in the Oracle E-Business Suite APPS schema that supports position and assignment budgeting within Oracle Human Resources (PER). Its metadata classifies it as a non-public API (OTHER) that is not referenced by any other database object, indicating it functions as a private, functionally specific utility rather than a shared enterprise interface. The package exposes seven documented procedures and functions, all of which are oriented toward resolving and populating budget-related values for holders of assignments, positions, and budget elements.

At a functional level, the package provides the logic required to identify which people or assignments occupy a given position during a budgeting period, retrieve the associated budget value for that period, and determine the period boundaries themselves. This supports HR budget administration activities such as position control, headcount costing, and assignment-level budget allocation, where the correct budget element and effective period must be determined for each assignment before a value can be derived. In Oracle EBS 12.1.1 and 12.2.2, the package continues to be published as VALID in the APPS schema.

Key Procedures and Functions

The package contains the following documented program units:

  • GET_HOLDERS — Resolves the holders (people or assignments) associated with a position or budget context. It is used to determine the population of assignment records to which budget values apply.
  • GET_BUDGET_VALUE — Returns the budget value associated with a given assignment, position, or budget element for the applicable period. This is the core retrieval function for budgeted amounts.
  • GET_PERIOD_START — Determines the start date of the budgeting period or effective date range that applies to the budget calculation.
  • GET_PERIOD_END — Determines the end date of the budgeting period or effective date range, complementing GET_PERIOD_START to define the effective window.
  • GET_STARTERS — Identifies assignments or people that started within the budget period, used to correctly prorate or attribute budget values to new joiners.
  • GET_LEAVERS — Identifies assignments or people that left within the budget period, used to correctly prorate or attribute budget values to leavers.
  • POPULATE_FIELDS — Populates the derived budget and position fields, orchestrating the calls to the getter functions and applying the results to the appropriate structures or tables.

No parameter lists are reproduced here because the ETRM metadata does not document signatures; callers should inspect the package specification before invoking these units directly.

Tables Accessed

The documented dependencies show the package reading from the following HR budget and assignment tables (via APPS synonyms):

  • PER_ASSIGNMENT_BUDGET_VALUES_F — The effective-dated table storing budget values per assignment; the primary source of budgeted amounts.
  • PER_BUDGET_VALUES — The budget value definition table that underpins budget elements and their values.
  • PER_BUDGET_ELEMENTS — Defines the budget elements (such as salary, grade, or position cost) to which values are attached.
  • PER_ASSIGNMENT_STATUS_TYPES — Provides assignment status classification used to determine starters, leavers, and current holders.

Additional dependencies include PER_ALL_ASSIGNMENTS, PER_ALL_PEOPLE, PER_ASSIGNMENTS_F, and HR_UTILITY, which supply the person, assignment, and general validation utilities required to resolve holders and period boundaries. The package does not appear to write to these tables; its role is largely derivation and population.

Usage Notes

Because PER_POS_BGT_PKG is not referenced by any other database object, it is not part of a shared call chain. It is typically invoked from HR budget-related forms, concurrent programs, or custom PL/SQL that needs to resolve position and assignment budget values. Typical triggers include position budgeting and headcount costing processes where the effective period must be established and starter/leaver populations correctly attributed.

When extending or calling this package, note that it is an internal APPS utility rather than a public API, so direct invocation should be avoided where standard HR budget APIs exist. Any custom callers must respect the effective dating of PER_ASSIGNMENT_BUDGET_VALUES_F and PER_ASSIGNMENTS_F, and should call POPULATE_FIELDS rather than the individual getters to ensure consistent results.