Search Results build_ship_prod_txn_tbl

Overview

CSD_SPLIT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an "OTHER" API rather than a public or private interface. It belongs to the Depot Repair module (the CSD schema family) and provides the internal engine used to split a repair order into multiple repair orders. Splitting a repair order is a common Depot Repair requirement when a single customer return contains items that must be routed to different repair lines, vendors, or organizations, or when only part of a returned quantity is to be serviced. The package orchestrates the creation of the new repair order header and lines, duplicates the relevant repair history, copies associated notes, and builds the supporting replenishment, product transaction, and shipping transaction structures required by the downstream processing logic.

The package is listed as VALID and is not referenced by any other package, indicating it is invoked directly rather than serving as a reusable utility layer. It depends on CSD_PROCESS_PVT, CSD_REPAIRS_PUB, CSD_REPAIR_HISTORY_PVT, and the standard FND_API error-handling framework.

Key Procedures and Functions

• SPLIT_REPAIR_ORDER — the main entry point that drives the entire split operation, coordinating the creation of the new repair order and its associated records.
• IS_SPLIT_REPAIR_ORDER_ALLOW — validates whether the selected repair order is eligible to be split, returning a yes/no determination used before the split is attempted.
• CREATE_NEW_REPAIR_ORDER — creates the new repair order header and line records that result from the split.
• BUILD_REPLN_RECORD — constructs the replenishment record associated with the newly created repair order.
• BUILD_PRODUCT_TXN_RECORD — assembles the product transaction record that captures the movement of the split items.
• BUILD_REPAIR_HISTORY_RECORD — builds the history record that will be written against the new repair order.
• COPY_REPAIR_HISTORY — copies existing repair history rows from the original repair order to the newly created one.
• COPY_JTF_NOTES — duplicates JTF notes attached to the original repair order onto the new order.
• BUILD_SHIP_PROD_TXN_TBL — constructs the shipping/product transaction table structure used during the split processing.
• SET_ERROR_MESSAGE — standard error-handling helper that populates the FND_API message stack when a validation or processing failure occurs.

Tables Accessed

The package reads and writes the core Depot Repair tables through APPS synonyms. CSD_REPAIRS holds the repair order header and line data that is created and updated during a split. CSD_REPAIR_HISTORY stores the historical status and action records that are copied to the new order by COPY_REPAIR_HISTORY. CSD_REPAIR_JOB_XREF provides the cross-reference between repair orders and jobs, which must be maintained consistently across the original and split orders. CSD_PRODUCT_TRANSACTIONS records the product movement generated by BUILD_PRODUCT_TXN_RECORD. MTL_ITEM_REVISIONS is consulted to resolve item revision information for the items being split. PLITBLM is an Oracle-supplied numeric/date translation table used in converting values during record construction.

Usage Notes

CSD_SPLIT_PKG is a back-end package invoked from Depot Repair execution paths rather than being called by external custom code, as evidenced by the absence of any referencing packages. In typical EBS 12.1.1 and 12.2.2 deployments, it is triggered when a user performs a split action from the Depot Repair form or an associated concurrent process; the form supplies the repair order identifier and the split attributes, and the package performs the validation via IS_SPLIT_REPAIR_ORDER_ALLOW before proceeding. Because the package relies on FND_API for error messaging, callers should verify the API return status rather than relying on exceptions alone. Customizations that need to split repair orders programmatically should ideally call the public CSD_REPAIRS_PUB layer, which in turn invokes the logic in this package, rather than calling CSD_SPLIT_PKG directly, to preserve supportability across patch levels.