Search Results pay_wrapper_pkg

Overview

PAY_WRAPPER_PKG is a lightweight utility package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Payroll (PAY) product family. Its stated purpose, taken directly from the package header, is to provide a wrapper for FND_DATE calls. The FND_DATE package is a long-standing Oracle Application Object Library utility used to convert between database DATE values and the formatted display strings expected by the Oracle Forms user interface, honouring the date format masks and calendar preferences configured for the current session.

The package was introduced relatively late in the EBS lifecycle. The header comment records that it was created by the developer asnell on 18-JUN-2012 under bug 13784208, and the revision identifier suggests it first shipped in the 12.0.12020000 release stream, making it available in both Oracle EBS 12.1.1 and 12.2.2 environments. The wrapper exists so that payroll code can invoke date-to-display conversion through a stable, product-specific entry point rather than calling the generic FND_DATE API directly, insulating dependent payroll code from changes in the underlying AOL utility.

Key Procedures and Functions

The package exposes a single documented program unit:

• DATE_TO_DISPLAYDATE — a function that accepts a DATE value and returns a VARCHAR2 containing the date rendered in the display format appropriate to the current user session. It is the payroll-facing equivalent of the standard FND_DATE conversion routines, allowing payroll forms and server-side code to present dates consistently with the user's territory, language, and date-format preferences. Notably, the package declares no public procedures; all functionality is concentrated in this one conversion function, confirming that the package is deliberately minimal in scope.

The package is compiled with AUTHID CURRENT_USER, meaning that privileges are evaluated against the invoking user's schema rather than the package owner. This is typical for thin utility wrappers that must be callable from multiple contexts without granting elevated privileges through definer's rights.

Tables Accessed

No base tables are documented as being referenced by this package through APPS synonyms. This is consistent with its role as a pure conversion utility: the routine performs string formatting on an input DATE and does not persist or retrieve business data. Any table access that occurs is indirect, arising from internal calls made by the underlying FND_DATE routines (for example, lookups of profile option values or session attributes), not from SQL written directly inside PAY_WRAPPER_PKG.

Usage Notes

Because the package contains only a formatting function, it is normally invoked from Oracle Forms date fields, from payroll concurrent program PL/SQL that needs to render dates into output files or reports, or from custom code that must display dates in a session-aware manner. ETRM records indicate the package is referenced by one other package, so it functions as a dependency in a wider payroll call chain rather than as a top-level entry point.

Developers extending payroll functionality should call DATE_TO_DISPLAYDATE rather than FND_DATE directly when working within the PAY schema, following the intent of the wrapper. No initialization, commit, or error-handling obligations attach to its use, and it is safe to call repeatedly within a session.