Search Results per_pay_proposals_populate




Overview
Explore in AI Chat

Overview

The APPS.PER_PAY_PROPOSALS_POPULATE package body is a PL/SQL utility in Oracle E-Business Suite (12.1.1 / 12.2.2) that supports the Salary Management and Pay Proposals functionality within Oracle Human Resources / Oracle Payroll. Its core business function is to gather, derive, and populate the data attributes required to build and display pay proposals — the records generated when a manager, HR administrator, or compensation planner proposes a new salary, grade, or element entry for an assignment. The package handles the assembly of default values such as salary basis details, currency and numeric formatting, prior salary, payroll context, working hours, and grade-derived salary ranges. These derived values feed the pay proposal forms and workflows so that proposal lines can be created with accurate, context-sensitive defaults. The package is classified as a supporting (OTHER) API rather than a public interface, and it is referenced by nine other packages, indicating it acts as a shared population layer for the compensation proposal subsystem.

Key Procedures and Functions

The package exposes eleven documented procedures and functions:

  • GET_GRADE — Returns the grade, minimum salary, maximum salary, midpoint salary, and rate unit of measure applicable to a person based on date, assignment, and business group. As shown in the source, it joins assignment, pay basis, grade rules, and rate information, and returns no values when no grade is set for the date.
  • GET_ELEMENT_ID — Resolves the element type or element identifier associated with a proposal context.
  • GET_CURRENCY_FORMAT — Provides currency formatting attributes for displaying monetary proposal amounts.
  • GET_NUMBER_FORMAT — Provides numeric formatting attributes for displaying proposal figures.
  • GET_DEFAULTS — Derives the default values applied to a pay proposal line.
  • GET_BASIS_DETAILS — The procedure targeted by the user search term; it returns the details of the salary basis applicable to the assignment, forming the foundation for salary calculations in a proposal.
  • GET_PREV_SALARY — Retrieves the previous or existing salary for comparison against a proposed amount.
  • GET_PAYROLL — Determines the payroll associated with the assignment.
  • GET_HOURS — Returns the assignment working hours used in proration and basis calculations.
  • GET_ASG_HOURS — Returns assignment-specific hours.
  • GET_NORM_HOURS — Returns normalized hours for standardizing salary calculations.

Tables Accessed

The package reads from the following documented tables (through APPS synonyms):

Usage Notes

PER_PAY_PROPOSALS_POPULATE is not a public API but an internal population utility. It is typically invoked indirectly by the Salary Management and Pay Proposals forms, by concurrent programs that generate proposal records, and by the nine dependent packages that consume its derivation logic. Because GET_GRADE and related routines are effective-dated, callers must pass a valid p_date, assignment, and business group to obtain correct results. Custom extensions should not call this package directly unless they replicate the same effective-dating and pay basis assumptions; the supported integration path remains the standard pay proposal flows. The package relies on hr_utility for debug tracing (g_debug / set_location), which can be enabled when troubleshooting proposal population issues.