Search Results g_hazard_class

Overview

INV_EBI_ITEM_PUB is a public PL/SQL API package owned by the APPS schema in Oracle E-Business Suite. It exposes the item-processing interface used by the EBI (Enterprise Business Integration) item layer, providing a programmatic entry point for creating, updating, deleting and synchronizing inventory items and item revisions. The package is classified as PUB, indicating that it forms part of the supported public API surface and may be called from outside its immediate schema.

The package is built around a strongly typed data model. Its specification declares a set of constants that define the accepted operation types (G_OTYPE_CREATE, G_OTYPE_DELETE, G_OTYPE_UPDATE, G_OTYPE_SYNC) and the accepted data levels (G_DATA_LEVEL_ITEM, G_DATA_LEVEL_ITEM_REV). It also defines a numeric entity map — G_INVENTORY_ITEM, G_ORGANIZATION, G_ITEM_CATALOG_GROUP, G_LIFECYCLE, G_CURRENT_PHASE, G_REVISION, G_HAZARD_CLASS, G_ASSET_CATEGORY, G_MANUFACTURER, G_CATEGORY_SET and G_CATEGORY — along with a pair of balance identifiers (G_ITEM_BALANCE, G_ITEM). These constants establish the vocabulary used by the interface tables that feed the package. The user search term "g_inventory_item" corresponds to the constant G_INVENTORY_ITEM (value 2), one of the entity identifiers declared at line 11 of the specification.

Key Procedures and Functions

The package documents five public procedures. Their purpose is as follows; parameter details beyond those provided in the metadata are not restated here.

• VALIDATE_ITEM — Performs validation of a single item supplied as an inv_ebi_item_obj record. It accepts a transaction type and returns an output object of type inv_ebi_item_output_obj containing the validation result, allowing callers to detect item-level errors before committing any data.
• PROCESS_ITEM — Executes a single-item operation. It takes a commit flag, an operation type (one of the G_OTYPE_* constants) and an item object, and returns an output object. This is the primary single-record maintenance entry point for the item and item revision data levels.
• PROCESS_ITEM_LIST — Performs the same processing logic as PROCESS_ITEM but operates against a collection of items (inv_ebi_item_obj_tbl). It is the bulk variant used when many items must be processed in one call, with the same commit control and operation semantics.
• GET_ITEM_BALANCE — Retrieves balance information for a supplied list of items. It returns an item balance output collection together with the standard EBS return status, message count and message data out parameters.
• GET_ITEM_ATTRIBUTES — Returns the attributes of a list of items. It accepts both an item list and a name/value list, and returns an item attribute table object along with the standard return status, message count and message data parameters.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed through its APPS synonym. This is the item interface/entity table used to stage item records before and during processing. The package reads from and writes to this table as part of the validate and process flows, using the entity identifiers (including G_INVENTORY_ITEM) to route each row to the correct processing logic. Because the package is an API layer over this staging table, all persistence of item changes is mediated by the table rather than by direct DML on the base inventory item tables.

Usage Notes

INV_EBI_ITEM_PUB is a published API and is referenced by three other packages, which is the typical pattern for an EBI item integration layer: a feeder or wrapper package populates the interface structures and calls the PUBLIC API to validate and process them. Custom code and integration programs should follow the same convention, calling VALIDATE_ITEM or PROCESS_ITEM for single records and PROCESS_ITEM_LIST for bulk loads, and should always inspect the returned output object, x_return_status, x_msg_count and x_msg_data rather than assuming success. The package is relevant to both 12.1.1 and 12.2.2 environments, where it remains the supported route for programmatic item create, update, delete and sync operations within the EBI framework.