Search Results get_updated_ids
Overview
The APPS.CSD_SOO_PVT package body is a private (PVT) orchestration engine within the Oracle E-Business Suite Service (CSD) module. Its role is to synchronize and refresh the "Service Order Orchestration" (SOO) data model, which coordinates the flow of information between field service activities, repairs, and the downstream supply-chain and order-management documents they generate. In an ETRM 12.1.1 / 12.2.2 environment, a service activity such as a repair or a return is not an isolated event; it spawns or updates internal sales orders, RMAs, shipping documents, purchase requisitions, and discrete jobs. The CSD_SOO_PVT package centralizes the logic that reconciles these related records so that statuses, identifiers, and cross-references remain consistent across the various operational entities. Because the object is classified as a private package, it is an internal implementation detail: it is not intended to be called directly by customer extensions, and its interfaces may change between releases. The ETRM metadata confirms the package is VALID and that it is not referenced by any other database object, indicating it sits at the edge of the dependency chain rather than being a shared library.
Key Procedures and Functions
The package exposes 21 documented procedures and functions organized around two themes: refresh operations and update helpers. The refresh family forms the core automation. REFRESH is the principal entry point, and SOO_DRIVER_MAIN acts as the driver that determines which subordinate refreshes to invoke. Specialized refresh routines target individual document types: REFRESH_SR and REFRESH_SR_TASK synchronize service requests and their tasks; REFRESH_JOB aligns discrete jobs; REFRESH_PURCHASE_REQ and REFRESH_INTERNAL_REQ update purchase and internal requisitions; REFRESH_INT_SALES_ORDER, REFRESH_RMA, and REFRESH_RMA_THIRD_PARTY manage internal orders and return authorizations, including third-party returns; and REFRESH_SHIP, REFRESH_SHIP_THIRD_PARTY, and REFRESH_DELIVERY handle shipping and delivery records.
The update helpers include UPDATE_COUNT, GET_UPDATED_IDS, UPDATE_RMA_RO_LINE_ID, UPDATE_SHIP_RO_LINE_ID, and UPDATE_INT_ORDER_HEADER_ID, which persist resolved identifiers back onto the orchestration rows. Diagnostic and utility routines include DEBUG and GET_DOCUMENT_STATUS, which support logging and status determination during processing.
Tables Accessed
The package reads and writes a broad set of operational tables. Service-side tables include CSD_PRODUCT_TRANSACTIONS, CSD_REPAIRS, and CSD_REPAIR_JOB_XREF, which hold the service activity and repair-to-job links. The orchestration state itself resides in CSD_SO_ORCHESTRATION and its sequence CSD_SO_ORCHESTRATION_S1. Service request data is drawn from CS_INCIDENTS_ALL_B, CS_INCIDENT_STATUSES, and CS_ESTIMATE_DETAILS. Order-management records come from OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL; requisition data from PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL; manufacturing data from WIP_DISCRETE_JOBS and WIP_ENTITIES; and shipping data from WSH_DELIVERY_DETAILS, WSH_NEW_DELIVERIES, and WSH_DELIVERY_ASSIGNMENTS_V. Reference lookups are resolved through FND_LOOKUP_VALUES and related lookup views.
Usage Notes
CSD_SOO_PVT is invoked indirectly by the Service Order Orchestration framework, typically triggered by a concurrent program, a workflow background process, or a form-driven action on a service request or repair. It relies on FND_API, FND_MSG_PUB, FND_LOG, and FND_FILE for error handling and logging, and it delegates rule evaluation to CSD_RULES_ENGINE_PVT and update execution to CSD_UPDATE_PROGRAMS_PVT. As a private package with 21 undocumented-parameter routines, it should be treated as internal; customizations should integrate through the supported public APIs rather than calling these procedures directly.