Search Results get_prev_salary_pro_amount

Overview

The APPS.HRI_OLTP_DISC_SALARY package is a salary and compensation discovery package within the Oracle E-Business Suite Human Resources Intelligence (HRI) OLTP layer. It belongs to the Oracle HRMS "discovery" family of packages — a set of denormalization and calculation utilities that support Oracle Daily Business Intelligence for HRMS, Oracle HRMSi reporting, and related workforce analytics. The package exposes public functions that encapsulate salary derivation logic, allowing callers to obtain computed compensation values without reimplementing the underlying pay basis and element configuration rules. It is owned by the APPS schema, is compiled with AUTHID CURRENT_USER, and is classified as an OTHER API rather than a strongly typed business API.

The package metadata is dated to an early HRMS release (header revision 115.2, 2003), but the object remains present and executable in Oracle EBS 12.1.1 and 12.2.2. Its most widely referenced member is the overloaded convert_currency_amount family of functions, which performs currency conversion in the context of salary calculations.

Key Procedures and Functions

• GET_PREV_SALARY_PRO_AMOUNT — Accepts a pay proposal identifier and returns a numeric salary amount associated with that proposal. It is used to retrieve the prior or proposed salary figure recorded against a pay proposal record, typically in support of salary change or progression reporting.
• GET_ANNUAL_SALARY_AS_OF_DATE — Accepts an effective date and an assignment identifier and returns the annualized salary for that assignment as of the given date. This function normalizes salary to an annual basis so that assignments paid on differing frequencies can be compared consistently, which is essential for compensation analytics and HRMSi subject areas.
• CONVERT_CURRENCY_AMOUNT — An overloaded function that converts a monetary amount from a source currency to a target currency as of a specified conversion date. Three overloads are declared. The first accepts a precision argument, allowing the caller to control decimal rounding of the converted result. The second accepts a rate type argument, allowing the caller to select a specific Oracle GL/HR currency conversion rate type (for example, a corporate or spot rate) rather than relying on the default. The third accepts only the currencies, conversion date, and amount, relying on default conversion behavior. Because Oracle PL/SQL resolves overloads by signature, callers must supply an unambiguous argument list.

Tables Accessed

The package reads configuration data through APPS synonyms rather than owning its own storage. The documented referenced tables are:

• PAY_ELEMENT_TYPES_F — Element type definitions, used to identify the salary element structures from which amounts are derived.
• PAY_INPUT_VALUES_F — Input value definitions for elements, used to interpret which input value carries the monetary salary amount.
• PER_PAY_BASES — Pay basis definitions (for example, annual, monthly, hourly), used to annualize salary amounts in GET_ANNUAL_SALARY_AS_OF_DATE.
• PER_PAY_PROPOSALS — Pay proposal records, the primary source for GET_PREV_SALARY_PRO_AMOUNT.

Usage Notes

This package is a read-only utility and is not intended to be called from HRMS data-entry forms for transactional processing. It is normally invoked from other PL/SQL packages, from Oracle HRMS Intelligence extraction code, and from custom reporting programs that require consistent salary annualization or currency conversion logic. The metadata notes that it is referenced by one other package, confirming its role as a subordinate utility. Because the functions are AUTHID CURRENT_USER, the executing user must hold suitable privileges on the underlying PAY and PER objects. Users searching for convert_currency_amount should note the three overloads and select the signature best matching their rounding and rate-type requirements; omitting a rate type delegates conversion behavior to Oracle's default currency machinery.