Search Results logical_transaction




Overview
Explore in AI Chat

Overview

APPS.INV_DROPSHIP_GLOBALS is a global PL/SQL specification package within Oracle Inventory (INV) that defines shared data structures used throughout the drop shipment and logical transaction processing architecture in Oracle E-Business Suite. Declared with AUTHID CURRENT_USER, the package executes under the privileges of the invoking schema rather than its owner. This is consistent with its role as a common container for type definitions consumed by multiple dependent program units in the Inventory and Order Management flow.

The package does not expose conventional business procedures or functions. Instead, it functions as a repository of a record type (logical_trx_attr_rec) and an associated PL/SQL table type (logical_trx_attr_tbl) used to pass and manipulate the attribute set associated with logical transactions. Logical transactions represent the accounting and inventory movements that OC (Order Capture), shipping, receiving, and intercompany flows generate automatically in support of drop shipments, global procurement, return to vendor, and retroactive price updates.

Key Procedures and Functions

The ETRM metadata documents zero procedures or functions for this package. The package body (INVDSGLS.pls, version 115.2, dated 2003/11/06) contains only the specification-level type declarations.

  • logical_trx_attr_rec — a record type that carries the full attribute set of a logical transaction, including transaction_id, transaction_type_id, transaction_action_id, transaction_source_type_id, and a parent_transaction_id that links child records to the parent Material Transaction (MMT) row.
  • logical_transactions_created — flag within the record indicating whether logical transactions were created (value 1) or deferred (value 2).
  • logical_transaction — flag indicating whether a given record corresponds to a physical or logical transaction.
  • logical_trx_type_code — code identifying the originating transaction: 1 (Drop Ship Receipt), 2 (Drop Ship Deliver), 3 (Global Procurement / Return to Vendor), 4 (Retroactive Price Update), or 5 (External Shipments across OUs or RMAs).
  • trx_flow_header_id — identifies the transaction flow used to create the logical transactions.
  • intercompany_cost, intercompany_pricing_option, and intercompany_currency_code — carry intercompany cost and pricing context for cross-OU flows.
  • logical_trx_attr_tbl — an associative array (INDEX BY BINARY_INTEGER) of the record type, used for bulk handling of logical transaction attribute sets.

Tables Accessed

The ETRM metadata documents no table references for this package, which is consistent with its role as a type-definition container. No DML is declared in the package specification. Downstream program units that reference this package perform the actual reads and writes against Inventory tables such as MTL_MATERIAL_TRANSACTIONS, MTL_TRANSACTIONS_INTERFACE, and the intercompany transaction tables.

Usage Notes

Because INV_DROPSHIP_GLOBALS is referenced by three other packages in the ETRM metadata, it is most likely consumed by drop shipment and intercompany processing packages that pass logical_trx_attr_tbl structures between procedures. Customizations and extensions that process drop shipments, internal sales orders, or intercompany logistics should reference the LOGICAL_TRANSACTION field and the associated type codes to distinguish physical from logical movements. Developers should also account for the inherent limitation of INDEX BY BINARY_INTEGER tables when interfacing with newer bulk-collection constructs.