Search Results create_abc_assignments




Overview
Explore in AI Chat

Overview

INV_ABC_ASSIGNMENTS_PUB is a public PL/SQL API package in the Oracle E-Business Suite Inventory module that provides a supported interface for creating and maintaining ABC assignment records within the ABC analysis framework. ABC assignments link inventory items to ABC classes through assignment groups, forming the data foundation used by ABC classification reports, cycle count planning, and inventory valuation analysis. ABC assignments are stored in the MTL_ABC_ASSIGNMENTS table and associate a specific inventory_item_id with an assignment_group_id and an abc_class_id. This package encapsulates the validation and persistence logic required to insert or update those associations, shielding callers from the underlying table structure and enforcing consistent validation before any DML is performed.

The header revision string indicates this body was last updated in the 12.2 code line (version 120.0.12020000.1, dated 2013), and the package is classified as PUBLIC within the ETRM metadata for both 12.1.1 and 12.2.2. The package name follows the standard Oracle naming convention, and the internal package constant g_pkg_name identifies it as INV_ABC_Assignments_Pub. A private debug helper, Mydebug, routes trace messages through inv_log_util.Trace, controlled by the INV_DEBUG_TRACE profile option.

Key Procedures and Functions

  • CREATE_ABC_ASSIGNMENTS — The single documented public procedure in this package. It is the API entry point for creating and updating ABC assignments. Based on the record passed in by the caller (containing inventory_item_id, assignment_group_id, and abc_class_id), it delegates to a private API that validates the input and then performs the appropriate insert or update against the ABC assignment data. The procedure follows the Oracle API standards: it accepts an API version number, an initialization flag for the message stack, and a commit flag, and it returns the standard x_return_status, x_msg_count, and x_msg_data out parameters. The API version is defined internally as 1.0, with a corresponding API name constant of 'CREATE_ABC_ASSIGNMENTS'. Because the procedure is governed by the standard API contract, callers must check x_return_status after invocation and inspect x_msg_data and x_msg_count when an error or unexpected status is returned.

Tables Accessed

  • MTL_ABC_ASSIGNMENTS — The sole documented table referenced by this package (accessed via the APPS synonym). It stores the ABC assignment rows that map inventory items to ABC classes within assignment groups. The Create_abc_assignments procedure reads and writes this table, inserting new assignment rows or updating existing ones based on the identifier values supplied in the input record. An internal variable defined against the inventory_item_id column (mtl_abc_assignments.inventory_item_id%TYPE) anchors the processing to that column.

Usage Notes

The package is typically invoked from Oracle Forms (such as the ABC Assignments or ABC Analysis setup forms), from concurrent programs that generate or refresh ABC assignments, or from custom PL/SQL code that needs to programmatically create ABC assignments. Because ETRM records show this package is referenced by zero other packages, it functions as a leaf-level API rather than a dependency of other PL/SQL units. Callers should always supply a valid p_abc_assignments_rec, pass fnd_api.g_true for p_init_msg_list when the calling context requires a clean message stack, and set p_commit appropriately according to transaction control requirements. Given the header revision, behavior is consistent across 12.1.1 and 12.2.2, though the implementation resides in the 12.2 file version. Debug output can be enabled by setting the INV_DEBUG_TRACE profile option, which drives the internal trace utility.