Search Results get_psn_eml_addrss

Overview

APPS.HR_VIEW_ALERT_RECIPIENT is a wrapper package body in the Oracle E-Business Suite Human Resources (HR) module. Its purpose is to expose alert-recipient resolution logic to Oracle Workflow, Oracle Alerts, and other consumers that need to determine who should receive a notification. The package delegates nearly all of its work to the underlying business logic package HR_BPL_ALERT_RECIPIENT, acting as a thin, controlled interface between client code and the recipient-derivation engine. The header comment block in the source identifies the file as pervarpt.pkb, with a revision label indicating a 2003 lifecycle, consistent with the long-stable HR alerting framework shipped in both EBS 12.1.1 and 12.2.2.

A defining characteristic of this package is the deliberate use of overloading to tolerate the loosely typed identifiers that appear throughout EBS integrations. The source excerpt explicitly documents that the package provides a NUMBER-based version and a VARCHAR2-based version of the same functional call, with the VARCHAR2 variant converting the input via TO_NUMBER before invoking the delegated implementation. This design accommodates callers that pass person identifiers as character strings, which is common in workflow message attributes and alert definitions.

Key Procedures and Functions

The ETRM metadata documents 28 callable units. The most prominent are the recipient-resolution functions exposed in the source excerpt:

• GET_PSN_EML_ADDRSS — returns the email address associated with a given person. This is the function targeted by the search term "get_psn_eml_addrss". It exists in both NUMBER and VARCHAR2 overloads.
• GET_ALL_PSN_PRSN_NM — returns the full person name for a given person identifier, again provided in NUMBER and VARCHAR2 overloads.
• GET_PSN_SUP_PSN_EML_ADDRSS — returns the email address of a person's supervisor, with a VARCHAR2 overload present in the source.

The remaining documented units follow the same naming convention and fall into consistent families. Person-level functions include GET_PSN_PRSN_NM, GET_PSN_SUP_PSN_NM, GET_PSN_LNG, and GET_PSN_SUP_PSN_LNG. Scope-validation functions include CHECK_PERSON_IN_SCOPE, CHECK_SUP_PERSON_IN_SCOPE, CHECK_ASG_SUP_IN_SCOPE, and CHECK_PASG_SUP_IN_SCOPE. Assignment-level resolution functions include GET_ASG_SUP_EML_ADDRSS, GET_ASG_SUP_NM, GET_ASG_SUP_LNG, GET_ASG_PSN_EML_ADDRSS, GET_ASG_PSN_NM, and GET_ASG_PSN_LNG. Position-assignment variants mirror these with the PASG prefix: GET_PASG_SUP_EML_ADDRSS, GET_PASG_SUP_NM, and GET_PASG_SUP_LNG. Collectively, these functions resolve names, email addresses, languages, and supervisor context for persons, assignments, and position assignments, subject to scope checks.

Tables Accessed

The ETRM metadata does not enumerate tables referenced through APPS synonyms for this wrapper. Because HR_VIEW_ALERT_RECIPIENT delegates to HR_BPL_ALERT_RECIPIENT, all table access—principally HR_PER_F, HR_EMPLOYEES, assignment, supervisor, and contact/email structures maintained by the HR business logic layer—occurs within the delegated package rather than here. Custom code should not assume this package carries its own SQL.

Usage Notes

This package is typically invoked from Oracle Workflow notification functions, Oracle Alerts definitions, and bespoke PL/SQL that must dynamically resolve a notification recipient without hard-coding an address. It is not referenced by any other documented package (referenced by 0), so it should be treated as a top-level integration surface. When calling GET_PSN_EML_ADDRSS, prefer the overload matching the native datatype of the incoming identifier to avoid unnecessary implicit conversion and the ORA-06502 risks that accompany invalid character input passed to TO_NUMBER.