Search Results ozf_resale_adjustments

Overview

APPS.OZF_CODE_CONVERSION_PVT is a private PL/SQL package body within the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / OZF) schema. It implements the code conversion framework used by Oracle's trade promotion and resale adjustment modules. Code conversion allows an organization to translate supplier- or customer-defined codes into internal codes recognized by the EBS system, providing a mapping layer between external business identifiers and internal reference data. The package is classified as a PVT (private) API, meaning it is intended for internal use by the OZF product layer rather than as a public integration interface. Its status is VALID in the APPS schema, and it depends on the FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, JTF_PLSQL_API, MO_GLOBAL, and OZF_UTILITY_PVT packages, consistent with standard EBS API plumbing.

Key Procedures and Functions

The package exposes fourteen documented procedures divided between standard code conversions and supplier code conversions.

CREATE_CODE_CONVERSION — Creates a new code conversion record mapping an external code to an internal code.
UPDATE_CODE_CONVERSION — Updates a single existing code conversion record.
UPDATE_CODE_CONVERSION_TBL — Performs bulk updates across multiple code conversion records.
DELETE_CODE_CONVERSION — Removes a single code conversion record.
DELETE_CODE_CONVERSION_TBL — Performs bulk deletion of code conversion records.
CHECK_UNIQ_CODE_CONVERSION — Validates uniqueness of a proposed code conversion entry.
VALIDATE_CODE_CONVERSION_REC — Validates the attributes of a code conversion record prior to persistence.
VALIDATE_CODE_CONVERSION — Performs validation logic on code conversion data.
CONVERT_CODE — Applies the conversion mapping to translate an external code into its internal equivalent.
CREATE_SUPP_CODE_CONVERSION — Creates a supplier-specific code conversion record.
UPDATE_SUPP_CODE_CONVERSION — Updates an existing supplier code conversion record.
UPDATE_SUPP_CODE_CONV_TBL — Bulk updates supplier code conversions.
DELETE_SUPP_CODE_CONVERSION — Deletes a supplier code conversion record.
DELETE_SUPP_CODE_CONV_TBL — Bulk deletes supplier code conversions.

Tables Accessed

The package operates across the OZF trade management schema. Core conversion storage resides in OZF_CODE_CONVERSIONS, OZF_CODE_CONVERSIONS_ALL, and the sequence OZF_CODE_CONVERSIONS_ALL_S; supplier-specific mappings use OZF_SUPP_CODE_CONVERSIONS, OZF_SUPP_CODE_CONVERSIONS_ALL, and OZF_SUPP_CODE_CONV_ALL_S. Resale adjustment processing touches OZF_RESALE_ADJUSTMENTS, OZF_RESALE_BATCHES, OZF_RESALE_BATCH_LINE_MAPS, OZF_RESALE_LINES, and the interface table OZF_RESALE_LINES_INT. OZF_CLAIMS is referenced for claim-related conversion scenarios. OZF_SYS_PARAMETERS provides system-level configuration, while DUAL and PLITBLM support generic SQL and PL/SQL table operations.

Usage Notes

Because OZF_CODE_CONVERSION_PVT is a private package, it is not called directly by external integrations or customer-written code. It is invoked by the OZF_CODE_CONVERSION_PKG public wrapper, by Oracle Forms used to maintain code conversions, and by concurrent programs that process resale adjustments and related trade management transactions. The references to OZF_RESALE_ADJUSTMENTS and OZF_RESALE_LINES_INT indicate that conversion logic is applied during resale adjustment batch processing and interface imports. The package is referenced by five other database objects, confirming its role as a shared internal utility within the OZF module. Customizations should target the public API layer rather than this private body to preserve upgradeability across 12.1.1 and 12.2.2 releases.

APPS.OZF_RESALE_PUB SQL Statements 12.2.2
SYNONYM: APPS.OZF_RESALE_ADJUSTMENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OZF_RESALE_ADJUSTMENTS, status:VALID,
SYNONYM: APPS.OZF_RESALE_ADJUSTMENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OZF_RESALE_ADJUSTMENTS, status:VALID,
PACKAGE BODY: APPS.OZF_CODE_CONVERSION_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_CODE_CONVERSION_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_RESALE_COMMON_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_RESALE_COMMON_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_RESALE_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_RESALE_PUB, status:VALID,
PACKAGE BODY: APPS.OZF_CODE_CONVERSION_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_CODE_CONVERSION_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_TP_ACCRUAL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_TP_ACCRUAL_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_TP_ACCRUAL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_TP_ACCRUAL_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_RESALE_COMMON_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_RESALE_COMMON_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_ADJUSTMENT_EXT_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_ADJUSTMENT_EXT_PVT, status:VALID,
VIEW: OZF.OZF_RESALE_ADJUSTMENTS_ALL# 12.2.2
owner:OZF, object_type:VIEW, object_name:OZF_RESALE_ADJUSTMENTS_ALL#, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
TABLE: OZF.OZF_RESALE_ADJUSTMENTS_ALL 12.1.1
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_ADJUSTMENTS_ALL, object_name:OZF_RESALE_ADJUSTMENTS_ALL, status:VALID,
APPS.OZF_CODE_CONVERSION_PVT SQL Statements 12.1.1
APPS.OZF_CODE_CONVERSION_PVT SQL Statements 12.2.2
APPS.OZF_TP_ACCRUAL_PVT SQL Statements 12.1.1
APPS.OZF_RESALE_COMMON_PVT SQL Statements 12.1.1
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_ADJUSTMENTS 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_ADJUSTMENTS 12.1.1
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_ADJUSTMENTS 12.1.1
APPS.OZF_TP_ACCRUAL_PVT SQL Statements 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_ADJUSTMENTS 12.2.2
APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_ADJUSTMENTS 12.2.2
APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_ADJUSTMENTS 12.1.1
APPS.OZF_RESALE_PUB dependencies on OZF_RESALE_ADJUSTMENTS 12.2.2
APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_RESALE_ADJUSTMENTS 12.2.2
APPS.OZF_RESALE_COMMON_PVT SQL Statements 12.2.2
PACKAGE BODY: APPS.OZF_RESALE_PUB 12.2.2
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCHES 12.1.1
APPS.OZF_RESALE_PUB dependencies on OZF_OFFER_ADJ_RLTD_LINES 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_BATCHES 12.1.1
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_ADJUSTMENTS_ALL 12.1.1
APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_BATCHES 12.2.2
APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_BATCHES 12.1.1
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCHES 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_OFFER_ADJ_RLTD_LINES 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_BATCHES 12.2.2
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCHES_ALL 12.1.1
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_ADJUSTMENTS_ALL 12.2.2
PACKAGE BODY: APPS.OZF_CODE_CONVERSION_PVT 12.2.2
PACKAGE BODY: APPS.OZF_CODE_CONVERSION_PVT 12.1.1
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCHES_ALL 12.2.2
PACKAGE BODY: APPS.OZF_RESALE_COMMON_PVT 12.1.1
APPS.OZF_ADJUSTMENT_EXT_PVT SQL Statements 12.2.2
PACKAGE BODY: APPS.OZF_TP_ACCRUAL_PVT 12.2.2
PACKAGE BODY: APPS.OZF_TP_ACCRUAL_PVT 12.1.1
eTRM - OZF Tables and Views 12.1.1
description: Table to store the Market eligibilty for a Offer Worksheet ,
PACKAGE BODY: APPS.OZF_RESALE_COMMON_PVT 12.2.2