Search Results inv_label_pvt9




Overview
Explore in AI Chat

Overview

APPS.INV_LABEL_PVT9 is a private PL/SQL package within the Oracle E-Business Suite Inventory (INV) module, shipped under the version header INVLAP9S.pls (120.0.12010000.1, dated 2008/07/24). It is declared with AUTHID CURRENT_USER, meaning the package executes with the privileges of the invoking schema rather than the definer, which is standard for an EBS private API invoked from within the APPS runtime environment.

The package belongs to the family of inventory label printing private APIs, whose collective purpose is to assemble the variable data content that is rendered onto material transaction labels and related documents. INV_LABEL_PVT9 is a specialized member of that family, dedicated to resolving the data elements required by the label types assigned to it. The G_PKG_NAME constant identifies the package for error handling and message lookup purposes. It is referenced by one other package, confirming its role as a subordinate utility rather than a standalone entry point.

Key Procedures and Functions

The package exposes two overloaded specifications of a single procedure, GET_VARIABLE_DATA. Both overloads share the same parameter contract in the metadata; the distinguishing characteristic is the data type of the primary output parameter, x_variable_content, which returns either a LONG scalar or an INV_LABEL.label_tbl_type collection.

  • GET_VARIABLE_DATA (LONG overload) — Returns the resolved label variable content as a LONG value, together with standard EBS output diagnostics: x_msg_count, x_msg_data, and x_return_status. It accepts a label_type_rec describing the label definition, a p_transaction_id, a row of MTL_MATERIAL_TRANSACTIONS_TEMP as p_input_param, and a p_transaction_identifier.
  • GET_VARIABLE_DATA (table overload) — Functionally equivalent, but returns x_variable_content as an INV_LABEL.label_tbl_type collection, enabling callers to consume the variable content in structured, row-by-row form rather than as a single LONG string.

The overloaded design allows the label generation framework to select the most appropriate output representation based on the label type being processed.

Tables Accessed

The package reads from a broad set of Inventory, Bills of Material, Costing, Purchasing, Projects, and Work in Process tables through APPS synonyms. Key references include:

Usage Notes

INV_LABEL_PVT9 is not intended for direct invocation by end users or external integrations. It is invoked internally by the inventory label printing infrastructure, most likely from a coordinating label package that dispatches to a numbered series of INV_LABEL_PVT* packages based on label type. Typical runtime paths include the Oracle Inventory label printing concurrent program and inventory transaction forms that trigger label output. Custom code should call the public INV_LABEL API rather than this private package, since private APIs are unsupported for direct use and subject to change across patch levels.