Search Results create_valid_category

Overview

INV_ITEM_CATEGORY_PVT is a private PL/SQL package in the APPS schema that encapsulates the core business logic governing item-to-category assignments in Oracle E-Business Suite. It belongs to the INV (Inventory) product family and is classified as a PVT-layer API, meaning it is intended for internal use by the public API layer rather than for direct invocation by external consumers. The package is responsible for validating category set structures, maintaining valid category definitions, and creating, updating, and removing item-category relationships recorded in the MTL_ITEM_CATEGORIES table. By isolating this logic, the package provides a reusable, consistent mechanism through which both standard EBS products and customized extensions manipulate item categorization without bypassing application validation rules.

The ETRM metadata confirms the package is VALID and has documented dependencies on FND_API and the SYS.STANDARD library, reflecting adherence to the Oracle Application Object Library API conventions. It is referenced by several other packages, including INV_ITEM_CATEGORY_PUB, INV_ITEM_CATEGORY_OI, and ENI_UPGRADE_VSET, which indicates it functions as the workhorse behind the publicly exposed category APIs.

Key Procedures and Functions

The ETRM metadata documents five entry points within the package. The names and purposes are as follows:

• CREATE_CATEGORY_ASSIGNMENT — Establishes a new association between an inventory item and a category within an enabled category set. This is the primary routine for assigning categories to items.
• UPDATE_CATEGORY_ASSIGNMENT — Modifies an existing item-category relationship, typically used when changing which category within a set an item belongs to.
• DELETE_CATEGORY_ASSIGNMENT — Removes an existing item-category association, cleaning up the corresponding record so that reporting and item classification remain accurate.
• CREATE_VALID_CATEGORY — Creates a valid category entry within a category set, defining the set of permissible categories that items may ultimately be assigned to.
• UPDATE_VALID_CATEGORY — Maintains and modifies previously defined valid category records, supporting changes in the category hierarchy or naming within a set.

No parameter lists are documented in the ETRM excerpt; consumers should defer to the actual package specification rather than assuming argument signatures.

Tables Accessed

The package operates against several core Inventory reference tables, accessed through APPS synonyms. MTL_ITEM_CATEGORIES is the principal transactional table written by the assignment routines, storing the item-to-category mapping. MTL_CATEGORIES_B, MTL_CATEGORY_SETS_B, and MTL_CATEGORY_SET_VALID_CATS hold the category set definitions and the valid categories within each set, and are read during validation of the CREATE_VALID_CATEGORY, UPDATE_VALID_CATEGORY, and assignment routines. MTL_DEFAULT_CATEGORY_SETS identifies which category sets are flagged as default for an item, while MTL_SYSTEM_ITEMS_B supplies the item master records being categorized. MTL_PARAMETERS provides inventory organization-level setup values, such as the default category set configuration, that influence which sets may be applied during assignment. Together, these tables allow the package to enforce that every category assigned to an item is valid within an enabled, default-designated category set for the relevant organization.

Usage Notes

As a PVT-layer package, INV_ITEM_CATEGORY_PVT is not intended for direct invocation by custom code or reports. Developers should instead call the public API INV_ITEM_CATEGORY_PUB, which wraps this private package and exposes the supported, documented entry points for item-category maintenance. Standard EBS forms, such as the Item Master and Item Relationships forms, ultimately drive these routines when users assign or update categories on items. Concurrent programs that load or migrate item categorization data, and upgrade routines such as ENI_UPGRADE_VSET, also invoke this package as an internal dependency. When extending categorization logic, the recommended approach is to validate against the same MTL_CATEGORY_SET_VALID_CATS and MTL_DEFAULT_CATEGORY_SETS rules that this package enforces, ensuring data integrity across both 12.1.1 and 12.2.2 releases, where the package remains valid and structurally consistent.