Search Results process_cancel_quantity

Overview

APPS.OE_OE_FORM_CANCEL_LINE is a private PL/SQL package body in Oracle E-Business Suite Order Management (OE) that implements the line-level cancellation logic invoked from the Sales Orders (OE_ORDER) form. Its name indicates its role as the form-side driver for cancelling order lines or reducing ordered quantities, complementing the public OE_Order_PUB API layer. The header comment block identifies the package as "Private," with an API name of OE_OE_FORM_CANCEL_LINE and a current version of 1.0. The package body declares global line record structures (g_line_rec and g_db_line_rec) of type OE_Order_PUB.Line_Rec_Type to cache the in-form line and its database image, supporting the multi-record block interaction typical of the Sales Orders form. The $Header directive shows the file OEXFCANB.pls at version 120.3.12020000.4, shipped 2013/04/10, indicating active maintenance through the 12.1.x and 12.2.x release cycles. The package is classified as API type "OTHER" and is referenced by seven other packages, reflecting its position as a shared form-level utility rather than a callable public interface.

Key Procedures and Functions

• PROCESS_CANCEL_QUANTITY — The primary documented routine and the target of the "set_flag" search. It processes a set of record identifiers passed in as an OE_GLOBALS.Selected_Record_Tbl for multi-org access control, applying a cancel-to quantity, cancellation comments, reason code, and cancellation type. The local variable set_flag VARCHAR2(1) := 'N' was introduced under bug# 2233213 to track state while iterating the selected records, and the loop control variables (j, initial, nextpos) support parsing of that record table. The procedure exposes standard concurrent-style OUT parameters for message count, message data, return status, and error count.
• PROCESS_CANCEL_ORDER — Handles cancellation at the order level, cascading the cancellation request across the lines belonging to the order.
• CANCEL_REMAINING_ORDER — Cancels the outstanding or unreserved balance of an order, typically invoked when the user chooses to cancel remaining quantity from the form.
• CALL_PROCESS_ORDER — A wrapper that routes the cancellation request into the order processing flow, invoking the OE_Order_PUB layer on behalf of the form.

An internal FUNCTION Get_line and a private cursor prg_parent are also defined in the body; Get_line retrieves a cached Line_Rec_Type, optionally from the database.

Tables Accessed

• OE_PRICE_ADJUSTMENTS — Read to identify existing price adjustment definitions relevant to the lines being cancelled, ensuring adjustments remain consistent after cancellation.
• OE_PRICE_ADJ_ASSOCS — Read to resolve the association between price adjustments and the affected order lines.
• PLITBLM — The Order Management line interface/interface-table synonym, used in the form-driven flow to stage or validate line-level changes.

Actual line and order persistence is performed through OE_Order_PUB, which the package calls rather than updating OE_ORDER_LINES_ALL directly.

Usage Notes

The package is not intended for direct customer invocation. It is invoked by the Sales Orders form when a user cancels a line, cancels an entire order, or cancels the remaining quantity of an order, and it delegates the transactional work to OE_Order_PUB using the standard return-status and message-count conventions. Because it is marked Private and carries no public API classification, customizations should call OE_Order_PUB.Process_Order instead. For diagnostics, the set_flag variable inside PROCESS_CANCEL_QUANTITY is a local state marker only and has no external significance; tracing it requires debugging the package body at runtime.