Search Results c_source_type

Overview

APPS.OE_DEFAULT_SOURCE_TYPE_PVT is an internal (private) API package in Oracle Order Management whose purpose is to determine the default source type — that is, the fulfillment origin such as Internal, External, or a purchase/pick release — for an order line during Order Import or line-defaulting processing. The single business function it serves is to answer the question: given an item, a cycle, a line type, and related order attributes, what sourcing model should the line default to? The package body is versioned as OEXVDSTB.pls and constructs its result through the standard Oracle EBS PL/SQL API toolkit pattern (FND_API), returning a status, message count, and message data along with the derived source type and its internal source type identifier. As a PVT (private) classification package, it is not intended as a public integration point; it is called internally by Order Management defaulting logic.

Key Procedures and Functions

• GET_DEFAULT_SOURCE_TYPE — The only documented procedure in the package. It accepts order-context inputs (item, cycle, line type, option flag, item type, and optional warehouse) and returns the resolved source type identifier along with a source type value, plus the standard API return status, message count, and message data outputs. Internally it checks API compatibility via FND_API.Compatible_API_Call, validates that required inputs are supplied, and raises FND_API.G_EXC_UNEXPECTED_ERROR on version mismatch or returns FND_API.G_RET_STS_ERROR on missing mandatory inputs. The literal c_source_type serves as a local cursor/loop variable of type VARCHAR2(80) that carries the candidate source type string derived from the item/cycle/line-type combination before it is returned to the caller.

Tables Accessed

• MTL_SYSTEM_ITEMS — Referenced via the APPS synonym to validate the item and establish whether the item is defined in the specified organization or inventory context, which drives the org-specified / item-in-org logic used to select the correct default source type.
• SO_CYCLE_ACTIONS — Referenced to read the cycle/action configuration for the order cycle, correlating purchasing and pick-release actions (the package declares constants PURCHASERELEASE = 17 and PICKRELEASE = 2) with the source type ultimately returned.

The package performs validation reads only; it is not documented to insert or update data in these tables.

Usage Notes

OE_DEFAULT_SOURCE_TYPE_PVT is invoked internally by Order Management defaulting and Order Import flows rather than by end users directly. Typical invocation context is the order line defaulting engine, which calls GET_DEFAULT_SOURCE_TYPE when populating the source type attribute on a new or imported order line. It may also be reached from Order Management forms (for example, Sales Orders) when a line is entered or defaulted, and from custom extensions that need to reproduce the standard sourcing-default behavior. Callers should supply all mandatory inputs (item, cycle, line type, option flag, and item type), as the procedure returns an error status without deriving a value when any are null. A warehouse value of -99 is normalized to NULL by the procedure, and a non-null warehouse sets the org-specified flag to 'Y'. As a private package, its signature is subject to change across patches and it should not be treated as a supported public API; dependent logic should reference it only where standard Order Management behavior must be preserved.