Search Results get_employee_name

Overview

HXC_APPROVAL_REPORT_PKG is an Oracle EBS PL/SQL package owned by APPS and declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling schema rather than the package owner. It belongs to the Oracle Time and Labor (OTL) module (HXC schema) and supports the Timecard Approval Report and related approval-processing screens. Its business role is to resolve surrogate IDs into human-readable descriptive names for reporting and approval rendering: employee, supervisor, project, task, element, application, organization, cost center, payroll, and business group. Rather than querying base tables directly from a report or form, the approval report logic calls these helper functions to translate numeric foreign keys into display values. The classification is OTHER, and the package was historically shipped at version 115.4 (2002), making it a long-standing, stable component of the OTL approval reporting stack in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented API exposes eleven functions, each a single-purpose "code-to-name" lookup:

• GET_EMPLOYEE_NAME — returns the employee name for a supplied person ID; this is the function that matches the "get_employee_name" search.
• GET_LAST_APRV — returns the last approver for a given timecard ID and OVN (object version number), used to show approval history.
• GET_PROJECT_NAME — returns the project name for a project number.
• GET_TASK_NAME — returns the task name for a task number.
• GET_ELEMENT_NAME — returns the element name for an element type ID.
• GET_APPLICATION_NAME — returns the application name for a time recipient ID.
• GET_SUPERVISOR_NAME — returns the supervisor name, typically for approval routing display.
• GET_ORGANIZATION_NAME — returns the organization name for an organization ID.
• GET_COST_CENTER — returns the cost center associated with a time record.
• GET_PAYROLL_NAME — returns the payroll name for a payroll ID.
• GET_BUSINESS_GROUP_NAME — returns the business group name for a business group ID.

All functions return VARCHAR2 and are designed as deterministic display helpers; none perform data manipulation.

Tables Accessed

The package reads through APPS synonyms. People-related lookups (GET_EMPLOYEE_NAME, GET_SUPERVISOR_NAME) resolve against PER_ALL_PEOPLE_F. Timecard approval lookups use HXC_TIME_BUILDING_BLOCKS, HXC_TIME_ATTRIBUTES, and HXC_TIME_ATTRIBUTE_USAGES to identify the timecard and its approval attributes. GET_APPLICATION_NAME reads HXC_TIME_RECIPIENTS. Payroll and costing functions draw on PAY_ALL_PAYROLLS_F (GET_PAYROLL_NAME), PAY_ELEMENT_TYPES_F (GET_ELEMENT_NAME), and PAY_COST_ALLOCATION_KEYFLEX (GET_COST_CENTER). Project and task name resolution would reference project/task definition tables (via APPS synonyms for PA). These are all read-only lookups; the package writes no data.

Usage Notes

HXC_APPROVAL_REPORT_PKG is typically invoked from the Timecard Approval Report and OTL approval forms, where it enriches result sets with descriptive names during display and printing. Because the functions are simple scalar lookups, custom reports and concurrent programs can also call them directly, passing the person, project, task, or timecard identifiers retrieved in the query. The package is not referenced by any other documented package (0 dependents), so callers invoke it directly rather than through an API chain. The AUTHID CURRENT_USER declaration means grants to the underlying tables must exist for the calling user; in practice APPS and appropriately privileged OTL users execute it successfully. GET_LAST_APRV accepts both a timecard ID and OVN, so callers must supply the matching object version number to obtain the correct approver.