Search Results save_party_site_uses




Overview
Explore in AI Chat

Overview

HZ_PARTY_SITE_BO_PVT is a private (PVT) PL/SQL package owned by APPS that forms part of the Oracle EBS Trading Community Architecture (TCA) party site business object layer. Its role is to encapsulate the business-object-level logic that governs the creation and persistence of party site uses — the records that associate a party site with the purposes for which it may be used, such as a billing location, a shipping location, a statement-to site, or a legal address. In the EBS 12.1.1 and 12.2.2 data model, party site uses reside in the HZ_PARTY_SITE_USES entity and are central to how Receivables, Order Management, Purchasing, and other modules determine which addresses are eligible for a given transaction role.

The package is classified as private, indicating that it is intended for internal consumption by the TCA public APIs and other BO-layer packages rather than as a supported entry point for customer extensions. The 12.2.2 ETRM metadata records three documented procedures and a dependency on the PLITBLM table via APPS synonym, and notes that the package is referenced by four other packages in the application schema.

Key Procedures and Functions

  • CREATE_PARTY_SITE_USES — Creates party site use records for a specified party site. It accepts a list of party site use objects and the party site identifier, and returns a standard FND_API return status along with message count and message data, allowing callers to detect success, validation error, or unexpected error conditions.
  • SAVE_PARTY_SITE_USES — Performs an insert-or-update operation on party site uses, providing the persistence path for both newly created and modified use records. It shares the same argument profile as CREATE_PARTY_SITE_USES: the object list, the party site ID, and the standard return status, message count, and message data outputs.
  • SAVE_PARTY_SITES — Persists party site records within the same business object layer, complementing the site-use procedures by handling the parent site entity.

All three procedures were created on 14-DEC-2004 by Arnold Ng, with the package header carrying a revision of 120.3 dated 18-MAY-2006.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed through an APPS synonym. PLITBLM is an internal TCA work table used in the party site use processing flow, typically holding transient or intermediate rows during validation and persistence logic. The procedures ultimately operate against the party site use entity (HZ_PARTY_SITE_USES) and its parent party site entity; the object-list parameter HZ_PARTY_SITE_USE_OBJ_TBL reflects this direct object-oriented mapping, where each element in the collection corresponds to a party site use record to be created or saved.

Usage Notes

Because HZ_PARTY_SITE_BO_PVT is a private package, it is not intended for direct invocation from custom code. It is normally called by the public TCA party APIs and by other packages in the HZ business object layer — the metadata records four dependent package references — which in turn are driven from the Oracle Forms-based party and account maintenance screens, the Customer/Party workbenches, and bulk data-loading programs such as the TCA party import and address validation concurrent programs.

Developers extending EBS should treat CREATE_PARTY_SITE_USES and SAVE_PARTY_SITE_USES as internal implementation details and instead use the supported public APIs (for example, HZ_PARTY_SITE_V2PUB or the party site public interfaces) for address and site use maintenance. Direct calls to this package bypass supported validation and are exposed to change without notice across patches and upgrades between 12.1.1 and 12.2.2. Where troubleshooting is required, the standard FND_API return status outputs and the FND message stack provide the primary diagnostic surface.