Search Results get_cust_acct_site_uses

Overview

APPS.CSP_PARTS_ORDER is a server-side PL/SQL package body in Oracle E-Business Suite (validated against 12.1.1 and 12.2.2) whose stated purpose is to "Create/Update/Cancel Internal Parts Order for Spares." The package belongs to the Spares Management / Enterprise Asset Management (EAM) family of components and provides the programmatic engine that converts a spare-parts requirement into an internal sales order or internal requisition, drives it through booking, and supports its subsequent cancellation. The header block records the source file as cspvpodb.pls (version 120.72.12020000.6) and dates the original creation to May 2001, indicating a long-lived object that has been patched repeatedly across release levels. The package is classified under the ETRM API taxonomy as OTHER rather than as a public Open Interface or a formally published API, which means it is intended primarily for internal consumption by other CSP components and by Oracle's own forms and concurrent programs.

Key Procedures and Functions

ETRM documents seven callable units within the package body. The two principal entry points are PROCESS_ORDER, which performs the create or update of an internal parts order, and PROCESS_PURCHASE_REQ, which handles the purchasing-requisition side of the flow, including the requisition distributions required when the requirement is met through procurement rather than internal transfer. Cancellation is split across CANCEL_ORDER, which cancels at the order level, and CANCEL_ORDER_LINE, which cancels individual lines, allowing partial reversal of a spares demand. BOOK_ORDER performs the booking action that firms up the order once the lines have been validated and priced. Two further units, UPD_OE_LINE_SHIP_METHOD and UPD_OE_SHIP_TO_ADD, maintain Order Entry line attributes — specifically the shipping method and the ship-to address — ensuring the internal order carries the correct delivery information for the destination organization. Consistent with Oracle EBS coding standards, these units return status values and use IN OUT parameters for derived outputs; the internal helper get_unit_price_prc, visible in the source excerpt, demonstrates the pattern by deriving functional currency and unit price from either the source organization cost or the list price plus conversion rate, returning them through NOCOPY OUT parameters.

Tables Accessed

The package reads and writes a broad cross-section of EBS tables through APPS synonyms. Order and requisition data resides in PO_REQ_DISTRIBUTIONS_ALL, while the spares requirement itself is carried in CSP_REQUIREMENT_HEADERS, CSP_REQUIREMENT_LINES, and CSP_REQ_LINE_DETAILS. Customer and ship-to resolution draws on HZ_CUST_ACCT_SITES, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_ACCOUNT_ROLES, and CSP_RS_CUST_RELATIONS, the last being the CSP relationship table that maps internal organizations to their customer representation. Service-request linkage is maintained through CS_INCIDENTS_ALL. Financial and organizational context comes from FINANCIALS_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMS_ALL, GL_CODE_COMBINATIONS, HR_ALL_ORGANIZATION_UNITS, and HR_ORGANIZATION_INFORMATION, with FND_USER supplying the audit identity. The presence of the HZ customer tables is directly relevant to the user's search term get_cust_acct_site_uses: site-use validation against HZ_CUST_ACCT_SITES is the mechanism by which the package confirms that a destination organization has a valid internal customer site before the order is created or the ship-to is updated.

Usage Notes

Because the package is classified as OTHER, it should be treated as a non-public API: customizations should preferably call the supported CSP forms and concurrent programs rather than invoking these procedures directly, since signatures may change between patch levels. In practice the package is driven from the Spares Management responsibilities — the parts order and shipping forms, the order booking and cancellation actions, and scheduled programs that process pending requirements — and it is referenced by ten other packages within the CSP schema, meaning changes can propagate well beyond the immediate module. When debugging spares order creation, the most useful starting points are PROCESS_ORDER for header and line creation and PROCESS_PURCHASE_REQ for requisition generation; failures to resolve a ship-to typically trace to customer site-use data in the HZ tables or to accounting information missing from HR_ORGANIZATION_INFORMATION for the source or destination organization.