Search Results format_address_label

Overview

ARP_ADDR_LABEL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that centralizes the formatting and layout of address information for display and printing across Receivables and related application modules. The package is classified as an OTHER API in the ETRM repository, indicating that it is a utility or formatting routine rather than a transactional business API, and it is declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling schema rather than the package owner. Its header identifies it as an original Oracle Receivables component (the AROADDLS.pls source name and the AR module prefix), giving it a long lineage that extends back through early EBS releases and remains relevant in 12.1.1 and 12.2.2.

The core business problem the package solves is that an address stored as discrete attribute columns — address lines, city, county, state, province, postal code, territory, and country — must be rendered as a single printable or displayable label. That rendering must respect country-specific address styles, page width constraints, and minimum and maximum height limits imposed by the calling report or form. ARP_ADDR_LABEL_PKG encapsulates this logic so that every caller produces a consistent result.

Key Procedures and Functions

• FORMAT_ADDRESS_LABEL — The function most commonly located by the search term "format_address_label." It accepts a full set of address attributes along with address style, customer name, bill-to location, first and last name, mail stop, default country code and description, a home-country printing flag, and numeric width, minimum height, and maximum height values, returning a single VARCHAR2 containing the assembled address label. It is the primary entry point when a caller requires an address label formatted to specific dimensional constraints.
• FORMAT_ADDRESS — Documented in more than one overload. The overloads accept essentially the same address attribute set as FORMAT_ADDRESS_LABEL, with certain parameters defaulted to NULL and, in one variant, an additional print-default-attention flag. They return the formatted address as VARCHAR2. The overloading allows callers that do not need label-specific behavior, or that omit optional attention and country parameters, to invoke the routine without supplying every argument.

Tables Accessed

The only documented table reference is NLS_DATABASE_PARAMETERS, accessed through an APPS synonym. This is a read-only reference to the database national language settings, used to determine locale-sensitive formatting behavior — for example, the database character set and territory conventions that influence how address elements are ordered and separated when producing the label.

Usage Notes

The package is referenced by 92 other packages in the ETRM repository, confirming it is a widely consumed utility rather than an end-user-facing function. It is typically invoked from Oracle Forms address blocks, from Receivables concurrent programs and report templates that print customer or site addresses, and from custom PL/SQL code that must render addresses consistently with standard EBS behavior. Because it is not a transactional API, it does not commit or roll back data and carries no validation side effects; it simply reads the NLS parameters and returns a formatted string. Developers extending address printing in 12.1.1 or 12.2.2 should call FORMAT_ADDRESS_LABEL rather than reimplementing address style logic, thereby inheriting Oracle's country-specific formatting rules.