Results for “csm_orders_pkg”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.CSM_ORDERS_PKG is a server-side PL/SQL package that belongs to the Oracle E-Business Suite service supply chain module, commonly associated with the Depot Repair, Field Service, and returns/receiving flows delivered under the CSM (Customer Service Management) schema prefix. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking schema rather than the definer, which is typical for EBS APIs that must respect the caller's access to the underlying service tables and their APPS synonyms.
The header comment in the package specification indicates it was created in May 2012 and carries a version label consistent with the 12.2 code line (120.0.12020000.2), so the object is present in both 12.1.1 and 12.2.2 environments although its documented behavior is captured against the 12.2.2 ETRM repository. Functionally, the package encapsulates two distinct responsibilities: applying pending client-side changes to service order data, and recording the receipt of quantities against service order lines. It therefore acts as a thin business API layer between the user interface or upstream integration code and the CSM order tables.
Key Procedures and Functions
The package specification exposes two documented procedures:
- APPLY_CLIENT_CHANGES — Accepts a user name, a transaction identifier, and a debug level, and returns a status indicator through an IN OUT NOCOPY parameter. The procedure applies changes that were staged on the client (for example, in a forms block or a mobile device cache) into the database in the context of the supplied transaction. The
x_return_statusparameter follows the standard EBS convention of returning a success, warning, or error code so that callers can branch on the outcome. - RECEIVE_ORDER — Records receipt of a specified quantity against a service order line identified by
p_line_idandp_received_qty. It returns a CLOB result payload together with a return status and an error message, which allows the caller to process structured output — such as line-level validation results or updated order state — in addition to simple success or failure signalling. This is the entry point most relevant to the search term receive_order.
Tables Accessed
According to the documented table references, the package operates against three objects exposed through APPS synonyms:
- CSM_ORDER_LINES_INQ — an inquiry-oriented view or table over service order lines. It supplies the line context (line identifier, ordered quantity, status) that RECEIVE_ORDER needs in order to validate and post a receipt.
- CSM_REQ_LINE_DETAILS_ACC — the detail/accounting layer for requisition or requirement lines associated with the service order, used to keep the financial and fulfillment attributes synchronized when a receipt is applied.
- CSP_REQ_LINE_DETAILS — the base requirement line detail table in the CSP schema family, consulted for the underlying requirement record that the order line fulfills.
Together these tables indicate that receipt processing is not a simple update of a single line; the package reconciles order line, requirement detail, and accounting detail records so that downstream fulfillment and costing remain consistent.
Usage Notes
CSM_ORDERS_PKG is not intended to be called directly by end users. It is normally invoked from the Depot Repair or Field Service order forms when a user confirms receipt of parts or services, from concurrent programs that batch-process receipts, or from custom PL/SQL integrations that need to post receipts programmatically. Because the package metadata records one other package as a referencer, callers should be aware that it participates in a small dependency chain and that the standard EBS error-handling pattern applies: always inspect x_return_status and, where populated, x_error_message before committing. The CLOB result parameter in RECEIVE_ORDER should be parsed by the caller when structured feedback is required. As with all EBS service APIs, the transaction should be committed or rolled back by the calling code, not by the package itself.
-
PACKAGE: APPS.CSM_ORDERS_PKG 12.2.2
-
PACKAGE: APPS.CSM_ORDERS_PKG 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2