Search Results format_address




Overview
Explore in AI Chat

Overview

APPS.HR_BPL_ALERT_ADDRESS is a PL/SQL package body belonging to the Oracle E-Business Suite Human Resources (PER) product family. Its name and internal helpers (the package is composed of formatting routines whose names, such as format_address and format_emrg_contacts, are visible in the source header) indicate that the package exists to assemble and format address and emergency contact information for use within Oracle HRMS alerts and business process library (BPL) notification output. In Oracle EBS 12.1.1 and 12.2.2, alert messages delivered by the HR alerts framework often need to render a person's combined address lines or a formatted emergency contact string. This package provides the pl/sqL logic that stitches those component values into a single display-ready string, using package-level global variables (for example g_addr_address, g_emrg_contacts, g_emrg_person_id) as accumulators. It is classified under ETRM with the metadata classification OTHER, reflecting that it is an internal/infrastructure utility rather than a public, customer-facing API.

A relevant point for developers who search for "format_address" is that format_address is a locally declared procedure within the package body. It is not part of the documented public interface, and its parameter list is not published in the ETRM metadata; only its intent of formatting an output address from component strings is implied by the source header comments.

Key Procedures and Functions

  • GET_PSN_ADDRSS — The documented entry point for retrieving a formatted address for a person. It is the procedure associated with the "format_address" search term, consuming the surrounding globals and returning a consolidated address value for alert rendering.
  • GET_PSN_EMRG_CONTACTS — The documented entry point for retrieving formatted emergency contact information for a person, producing a string representation of emergency contact names and telephone details for inclusion in an alert message.

Both procedures are documented in ETRM 12.2.2 with no published parameter lists, so no signature detail is asserted here. The package body additionally contains private formatting helpers, including overloaded format_emrg_contacts variants and an internal format_address routine, which support the two public-facing procedures.

Tables Accessed

The package reads the following tables through APPS synonyms:

  • PER_ADDRESSES — supplies street address components that are concatenated into the formatted address.
  • PER_ALL_PEOPLE_F — provides the person record (and its effective-dated context) whose address and contacts are being resolved.
  • PER_PHONES — supplies telephone numbers, including phone types used when formatting emergency contacts.
  • PER_CONTACT_RELATIONSHIPS — identifies the contacts related to a person, used to build the emergency contact list.
  • FND_LOOKUP_VALUES — looks up coded values, such as phone type descriptions, for display sequencing and formatting.
  • FND_DESCR_FLEX_COLUMN_USAGES — supports descriptive flexfield context, used when address DFF segments must be included in the formatted output.

Usage Notes

HR_BPL_ALERT_ADDRESS is invoked from within the HR alerts and business process library framework, typically when an alert subscription is evaluated and its message payload is constructed. It is not intended to be called directly from end-user forms or concurrent programs; instead it is referenced by another package (ETRM records one referencing package), which calls these procedures to obtain the address and emergency contact strings. Custom code that extends HRMS alerts may call the two documented procedures when assembling alert text, but developers should treat the package as subject to change between 12.1.1 and 12.2.2 and should not depend on the private formatting routines.