Search Results ozf_supp_trd_prfls

Overview

The APPS.OZF_SUPP_TRADE_PROFILE_PVT package body is a private API implementation within the Oracle E-Business Suite Trade Management (formerly Oracle Field Sales/Channel Revenue Management) module. It encapsulates the business logic that governs supplier trade profiles — the master-data records that describe the trading relationship between an operating unit and its suppliers, including the supplier customer account, ship-to or bill-to site usages, and the associated trade profile line items. The package functions as the internal engine behind the public supplier trade profile package (OZF_SUPP_TRD_PRFLS_PKG) and is not intended for direct invocation by end users. Its responsibilities include creating, maintaining, validating, and locking supplier trade profile records stored in the OZF_SUPP_TRD_PRFLS family of tables. As an API-classified Private (PVT) package, it is designed for restricted internal consumption, delegating transaction control and message handling to the standard Oracle Application Object Library (AOL) API infrastructure (FND_API, FND_MSG_PUB, FND_MESSAGE). The package is valid in both Oracle EBS 12.1.1 and 12.2.2 and resides in the APPS schema.

Key Procedures and Functions

The documented interface exposes seven procedures and functions that form the operational core of supplier trade profile maintenance:

• CREATE_SUPP_TRADE_PROFILE — Inserts a new supplier trade profile header and its associated detail records, assigning identifiers from the underlying sequence and applying defaulting logic.
• UPDATE_SUPP_TRADE_PROFILE — Modifies existing supplier trade profile attributes and reconciles dependent detail rows.
• DELETE_SUPP_TRADE_PROFILE — Removes a supplier trade profile and its dependent records, enforcing referential integrity.
• LOCK_SUPP_TRADE_PROFILE — Acquires a row-level lock on the trade profile to serialize concurrent modifications.
• VALIDATE_SUPP_TRADE_PROFILE — Performs business-rule validation against the profile, checking required attributes and cross-entity consistency.
• CHECK_SUPP_TRD_PRFL_ITEMS — Evaluates the trade profile item lines, verifying that each referenced item is valid and consistent with the profile definition.
• VALIDATE_SUPP_TRD_PRFL_REC — Validates an individual trade profile record, typically invoked as a subordinate validation step.

Tables Accessed

The package reads and writes the following documented database objects:

• OZF_SUPP_TRD_PRFLS — The core supplier trade profile entity table, holding profile header data.
• OZF_SUPP_TRD_PRFLS_ALL and OZF_SUPP_TRD_PRFLS_ALL_S — The multi-org (_ALL) table and its primary key sequence, supporting operating-unit partitioning and surrogate key generation.
• HZ_CUST_ACCOUNTS — The TCA customer/supplier account registry, used to resolve the trading partner account.
• HZ_CUST_SITE_USES — Site-use assignments (bill-to, ship-to) referenced by the profile.
• OZF_SYS_PARAMETERS — Trade Management system parameters supplying defaulting and validation behavior.
• DUAL — Used for single-row PL/SQL expressions and sequence retrieval.

Usage Notes

Because OZF_SUPP_TRADE_PROFILE_PVT is a private package, it is not called directly from Forms, concurrent programs, or custom client code. Instead, it is invoked internally by OZF_SUPP_TRD_PRFLS_PKG and by the Trade Management UI forms and OAF pages that persist supplier trade profile data. Multi-org context is established through MO_GLOBAL, while validation and error propagation rely on the AOL API message stack. The package is referenced by two other database objects within the APPS schema, confirming its subordinate role in the Trade Management dependency hierarchy. Developers extending supplier trade profile behavior should interact with the public package rather than this private implementation, as the interface is subject to change without notice.