Search Results update_ticket_string

Overview

HR_EMPL_VERF_UTIL is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite. Its name reflects its role in support of employee verification (EMPL_VERF), a security facility used by Oracle HRMS self-service modules to confirm the identity of an employee before granting access to restricted pages, such as payslip viewing, personal information maintenance, or benefits enrollment. The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking session rather than the definer, and it explicitly relies on APPS synonyms for the base tables it touches.

The package is documented in ETRM with an API classification of UTIL and contains six documented procedures and functions. Its central mechanism is ticket-based verification: a caller-generated token (the "ticket string") is encoded, checked, and updated to track the state of a verification transaction. In the 12.1.1 and 12.2.2 code lines the package remains a stable, lightly maintained component, as evidenced by the header revision 120.1 dated June 2005.

Key Procedures and Functions

• CHECK_TICKET_STRING — A function that validates an inbound ticket string and returns a numeric status code. It also returns the decoded operation and argument carried within the ticket, allowing the caller to determine what action the ticket authorizes.
• CHECK_ONETIME_TICKET_STRING — A parallel validation function for single-use tickets. It performs the same decode-and-return pattern but is intended for tickets that must not be replayed.
• UPDATE_TICKET_STRING — The function most frequently sought in support research. It accepts a ticket, an operation, and an argument, applies the requested change to the ticket record, and returns a numeric result indicating success or failure. It is the counterpart to the CHECK functions, persisting state once verification has been performed.
• SEND_NOTIFICATION — Builds and dispatches the verification notification, including the recipient and sender addresses, a reply-to address, an access URL, an access duration in days, the employee name, an access limit, a personal key, and free-form comments.
• GET_EMPLOYEE_SALARY — Retrieves salary and related compensation attributes for an assignment as of an effective date, returning salary, frequency, annualized salary, pay basis, reason code, currency, status, currency name, and pay-basis frequency as OUT parameters.
• SEND_MAIL — Listed in the documented inventory as a mail-delivery routine; in the package specification source it appears commented out, indicating it was superseded by SEND_NOTIFICATION.

Tables Accessed

The package reads and writes through APPS synonyms: PER_ALL_ASSIGNMENTS_F supplies assignment context and the effective-dated attributes required by GET_EMPLOYEE_SALARY; FND_CURRENCIES_TL provides the translated currency name; FND_NEW_MESSAGES and FND_USER support notification delivery and recipient identification; and WF_ADHOC_ROLE_S is used to resolve ad hoc role membership referenced during verification. No other packages in the documented set reference HR_EMPL_VERF_UTIL, so its callers are forms, self-service pages, or custom extensions rather than peer APIs.

Usage Notes

HR_EMPL_VERF_UTIL is normally invoked indirectly. Oracle HRMS self-service flows generate a ticket, dispatch a notification through SEND_NOTIFICATION, and later validate the returned ticket using CHECK_TICKET_STRING or CHECK_ONETIME_TICKET_STRING. When verification must be recorded or the ticket state advanced, the calling code invokes UPDATE_TICKET_STRING. Customizations that interface with employee verification, such as bespoke approval pages or external identity checks, may call these routines directly, but they should preserve the AUTHID CURRENT_USER semantics and grant the invoking user appropriate access to the underlying tables. Because the package is classified as a utility and is not referenced by other documented APIs, Oracle does not guarantee its signature across releases; any custom dependency should be revalidated after patching or upgrading between 12.1.1 and 12.2.2.