Search Results csd_update_ship_program_cuhk

Overview

CSD_UPDATE_SHIP_PROGRAM_CUHK is a PL/SQL custom hook package owned by the APPS schema within the Oracle E-Business Suite enterprise asset management and depot repair modules. Its stated purpose in the package header is to contain custom hooks for the update shipping concurrent program. Specifically, it provides an extension point that Oracle customers and integrators can use to inject site-specific business logic into the standard shipping update processing flow without modifying Oracle-owned code. In the 12.1.1 and 12.2.2 releases, this package is classified as an OTHER API, meaning it is not a public, supported interface intended for general invocation but rather a hook point invoked indirectly by Oracle's internal program logic.

The package is registered under the CSD (Depot Repair / Service Depot) product family. The "CUHK" suffix and the header comment history identify it as a customer hook delivered as part of the shipping update program's customization framework, originally created in August 2008 and last revised under version 120.1 in February 2011.

Key Procedures and Functions

The package exposes a single documented procedure:

• POST_UPDATE_PROD_TXN — The custom hook procedure that is called from within CSD_UPDATE_PROGRAMS_PVT.SO_SHIP_UPDATE. According to the header documentation, it executes after the csd_product_transactions table has been updated and before the program writes a corresponding activity record to the CSD history table. The procedure receives identifiers for the repair line, the product transaction, and the shipped item instance, along with the comms_nl_trackable_flag value and the depot action code for the shipped transaction line. It returns an x_flag output parameter that controls downstream behavior: when x_flag returns 0, the main SO_SHIP_UPDATE program logs activity to the CSD history table; when x_flag returns a non-zero value, the main program suppresses that history logging and reprocesses the shipped line on the next execution of SO_SHIP_UPDATE. Standard return-status, message-count, and message-data output parameters are also provided to communicate error and status information back to the calling program. The header explicitly advises reviewing CSD_UPDATE_PROGRAMS_PVT.SO_SHIP_UPDATE before using this hook.

Tables Accessed

The ETRM metadata does not list any tables referenced through APPS synonyms for this package. The documented logic refers to the csd_product_transactions table, which is updated by the parent procedure immediately before this hook is invoked, and to the CSD history table, to which the parent procedure writes activity records after the hook returns. The procedure parameter list also references the mtl_system_items table as the source of the comms_nl_trackable_flag column used to identify whether the shipped item is tracked. Because the package is a hook, direct table access is typically performed inside the customer-specific implementation body rather than in the delivered shell.

Usage Notes

POST_UPDATE_PROD_TXN is not called directly by end users, forms, or concurrent program definitions. It is invoked internally by CSD_UPDATE_PROGRAMS_PVT.SO_SHIP_UPDATE, which itself runs as part of the update shipping concurrent program. The package is classified as a customer hook, and the ETRM metadata indicates it is referenced by one other package — the standard shipping update program. Customers and integrators extend or replace the body of POST_UPDATE_PROD_TXN to implement site-specific validation, correction, or conditional history-logging rules required for depot repair shipping. The x_flag contract is the critical control lever: returning zero permits normal history logging, while returning a non-zero value causes the line to be skipped and retried on the subsequent SO_SHIP_UPDATE run, which is useful for deferring processing when prerequisite data is not yet available. Because the 120.1 version dates from 2011, deployments on 12.2.2 should verify current package contents against the online patching edition before relying on this hook.