Search Results copy_item_id

Overview

INVPAGI2 is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an OTHER-type API. Its documented purpose is to support the Oracle Inventory item interface by programmatically assigning item header records during item import and related item maintenance operations. The package operates with AUTHID CURRENT_USER semantics, meaning its unqualified object references resolve against the privileges of the calling user rather than the package owner, a design characteristic common to Oracle EBS public APIs.

The package is closely associated with the MTL_SYSTEM_ITEMS_INTERFACE workflow, the staging area through which item data passes before validation and insertion into the base MTL_SYSTEM_ITEMS tables. It also carries serial-tagging logic introduced under Bug 9913552, evidenced by the global variable G_copy_item_id, which exists specifically to pass a source item identifier into the API so that serial tag assignments can be copied from one item to another.

Key Procedures and Functions

The package exposes a single documented callable: ASSIGN_ITEM_HEADER_RECS. This is a function returning an integer status code. Its parameters include the target organization identifier, an all-org indicator, program and request identifiers used for concurrent-manager context, user and login identifiers for auditing, an error text output parameter, a set identifier for item template/attribute grouping, and a default-flag indicator. The function is responsible for populating item header staging records for the supplied organization and program context, allowing downstream processing to validate and commit the item definitions.

The global variable G_copy_item_id defaults to a sentinel value and is set by callers to communicate the source item when the API is used to duplicate serial tag assignments. This variable is not a formal parameter; it is a package-level state carrier, so callers must set it explicitly before invoking the function when copy behavior is required.

Tables Accessed

Via APPS synonyms, the package touches a broad set of Inventory and related tables. MTL_SYSTEM_ITEMS_INTERFACE and its _S sequence-related synonym are the primary staging targets written during header record assignment. MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_S represent the destination base tables for validated items. MTL_ITEM_TEMPLATES supplies template definitions that drive default attribute values, while MTL_ITEM_CATALOG_GROUPS_B and MTL_ITEM_REVISIONS_INTERFACE support catalog grouping and revision staging respectively. MTL_UNITS_OF_MEASURE_TL and MTL_PARAMETERS provide unit-of-measure translations and organization-level inventory parameters.

Organizational context is derived from HR_ORGANIZATION_INFORMATION. Purchasing-related defaults may be pulled from PO_SYSTEM_PARAMETERS_ALL. Error messaging leverages FND_NEW_MESSAGES. Utility references include DBMS_SQL for dynamic SQL, DUAL for scalar queries, and PLITBLM, the standard EBS PL/SQL table-to-index-by conversion utility.

Usage Notes

INVPAGI2 is not a user-facing API. It is invoked internally by two other packages within the Oracle Inventory item import and copy infrastructure, typically through concurrent programs such as the Item Import process. The function form returning an integer status follows the standard EBS convention where zero or one indicates success and other values signal validation failure, with diagnostic detail returned through the err_text out parameter.

Custom code should invoke this package only when replicating the supported item header assignment behavior, and must respect the global variable initialization pattern before calls that involve serial tag copying. Direct manipulation of the interface tables without the accompanying program, request, and user identifiers can produce incomplete audit context and should be avoided in production customizations.