Search Results date_to_displaydate

Overview

APPS.PAY_WRAPPER_PKG is a lightweight PL/SQL wrapper package that centralises Payroll's access to Oracle Application Object Library date-formatting utilities. Its documented purpose is to act as a "wrapper for FND_DATE calls", shielding dependent Payroll code from the underlying FND_DATE implementation and from the calendar-awareness behaviour that Oracle introduced in the 12.1 release family.

The package body carries the header identifier paywrapper.pkb 120.2.12020000.1, dated 18-JUL-2012. The change list records a single authoring event by "asnell" against bug 13784208, tracked across three phases: created at release 12.0, "made calendar aware" at release 12.1, and a further phase change at 12.2. This progression explains the package's existence: when FND_DATE gained the calendar_aware_alt capability, Payroll needed a single, consistent point of invocation so that every Payroll call site would honour the alternative calendar setting rather than defaulting to the Gregorian calendar.

In the Oracle EBS 12.1.1 and 12.2.2 environments, the package is registered in the ETRM repository under owner APPS with an API classification of OTHER. It exposes no public tables and holds no persistent state; it is a pure pass-through utility layer.

Key Procedures and Functions

The package body documents exactly one callable program unit:

• DATE_TO_DISPLAYDATE — a function that accepts a date value and returns a character representation suitable for display. Its body performs no logic of its own beyond delegating to FND_DATE.DATE_TO_DISPLAYDATE, explicitly passing the FND_DATE.CALENDAR_AWARE_ALT constant for the calendar-awareness argument. This means the returned string is rendered using the user's alternative calendar where one is configured, rather than being hard-coded to a Gregorian format.

No parameter lists are documented for this function beyond the single input date; the signature should be confirmed against the deployed source before use. No other procedures or functions are present in the package body, and the source terminates immediately after the function definition.

Tables Accessed

The ETRM metadata records no referenced tables for APPS.PAY_WRAPPER_PKG, whether accessed directly or through APPS synonyms. This is consistent with the source listing, which contains no SQL statements. The only external dependency is on the FND_DATE package specification, from which the DATE_TO_DISPLAYDATE function and the CALENDAR_AWARE_ALT constant are resolved at compile time. Date-format and calendar preferences are therefore resolved by FND_DATE from the session's user profile options rather than by any table read performed within this package.

Usage Notes

The package is typically invoked from Payroll forms, concurrent program PL/SQL, and custom extensions that need to render a date for user display while respecting the alternative calendar configuration. Calling PAY_WRAPPER_PKG.DATE_TO_DISPLAYDATE in preference to calling FND_DATE directly ensures that any future change to calendar-handling policy is absorbed in one place rather than at every call site.

ETRM records that the package is referenced by one other package, indicating a narrow but real dependency footprint within the Payroll schema. Because the wrapper adds a layer of indirection but no business logic, developers should be aware that it will not alter formatting behaviour beyond the calendar-awareness flag; any requirement for a specific format mask must be handled by the caller or by the underlying FND_DATE service. The package should also be validated after upgrades between 12.1.1 and 12.2.2, since the change list shows the calendar-awareness phase was adjusted between these releases.

Finally, the dependency list forms a collection of exceptions created by the package, but only the standard package body structure is present. Finally, the package has no initialization section, so no session-level setup occurs when it is loaded.