Search Results get_locator_control

Overview

APPS.PO_SUBINVENTORIES_S is a client-level PL/SQL package body in the Oracle E-Business Suite Purchasing module. Its primary business function is server-side validation of subinventory and locator attributes supplied during Purchasing transactions that reference inventory destinations, receiving, and internal requisition flows. The package encapsulates the rules that determine whether a given subinventory, and by extension a locator within that subinventory, is valid for a specified organization, item, transaction date, and destination type.

The source header identifies the file as POXCOS1B.pls (version 115.9, last modified 2002/11/25). The naming convention and body structure confirm that the package is a client-side wrapper generated against a server package, providing validation routines consumed by Purchasing forms and APIs. The package is registered in the ETRM repository with the owner APPS and is classified as an OTHER API type rather than a public, supported interface.

Key Procedures and Functions

The ETRM metadata documents 11 procedures or functions. The most relevant to the search term "get_locator_control" are described below:

• GET_LOCATOR_CONTROL — Returns the locator control setting governing whether a locator value must be supplied for a subinventory. This function is central to determining if a user must enter a locator during transaction entry, based on the locator control flags held in inventory setup tables.
• val_subinventory — Validates a subinventory name against the organization, item, transaction date, and destination type. It returns 0 for success and a non-zero code for failure, and returns 3 when no subinventory is required (for example, when the destination type is not INVENTORY or the subinventory is null). It checks the subinventory's disable date against the transaction date.
• TEST_CHECK_SUB_TRANSFER — Performs a check related to subinventory transfer eligibility, supporting the validation logic used when moving material between subinventories.
• NAME — A generic subprogram entry documented among the package's callable members.

Parameter lists are deliberately not reproduced here. The documented signature of val_subinventory accepts the subinventory, organization, transaction date, item, and destination type as inputs and returns a numeric status.

Tables Accessed

The package reads from the following APPS synonyms:

• MTL_SECONDARY_INVENTORIES — Validates subinventory existence and the DISABLE_DATE relative to the transaction date.
• MTL_ITEM_LOCATIONS and MTL_SECONDARY_LOCATORS — Support locator validation and locator control resolution.
• MTL_ITEM_LOC_DEFAULTS and MTL_ITEM_SUB_DEFAULTS — Supply default locator and subinventory behavior for items.
• MTL_ITEM_SUB_INVENTORIES — Confirms item-to-subinventory assignment.
• MTL_PARAMETERS — Provides organization-level inventory parameters.
• MTL_INTERORG_PARAMETERS — Supports inter-organization transfer validation.
• MTL_SYSTEM_ITEMS — Confirms item attributes used in validation.

Usage Notes

PO_SUBINVENTORIES_S is invoked primarily from Purchasing forms and internal APIs during validation of inventory-destined lines, including requisitions, purchase orders, and receiving. Custom code that must emulate Purchasing subinventory or locator validation can call GET_LOCATOR_CONTROL to resolve locator control before prompting for a locator, and val_subinventory to confirm subinventory eligibility. The package body is referenced by 7 other packages, indicating its role as a shared validation utility. Because the package is classified as an OTHER API and is not a supported public interface, Oracle does not guarantee its signature across releases, so custom callers should isolate dependencies.