Search Results ben_cwb_fte_factor

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.