Search Results hr_view_alert_recipient

Overview

APPS.HR_VIEW_ALERT_RECIPIENT is a PL/SQL package in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and classified under ETRM as an "OTHER" API. The package is declared with AUTHID CURRENT_USER and addresses a specific business requirement: resolving the contact details of employees and their supervisors for the purpose of alert and notification delivery within Oracle HRMS and workflow-driven processes. Rather than exposing raw person or assignment identifiers, the package returns derived, human-readable values — person names, e-mail addresses, and language codes — that downstream alert mechanisms can consume directly.

The package distinguishes between three levels of resolution: person-level functions keyed on person identifier, assignment-level functions keyed on assignment identifier, and "primary assignment" (PASG) functions keyed on assignment identifier but resolving the primary assignment context. It also exposes the supervisor dimension at each of these levels, enabling alerts to be routed to a line manager when the primary recipient is unavailable or when escalation logic applies.

Key Procedures and Functions

The documented functions fall into several logical groups. The person-level group includes GET_ALL_PSN_PRSN_NM, which returns the concatenated display name for a person; GET_PSN_PRSN_NM and GET_PSN_SUP_PSN_NM, which return the person's name and the supervisor's name respectively; GET_PSN_EML_ADDRSS and GET_PSN_SUP_PSN_EML_ADDRSS, which return e-mail addresses; and GET_PSN_LNG and GET_PSN_SUP_PSN_LNG, which return language codes used for localised notification content. Several of these are overloaded, accepting the person identifier as either a NUMBER or a VARCHAR2.

The assignment-level group provides equivalent capabilities keyed on assignment identifier: GET_ASG_SUP_EML_ADDRSS, GET_ASG_SUP_NM, and GET_ASG_SUP_LNG resolve the supervisor's e-mail, name, and language from an assignment. A parallel set — GET_ASG_PSN_EML_ADDRSS, GET_ASG_PSN_NM, and GET_ASG_PSN_LNG — resolves the assignment holder's own contact details.

The primary-assignment (PASG) group includes the function the user searched for, GET_PASG_SUP_EML_ADDRSS, which returns the e-mail address of the supervisor associated with a given primary assignment. It is joined by GET_PASG_SUP_NM and GET_PASG_SUP_LNG for the supervisor's name and language.

Scope-validation functions complete the API surface: CHECK_PERSON_IN_SCOPE, CHECK_SUP_PERSON_IN_SCOPE, CHECK_ASG_SUP_IN_SCOPE, and CHECK_PASG_SUP_IN_SCOPE determine whether the person or supervisor falls within the authorised visibility scope, guarding against alerts being dispatched to out-of-scope recipients.

Tables Accessed

The provided ETRM metadata does not enumerate the underlying base tables, and no APPS synonyms are documented for this package. Functionally, the resolution of names, e-mail addresses, languages, and supervisor relationships implies access to core HRMS person and assignment entities — including person, assignment, and supervisor hierarchy data — together with the contact and language information necessary to produce deliverable e-mail addresses. Because the package is a retrieval-only view helper, it performs read operations rather than DML.

Usage Notes

HR_VIEW_ALERT_RECIPIENT is designed as a helper for alert and notification frameworks. It is typically invoked from Oracle Workflow notification definitions, from Oracle Alerts, or from custom PL/SQL that needs to determine who should receive a notification and in which language. Consumers should call the appropriate overload matching their identifier type, and should respect the CHECK_*_IN_SCOPE functions before dispatching to a resolved recipient, as these determine whether the derived contact is legitimately visible to the calling context. Because the package is AUTHID CURRENT_USER, privilege resolution occurs against the calling schema, which is significant when the package is executed from a custom schema rather than from APPS.