Search Results predefault_child_master

Overview

INVPUTLI is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM repository as an "OTHER" API. Its name reflects its role as an inventory utility library (INV-PUT-LI, i.e., Inventory Utilities) that centralizes low-level defaulting and diagnostic logic used throughout the Inventory (INV) product family. Rather than exposing a formalized business API for external integration, INVPUTLI serves as an internal helper package whose routines are called by other Inventory forms and packages to resolve default values for item attributes, master organization context, and descriptive flexfield segments during item definition and maintenance operations.

The package is significant because it encapsulates the logic that determines how item defaults propagate between the master organization and child organizations, a central concept in Oracle Inventory's multi-organization model. The master_org_id parameter, which appears in multiple signatures, is the key driver of this behavior and explains why the object is frequently surfaced when users search on that term.

Key Procedures and Functions

• INFO — Accepts a message string and is used for informational or diagnostic output, typically surfacing user-friendly messages during defaulting operations.
• GET_DYNAMIC_SQL_STR — Builds a dynamic SQL statement from a numeric identifier, returning the generated SQL text and any error text, with an integer return status. This supports flexible, metadata-driven query construction.
• ASSIGN_MASTER_DEFAULTS — The core defaulting routine. Given a transaction, item, organization, and master_org_id, along with status, UOM, description, and requirement flags, it populates attributes on the master organization record and returns a status code. This is the routine most directly tied to the user's search term.
• ASSIGN_ITEM_DEFAULTS — Applies default values for an item within a specific organization, covering status, UOM, description allowance, requisition requirement, and tax flags, including a receiving flag.
• PREDEFAULT_CHILD_MASTER — Pre-populates attributes for a child organization item using values inherited from the master organization, governed by the master_org_id parameter.
• GET_DEBUG_LEVEL — Returns the current debugging verbosity level, allowing callers to conditionally emit diagnostic output.

Tables Accessed

The package reads and writes against core Inventory item tables through APPS synonyms. MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL, and MTL_SYSTEM_ITEMS_INTERFACE hold item definition and interface data, while MTL_PARAMETERS supplies organization-level inventory parameters. MTL_UNITS_OF_MEASURE and its translation table support UOM defaulting, and MTL_ITEM_CATALOG_GROUPS_B provides catalog group context. Descriptive flexfield metadata is read from FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_COLUMN_USAGES, and FND_ID_FLEX_SEGMENTS, with EGO_INTERFACE_TL supplying interface translations. DBMS_OUTPUT and DBMS_PIPE are used for debug messaging and inter-process signaling.

Usage Notes

INVPUTLI is referenced by 37 other packages, confirming its role as a shared internal utility rather than a standalone integration entry point. It is typically invoked indirectly when users define or update items through the Inventory Item Master form or related concurrent programs, where defaulting logic must reconcile child-organization values against the master organization identified by master_org_id. Custom code should treat these routines as internal, since the package is not documented as a supported public API; direct calls risk disruption across releases such as 12.1.1 and 12.2.2.