Search Results cancel_order_line

Overview

CSP_PARTS_ORDER is a server-side PL/SQL package owned by APPS that manages the lifecycle of internal parts orders used for spare parts replenishment within Oracle E-Business Suite. Its stated purpose, taken from the package header, is "to create/update/cancel internal parts order for spares." The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking schema rather than the definer, and it therefore relies on the APPS synonym layer for access to the underlying application tables.

The package belongs to the CRM Service / depot repair family of objects and bridges the field service requirements captured in the CSP requirement tables with Oracle Purchasing requisitions and Oracle Order Management sales order lines. In the ETRM 12.2.2 metadata it carries the API classification OTHER and is referenced by ten other packages, which confirms that it functions as a shared internal utility rather than an end-user-facing interface. The header comment records its original creation in 2001 and a revision in 2011, reflecting long-standing use across 12.1.1 and 12.2.2 installations.

Key Procedures and Functions

The metadata documents seven procedures and functions. Descriptions below reflect documented purpose only; parameter lists are not reproduced because they are not part of the supplied metadata.

• PROCESS_ORDER — Principal driver for internal parts orders, handling creation, update, or cancellation of the order as a whole.
• PROCESS_PURCHASE_REQ — Creates or maintains the associated purchase requisition for the parts order, including requisition distribution records.
• CANCEL_ORDER — Cancels an entire internal parts order.
• CANCEL_ORDER_LINE — Cancels an individual line on an internal parts order.
• BOOK_ORDER — Books the order so that it becomes an active, transactable document.
• UPD_OE_LINE_SHIP_METHOD — Updates the shipping method on an Oracle Order Management order line associated with the parts order. This is the object retrieved by the search term "upd_oe_line_ship_method".
• UPD_OE_SHIP_TO_ADD — Updates or supplies the ship-to address on the corresponding OE order.

Tables Accessed

The package references the following tables through APPS synonyms. Financial and requisition data is held in PO_REQ_DISTRIBUTIONS_ALL, the source of the Req_dist_Rec_type record defined in the package specification. CSP_REQUIREMENT_HEADERS, CSP_REQUIREMENT_LINES, and CSP_REQ_LINE_DETAILS hold the service requirement structure that drives the parts demand. CSP_RS_CUST_RELATIONS and CS_INCIDENTS_ALL link the requirement to the customer relationship and the service incident.

Customer and address data is resolved from HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES, and HZ_CUST_ACCT_SITES_ALL. Organization context comes from HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION, accounting context from GL_CODE_COMBINATIONS and FINANCIALS_SYSTEM_PARAMETERS / FINANCIALS_SYSTEM_PARAMS_ALL, and audit context from FND_USER.

Usage Notes

CSP_PARTS_ORDER is normally invoked from Oracle Service forms, depot repair and spares replenishment flows, and concurrent programs that convert service requirements into internal requisitions and OE order lines. Because ten other packages reference it, it is also common to see it called from custom PL/SQL that must create or amend parts orders programmatically. Updates to shipping method or ship-to address should always be routed through UPD_OE_LINE_SHIP_METHOD and UPD_OE_SHIP_TO_ADD rather than direct DML against OE tables, so that order line validation and audit columns are maintained correctly. Callers should ensure the environment is initialized with FND_GLOBAL and MO_GLOBAL context before invocation.