Search Results create_address

Overview

The APPS.AST_PARTY_LOCATIONS_V2PUB package is a public (PUB-classified) PL/SQL API belonging to the Oracle E-Business Suite Customer Relationship Management (CRM) foundation layer. It provides a programmatic interface for creating and maintaining party location records — the physical addresses associated with parties such as customers, prospects, contacts, and organizations. In Oracle EBS 12.1.1 and 12.2.2, party location data underpins the Trading Community Architecture (TCA) model, which centralizes the storage of parties, locations, and their relationships so that address information is shared consistently across Order Management, Receivables, Service, and other modules.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer. Its source header identifies it as astcul2s.pls, a component of the Address and Site (AST) API family that supports the "V2" generation of location APIs.

Key Procedures and Functions

The ETRM metadata documents two public procedures:

• Create_Address — Creates a new party location (address) record. It accepts an address record typed as AST_API_RECORDS_V2PKG.ADDRESS_REC_TYPE, returning a location identifier along with standard API out parameters for message count, message data, and return status.
• Update_Address — Modifies an existing party location record. It accepts the same address record type, an in-out object version number (used for optimistic concurrency control), and the standard out parameters for messages and return status. This is the procedure most directly relevant to the user's update_address search.

The uniform signature pattern — x_msg_count, x_msg_data, and x_return_status — follows the standard Oracle EBS API error-handling convention, allowing callers to inspect success, warning, or error outcomes and retrieve associated messages.

Tables Accessed

The ETRM extract for this object does not enumerate the base tables referenced through APPS synonyms. In practice, the procedures operate against the TCA party-location entities — principally HZ_PARTY_SITES, HZ_LOCATIONS, and the associated location assignment tables. Because the package manipulates these core TCA structures indirectly via the referenced record type package, direct table names are not exposed in the documented metadata.

Usage Notes

This package is typically invoked from:

• Custom PL/SQL programs and concurrent programs that need to create or update addresses without direct DML against TCA tables;
• Integration or interface routines loading address data from external systems;
• Form-based or workflow-driven events that programmatically amend party location details.

Because it is a public API, it should be preferred over direct table manipulation to ensure TCA integrity and business-rule enforcement. Callers must check x_return_status and process the returned messages. The metadata notes the package is referenced by zero other packages, indicating it is a leaf-level API consumed by external or application callers rather than other documented packages.