Search Results get_lookup_meaning

Overview

APPS.PER_AE_XDO_REPORT is a reporting support package body belonging to the Oracle E-Business Suite Human Resources (PER) module, specifically targeted at the United Arab Emirates (AE) legislative localization. Its primary business function is to assemble structured personnel data — visa records, passport records, and employment contract details — and emit the results as a binary XML Publisher data source (an XFDF-style BLOB) suitable for rendering through the Oracle XML Publisher (BI Publisher) engine. The package therefore acts as the data extraction layer behind statutory and HR operational reports required by UAE labour and immigration practice.

Consistent with its classification as an OTHER API object, PER_AE_XDO_REPORT exposes no supported public interface for transactional integration. It is an internal reporting utility rather than a validation or business-event hook.

Key Procedures and Functions

The ETRM metadata documents seven callable units. All are implementation-level constructs serving document generation and lookup support.

• GET_VISA_DATA — The principal extraction routine for visa reporting. It resolves the operating business group, resolves a hierarchy of organizations from the organization structure version supplied by the caller, joins employee and assignment data to visa/document extra information, and writes the resulting XML payload into an output BLOB for XML Publisher.
• GET_PASSPORT_DATA — The parallel extraction routine for passport records, following the same report-data-source pattern.
• GET_CONTRACT_DATA — The parallel extraction routine for employment contract information, again producing an XML BLOB for publishing.
• CLOB_TO_BLOB — A conversion helper that translates generated XML held in a CLOB into a BLOB suitable for the report template.
• WRITETOCLOB — An internal writer that appends or assembles generated XML markup into a CLOB buffer during extraction.
• FETCH_PDF_BLOB — Retrieves a PDF BLOB, typically for embedding or delivering a generated document.
• GET_LOOKUP_MEANING — The lookup utility that resolves an Oracle EBS lookup code to its display meaning. In this package the routine is used to translate coded values on HR person, assignment, and document records into the descriptive text expected on printed output, so that reported values reflect configured lookup meanings rather than internal codes.

Tables Accessed

The package reads a defined set of HR and FND objects, all accessed through APPS synonyms.

• PER_BUSINESS_GROUPS / PER_ORGANIZATION_STRUCTURES / PER_ORG_STRUCTURE_VERSIONS / PER_ORG_STRUCTURE_ELEMENTS — used to resolve the AE business group and to walk the organization hierarchy via CONNECT BY when the report is scoped to an organization structure version.
• HR_ALL_ORGANIZATION_UNITS, PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE — the core person, assignment, and service records that form the report subject set.
• HR_DOCUMENT_EXTRA_INFO, HR_DOCUMENT_TYPES_TL, PER_JOBS — the visa and passport document data (stored in descriptive flexfield segments) and their translated document type names.
• FND_LOBS, FND_SESSIONS, DBMS_LOB, DUAL, PLITBLM — supporting objects for BLOB/CLOB storage, session context, LOB manipulation, and PL/SQL table utility.

Usage Notes

PER_AE_XDO_REPORT is invoked indirectly. It is registered as the data source of the relevant UAE HR/visa XML Publisher concurrent programs, where the runtime passes the request identifier, report name, effective date, business group, organization structure identifiers, and an expiry window. The extraction procedures then populate a BLOB that the template consumes.

Because the package is classified as OTHER and is referenced by no other package, it should not be called from custom PL/SQL as a supported API. Customizations needing equivalent data are advised to query the underlying PER and HR document tables directly, or to build their own data source, rather than invoking these internal procedures.