Search Results get_element_id

Overview

APPS.PER_PAY_PROPOSALS_POPULATE is a PL/SQL package within the Oracle E-Business Suite Human Resources (PER) and Payroll (PAY) application modules. Its principal business function is to populate and derive the default values, salary basis attributes, element entry references, and grade-related amounts required when salary proposals are created or modified through the Salary Proposal and Grade/Progression functionality in Oracle HRMS. The package encapsulates the server-side logic that a user sees pre-populated on the Salary Proposal form, including currency, formatting, salary basis, payroll, annualization factors, grade ranges, previous salary, and element entry identifiers. In effect, it centralises the derivation of proposal defaults so that the same calculations are consistently applied across forms, concurrent processes, and any custom code that performs comparable work.

Key Procedures and Functions

The package exposes eleven documented procedures. Each is described below by purpose only.

• GET_GRADE — Returns the grade value applicable to an assignment along with the minimum, maximum, and midpoint salary amounts and the associated grade unit of measure for a given date, assignment, and business group.
• GET_ELEMENT_ID — Identifies the payroll element associated with a given assignment, business group, and change date, returning the payroll value and the applicable element entry identifier. This is the procedure most commonly inspected when users search for "get_element_id," since it bridges the salary proposal to the underlying element entry that will receive the approved salary amount.
• GET_CURRENCY_FORMAT — Derives the display format string for a supplied currency code, ensuring that monetary amounts on the proposal are rendered according to the currency's conventions.
• GET_NUMBER_FORMAT — Returns the number format string used to render numeric values consistently on the proposal.
• GET_DEFAULTS — The principal driver procedure. It populates the full set of default attributes for a proposal, including date, business group, currency, format string, salary basis and pay basis names and values, annualization factors, grade, grade annualization factor, grade amounts, previous salary, last change date, element entry identifier, a basis-changed indicator, and the salary and grade units of measure.
• GET_BASIS_DETAILS — Retrieves salary basis and pay basis details effective on a given date for an assignment, including currency, basis names, pay basis, annualization factors, grade basis, grade annualization factor, and element type identifier.
• GET_PREV_SALARY — Determines the employee's previous salary value relative to the proposal, used for comparison and progression calculations.
• GET_PAYROLL — Resolves the payroll to which the assignment belongs, supporting defaulting of the payroll value on the proposal.
• GET_HOURS — Returns the assignment's hours, typically for deriving or validating salary on an hourly basis.
• GET_ASG_HOURS — Returns the hours specifically associated with the assignment record, distinguishing assignment-level hours from other hour sources.
• GET_NORM_HOURS — Returns the normal (full-time equivalent) hours used to normalise salary amounts for part-time or FTE-sensitive calculations.

Tables Accessed

The package operates through APPS synonyms over the following base and interface tables:

• PER_ALL_ASSIGNMENTS_F — The primary source of assignment-level data (payroll, hours, grade, salary basis context) for the input assignment identifier.
• PER_PAY_PROPOSALS — The salary proposal table that the package ultimately supports populating or defaulting.
• PER_PAY_BASES — Supplies salary basis definitions such as annualization factors and basis names.
• PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F — Provide the element entry and its current values, underpinning GET_ELEMENT_ID and previous-salary logic.
• PAY_ELEMENT_TYPES_F and PAY_INPUT_VALUES_F — Define the element types and their input values used when identifying the salary element.
• PAY_ALL_PAYROLLS_F — Source for payroll resolution.
• PAY_GRADE_RULES_F — Supplies grade progression rules associated with grade and salary calculations.
• HR_ALL_POSITIONS_F and HR_ORGANIZATION_INFORMATION — Position and organisation attributes that influence grade and payroll defaulting.
• PER_TIME_PERIOD_TYPES — Used to interpret payroll periodicity for annualization and salary basis computations.

Usage Notes

PER_PAY_PROPOSALS_POPULATE is invoked internally by the Oracle HRMS Salary Proposal and Grade/Progression forms to default field values when a user initiates or edits a proposal. It is also referenced by nine other packages, indicating reuse across related compensation and payroll defaulting processes. While Oracle does not document the package as a public API, developers frequently call GET_ELEMENT_ID directly to determine the element entry associated with an assignment for a given change date, particularly in extensions that write salary changes programmatically. Because the procedure signatures use OUT NOCOPY parameters and depend on effective-dated assignment and element data, custom callers must supply a valid assignment, business group, and effective date to obtain meaningful results. Any custom usage should be treated as an unsupported dependency on internal Oracle code, since method signatures may change between EBS releases such as 12.1.1 and 12.2.2.