Search Results delete_mtl_unit_trans

Overview

CSM_MTL_UNIT_TXN_ACC_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the ETRM API classification "OTHER." It belongs to the Oracle Complex Maintenance, Repair, and Overhaul (CMRO) / Enterprise Asset Management family of CSM (Customer Service Management) utilities that surround the MTL_UNIT_TRANSACTIONS table. The package provides the transactional maintenance layer for the CSM_MTL_UNIT_TXN_ACC accounting records, which hold the accounting distributions generated for material unit transactions. It encapsulates the insert, update, delete, and bulk-purge operations required to keep the accounting staging table synchronized with the underlying material transaction activity. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than the package owner. The most recent shipped source version carried the header identifier csmutacs.pls 120.0.12010000.2 (dated 2008/10/20), indicating the package body is a long-standing, stable component of the EBS 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The package exposes four documented procedures, all of which take a numeric user identifier as their first parameter:

• INSERT_MTL_UNIT_TRANS — Creates one or more accounting records in the CSM_MTL_UNIT_TXN_ACC staging table in response to a material unit transaction. It is invoked when a new transaction requiring accounting entries is processed.
• UPDATE_MTL_UNIT_TRANS — Modifies existing accounting records associated with a given transaction, typically when transaction attributes that drive distribution logic are corrected or re-derived.
• DELETE_MTL_UNIT_TRANS — Removes the accounting records for a single transaction, identified by its transaction identifier. This is the procedure most commonly located by searches such as "delete_mtl_unit_trans," and it is the targeted, single-record counterpart to the bulk purge routine below.
• DELETE_ALL_ACC_RECORDS — Performs a bulk purge of accounting records and returns a status indicator through its OUT NOCOPY VARCHAR2 parameter, allowing the caller to detect success or failure without relying on exceptions.

No public functions are documented; the package is entirely procedural.

Tables Accessed

The package operates against three documented database objects, available through APPS synonyms:

• CSM_MTL_UNIT_TXN_ACC — The primary table maintained by the package. All four procedures read or write this staging table, which stores the accounting lines generated from material unit transactions.
• MTL_UNIT_TRANSACTIONS — The base Oracle Inventory table recording unit-level material transactions. The package references it as the driving source for determining which transactions require accounting records.
• PLITBLM — The standard Oracle EBS PL/SQL index-by table of numbers used for bulk-processing identifiers within the package's set-based operations.

Usage Notes

CSM_MTL_UNIT_TXN_ACC_PKG is an internal integration utility rather than an end-user-facing API. It is most commonly called from transactional forms and from concurrent programs in the CMRO and Inventory modules that create, adjust, or reverse unit material transactions. It may also be referenced by custom code or validation logic that must explicitly delete accounting records, in which case DELETE_MTL_UNIT_TRANS should be preferred over direct DML because it preserves any package-level consistency checks. Because it is declared AUTHID CURRENT_USER, callers must have the necessary DML privileges on the underlying tables. The ETRM metadata records that the package is referenced by one other package, confirming its role as a subordinate building block. Developers diagnosing issues with orphaned or missing accounting rows for unit transactions should inspect callers of these procedures before applying manual corrections.