Search Results hr_bpl_alert_address




Overview
Explore in AI Chat

Overview

HR_BPL_ALERT_ADDRESS is an Oracle EBS Human Resources (HR) PL/SQL package owned by the APPS schema. It is classified in the ETRM repository as an "OTHER" API, indicating that it is not part of the standard public HRMS API set but rather an internal component used by Oracle's HR self-service and business process library (BPL) functionality. The package is declared with AUTHID CURRENT_USER and exposes a set of global variables prefixed with g_addr_ and g_emrg_, together with two documented functions. Its core purpose is to retrieve and format person-level address information and emergency contact details for use in HR alerting, notification, and person-profile display contexts. In Oracle EBS 12.1.1 and 12.2.2, this package supports the delivery of address and emergency contact data to calling forms or processes that need a consolidated, preformatted string rather than individual column values.

Key Procedures and Functions

  • GET_PSN_ADDRSS — Returns a formatted address string for a given person. The package globals (g_addr_address_style, g_addr_address_line1 through g_addr_address_line3, g_addr_country, g_addr_postal_code, g_addr_region_1 through g_addr_region_3, g_addr_town_or_city, and the g_addr_add_information13 through g_addr_add_information20 descriptive flexfield segments) capture the address components resolved by this function. The variable g_addr_address holds the consolidated output, and g_addr_col_name identifies the column context.
  • GET_PSN_EMRG_CONTACTS — Returns the emergency contact information associated with a person. Its globals include g_emrg_person_id, g_emrg_contacts, g_emrg_full_name, g_emrg_phone_number, and g_emrg_phone_type, supporting retrieval of contact name and telephone details.

The package header does not document explicit parameter lists for these functions in the excerpt; callers should consult the package body and the specific Oracle HRMS patch level for exact signatures. Both functions are scalar-returning and populate the package-level globals as a side effect, so callers should account for shared session state.

Tables Accessed

  • PER_ADDRESSES — Provides the person's address lines, style, and DFF attribute columns used to build the formatted address.
  • PER_ALL_PEOPLE_F — Supplies the person record and effective-dated person identity used as the lookup key.
  • PER_CONTACT_RELATIONSHIPS — Resolves the emergency contact relationships linking a person to their designated contacts.
  • PER_PHONES — Retrieves phone numbers and phone types for emergency contacts.
  • FND_LOOKUP_VALUES — Provides lookup meanings, typically for address styles or phone types.
  • FND_DESCR_FLEX_COLUMN_USAGES — Resolves descriptive flexfield segment definitions and column mappings used when assembling the address DFF information.

Usage Notes

HR_BPL_ALERT_ADDRESS is referenced by one other package within the ETRM dependency graph, which suggests it is consumed indirectly rather than being a primary entry point for customizations. It is typically invoked from HR self-service forms, alert or notification processing, and internal business process library flows that need a person's formatted address or emergency contact string. Because the package maintains session-scoped globals, custom code calling these functions should invoke them immediately before reading the global variables, and should not assume thread safety. Developers working on Oracle EBS 12.1.1 or 12.2.2 should treat this package as an internal, non-public interface: direct calls are permitted but Oracle does not guarantee signature stability across patch levels, so any dependency should be reviewed after HRMS upgrades.