Search Results p_period_end_date

Overview

APPS.HR_WRK_SCH_PKG is a PL/SQL package body that supports the Oracle EBS work schedule and availability infrastructure used by Human Resources, Oracle Time and Labor, and absence management. Its principal business role is to determine the working schedule that applies to a given person assignment for a specified date range, taking into account schedule inheritance from higher levels of the enterprise hierarchy. The package header comment states that it evaluates whether an entered absence overlaps with schedules attached at Business Group, Position, Job, HR Organization, or Location level. The comment further notes that the overlap procedure is invoked only when a schedule already exists at the person assignment level.

The object carries the version marker 120.6.12010000.2 with a 2008 header timestamp, indicating a long-standing component carried forward into both 12.1.1 and 12.2.2. A comment referencing bug 6711896 confirms that the overlap logic was subject to a targeted fix. The ETRM classification for this package is OTHER, meaning it is not marketed as a formally supported public API; it is an internal implementation package rather than a published integration surface.

Key Procedures and Functions

The ETRM metadata documents two callable program units within the package body:

• GET_PER_ASG_SCHEDULE — Retrieves the work schedule applicable to a person assignment for a given period. Internally this relies on the schedule inheritance hierarchy to resolve which schedule level applies when a schedule is not defined directly against the assignment.
• GET_WORKING_DAY — Determines whether a date is a working day for the applicable schedule, returning the working-day determination for downstream absence and time calculations.

The package body excerpt additionally reveals a private procedure, check_overlap_schedules, which accepts a person assignment identifier, a period start date, a period end date, a schedule category, an include-exceptions flag, and a busy/tentative assignment indicator, and returns the schedule source and an availability time varray. The parameter p_period_end_date — the term used in the search that surfaced this object — belongs to this private overlap routine, not to the two documented public units.

Tables Accessed

• PER_ALL_ASSIGNMENTS_F — Supplies the assignment's business group, organization, job, position, and location, which together drive schedule inheritance lookup.
• PER_SCH_INHERIT_HIER — Defines the schedule inheritance hierarchy. Cursors select the maximum hier_seq where in_hier = 'Y' and derive the inherit_level for a given sequence.
• CAC_SR_SCHEDULES_B, CAC_SR_SCHDL_OBJECTS, CAC_SR_PUBLISH_SCHEDULES — Store the schedule definitions, their attached objects, and published schedule data.
• DUAL and PLITBLM — Utility references used for scalar selection and PL/SQL table handling.

Access is performed through APPS synonyms, consistent with standard EBS schema conventions.

Usage Notes

This package is invoked indirectly rather than through a direct user interface. It is referenced by ten other packages in the ETRM repository, indicating that absence entry, timecard validation, and scheduling forms or concurrent programs call into it to resolve schedules and validate date ranges. Custom code should treat GET_PER_ASG_SCHEDULE and GET_WORKING_DAY as the only documented entry points and must not depend on check_overlap_schedules, since private procedures carry no compatibility guarantee across patch levels. Because the package is classified OTHER, extensions should prefer supported HR APIs and use this package only where no public alternative exists. When diagnosing overlap or working-day discrepancies, verify that the assignment has a person-level schedule, then confirm the inheritance hierarchy sequence values in PER_SCH_INHERIT_HIER.