Search Results get_line_ids

Overview

APPS.OE_CNCL_UTIL is a utility package within the Oracle Order Management module of Oracle E-Business Suite. Its documented API classification is UTIL, indicating that it provides low-level helper routines consumed by other order management packages rather than exposing standalone business transactions. The package header is dated 2005 and carries the source identifier OEXVCGIS.pls. Its primary role is to support cancellation, retrieval, and defaulting logic operating against the public Order Management record structures defined in OE_Order_PUB.

The package is referenced by one other package, confirming its role as an internal dependency. The routines it exposes manipulate the standard OE_Order_PUB record types—Header_Rec_Type, Line_Rec_Type, Header_Scredit_Rec_Type, Line_Scredit_Rec_Type, Header_Adj_Rec_Type, and Line_Adj_Rec_Type—which are the canonical parameter structures passed between Order Management APIs. The source header explicitly notes "noship," consistent with a utility dependency rather than a directly invokable API.

Key Procedures and Functions

Seven documented procedures are exposed by this package:

• GET_HEADER_IDS – Populates header identifier values on the OE_Order_PUB header record, returning them through the IN OUT NOCOPY header record parameter.
• GET_LINE_IDS – Populates identifier values on the OE_Order_PUB line record.
• GET_HEADER_SCREDIT_IDS – Populates identifier values on the OE_Order_PUB header sales credit record.
• GET_LINE_SCREDIT_IDS – Populates identifier values on the OE_Order_PUB line sales credit record.
• GET_HEADER_ADJ_IDS – Populates identifier values on the OE_Order_PUB header adjustment record.
• GET_LINE_ADJ_IDS – Populates identifier values on the OE_Order_PUB line adjustment record.
• CONVERT_MISS_TO_NULL – Overloaded six times, accepting each of the six OE_Order_PUB record types listed above. The procedure converts Oracle Forms "MISS" (missing) values into SQL NULL values. This transformation is required because Forms represents a missing value differently from a database NULL, and Order Management APIs require true NULLs to interpret parameters correctly.

Tables Accessed

The package operates against the following base tables via APPS synonyms:

• OE_ORDER_HEADERS – Header-level order data, used as the source for the GET_HEADER_IDS identifier retrieval logic.
• OE_ORDER_LINES – Line-level order data, used as the source for the GET_LINE_IDS identifier retrieval logic.

These tables are referenced indirectly: the ID procedures resolve surrogate and primary key identifiers associated with the order structures being cancelled or processed, ensuring that subsequent API calls receive properly populated identifiers rather than Forms-default MISS values.

Usage Notes

OE_CNCL_UTIL is not intended for direct invocation by end users or standalone custom code. It is a supporting utility invoked internally by higher-level Order Management packages such as the order cancellation and order import logic. Two integration patterns dominate its use. First, Oracle Forms-based order entry transmits records containing MISS values; CONVERT_MISS_TO_NULL is called to normalize those records before they are supplied to OE_Order_PUB APIs. Second, the GET_*_IDS procedures resolve identifier values for header, line, sales credit, and adjustment records, allowing dependent packages to synchronize record identifiers during cancellation processing.

Because the package is documented as referenced by one other package and carries a "noship" header, customizations should avoid calling it directly unless the calling context replicates the exact OE_Order_PUB record structures the procedures expect. In 12.1.1 and 12.2.2 the package remains a compiled PL/SQL dependency of the Order Management cancellation stack and requires no separate setup.