Search Results mtl_cross_references_pvt




Overview
Explore in AI Chat

Overview

APPS.MTL_CROSS_REFERENCES_PVT is a private PL/SQL package in Oracle E-Business Suite that provides the internal processing engine for the public cross-reference API, MTL_CROSS_REFERENCES_PUB. Cross references define relationships between inventory items and alternate identifiers, such as GTIN (Global Trade Item Number), UPC, manufacturer part numbers, and customer part numbers. The package is declared with AUTHID CURRENT_USER, meaning that all unqualified object references resolve under the privileges of the calling schema rather than the APPS schema.

Its central responsibility is to process a set of cross-reference records held in a PL/SQL table — creating, updating, or deleting them in the MTL_CROSS_REFERENCES base and translation tables — while performing the validation, error logging, and interface-row handling that surround those operations. Because the package is classified as PVT, it is not intended for direct invocation by external consumers; the public wrapper MTL_CROSS_REFERENCES_PUB is the supported entry point. The package header identifies itself with the entity code 'XRef', the base table MTL_CROSS_REFERENCES, and the internal API name 'Process_XRef', which corresponds directly to the searched term.

Key Procedures and Functions

  • PROCESS_XREF — The primary entry point. It processes a batch of cross references supplied in a PL/SQL table (XRef_Tbl_Type) using the standard EBS API parameter conventions: p_init_msg_list, p_commit, and the standard OUT parameters x_return_status, x_msg_count, and x_message_list. The procedure performs CREATE, UPDATE, and DELETE actions against the supplied records in a single call, driving the actual DML against the cross-reference tables.
  • VALIDATE_GTIN_REC — Performs record-level validations specific to cross references that are of type GTIN. It accepts a single XRef_Rec_Type record and returns the standard API status and message outputs.
  • VALIDATE_GTIN_NUMBER — Takes a GTIN supplied as character data and validates the 14-digit GTIN structure.
  • PROCESS_XREF_INTF_ROWS — Handles the processing of rows staged in the cross-reference interface tables, moving validated data into the base tables.
  • WRITE_DEBUG — Internal diagnostic utility used to emit debug output during processing.
  • LOG_ERROR — Records processing failures into the standard interface error table so that rejected rows can be reviewed and corrected.
  • DEL_PROCESSED_RECS — Removes successfully processed records from the interface staging tables after a run completes.

Tables Accessed

The package touches a broad set of inventory and reference tables. Core data is written to MTL_CROSS_REFERENCES, its base table MTL_CROSS_REFERENCES_B, and the translation table MTL_CROSS_REFERENCES_TL, with valid cross-reference types sourced from MTL_CROSS_REFERENCE_TYPES. Staging and error handling involve MTL_CROSS_REFERENCES_INTERFACE, MTL_CROSS_REF_INTERFACE_S, and MTL_INTERFACE_ERRORS. Item context is validated against MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_INTERFACE_S, MTL_ITEM_REVISIONS, MTL_ITEM_REVISIONS_B, and MTL_PARAMETERS. Security and installation context are resolved through FND_GRANTS, FND_OBJECTS, and FND_PRODUCT_INSTALLATIONS.

Usage Notes

MTL_CROSS_REFERENCES_PVT is normally invoked indirectly through MTL_CROSS_REFERENCES_PUB from Inventory forms, concurrent programs that load cross-reference interface data, and custom integration code that must bulk-maintain item identifiers. Because it is a private package, direct calls from custom code are not supported and may change between releases. Callers should always request commit explicitly through the public API and inspect x_return_status and the message list to confirm outcomes.