Search Results locator_control




Overview
Explore in AI Chat

Overview

QLTINVCB is a PL/SQL package body owned by APPS in the Oracle E-Business Suite. Its purpose is to centralize the control logic used by Oracle Quality (QLT) to derive a locator control setting for inventory transactions. The package reconciles inventory organization, subinventory, and item-level control attributes together with negative-balance restriction flags, and returns a normalized numeric code indicating the effective locator control rule to be applied. The header comment records that the object was created on 20-May-1996 by Paul Mishkin, and the source is versioned as qltinvcb.plb 115.2, shipped 27-Nov-2002. The exact string locator_control appears in the source as a local variable in the CONTROL function, which is the artifact most relevant to a search for that term.

Key Procedures and Functions

  • CONTROL — The primary function of the package. It accepts a set of control parameters (organization control, subinventory control, item control, restrict flag, negative flag, and action) and resolves them into a single numeric locator control value. Its internal logic is hierarchical: organization control of 1, 2, or 3 maps directly to locator control 1, 2, or 3, while values of 4 cause evaluation to descend to subinventory-level controls. Only when subinventory control equals the special value 5 does the function descend further to item-level control. Whenever a negative-balance restriction applies, the resolved locator control is forced to 2.
  • NO_NEG_BALANCE — A boolean helper used by CONTROL to decide whether a negative-balance restriction should be enforced. It evaluates the restrict flag, the negative flag, and the action code, returning TRUE when the action falls within the restricted set (actions 1, 2, 3, 21, 30, or 32) under a restrict flag of 2 or NULL, or whenever the restrict flag equals 1. This function encapsulates the rule that determines when negative on-hand balances must be prevented during a quality-driven inventory transaction.

Tables Accessed

No base tables are documented as referenced through APPS synonyms for this package body. All logic in the excerpt operates exclusively on the scalar parameters passed into its two functions, performing conditional branching to produce a computed value. Consequently, the package is effectively stateless with respect to the database schema and appears intended as a lightweight rules engine callable from other PL/SQL units.

Usage Notes

QLTINVCB is an internal utility rather than an end-user API; the ETRM classification records it as OTHER, and it is referenced by four other packages. It is therefore typically invoked from within Oracle Quality or Inventory transaction-processing code rather than directly from a form or concurrent program, though custom applications may call QLTINVCB.CONTROL to reproduce standard locator and negative-balance control behavior. Because callers pass the control attributes explicitly, the package does not read profile options or organization setup itself, and callers are responsible for supplying accurate organization, subinventory, and item control values. The documented parameter defaults mean callers may omit any argument, and the package behavior remains consistent between 12.1.1 and 12.2.2 through the shared APPS-owned synonym.