Search Results con_request_mtl_system_items




Overview
Explore in AI Chat

Overview

CSL_MTL_SYSTEM_ITEMS_ACC_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema, classified under the "OTHER" API category in the ETRM documentation set. Its header carries a CVS revision marker dating to 2005, indicating that the package body has remained relatively stable across the 12.1.1 and 12.2.2 release streams. The package belongs to the CSL (Customer/Field Service) product family and addresses the accounting and resource-attribute association between inventory items and service resources.

Functionally, the package maintains the linkage records that reside in the JTM_MTL_SYSTEM_ITEMS_ACC table — the intersection of a service resource, an inventory item, and the organization in which that item is defined. These records govern which inventory items are visible or attributable to a given service resource. The package exposes both row-level event handlers (fired when a child record is created or removed) and bulk maintenance routines for rebuilding the full set of accounting/association records for a resource.

Key Procedures and Functions

  • PRE_INSERT_CHILD — The procedure this package is most commonly identified with. It is invoked as a pre-insert event handler when a child association record (item/organization/resource) is about to be created. It accepts the inventory item, organization, and resource identifiers and performs any validation or preparatory logic required before the association row is persisted.
  • POST_DELETE_CHILD — The counterpart cleanup handler. It is fired after a child association row is deleted, accepting the same three identifiers, and is responsible for reconciling dependent data left behind by the removal.
  • CON_REQUEST_MTL_SYSTEM_ITEMS — A concurrent-request entry point that processes system item records, presumably driving a mass operation over the item master for the service resource context.
  • DELETE_ALL_ACC_RECORDS — Removes every association record for a supplied resource identifier. It returns a status through an OUT parameter so callers can detect success or failure.
  • INSERT_ALL_ACC_RECORDS — The inverse bulk routine: it recreates the full set of association records for a resource identifier, also returning a status through an OUT parameter. Together with DELETE_ALL_ACC_RECORDS it provides a full-refresh capability.

Tables Accessed

The primary target table is JTM_MTL_SYSTEM_ITEMS_ACC, which stores the item-to-resource association rows manipulated by PRE_INSERT_CHILD, POST_DELETE_CHILD, and the bulk routines. JTM_ACC_TABLE_S and JTM_CON_REQUEST_DATA support the concurrent-request processing path, while CSL_MTL_SECONDARY_LOCATORS_ACC and CSL_RESOURCE_INVENTORY_ORG hold related CSL-side resource and locator configuration.

Item and organization context is drawn from MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL, and MTL_ITEM_CATEGORIES. Resource and user identity information is resolved through JTF_RS_RESOURCE_EXTNS, FND_USER, ASG_USER, ASG_PUB, and ASG_PUB_RESPONSIBILITY. CS_BILLING_TYPE_CATEGORIES is referenced for billing classification, and PLITBLM appears for item-list processing.

Usage Notes

Because PRE_INSERT_CHILD and POST_DELETE_CHILD are event handlers, they are typically invoked from the Service/Field Service forms layer or from a related API rather than being called directly. The ETRM metadata records that this package is referenced by six other packages, confirming that it is a dependency for other CSL service modules. Direct calls should be limited to the concurrent routines and the bulk maintenance procedures, using the standardized OUT status parameter for error handling. Implementers extending the item-resource association should route changes through this package to keep the JTM_MTL_SYSTEM_ITEMS_ACC table consistent with the service resource configuration.