Search Results get_order_category

Overview

APPS.OE_ORDER_COPY_UTIL is a utility package within the Oracle Order Management module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Its principal business function is to support the copying of sales order headers and lines, including the propagation of associated pricing attributes, descriptive flexfields (DFF), line sets, and payment-related information. The package encapsulates the logic required when an order or line is duplicated — either through standard order copy actions, RMA creation from a regular order, version-based copies, or reference-based line copies.

The package is classified as a UTIL API within ETRM and exposes a set of helper procedures invoked internally by Order Management infrastructure rather than as a standalone user-facing entry point. Several global package variables and constants define copy behavior, including pricing modes such as G_CPY_ORIG_PRICE, G_CPY_REPRICE, G_CPY_REPRICE_WITH_ORIG_DATE, and G_CPY_REPRICE_PARTIAL, and flags controlling split-line handling, canceled-line deletion, and regular-to-RMA conversion. R12 credit card encryption is also supported via flags such as G_Create_Payment_Flag and G_Payment_Type_Code.

Key Procedures and Functions

The package documents eight procedures and functions. GET_COPY_REC retrieves the copy record used to drive the duplication of order or line data. GET_ORDER_CATEGORY returns the order category, which governs which copy rules apply. GET_DEFAULT_LINE resolves the default line attributes to be applied when copying. GET_LINE_CATEGORY returns the category of an order line, similarly influencing copy logic. COPY_ORDER performs the copy of a sales order header and its associated lines. COPY_LINE_DFF_FROM_REF copies descriptive flexfield data from a referenced line. CALL_DFF_COPY_EXTN_API invokes the DFF copy extension API to propagate flexfield values. COPY_LINE_SETS copies line set associations between source and target lines.

Tables Accessed

The package operates against core Order Management tables referenced through APPS synonyms. OE_ORDER_HEADERS, OE_ORDER_HEADERS_ALL, and OE_ORDER_HEADERS_S provide header data; OE_ORDER_LINES, OE_ORDER_LINES_ALL, OE_ORDER_LINES_S, and OE_ORDER_LINES_HISTORY supply line and historical line information. Line set copying relies on OE_LINE_SETS, OE_SETS, and OE_SETS_S. OE_TRANSACTION_TYPES_ALL supplies transaction type context, and OE_PAYMENTS supports payment-related handling, including R12 credit card encryption scenarios. The temporary table OE_COPY_LINE_SORT_TMP is used for ordering and sequencing copied lines, while DUAL and PLITBLM are used for utility and PL/SQL table operations.

Usage Notes

OE_ORDER_COPY_UTIL is typically invoked indirectly by Order Management forms and concurrent programs that perform order copy, line copy, RMA creation, or version-based duplication. The package is referenced by seven other packages, confirming its role as a shared utility layer rather than a public API. The presence of the search term "line_scredits" suggests a common point of confusion: this package does not manage service credits directly; any line credit behavior observed during copy operations is a byproduct of copying line, pricing, and DFF data. Customizations should call the package only through the higher-level Order Management APIs that already invoke it, and developers should be aware that copy mode is controlled through the documented constants rather than through direct parameter injection.