Search Results is_serial_range_valid

Overview

CSD_INTERNAL_ORDERS_PVT is an internal, private (PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Enterprise Asset Management (eAM) / Depot Repair foundation, more specifically the component of the supply chain functionality that governs internal orders — requisitions, internal sales orders, internal move orders, picking, shipping, and receiving transactions between internal organizations. The package encapsulates the business logic that moves material and serialized inventory through internal supply arrangements, allowing maintenance, repair, and service organizations to transfer goods between warehouses, subinventories, and organizations while preserving serial number control.

The "_PVT" suffix indicates that the package is an implementation-layer API. It is not intended for direct customer invocation; public APIs typically wrap these private procedures with validation, defaults, and error handling via FND_API. Consistent with this role, the package depends on FND_API for its standard API return status conventions (for example, FND_API.G_RET_STS_SUCCESS) and on JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100 for handling multi-row ID and name collections passed between the public and private layers.

Key Procedures and Functions

ETRM documents eleven entry points. Because this is a private package, parameter lists are intentionally omitted; the procedures are described by purpose:

• CREATE_INTERNAL_REQUISITION — Creates an internal requisition that drives a demand for goods from another organization.
• CREATE_INTERNAL_SALES_ORDERS — Creates the corresponding internal sales order that fulfills an internal requisition.
• CREATE_INTERNAL_MOVE_ORDERS — Creates an internal move order for transferring material within or between organizations.
• PICK_RELEASE and PICK_RELEASE_INTERNAL_ORDER — Release picking activities for internal orders; the second variant applies the logic specifically to internal order lines.
• SHIP_CONFIRM_INTERNAL_ORDER — Confirms shipment of an internal order, typically updating shipping and inventory transaction records.
• RECEIVE_INTERNAL_ORDER — Confirms receipt of an internal order at the destination organization, creating receiving transactions.
• IS_SERIAL_RANGE_VALID — Validates that a range of serial numbers is valid for the items being moved, ensuring serial control integrity.
• GET_ALL_INTERNAL_ORDERS — Retrieves the set of internal orders matching supplied criteria.

Additional internal helpers exist but are not separately documented.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

• MTL_TXN_REQUEST_HEADERS — Move order headers.
• MTL_MATERIAL_TRANSACTIONS, MTL_MATERIAL_TRANSACTIONS_TEMP — Inventory transaction records and staging.
• MTL_RESERVATIONS — Inventory reservations for picking.
• MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP, MTL_SERIAL_NUMBERS_INTERFACE — Serial number assignment, validation, and interface.
• MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV — Item definitions and descriptive flexfield views.
• MTL_ITEM_SUB_DEFAULTS, MTL_PARAMETERS — Subinventory defaults and organization inventory parameters.
• CSD_PRODUCT_TRANSACTIONS, CSD_PRODUCT_TRANSACTIONS_S1 — Depot Repair product transaction records.
• FND_USER, HR_ORGANIZATION_INFORMATION — User and organization context.

Usage Notes

CSD_INTERNAL_ORDERS_PVT is referenced by CSD_REPAIRS_UTIL and CSD_REPAIR_MANAGER_UTIL, and is called from the public CSD_INTERNAL_ORDERS_PVT layer as well as Oracle Depot Repair forms and concurrent processes that manage internal material movement for repair work orders. Custom code should not call this package directly; the supported approach is to invoke the corresponding public API in the CSD schema, which performs validation and error handling on top of the private layer.