Search Results ozf_resale_batches_pkg




Overview
Explore in AI Chat

Overview

OZF_RESALE_BATCHES_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / ETRM) schema. It is classified as an OTHER API object, meaning it is not a formal public interface but instead a utility package that provides the canonical Data Manipulation Language operations for the OZF_RESALE_BATCHES_ALL table. The package belongs to the resale batch processing area of the Trade Management module, which supports the tracking and management of batches of resale or buy-back transactions used in downstream accrual, settlement, and channel program processing.

In the 12.1.1 and 12.2.2 releases, the package appears with a VALID status in the data dictionary and resolves only the SYS.STANDARD package as an external dependency, confirming it is a self-contained wrapper around the core resale batch entity rather than a cross-module orchestrator.

Key Procedures and Functions

The ETRM metadata documents four procedures, all following the standard Oracle Forms-style "table handler" pattern used throughout the OZF (Trade Management) schema. Parameter lists are intentionally not reproduced here.

  • INSERT_ROW — Inserts a new resale batch record into the underlying entity table, populating the audit and attribute columns supplied by the caller.
  • UPDATE_ROW — Updates an existing resale batch record, typically identified by its primary key, applying post-insert modifications.
  • DELETE_ROW — Removes a resale batch record from the entity table, generally invoked only when the batch has not been referenced by downstream accrual or settlement processing.
  • LOCK_ROW — Acquires a row-level lock on the resale batch record to support concurrent-update integrity, commonly used in Forms-based UI flows.

Tables Accessed

The only documented table referenced through APPS synonyms is OZF_RESALE_BATCHES_ALL. This table stores the header-level definition of resale batches and serves as the single persistence target for all four procedures: INSERT_ROW and UPDATE_ROW write to it, DELETE_ROW removes rows from it, and LOCK_ROW selects the row with a locking clause. Because the package is the sole documented DML path for this table, it acts as the enforcement point for any validation or defaulting logic applied to resale batch records.

Usage Notes

OZF_RESALE_BATCHES_PKG is referenced by three dependent packages: OZF_PRE_PROCESS_PVT, OZF_TP_ACCRUAL_PVT, and OZF_WEBADI_INTERFACE_PVT (the latter supporting Web ADI–based bulk data loading). This dependency map indicates the package is invoked indirectly rather than being called directly from user-facing code. Typical invocation paths include:

  • Oracle Forms-based maintenance screens in the Trade Management administrator responsibility, where LOCK_ROW, INSERT_ROW, and UPDATE_ROW back the standard block-level triggers.
  • Pre-processing routines in OZF_PRE_PROCESS_PVT that stage or validate resale batch data before accrual calculation.
  • Accrual processing in OZF_TP_ACCRUAL_PVT, which reads and possibly updates batch records as part of trade accrual generation.
  • Web ADI uploads handled by OZF_WEBADI_INTERFACE_PVT for bulk creation or maintenance of resale batches.

Customizations should call these procedures rather than issuing direct DML against OZF_RESALE_BATCHES_ALL, preserving the validation and audit behavior expected by the dependent Trade Management packages. Because the object status is VALID and dependencies are limited to SYS.STANDARD, the package is stable across both 12.1.1 and 12.2.2 and does not require online patching–specific considerations beyond standard APPS schema editioning.