Results for “get_primary_addr_id”

8 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IBE_ADDRESS_V2PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, shipped as part of the iStore (IBE) application family. It provides a consolidated address-maintenance API for iStore and related self-service modules, wrapping the Oracle Trading Community Architecture (TCA) public APIs HZ_LOCATION_V2PUB and HZ_PARTY_SITE_V2PUB. Its central business purpose is to allow callers to create, update, delete, and query party addresses — the combination of a location, a party site, and the associated site-use assignments — through a single, controlled interface rather than through multiple direct TCA calls.

The package was authored to support the iStore ordering flow, notably the one-click checkout feature, and its creation logic automatically registers addresses with the TCA party model so that billing, shipping, and tax validation remain consistent across the E-Business Suite. The header identifies the source file as IBEVADS.pls (version 120.1, dated 2005/11/23) and declares the package with AUTHID CURRENT_USER.

Key Procedures and Functions

Nine documented procedures and functions constitute the public surface of the package:

  • CREATE_ADDRESS — Creates an address by building a location, a party site, and the corresponding tax location assignment. It can also establish party site uses for billing and/or shipping, including designating the new address as primary when appropriate.
  • UPDATE_ADDRESS — Modifies an existing address by end-dating the current party site and creating a replacement location and party site. It also synchronizes the iStore one-click table.
  • DELETE_ADDRESS — Removes an address and its associated TCA records.
  • SET_ADDRESS_USAGE — Assigns or adjusts the usage types (for example, bill-to or ship-to) for a given address.
  • GET_PRIMARY_ADDRESS — Returns the primary address record for a party.
  • GET_PRIMARY_ADDR_ID — Returns the identifier of the party's primary address.
  • GET_PRIMARY_ADDR_DETAILS — Retrieves the detailed attributes of the primary address.
  • VALID_USAGES — Validates the usage designations supplied for an address.
  • COPY_PARTY_SITE — Duplicates an existing party site so that a new address can be derived from an established one.

Tables Accessed

The package operates against TCA and iStore tables through APPS synonyms. HZ_LOCATIONS stores the normalized address components; HZ_PARTY_SITES and HZ_PARTY_SITE_USES hold the party-site record and its usage assignments. HZ_PARTY_SITE_NUMBER_S supplies party site numbering. Customer-facing site records are read or written in HZ_CUST_ACCT_SITES_ALL and HZ_CUST_SITE_USES_ALL, while HZ_RELATIONSHIPS preserves party relationships. HR_ORGANIZATION_INFORMATION is referenced for organization-level attributes. IBE_ORD_ONECLICK_ALL is updated when addresses change, keeping the one-click ordering data consistent. DUAL and PLITBLM appear as utility references.

Usage Notes

As a private package, IBE_ADDRESS_V2PVT is not intended for direct customer invocation; it is called by other iStore packages and by Oracle forms and flows that manage address entry during checkout and account maintenance. Five other packages reference it. Custom code should prefer the public TCA APIs, but integrators extending iStore address behavior may consult this package to understand how address creation, primary designation, and one-click synchronization are coordinated.