Search Results delete_code_conversion

Overview

The APPS.OZF_CODE_CONVERSION_PVT package is a private (PVT) PL/SQL API belonging to the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / OZF) product family. It encapsulates the business logic that governs code conversion records used within Oracle Advanced Pricing, Trade Management, and related order-to-cash flows. Code conversions map external (customer-facing) codes to internal (application-facing) codes, allowing organizations to reconcile values received from external systems, partners, or legacy interfaces against the value sets and reference data held within EBS.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and it exposes a strongly typed record structure (code_conversion_rec_type) that carries the full column set of the underlying code conversion entity, including CODE_CONVERSION_ID, OBJECT_VERSION_NUMBER, who-columns, ORG_ID, PARTY_ID, CUST_ACCOUNT_ID, CODE_CONVERSION_TYPE, VALUE_SET_ID, EXTERNAL_CODE, INTERNAL_CODE, description, active date range, and fifteen descriptive flexfield attribute columns. This record type permits bulk and single-row DML to be performed with a consistent, version-aware payload. Because it is a PVT (private) package, it is not intended for direct customer invocation; it is consumed internally by the public code conversion APIs, forms, and concurrent processes.

Key Procedures and Functions

• CREATE_CODE_CONVERSION — Inserts a new code conversion record, validating the payload against the supported business rules and populating the surrogate key and audit columns.
• UPDATE_CODE_CONVERSION and UPDATE_CODE_CONVERSION_TBL — Update an existing code conversion. The _TBL variant operates on the table-structured (bulk) record collection, providing set-based update semantics.
• DELETE_CODE_CONVERSION and DELETE_CODE_CONVERSION_TBL — Remove a single code conversion or a bulk collection of code conversions. The bulk variant supports concurrent-program driven purging of many rows in one invocation. This pair is the target most commonly reached by a search for delete_code_conversion.
• CHECK_UNIQ_CODE_CONVERSION — Enforces uniqueness across the natural key of a code conversion, typically the combination of party, account, conversion type, value set, and external code.
• VALIDATE_CODE_CONVERSION_REC and VALIDATE_CODE_CONVERSION — Perform field-level and record-level validation, checking mandatory attributes, date-range consistency, and referential integrity before any DML is committed.
• CONVERT_CODE — The functional core of the package. Given an external code and conversion context, it resolves and returns the corresponding internal code used by downstream Trade Management and pricing logic.
• CREATE_SUPP_CODE_CONVERSION, UPDATE_SUPP_CODE_CONVERSION, UPDATE_SUPP_CODE_CONV_TBL, DELETE_SUPP_CODE_CONVERSION, and DELETE_SUPP_CODE_CONV_TBL — Parallel operations for supplier-side code conversions, mirroring the customer-facing API against the supplier conversion entity.

Tables Accessed

The package reads and writes the code conversion base and translation tables OZF_CODE_CONVERSIONS, OZF_CODE_CONVERSIONS_ALL, and OZF_CODE_CONVERSIONS_ALL_S, and their supplier counterparts OZF_SUPP_CODE_CONVERSIONS, OZF_SUPP_CODE_CONVERSIONS_ALL, and OZF_SUPP_CODE_CONV_ALL_S. It obtains system-level defaults and configuration from OZF_SYS_PARAMETERS, and references OZF_CLAIMS, OZF_RESALE_ADJUSTMENTS, OZF_RESALE_BATCHES, OZF_RESALE_BATCH_LINE_MAPS, OZF_RESALE_LINES, and OZF_RESALE_LINES_INT to validate that conversions are consistent with active claims, resale adjustments, and resale batch processing. DUAL is used for scalar lookups, and PLITBLM supports bulk DML array binding.

Usage Notes

Because OZF_CODE_CONVERSION_PVT is a private package, it should never be called directly from custom code. It is invoked through the public code conversion APIs, through Oracle Forms or OAF pages maintained by Trade Management, and through concurrent programs that seed, refresh, or purge code conversion data. The package is referenced by five other packages within the same product family. In release 12.1.1 and 12.2.2, the object remains at source version 120.2, and the AUTHID CURRENT_USER declaration requires that callers hold the appropriate privileges on the underlying tables and value sets. Any custom implementation requiring deletion of code conversions should call the owning public API rather than DELETE_CODE_CONVERSION directly.