Search Results pay_ae_payroll_register




Overview
Explore in AI Chat

Overview

PAY_AE_PAYROLL_REGISTER is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the generation of payroll register output for the United Arab Emirates (AE) localization. The package produces both XFDF and PDF renderings of payroll register data by transforming payroll action results into XML-tagged records and streaming the resulting document into binary large objects stored or returned to the calling process. It is a server-side utility rather than a public API; the ETRM metadata classifies it as OTHER, and no other packages reference it, indicating its role is confined to the specific payroll register reporting flow within the localization.

In practice, the package addresses the need to present statutory payroll register information, including payment details and payroll action attributes, in a structured, printable format. This is frequently reached through the "provider payments registration" style queries users run when reconciling payments and registering provider or employee payment details, though the package itself operates on the payroll register data set rather than on provider payment records.

Key Procedures and Functions

  • GET_PAYROLL_REGISTER_DATA — The primary entry point for assembling payroll register content. It accepts report identification and organization context along with payroll identifiers, an effective date, and up to three sort-order directives, and returns an XFDF document as a BLOB. It is the procedure that drives the underlying XML table population.
  • FETCH_PDF_BLOB — Retrieves the rendered PDF representation of a payroll register for a given report identifier, returning the binary content for downstream consumption or delivery.
  • CLOB_TO_BLOB — A conversion utility that transforms character large object content into a binary large object, used to bridge CLOB-based XML text and BLOB-based output artifacts.
  • WRITETOCLOB — Writes the payroll register document content into a CLOB and exposes the resulting XFDF BLOB, complementing the PDF retrieval path.
  • GET_LOOKUP_MEANING — Returns the display meaning associated with a lookup type and code, providing localized or human-readable labels for values emitted into the register output.

The package also declares an XMLRec record type and a tXMLTable collection type for holding tag name and tag value pairs during document assembly; these are internal structures rather than callable procedures.

Tables Accessed

Usage Notes

The package is normally invoked by the UAE payroll register concurrent program or report definition, which calls GET_PAYROLL_REGISTER_DATA to build the XFDF stream and then FETCH_PDF_BLOB to obtain the printable output. Custom code may call these procedures directly when embedding payroll register content into bespoke output, in which case callers must supply valid organization, organization structure version, payroll, effective date, and sort parameters. Because the package is not referenced by other packages and is classified as OTHER, it should be treated as an internal implementation object; direct modification or reliance on undocumented behavior is unsupported. Lookup labels produced via GET_LOOKUP_MEANING depend on the current application lookup configuration, so output text may vary with localization patch level.