Search Results clear_carton_count

Overview

INV_LABEL_PVT8 is a private PL/SQL package in the APPS schema within Oracle E-Business Suite. It is a component of the Inventory label printing architecture, which supports the generation and formatting of labels (such as LPN, cartonization, and material transaction labels) produced during warehouse and inventory operations. The suffix "PVT8" identifies this package as the eighth private helper in a series of label-printing packages (INV_LABEL_PVT1 through INV_LABEL_PVTn) that collectively supply the variable data and attributes used by the public INV_LABEL package and the Oracle Label Printing framework.

The package is classified as API classification OTHER and is not intended for direct customer invocation. Its principal role is to resolve the contents of label variables for specific transaction contexts and to manage cartonization counting used during label rendering. The header comment ("$Header: INVLAP8S.pls 120.1 ... noship $") and the "noship" attribute indicate that this is an internal, non-seeded object shipped as part of the Inventory application code base.

Key Procedures and Functions

The package exposes four documented procedures:

• GET_VARIABLE_DATA (LONG overload) — Populates an output variable content value of type LONG for a given label type and transaction context, returning status, message count, and message data. It accepts the label type information, a transaction identifier, a row of MTL_MATERIAL_TRANSACTIONS_TEMP, and a transaction identifier number as inputs.
• GET_VARIABLE_DATA (label table overload) — The second overload performs the same logical function but returns the variable content as a collection of type INV_LABEL.label_tbl_type, allowing multiple label variables or multi-line values to be assembled at once.
• SET_CARTON_COUNT — Establishes the cartonization context by cartonization identifier, allowing subsequent label variable resolution to determine the current carton count for the identified cartonization record.
• CLEAR_CARTON_COUNT — Resets the carton count state, ensuring that a stale cartonization context does not leak into subsequent label generation calls.

The package declares a private collection type, all_lpn_tbl, as a table of numbers indexed by BINARY_INTEGER, used internally to track LPN identifiers associated with the label context.

Tables Accessed

The package reads and references data from a broad set of Inventory, Human Resources, and Trading Community (HZ) tables via APPS synonyms, reflecting the mix of inventory, location, and customer information that appears on labels:

• Inventory tables: MTL_MATERIAL_TRANSACTIONS_TEMP (the pending transaction driving the label request) and MTL_CUSTOMER_ITEMS (customer item definitions printed on outbound labels).
• Location tables: HR_LOCATIONS_ALL and HZ_LOCATIONS supply organization and address details for ship-from, ship-to, and internal location labels.
• Customer and party tables: HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, HZ_PARTY_SITES, and HZ_RELATIONSHIPS provide customer, account, site, and contact information.
• Geography and contact tables: HZ_GEOGRAPHIES, HZ_GEO_NAME_REFERENCE_LOG, HZ_GEO_STRUCT_MAP, and HZ_CONTACT_POINTS resolve geographic and contact details rendered as label variables.

Usage Notes

INV_LABEL_PVT8 is invoked indirectly through the label printing framework. When a user initiates a label print or reprint from Oracle Inventory forms (such as the Receiving, Material Transactions, or Move Order forms) or from the LPN and cartonization flows, the public INV_LABEL package routes variable resolution to the appropriate private package based on the label type being processed. INV_LABEL_PVT8 handles the specific label types and variable sets assigned to it within that dispatch logic.

Because the package is private and non-seeded, custom code should not call it directly. Customizations requiring additional label variables should extend through the supported label printing interfaces or develop a separate private package consistent with the framework's dispatch mechanism. The SET_CARTON_COUNT and CLEAR_CARTON_COUNT procedures establish and release session-local cartonization state, so callers within the framework must ensure CLEAR_CARTON_COUNT is invoked after label generation to avoid incorrect counts on subsequent labels. The package is referenced by one other package within the Inventory label printing layer, confirming its role as a dependent helper rather than an entry point.