Search Results choose_option

Overview

CSP_SCH_INT_PVT is the scheduler integration private package body for the Oracle E-Business Suite Depot Repair and Spares Management (CSP) module. It provides the low-level scheduling, sourcing, availability, and inventory reservation logic that the public CSP scheduler APIs and concurrent programs depend upon. The package is classified as PVT in ETRM, indicating it is intended for internal consumption by the CSP application layer rather than direct customer invocation.

The package addresses the core business problem of determining whether a required spare part can be fulfilled, from where it should ship, when it will arrive, and how the corresponding order and reservation should be created. Its logic spans multi-organization sourcing in a global (enterprise-wide) inventory model, shipping method selection, lead time calculation, and inter-org transfer handling. The version header (120.68.12020000.14 dated 2013) reflects the mature 12.1.1 / 12.2.2 code line.

Key Procedures and Functions

The package exposes 21 documented procedures and functions. SPARES_CHECK2 is the routine most relevant to spares eligibility evaluation. GET_AVAILABILITY_OPTIONS and CHOOSE_OPTION support the sourcing decision by enumerating candidate supply locations and selecting the optimum one. CHECK_PARTS_AVAILABILITY and CHECK_LOCAL_INVENTORY perform quantity-on-hand checks across organizations and subinventories. GET_ALTERNATES resolves substitute items when the primary part is unavailable.

Order and reservation lifecycle routines include CREATE_ORDERS, CREATE_RESERVATION, and CREATE_RES_FOR_RCV_TRANXS for generating reservations tied to receiving transactions, with CANCEL_ORDER_LINE and CANCEL_RESERVATION providing the reversal paths. CLEAN_MATERIAL_TRANSACTION and CLEAN_REQUIREMENT purge processed transaction and requirement data. Date logic is handled by GET_DELIVERY_DATE and GET_ARRIVAL_DATE, which apply calendar and carrier lead times.

The WS_-prefixed routines — WS_CHECK_OTHER_ENG_SUBINV, WS_CHECK_ENGINEERS_SUBINV, and WS_CHECK_ORGANIZATIONS — implement web-service-facing validation of subinventory and organization eligibility. TASKS_POST_INSERT and TASK_POST_CANCEL are post-processing hooks for scheduler task records.

Tables Accessed

The package reads and writes CSP_REQUIREMENT_HEADERS, CSP_REQUIREMENT_LINES, and CSP_REQ_LINE_DETAILS to persist scheduling demand; CSP_REQUIREMENT_LINES_S1 is referenced as a sequence for line numbering. Temporary working sets are held in CSP_AVAILABLE_PARTS_TEMP and CSP_REQUIRED_PARTS_TEMP. Sourcing and fulfillment configuration is drawn from CSP_INV_LOC_ASSIGNMENTS, CSP_SEC_INVENTORIES, CSP_CARRIER_DELIVERY_TIMES, BOM_CALENDAR_DATES, and CSP_RS_CUST_RELATIONS. Customer and incident context comes from CS_INCIDENTS_ALL, HR_ALL_ORGANIZATION_UNITS, HZ_CUST_ACCT_SITES, and HZ_CUST_ACCT_SITES_ALL.

Usage Notes

CSP_SCH_INT_PVT is invoked indirectly through the CSP scheduler public APIs, the Spares Management concurrent programs, and Depot Repair forms that trigger scheduling and reservation. It is referenced by nine other packages, confirming its role as a shared internal engine. Because it is a private package, custom code should call the supported public API layer instead of CSP_SCH_INT_PVT directly. Overriding or bypassing it risks breaking reservation integrity and multi-org sourcing behavior in 12.1.1 and 12.2.2.