Search Results create_rate_value

Overview

APPS.HR_RATE_VALUES_API is a public PL/SQL API in Oracle E-Business Suite that manages rate value records within Oracle Payroll and the grade/step rate structures used in compensation processing. Rate values represent the monetary, currency, or numeric thresholds attached to a rate record — typically a grade or spinal point — and are consumed by payroll calculations, grade rate derivation, and assignment-level pay determination. The package body encapsulates the business logic and validation rules that protect the integrity of these values, ensuring that effective dating, currency handling, and object versioning conform to the standards used across EBS HRMS APIs. The package is classified as an API in the ETRM repository, meaning it is published for external invocation by forms, concurrent programs, and custom development rather than being restricted to internal use.

The header comment (pypgrapi.pkb) identifies the source file as part of the Payroll grade rate API family. The package exposes six documented procedures and is referenced by eight other packages, confirming its role as a foundational component within the HRMS rate-value domain.

Key Procedures and Functions

The documented entry points are as follows. None of the signatures below are reproduced from invention; they reflect only the purposes recorded in the ETRM metadata.

• CREATE_RATE_VALUE — Inserts a new rate value row for a specified rate and grade or spinal point, establishing the effective dating, currency, and monetary thresholds. As shown in the source excerpt, it accepts the effective date, business group, rate identifier, and grade/spinal point, together with rate type, currency, maximum, mid value, minimum, sequence, and value attributes. It returns the generated grade rule identifier, object version number, and effective start and end dates.
• UPDATE_RATE_VALUE — Modifies an existing rate value record, applying the same validation and effective-dating rules as creation and advancing the object version number.
• DELETE_RATE_VALUE — Removes or logically terminates a rate value, honoring the effective-dating conventions of the underlying datemodel.
• CREATE_ASSIGNMENT_RATE_VALUE — Establishes a rate value at the assignment level, allowing an individual assignment to carry a rate value distinct from the grade-level default. This is the procedure most closely associated with the user's search term create_assignment_rate_value.
• UPDATE_ASSIGNMENT_RATE_VALUE — Amends an existing assignment-level rate value, preserving effective history and versioning.
• LCK — Provides the standard locking routine used to serialize concurrent access to rate value records prior to update or delete operations.

Tables Accessed

The package operates against two tables referenced through APPS synonyms:

• PAY_GRADE_RULES_F — The primary datastore for grade rate values. The source excerpt confirms that the package reads and writes this table, using its columns for effective start and end dates, object version number, currency code, and grade rule identifier.
• PAY_RATES — Supplies the rate definition context, including the rate unit of measure that governs how a value is interpreted.

Usage Notes

HR_RATE_VALUES_API is typically invoked from the Grade Rates and Rate Values forms within Oracle Payroll, from concurrent programs that mass-maintain rate structures, and from custom PL/SQL that needs to create or amend rate values programmatically. Because it is an API-classified package, callers should use the documented procedures rather than inserting directly into PAY_GRADE_RULES_F, so that validation, effective dating, and object versioning remain consistent. Standard practice is to pass p_validate as TRUE first to confirm that a proposed change will succeed before committing it. Given that eight other packages depend on this API, changes to its behavior can have broad downstream impact, and customizations should avoid modifying the package body itself.