Search Results format_last_address_line

Overview

APPS.OZF_LOCATION_PVT is a private PL/SQL package body within the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / OZF) schema. It provides internal utility logic for retrieving, formatting, and resolving location, party site, and customer account site information used throughout the OZF modules. The package is classified as a private (PVT) API, meaning it is intended for internal consumption by other OZF packages and is not published as a supported public interface for external integrators. Its header revision ($Header: ozfvlocb.pls 120.1 2005/09/15) indicates the source has been stable since the 11i era and continues to ship in Release 12.1.1 and 12.2.2 without material change.

Key Procedures and Functions

The documented package exposes four program units:

• FORMAT_ADDRESS — Returns a single concatenated string representing a formatted address. The private helper ozfx_format_address concatenates address lines 1 through 4, city, county, state, province, postal code, and territory short name, joining each non-null segment with a comma and space. The public FORMAT_ADDRESS extends this behavior by honoring a caller-supplied address style (display order of segments) and by inserting line breaks so the output fits within a given box dimension.
• GET_LOCATION — Retrieves location attribute data for a given location context, returning the descriptive address and related fields needed by calling OZF processes.
• GET_LOCATION_ID — Resolves and returns the unique identifier of a location record, allowing callers to obtain the HZ_LOCATIONS primary key without directly querying the table.
• GET_PARTY_NAME — Returns the party name associated with a party or party site, used to populate address displays and reports with the correct trading partner designation.

The user search term "format_last_address_line" does not correspond to any documented program unit in this package; it is likely a reference to internal line-assembly logic within FORMAT_ADDRESS rather than a separate API.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• HZ_LOCATIONS — Master address repository; supplies the raw address segments consumed by FORMAT_ADDRESS and returned by GET_LOCATION.
• HZ_PARTIES and HZ_PARTY_SITES — Provide party identity and the association between a party and a location, supporting GET_PARTY_NAME and site resolution.
• HZ_CUST_ACCT_SITES_ALL and HZ_CUST_SITE_USES_ALL — Customer account site and site-use records, used to link a location to a specific customer account and site purpose.
• OZF_ACCOUNT_ALLOCATIONS — Trade Management allocation data that consumes location and account site information for accrual and settlement processing.

Usage Notes

OZF_LOCATION_PVT is invoked indirectly rather than called from Oracle Forms or concurrent programs directly. It is referenced by two other OZF packages, which rely on it to standardize address output and to resolve location and party identifiers consistently. Typical invocation paths include Trade Management account and allocation processing, where a properly formatted address string and a validated location identifier are required for display, documentation, or downstream integration. Because the package is classified PVT, customizations should not call it directly; developers requiring equivalent functionality should instead use the public Oracle Trading Community Architecture (HZ) APIs, such as HZ_LOCATION_V2PUB or HZ_PARTY_SITE_V2PUB, which are supported across 12.1.1 and 12.2.2.