Search Results log_activity

Overview

CSD_UPDATE_PROGRAMS_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Depot Repair module. Its primary business function is to propagate transactional updates originating from external fulfillment, receiving, and manufacturing flows back into the Depot Repair data model. When repair orders are processed through Receiving, Order Management, Inventory, Shipping, or Work in Process, this package reconciles those movements against the repair order header, lines, product transactions, and history records.

The package declares global constants G_PKG_NAME and G_FILE_NAME (sourced from csddrclb.pls) and a global debug level variable, G_debug_level, initialized from FND_LOG.G_CURRENT_RUNTIME_LEVEL. This confirms that the package integrates with the Oracle Application Object Library (FND) logging infrastructure, using the runtime level to gate diagnostic output. A locally defined record type, RCPT_LINES_Rec_Type, structures receipt-line data, drawing fields from OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, RCV_TRANSACTIONS, CSD_REPAIRS, and CSD_PRODUCT_TRANSACTIONS. This structure is central to correlating RMA receipt lines with repair activity. As a PVT package, it is intended for internal use by the Depot Repair application and is not a public API.

Key Procedures and Functions

The package exposes eighteen documented units that cluster around lifecycle events in the repair order:

• LOG_ACTIVITY — Records diagnostic and activity information, consistent with the package's FND_LOG debug-level variable. This is the unit most directly associated with the searched term "log_activity."
• CONVERT_TO_RO_UOM — Performs unit-of-measure conversion for repair order quantities.
• JOB_CREATION_UPDATE and JOB_COMPLETION_UPDATE — Reflect manufacturing job creation and completion events against the repair order.
• RECEIPTS_UPDATE, RMA_RCV_UPDATE, and IO_RCV_UPDATE — Process receiving transactions, including RMA and internal order receipts; IO_RCV_UPDATE_MOVE_OUT handles subsequent movement.
• SHIP_UPDATE, SO_SHIP_UPDATE, and IO_SHIP_UPDATE — Process shipment events for sales order and internal order flows.
• WIP_UPDATE — Reflects Work in Process activity. PROD_TXN_STATUS_UPD updates product transaction status.
• RECEIPTS_UPDATE_CONC_PROG, WIP_UPDATE_CONC_PROG, SHIP_UPDATE_CONC_PROG, and TASK_UPDATE_CONC_PROG — Concurrent-program entry points that wrap the corresponding online update logic.
• UPDATE_LOGISTIC_STATUS_WF — Updates logistics status, likely invoked from a workflow process.

Tables Accessed

The package reads and writes core Depot Repair entities: CSD_REPAIRS, CSD_PRODUCT_TRANSACTIONS, CSD_REPAIR_HISTORY, CSD_REPAIR_JOB_XREF, and CSD_REPAIR_TYPES_B. It references installation and inventory data via CSI_ITEM_INSTANCES, MTL_SYSTEM_ITEMS, MTL_SERIAL_NUMBERS, MTL_LOT_NUMBERS, MTL_TRANSACTION_LOT_NUMBERS, MTL_MATERIAL_TRANSACTIONS, and MTL_TXN_REQUEST_LINES. Organizational context comes from HR_ALL_ORGANIZATION_UNITS, while CS_ESTIMATE_DETAILS and CS_INCIDENTS_ALL_B supply service and estimate linkage. These tables are accessed through APPS synonyms, consistent with standard EBS schema design.

Usage Notes

CSD_UPDATE_PROGRAMS_PVT is a private package invoked internally by Depot Repair and referenced by six other packages. Its concurrent-program procedures (those ending in _CONC_PROG) indicate scheduled or batch execution, while the remaining units are called from online transaction flows or workflow. Because it is classified PVT, custom code should not call it directly; instead, integrations should rely on supported public APIs. The LOG_ACTIVITY routine and FND_LOG integration make the package traceable when diagnostic logging is enabled.