Search Results get_currency_name

Overview

APPS.HR_EMPL_VERF_UTIL is a utility package body in Oracle E-Business Suite, classified as a UTIL API within the ETRM metadata repository. Its name and internal structure indicate that it supports employee verification workflows, primarily those that validate and consume HTTP-style tickets used to authorize one-time or time-limited access to employee information. The package header comment follows the standard Oracle template (PKGBODY.TXT) and identifies the object as hr_empl_verf_util, with the last recorded revision dated 2006.

The package wraps lower-level functionality provided by the FND_HTTP_TICKET package, exposing simplified Boolean-to-numeric conversions for callers that need deterministic return codes (1 for matched, 0 for not matched, 2 for a null result). In Oracle EBS 12.1.1 and 12.2.2, such utilities are typically used in self-service or web-based flows where a URL-embedded ticket must be verified before the application displays employee verification data such as salary.

Key Procedures and Functions

The package exposes six documented procedures and functions. Each is described below based on the documented metadata; parameter lists are intentionally omitted.

• CHECK_TICKET_STRING — Validates a multi-use ticket string by delegating to FND_HTTP_TICKET.CHECK_TICKET_STRING. It returns a numeric status: 1 when the ticket matches, 0 when it does not, and 2 when the underlying result is null. It also returns the decoded operation and argument through OUT parameters.
• CHECK_ONETIME_TICKET_STRING — Validates a single-use ticket by calling FND_HTTP_TICKET.CHECK_ONETIME_TICKET_STRING. It returns 1 for a successful match and 0 otherwise, enforcing one-time consumption semantics.
• SEND_MAIL — Sends an SMTP-based email. The source excerpt shows it opening a connection via UTL_SMTP, issuing HELO/MAIL/RCPT commands, and writing message data. This supports verification notifications to employees or administrators.
• SEND_NOTIFICATION — Emits a workflow notification (associated with WF_ADHOC_ROLE_S and FND_NEW_MESSAGES). It centralizes the notification pattern used by employee verification processes.
• GET_EMPLOYEE_SALARY — Retrieves employee salary information, joining assignments to currency data. This is the function most relevant to the user query "get_currency_name": it resolves the currency associated with a salary amount, using FND_CURRENCIES_TL to obtain the currency name.
• UPDATE_TICKET_STRING — Updates a stored ticket string, likely marking one-time tickets as consumed or refreshing ticket state.

Tables Accessed

The documented tables accessed through APPS synonyms are:

• PER_ALL_ASSIGNMENTS_F — the primary source of assignment-level data, including salary and payroll attributes, used by GET_EMPLOYEE_SALARY.
• FND_CURRENCIES_TL — the translated currencies table, read to return the currency name for a salary amount. This is the table behind the "get_currency_name" search term.
• FND_NEW_MESSAGES — stores notification message content used by SEND_NOTIFICATION.
• FND_USER — identifies the recipient or actor associated with verification and notification actions.
• WF_ADHOC_ROLE_S — provides ad hoc role membership for workflow notification routing.

Usage Notes

HR_EMPL_VERF_UTIL is not referenced by any other documented package, indicating it is invoked directly by forms, concurrent programs, or custom code rather than through an internal dependency chain. Typical invocations include self-service employee verification pages that embed a ticket in a URL, where CHECK_TICKET_STRING or CHECK_ONETIME_TICKET_STRING is called before displaying data; and salary verification flows where GET_EMPLOYEE_SALARY resolves the currency name via FND_CURRENCIES_TL. Because the package depends on FND_HTTP_TICKET and UTL_SMTP, callers must ensure FND and Workflow schemas are accessible and that SMTP connectivity is configured. Custom code should treat the numeric return codes as the contract and handle unexpected exceptions, since the functions re-raise exceptions via WHEN OTHERS THEN raise.