Search Results per_asg

Overview

PAY_CALC_HOURS_WORKED is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the OTHER API category. It was introduced by the Oracle Payroll development team on 28-APR-2005 (version 115.0, bug 4338404) to deliver functionality for calculating hours worked for an assignment. The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling user rather than the package owner, which is typical for packages invoked from payroll processing and other runtime contexts where row-level security and business group isolation apply.

The package addresses a common payroll and time-management requirement: deriving the number of hours an employee has actually worked over a defined period, based on the assignment's work schedule, while also supporting the derivation of standard hours within a given date range. Its header comments confirm the intent to provide "new functionality to calculate hours worked," and the parameter set demonstrates that it resolves schedule information dynamically from the assignment rather than requiring the caller to supply it.

Key Procedures and Functions

• CALCULATE_ACTUAL_HOURS_WORKED — The primary entry point. This function returns a numeric value representing the actual hours worked for a given assignment and period. It accepts payroll context identifiers (assignment action, assignment, business group, element entry, date earned), a period start and end date, a schedule category distinguishing work schedules from pager schedules, flags controlling whether exceptions are included and how tentative busy time is treated, and a legislation code. Two IN OUT parameters allow the caller to pass in and receive back the schedule source and schedule used, while output parameters return status and message. The function derives schedule data from the assignment when the schedule source indicates PER_ASG.
• STANDARD_HOURS_WORKED — A supporting function that computes standard hours for a supplied date range. It accepts a standard hours value, a range start and end date, and a standard frequency, returning the proportion of standard hours applicable to that range. This is commonly used to normalize or compare actual hours against an expected baseline.

Tables Accessed

• HR_ORGANIZATION_INFORMATION — Read to obtain organization-level classification and schedule-related information needed to resolve the correct work schedule for a business group or organization.
• PER_ALL_ASSIGNMENTS_F — Read to retrieve assignment context, including the assignment's schedule, effective dates, and associated business group, which drives the schedule source resolution logic.

Both tables are referenced through APPS synonyms. No other package in the documented metadata references PAY_CALC_HOURS_WORKED, indicating it is a leaf-level utility consumed directly by forms, payroll processes, or custom code rather than by peer APIs.

Usage Notes

The package is typically invoked during payroll or time-and-labor processing when the system must know actual hours worked over an interval, such as calculating a shift from 12:05 PM to 2:26 PM on a given day. Callers supply the assignment context and period, and the function resolves the applicable schedule and any exceptions, returning the computed hours. Because it is AUTHID CURRENT_USER, it is safe to call from within payroll run logic and concurrent programs that operate under APPS or a restricted payroll responsibility. Typical invocation points include payroll element entry processing, absence and overtime calculations, and custom Fast Formula or PL/SQL extensions that need schedule-derived hours. Developers integrating with this package should capture the return status and message outputs to detect scheduling or exception-related failures, and should ensure the assignment and period dates are consistent with the assignment's effective dating to avoid incorrect schedule resolution.