Search Results per_saladmin_utility

Overview

PER_SALADMIN_UTILITY is an Oracle E-Business Suite package body owned by the APPS schema that provides the core salary administration utility functions used throughout the Oracle Human Resources (HR) and Oracle Payroll salary management flows. In EBS 12.1.1 and 12.2.2, it acts as a shared, low-level helper library that supports the Salary Administration form, the Pay Proposal (proposal and component) maintenance screens, and any API-driven salary adjustments. The package encapsulates the business logic needed to read, calculate, and adjust pay proposals, to derive salary-related attributes (annual salary, full-time equivalent, grade minimum/maximum), and to resolve currency, frequency, and date defaults from the underlying HR and Payroll data model. It is structured as a utility package rather than a user-facing API, and Oracle classifies it with an API category of OTHER. The body is documented as VALID in ETRM 12.2.2 and exposes 40 procedures and functions; it references a broad set of HR/Payroll base tables and is itself referenced by 18 other database objects, indicating its role as a shared internal dependency rather than a top-level entry point.

Key Procedures and Functions

The 40 documented routines cover salary administration, proposal maintenance, and derivation helpers. Representative documented procedures and functions include:

ADJUST_PAY_PROPOSALS / INSERT_PAY_PROPOSAL – insert and adjust pay proposal and proposal component rows, forming the write path of the package.
GET_SAL_ON_BASIS_CHG – returns salary on a basis change, supporting re-basing of salary when the pay basis changes.
GET_GRD_MAX_PAY / GET_GRD_MIN_PAY – return the maximum and minimum pay for a grade, typically via grade rules.
GET_ANNUAL_SALARY / GET_ANNUALIZATION_FACTOR / GET_FTE – derive annualized salary, annualization factor, and full-time equivalent values.
GET_BASIS_CURRENCY_CODE / GET_GRADE_CURRENCY / GET_CURRENCY_FORMAT – resolve currency codes and display format for salary amounts.
GET_PAY_BASIS_FREQUENCY / GET_UOM – return the frequency and unit of measure associated with a pay basis.
GET_NEXT_SAL_REVIEW_DATE / GET_PREVIOUS_PROPOSAL_DT – determine the next salary review date and the date of the previous proposal.
GET_GRADE / DECODE_GRADE_LADDER – retrieve grade information and decode grade ladder values.
CHECK_GSP_MANUAL_OVERRIDE – validate a manual override against grade step progression rules.
GET_QUERY_ONLY / GET_LOOKUP_DESC – return query-only mode and lookup descriptions for form/validation use.

Parameter lists are not reproduced here; callers should consult the package specification for exact signatures.

Tables Accessed

Through APPS synonyms the package reads and writes the salary administration and payroll data model, including:

PER_PAY_PROPOSALS, PER_PAY_PROPOSAL_COMPONENTS, PER_PAY_PROPOSALS_POPULATE – the primary proposal and component records, together with proposal population logic.
PER_ALL_ASSIGNMENTS_F, PER_PAY_BASES, PER_GRADES_VL, PER_ASSIGNMENT_BUDGET_VALUES_F, PER_ASSIGNMENT_STATUS_TYPES, PER_TIME_PERIOD_TYPES – assignment, pay basis, grade, budget, status, and time period attributes.
BEN_PGM_F – benefits program definitions used in salary/benefits integration.
PAY_ALL_PAYROLLS_F, PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, PAY_GRADE_RULES_F, PAY_INPUT_VALUES_F, PAY_PAYROLL_ACTIONS – payroll, element, grade rule, and input value data supporting grade pay limits and payroll actions.
FND_CURRENCIES_VL, FND_CURRENCY, FND_PROFILE, HR_LOOKUPS – currency, profile option, and lookup values.

It also calls supporting server-side packages including HR_API, HR_GENERAL, HR_CURRENCY_PKG, HR_UTILITY, HR_MAINTAIN_PROPOSAL_API, and BEN_CWB_PERSON_INFO_PKG, and is not referenced by any database object at the schema level.

Usage Notes

PER_SALADMIN_UTILITY is typically invoked indirectly by Oracle HR forms (Salary Administration and Pay Proposal maintenance), by the HR_MAINTAIN_PROPOSAL_API and other proposal APIs, and by concurrent programs performing salary administration and payroll processing. Because it is referenced by 18 other objects, customer and partner extensions should treat it as an internal utility; direct calls are supported only where the package specification exposes a documented routine. In 12.1.1 and 12.2.2 the package is present and VALID in APPS, and custom salary logic that needs grade min/max pay, annualization, FTE, currency resolution, or proposal insertion should prefer the documented procedures over re-implementing equivalent SQL against the base tables.

PACKAGE BODY: APPS.PER_SALADMIN_UTILITY 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_SALADMIN_UTILITY, status:VALID,
PACKAGE: APPS.PER_SALADMIN_UTILITY 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_SALADMIN_UTILITY, status:VALID,
PACKAGE BODY: APPS.PER_SALADMIN_UTILITY 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_SALADMIN_UTILITY, status:VALID,
PACKAGE: APPS.PER_SALADMIN_UTILITY 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_SALADMIN_UTILITY, status:VALID,
PACKAGE: APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PQH_BDGT_ACTUAL_CMMTMNT_PKG, status:VALID,
PACKAGE BODY: APPS.PER_CHANGE_PAY_ANALYTICS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_CHANGE_PAY_ANALYTICS_PKG, status:VALID,
PACKAGE BODY: APPS.PER_SALADMIN_ANALYTICS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_SALADMIN_ANALYTICS_PKG, status:VALID,
PACKAGE BODY: APPS.BEN_TCS_COMPENSATION 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_TCS_COMPENSATION, status:VALID,
PACKAGE: APPS.BEN_CWB_PERSON_INFO_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BEN_CWB_PERSON_INFO_PKG, status:VALID,
PACKAGE BODY: APPS.PER_VIEWS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_VIEWS_PKG, status:VALID,
PACKAGE: APPS.BEN_CWB_PERSON_INFO_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:BEN_CWB_PERSON_INFO_PKG, status:VALID,
PACKAGE: APPS.PER_PAY_PROPOSALS_POPULATE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_PAY_PROPOSALS_POPULATE, status:VALID,
PACKAGE BODY: APPS.BEN_CWB_PERSON_INFO_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_CWB_PERSON_INFO_PKG, status:VALID,
PACKAGE BODY: APPS.PER_ASSIGNMENTS_F1_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_ASSIGNMENTS_F1_PKG, status:VALID,
PACKAGE BODY: APPS.BEN_TCS_COMPENSATION 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_TCS_COMPENSATION, status:VALID,
PACKAGE BODY: APPS.HR_MEE_VIEWS_GEN 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HR_MEE_VIEWS_GEN, status:VALID,
PACKAGE BODY: APPS.PER_ASSIGNMENTS_F3_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_ASSIGNMENTS_F3_PKG, status:VALID,
PACKAGE BODY: APPS.PER_PPC_BUS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_PPC_BUS, status:VALID,
PACKAGE BODY: APPS.PER_VIEWS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_VIEWS_PKG, status:VALID,
PACKAGE BODY: APPS.PER_PPC_BUS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_PPC_BUS, status:VALID,
PACKAGE: APPS.PER_PAY_PROPOSALS_POPULATE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_PAY_PROPOSALS_POPULATE, status:VALID,
PACKAGE BODY: APPS.BEN_CWB_PERSON_INFO_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_CWB_PERSON_INFO_PKG, status:VALID,
PACKAGE BODY: APPS.PER_ASSIGNMENTS_F1_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_ASSIGNMENTS_F1_PKG, status:VALID,
PACKAGE BODY: APPS.PER_PYP_BUS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_PYP_BUS, status:VALID,
PACKAGE BODY: APPS.PER_SSHR_CHANGE_PAY 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_SSHR_CHANGE_PAY, status:VALID,
PACKAGE BODY: APPS.HR_PERIODS_OF_SERVICE_API 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HR_PERIODS_OF_SERVICE_API, status:VALID,
PACKAGE BODY: APPS.PER_SSHR_CHANGE_PAY 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_SSHR_CHANGE_PAY, status:VALID,
PACKAGE: APPS.HR_CURRENCY_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HR_CURRENCY_PKG, status:VALID,
PACKAGE: APPS.HR_CURRENCY_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HR_CURRENCY_PKG, status:VALID,
SYNONYM: APPS.PER_PAY_PROPOSAL_COMPONENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_PAY_PROPOSAL_COMPONENTS, status:VALID,
PACKAGE BODY: APPS.HR_PAY_RATE_SS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HR_PAY_RATE_SS, status:VALID,
MATERIALIZED VIEW: APPS.HR_MBS_WRKFC_JCX_MV 12.1.1
owner:APPS, object_type:MATERIALIZED VIEW, object_name:HR_MBS_WRKFC_JCX_MV, status:VALID,
PACKAGE BODY: APPS.HREMPTER 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HREMPTER, status:VALID,
PACKAGE: APPS.HR_MAINTAIN_PROPOSAL_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HR_MAINTAIN_PROPOSAL_API, status:VALID,
PACKAGE: APPS.PER_SALADMIN_UTILITY 12.1.1
PACKAGE: APPS.HR_MAINTAIN_PROPOSAL_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HR_MAINTAIN_PROPOSAL_API, status:VALID,
PACKAGE BODY: APPS.HREMPTER 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:HREMPTER, status:VALID,
PACKAGE BODY: APPS.BEN_CWB_BACKOUT_POST_PROCESS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_CWB_BACKOUT_POST_PROCESS, status:VALID,
MATERIALIZED VIEW: APPS.HR_MBS_WRKFC_JCX_SUPH_MV 12.1.1
owner:APPS, object_type:MATERIALIZED VIEW, object_name:HR_MBS_WRKFC_JCX_SUPH_MV, status:VALID,
SYNONYM: APPS.PER_PAY_PROPOSALS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_PAY_PROPOSALS, status:VALID,
SYNONYM: APPS.PER_PAY_PROPOSALS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_PAY_PROPOSALS, status:VALID,
SYNONYM: APPS.PER_ASSIGNMENT_BUDGET_VALUES_F 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_ASSIGNMENT_BUDGET_VALUES_F, status:VALID,
PACKAGE BODY: APPS.HR_UTIL_MISC_SS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HR_UTIL_MISC_SS, status:VALID,
PACKAGE: APPS.PER_SALADMIN_UTILITY 12.2.2
SYNONYM: APPS.PER_ASSIGNMENT_BUDGET_VALUES_F 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_ASSIGNMENT_BUDGET_VALUES_F, status:VALID,
SYNONYM: APPS.PAY_GRADE_RULES_F 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PAY_GRADE_RULES_F, status:VALID,
PACKAGE BODY: APPS.HR_ASSIGNMENT_API 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HR_ASSIGNMENT_API, status:VALID,
SYNONYM: APPS.PAY_GRADE_RULES_F 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PAY_GRADE_RULES_F, status:VALID,
SYNONYM: APPS.PER_TIME_PERIOD_TYPES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_TIME_PERIOD_TYPES, status:VALID,
SYNONYM: APPS.PER_TIME_PERIOD_TYPES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_TIME_PERIOD_TYPES, status:VALID,