Search Results get_reason_code

Overview

GML_INTORD_LOT_STS is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the Process Manufacturing (OPM / GML) family of modules. Its central purpose is to derive, validate, and govern lot status information as it flows between shipping, receiving, inventory, and order management activities. In the Oracle EBS 12.1.1 and 12.2.2 technical stacks, the package is a supporting utility that bridges lot-controlled inventory in process manufacturing warehouses with the transactional requirements of internal orders and provisional or pending receipt processing.

The package is designated with an API classification of OTHER, indicating it is a documented but non-public interface rather than a formally published open API. The header comment identifies the module as a "noship" object, reflecting its internal utility nature. The package encapsulates logic for evaluating whether a lot may be transacted and for determining the correct lot status to apply during PORC (provisional, order, receipt, or consumption) transaction creation.

Key Procedures and Functions

Three documented procedures or functions comprise the package's public surface:

• DERIVE_PORC_LOT_STATUS — Returns the lot status used when creating PORC transactions. It accepts item, warehouse, lot, location, and shipped-lot-status inputs and resolves the appropriate receipt lot status, determines whether the transaction is allowed, and returns a status indicator plus message data. It is the core status-resolution routine in the package.
• CHANGE_INV_LOT_STATUS — Handles modification of an existing inventory lot status, providing the mechanism by which a lot transitions from one status to another within the inventory records.
• GET_OMSO_LOT_STATUS — Retrieves lot status information relevant to order management and shipping operations, supporting the outbound/internal order side of lot status determination.

The user search term "get_reason_code" corresponds to reason code handling that supports lot status change justification and security checks, though no separately documented procedure of that exact name appears in the metadata.

Tables Accessed

The package reads and writes a defined set of tables via APPS synonyms, spanning process manufacturing, inventory, and order management:

• GMA_REASON_CODE_SECURITY — validates reason code security when lot status changes require a reason.
• IC_LOTS_MST, IC_LOCT_INV, IC_ITEM_MST, IC_WHSE_MST — provide lot, location inventory, item, and warehouse master data.
• IC_TRAN_PND, IC_ADJS_JNL, IC_JRNL_MST — support pending transactions and adjustment journal posting.
• OE_ORDER_LINES_ALL — supplies order line context for shipping-side lot status.
• SY_REAS_CDS, SY_ORGN_MST — reason code and organization master references.
• PLITBLM — the process manufacturing error/message table used for returning message data.

Usage Notes

GML_INTORD_LOT_STS is typically invoked indirectly by internal order processing, receiving, and inventory adjustment flows rather than by end users. It is referenced by one other package and is likely called during PORC transaction generation and lot status change operations. Custom code and extensions that manipulate lot status in process manufacturing warehouses should route through this package's procedures to preserve reason code security and journal integrity. Because it is an OTHER-classified object, Oracle does not guarantee backward compatibility, and direct calls should be validated against each 12.1.1 or 12.2.2 patch level.